bei einem aktuellen Projekt habe ich sehr starke Performance-Probleme.
Der Seitenaufruf dauert ungewöhnlich lange.
Wir haben das Bundle AdvanceMod_Rewrite von polycoder im Einsatz (allerdings die mod_rewrite Funktion und die Rewrite-Rules deaktiviert)
Server Betriebssystem: Microsoft-IIS/6.0
PHP MySQL database extension: mysql
MySQL Serverversion: 5.0.22-community-nt
Installierte PHP-Version: 5.1.5
Auf selbem Server laufen bereits andere Versionen völlig problemlos (Beispiel: www.dsbike.de)
Die Debug-Ausgabe liefert mir beim Seitenaufruf ungewöhnliche OPTIMIZE Querys.
...
Code: Alles auswählen
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91204, 200706, 1, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91205, 200706, 17, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91206, 200706, 2, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91207, 200706, 3, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91208, 200706, 4, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91209, 200706, 5, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91210, 200706, 18, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91211, 200706, 19, 1, 1, 1, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91212, 200706, 20, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91213, 200706, 21, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91214, 200706, 22, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91215, 200706, 23, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91216, 200706, 12, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91217, 200706, 13, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91218, 200706, 26, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91219, 200706, 27, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91220, 200706, 28, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91221, 200706, 29, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91222, 200706, 30, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91223, 200706, 31, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91224, 200706, 32, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91225, 200706, 6, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91226, 200706, 33, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91227, 200706, 34, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91228, 200706, 35, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91229, 200706, 37, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91230, 200706, 43, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91231, 200706, 44, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91232, 200706, 54, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91233, 200706, 56, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91234, 200706, 57, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91235, 200706, 36, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91236, 200706, 50, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91237, 200706, 51, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91238, 200706, 42, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91239, 200706, 41, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91240, 200706, 59, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91241, 200706, 58, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91242, 200706, 60, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91243, 200706, 40, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91244, 200706, 52, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91245, 200706, 53, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91246, 200706, 39, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91247, 200706, 38, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91248, 200706, 7, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91249, 200706, 14, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91250, 200706, 15, 1, 1, 0, '')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat_archive ( idstatarch, archived, idcatart, idlang, idclient, visited, visitdate) VALUES (91251, 200706, 16, 1, 1, 0, '')
Debug: query = DELETE FROM con_stat
Debug: query = SELECT A.idcatart, B.idclient, C.idlang FROM con_cat_art AS A INNER JOIN con_cat AS B ON A.idcat = B.idcat INNER JOIN con_cat_lang AS C ON A.idcat = C.idcat
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90112, 1, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90113, 17, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90114, 2, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90115, 3, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90116, 4, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90117, 5, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90118, 18, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90119, 19, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90120, 20, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90121, 21, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90122, 22, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90123, 23, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90124, 12, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90125, 13, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90126, 26, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90127, 27, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90128, 28, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90129, 29, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90130, 30, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90131, 31, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90132, 32, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90133, 6, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90134, 33, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90135, 34, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90136, 35, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90137, 37, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90138, 43, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90139, 44, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90140, 54, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90141, 56, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90142, 57, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90143, 36, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90144, 50, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90145, 51, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90146, 42, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90147, 41, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90148, 59, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90149, 58, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90150, 60, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90151, 40, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90152, 52, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90153, 53, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90154, 39, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90155, 38, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90156, 7, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90157, 14, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90158, 15, 1, 1, '0000-00-00 00:00:00')
Debug: query = lock tables con_sequence write
Debug: query = unlock tables
Debug: query = INSERT INTO con_stat ( idstat, idcatart, idlang, idclient, visited ) VALUES ( 90159, 16, 1, 1, '0000-00-00 00:00:00')
Debug: query = SELECT changed, sid FROM con_phplib_active_sessions
Debug: query = SELECT idinuse FROM con_inuse
Debug: query = OPTIMIZE TABLE con_art
Debug: query = OPTIMIZE TABLE con_art_lang
Debug: query = OPTIMIZE TABLE con_cat
Debug: query = OPTIMIZE TABLE con_cat_art
Debug: query = OPTIMIZE TABLE con_cat_tree
Debug: query = OPTIMIZE TABLE con_cat_lang
Debug: query = OPTIMIZE TABLE con_clients
Debug: query = OPTIMIZE TABLE con_clients_lang
Debug: query = OPTIMIZE TABLE con_code
Debug: query = OPTIMIZE TABLE con_content
Debug: query = OPTIMIZE TABLE con_lang
Debug: query = OPTIMIZE TABLE con_lay
Debug: query = OPTIMIZE TABLE con_mod
Debug: query = OPTIMIZE TABLE con_news
Debug: query = OPTIMIZE TABLE con_news_rcp
Debug: query = OPTIMIZE TABLE con_news_groups
Debug: query = OPTIMIZE TABLE con_news_groupmembers
Debug: query = OPTIMIZE TABLE con_stat
Debug: query = OPTIMIZE TABLE con_stat_archive
Debug: query = OPTIMIZE TABLE con_status
Debug: query = OPTIMIZE TABLE con_template
Debug: query = OPTIMIZE TABLE con_template_conf
Debug: query = OPTIMIZE TABLE con_type
Debug: query = OPTIMIZE TABLE con_upl
Debug: query = OPTIMIZE TABLE con_keywords
Debug: query = OPTIMIZE TABLE con_area
Debug: query = OPTIMIZE TABLE con_actions
Debug: query = OPTIMIZE TABLE con_nav_main
Debug: query = OPTIMIZE TABLE con_nav_sub
Debug: query = OPTIMIZE TABLE con_rights
Debug: query = OPTIMIZE TABLE con_container
Debug: query = OPTIMIZE TABLE con_container_conf
Debug: query = OPTIMIZE TABLE con_files
Debug: query = OPTIMIZE TABLE con_frame_files
Debug: query = OPTIMIZE TABLE con_plugins
Debug: query = OPTIMIZE TABLE con_phplib_active_sessions
Debug: query = OPTIMIZE TABLE con_phplib_auth_user_md5
Debug: query = OPTIMIZE TABLE con_actionlog
Debug: query = OPTIMIZE TABLE con_link
Debug: query = OPTIMIZE TABLE con_meta_type
Debug: query = OPTIMIZE TABLE con_meta_tag
Debug: query = OPTIMIZE TABLE con_groups
Debug: query = OPTIMIZE TABLE con_group_prop
Debug: query = OPTIMIZE TABLE con_groupmembers
Debug: query = OPTIMIZE TABLE con_config
Debug: query = OPTIMIZE TABLE con_config_client
Debug: query = OPTIMIZE TABLE con_data
Debug: query = OPTIMIZE TABLE con_sequence
Debug: query = OPTIMIZE TABLE con_user_prop
Debug: query = OPTIMIZE TABLE con_inuse
Debug: query = OPTIMIZE TABLE con_system_prop
Debug: query = OPTIMIZE TABLE con_art_spec
Debug: query = OPTIMIZE TABLE con_mod_history
Debug: query = OPTIMIZE TABLE con_properties
Debug: query = OPTIMIZE TABLE con_frontendusers
Debug: query = OPTIMIZE TABLE con_frontendgroups
Debug: query = OPTIMIZE TABLE con_frontendgroupmembers
Debug: query = OPTIMIZE TABLE con_communications
Debug: query = OPTIMIZE TABLE con_mod_translations
Debug: query = OPTIMIZE TABLE con_frontendpermissions
Debug: query = OPTIMIZE TABLE con_dbfs
Debug: query = OPTIMIZE TABLE con_chartableIm Quellcode finde ich aber komischerweise nur eine einzige OPTIMIZE-Anweisung (im Ordner: /cronjobs).
Weiß jemand was diese SQL-Anweisungen bewirken bzw. durch was sie ausgelöst werden?
Vielen Dank!
