Hi,
There are lot mysql transactions with the "cleaning up" state on my Mysql
5.6.31:
TRANSACTIONS
Trx id counter 26782150
Purge done for trx's n:o < 26774181 undo n:o < 0 state: running but idle
History list length 739
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTI
Hi folks!
I have noticed the GTID thread is sunpending since I upgraded the MySQL
from 5.5 to 5.7.
I have tryed to disable GTI using :
SET @@GLOBAL.GTID_MODE = OFF;
But the problem persists...
Somebody could clarify this situation for me?
Thanks!!
Hi,
I'm receiving MySQL 5.5 deadlocks.
I enabled the innodb lock monitor using this command:
CREATE TABLE innodb_lock_monitor(a int) ENGINE=INNODB;
I got the following output:
LATEST DETECTED DEADLOCK
151007 13:58:36
*** (1) TRANSACTION:
TRANSAC
niel Lucio Quiroz <
luis.daniel.lu...@gmail.com>:
> How big is your innodb buffer in compare all innodb?
>
> Try running the mysqltuner script, it will give you useful information
> On Jul 24, 2015 4:40 PM, "Camilo Vieira" wrote:
>
>> Hi,
>>
>> My MySQ
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
Hi,
I have two servers Mysql 5.5 with master to master replication.
The second server failed and I needed to remove it to repair the operating
system.
After this incident the application users have been notice that the
application response have been very slow.
Both servers have RAID 1 (mirroring)
