Hey,
As per you config in my.cnf there has to be two logs> log_error = /var/log/mysql_error.log > log-slow-queries = /var/log/mysql_slow_queries.log
We have to have that info in error log to hunt down the issue. Also if possible obtain the messages from /var/log/messages (these are kernel messages) when the crash occurred. Without the error info from the mysql_error.log we cant do much.
Thanx AlexOn Wed, 04 Jan 2006 19:00:16 +0530, 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 arepreferred 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]
