The Gas Centre and BBQ Shop Limited – thegascentre.co.uk Support – 2025-03-06

Checking server performance – terrible. Removing php-fpm access and slow logging. Restarting services. Checking process – mysql high CPU. SHOW PROCESSLIST – many “Waiting for table level lock”. Researching converting table engine to InnoDB. Phone call with PF. Preparing SQL statements to convert tables to InnoDB. Backing up table. Converting engine to InnoDB. Optimising InnoDB settings in mysqld.cnf. Phone call with PF re: layouts missing. Trying to connect to db remotely via SSH. Phone call with TW re: mega menu layout settings. Updating Sequel Ace. Connecting to gascentre_production db using SSH tunnel. Running mysqltuner.pl. Tweaking settings and checking effects on CPU – none. Phone call with PF. Phone call with FC re: adding mailto links.