I have a Windows program that will execute simple 1 table queries that use
an index and sort, and with a limit of 20 rows.
When I start the program for the first time, the queries run quite fast at
around 1200 queries/second. Then within a couple of seconds it drops
immediately down to 20-40 queries/second, sometimes even less than that.
Over the next 20 minutes or so it will gradually move back up to 300
queries/sec and then move to 800 etc. probably because it is now finding
the results in the cache.
I'd like to know what can I do to prevent it from dropping to 20
queries/second a few seconds after it starts up. I'm using MySQL 5.0.24 and
MyISAM tables. 20-40 queries per second is extremely slow and something has
to be wrong somewhere. The program is running on the same machine as MySQL
and is a dedicated machine (no one else is using the database). How can I
speed things up? TIA
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]