query problem

2004-06-30 Thread auslander
using mysql 4.0.x please review the following sql then see below for the problem: DROP TABLE IF EXISTS inbound_fax_info; CREATE TABLE inbound_fax_info ( fax_id int(10) unsigned NOT NULL auto_increment, barcode varchar(100) default '', document_id int(10) unsigned default NULL, department_id int

Re: query problem

2004-06-30 Thread auslander
tabase Administrator Unimin Corporation - Spruce Pine auslander <[EMAIL PROTECTED]To: [EMAIL PROTECTED]

Re: Minitoring mysqld process activities

2004-06-30 Thread auslander
You could also use 'show full processlist;' at the mysql prompt. even better is an app called mytop whis looks/acts like top but is specifically used for mysql. Victor Pendleton wrote: Have you checked the slow query log and the error log? you could also che -Original Message- From: Moha