If you are knowledgeable about the application and know which tables are frequently accessed during the time of crash, you can send the create statements used to create those tables. Also any indexing and how many rows are in the table will also help.
In my opinion over a hundred tables for an application sound bit too high. Perhaps some of table can be collapsed to fewer tables. 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] > > -- http://chatter.mirislam.com/
