best mysql config for my vps

Question

what best config for my.cnf file i have big size sql

Total processors: 4
Processor #1
Vendor
GenuineIntel
Name
Intel(R) Core(TM) i7-3930K CPU @ 3.20GHz
Speed
3200.058 MHz
Cache
12288 KB
Memory Information
Memory: 14243308k/15728640k available

I'm voting to close this question as off-topic because there are too many variables not known to offer specific advice. — ceejayoz, Jun 23 '15 at 16:16
There's a whole category of questions at http://stackoverflow.com/questions/tagged/mysqltuner - please run `mysqltuner` first — Josip Rodin, Jun 25 '15 at 15:07

score 0 · Answer 1 · answered Jun 23 '15 at 08:30

There is no straight forward answer of this question as one configuration can be suitable for one but not for other..

If you are using innodb engine then You can start with below configuration initially and can optimize as per your requirement/problems-

default_storage_engine = InnoDB
innodb_file_per_table
lower_case_table_names = 1
wait_timeout = 120
innodb_buffer_pool_size = 10G
key_buffer_size = 20M
max_allowed_packet = 64M
max_connections = 100
query_cache_type = 1
query_cache_size = 20M
query_cache_limit = 2M
read_buffer_size = 2M
sort_buffer_size = 2M
join_buffer_size = 2M
tmp_table_size = 512M
max_heap_table_size = 512M

score -1 · Answer 2 · answered Jun 23 '15 at 16:13

for the mysql optimization, I will suggest you please try with MySQL tuner script. You can try it with the following command

wget https://launchpad.net/mysql-tuning-primer/trunk/1.6-r1/+download/tuning-primer.sh

chmod 755 tuning-primer.sh

./tuning-primer.sh

best mysql config for my vps

2 Answers2