Re: MYsql getting crash
Rick James,
It works like a charm :) Now my server is running without any issues. Thank you very much for your help on resolving this issue.
*****You are running 5.0.27 (or is it 5.0.22 ?), so you are still restricted to *****4GB. "As of MySQL 5.0.52...". Thanks for pointing that out; I had not *****noticed. OTOH, "key_buffer_size=12884901888" -- maybe you do really have *****12GB??
My database size is around 280GB and many MyISAM tables have around 300 million rows and it will grow. The total MyISAM indexes size for my database is around 144 GB. And also my server m/c has 32 GB of RAM, so I would like to maximize the utilization of RAM. That's why I tried to increase it to 12GB. Is it make sense to increase key_buffer_size to 12 GB in mysql 5.1.40 ?
Thanks,
Ramesh
Edited 3 time(s). Last edit at 10/28/2009 03:35AM by Ramesh Kumar.
Subject
Written By
Posted
Re: MYsql getting crash
October 28, 2009 03:16AM
November 06, 2009 02:33AM
November 06, 2009 10:28AM
December 06, 2009 07:51AM
December 30, 2009 11:42PM
December 31, 2009 03:06AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.