Trues Posted February 6, 2023 Share Posted February 6, 2023 (edited) Hello, I recently had to migrate my site to a new server as the old one didn't support PHP 8. The migration went fine but now when i try to run the upgrade, It either times out with a 50X page or I get this error. Â Any help would be greatly appreciated. Thanks, MIke Edited February 6, 2023 by Trues Link to comment Share on other sites More sharing options...
Jim M Posted February 6, 2023 Share Posted February 6, 2023 Please contact your hosting provider as this is a MySQL server issue. The UPDATE command on that table is taking longer than what you are allowing it to, thus you are getting a lock timeout. Â Link to comment Share on other sites More sharing options...
Trues Posted February 6, 2023 Author Share Posted February 6, 2023 Thanks so much Jim. I'll contact my host again with this info and see what they say. I've been working with them on this issue for the past week with no luck. I'll keep trying. Link to comment Share on other sites More sharing options...
Marc Stridgen Posted February 7, 2023 Share Posted February 7, 2023 It should be noted, all your tables should be using the INNODB table engine. I suspect that one at the least is running MyIsam. Without being over technical, its more efficient with locks Link to comment Share on other sites More sharing options...
Solution Trues Posted February 7, 2023 Author Solution Share Posted February 7, 2023 I made these changes to mysql and all is good now. Thanks again. innodb_lock_wait_timeout=1200 innodb_file_per_table=1 innodb_buffer_pool_size = 12G innodb_lock_wait_timeout = 200 innodb_log_file_size= 1600M Link to comment Share on other sites More sharing options...
Marc Stridgen Posted February 7, 2023 Share Posted February 7, 2023 Glad to hear it 🙂 Link to comment Share on other sites More sharing options...
Recommended Posts