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 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: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 500003 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED]
