• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

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