thread_pool_size=1 causes mysqld hang
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.1 |
Invalid
|
Undecided
|
Unassigned | |||
5.5 |
Triaged
|
Medium
|
Unassigned | |||
5.6 |
Triaged
|
Medium
|
Unassigned | |||
5.7 |
Triaged
|
Medium
|
Unassigned |
Bug Description
**************** RQG start up command
if [ -r /usr/lib64/
elif [ -r /usr/lib/
elif [ -r /ssd/ramesh/
else echo 'Error: jemalloc not found, please install it first'; exit 1; fi
ps -ef | grep 'rundir1_3' | grep -v grep | awk '{print $2}' | xargs sudo kill -9 > /dev/null 2>&1
rm -Rf /ssd/ramesh/
rm -Rf /ssd/ramesh/
mkdir /ssd/ramesh/
mkdir /ssd/ramesh/
cd /ssd/ramesh/randgen
bash -c "set -o pipefail; perl /ssd/ramesh/
tail -n1 /ssd/ramesh/
***************** PS version
[ramesh@qaserver-01 582358]$ /ssd/ramesh/
/ssd/ramesh/
[ramesh@qaserver-01 582358]$
***************** Thread pool variable, status and processlist info
mysql> show variables like '%thread_pool%';
+------
| Variable_name | Value |
+------
| thread_
| thread_
| thread_
| thread_
| thread_
| thread_pool_size | 1 |
| thread_
+------
7 rows in set (0.00 sec)
mysql>
mysql> show processlist;
+----+-
| Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | Rows_read |
+----+-
| 1 | root | 127.0.0.1:42280 | test | Sleep | 1715 | | NULL | 0 | 0 | 0 |
| 9 | root | 127.0.0.1:42307 | test | Sleep | 1471 | | NULL | 502 | 502 | 502 |
| 10 | root | 127.0.0.1:42308 | test | Query | 1475 | Waiting for global read lock | DROP TABLE IF EXISTS y | 0 | 0 | 0 |
| 11 | root | 127.0.0.1:42309 | test | Query | 1475 | Waiting for global read lock | REPLACE INTO `table500_
| 12 | root | 127.0.0.1:42310 | test | Query | 1475 | Waiting for global read lock | UPDATE `table100_
| 13 | root | 127.0.0.1:42311 | test | Query | 1476 | Waiting for global read lock | DROP TABLE IF EXISTS k | 0 | 0 | 0 |
| 27 | unauthenticated user | connecting host | NULL | Connect | NULL | login | NULL | 0 | 0 | 0 |
| 28 | unauthenticated user | connecting host | NULL | Connect | NULL | login | NULL | 0 | 0 | 0 |
| 30 | root | 127.0.0.1:33950 | NULL | Query | 0 | NULL | show processlist | 0 | 0 | 0 |
+----+-
9 rows in set (0.00 sec)
mysql>
mysql> show global status like '%threadpool%';
+------
| Variable_name | Value |
+------
| Threadpool_
| Threadpool_threads | 13 |
+------
2 rows in set (0.00 sec)
mysql>
GDB, mysqld and ldd files