I would suggest looking at the slow query log first and figure out what queries were taking long when the crash occurs at heavy concurrent usage, and then try to optimize those queries, it might a world of difference, also since you have only 1GB ram , try decreasing the sort_buffer_size, read_buffer_size to like 500K instead of the default 2M........
Kishore Jalleda On 1/4/06, Jonathan Chong <[EMAIL PROTECTED]> wrote: > Hi Alex > > There are over a hundred tables for the site, and those that are > related to this query are probably about 15-30. Do you want the CREATE > TABLE syntax for all of them? > > Funnily enough, the file /var/log/mysql_error.log doesn't exist .. > > I'm using myISAM tables, yes. > > > On 04/01/06, Alex <[EMAIL PROTECTED]> wrote: > > the table type whether it is myisam or innodb. create table statements are > > preferred when you have slow query issues. > > > > --Alex > > > > > > On Wed, 04 Jan 2006 15:57:06 +0530, Jonathan Chong <[EMAIL PROTECTED]> > > wrote: > > > > > Sorry > > > > > > I also forgot to ask - when you say the tables, did you want the table > > > structure? There are quite a few tables, perhaps I should just send > > > the tables that are read and written to often when a user hits a page? > > > > > > > > > > > > On 04/01/06, Alex <[EMAIL PROTECTED]> wrote: > > >> Hi, > > >> > > >> Please provide details like what tables are you using, the entire > > >> my.cnf > > >> and the information from the mysqld.err when the crashes occurred. > > >> > > >> > > >> --Alex > > > > > > -- > > > Jonathan Chong > > > > > > http://www.arsenal-now.com/ > > > http://www.arsenal-mania.com/ > > > http://www.ashburrn.com/ > > > http://www.jonathan-chong.com/ > > > > > > > > > > > > > > > -- > Jonathan Chong > > http://www.arsenal-now.com/ > http://www.arsenal-mania.com/ > http://www.ashburrn.com/ > http://www.jonathan-chong.com/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
