Title: Maximum execution time Last modified: April 5, 2021 --- # Maximum execution time * [banothuthiru](https://wordpress.org/support/users/banothuthiru/) * (@banothuthiru) * [5 years, 1 month ago](https://wordpress.org/support/topic/maximum-execution-time-6/) * Hi, I;m facing an issue when i try to save the content after done changes into localhost it takes time and show the following error please can any one help me to solve this issue * Fatal error: Maximum execution time of 120 seconds exceeded in C:\xampp\htdocs\ codeplexus\wp-includes\wp-db.php on line 2056 There has been a critical error on this website. Please check your site admin email inbox for instructions. - This topic was modified 5 years, 1 month ago by [Yui](https://wordpress.org/support/users/fierevere/). Reason: moved to "localhost installs" Viewing 10 replies - 1 through 10 (of 10 total) * Moderator [Yui](https://wordpress.org/support/users/fierevere/) * (@fierevere) * 永子 * [5 years, 1 month ago](https://wordpress.org/support/topic/maximum-execution-time-6/#post-14278351) * 120 sec is very slow operation on database. * Are you using modern hardware? Is your storage used for database a SSD? * You can increase max_execution_time value in php.ini or set it to 0 for unlimited, but in case your database is not really that huge, there is something wrong with your server configuration (mysql/hardware) - This reply was modified 5 years, 1 month ago by [Yui](https://wordpress.org/support/users/fierevere/). * Thread Starter [banothuthiru](https://wordpress.org/support/users/banothuthiru/) * (@banothuthiru) * [5 years, 1 month ago](https://wordpress.org/support/topic/maximum-execution-time-6/#post-14278385) * No I’m using HDD in my PC * Moderator [Yui](https://wordpress.org/support/users/fierevere/) * (@fierevere) * 永子 * [5 years, 1 month ago](https://wordpress.org/support/topic/maximum-execution-time-6/#post-14278411) * > HDD * Slow, Fragmented? Try running defragmentation at least. * In any case, i have pointed where the problem is. * You can check mysql.err (mysql errors log) to get more information regarding this problem. * [Dion](https://wordpress.org/support/users/diondesigns/) * (@diondesigns) * [5 years, 1 month ago](https://wordpress.org/support/topic/maximum-execution-time-6/#post-14278432) * No page in WordPress should ever require 120 seconds of CPU time, so something is definitely wrong. Is your site slow on all pages, or only when saving a post? * Since your system is Windows-based, you should check the value of `DB_HOST` in your wp-config.php file. If it is `localhost` or empty, change it to this: * `define('DB_HOST', '127.0.0.1');` * This probably won’t fix your problem, but it should reduce page load times by 2-4 seconds. * Thread Starter [banothuthiru](https://wordpress.org/support/users/banothuthiru/) * (@banothuthiru) * [5 years, 1 month ago](https://wordpress.org/support/topic/maximum-execution-time-6/#post-14278437) * I have been trying but not found I have seen the error log also nothing init * ``` InnoDB: using atomic writes. 2021-04-05 17:44:18 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-04-05 17:44:18 0 [Note] InnoDB: Uses event mutexes 2021-04-05 17:44:18 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-04-05 17:44:18 0 [Note] InnoDB: Number of pools: 1 2021-04-05 17:44:18 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-04-05 17:44:18 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-04-05 17:44:18 0 [Note] InnoDB: Completed initialization of buffer pool 2021-04-05 17:44:19 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288 2021-04-05 17:44:22 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-04-05 17:44:22 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-04-05 17:44:22 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-04-05 17:44:22 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-04-05 17:44:22 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-04-05 17:44:22 0 [Note] InnoDB: Waiting for purge to start 2021-04-05 17:44:22 0 [Note] InnoDB: 10.4.18 started; log sequence number 300297; transaction id 170 2021-04-05 17:44:22 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool 2021-04-05 17:44:22 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-04-05 17:44:22 0 [Note] Server socket created on IP: '::'. ``` * Thread Starter [banothuthiru](https://wordpress.org/support/users/banothuthiru/) * (@banothuthiru) * [5 years, 1 month ago](https://wordpress.org/support/topic/maximum-execution-time-6/#post-14278467) * No all pages in my site are fast when I try to save only give this issue & this issue i raised when I add the menu item to the menu bar save on that time it’s give this issue * [Dion](https://wordpress.org/support/users/diondesigns/) * (@diondesigns) * [5 years, 1 month ago](https://wordpress.org/support/topic/maximum-execution-time-6/#post-14278523) * How many menu items do you have? Saving a menu is **_extremely_** hard on a server; I’ve seen WordPress make more than 2500 INSERT/UPDATE queries when saving a huge menu. * You should increase the size of the InnoDB buffer pool. 16MB is much too low, and that could be the cause of your problem. It should ideally be at least twice the combined size of all your databases. Ask the Xampp support people how that should be done. * Thread Starter [banothuthiru](https://wordpress.org/support/users/banothuthiru/) * (@banothuthiru) * [5 years, 1 month ago](https://wordpress.org/support/topic/maximum-execution-time-6/#post-14278581) * currently I’m trying to save one item init but that issue is raising please could you tell what can I do to increase buffer pool * Moderator [Yui](https://wordpress.org/support/users/fierevere/) * (@fierevere) * 永子 * [5 years, 1 month ago](https://wordpress.org/support/topic/maximum-execution-time-6/#post-14278715) * You can check this article on setting _innodb\_buffer\_pool\_size_ (directive must be placed in my.cnf file in _[mysqld]_ section and mysqld should be restarted after modifying its config file) * [https://mariadb.com/kb/en/innodb-buffer-pool/](https://mariadb.com/kb/en/innodb-buffer-pool/) * or this one, for dynamic pool [https://mariadb.com/kb/en/setting-innodb-buffer-pool-size-dynamically/](https://mariadb.com/kb/en/setting-innodb-buffer-pool-size-dynamically/) - This reply was modified 5 years, 1 month ago by [Yui](https://wordpress.org/support/users/fierevere/). * [iforcepros](https://wordpress.org/support/users/iforcepros/) * (@iforcepros) * [4 years, 8 months ago](https://wordpress.org/support/topic/maximum-execution-time-6/#post-14929649) * InnoDB buffer pool changed this to 32. Also the localhost to 127.0.0.1. Fan on the laptop immediately cooled down after restarting xampp. Thanks everyone - This reply was modified 4 years, 8 months ago by [iforcepros](https://wordpress.org/support/users/iforcepros/). Viewing 10 replies - 1 through 10 (of 10 total) The topic ‘Maximum execution time’ is closed to new replies. * In: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/) * 10 replies * 4 participants * Last reply from: [iforcepros](https://wordpress.org/support/users/iforcepros/) * Last activity: [4 years, 8 months ago](https://wordpress.org/support/topic/maximum-execution-time-6/#post-14929649) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics