DeskNow Knowledge Base
Home Installation and initial setup Performance tuning for MySQL database

Performance tuning for MySQL database

By default MySQL is installed with very conservative settings, and will run with no probems in most systems. A simple configuration change, however, will dramatically increase its speed in most cases.

Using the MySQL Admin tool (normally installed by default), in the section 'Startup variables/InnoDB parameters' increase the 'Buffer Pool Size' value. This is the amount of RAM dedicated to MySQL. Choose a value that is lower than the free physical memory available on the system when all the other applications (including DeskNow) are running. You can use the Task Manager (press Ctrl-Shift-Esc) to find out how much physical (not virtual) memory is currently available.

Leave a reasonable margin to avoid exceeding the amount of physical memory available and forcing disk swapping.

Example: on a server with 1GB of RAM, where DeskNow is configured to use no more than 256 Mb and little else is running, you could try setting the 'Buffer Pool Size' to 400 Mb or similar. This would leave plenty of space for other applications, but would considerably speedup MySQL.

Remember to restart MySQL after changing these settings.

Email Article Email
Print Article Print

How helpful was this article to you?
Related Articles
article Performance tuning for PostgreSQL database (Linux)
Note: this page is for tuning PostgreSQL on...

  October 27, 2004    Views: 110128   
article Performance tuning for the embedded PostgreSQL database (Windows)
PostgreSQL can be a very fast database, but its...

  August 11, 2006    Views: 30701   
article Performance tuning
This article provides a few tip and strategies...

  February 2, 2007    Views: 24198   

Powered by Lore :: (c)2003 Pineapple Technologies.