We have a MySQL database where every second couple of tens of kilobytes to a couple hundred kilobytes of data is inserted into the database. Note here that largest chunk of the data is consisted of a Blob. This data (including the blob) is continuously queried by an application which displays it in a graphical format(waveform).
When the database size get to a few days i.e. about 10GB the performance slows down dramatically and InnoDB starts giving 995 error code on Windows2000 machine with 2GHz P4, 1GB RAM. Size of each individual datafile is 3GB. We donot have any complex database design and the SELECT queries are only on individual tables without any joins. We had the database implemented using MyISAM but we switched to InnoDB and saw a huge performance decrease.... This in terms of minutes when the database size is a few GBs and a couple of data files !! What performance optimizations could be done to make the database more responsive and perform faster. Thanks, Chirag ________________________________________________________________ Sent via the WebMail system at mail.atcsoftware.us -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]