Percona Server

MySQL & MariaDB Other MySQL® Questions
1

Hi, I am running Server version: 5.5.22-55-log Percona Server (GPL), Release rel25.2, Revision 237

I am getting below errors from “SHOW ENGINE INNODB STATUS”:

OS WAIT ARRAY INFO: reservation count 248796, signal count 10462982
–Thread 1218939200 has waited at btr0sea.c line 1508 for 0.0000 seconds the semaphore:
S-lock on RW-latch at 0x29ea4b18 ‘btr_search_latch_part[i]’
number of readers 0, waiters flag 0, lock_word: 100000
Last time read locked in file btr0sea.c line 918
Last time write locked in file /home/jenkins/workspace/percona-server-5.5-rpms/label_exp/ce ntos5-64/target/BUILD/Percona-Server-5.5.22-rel25.2/Percona- Server-5.5.22-rel25.2/storage/innobase/btr/btr0sea.c line 669

INNODB STATUS file attached.

Looking forward for your suggestion.

Thanks!

Vineet

2

Anyone can update on that its a Application issue or bug of Percona Server.

3

Hi,

Are you using adaptive hash partitions? If yes then it might be this problem [URL]https://bugs.launchpad.net/percona-server/+bug/791030[/URL] . If you are not using partitions then might be you have too much concurrency and should try to limit it to 8 with innodb_thread_concurrency. Can you provide the details of my.cnf? output of “show global variables” and “show global status” would be helpful too.