• We value your experience with Plesk during 2024
    Plesk strives to perform even better in 2025. To help us improve further, please answer a few questions about your experience with Plesk Obsidian 2024.
    Please take this short survey:

    https://pt-research.typeform.com/to/AmZvSXkx
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

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