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]
