bechir
New Pleskian
i have problem with increasing innodb_buffer_pool_size , i have a huge database 5G , and now my website become very slow
what can i do to have the best performance ? ,
when i increase innodb_buffer_pool_size parameter, mysql service won't start.
this is my.ini file :
[MySQLD]
port=3306
basedir=C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL51\
datadir=C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL\Data
character-set-server=latin1
default-storage-engine=INNODB
innodb_additional_mem_pool_size=1524M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=512M
innodb_buffer_pool_size=1360M
innodb_log_file_size=100M
innodb_thread_concurrency=8
#innodb_buffer_pool_instances=16
#innodb_buffer_pool_chunk_size=512M
query_cache_size = 88M
federated
key_buffer_size = 384M
max_allowed_packet = 8M
skip-external-locking
table_open_cache = 512M
sort_buffer_size = 512M
read_buffer_size = 512M
read_rnd_buffer_size = 256M
myisam_sort_buffer_size = 512M
thread_cache_size = 8
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 256M
write_buffer = 256M
tmpdir=C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL\Data
[client]
port=3306
what can i do to have the best performance ? ,
when i increase innodb_buffer_pool_size parameter, mysql service won't start.
this is my.ini file :
[MySQLD]
port=3306
basedir=C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL51\
datadir=C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL\Data
character-set-server=latin1
default-storage-engine=INNODB
innodb_additional_mem_pool_size=1524M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=512M
innodb_buffer_pool_size=1360M
innodb_log_file_size=100M
innodb_thread_concurrency=8
#innodb_buffer_pool_instances=16
#innodb_buffer_pool_chunk_size=512M
query_cache_size = 88M
federated
key_buffer_size = 384M
max_allowed_packet = 8M
skip-external-locking
table_open_cache = 512M
sort_buffer_size = 512M
read_buffer_size = 512M
read_rnd_buffer_size = 256M
myisam_sort_buffer_size = 512M
thread_cache_size = 8
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 256M
write_buffer = 256M
tmpdir=C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL\Data
[client]
port=3306