Title: wpbuild's Replies | WordPress.org --- # wpbuild [ ](https://wordpress.org/support/users/wpbuild/) * [Profile](https://wordpress.org/support/users/wpbuild/) * [Topics Started](https://wordpress.org/support/users/wpbuild/topics/) * [Replies Created](https://wordpress.org/support/users/wpbuild/replies/) * [Reviews Written](https://wordpress.org/support/users/wpbuild/reviews/) * [Topics Replied To](https://wordpress.org/support/users/wpbuild/replied-to/) * [Engagements](https://wordpress.org/support/users/wpbuild/engagements/) * [Favorites](https://wordpress.org/support/users/wpbuild/favorites/) Search replies: ## Forum Replies Created Viewing 15 replies - 1 through 15 (of 25 total) 1 [2](https://wordpress.org/support/users/wpbuild/replies/page/2/?output_format=md) [→](https://wordpress.org/support/users/wpbuild/replies/page/2/?output_format=md) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Fast Total Search - The Power of Indexed Search] Высокая нагрузка на MySQL](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/) * Thread Starter [wpbuild](https://wordpress.org/support/users/wpbuild/) * (@wpbuild) * [1 year, 5 months ago](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/page/2/#post-18291817) * Вечер добрый. * Я правильно понимаю, на сайтах с большим количеством активных пользователей в админке, лучше отказаться от этого плагина? Потому что проблема так никуда и не делась. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Fast Total Search - The Power of Indexed Search] Высокая нагрузка на MySQL](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/) * Thread Starter [wpbuild](https://wordpress.org/support/users/wpbuild/) * (@wpbuild) * [1 year, 7 months ago](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/page/2/#post-18173744) * День добрый. Что нибудь проясняется? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Fast Total Search - The Power of Indexed Search] Высокая нагрузка на MySQL](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/) * Thread Starter [wpbuild](https://wordpress.org/support/users/wpbuild/) * (@wpbuild) * [1 year, 7 months ago](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/page/2/#post-18147874) * Ну хотя бы приблизительно? Напрягает нагрузка )) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Fast Total Search - The Power of Indexed Search] Высокая нагрузка на MySQL](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/) * Thread Starter [wpbuild](https://wordpress.org/support/users/wpbuild/) * (@wpbuild) * [1 year, 7 months ago](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/page/2/#post-18142343) * День добрый. Не подскажете когда ждать обновления? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Fast Total Search - The Power of Indexed Search] Высокая нагрузка на MySQL](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/) * Thread Starter [wpbuild](https://wordpress.org/support/users/wpbuild/) * (@wpbuild) * [1 year, 8 months ago](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/#post-18137485) * Если я правильно понимаю происходящее, при каждом `save_post` ставится в очередь реиндексация, и если таких событий много и они одновременные, возникает большое количество запросов к базе. Вопрос, а можно ли как то объединять такие запросы, и отправлять на реиндексацию массив постов, а не отдельный пост? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Fast Total Search - The Power of Indexed Search] Высокая нагрузка на MySQL](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/) * Thread Starter [wpbuild](https://wordpress.org/support/users/wpbuild/) * (@wpbuild) * [1 year, 8 months ago](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/#post-18135654) * [video src="https://block.iwpb.ru/img/2024-11-14.mp4" /] * Я отключил WP cron вообще, поставил системный с запуском раз в 2 минуты. но видимо при активности пользователей все равно куча таких запросов вылазит * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Fast Total Search - The Power of Indexed Search] Высокая нагрузка на MySQL](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/) * Thread Starter [wpbuild](https://wordpress.org/support/users/wpbuild/) * (@wpbuild) * [1 year, 8 months ago](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/#post-18132695) * Вот еще наблюдение примерно одинаковая конфигурация серверов: * Executed the cron event ‘wpfts_indexer_event’ in 0.205s. на машине где 700 тыс. записей. 1 тип записи, 3 таксономиибаза примерно 9Gb * Executed the cron event ‘wpfts_indexer_event’ in 0.001s. на машине где 200 тыс. записей. 8 типов записей, 30 таксономийбаза примерно 4Gb * непонятно почему такая большая разница во времени выполнения. Я честно говоря думал что на второй машине, где больше разнородных элементов будет дольше проверяться индекс. - This reply was modified 1 year, 8 months ago by [wpbuild](https://wordpress.org/support/users/wpbuild/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Fast Total Search - The Power of Indexed Search] Высокая нагрузка на MySQL](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/) * Thread Starter [wpbuild](https://wordpress.org/support/users/wpbuild/) * (@wpbuild) * [1 year, 8 months ago](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/#post-18132463) * Вот еще какое наблюдение, ночью, когда активности авторов/редакторов на сайте нет, то раз в минуту появляется такой запрос, иногда 2 или 3 разом, но все это в течении 1-2 секунд заканчивается, и на нагрузку никак не влияет. А когда в админке висят авторы, то таких хапросов может образоваться до 50 штук одновременно. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Fast Total Search - The Power of Indexed Search] Высокая нагрузка на MySQL](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/) * Thread Starter [wpbuild](https://wordpress.org/support/users/wpbuild/) * (@wpbuild) * [1 year, 8 months ago](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/#post-18131929) * Еще один момент, после полного удаления палагина, его переустановки и переиндексации, пропало сообщение: * “NOTICE: PHP message: Ошибка перепланировки события Cron для хука wpfts_indexer_event, код ошибки: could_not_set, сообщение об ошибке: Список событий cron не может быть сохранен., данные: {“schedule”:”wpfts_each_minute”,”args”:[],”interval”: 60}” * Но поведение при этом осталось прежнее. - This reply was modified 1 year, 8 months ago by [wpbuild](https://wordpress.org/support/users/wpbuild/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Fast Total Search - The Power of Indexed Search] Высокая нагрузка на MySQL](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/) * Thread Starter [wpbuild](https://wordpress.org/support/users/wpbuild/) * (@wpbuild) * [1 year, 8 months ago](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/#post-18131910) * Вот еще в логах проскочило, вряд ли оно, но вдруг на что то натолкнет. * [pool www-php83] child 20538 said into stderr: “NOTICE: PHP message: WordPress database error Duplicate entry ‘848388-wp_posts’ for key ‘tid_tsrc_unique’ for query insert into `wpftsi_index` (`tid`, `tsrc`, `tdt`, `build_time`, `update_dt`,` force_rebuild`, `locked_dt`) values (“848388”, “wp_posts”, “1970-01-01 00:00: 00”, 0, “1970-01-01 00:00:00”, 1, “1970-01-01 00:00:00″) made by do_action(‘wp_ajax_heartbeat’), WP_Hook->do_action, WP_Hook->apply_filters, wp_ajax_heartbeat, apply_filters(‘ heartbeat_received’), WP_Hook->apply_filters, heartbeat_autosave, wp_autosave, edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), WP_Hook->do_action, WP_Hook->apply_filters, wpfts_save_post_action, wpfts_post_reindex, WPFTS_Core- >MakePostsSync, WPFTS_DB->query” * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Fast Total Search - The Power of Indexed Search] Высокая нагрузка на MySQL](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/) * Thread Starter [wpbuild](https://wordpress.org/support/users/wpbuild/) * (@wpbuild) * [1 year, 8 months ago](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/#post-18131872) * Вообще всегда. с периодичностью раз в 1-3 минуты. когда то по 1-2 запроса, когда то по 20-30-50 * От того находишься в админке или нет – не зависит. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Fast Total Search - The Power of Indexed Search] Высокая нагрузка на MySQL](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/) * Thread Starter [wpbuild](https://wordpress.org/support/users/wpbuild/) * (@wpbuild) * [1 year, 8 months ago](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/#post-18131571) * Никаких идей не появилось? Может нужна еще какая нибудь информация? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Fast Total Search - The Power of Indexed Search] Высокая нагрузка на MySQL](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/) * Thread Starter [wpbuild](https://wordpress.org/support/users/wpbuild/) * (@wpbuild) * [1 year, 8 months ago](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/#post-18129514) * Попробуйте выключить плагин и снова включить – посмотрите, решает ли это проблему или запросы продолжают массово выполняться? * Пробовал. никак не влияет * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Fast Total Search - The Power of Indexed Search] Высокая нагрузка на MySQL](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/) * Thread Starter [wpbuild](https://wordpress.org/support/users/wpbuild/) * (@wpbuild) * [1 year, 8 months ago](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/#post-18129502) * Как я понимаю ошибка cron – известна начиная с версии wp 6.1.1. и не влияет на работу самого крона [https://core.trac.wordpress.org/ticket/57271](https://core.trac.wordpress.org/ticket/57271) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Fast Total Search - The Power of Indexed Search] Высокая нагрузка на MySQL](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/) * Thread Starter [wpbuild](https://wordpress.org/support/users/wpbuild/) * (@wpbuild) * [1 year, 8 months ago](https://wordpress.org/support/topic/%d0%b2%d1%8b%d1%81%d0%be%d0%ba%d0%b0%d1%8f-%d0%bd%d0%b0%d0%b3%d1%80%d1%83%d0%b7%d0%ba%d0%b0-%d0%bd%d0%b0-mysql/#post-18129372) * Дополнение: Периодичность приблизительно 1 минута. Viewing 15 replies - 1 through 15 (of 25 total) 1 [2](https://wordpress.org/support/users/wpbuild/replies/page/2/?output_format=md) [→](https://wordpress.org/support/users/wpbuild/replies/page/2/?output_format=md)