From: DeskNow Knowledge Base
http://www.desknow.com/kb/

Performance tuning for MySQL database
http://www.desknow.com/kb/idx/12/116/article/

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.