MySQL Speed Getting Slower

2008-09-24 Thread sangprabv
Hi, My MySQL server's data is increasing for about 1 million new records per day. And it's now become slower when processing data. Is there any way to speed up? TIA. Regards, Willy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: MySQL Speed Getting Slower

2008-09-24 Thread Krishna Chandra Prajapati
If you are using innodb. Then increase innodb_buffer_pool_size. If myisam then increse key_buffer_size. Please send status of mysql server and OS details On Wed, Sep 24, 2008 at 12:39 PM, sangprabv [EMAIL PROTECTED] wrote: Hi, My MySQL server's data is increasing for about 1 million new