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 lo
- Original Message -
> From: "Camilo Vieira"
> 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 workl
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
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional
Hi,
Your INSEERquery status is "Copying to tmp table",
this means fetching rows which has to be inserted is slow.
You should tune SELECT statement in your insert query.
Adding indexes and/or simplifying query and/or .. so on.
```
---TRANSACTION 31D6D74, ACTIVE 27107 sec
mysql tables in use 8, l
Hi,
My MySQL server is performing very slow inserts. Does somebody could help
me to understand what's happening?
mysql> show engine innodb status \G
*** 1. row ***
Type: InnoDB
Name:
Status:
=
150724 17:40:28
