mysql并发插入慢求解

2012-07-23 11:21:39 451 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Mid-360激光雷达与Fast-LIO2实战：从环境搭建到实时点云建图本文提供Livox Mid-360激光雷达与Fast-LIO2算法从零开始的实战教程。详细介绍了在Ubuntu和ROS环境下进行系统配置、依赖安装、硬件连接与网络设置的完整流程，并指导如何运行算法实现实时点云建图与可视化，最后总结了关键参数调优与常见问题排查方法。阅读详情

我公司的系统现每秒插入量是400条记录那样，是多线程的并发插入同一张表，此表是用作日志用的。现在插入要10秒钟那样，非常慢。是linux的服务器，求高手帮忙解决。谢谢！
我的设置是这样的：

[mysqld]
event_scheduler = on
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

default-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 risks

lower_case_table_names=1

symbolic-links=0

[mysqld_safe]
open-files-limit=10240
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

...全文