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]