新配了台8核32G内存机器做数据服务器,不知道网管怎么搞的,装的32位系统。
简单改了下配置
[mysqld]
skip-locking
skip-name-resolve key_buffer_size = 10240M max_allowed_packet = 16M table_open_cache = 1024 sort_buffer_size = 128M net_buffer_length = 128M read_buffer_size = 128M read_rnd_buffer_size = 64M myisam_sort_buffer_size = 256M thread_cache_size = 32 query_cache_size = 1024M thread_concurrency = 12 max_connections = 2048 wait_timeout = 30