A seguire la lettera che mi \u00e8 giunta dal support team.
\n<\/p>\n
Hello,
\nThis is just a friendly email to let you know we made a minor change to your “wp” database. It looks like the stats table was not properly indexed, and it was causing a high load when this query was run:<\/p>\n
# Query_time: 3 Lock_time: 0 Rows_sent: 36 Rows_examined: 116167<\/p>\n
\n[sql]SELECT referer, resource, dt
\nFROM wp_slim_stats
\nWHERE referer NOT LIKE ‘%fullo.net%’
\nAND
\nreferer!=”
\nORDER BY dt DESC
\nLIMIT 0,36;[\/sql]
\n<\/small><\/p>\n
It was having to scan all 116,000 rows in that table to find the referrer. I added this index:<\/p>\n
\n[sql]ALTER TABLE `blog_b2slim_stats` ADD INDEX `referrer` ( `referer` ( 12 ) )[\/sql]
\n<\/small><\/p>\n
And now it scans at most 12 rows! Let us know if you have any other questions. The load has already dropped over 10 points. You should let the program author know of this change so it can help other people not get possibly dinged by their hosting companies!<\/strong>\n<\/p><\/blockquote>\nl’autore \u00e8 stato ovviamente trackbackato ed avvisato per email dell’accaduto.<\/p>\n
ciauz<\/p>\n","protected":false},"excerpt":{"rendered":"
Mi scrive oggi il support di Dreamhost dicendomi che hanno dovuto metter mano al mio db in quanto alcune tabelle (da oltre 116k recond) ne inficiavano le performance. Il problema pare dipenda da SlimStat, che quindi per un pochino disattiver\u00f2. A seguire la lettera che mi \u00e8 giunta dal support team.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[9],"tags":[107,401,1161,1162,679,1125,93,674],"class_list":["post-1929","post","type-post","status-publish","format-standard","hentry","category-php","tag-bug","tag-database","tag-optimization","tag-slimstat","tag-sql","tag-stats","tag-wordpress","tag-wp"],"yoast_head":"\n
Qualche problema per SlimStat - Fullo<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fullo.net\/blog\/2006\/04\/19\/qualche-problema-per-slimstat\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Qualche problema per SlimStat - Fullo\" \/>\n<meta property=\"og:description\" content=\"Mi scrive oggi il support di Dreamhost dicendomi che hanno dovuto metter mano al mio db in quanto alcune tabelle (da oltre 116k recond) ne inficiavano le performance. Il problema pare dipenda da SlimStat, che quindi per un pochino disattiver\u00f2. A seguire la lettera che mi \u00e8 giunta dal support team.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fullo.net\/blog\/2006\/04\/19\/qualche-problema-per-slimstat\/\" \/>\n<meta property=\"og:site_name\" content=\"Fullo\" \/>\n<meta property=\"article:published_time\" content=\"2006-04-19T10:01:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/www.fullo.net\/blog\/wp-content\/uploads\/2021\/05\/FB_IMG_1515748807284.jpg?fit=1453%2C1453&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"1453\" \/>\n\t<meta property=\"og:image:height\" content=\"1453\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Francesco Fullone\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@fullo\" \/>\n<meta name=\"twitter:site\" content=\"@fullo\" \/>\n<meta name=\"twitter:label1\" content=\"Scritto da\" \/>\n\t<meta name=\"twitter:data1\" content=\"Francesco Fullone\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo di lettura stimato\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2006\\\/04\\\/19\\\/qualche-problema-per-slimstat\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2006\\\/04\\\/19\\\/qualche-problema-per-slimstat\\\/\"},\"author\":{\"name\":\"Francesco Fullone\",\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/#\\\/schema\\\/person\\\/24e91bc6caea6c411a8668df5639428c\"},\"headline\":\"Qualche problema per SlimStat\",\"datePublished\":\"2006-04-19T10:01:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2006\\\/04\\\/19\\\/qualche-problema-per-slimstat\\\/\"},\"wordCount\":216,\"commentCount\":15,\"publisher\":{\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/#\\\/schema\\\/person\\\/24e91bc6caea6c411a8668df5639428c\"},\"keywords\":[\"bug\",\"database\",\"optimization\",\"slimstat\",\"sql\",\"stats\",\"wordpress\",\"wp\"],\"articleSection\":[\"php\"],\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2006\\\/04\\\/19\\\/qualche-problema-per-slimstat\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2006\\\/04\\\/19\\\/qualche-problema-per-slimstat\\\/\",\"url\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2006\\\/04\\\/19\\\/qualche-problema-per-slimstat\\\/\",\"name\":\"Qualche problema per SlimStat - Fullo\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/#website\"},\"datePublished\":\"2006-04-19T10:01:23+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2006\\\/04\\\/19\\\/qualche-problema-per-slimstat\\\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2006\\\/04\\\/19\\\/qualche-problema-per-slimstat\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2006\\\/04\\\/19\\\/qualche-problema-per-slimstat\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Qualche problema per SlimStat\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/\",\"name\":\"Fullo\",\"description\":\"nulla e' impossibile per chi non lo deve fare!\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/#\\\/schema\\\/person\\\/24e91bc6caea6c411a8668df5639428c\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"it-IT\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/#\\\/schema\\\/person\\\/24e91bc6caea6c411a8668df5639428c\",\"name\":\"Francesco Fullone\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.fullo.net\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/hawiaina-gold-circled-white.png?fit=622%2C622&ssl=1\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.fullo.net\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/hawiaina-gold-circled-white.png?fit=622%2C622&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.fullo.net\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/hawiaina-gold-circled-white.png?fit=622%2C622&ssl=1\",\"width\":622,\"height\":622,\"caption\":\"Francesco Fullone\"},\"logo\":{\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.fullo.net\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/hawiaina-gold-circled-white.png?fit=622%2C622&ssl=1\"},\"sameAs\":[\"http:\\\/\\\/www.fullo.net\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/fullo\",\"https:\\\/\\\/x.com\\\/fullo\"],\"url\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/author\\\/fullo\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Qualche problema per SlimStat - Fullo","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.fullo.net\/blog\/2006\/04\/19\/qualche-problema-per-slimstat\/","og_locale":"it_IT","og_type":"article","og_title":"Qualche problema per SlimStat - Fullo","og_description":"Mi scrive oggi il support di Dreamhost dicendomi che hanno dovuto metter mano al mio db in quanto alcune tabelle (da oltre 116k recond) ne inficiavano le performance. Il problema pare dipenda da SlimStat, che quindi per un pochino disattiver\u00f2. A seguire la lettera che mi \u00e8 giunta dal support team.","og_url":"https:\/\/www.fullo.net\/blog\/2006\/04\/19\/qualche-problema-per-slimstat\/","og_site_name":"Fullo","article_published_time":"2006-04-19T10:01:23+00:00","og_image":[{"width":1453,"height":1453,"url":"https:\/\/i0.wp.com\/www.fullo.net\/blog\/wp-content\/uploads\/2021\/05\/FB_IMG_1515748807284.jpg?fit=1453%2C1453&ssl=1","type":"image\/jpeg"}],"author":"Francesco Fullone","twitter_card":"summary_large_image","twitter_creator":"@fullo","twitter_site":"@fullo","twitter_misc":{"Scritto da":"Francesco Fullone","Tempo di lettura stimato":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fullo.net\/blog\/2006\/04\/19\/qualche-problema-per-slimstat\/#article","isPartOf":{"@id":"https:\/\/www.fullo.net\/blog\/2006\/04\/19\/qualche-problema-per-slimstat\/"},"author":{"name":"Francesco Fullone","@id":"https:\/\/www.fullo.net\/blog\/#\/schema\/person\/24e91bc6caea6c411a8668df5639428c"},"headline":"Qualche problema per SlimStat","datePublished":"2006-04-19T10:01:23+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fullo.net\/blog\/2006\/04\/19\/qualche-problema-per-slimstat\/"},"wordCount":216,"commentCount":15,"publisher":{"@id":"https:\/\/www.fullo.net\/blog\/#\/schema\/person\/24e91bc6caea6c411a8668df5639428c"},"keywords":["bug","database","optimization","slimstat","sql","stats","wordpress","wp"],"articleSection":["php"],"inLanguage":"it-IT","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fullo.net\/blog\/2006\/04\/19\/qualche-problema-per-slimstat\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fullo.net\/blog\/2006\/04\/19\/qualche-problema-per-slimstat\/","url":"https:\/\/www.fullo.net\/blog\/2006\/04\/19\/qualche-problema-per-slimstat\/","name":"Qualche problema per SlimStat - Fullo","isPartOf":{"@id":"https:\/\/www.fullo.net\/blog\/#website"},"datePublished":"2006-04-19T10:01:23+00:00","breadcrumb":{"@id":"https:\/\/www.fullo.net\/blog\/2006\/04\/19\/qualche-problema-per-slimstat\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fullo.net\/blog\/2006\/04\/19\/qualche-problema-per-slimstat\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fullo.net\/blog\/2006\/04\/19\/qualche-problema-per-slimstat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fullo.net\/blog\/"},{"@type":"ListItem","position":2,"name":"Qualche problema per SlimStat"}]},{"@type":"WebSite","@id":"https:\/\/www.fullo.net\/blog\/#website","url":"https:\/\/www.fullo.net\/blog\/","name":"Fullo","description":"nulla e' impossibile per chi non lo deve fare!","publisher":{"@id":"https:\/\/www.fullo.net\/blog\/#\/schema\/person\/24e91bc6caea6c411a8668df5639428c"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fullo.net\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"it-IT"},{"@type":["Person","Organization"],"@id":"https:\/\/www.fullo.net\/blog\/#\/schema\/person\/24e91bc6caea6c411a8668df5639428c","name":"Francesco Fullone","image":{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/i0.wp.com\/www.fullo.net\/blog\/wp-content\/uploads\/2024\/10\/hawiaina-gold-circled-white.png?fit=622%2C622&ssl=1","url":"https:\/\/i0.wp.com\/www.fullo.net\/blog\/wp-content\/uploads\/2024\/10\/hawiaina-gold-circled-white.png?fit=622%2C622&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.fullo.net\/blog\/wp-content\/uploads\/2024\/10\/hawiaina-gold-circled-white.png?fit=622%2C622&ssl=1","width":622,"height":622,"caption":"Francesco Fullone"},"logo":{"@id":"https:\/\/i0.wp.com\/www.fullo.net\/blog\/wp-content\/uploads\/2024\/10\/hawiaina-gold-circled-white.png?fit=622%2C622&ssl=1"},"sameAs":["http:\/\/www.fullo.net","https:\/\/www.linkedin.com\/in\/fullo","https:\/\/x.com\/fullo"],"url":"https:\/\/www.fullo.net\/blog\/author\/fullo\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3OSc1-v7","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":1680,"url":"https:\/\/www.fullo.net\/blog\/2005\/10\/05\/sql-designer\/","url_meta":{"origin":1929,"position":0},"title":"SQL Designer","author":"Francesco Fullone","date":"05\/10\/2005","format":false,"excerpt":"SQL Designer \u00e8 un'applicazione ajax enabled che serve a disegnare schemi ER. Con questo script \u00e8 possibile creare nuove tabelle, foreign key, aggiungere e rimuovere campi dalle tabelle come se nulla fosse e con un'interfaccia grafica pulita e molto semplice da usare. Inoltre le relazioni sono controllate e se viene\u2026","rel":"","context":"In "ajax"","block_context":{"text":"ajax","link":"https:\/\/www.fullo.net\/blog\/category\/tecnologia\/ajax\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2350,"url":"https:\/\/www.fullo.net\/blog\/2007\/10\/17\/sqlserver-driver-per-php-5\/","url_meta":{"origin":1929,"position":1},"title":"SQLServer driver per PHP 5","author":"Francesco Fullone","date":"17\/10\/2007","format":false,"excerpt":"Pare che Microsoft si sia svegliata ed abbia finalmente rilasciato un driver ufficiale per SQL Server 2005. Il driver supporta stream di dati, SQL parametrizzati ed ha a corredo, pare, una buona documentazione. Leggo per\u00f2 che a parte un discorso di chiusura del codice, opinabile in un linguaggio dichiaratamente OSS,\u2026","rel":"","context":"In "php"","block_context":{"text":"php","link":"https:\/\/www.fullo.net\/blog\/category\/tecnologia\/php\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":310,"url":"https:\/\/www.fullo.net\/blog\/2003\/06\/26\/phplinksdaogen\/","url_meta":{"origin":1929,"position":2},"title":"php::Links(‘daoGen’)","author":"Francesco Fullone","date":"26\/06\/2003","format":false,"excerpt":"Creare classi per la gestione di database non \u00e8 mai stato pi\u00f9 facile! Grazie a daoGen sar\u00e0 possibile creare e gestire un db in maniera semplice ed efficiente. Lo script, una volta immesse le specifiche del db ci creer\u00e0 4 file: il primo contentente la struttura SQL-compliant delle nostre tabelle,\u2026","rel":"","context":"In "tecnologia"","block_context":{"text":"tecnologia","link":"https:\/\/www.fullo.net\/blog\/category\/tecnologia\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":941,"url":"https:\/\/www.fullo.net\/blog\/2004\/07\/24\/phplinks-wact\/","url_meta":{"origin":1929,"position":3},"title":"PHP::Links(” wact “)","author":"Francesco Fullone","date":"24\/07\/2004","format":false,"excerpt":"Il progetto Web Application Component Toolkit (wact per gli amici) sta crescendo a vista d'occhio e nuovi pattern sono rilasciati sempre pi\u00f9 frequentemente. E per dimostrarne la validit\u00e0 Herry Fuecks sfida chiunque a realizzare un miglior metodo a Data Table Tag per la generazione dinamica di tabelle da query SQL,\u2026","rel":"","context":"In "php"","block_context":{"text":"php","link":"https:\/\/www.fullo.net\/blog\/category\/tecnologia\/php\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1688,"url":"https:\/\/www.fullo.net\/blog\/2005\/10\/10\/oracle-compra-innodb\/","url_meta":{"origin":1929,"position":4},"title":"Oracle compra InnoDB","author":"Francesco Fullone","date":"10\/10\/2005","format":false,"excerpt":"Con una mossa a sorpresa Oracle ha rilevato l'azienda open source Innobase. Azienda che non \u00e8 altro che la sviluppatrice delle tabelle InnoDB tanto care agli utenti MySQL. Bisogna ricordare che la tecnologia InnoDB \u00e8 infatti rilasciata con una licenza duale simile a quella di MySQL e che quindi (a\u2026","rel":"","context":"In "open source"","block_context":{"text":"open source","link":"https:\/\/www.fullo.net\/blog\/category\/tecnologia\/open-source\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2007,"url":"https:\/\/www.fullo.net\/blog\/2006\/07\/17\/firefox-xorg-e-flash\/","url_meta":{"origin":1929,"position":5},"title":"Firefox, Xorg e Flash","author":"Francesco Fullone","date":"17\/07\/2006","format":false,"excerpt":"Se mentre navigate vi schiatta improvvisamente firefox pare, quasi sicuramente, che il problema dipenda dall'ultimo aggiornamento di Xorg fatto sulle maggiori distribuzioni. Nello specifico per capire se \u00e8 questo il bug che vi affligge bisogner\u00e0 avviare firefox da shell e controllare se al crash si presenta il seguente messaggio: [code]Gdk-ERROR\u2026","rel":"","context":"In "linux"","block_context":{"text":"linux","link":"https:\/\/www.fullo.net\/blog\/category\/tecnologia\/linux\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/posts\/1929","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/comments?post=1929"}],"version-history":[{"count":0,"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/posts\/1929\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/media?parent=1929"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/categories?post=1929"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/tags?post=1929"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}