Jump to content
  • 0

[Help] My.ini MySQL 5.5


Question

Posted

I need set my.ini for 1000+ Online. Can anyone help me about it? How cofirm the best for Server. My Server Xeon Quad Core (8 Chip, Ram 16G).

max_connections=600
query_cache_size=0
table_cache=122
tmp_table_size=256M
thread_cache_size=200
innodb_additional_mem_pool_size=8M
innodb_flush_log_at_trx_commit=2
innodb_log_buffer_size=16M
innodb_buffer_pool_size=1024M
innodb_log_file_size=512M
innodb_thread_concurrency=24
memlock
innodb_file_per_table

4 answers to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...