Hi,
I have checked on both Percona Server 5.6.15 and 5.6.16 versions. I’m really confused that why you can’t able to do it. check below log
On 5.6.16 :
nilnandan@Nil-Dell-XPS:~$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 38
Server version: 5.6.16-64.0-553.saucy (Ubuntu)
Copyright (c) 2009-2014 Percona LLC and/or its affiliates
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
mysql> show global variables like ‘thread_cache%’;
±------------------±------+
| Variable_name | Value |
±------------------±------+
| thread_cache_size | 8 |
±------------------±------+
1 row in set (0.00 sec)
mysql> show global status like ‘%threads_%’;
±------------------±------+
| Variable_name | Value |
±------------------±------+
| Threads_cached | 0 |
| Threads_connected | 1 |
| Threads_created | 1 |
| Threads_running | 1 |
±------------------±------+
4 rows in set (0.00 sec)
I run this on second session,
nilnandan@Nil-Dell-XPS:~$ mysqlslap -uroot -p --create-schema=test --concurrency=20 --no-drop --number-of-queries=1000 --query=“select 1”
Enter password:
Benchmark
Average number of seconds to run all queries: 0.014 seconds
Minimum number of seconds to run all queries: 0.014 seconds
Maximum number of seconds to run all queries: 0.014 seconds
Number of clients running queries: 20
Average number of queries per client: 50
nilnandan@Nil-Dell-XPS:~$
Again check status.
mysql> show global status like ‘%threads_%’;
±------------------±------+
| Variable_name | Value |
±------------------±------+
| Threads_cached | 8 |
| Threads_connected | 1 |
| Threads_created | 22 |
| Threads_running | 1 |
±------------------±------+
4 rows in set (0.00 sec)
mysql>
On 5.6.15,
nilnandan@Nil-Dell-XPS:~/sandboxes/msb_5_6_15$ mysql -umsandbox -p --socket=/tmp/mysql_sandbox5615.sock
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.15-rel63.0 Percona Server with XtraDB (GPL), Release rel63.0, Revision 519
Copyright (c) 2009-2014 Percona LLC and/or its affiliates
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
mysql>
mysql> show global variables like ‘thread_cache%’;
±------------------±------+
| Variable_name | Value |
±------------------±------+
| thread_cache_size | 9 |
±------------------±------+
1 row in set (0.01 sec)
mysql> show global status like ‘%threads_%’;
±------------------±------+
| Variable_name | Value |
±------------------±------+
| Threads_cached | 0 |
| Threads_connected | 1 |
| Threads_created | 1 |
| Threads_running | 1 |
±------------------±------+
4 rows in set (0.00 sec)
Run this on second session,
nilnandan@Nil-Dell-XPS:~/sandboxes/msb_5_6_15$ mysqlslap -umsandbox -p --socket=/tmp/mysql_sandbox5615.sock --create-schema=test --concurrency=20 --no-drop --number-of-queries=1000 --query=“select 1”
Enter password:
Benchmark
Average number of seconds to run all queries: 0.012 seconds
Minimum number of seconds to run all queries: 0.012 seconds
Maximum number of seconds to run all queries: 0.012 seconds
Number of clients running queries: 20
Average number of queries per client: 50
nilnandan@Nil-Dell-XPS:~/sandboxes/msb_5_6_15$
mysql> show global status like ‘%threads_%’;
±------------------±------+
| Variable_name | Value |
±------------------±------+
| Threads_cached | 9 |
| Threads_connected | 1 |
| Threads_created | 21 |
| Threads_running | 1 |
±------------------±------+
4 rows in set (0.00 sec)
mysql>