On Mon, Sep 3, 2012 at 11:32 AM, Raphael Bauduin wrote:
> Hi,
>
> In the output of
> SHOW ENGINE INNODB STATUS \G
>
> I have several old active transactions, each having locked some rows.
> All or from the same process id, but with different thread ids. This
> is the
Hi,
In the output of
SHOW ENGINE INNODB STATUS \G
I have several old active transactions, each having locked some rows.
All or from the same process id, but with different thread ids. This
is the oldest one, which is 2.5 days old:
---TRANSACTION 0 1532609805, ACTIVE 227995 sec, process no 2951
tly. I'll try disabling the query
cache and report back.
>
>> -Original Message-
>> From: raphi...@gmail.com [mailto:raphi...@gmail.com] On Behalf Of
>> Raphael Bauduin
>> Sent: Wednesday, August 29, 2012 2:16 AM
>> To: Rick James
>> Cc: mysql@lis
reasonable max.
Thanks for your feedback. These question were going to be the topic of
my next mail to the list, but you anticipated correctly :-)
Raph
>
>> -Original Message-
>> From: raphi...@gmail.com [mailto:raphi...@gmail.com] On Behalf Of
>> Raphael Bauduin
>&
Hi,
I have a mysql server running with the query cache size being 128M
(134217728 bytes).
Here are the qcache variables values:
| Qcache_free_blocks| 13758|
| Qcache_free_memory| 46945512 |
| Qcache_hits | 56418967 |
| Qcache_