Re: MySQL 5.5 Slow performance to insert

2015-07-27 Thread Johan De Meersman
- Original Message - From: Camilo Vieira camilo.vie...@gmail.com Subject: Re: MySQL 5.5 Slow performance to insert $ ./mysqltuner.pl --user root --pass abril@123 Thank you for that password :-) I don't particularly like MySQLtuner myself, it makes assumptions about your workload

Re: MySQL 5.5 Slow performance to insert

2015-07-27 Thread Camilo Vieira
Hi Luis, I have got the output below: $ ./mysqltuner.pl --user root --pass abril@123 [OK] Logged in using credentials passed on the command line MySQLTuner 1.5.0 - Major Hayden ma...@mhtx.net Bug reports, feature requests, and downloads at http://mysqltuner.com/ Run with '--help' for

Re: MySQL 5.5 Slow performance to insert

2015-07-27 Thread shawn l.green
On 7/24/2015 4:35 PM, Camilo Vieira wrote: Hi, My MySQL server is performing very slow inserts. Does somebody could help me to understand what's happening? ... snip ... ---TRANSACTION 31D6D74, ACTIVE 27107 sec mysql tables in use 8, locked 8 7470 lock struct(s), heap size 801208, 849088 row