Re: very slow inserts on InnoDB

log. The system faces from time to time heavy loads of up to 1000 requests/second. Catalin [EMAIL PROTECTED] wrote: news <[EMAIL PROTECTED]> wrote on 07/25/2005 10:41:46 AM: Hi, I have the following table : CREATE TABLE `raw_outgoing_sms` ( `id` bigint(20) NO

very slow inserts on InnoDB

going_gsm_op` (`id_gsm_operator`), KEY `idx_outgoing_shortcode` (`id_shortcode`) ) ENGINE=InnoDB When i insert data into it it takes around 11 seconds. Why ? Thanks, Catalin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: plz help

Use the LIMIT clause in mysql instead of TOP clause for access and mssql. Luck ! - Original Message - From: "Wajih-ur-Rehman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 22, 2003 12:22 PM Subject: plz help > I have this statement that works perfectly fine in Acc

replication and transaction problem

o, actually, on the slave machine it's like there are no transactions at all. Am I wrong somewhere? Please give me some advice, Thank you -- Sincerely Catalin Grigoroscuta Junior Programmer One5 Development SRL Str Intrarea Glucozei No 37-39, sector 2, Bucharest, Romania Phone: +40 1-

MYSQL - JAVA driver

hi 2 all! does anybody knows an good ODBC like mysql driver for an java application on an win2k proffessiona OS? thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mys

MySQL: Unable to save result set

and when we've run the scripts on other server all os OK. So we believe this errors are caused by a sever problem. Can you tell me what kind of problems might be? Catalin Tenita - Before posting, please check:

Server overload problems

ading it with mysql processes. The machine is a dual 933's with 2 gig of ram and scsi drives, acting as shared-hosting server. Best Regards, Catalin Tenita - Before posting, please check: http://www.mysql.com/manual.