Hello, I've been noticing a little lag in my application lately, it seems as if 1 table in 1 database is getting slower to read from. Mind you, that table is being accessed a LOT of times per second every hour of every day, and then the "application" searches on this same table too.
In my sandbox, it is fast to search (as there is no other reads/queries on that table), so i don't think it is disk i/o (but you never know right?). I've also double checked all the indexing, to insure indexes are used. What I was wondering is, are the reads/queries simultaneous, or are they sequential? would symlinking the file to another db make any difference (or is that even possible)? any insight would be appreciated, or even any ideas on what I may do to increase the performance, or even how to measure where the issue could be would help as well. Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org