Explain this mysql settings to me
$10-30 USD
Paid on delivery
Hi,
I need you to explain each of this setting in [login to view URL] file, and how they work together..
big-tables
max_allowed_packet = 16M
key_buffer_size=1G
query_cache_size = 1G
table_cache = 1024
max_heap_table_size=5368709120
long_query_time=2
max_seeks_for_key=100
max_connections = 2048
set-variable = key_buffer=4G
set-variable = sort_buffer=256K
set-variable = myisam_sort_buffer_size=256K
local-infile=0
open_files_limit=102400
innodb_file_per_table=1
innodb_flush_log_at_trx_commit = 0
innodb_buffer_pool_size = 3G
innodb_additional_mem_pool_size = 1G
innodb_log_buffer_size = 512M
innodb_max_dirty_pages_pct = 90
innodb_thread_concurrency = 4
innodb_commit_concurrency = 4
innodb_flush_method = O_DIRECT
innodb_log_file_size = 1G
I will need doc file with all this explained so I can understand why I should use this settings on my server.
Project ID: #8908601
About the project
Awarded to:
Hello, I am linux system engineer working with web hosting company from past two years and having knowledge of maintaining linux servers, security issue, software installation, server installation, DNS configuration More
10 freelancers are bidding on average $27 for this job
Hello buddy, I am java developer and having experience of mysql since I developing projects. I am familiar with this file, but as per your requirement I would like to take a day for making word file. Message me an More
Hello, I'm an expert in web server and database administration with over 6 years experience. I can provide documentation on the settings options stated in the project description. Please contact me so that I can get More
I have many experience using MySQL to build and design database for more than 5 years, and I can provide you the explanation of your configuration
I can do that task for you which will meet your requirements I placed minimum budget just because to create long term link/relationship so that you feel comfortable working with me. I have a team with multiple skills. More