mysql sysbench 测试
来源:互联网 发布:自适应二值化算法 编辑:程序博客网 时间:2024/06/05 19:26
最近尝试对mariadb 10.0 进行sysbench 的OLTP 的 RW complex 测试,
测试的机器配置如下:
cpu : 80核
内存 : 64G
硬盘 : SAS RAID1
测试工具:
sysbench-0.4.12
操作系统调优:
echo deadline >/sys/block/sda/queue/scheduler
ulimit -n 10240
数据生成语句为:
./sysbench --test=oltp --oltp-table-size=20000000--mysql-host=127.0.0.1 --mysql-port=3306 --mysql-user=root--mysql-db=test --db-driver=mysql prepare
调优之后的配置文件如下:
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
skip-external-locking
skip-name-resolve
key_buffer_size = 512M
thread_cache_size = 3000
max_connections = 20480
lower_case_table_names = 1
server-id = 1
thread_handling=pool-of-threads
thread_pool_max_threads=1500
innodb_log_file_size = 4G
innodb_log_buffer_size = 256M
innodb_buffer_pool_size = 30G
innodb_buffer_pool_instances = 1
innodb_flush_log_at_trx_commit = 0
innodb_file_per_table=1
innodb_locks_unsafe_for_binlog = 1
innodb_thread_concurrency = 28
innodb_flush_method= O_DIRECT
innodb_io_capacity=600
innodb_log_block_size=2048
innodb_read_io_threads=16
innodb_write_io_threads=16
innodb_support_xa=0
innodb_change_buffering=all
innodb_checksum_algorithm=none
innodb_doublewrite = false
#innodb_adaptive_hash_index = 0
max_prepared_stmt_count=1048576
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
测试结果为:
并发 totaltime transaction
8 11.2411s 1779.19 per sec.
16 4.3096s 4641.32 per sec.
32 2.5201s 7937.14 per sec.
64 2.5204s 7936.49 per sec.
128 3.0844s 6485.61 per sec.
256 3.2569s 6141.08 per sec.
512 4.8043s 4163.54 per sec.
1024 6.8200s 2934.31 per sec.
2048 8.7394s 2289.29 per sec.
转载请注明转自高孝鑫的博客
测试的机器配置如下:
cpu : 80核
内存 : 64G
硬盘 : SAS RAID1
测试工具:
sysbench-0.4.12
操作系统调优:
echo deadline >/sys/block/sda/queue/scheduler
ulimit -n 10240
数据生成语句为:
./sysbench --test=oltp --oltp-table-size=20000000--mysql-host=127.0.0.1 --mysql-port=3306 --mysql-user=root--mysql-db=test --db-driver=mysql prepare
调优之后的配置文件如下:
[client]
port
socket
[mysqld]
port
socket
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
skip-external-locking
skip-name-resolve
key_buffer_size = 512M
thread_cache_size = 3000
max_connections = 20480
lower_case_table_names = 1
server-id
thread_handling=pool-of-threads
thread_pool_max_threads=1500
innodb_log_file_size = 4G
innodb_log_buffer_size = 256M
innodb_buffer_pool_size = 30G
innodb_buffer_pool_instances = 1
innodb_flush_log_at_trx_commit = 0
innodb_file_per_table=1
innodb_locks_unsafe_for_binlog = 1
innodb_thread_concurrency = 28
innodb_flush_method= O_DIRECT
innodb_io_capacity=600
innodb_log_block_size=2048
innodb_read_io_threads=16
innodb_write_io_threads=16
innodb_support_xa=0
innodb_change_buffering=all
innodb_checksum_algorithm=none
innodb_doublewrite = false
#innodb_adaptive_hash_index = 0
max_prepared_stmt_count=1048576
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
测试结果为:
并发
8
16
32
64
128
256
512
1024
2048
转载请注明转自高孝鑫的博客
0 0
- mysql sysbench 测试
- buildbot + bazaar + mysql的测试…
- mysql 连接测试
- mysql 注释
-  
- cmd mysql 常用命令
- 刘道成 mysql 视频教程 配套材料
-
- V4L2 usb 摄像头 测试
- V4L2 usb 摄像头 测试
- MySQL模式 : Strict Mode
- mysql 源码 安装
- 传智播客 mysql 视频
- Mysql alter procedure name
- MYSQL C API 入门教程
- MySQL Online DDL …
- MySQL server has …
- MYSQL YEAR TIME DATE
- 本地复制一张innodb表的数据
- postgre-xc 初步调研
- 如何在mysql中间件层实现客户端连…
- innodb monitor output&…
- FederatedX 下推语句调研
- mysql sysbench 测试
- MySQL 的 XA 模式下的主从复制问题
- 转:CentOS 6.4 编译安…
- 在centos/redhat6.5上编译Mariadb…
- JavaScript获取事件对象的注意点
- EBS值集定义
- MySQL分布式集群连接池低潮抖动问…
- CentOS 6.5 升级 elrepo-kernel-lt
- 转:用消息队列和消息应用状态表来…