我公司的系统现每秒插入量是400条记录那样,是多线程的并发插入同一张表,此表是用作日志用的。现在插入要10秒钟那样,非常慢。是linux的服务器,求高手帮忙解决。谢谢!
我的设置是这样的:
[mysqld]
event_scheduler = on
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sockdefault-character-set=utf8
user=mysql
skip-locking
skip-name-resolve
back_log=512
max_allowed_packet=4M
#thread_stack=256k
table_cache=128K
join_buffer_size=8M
myisam_sort_buffer_size=64M
query_cache_size=64M
tmp_table_size=256M
max_connections=2000
max_connect_errors=10000000
wait_timeout=1800
thread_concurrency=8
innodb_additional_mem_pool_size=4M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=2M
#innodb_log_file_size=64M   
#innodb_log_files_in_group=2
innodb_thread_concurrency=8
memlock
innodb_buffer_pool_size=1024M
key_buffer_size=256M
read_buffer_size=4M
read_rnd_buffer_size=16M
sort_buffer_size=32M
thread_cache_size=120
# Disabling symbolic-links is recommended to prevent assorted security riskslower_case_table_names=1symbolic-links=0[mysqld_safe]
open-files-limit=10240
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid