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
Alex
On 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
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]