enterprise-support team mailing list archive
-
enterprise-support team
-
Mailing list archive
-
Message #03201
[Bug 1087205] Re: Percona Server does not do background log flushing during the period when there is no user activity
Could not able to reproduced with 5.6
root@Nil-Dell-XPS:/home/nilnandan/bzr/sysbench/sysbench# mysql -uroot -p -e "select version()"
Enter password:
+-----------------------+
| version() |
+-----------------------+
| 5.6.16-64.0-553.saucy |
+-----------------------+
root@Nil-Dell-XPS:/home/nilnandan/bzr/sysbench/sysbench#
root@Nil-Dell-XPS:/home/nilnandan/bzr/sysbench/sysbench# ./sysbench --test=./tests/db/oltp.lua --oltp-tables-count=8 --oltp-table-size=800000 --mysql-table-engine=innodb --mysql-db=test prepare
sysbench 0.5: multi-threaded system evaluation benchmark
Creating table 'sbtest1'...
Inserting 800000 records into 'sbtest1'
Creating table 'sbtest2'...
Inserting 800000 records into 'sbtest2'
Creating table 'sbtest3'...
Inserting 800000 records into 'sbtest3'
Creating table 'sbtest4'...
Inserting 800000 records into 'sbtest4'
Creating table 'sbtest5'...
Inserting 800000 records into 'sbtest5'
Creating table 'sbtest6'...
Inserting 800000 records into 'sbtest6'
Creating table 'sbtest7'...
Inserting 800000 records into 'sbtest7'
Creating table 'sbtest8'...
Inserting 800000 records into 'sbtest8'
root@Nil-Dell-XPS:/home/nilnandan/bzr/sysbench/sysbench#
root@Nil-Dell-XPS:/home/nilnandan/bzr/sysbench/sysbench# for t in $(seq 1 8); do mysql -uroot -proot -A test -e "select * from sbtest${t}" > /dev/null; done
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
root@Nil-Dell-XPS:/home/nilnandan/bzr/sysbench/sysbench#
root@Nil-Dell-XPS:/home/nilnandan/bzr/sysbench/sysbench#
root@Nil-Dell-XPS:/home/nilnandan/bzr/sysbench/sysbench#
root@Nil-Dell-XPS:/home/nilnandan/bzr/sysbench/sysbench# ./sysbench --test=./tests/db/oltp.lua --oltp-tables-count=8 --oltp-table-size=800000 --mysql-table-engine=innodb --mysql-db=test --max-time=930 --num-threads=8 --max-requests=0 --report-interval=1 run
sysbench 0.5: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 8
Report intermediate results every 1 second(s)
Random number generator seed is 0 and will be ignored
Threads started!
[ 1s] threads: 8, tps: 1859.66, reads/s: 26113.30, writes/s: 7440.64, response time: 6.02ms (95%)
[ 2s] threads: 8, tps: 1993.81, reads/s: 27909.38, writes/s: 7978.25, response time: 6.54ms (95%)
[ 3s] threads: 8, tps: 1706.56, reads/s: 23908.81, writes/s: 6824.23, response time: 8.59ms (95%)
[ 4s] threads: 8, tps: 1801.59, reads/s: 25209.24, writes/s: 7204.35, response time: 8.34ms (95%)
[ 5s] threads: 8, tps: 2078.19, reads/s: 29117.71, writes/s: 8314.78, response time: 6.63ms (95%)
[ 6s] threads: 8, tps: 2120.67, reads/s: 29683.35, writes/s: 8484.67, response time: 6.54ms (95%)
...
[ 926s] threads: 8, tps: 1581.00, reads/s: 22151.05, writes/s: 6324.01, response time: 10.62ms (95%)
[ 927s] threads: 8, tps: 1625.00, reads/s: 22715.01, writes/s: 6496.00, response time: 7.76ms (95%)
[ 928s] threads: 8, tps: 1557.00, reads/s: 21805.97, writes/s: 6227.99, response time: 10.40ms (95%)
[ 929s] threads: 8, tps: 1605.00, reads/s: 22497.01, writes/s: 6422.00, response time: 10.00ms (95%)
[ 930s] threads: 8, tps: 1637.00, reads/s: 22912.94, writes/s: 6555.98, response time: 10.45ms (95%)
OLTP test statistics:
queries performed:
read: 23010582
write: 6574452
other: 3287226
total: 32872260
transactions: 1643613 (1767.32 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 29585034 (31811.75 per sec.)
other operations: 3287226 (3534.64 per sec.)
General statistics:
total time: 930.0033s
total number of events: 1643613
total time taken by event execution: 7436.3993s
response time:
min: 1.67ms
avg: 4.52ms
max: 148.56ms
approx. 95 percentile: 7.63ms
Threads fairness:
events (avg/stddev): 205451.6250/1657.65
execution time (avg/stddev): 929.5499/0.01
root@Nil-Dell-XPS:/home/nilnandan/bzr/sysbench/sysbench#
root@Nil-Dell-XPS:/home/nilnandan/bzr/sysbench/sysbench# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 19
Server version: 5.6.16-64.0-553.saucy (Ubuntu)
...
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
mysql> show status like 'innodb_buffer_pool_pages%';
+-----------------------------------------+--------+
| Variable_name | Value |
+-----------------------------------------+--------+
| Innodb_buffer_pool_pages_data | 96660 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 391255 |
| Innodb_buffer_pool_pages_LRU_flushed | 0 |
| Innodb_buffer_pool_pages_free | 29772 |
| Innodb_buffer_pool_pages_made_not_young | 0 |
| Innodb_buffer_pool_pages_made_young | 34 |
| Innodb_buffer_pool_pages_misc | 4632 |
| Innodb_buffer_pool_pages_old | 35518 |
| Innodb_buffer_pool_pages_total | 131064 |
+-----------------------------------------+--------+
10 rows in set (0.00 sec)
mysql>
mysql> show engine innodb status \G
*************************** 1. row ***************************
Type: InnoDB
Name:
Status:
=====================================
2014-03-13 15:44:06 7f39996f2700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 46 seconds
...
---
LOG
---
Log sequence number 3832294775
Log flushed up to 3832294775
Pages flushed up to 3832294775
Last checkpoint at 3832294775
Max checkpoint age 848635454
Checkpoint age target 822115597
Modified age 0
Checkpoint age 0
0 pending log writes, 0 pending chkp writes
4774 log i/o's done, 1.15 log i/o's/second
----------------------
** Changed in: percona-server/5.6
Status: New => Invalid
--
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1087205
Title:
Percona Server does not do background log flushing during the period
when there is no user activity
To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1087205/+subscriptions
