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_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_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}},"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=\"en_US\" \/>\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 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=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Francesco Fullone\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\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\":\"en-US\",\"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\":\"en-US\",\"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\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/#\\\/schema\\\/person\\\/24e91bc6caea6c411a8668df5639428c\",\"name\":\"Francesco Fullone\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@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":"en_US","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","author":"Francesco Fullone","twitter_card":"summary_large_image","twitter_creator":"@fullo","twitter_site":"@fullo","twitter_misc":{"Written by":"Francesco Fullone","Est. reading time":"1 minute"},"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":"en-US","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":"en-US","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":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.fullo.net\/blog\/#\/schema\/person\/24e91bc6caea6c411a8668df5639428c","name":"Francesco Fullone","image":{"@type":"ImageObject","inLanguage":"en-US","@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":1911,"url":"https:\/\/www.fullo.net\/blog\/2006\/04\/03\/slimstat-statistiche-per-wordpress\/","url_meta":{"origin":1929,"position":0},"title":"SlimStat, statistiche per WordPress","author":"Francesco Fullone","date":"03\/04\/2006","format":false,"excerpt":"Finalmente ho trovato un degno successore a ShortStats per Wordpress, ed \u00e8 tutto italiano! Si tratta dell'ottimo SlimStats. Questo plugin permette di importare il vecchio db di shortstats e di gestirlo a pieno. Le features del plugin sono pi\u00f9 o meno le stesse di quelle del suo \"genitore\" inoltre \u00e8\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":1680,"url":"https:\/\/www.fullo.net\/blog\/2005\/10\/05\/sql-designer\/","url_meta":{"origin":1929,"position":1},"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":2},"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":3},"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":595,"url":"https:\/\/www.fullo.net\/blog\/2003\/12\/09\/phplinks-persistance-layers\/","url_meta":{"origin":1929,"position":4},"title":"php::Links(‘ Persistance Layers ‘);","author":"Francesco Fullone","date":"09\/12\/2003","format":false,"excerpt":"stasera ho scoperto il mondo dei Persistance Layers. Questi non sono altro che delle classi PHP per la gestione di database come se fossero oggetti, ed \u00e8 quindi possibile aggiungere valori, modificarli o creare nuove strutture in modo semplice ed immediato. A persistence layer encapsulates the behaviour needed to make\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":1688,"url":"https:\/\/www.fullo.net\/blog\/2005\/10\/10\/oracle-compra-innodb\/","url_meta":{"origin":1929,"position":5},"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":[]}],"_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}]}}