Jump to content

Good performance Mysql, my.cnf


Recommended Posts

Hello,

I wanted to ask how you set up your my.cnf for a good perfomance.

Here is my.cnf:

#INNODB
innodb_buffer_pool_size = 378M
innodb_log_file_size = 64M
innodb_file_per_table=1
innodb_flush_method = O_DIRECT
#MyISAM
key_buffer_size = 64M
#OTHER
tmp_table_size = 32M
max_heap_table_size = 32M
query_cache_type = 0
query_cache_size = 00
max_connections = 500
max_connect_errors = 500
thread_cache_size = 50
table_open_cache = 800
open_files_limit = 65535
innodb_force_recovery = 0

Link to comment
Share on other sites

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

  • 6 months later...
On 2016. 07. 25. at 1:17 AM, TekkForCeAD2 said:

Hello,

I wanted to ask how you set up your my.cnf for a good perfomance.

Here is my.cnf:

#INNODB
innodb_buffer_pool_size = 378M
innodb_log_file_size = 64M
innodb_file_per_table=1
innodb_flush_method = O_DIRECT
#MyISAM
key_buffer_size = 64M
#OTHER
tmp_table_size = 32M
max_heap_table_size = 32M
query_cache_type = 0
query_cache_size = 00
max_connections = 500
max_connect_errors = 500
thread_cache_size = 50
table_open_cache = 800
open_files_limit = 65535
innodb_force_recovery = 0

My.cnf
 

Spoiler

#INNODB
innodb_buffer_pool_size = 200M
innodb_log_file_size = 100M
innodb_file_per_table=1
innodb_flush_method = O_DIRECT
#MyISAM
key_buffer_size = 75M
#OTHER
tmp_table_size = 35M
max_heap_table_size = 335M
query_cache_type = 0
query_cache_size = 00
max_connections = 500
max_connect_errors = 150
thread_cache_size = 50
table_open_cache = 800
open_files_limit = 65535
innodb_force_recovery = 0

========== NOT TESTED ==========

  • Good 1

787292068_Nvtelen.png.6faa7b0bbb3398fd29

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Announcements



  • Similar Content

  • Activity

    1. 60

      Inbuild GR2 Animation

    2. 2

      wait() function bug

    3. 0

      Remove Party Role Bonuses

    4. 1

      Fix CBar3D

    5. 2

      set_quest_state not working

    6. 1

      Fix CBar3D

  • Recently Browsing

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.