Jump to content

tesimanq

Members
  • Content Count

    55
  • Joined

  • Last visited

  1. tesimanq

    HelloSpace 10gb di spazio

    Questa mattina su hellospace abbiamo pubblicato l'annuncio nel forum di offrire solo ai nuovi iscritti: 10 GB di spazio web 10 TB di traffico 10 Database mysql 10 Account ftp HelloSpace.net Spazio Gratuito Hosting Free PHP MySQL
  2. Salve possiedo un server in cui risiedono diversi siti che generano circa 40.000 visite uniche al giorno.. mi capita spesso che mentre sto navigando tra un sito all'altro mi esce impossibile visualizzare la pagina, mentre ad altre persone carica tranquillamente.. il che significa che le connessioni vengono killate perchè troppe.. è possibile creare una configurazione ottimale per mpm worker? Al momento sono su debian5 64bit con apache2.2 e suphp attivo con questi moduli abilitati: actions.conf alias.load authz_default.load authz_user.load bw.load dir.conf fastcgi.conf info.load mod-evasive.load rewrite.load status.conf suphp.load actions.load auth_basic.load authz_groupfile.load autoindex.conf cgid.conf dir.load fastcgi.load mime.conf negotiation.conf setenvif.conf status.load unique_id.load alias.conf authn_file.load authz_host.load autoindex.load cgid.load env.load info.conf mime.load negotiation.load setenvif.load suphp.conf il server è il seguente: Intel Xeon Quad 4x 2.83+ GHz 8 GB DDR2 2x 750 GB - SATA2 in raid 1 soft la mia attuale configurazione è fatta a caso perchè non so proprio come configurare worker anche basandomi sul manuale :( qualcuno mi aiuta? :(
  3. Non per intromettermi, ma per macchina piccola cosa intendete? perchè supponendo che si voglia mettere sul primo kimsufi vi do ragione, ma se si vuol mettere sull'ultimo? i7 920 4x 2x 2.66+ GHz 12 GBRAM RAID 0/1/5/6 l'hard disk sicuramente non sarà un sas, però...
  4. Già fatto, ho aumentato a tipo 256000 ma non si è risolto.. non so proprio piu che fare, ho pensato che qualche mod facesse andare in errore, e ho provato a disattivare tutto, ma niente :( help me please :(
  5. Ciao a tutti, è dalle 17 di oggi apache cade all'improvviso in continuazione... premetto che non ho toccato nulla e che erano giorni e giorni che andava tutto ok.. in error.log mi dà queste voci: [Mon Nov 16 20:56:25 2009] [info] [client 82.52.78.107] (9)Bad file descriptor: core_output_filter: writing data to the network [Mon Nov 16 20:56:25 2009] [warn] child process 23960 still did not exit, sending a SIGTERM [Mon Nov 16 20:56:25 2009] [warn] child process 23963 still did not exit, sending a SIGTERM [Mon Nov 16 20:56:25 2009] [warn] child process 24202 still did not exit, sending a SIGTERM [Mon Nov 16 20:56:25 2009] [warn] child process 24266 still did not exit, sending a SIGTERM [Mon Nov 16 20:56:25 2009] [warn] child process 24269 still did not exit, sending a SIGTERM [Mon Nov 16 20:56:27 2009] [warn] child process 23960 still did not exit, sending a SIGTERM [Mon Nov 16 20:56:27 2009] [warn] child process 23963 still did not exit, sending a SIGTERM [Mon Nov 16 20:56:27 2009] [warn] child process 24202 still did not exit, sending a SIGTERM [Mon Nov 16 20:56:27 2009] [warn] child process 24266 still did not exit, sending a SIGTERM [Mon Nov 16 20:56:27 2009] [warn] child process 24269 still did not exit, sending a SIGTERM [Mon Nov 16 20:56:27 2009] [info] [client 87.20.202.95] (9)Bad file descriptor: core_output_filter: writing data to the network [Mon Nov 16 20:56:29 2009] [error] child process 23960 still did not exit, sending a SIGKILL [Mon Nov 16 20:56:29 2009] [error] child process 23963 still did not exit, sending a SIGKILL [Mon Nov 16 20:56:29 2009] [error] child process 24202 still did not exit, sending a SIGKILL [Mon Nov 16 20:56:29 2009] [error] child process 24266 still did not exit, sending a SIGKILL [Mon Nov 16 20:56:29 2009] [error] child process 24269 still did not exit, sending a SIGKILL [Mon Nov 16 20:56:30 2009] [notice] caught SIGTERM, shutting down [Mon Nov 16 20:56:31 2009] [error] (24)Too many open files: could not open transfer log file /var/log/apache_common_access_log. Non riesco proprio a risolvere, please mi date una dritta? :icon_rolleyes:
  6. Ragà ho notato che in syslog ci sono sfilze continue di errori del genere: Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_pagelinks.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_protected_titles.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_protected_titles.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_querycache.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_querycache.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_querycache_info.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_querycache_info.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_querycachetwo.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_querycachetwo.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_recentchanges.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_recentchanges.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_redirect.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_redirect.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_revision.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_revision.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_site_stats.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_site_stats.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_tag_summary.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_tag_summary.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_templatelinks.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_templatelinks.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_text.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_text.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_trackbacks.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_trackbacks.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_transcache.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_transcache.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_updatelog.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_updatelog.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_user.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_user.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_user_groups.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_user_groups.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_user_newtalk.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_user_newtalk.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_valid_tag.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_valid_tag.frm' Oct 25 23:36:40 ****** mysqld[31849]: 091025 23:36:40 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mydb/table_watchlist.frm' Possibile che sia questo il problema? sapete come risolvere?
  7. Grazie dell'aiuto, ho provato, ma nada.. credo proprio che sia il raid soft... è un bel guaio... mmm
  8. Sono in raid1 software.. in che senso?
  9. Potrebbe essere che avendo installato eaccelerator e zend optimizer insieme rallentano la scrittura al disco?
  10. Nessuno che abbia una soluzione? :(
  11. Ho fatto anche repair.. ogni tanto mi usciva note : The storage engine for the table doesn't support repair.. Comunque non si è risolto ancora :( ma non c'è nessun applicativo che dice cosa è in esecuzione per lungo tempo da far rallentare tutto? perchè a quanto ho capito apache e mysql non è che rallentano tanto..
  12. Ho portato a 300 max connections e ottimizzato tutte le tabelle (molte sono uscite corrotte).. vediamo se in quest'ora mi arriva una email di munin come ha fatto tutta la giornata... Usu queste sono le informazioni: velocità cpu / singolo o multiprocessore: CPU number: 4 model name : Intel® Xeon® CPU X3360 @ 2.83GHz model name : Intel® Xeon® CPU X3360 @ 2.83GHz model name : Intel® Xeon® CPU X3360 @ 2.83GHz model name : Intel® Xeon® CPU X3360 @ 2.83GHz cpu MHz : 2830.000 cpu MHz : 2830.000 cpu MHz : 2830.000 cpu MHz : 2830.000 cache size : 6144 KB cache size : 6144 KB cache size : 6144 KB cache size : 6144 KB Ram: Memory: used free (MB) 1269 6612 Tipo HD/configurazione: ATA Hitachi HDS72107 (Direct-Access) RAID 1 / software Sistema Operativo: Debian Lenny apache version: 2.2.9 (Debian) PHP version: 5.2.6-1+lenny3 MySQL version: 5.0.51a TOP: top - 20:04:52 up 43 days, 10:25, 1 user, load average: 11.17, 8.92, 8.34 Tasks: 248 total, 2 running, 235 sleeping, 0 stopped, 11 zombie Cpu(s): 10.6%us, 5.9%sy, 0.0%ni, 77.1%id, 6.1%wa, 0.0%hi, 0.2%si, 0.0%st Mem: 8072020k total, 7980704k used, 91316k free, 706012k buffers Swap: 36869152k total, 1672756k used, 35196396k free, 5339436k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 12630 nomesito1 20 0 119m 11m 5332 R 25 0.1 0:00.13 php-cgi 12628 nomesito2 20 0 0 0 0 Z 23 0.0 0:00.12 php-cgi <defunct> 12631 nomesito3 20 0 0 0 0 Z 19 0.0 0:00.10 php-cgi <defunct> 12634 root 20 0 0 0 0 Z 19 0.0 0:00.10 php-cgi <defunct> 30714 root 20 0 271m 33m 9592 D 12 0.4 0:20.31 php 20625 mysql 20 0 1262m 321m 5488 S 6 4.1 6:12.00 mysqld 9690 www-data 20 0 454m 54m 1504 S 2 0.7 0:01.11 apache2 9736 www-data 20 0 466m 56m 1912 S 2 0.7 0:01.05 apache2 1 root 20 0 10312 608 572 S 0 0.0 0:11.48 init 2 root 15 -5 0 0 0 S 0 0.0 0:00.01 kthreadd 3 root RT -5 0 0 0 S 0 0.0 0:29.63 migration/0 4 root 15 -5 0 0 0 S 0 0.0 2:47.85 ksoftirqd/0 5 root RT -5 0 0 0 S 0 0.0 0:50.78 migration/1 6 root 15 -5 0 0 0 S 0 0.0 2:20.60 ksoftirqd/1 7 root RT -5 0 0 0 S 0 0.0 1:15.03 migration/2 8 root 15 -5 0 0 0 S 0 0.0 1:31.28 ksoftirqd/2 9 root RT -5 0 0 0 S 0 0.0 1:23.50 migration/3 10 root 15 -5 0 0 0 S 0 0.0 1:10.42 ksoftirqd/3 11 root 15 -5 0 0 0 S 0 0.0 0:22.30 events/0 12 root 15 -5 0 0 0 S 0 0.0 0:18.18 events/1 13 root 15 -5 0 0 0 S 0 0.0 1:13.45 events/2 14 root 15 -5 0 0 0 S 0 0.0 0:27.10 events/3 15 root 15 -5 0 0 0 S 0 0.0 0:00.00 khelper 19 root RT -5 0 0 0 S 0 0.0 0:00.00 kstop/0 20 root RT -5 0 0 0 S 0 0.0 0:00.00 kstop/1 21 root RT -5 0 0 0 S 0 0.0 0:00.00 kstop/2 22 root RT -5 0 0 0 S 0 0.0 0:00.00 kstop/3 161 root 15 -5 0 0 0 S 0 0.0 0:00.00 kintegrityd/0 162 root 15 -5 0 0 0 S 0 0.0 0:00.00 kintegrityd/1 163 root 15 -5 0 0 0 S 0 0.0 0:00.00 kintegrityd/2 164 root 15 -5 0 0 0 S 0 0.0 0:00.00 kintegrityd/3 165 root 15 -5 0 0 0 S 0 0.0 0:06.77 kblockd/0 166 root 15 -5 0 0 0 S 0 0.0 0:02.09 kblockd/1 167 root 15 -5 0 0 0 S 0 0.0 0:04.88 kblockd/2 168 root 15 -5 0 0 0 S 0 0.0 0:02.33 kblockd/3 169 root 15 -5 0 0 0 S 0 0.0 0:00.00 kacpid 170 root 15 -5 0 0 0 S 0 0.0 0:00.00 kacpi_notify 238 root 15 -5 0 0 0 S 0 0.0 0:00.00 ata/0 239 root 15 -5 0 0 0 S 0 0.0 0:00.00 ata/1 KeepAlive On MaxKeepAliveRequests 100 KeepAliveTimeout 15 <IfModule mpm_prefork_module> StartServers 5 MinSpareServers 5 MaxSpareServers 10 MaxClients 150 MaxRequestsPerChild 0 </IfModule> <IfModule mpm_worker_module> StartServers 2 MaxClients 150 MinSpareThreads 25 MaxSpareThreads 75 ThreadsPerChild 25 MaxRequestsPerChild 0 </IfModule> con find / -size +2000000k non ha dato risultatiuname - a: Linux ******** 2.6.28.4-xxxx-std-ipv6-64 #4 SMP Wed Sep 9 22:10:20 UTC 2009 x86_64 GNU/Linux ulimit -aH core file size (blocks, -c) unlimited data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 71680 max locked memory (kbytes, -l) 64 max memory size (kbytes, -m) unlimited open files (-n) 16000 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 real-time priority (-r) 0 stack size (kbytes, -s) unlimited cpu time (seconds, -t) unlimited max user processes (-u) 71680 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited Spero di aver dato informazioni utili... nel frattempo munin mi ha inviato un altra email di Load average WARNINGs: load is 11.51 (outside range [:10]) :(
  13. max connections non dovrebbe essere uguale a 1/2 della ram? (invece di 4000 ho messo 3000) comunque ho pensato che visto ho la ram libera la sfrutto... avrò anche sbagliato, ma era una prova.. :( mysql> show processlist; +-------+----------+-----------+------------+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+----------+-----------+------------+---------+------+-------+------------------+ | 31134 | root | localhost | NULL | Query | 0 | NULL | show processlist | | 31144 | sito | localhost | dbsito | Sleep | 0 | | NULL | +-------+----------+-----------+------------+---------+------+-------+------------------+ 3 rows in set (0.00 sec)
  14. # # The MySQL database server configuration file. # # You can copy this to one of: # - "/etc/mysql/my.cnf" to set global options, # - "~/.my.cnf" to set user-specific options. # # One can use all long options that the program supports. # Run program with --help to get a list of available options and with # --print-defaults to see which it would actually understand and use. # # For explanations see # MySQL :: MySQL 5.1 Reference Manual :: 5.1.4 Server System Variables # This will be passed to all mysql clients # It has been reported that passwords should be enclosed with ticks/quotes # escpecially if they contain "#" chars... # Remember to edit /etc/mysql/debian.cnf when changing the socket location. [client] port = 3306 socket = /var/run/mysqld/mysqld.sock # Here is entries for some specific programs # The following values assume you have at least 32M ram # This was formally known as [safe_mysqld]. Both versions are currently parsed. [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] tmp_table_size = 256M max_heap_table_size = 256M # # * Basic Settings # user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english skip-external-locking # # Instead of skip-networking the default is now to listen only on # localhost which is more compatible and is not less secure. bind-address = 127.0.0.1 # # * Fine Tuning # key_buffer = 500M max_allowed_packet = 16M thread_stack = 128K thread_cache_size = 8 # This replaces the startup script and checks MyISAM tables if needed # the first time they are touched myisam-recover = BACKUP max_connections = 3000 table_cache = 3000 #thread_concurrency = 10 # # * Query Cache Configuration # query_cache_limit = 1M query_cache_size = 500M # # * Logging and Replication # # Both location gets rotated by the cronjob. # Be aware that this log type is a performance killer. #log = /var/log/mysql/mysql.log # # Error logging goes to syslog. This is a Debian improvement :) # # Here you can see queries with especially long duration log_slow_queries = /var/log/mysql/mysql-slow.log #long_query_time = 2 #log-queries-not-using-indexes # # The following can be used as easy to replay backup logs or for replication. # note: if you are setting up a replication slave, see README.Debian about # other settings you may need to change. #server-id = 1 #log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 10 max_binlog_size = 100M #binlog_do_db = include_database_name #binlog_ignore_db = include_database_name # # * BerkeleyDB # # Using BerkeleyDB is now discouraged as its support will cease in 5.1.12. skip-bdb # # * InnoDB # # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/. # Read the manual for more InnoDB related options. There are many! # You might want to disable InnoDB to shrink the mysqld process by circa 100MB. skip-innodb # # * Security Features # # Read the manual, too, if you want chroot! # chroot = /var/lib/mysql/ # # For generating SSL certificates I recommend the OpenSSL GUI "tinyca". # # ssl-ca=/etc/mysql/cacert.pem # ssl-cert=/etc/mysql/server-cert.pem # ssl-key=/etc/mysql/server-key.pem [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] #no-auto-rehash # faster start of mysql but no tab completition [isamchk] key_buffer = 16M # # * NDB Cluster # # See /usr/share/doc/mysql-server-*/README.Debian for more information. # # The following configuration is read by the NDB Data Nodes (ndbd processes) # not from the NDB Management Nodes (ndb_mgmd processes). # # [MYSQL_CLUSTER] # ndb-connectstring=127.0.0.1 # # * IMPORTANT: Additional settings that can override those from this file! # The files must end with '.cnf', otherwise they'll be ignored. # !includedir /etc/mysql/conf.d/ bind-address=127.0.0.1
  15. Ps aux mi ha dato tutti [php-cgi] mysqltuner dopo le modifiche mi da: -------- General Statistics -------------------------------------------------- [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.0.51a-24+lenny2-log [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: +Archive -BDB -Federated -InnoDB -ISAM -NDBCluster [--] Data in MyISAM tables: 586M (Tables: 27039) [--] Data in MEMORY tables: 124K (Tables: 53) [!!] Total fragmented tables: 893 -------- Performance Metrics ------------------------------------------------- [--] Up for: 34m 10s (481K q [234.942 qps], 30K conn, TX: 548M, RX: 33M) [--] Reads / Writes: 64% / 36% [--] Total buffers: 1.2G global + 2.6M per thread (3000 max threads) [!!] Maximum possible memory usage: 8.9G (115% of installed RAM) [OK] Slow queries: 0% (16/481K) [OK] Highest usage of available connections: 0% (16/3000) [OK] Key buffer size / total MyISAM indexes: 500.0M/223.7M [OK] Key buffer hit rate: 99.8% (98M cached / 183K reads) [OK] Query cache efficiency: 28.6% (71K cached / 251K selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 0% (2 temp sorts / 2K sorts) [!!] Temporary tables created on disk: 31% (1K on disk / 3K total) [OK] Thread cache hit rate: 99% (30 created / 30K connections) [!!] Table cache hit rate: 1% (3K open / 235K opened) [OK] Open file limit used: 37% (5K/16K) [OK] Table locks acquired immediately: 96% (245K immediate / 254K locks) -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance MySQL started within last 24 hours - recommendations may be inaccurate Reduce your overall MySQL memory footprint for system stability Temporary table size is already large - reduce result set size Reduce your SELECT DISTINCT queries without LIMIT clauses Increase table_cache gradually to avoid file descriptor limits Variables to adjust: *** MySQL's maximum memory usage is dangerously high *** *** Add RAM before increasing MySQL buffer variables *** table_cache (> 3000)
×