I have MySQL 5 installed on a Windows Server 2003 x64 box which is part of a small network. It is running much more slowly than I would like, so I want to optimize any settings that would affect speed of both processing and communication.
When network clients (using Access front-end, myODBC driver) query the MySQL server for a recordset, or if I export a table from Access via ODBC to a MySQL catalog, network bandwidth utilization maxes at 0.5%-1.0% of 1gbps. How can I improve this?
Queries of all sorts (passed-through directly against MySQL) simply run more slowly (by about 200-400%) than if I use MS Access alone. What configuration settings should I use, given my setup below, to maximize usage of resources?
The tables are all presently myISAM. I've done substantial index optimization. The database server has 2 AMD Opterons, 3.5GB RAM, 4x15Krpm RAID/0. Nothing but the OS and MySQL is running on this machine -- it is a dedicated database server, and I want it to perform as such.