{"id":196,"date":"2008-09-04T11:05:07","date_gmt":"2008-09-04T09:05:07","guid":{"rendered":"http:\/\/www.work4net.it\/?p=196"},"modified":"2008-09-04T11:05:07","modified_gmt":"2008-09-04T09:05:07","slug":"verificare-le-performance-di-mysql-con-mysqltuner","status":"publish","type":"post","link":"https:\/\/www.italiamac.it\/work4net\/2008\/09\/verificare-le-performance-di-mysql-con-mysqltuner\/","title":{"rendered":"Verificare le performance di MySQL Server con MySQLTuner"},"content":{"rendered":"

MySQLTuner<\/a> \u00e8 uno script in perl che verifica le prestazioni del tuo Mysql Server<\/a> raccogliendo tutte le statistiche per poi restituire una serie di suggerimenti per ottimizzare le performance modificando il file my.cnf<\/em>.
\n
\nScaricate MySQLTuner script:<\/p>\n

wget http:\/\/mysqltuner.com\/mysqltuner.pl<\/p><\/blockquote>\n

Rendilo eseguibile:<\/p>\n

chmod +x mysqltuner.pl<\/p><\/blockquote>\n

\n
\nEseguilo:<\/p>\n

server1:~# .\/mysqltuner.pl<\/p><\/blockquote>\n

>> MySQLTuner 0.9.8 – Major Hayden
\n >> Bug reports, feature requests, and downloads at http:\/\/mysqltuner.com\/
\n >> Run with ‘–help’ for additional options and output filtering
\nPlease enter your MySQL administrative login: <-- root<\/strong>
\nPlease enter your MySQL administrative password: <-- yourrootsqlpassword<\/strong><\/p>\n

——– General Statistics ————————————————–
\n[–] Skipped version check for MySQLTuner script
\n[!!] Your MySQL version 4.1.11-Debian_etch1-log is EOL software! Upgrade soon!
\n[OK] Operating on 32-bit architecture with less than 2GB RAM<\/p>\n

——– Storage Engine Statistics ——————————————-
\n[–] Status: +Archive -BDB -Federated +InnoDB +ISAM -NDBCluster
\n[–] Data in MyISAM tables: 301M (Tables: 2074)
\n[–] Data in HEAP tables: 379K (Tables: 9)
\n[!!] InnoDB is enabled but isn’t being used
\n[!!] ISAM is enabled but isn’t being used
\n[!!] Total fragmented tables: 215<\/p>\n

——– Performance Metrics ————————————————-
\n[–] Up for: 12d 18h 33m 30s (1B q [1K qps], 185K conn, TX: 3B, RX: 377M)
\n[–] Reads \/ Writes: 78% \/ 22%
\n[–] Total buffers: 2.6M per thread and 58.0M global
\n[OK] Maximum possible memory usage: 320.5M (20% of installed RAM)
\n[OK] Slow queries: 0% (17\/1B)
\n[OK] Highest usage of available connections: 32% (32\/100)
\n[OK] Key buffer size \/ total MyISAM indexes: 16.0M\/72.3M
\n[OK] Key buffer hit rate: 99.9%
\n[OK] Query cache efficiency: 99.9%
\n[!!] Query cache prunes per day: 47549
\n[OK] Sorts requiring temporary tables: 0%
\n[!!] Temporary tables created on disk: 28%
\n[OK] Thread cache hit rate: 99%
\n[!!] Table cache hit rate: 0%
\n[OK] Open file limit used: 12%
\n[OK] Table locks acquired immediately: 99%
\n[!!] Connections aborted: 20%<\/p>\n

——– Recommendations —————————————————–
\nGeneral recommendations:
\n Add skip-innodb to MySQL configuration to disable InnoDB
\n Add skip-isam to MySQL configuration to disable ISAM
\n Run OPTIMIZE TABLE to defragment tables for better performance
\n Enable the slow query log to troubleshoot bad queries
\n When making adjustments, make tmp_table_size\/max_heap_table_size equal
\n Reduce your SELECT DISTINCT queries without LIMIT clauses
\n Increase table_cache gradually to avoid file descriptor limits
\n Your applications are not closing MySQL connections properly
\nVariables to adjust:
\n query_cache_size (> 16M)
\n tmp_table_size (> 32M)
\n max_heap_table_size (> 16M)
\n table_cache (> 64)<\/p>\n

server1:~#<\/p>\n","protected":false},"excerpt":{"rendered":"

MySQLTuner \u00e8 uno script in perl che verifica le prestazioni del tuo Mysql Server raccogliendo tutte le statistiche per poi restituire una serie di suggerimenti per ottimizzare le performance modificando il file my.cnf. Scaricate MySQLTuner script: wget http:\/\/mysqltuner.com\/mysqltuner.pl Rendilo eseguibile: chmod +x mysqltuner.pl<\/p>\n","protected":false},"author":2,"featured_media":1322,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[41,7],"tags":[198,830,831,832,833],"class_list":["post-196","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-opensource","category-tutorial","tag-mysql","tag-mysql-server","tag-mysqltuner","tag-performance","tag-sql"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.italiamac.it\/work4net\/wp-content\/uploads\/2013\/08\/feat_generic.jpg?fit=1022%2C573&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/p8fSv5-3a","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":346,"url":"https:\/\/www.italiamac.it\/work4net\/2008\/10\/sript-shell-per-eseguire-backup-di-tutti-db-mysql-in-remoto-via-ftp\/","url_meta":{"origin":196,"position":0},"title":"Script Shell per eseguire Backup di tutti db Mysql in remoto via FTP","author":"Dev","date":"22 Ottobre 2008","format":false,"excerpt":"Questo script permette di fare il backup di ciascuna tabella di ogni database (un file per tabella),, compattando il tutto alla fine per poi inviarlo via FTP sul server di backup. #!\/bin\/sh # System + MySQL backup script # Copyright (c) 2008 Marchost # This script is licensed under GNU\u2026","rel":"","context":"In "Opensource"","block_context":{"text":"Opensource","link":"https:\/\/www.italiamac.it\/work4net\/category\/opensource\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.italiamac.it\/work4net\/wp-content\/uploads\/2013\/08\/feat_generic.jpg?fit=1022%2C573&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.italiamac.it\/work4net\/wp-content\/uploads\/2013\/08\/feat_generic.jpg?fit=1022%2C573&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.italiamac.it\/work4net\/wp-content\/uploads\/2013\/08\/feat_generic.jpg?fit=1022%2C573&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.italiamac.it\/work4net\/wp-content\/uploads\/2013\/08\/feat_generic.jpg?fit=1022%2C573&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":88,"url":"https:\/\/www.italiamac.it\/work4net\/2008\/05\/non-mi-ricordo-piu-la-password-del-server-mysql\/","url_meta":{"origin":196,"position":1},"title":"Non mi ricordo pi\u00f9 la password del server MySQL","author":"Dev","date":"15 Maggio 2008","format":false,"excerpt":"Esiste una modalit\u00e0 semplice per recuperare la password del server MySQL se non la si ha o non la si ricorda: 1 - Stoppare MySQL # \/etc\/init.d\/mysql stop 2 - Avviare mysql senza le GRANT TABLES # \/usr\/bin\/mysqld_safe --skip-grant-tables 3 - Accedere alla tabella mysql # mysql -u root mysql\u2026","rel":"","context":"In "Opensource"","block_context":{"text":"Opensource","link":"https:\/\/www.italiamac.it\/work4net\/category\/opensource\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.italiamac.it\/work4net\/wp-content\/uploads\/2013\/08\/feat_generic.jpg?fit=1022%2C573&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.italiamac.it\/work4net\/wp-content\/uploads\/2013\/08\/feat_generic.jpg?fit=1022%2C573&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.italiamac.it\/work4net\/wp-content\/uploads\/2013\/08\/feat_generic.jpg?fit=1022%2C573&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.italiamac.it\/work4net\/wp-content\/uploads\/2013\/08\/feat_generic.jpg?fit=1022%2C573&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":804,"url":"https:\/\/www.italiamac.it\/work4net\/2009\/08\/come-installare-vmware-server-20-su-centos-53\/","url_meta":{"origin":196,"position":2},"title":"Come Installare VMware Server 2.0 su CentOS 5.3","author":"Dev","date":"20 Agosto 2009","format":false,"excerpt":"In questo tutorial voglio spiegare come installare VMware Server 2.0 su CentOS 5.3 con pochi semplici passi. 1. Creare Account VMware per potersi loggare e scaricare l\u2019ultima versione corrente e successivamente ricevere, via mail, i codici di attivazione 2. Scaricare la versione VMServer 2.0 RPM (ci sono 2 versioni una\u2026","rel":"","context":"In "Opensource"","block_context":{"text":"Opensource","link":"https:\/\/www.italiamac.it\/work4net\/category\/opensource\/"},"img":{"alt_text":"vmware","src":"https:\/\/i0.wp.com\/www.work4net.it\/immagini\/2009\/08\/vmware-300x233.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":167,"url":"https:\/\/www.italiamac.it\/work4net\/2008\/08\/batch-file-upload-automatico-con-windows-xp\/","url_meta":{"origin":196,"position":3},"title":"Batch File Upload Automatico con Windows XP","author":"Dev","date":"16 Agosto 2008","format":false,"excerpt":"Adottando gli stratagemmi pi\u00f9 vari, si pu\u00f2 ottenere anche da Windows qualcosa di vagamente simile al comportamento di `cron` sui server Linux. Solo vagamente, non voglio illudere nessuno. Per\u00f2 si pu\u00f2 fare. Ecco come. Supponiamo di dover spostare ogni ora una copia del file PROVA.TXT sul seguente server FTP: host:\u2026","rel":"","context":"In "Tutorial"","block_context":{"text":"Tutorial","link":"https:\/\/www.italiamac.it\/work4net\/category\/tutorial\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.italiamac.it\/work4net\/wp-content\/uploads\/2013\/08\/feat_generic.jpg?fit=1022%2C573&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.italiamac.it\/work4net\/wp-content\/uploads\/2013\/08\/feat_generic.jpg?fit=1022%2C573&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.italiamac.it\/work4net\/wp-content\/uploads\/2013\/08\/feat_generic.jpg?fit=1022%2C573&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.italiamac.it\/work4net\/wp-content\/uploads\/2013\/08\/feat_generic.jpg?fit=1022%2C573&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":788,"url":"https:\/\/www.italiamac.it\/work4net\/2009\/07\/come-controllare-le-vulnerabilita-di-un-server-web-con-nikto\/","url_meta":{"origin":196,"position":4},"title":"Come controllare le vulnerabilit\u00e0 di un server Web con Nikto","author":"Dev","date":"19 Luglio 2009","format":false,"excerpt":"Nikto \u00e8 uno scanner di server Web Open Source (GNU GPL) che esegue la scansione di un web server alla ricerca di pi\u00f9 di 3500 file pericolosi\/CGI, versioni obsolete ecc... con un'ottima gestione e supporto dei plug-in. Di semplice installazione su ubuntu: $ sudo apt-get install nikto","rel":"","context":"In "Opensource"","block_context":{"text":"Opensource","link":"https:\/\/www.italiamac.it\/work4net\/category\/opensource\/"},"img":{"alt_text":"niktoshibu","src":"https:\/\/i0.wp.com\/www.work4net.it\/immagini\/2009\/07\/niktoshibu.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":181,"url":"https:\/\/www.italiamac.it\/work4net\/2008\/08\/come-installare-vmware-server-version-106-su-ubuntu-804-desktop\/","url_meta":{"origin":196,"position":5},"title":"Come Installare VMware Server (Version 1.0.6) su Ubuntu 8.04 Desktop","author":"Dev","date":"31 Agosto 2008","format":false,"excerpt":"1. Note Preliminari Scaricare la versione 1.0.6 (rilasciata il May 29, 2008), per le altre versioni 1.0.6 di release diversa \u00e8 necessario installare una patch per supportare il kernel 2.6.24 (vedi qui). 2. Installare VMware Server Scaricare VMware Server, da http:\/\/www.vmware.com\/download\/server\/ cliccando su Download Now: Accetta la licenza. Scarica VMware\u2026","rel":"","context":"In "Opensource"","block_context":{"text":"Opensource","link":"https:\/\/www.italiamac.it\/work4net\/category\/opensource\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.work4net.it\/immagini\/2008\/08\/1-300x225.jpg?resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.italiamac.it\/work4net\/wp-json\/wp\/v2\/posts\/196","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.italiamac.it\/work4net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.italiamac.it\/work4net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.italiamac.it\/work4net\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.italiamac.it\/work4net\/wp-json\/wp\/v2\/comments?post=196"}],"version-history":[{"count":0,"href":"https:\/\/www.italiamac.it\/work4net\/wp-json\/wp\/v2\/posts\/196\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.italiamac.it\/work4net\/wp-json\/wp\/v2\/media\/1322"}],"wp:attachment":[{"href":"https:\/\/www.italiamac.it\/work4net\/wp-json\/wp\/v2\/media?parent=196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.italiamac.it\/work4net\/wp-json\/wp\/v2\/categories?post=196"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.italiamac.it\/work4net\/wp-json\/wp\/v2\/tags?post=196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}