When I run it, the following error is displayed.

  • Resolved youropfirend

    (@nono520)


    1 year, 2 months ago

    Hello

    1. When I run it, the following error is displayed.
      PHP Warning: Undefined array key “HTTP_HOST” in phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Runner.php(1309) : eval()’d code on line 29
      PHP Warning: Undefined array key “HTTP_HOST” in phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Runner.php(1309) : eval()’d code on line 30
      Index WP MySQL For Speed ??1.4.14
      Versions Plugin:1.4.14 MySQL:8.0.34-0ubuntu0.22.04.1 WordPress:6.3.1 WordPress database:55853 php:8.2.10
      disable wp_commentmeta complete. (2 MySQL statements, 21.34s)
      disable wp_comments complete. (2 MySQL statements, 4.87s)
      disable wp_options complete. (2 MySQL statements, 4.11s)
      disable wp_postmeta complete. (2 MySQL statements, 6.17s)
      WordPress database error MySQL server has gone away for query ALTER TABLE wp_posts DROP KEY post_name, ADD KEY post_name (post_name(191)), DROP KEY post_parent, ADD KEY post_parent (post_parent), DROP KEY type_status_date, ADD KEY type_status_date (post_type, post_status, post_date, ID), DROP KEY post_author, ADD KEY post_author (post_author)/imfs-query-tag679005840/ made by include(‘phar:///usr/local/bin/wp/php/boot-phar .php’), include(‘phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/wp-cli.php’), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner ->process, WP_CLI\Runner->start, WP_CLI\Runner->run_command_and_exit, WP_CLI\Runner->run_command, WP_CLI\Dispatcher\Subcommand->invoke, call_user_func, WP_CLI\Dispatcher\CommandFactory::WP_CLI\Dispatcher{closure} , call_user_func, ImsfCli->disable, ImsfCli->doRekeying, ImfsDb->rekeyTables, ImfsDb->rekeyTable, ImfsDb->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC_CallUnderlying->que ry, W3TC \DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query PHP Fatal error: Uncaught ImfsException: [0]: MySQL server has gone away in ALTER TABLE wp_posts DROP KEY post_name, ADD KEY post_name (post_name(191)), DROP KEY post_parent, ADD KEY post_parent (post_parent), DROP KEY type_status_date, ADD KEY type_status_date (post_type, post_status, post_date, ID), DROP KEY post_author, ADD KEY post_author (post_author)/imfs-query-tag679005840/ thrown in /var/www/xxxxxx/wp-content/plugins/index-wp-mysql-for-speed/code/imsfdb.php on line 427
      Fatal error: Uncaught ImfsException: [0]: MySQL server has gone away in ALTER TABLE wp_posts DROP KEY post_name, ADD KEY post_name (post_name(191)), DROP KEY post_parent, ADD KEY post_parent (post_parent), DROP KEY type_status_date, ADD KEY type_status_date (post_type, post_status, post_date, ID), DROP KEY post_author, ADD KEY post_author (post_author)/*imfs-query-tag679005840*/ thrown in /var/www/xxxxxx/wp-content/plugins/index-wp-mysql-for-speed/code/imsfdb.php on line 427
      Error: There is a major problem with this site. Learn more about troubleshooting in WordPress This site is experiencing a major problem.

    Upload id: rZZTyjJF
    When I try to restore the key, an error occurs and cannot be completed.
    But it can’t be completed if I run join key

    1. I want to add this plug-in to the key and recovery key to the cron schedule.
      wp index-mysql disable
      wp index-mysql enable

    Suppose I update articles every day, would it be better if I need to run it every once in a while?

    1. Or do I only need to run it once, and I don’t need to run it again no matter whether there are new articles or not?

    Thank you very much for creating such a good plug-in, and also appreciate your answer, thank you

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author OllieJones

    (@olliejones)

    Thanks for the questions, and for the uploaded metadata. Your uploaded metadata shows that your tables all have high-performance keys. So you have successfully used the plugin. There’s no need to do anything further. Your site will continue to get the benefit.

    Do not disable and re-enable the high performance keys in a daily cron job. That doesn’t make sense. Once the high-performance keys are in place, MySQL uses and maintains them. They don’t get stale or anything like that, so there’s no need to rebuild them routinely.

    If you do any routine data maintenance at all, you can do ANALYZE TABLE wp_posts operations to your tables once a week or once a month. But even that is not usually necessary.

    About your error message:

    MySQL server has gone away means your MySQL server crashed. This is a very rare problem on a production web site. A couple of server-configuration things are possible causes. Both of these require help from your hosting provider, or for you to upgrade your hosting.

    1. The MySQL server doesn’t have enough RAM to do its job.
    2. The server’s tmpdir setting (a server variable) is set to 'tmp, and the /tmp disk volume is too small. Change the server variable to /var/tmp in this case.

    But if this is only happening from your cronjob, don’t worry about it.

    Thread Starter youropfirend

    (@nono520)

    Thank you very much for your answer and for such a great plugin

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘When I run it, the following error is displayed.’ is closed to new replies.