Bug #61818 debian 6 64 bit + mysql 5.1.57 insert innodb very very slow

• Submitted: 11 Jul 2011 8:22
• Modified: 11 Jul 2011 9:03
• Reporter: florian trincal
• Status: Closed
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.1.57
• OS: Linux (debian 6 64 bit)
• CPU Architecture: Any
• Tags: innodb slow

[11 Jul 2011 8:22] florian trincal

Description:
hi,

I have a production mysql server on debian 6 64 bit with mysql 5.1.57 package.

All is ok except an massive insert on innodb table, insert is very very slow but the import file has only 8000 queries.

on another mysql server on debian 6 32 bit insert take 50s and on this server it take 6 minutes.

can you give me a solution please !!!

How to repeat:
insert a file with 8000 lines in innodb table

[11 Jul 2011 8:30] MySQL Verification Team

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

Hint:  Does this it work better after this?

SET GLOBAL innodb_flush_log_at_trx_commit=0;

[11 Jul 2011 8:50] florian trincal

hello,

excuse me but i use mysql community server in production, i don't use mysql entreprise version.

sincerly

[11 Jul 2011 9:03] florian trincal

Hi,
It's work with the parameter in last comment
Thank you very much for your help. this is a great support
Sincerly