stack explanation ?

_Z16dispatch_command19enum_server_commandP3THDPcj + 1069 0x8102eb8 _Z10do_commandP3THD + 100 0x810280d handle_one_connection + 841 0xc59e51 (?) 0x50e06a (?) this is a Mysql 4.0.18 on a dedicated linux Red Hat Enterprise Linux ES release 3 ( kernel 2.4.21-20 ) with 3 Gig RAM could you tell me what happened please? -- Dilipan

recontruct database from NORMAL logs : how ?

? Is there any script that will enable me to get the queries concerning only one database from the General query log? Any comment is welcome. thanks in advance, -- Dilipan Sebastiampillai Systems - DBA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: CPU 100% + crashes ...

Dilipan Sebastiampillai wrote: can you please post the complete .err log that also contains information about the crashes. If there are stack traces, please resolve them

Re: CPU 100% + crashes ...

://www.innodb.com/order.php - Original Message - From: Dilipan Sebastiampillai [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Thursday, December 15, 2005 2:04 PM Subject: CPU 100% + crashes ... Hi all, We have a MySQL server used for a queueing system. It worked fine so far

CPU 100% + crashes ...

deletes/s, 111256000.00 reads/s END OF INNODB MONITOR OUTPUT -- Dilipan Sebastiampillai Systems - DBA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

automated DELETEs or/and UPDATES ?

Hi all, from time to time I have a huge number of DELETEs or/and UPDATES processed by MySQL at noon and 8pm. The trouble is that I didn't send those queries to MySQL ! i don't have any crons running. Is this an automated MySQL procedure ? Is there any automated procedure within MySQL? thanks

updates after restart MySQL 4.0.18

]# Thanks in advance. -- Dilipan Sebastiampillai London -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 4.0.18 - 4.1.7 LEFT JOIN problem

Hi! On Nov 22, Dilipan Sebastiampillai wrote: I moved a db from 4.0.18 to 4.1.7 and I realise that the SAME sql query using LEFT JOIN gives me different result. The result from 4.0.18 does s real LEFT JOIN but 4.1.7 differs sometimes and I don't want that. I think it comes from

4.0.18 - 4.1.7 LEFT JOIN problem

I moved a db from 4.0.18 to 4.1.7 and I realise that the SAME sql query using LEFT JOIN gives me different result. The result from 4.0.18 does s real LEFT JOIN but 4.1.7 differs sometimes and I don't want that. I think it comes from an 'optimization' how can I make a query without using

phpMyAdmin don't show table size

Hello, after restoring from a mysqldump I use phpMyAdmin to view my database but the size field is unknown ... how could I get a size display ? -- Dilipan Sebastiampillai -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com