Risultati della ricerca per 'Database wordpress tables'
-
-
Non riesco a fare un backup con Duplicator. Il processo arriva al 59.7% e poi si interrompe fornendomi i seguenti errori. Il plugin mi informa che il mio sito occupa 5GB mentre il DB 12MB.
Fase 1
Scansionando il sito
Attendi…
Mantieni questa finestra aperta durante il processo di scansione.
Potrebbero servire diversi minuti.
Fase 2
Compilazione pacchetto 59.7%
Attendi…
Tieni aperta questa finestra e non chiuderla durante il processo di creazione.
Il completamento dell’operazione potrebbe richiedere diversi minuti.
Fase 3
Si blocca a 59.7% per molto tempo.
Fase 4
Stato della compilazione
Compilazione interrotta dall’host
This server cannot complete the build due to host setup constraints, see the error message for more details.
If the error details are not specific consider the options below by clicking each section.******************************************************************************** DUPLICATOR-LITE PACKAGE-LOG: 5 February 2023 22:22 NOTICE: Do NOT post to public sites or forums ******************************************************************************** VERSION: 1.5.2.1 WORDPRESS: 5.9.5 PHP INFO: 5.6.40 | SAPI: cgi-fcgi SERVER: Apache PHP TIME LIMIT: (0) no time limit imposed PHP MAX MEMORY: 4294967296 (1024M default) MEMORY STACK: 81.25MB ******************************************************************************** DATABASE: ******************************************************************************** BUILD MODE: PHP(query limit - 100) MYSQLTIMEOUT: 5000 MYSQLDUMP: Not Supported TABLES: total:22 | filtered:0 | create:22 FILTERED: [] SQL CREATED: 20230205_xxxxxxxxxxx_af3938eced030e1d8652_20230205222046_database.sql SQL FILE SIZE: 9.74MB (10209995) SQL FILE TIME: 2023-02-05 22:22:05 SQL RUNTIME: 2.70 sec. ******************************************************************************** ARCHIVE (ZIP): ******************************************************************************** ARCHIVE DIR: /web/htdocs/www.nomeadominio.it/home ARCHIVE FILE: 20230205_xxxxxxxxxxx_af3938eced030e1d8652_20230205222046_archive.zip FILTERS: *OFF* DIRS: not set FILES: not set EXTS: not set ---------------------------------------- COMPRESSING SIZE: 5.06GB STATS: Dirs 2,677 | Files 29,397 SQL ADDED: 20230205_xxxxxxxxxxx_af3938eced030e1d8652_20230205222046_database.sql [PHP ERR][WARN] MSG:filesize(): stat failed for /web/htdocs/www.nomeadominio.it/home/ikkanews/----.mht [CODE:2|FILE:/web/htdocs/www.nomeadominio.it/home/wp-content/plugins/duplicator/classes/package/class.pack.archive.zip.php|LINE:172] do_action('wp_ajax_duplicator_package_build'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, duplicator_package_build, DUP_Package->runZipBuild, DUP_Archive->build, DUP_Zip::create, filesize, DUP_Handler::error, DUP_Handler::getMessage [PHP ERR][WARN] MSG:filesize(): stat failed for /web/htdocs/www.nomeadominio.it/home/----.mht [CODE:2|FILE:/web/htdocs/www.nomeadominio.it/home/wp-content/plugins/duplicator/classes/package/class.pack.archive.zip.php|LINE:172] do_action('wp_ajax_duplicator_package_build'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, duplicator_package_build, DUP_Package->runZipBuild, DUP_Archive->build, DUP_Zip::create, filesize, DUP_Handler::error, DUP_Handler::getMessage WARNING: Unable to zip files: FILE: [/web/htdocs/www.nomeadominio.it/home/ikkanews/----.mht] FILE: [/web/htdocs/www.nomeadominio.it/home/----.mht] ZipArchive Object ( [status] => 0 [statusSys] => 0 [numFiles] => 32072 [filename] => /web/htdocs/www.nomeadominio.it/home/wp-content/backups-dup-lite/tmp/20230205_xxxxxxxxxxx_af3938eced030e1d8652_20230205222046_archive.zip [comment] => ) FILE ADDED TO ZIP: 32071 COMPRESSION RESULT: '1' COMPRESSED SIZE: 4.25GB ARCHIVE RUNTIME: 436.76 sec. MEMORY STACK: 94.75MB building installer [PHP ERR][WARN] MSG:No valid encoded path found in value '' for ioncube.loader.encoded_paths. [CODE:2|FILE:Unknown|LINE:0] DUP_Handler::shutdown, DUP_Handler::error, DUP_Handler::getMessageIl mio hosting mi permette di editare i seguenti parametri (max_execution_time è già al massimo, memory_limit anche):
PHP 8.1 PHP 8.0 PHP 7.4 (obsoleta) PHP 7.3 (obsoleta) PHP 7.2 (obsoleta) PHP 7.1 (obsoleta) PHP 7.0 (obsoleta) PHP 5.6 (attualmente in uso ma obsoleta) PHP 5.5 (obsoleta) PHP 5.4 (obsoleta) PHP 5.3 (obsoleta) PHP 5.2 (obsoleta) PHP 4.4 (obsoleta) Nascondi versioni obsolete display_errors Off max_input_time 60 max_input_vars 1000 post_max_size 25M zlib.output_compression Off allow_url_fopen Off opcache.jit Off max_execution_time 900 memory_limit 1024M output_buffering 4096 upload_max_filesize 25M short_open_tag Off mysqli.allow_local_infile Off ioncube OffTogliendo quei file ottengo questo log:
******************************************************************************** DUPLICATOR-LITE PACKAGE-LOG: 5 February 2023 23:05 NOTICE: Do NOT post to public sites or forums ******************************************************************************** VERSION: 1.5.2.1 WORDPRESS: 5.9.5 PHP INFO: 5.6.40 | SAPI: cgi-fcgi SERVER: Apache PHP TIME LIMIT: (0) no time limit imposed PHP MAX MEMORY: 4294967296 (1024M default) MEMORY STACK: 80.75MB ******************************************************************************** DATABASE: ******************************************************************************** BUILD MODE: PHP(query limit - 100) MYSQLTIMEOUT: 5000 MYSQLDUMP: Not Supported TABLES: total:22 | filtered:0 | create:22 FILTERED: [] SQL CREATED: 20230205_xxxxxxxx_00bacebb0a0a153c8817_20230205230513_database.sql SQL FILE SIZE: 9.72MB (10189462) SQL FILE TIME: 2023-02-05 23:05:51 SQL RUNTIME: 2.35 sec. ******************************************************************************** ARCHIVE (ZIP): ******************************************************************************** ARCHIVE DIR: /web/htdocs/www.nomeadominio.it/home ARCHIVE FILE: 20230205_xxxxxxxx_00bacebb0a0a153c8817_20230205230513_archive.zip FILTERS: *OFF* DIRS: not set FILES: not set EXTS: not set ---------------------------------------- COMPRESSING SIZE: 5.06GB STATS: Dirs 2,676 | Files 29,395 SQL ADDED: 20230205_xxxxxxxx_00bacebb0a0a153c8817_20230205230513_database.sql ZipArchive Object ( [status] => 0 [statusSys] => 0 [numFiles] => 32071 [filename] => /web/htdocs/www.nomeadominio.it/home/wp-content/backups-dup-lite/tmp/20230205_xxxxxxxx_00bacebb0a0a153c8817_20230205230513_archive.zip [comment] => ) FILE ADDED TO ZIP: 32070
-
Salve a tutti,
ho un dominio [link sotto] su siteground
Dentro essenzialmente ci sono pochi plugin e woocommerce installato con al massimo 6-7 prodotti e qualche pagina informativa oltre la home.Il sito non è più accessibile
Ho aperto un ticket su siteground e la risposta è stata
“CAUSA DEL CONSUMO ELEVATO DI RISORSE:
Abbiamo svolto uno studio approfondito e abbiamo scoperto che WordPress esegue query lente in direzione del suo database, che infine monopolizzano il server. Il server tenta di eseguire le query lente mettendo altri processi in coda fino a quando viene liberata un po’ di memoria. Tuttavia, mentre sono in attesa, i processi si accumulano e causano ulteriori problemi. I motivi per query lente nel database possono essere molteplici, ma i seguenti tre sono i più comuni:”
E continua ancora:
Ecco alcune delle query di database che sono lente e consumano molte risorse del server:
=== Databases Info =========================================================================
Database Label Tables Views InnoDB MyISAM Slow Queries Slowest Query DB Size
————– ————- —— —– —— —— ———— ————- ——-
dbbqkxtgr564py meditashop.it 45 0 45 0 2293 9.538 52.5 MB
——————————————————————————————–=== TOP 10 of 2293 (total) Slow Queries for the past 24 hours ====================================================
1. Executed 9h 54m 51s ago for 17.010839 sec on Database –> dbbqkxtgr564py
Date: 2020-04-10 08:24:21 Query_time: 17.010839 Rows_examined: 1: Rows_sent 0 Lock_time: 0.000209 Query_chars: 415
UPDATE usc_packlink_entity SET type = ‘Configuration’, index_1 = ‘taskRunnerStatus’, index_2 = ‘1’, index_3 = NULL, index_4 = NULL, index_5 = NULL, index_6 = NULL, index_7 = NULL, data = ‘{\”class_name\”:\”Logeecom\\\\Infrastructure\\\\Configuration\\\\ConfigEntity\”,\”id\”:\”1\”,\”name\”:\”taskRunnerStatus\”,\”value\”:{\”guid\”:\”\”,\”timestamp\”:null},\”systemId\”:\”1\”}’ WHERE id = ‘1’;
——————————————————————————————————————-
2. Executed 9h 54m 51s ago for 15.057252 sec on Database –> dbbqkxtgr564py
Date: 2020-04-10 08:24:21 Query_time: 15.057252 Rows_examined: 385: Rows_sent 385 Lock_time: 0.050277 Query_chars: 74
SELECT option_name, option_value FROM usc_options WHERE autoload = ‘yes’;
——————————————————————————————————————-
3. Executed 9h 54m 51s ago for 12.268459 sec on Database –> dbbqkxtgr564py
Date: 2020-04-10 08:24:21 Query_time: 12.268459 Rows_examined: 385: Rows_sent 385 Lock_time: 0.050340 Query_chars: 74
SELECT option_name, option_value FROM usc_options WHERE autoload = ‘yes’;
——————————————————————————————————————-
4. Executed 2h 33m 48s ago for 10.020625 sec on Database –> dbbqkxtgr564py
Date: 2020-04-10 15:45:24 Query_time: 10.020625 Rows_examined: 0: Rows_sent 0 Lock_time: 0.071572 Query_chars: 101
SELECT option_value FROM usc_options WHERE option_name = ‘wc_connect_debug_logging_enabled’ LIMIT 1;
——————————————————————————————————————-
5. Executed 8h 12m 53s ago for 9.538467 sec on Database –> dbbqkxtgr564py
Date: 2020-04-10 10:06:19 Query_time: 9.538467 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000098 Query_chars: 101
SELECT option_value FROM usc_options WHERE option_name = ‘_transient_et_builder_ajax_cache’ LIMIT 1;
——————————————————————————————————————-
6. Executed 8h 12m 53s ago for 9.528367 sec on Database –> dbbqkxtgr564py
Date: 2020-04-10 10:06:19 Query_time: 9.528367 Rows_examined: 0: Rows_sent 0 Lock_time: 0.012888 Query_chars: 104
SELECT option_value FROM usc_options WHERE option_name = ‘jetpack_edit_links_calypso_redirect’ LIMIT 1;
——————————————————————————————————————-
7. Executed 4h 34m 47s ago for 9.108485 sec on Database –> dbbqkxtgr564py
Date: 2020-04-10 13:44:25 Query_time: 9.108485 Rows_examined: 1: Rows_sent 1 Lock_time: 0.050165 Query_chars: 95
SELECT option_value FROM usc_options WHERE option_name = ‘_transient_et_core_version’ LIMIT 1;
——————————————————————————————————————-
8. Executed 7h 8m 5s ago for 7.904073 sec on Database –> dbbqkxtgr564py
Date: 2020-04-10 11:11:07 Query_time: 7.904073 Rows_examined: 362: Rows_sent 181 Lock_time: 0.006090 Query_chars: 214
SELECT usc_posts.* FROM usc_posts WHERE 1=1 AND usc_posts.post_parent = 16 AND usc_posts.post_type = ‘revision’ AND ((usc_posts.post_status = ‘inherit’)) ORDER BY usc_posts.post_date DESC, usc_posts.ID DESC;
——————————————————————————————————————-
9. Executed 7h 3m 57s ago for 7.156883 sec on Database –> dbbqkxtgr564py
Date: 2020-04-10 11:15:15 Query_time: 7.156883 Rows_examined: 362: Rows_sent 181 Lock_time: 0.043920 Query_chars: 214
SELECT usc_posts.* FROM usc_posts WHERE 1=1 AND usc_posts.post_parent = 16 AND usc_posts.post_type = ‘revision’ AND ((usc_posts.post_status = ‘inherit’)) ORDER BY usc_posts.post_date DESC, usc_posts.ID DESC;
——————————————————————————————————————-
10. Executed 4h 30m 7s ago for 6.986377 sec on Database –> dbbqkxtgr564py
Date: 2020-04-10 13:49:05 Query_time: 6.986377 Rows_examined: 0: Rows_sent 0 Lock_time: 0.031671 Query_chars: 101
SELECT option_value FROM usc_options WHERE option_name = ‘wc_connect_debug_logging_enabled’ LIMIT 1;
——————————————————————————————————————-=== Top 3 Similar SQL Queries and their query time =================================================================
Executed: 1814 time for minumum: 1.002449 sec, maximum: 9.538467 sec
SELECT option_value FROM usc_options WHERE option_name = ‘_transient_et_builder_ajax_cache’ LIMIT 1;
——————————————————————————————————————-
Executed: 184 time for minumum: 1.015242 sec, maximum: 6.586253 sec
SELECT * FROM usc_packlink_entity WHERE type = ‘Configuration’ AND ( index_1 = ‘taskRunnerStatus’ AND index_2 = ‘1’) LIMIT 0, 1;
——————————————————————————————————————-
Executed: 70 time for minumum: 1.052578 sec, maximum: 4.332906 sec
SELECT post_id, meta_key, meta_value FROM usc_postmeta WHERE post_id IN (150) ORDER BY meta_id ASC;
——————————————————————————————————————-Dalle query precedenti possiamo concludere che il tuo problema è causato da un script non ben compilati.
Come posso procedere?
Cosa va fatto?Grazie mille
Giovanni
aggiornamento
dovresti contattare uno sviluppatore professionista per controllare le query lente generate dal tuo database come specificato dal mio collega nella risposta precedente perché questo va oltre lo scopo del nostro supporto.La pagina su cui ho bisogno di aiuto: [devi essere connesso per vedere il link]
nella figura io setto:
replace: /wordpress/
with: /database: tutti i dati database e password
tabless: all tabless
actions: update details
p.s.Ma non ho capito se va eseguito lo script dentro cartella del sito wordpress o va fatta una cartella dentro a parte.
Comunque se è tutto giusto non funziona come mai?-
Salve, vorrei sapere a cosa è dovuto questo errore:
L’ho installato da wp cli e attivato da browser
[Fri Nov 09 16:35:33.840524 2018] [php7:notice] [pid 7863] [client ::1:53666] WordPress errore sul database Table 'x.wp_wpgdprc_access_requests' doesn't exist per la query ALTER TABLEwp_wpgdprc_access_requests\n ADD columntokentext NOT NULL AFTERip_address; fatta da require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, WPGDPRC\\WPGDPRC->init, WPGDPRC\\WPGDPRC::handleDatabaseTables, referer: http://localhost:81/wp-admin/plugins.php?plugin_status=all&paged=1&sNota: Lo scaricato oggi pomeriggio.
Cosa devo fare?
Grazie mille.
-
