- Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688
-->-----Original Message----- -->From: joffrey leevy [mailto:[EMAIL PROTECTED] -->Sent: Wednesday, November 12, 2003 9:58 AM -->To: [EMAIL PROTECTED] -->Subject: newbie question on data accumulation --> -->Hi all --> -->Curious as to what happens after data is repeatedly -->selected from a mysql table overtime. If the data is not fragmented from constant deletes, it will continue to stay at a constant fast rate. The table is put into a table cache to reduce the amount of opens, the data is stored in shared memory in a key buffer, thus the speed of mysql. If your table does not change, and the query is the same turn on the query cache, you'll see a 256 times speed increase. Does it -->accumulate as junk data, stored at some location and -->eventually slow down the database/program/server? The queries do eventually slow down if there are a lot of deletes that fragments your table. This can be repaired with an optimize table. -->Does any purging have to take place? Don't know what you mean with this question. --> --> -->Thanks -->J --> --> -->__________________________________ -->Do you Yahoo!? -->Protect your identity with Yahoo! Mail AddressGuard -->http://antispam.yahoo.com/whatsnewfree --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
