Skocz do zawartości

Elber

Użytkownicy
 Wyświetl profil  Zobacz jego aktywność

  • Zawartość

    93

  • Rejestracja

  • Ostatnio

Posty napisane przez Elber

  3. Napisano · Raportuj odpowiedź

    Witam, mam pytanie, mam serwer w serwerowni i potrzebuję na nim zainstalować środowisko graficzne oraz dostęp do tego serwera za pomocą pulpitu zdalnego. Zależy im na tym aby to wszystko dość płynnie chodziło i nie muliło. Zastanawiam się jakie środowisko zainstalować czy gnome czy xfce oraz jak rozwiązać sprawę z pulpitem zdalnym, aby była możliwość dostępu przez kilku użytkowników na raz, czyli kilka sesji.

     

    cat /proc/cpuinfo

    processor : 0

    vendor_id : AuthenticAMD

    cpu family : 15

    model : 75

    model name : AMD Athlon 64 X2 Dual Core Processor 3400+

    stepping : 2

    cpu MHz : 1808.261

    cache size : 512 KB

    cat /proc/meminfo

    MemTotal: 3370288 kB

    MemFree: 3061688 kB

    Buffers: 14316 kB

  5. Napisano · Raportuj odpowiedź

    Ok, najświeższy wynik z mysqltuner'a, Co jeszcze mogę zmienić i na jakie wartości ?

     

    ------- General Statistics --------------------------------------------------

    [--] Skipped version check for MySQLTuner script

    [OK] Currently running supported MySQL version 5.0.51a-24+lenny4

    [!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM

     

    -------- Storage Engine Statistics -------------------------------------------

    [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster

    [--] Data in MyISAM tables: 1004M (Tables: 918)

    [--] Data in InnoDB tables: 22M (Tables: 30)

    [--] Data in MEMORY tables: 1011K (Tables: 12)

    [!!] Total fragmented tables: 49

     

    -------- Performance Metrics -------------------------------------------------

    [--] Up for: 1d 13h 34m 1s (7M q [56.611 qps], 517K conn, TX: 844M, RX: 2B)

    [--] Reads / Writes: 85% / 15%

    [--] Total buffers: 96.0M global + 2.6M per thread (100 max threads)

    [OK] Maximum possible memory usage: 358.5M (9% of installed RAM)

    [OK] Slow queries: 0% (219/7M)

    [OK] Highest usage of available connections: 34% (34/100)

    [OK] Key buffer size / total MyISAM indexes: 32.0M/491.7M

    [OK] Key buffer hit rate: 95.5% (74M cached / 3M reads)

    [OK] Query cache efficiency: 71.0% (4M cached / 5M selects)

    [!!] Query cache prunes per day: 274415

    [OK] Sorts requiring temporary tables: 0% (3K temp sorts / 379K sorts)

    [!!] Joins performed without indexes: 627

    [OK] Temporary tables created on disk: 1% (4K on disk / 348K total)

    [OK] Thread cache hit rate: 99% (675 created / 517K connections)

    [!!] Table cache hit rate: 0% (64 open / 231K opened)

    [OK] Open file limit used: 11% (116/1K)

    [OK] Table locks acquired immediately: 99% (3M immediate / 3M locks)

    [OK] InnoDB data size / buffer pool: 22.3M/30.0M

     

    -------- Recommendations -----------------------------------------------------

    General recommendations:

    Run OPTIMIZE TABLE to defragment tables for better performance

    Enable the slow query log to troubleshoot bad queries

    Adjust your join queries to always utilize indexes

    Increase table_cache gradually to avoid file descriptor limits

    Variables to adjust:

    query_cache_size (> 16M)

    join_buffer_size (> 128.0K, or always use indexes with joins)

    table_cache (> 64)

  7. Napisano · Raportuj odpowiedź

    Ok następny wynik z mysqltuner'a teraz już po 24 h. Co na podstawie tego zrobić ?

     

    -------- General Statistics --------------------------------------------------

    [--] Skipped version check for MySQLTuner script

    [OK] Currently running supported MySQL version 5.0.51a-24+lenny4

    [!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM

     

    -------- Storage Engine Statistics -------------------------------------------

    [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster

    [--] Data in MyISAM tables: 1009M (Tables: 918)

    [--] Data in InnoDB tables: 25M (Tables: 30)

    [--] Data in MEMORY tables: 1011K (Tables: 12)

    [!!] Total fragmented tables: 136

     

    -------- Performance Metrics -------------------------------------------------

    [--] Up for: 1d 2h 2m 16s (5M q [59.634 qps], 377K conn, TX: 3B, RX: 1B)

    [--] Reads / Writes: 85% / 15%

    [--] Total buffers: 58.0M global + 2.6M per thread (100 max threads)

    [OK] Maximum possible memory usage: 320.5M (8% of installed RAM)

    [OK] Slow queries: 0% (2/5M)

    [OK] Highest usage of available connections: 25% (25/100)

    [OK] Key buffer size / total MyISAM indexes: 16.0M/574.4M

    [OK] Key buffer hit rate: 97.3% (51M cached / 1M reads)

    [OK] Query cache efficiency: 70.8% (3M cached / 4M selects)

    [!!] Query cache prunes per day: 299400

    [OK] Sorts requiring temporary tables: 0% (2K temp sorts / 271K sorts)

    [!!] Joins performed without indexes: 485

    [OK] Temporary tables created on disk: 1% (2K on disk / 251K total)

    [OK] Thread cache hit rate: 99% (310 created / 377K connections)

    [!!] Table cache hit rate: 0% (64 open / 162K opened)

    [OK] Open file limit used: 11% (114/1K)

    [OK] Table locks acquired immediately: 99% (2M immediate / 2M locks)

    [!!] InnoDB data size / buffer pool: 25.3M/8.0M

     

    -------- Recommendations -----------------------------------------------------

    General recommendations:

    Run OPTIMIZE TABLE to defragment tables for better performance

    Enable the slow query log to troubleshoot bad queries

    Adjust your join queries to always utilize indexes

    Increase table_cache gradually to avoid file descriptor limits

    Variables to adjust:

    query_cache_size (> 16M)

    join_buffer_size (> 128.0K, or always use indexes with joins)

    table_cache (> 64)

    innodb_buffer_pool_size (>= 25M)

  8. Napisano · Raportuj odpowiedź

    Jakby co to nic jeszcze nie zmieniałem:

     

    -------- General Statistics --------------------------------------------------

    [--] Skipped version check for MySQLTuner script

    [OK] Currently running supported MySQL version 5.0.51a-24+lenny4

    [!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM

     

    -------- Storage Engine Statistics -------------------------------------------

    [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster

    [--] Data in MyISAM tables: 1009M (Tables: 918)

    [--] Data in InnoDB tables: 25M (Tables: 30)

    [--] Data in MEMORY tables: 1011K (Tables: 12)

    [!!] Total fragmented tables: 131

     

    -------- Performance Metrics -------------------------------------------------

    [--] Up for: 21h 48m 39s (4M q [52.906 qps], 280K conn, TX: 3B, RX: 1B)

    [--] Reads / Writes: 85% / 15%

    [--] Total buffers: 58.0M global + 2.6M per thread (100 max threads)

    [OK] Maximum possible memory usage: 320.5M (8% of installed RAM)

    [OK] Slow queries: 0% (2/4M)

    [OK] Highest usage of available connections: 25% (25/100)

    [OK] Key buffer size / total MyISAM indexes: 16.0M/574.3M

    [OK] Key buffer hit rate: 97.6% (40M cached / 993K reads)

    [OK] Query cache efficiency: 71.5% (2M cached / 3M selects)

    [!!] Query cache prunes per day: 279059

    [OK] Sorts requiring temporary tables: 0% (1K temp sorts / 196K sorts)

    [OK] Temporary tables created on disk: 1% (2K on disk / 194K total)

    [OK] Thread cache hit rate: 99% (215 created / 280K connections)

    [!!] Table cache hit rate: 0% (64 open / 113K opened)

    [OK] Open file limit used: 11% (121/1K)

    [OK] Table locks acquired immediately: 99% (1M immediate / 1M locks)

    [!!] InnoDB data size / buffer pool: 25.3M/8.0M

     

    -------- Recommendations -----------------------------------------------------

    General recommendations:

    Run OPTIMIZE TABLE to defragment tables for better performance

    MySQL started within last 24 hours - recommendations may be inaccurate

    Enable the slow query log to troubleshoot bad queries

    Increase table_cache gradually to avoid file descriptor limits

    Variables to adjust:

    query_cache_size (> 16M)

    table_cache (> 64)

    innodb_buffer_pool_size (>= 25M)

     

  9. Napisano · Raportuj odpowiedź

    Jeśli o obciążenie chodzi to spoko, bo nie przekracza raczej 0,5 procek i ram też raczej są wonle. Serwer przeżyje, bo przed restartem mysql wczorajszym, prędzej go nie resetowałem z miesiąc chyba. Zapchał się dlatego że jeden z adminów wysyłał spam na 200 tyś userów ... po południu dam wyniki tych skryptów.

    Dane z przed chwili - Load average: 0.27 0.41 0.36

  11. Napisano · Raportuj odpowiedź

    Witam, potrzebuje pomocy z optymalizacją MySQL. Szczerze nie znam się na optymalizacji... Na serwerze znajdują się 3 fora na silniku vB jedno 200 tyś userów, drugie 11 tyś userów a trzecie małe 3 tyś. Procek - Intel® Core2 Quad Q6700 @ 2.66GHz | 4 GB ramu | Dysk 1 TB

     

    To wynik z MySQLTuner

     

    >> MySQLTuner 1.0.1 - Major Hayden <major@mhtx.net>

    >> Bug reports, feature requests, and downloads at http://mysqltuner.com/

    >> Run with '--help' for additional options and output filtering

     

    -------- General Statistics --------------------------------------------------

    [--] Skipped version check for MySQLTuner script

    [OK] Currently running supported MySQL version 5.0.51a-24+lenny4

    [!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM

     

    -------- Storage Engine Statistics -------------------------------------------

    [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster

    [--] Data in MyISAM tables: 1008M (Tables: 918)

    [--] Data in InnoDB tables: 24M (Tables: 30)

    [--] Data in MEMORY tables: 379K (Tables: 12)

    [!!] Total fragmented tables: 139

     

    -------- Performance Metrics -------------------------------------------------

    [--] Up for: 6m 50s (29K q [71.966 qps], 2K conn, TX: 1B, RX: 8M)

    [--] Reads / Writes: 87% / 13%

    [--] Total buffers: 58.0M global + 2.6M per thread (100 max threads)

    [OK] Maximum possible memory usage: 320.5M (8% of installed RAM)

    [OK] Slow queries: 0% (0/29K)

    [OK] Highest usage of available connections: 12% (12/100)

    [!!] Key buffer size / total MyISAM indexes: 16.0M/574.0M

    [!!] Key buffer hit rate: 81.8% (237K cached / 43K reads)

    [OK] Query cache efficiency: 64.7% (13K cached / 21K selects)

    [!!] Query cache prunes per day: 191133

    [OK] Sorts requiring temporary tables: 0% (10 temp sorts / 1K sorts)

    [!!] Joins performed without indexes: 6

    [OK] Temporary tables created on disk: 1% (21 on disk / 1K total)

    [OK] Thread cache hit rate: 99% (12 created / 2K connections)

    [!!] Table cache hit rate: 1% (64 open / 6K opened)

    [OK] Open file limit used: 11% (121/1K)

    [OK] Table locks acquired immediately: 99% (12K immediate / 12K locks)

    [!!] InnoDB data size / buffer pool: 24.3M/8.0M

     

    -------- Recommendations -----------------------------------------------------

    General recommendations:

    Run OPTIMIZE TABLE to defragment tables for better performance

    MySQL started within last 24 hours - recommendations may be inaccurate

    Enable the slow query log to troubleshoot bad queries

    Adjust your join queries to always utilize indexes

    Increase table_cache gradually to avoid file descriptor limits

    Variables to adjust:

    key_buffer_size (> 574.0M)

    query_cache_size (> 16M)

    join_buffer_size (> 128.0K, or always use indexes with joins)

    table_cache (> 64)

    innodb_buffer_pool_size (>= 24M)

     

    A to mój my.conf

     

    #

    # 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

    # http://dev.mysql.com/doc/mysql/en/server-system-variables.html

     

    # 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]

    #

    # * 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 = 16M

    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 = 100

    #table_cache = 64

    #thread_concurrency = 10

    #

    # * Query Cache Configuration

    #

    query_cache_limit = 1M

    query_cache_size = 16M

    #

    # * 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/

  18. Napisano · Raportuj odpowiedź

    Proponuje zacząć od sprawdzenia poprawności hostname. Oprócz tego pokaz zrodlo wiadomosci dostarczonej na gmaila.

     

    /etc/hosts

    212.59.242.236 emailbiznes emailbiznes.pl

     

    /etc/hostname

    emailbiznes

     

     

    Źródło wiadomości:

    Delivered-To: mcelber@gmail.com Received: by 10.204.163.7 with SMTP id y7cs13117bkx; Fri, 23 Jul 2010 05:04:54 -0700 (PDT) Received: by 10.213.33.197 with SMTP id i5mr3211266ebd.45.1279886694484; Fri, 23 Jul 2010 05:04:54 -0700 (PDT) Return-Path: <admin@emailbiznes.pl> Received: from mail.emailbiznes.pl (emailbiznes.pl [212.59.242.236]) by mx.google.com with ESMTP id q60si438319eeh.18.2010.07.23.05.04.54; Fri, 23 Jul 2010 05:04:54 -0700 (PDT) Received-SPF: pass (google.com: domain of admin@emailbiznes.pl designates 212.59.242.236 as permitted sender) client-ip=212.59.242.236; Authentication-Results: mx.google.com; spf=pass (google.com: domain of admin@emailbiznes.pl designates 212.59.242.236 as permitted sender) smtp.mail=admin@emailbiznes.pl Received: from lista.emailbiznes.pl (vz3021.logout.pl [212.59.242.236]) by mail.emailbiznes.pl (Postfix) with ESMTPA id EE80E5800C3 for <mcelber@gmail.com>; Fri, 23 Jul 2010 14:01:01 +0200 (CEST) To: mcelber@gmail.com Subject: Cześć

    Message-ID: <7ff97981b8063f6e906b6e8c5321cba2@lista.emailbiznes.pl> Date: Fri, 23 Jul 2010 14:01:01 +0200 From: "=?UTF-8?B?Um9iZXJ0IFdpbGnFhHNraQ==?=" <admin@emailbiznes.pl> Reply-To: admin@emailbiznes.pl MIME-Version: 1.0 X-Mailer-LID: 5 List-Unsubscribe: <http://lista.emailbiznes.pl/unsubscribe.php?M=8394&C=eccaeac4ad1e3b94bf87a8dfa4b8f02a&L=5&N=37> X-Mailer-RecptId: 8394 X-Mailer-SID: 37 X-Mailer-Sent-By: 1 Content-Type: multipart/alternative; charset="UTF-8"; boundary="b1_7287b77a53bfb5d00f2def53708644ab" Content-Transfer-Encoding: 8bit --b1_7287b77a53bfb5d00f2def53708644ab Content-Type: text/plain; format=flowed; charset="UTF-8" Content-Transfer-Encoding: 8bit

    Cześć

     

    --b1_7287b77a53bfb5d00f2def53708644ab

  19. Napisano · Raportuj odpowiedź

    Witam, mam problem, mam skonfigurowane DNS'y, SPF'a ale mimo to maile, które wysyłam z serwera emailbiznes.pl (212.59.242.236) do gmail są traktowane jako spam, o dziwo jeśli wyślę maila z thunderbira to jest dobrze, a jeśli ze skryptu php to traktuje to jako spam... co muszę jeszcze zrobić by gmail nie traktował wiadomości jako spam ? Jeśli chodzi o treść maila to może być nawet zwykłe "Cześć" to i tak gmail to traktuje jako spam ....

  21. Napisano · Raportuj odpowiedź

    Witam, mam takie pytanie, jak by wyglądał skrypt który wyświetlał by tylko nazwę i link do formularza kontaktowego firm jakiejś danej branży ze strony http://www.pf.pl przykładowo w "Co" wpisuje "serwis komputerowy" i wyświetla mi firmy, chciał bym aby wyświetlało mi 50 wyników na stronę i by to wyglądało tak:

    nazwa firmy - link do formularza kontaktowego np.

    Kombinowałem trochę ale coś nie za bardzo chce mi sie to udać :)

  24. Napisano · Raportuj odpowiedź

    Witam, mam mały problem z mailami, otóż zauważyłem że czasem, a w sumie to nawet często maile nie dochodzą odrazu, czasem to trwa kilkanaście minut a czasem nawet do kilku dni ...

     

    Patrząc w logi mam jeden komunikat amavis'a a w zasadzie Mai

    amavis[28383]: (28383-03) Maia: [check_mail] WARNING: Size limit (-1) > max_allowed_packet (33553408); effective size limit is 33552384 bytes

     

    Gdzie to ostrzerzenie mogę naprawić ?

     

    Oraz tak wyglądają SPF i MX domen na serwerze:

     

    domena pixelmeal.com

    IN MX 10 mail.pixelmeal.com.

     

    pixelmeal.com. IN TXT "v=spf1 a mx ip4:91.121.142.229 include:pixelmeal.com include:ns356736.ovh.net ~all"

     

    domena ns356736.ovh.net

    IN MX 10 mail.pixelmeal.com.

     

    ns356736.ovh.net. IN TXT "v=spf1 a mx ptr a:mail.pixelmeal.com ip4:91.121.142.229 ~all"

     

    Oraz każda inna domena na moim serwerze ma takie same wpisy:

    IN MX 10 mail.pixelmeal.com.

     

    domena.pl. IN TXT "v=spf1 a mx ip4:91.121.142.229 include:pixelmeal.com include:ns356736.ovh.net ~all"

  25. Napisano · Raportuj odpowiedź

    Kurde zmieniałem nie ten size co miałem :( Dzięki :)

     

    Would you like me to create a ~/.my.cnf file for you? [y/N] : N

-- MYSQL PERFORMANCE TUNING PRIMER --
 	- By: Matthew Montgomery -

MySQL Version 5.0.51a-24+lenny2-log i486

Uptime = 0 days 16 hrs 55 min 41 sec
Avg. qps = 11
Total Questions = 725330
Threads Connected = 1

Warning: Server has not been running for at least 48hrs.
It may not be safe to use these recommendations

To find out more information on how each of these
runtime variables effects performance visit:
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
Visit http://www.mysql.com/products/enterprise/advisors.html
for info about MySQL's Enterprise Monitoring and Advisory Service

SLOW QUERIES
The slow query log is enabled.
Current long_query_time = 10 sec.
You have 0 out of 725351 that take longer than 10 sec. to complete
Your long_query_time seems to be fine

BINARY UPDATE LOG
The binary update log is NOT enabled.
You will not be able to do point in time recovery
See http://dev.mysql.com/doc/refman/5.0/en/point-in-time-recovery.html

WORKER THREADS
Current thread_cache_size = 16384
Current threads_cached = 10
Current threads_per_sec = 0
Historic threads_per_sec = 0
Your thread_cache_size is fine

MAX CONNECTIONS
Current max_connections = 100
Current threads_connected = 1
Historic max_used_connections = 11
The number of used connections is 11% of the configured maximum.
Your max_connections variable seems to be fine.

INNODB STATUS
Current InnoDB index space = 160 K
Current InnoDB data space = 96 K
Current InnoDB buffer pool free = 96 %
Current innodb_buffer_pool_size = 32 M
Depending on how much space your innodb indexes take up it may be safe
to increase this value to up to 2 / 3 of total system memory

MEMORY USAGE
Max Memory Ever Allocated : 277 M
Configured Max Per-thread Buffers : 1.80 G
Configured Max Global Buffers : 74 M
Configured Max Memory Limit : 1.87 G
Physical Memory : 1.95 G

nMax memory limit exceeds 90% of physical memory

KEY BUFFER
Current MyISAM index space = 25 M
Current key_buffer_size = 8 M
Key cache miss rate is 1 : 1040
Key buffer free ratio = 4 %
You could increase key_buffer_size
It is safe to raise this up to 1/4 of total system memory;
assuming this is a dedicated database server.

QUERY CACHE
Query cache is enabled
Current query_cache_size = 32 M
Current query_cache_used = 16 M
Current query_cache_limit = 8 M
Current Query cache Memory fill ratio = 50.48 %
Current query_cache_min_res_unit = 4 K
MySQL won't cache query results that are larger than query_cache_limit in size

SORT OPERATIONS
Current sort_buffer_size = 2 M
Current read_rnd_buffer_size = 256 K
Sort buffer seems to be fine

JOINS
Current join_buffer_size = 16.00 M
You have had 333 queries where a join could not use an index properly
join_buffer_size >= 4 M
This is not advised
You should enable "log-queries-not-using-indexes"
Then look for non indexed joins in the slow query log.

OPEN FILES LIMIT
Current open_files_limit = 65535 files
The open_files_limit should typically be set to at least 2x-3x
that of table_cache if you have heavy MyISAM usage.
Your open_files_limit value seems to be fine

TABLE CACHE
Current table_cache value = 32712 tables
You have a total of 391 tables
You have 423 open tables.
The table_cache value seems to be fine

TEMP TABLES
Current max_heap_table_size = 32 M
Current tmp_table_size = 32 M
Of 11053 temp tables, 3% were created on disk
Created disk tmp tables ratio seems fine

TABLE SCANS
Current read_buffer_size = 128 K
Current table scan ratio = 1858 : 1
read_buffer_size seems to be fine

TABLE LOCKING
Current Lock Wait ratio = 1 : 2644
You may benefit from selective use of InnoDB.
If you have long running SELECT's against MyISAM tables and perform
frequent updates consider setting 'low_priority_updates=1'
If you have a high concurrency of inserts on Dynamic row-length tables
consider setting 'concurrent_insert=2'.

×