• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Question can't increase mysql innodb_buffer_pool_size

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
 
i enabled log file,
this is my log error :
180427 5:52:20 InnoDB: Initializing buffer pool, size = 2.0G
180427 5:52:20 InnoDB: Error: cannot allocate 2147500032 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 1604905804 bytes. Operating system errno: 8
InnoDB: Check if you should increase the swap file or
InnoDB: ulimits of your operating system.
InnoDB: On FreeBSD check you have compiled the OS with
InnoDB: a big enough maximum process size.
InnoDB: Note that in most 32-bit computers the process
InnoDB: memory space is limited to 2 GB or 4 GB.
InnoDB: We keep retrying the allocation for 60 seconds...
180427 5:53:20InnoDB: Fatal error: cannot allocate the memory for the buffer pool
180427 5:53:20 [ERROR] Plugin 'InnoDB' init function returned error.
180427 5:53:20 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
180427 5:53:20 [Note] Event Scheduler: Loaded 0 events
180427 5:53:20 [Note] C:\Program Files
 
Back
Top