ExtraDRM : Design Resource Management

Wampserver performance and tuning Parameters (mysql and phpmyadmin)

Published · Updated

In php.ini, this is the one:

upload_max_filesize

However, change only this line won’t help you to restore big db, so you have to setup some other factors as well

Try these different settings in C:\wamp\bin\apache\apache2.2.6\bin\php.ini

Find:
post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M

Change to:
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M

And add this to C:\wamp\bin\mysql\mysql5.0.45\my.ini:

max_allowed_packet = 200M

Then restart wamp

Have fun,

Post Views: 13,197

Tags:

extradrmtech

Since 30 years I work on Database Architecture and data migration protocols. I am also a consultant in Web content management solutions and medias protecting solutions. I am experienced web-developer with over 10 years developing PHP/MySQL, C#, VB.Net applications ranging from simple web sites to extensive web-based business applications. Besides my work, I like to work freelance only on some wordpress projects because it is relaxing and delightful CMS for me. When not working, I like to dance salsa and swing and to have fun with my little family.

You may also like...