Strato mit plesk 8.1 mysql 5 stürtz ab

F

foryoudo

New Member
Hallo erstmal,

ich habe letzt woche mein VServer neuinstalliert mit openSUSE 10.1 Professional inkl. Plesk 8.1 (MySQL 5 PHP 5)

Nun habe ich das problem das MySQL abstürzt! Und nun?

Nun habe ich Plesk 8.1 /etc/init.d/psa stop nun läuft alles ohne problem! (Stimmt nicht ganz, ist jetzt 1 Tag ohne absturz gelaufen)

Weiß einer von euch was das sein kann, oder hat jemand genau das selbe problem!

Gruß
foryoudo
 
Last edited by a moderator:
Ohne relevante Logauszüge werden wir wohl kaum was machen können. Poste die passenden Auszüge aus dem syslog (/var/log/messages) und aus dem mysql.log (musst Du suchen).
 
marneus said:
Ohne relevante Logauszüge werden wir wohl kaum was machen können. Poste die passenden Auszüge aus dem syslog (/var/log/messages) und aus dem mysql.log (musst Du suchen).
Click to expand...

/var/log/messages
Code: 
Aug 31 11:27:04 h1085305 xinetd[13836]: smtp: fork failed: Cannot allocate memory (errno = 12)
Aug 31 11:27:04 h1085305 last message repeated 4 times
Aug 31 11:27:04 h1085305 xinetd[13836]: Deactivating service smtp due to no available descriptors.  Restarting in 10 seconds.
Aug 31 11:27:09 h1085305 xinetd[30194]: execv( /var/qmail/bin/tcp-env ) failed: Bad file descriptor (errno = 9)
Aug 31 11:27:09 h1085305 xinetd[13836]: smtp: fork failed: Cannot allocate memory (errno = 12)
Aug 31 11:27:09 h1085305 xinetd[13836]: smtp: fork failed: Cannot allocate memory (errno = 12)
Aug 31 11:27:14 h1085305 xinetd[13836]: Activating service smtp
Aug 31 11:27:14 h1085305 xinetd[13836]: smtp: fork failed: Cannot allocate memory (errno = 12)
Aug 31 11:27:14 h1085305 last message repeated 2 times
Aug 31 11:27:14 h1085305 xinetd[13836]: Deactivating service smtp due to no available descriptors.  Restarting in 10 seconds.
Aug 31 11:27:15 h1085305 xinetd[13836]: Service smtp: server exit with 0 running servers
Aug 31 11:27:23 h1085305 last message repeated 32 times
Aug 31 11:27:24 h1085305 xinetd[13836]: Activating service smtp
Aug 31 11:27:25 h1085305 xinetd[13836]: smtp: fork failed: Cannot allocate memory (errno = 12)
Aug 31 11:27:25 h1085305 last message repeated 32 times
Aug 31 11:27:25 h1085305 xinetd[13836]: Deactivating service smtp due to no available descriptors.  Restarting in 10 seconds.
Aug 31 11:27:30 h1085305 xinetd[13836]: smtp: fork failed: Cannot allocate memory (errno = 12)
Aug 31 11:27:30 h1085305 last message repeated 2 times
Aug 31 11:27:35 h1085305 xinetd[13836]: Activating service smtp
Aug 31 11:27:36 h1085305 xinetd[13836]: smtp: fork failed: Cannot allocate memory (errno = 12)
Aug 31 11:27:36 h1085305 xinetd[32187]: warning: cannot open /etc/hosts.allow: Too many open files in system
Aug 31 11:27:36 h1085305 xinetd[32187]: warning: cannot open /etc/hosts.deny: Too many open files in system
Aug 31 11:27:36 h1085305 xinetd[13836]: smtp: fork failed: Cannot allocate memory (errno = 12)
Aug 31 11:27:36 h1085305 xinetd[32189]: warning: cannot open /etc/hosts.allow: Too many open files in system
Aug 31 11:27:36 h1085305 xinetd[32189]: warning: cannot open /etc/hosts.deny: Too many open files in system
Aug 31 11:27:36 h1085305 xinetd[32190]: execv( /var/qmail/bin/tcp-env ) failed: Cannot allocate memory (errno = 12)
Aug 31 11:27:36 h1085305 xinetd[13836]: smtp: fork failed: Cannot allocate memory (errno = 12)
Aug 31 11:27:36 h1085305 xinetd[32192]: warning: cannot open /etc/hosts.allow: Too many open files in system
Aug 31 11:27:36 h1085305 xinetd[32192]: warning: cannot open /etc/hosts.deny: Too many open files in system
Aug 31 11:27:36 h1085305 xinetd[13836]: smtp: fork failed: Cannot allocate memory (errno = 12)
Aug 31 11:27:36 h1085305 xinetd[32194]: warning: cannot open /etc/hosts.allow: Too many open files in system
Aug 31 11:27:36 h1085305 xinetd[13836]: smtp: fork failed: Cannot allocate memory (errno = 12)
Aug 31 11:27:36 h1085305 last message repeated 2 times
Aug 31 11:27:36 h1085305 xinetd[32194]: warning: cannot open /etc/hosts.deny: Too many open files in system
Aug 31 11:27:36 h1085305 xinetd[13836]: smtp: fork failed: Cannot allocate memory (errno = 12)
Aug 31 11:27:36 h1085305 last message repeated 2 times
Aug 31 11:27:36 h1085305 xinetd[32194]: execv( /var/qmail/bin/tcp-env ) failed: Too many open files in system (errno = 23)
Aug 31 11:27:36 h1085305 xinetd[13836]: smtp: fork failed: Cannot allocate memory (errno = 12)
Aug 31 11:27:36 h1085305 last message repeated 22 times
Aug 31 11:27:36 h1085305 xinetd[13836]: Deactivating service smtp due to no available descriptors.  Restarting in 10 seconds.
Aug 31 11:27:41 h1085305 xinetd[13836]: smtp: fork failed: Cannot allocate memory (errno = 12)
Aug 31 11:27:41 h1085305 last message repeated 22 times
Aug 31 11:27:46 h1085305 xinetd[13836]: Activating service smtp
Aug 31 11:27:46 h1085305 xinetd[13836]: smtp: fork failed: Cannot allocate memory (errno = 12)
Aug 31 11:27:46 h1085305 last message repeated 22 times
Aug 31 11:27:46 h1085305 xinetd[32580]: execv( /var/qmail/bin/tcp-env ) failed: Cannot allocate memory (errno = 12)
Aug 31 11:27:46 h1085305 xinetd[13836]: smtp: fork failed: Cannot allocate memory (errno = 12)
Aug 31 11:27:46 h1085305 last message repeated 4 times
Aug 31 11:27:46 h1085305 xinetd[13836]: Deactivating service smtp due to no available descriptors.  Restarting in 10 seconds.
Aug 31 11:28:22 h1085305 xinetd[3314]: execv( /var/qmail/bin/tcp-env ) failed: Cannot allocate memory (errno = 12)
Aug 31 11:28:27 h1085305 xinetd[13836]: smtp: fork failed: Cannot allocate memory (errno = 12)
Aug 31 11:28:27 h1085305 xinetd[13836]: service smtp: too many consecutive fork failures

Das mit dem memory verstehe ich nicht. Wie gesagt nach der neuinstallation läuft der VServer ca. 3 stunden.

mysqld.log

Code: 
Number of processes running now: 0
070831 11:28:09  mysqld restarted
070831 11:28:09  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
070831 11:28:09  InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 1091289.
InnoDB: Doing recovery: scanned up to log sequence number 0 1091299
InnoDB: Last MySQL binlog file position 0 0, file name
070831 11:28:09  InnoDB: Started; log sequence number 0 1091299
070831 11:28:09 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.18'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  SUSE MySQL RPM
070831 11:28:10 [ERROR] mysqld: Got error 12 from select
InnoDB: Error: pthread_create returned 12
070831 12:13:29  mysqld started
070831 12:13:29  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
070831 12:13:29  InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 1091348.
InnoDB: Doing recovery: scanned up to log sequence number 0 1091348
InnoDB: Last MySQL binlog file position 0 0, file name
070831 12:13:29  InnoDB: Started; log sequence number 0 1091348
070831 12:13:29 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.18'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  SUSE MySQL RPM

Noch was: Strato hat mir geschrieben:

Code: 
Ihr Server scheint permanent mehr Speicher anzufordern als im zugeteilt wurde. Dies kann ein Grund sein weshalb Ihr MySQL Server seinen Dienst verweigert.

      uid  resource           held    maxheld    barrier      limit    failcnt
   1085305: kmemsize        3891473    3901297    8512433    9823665   26521455
            lockedpages           0          0       3800       4096          0
            privvmpages       61774      62298     138256     202568         16
            shmpages           8833       8833     131072     131072          0
            dummy                 0          0          0          0          0
            numproc              59         59        232        232          0
            physpages         16277      16350          0 2147483647          0
            vmguarpages           0          0      66400 2147483647          0
            oomguarpages      16277      16350      66400 2147483647          0
            numtcpsock           33         36        500        500      14425
            numflock              9          9        200        232          0
            numpty                1          1         64         64          0
            numsiginfo            0          1        512        512          0
            tcpsndbuf        297388     321984    4683256    6102456          0
            tcprcvbuf        443768     492920    4683256    6102456          0
            othersockbuf      44720      44720    1503232    4063232          0
            dgramrcvbuf           0        700     240000     262144          0
            numothersock         30         31        382        382          0
            dcachesize            0          0    2194304    2317184          0
            numfile            2273       2273       5432       5432          0
            dummy                 0          0          0          0          0
            dummy                 0          0          0          0          0
            dummy                 0          0          0          0          0
            numiptent            54         54        128        128          0

top

Code: 
top - 12:38:35 up 25 min,  1 user,  load average: 0.13, 0.08, 0.01
Tasks:  47 total,   2 running,  45 sleeping,   0 stopped,   0 zombie
Cpu(s):  0.7% us,  0.3% sy,  0.0% ni, 99.0% id,  0.0% wa,  0.0% hi,  0.0% si
Mem:   2070020k total,  1916060k used,   153960k free,   544360k buffers
Swap:  3068392k total,        0k used,  3068392k free,   599876k cached
 
Last edited by a moderator:
Hey,

kann es sein das dies in den logs ein Hack angriff ist?

Code: 
Aug 31 16:19:36 h1085305 sshd[19617]: Invalid user rusticos from 66.238.200.241
Aug 31 16:19:39 h1085305 sshd[19626]: Invalid user rusticos from 66.238.200.241
Aug 31 16:19:40 h1085305 sshd[19632]: Invalid user test from 66.238.200.241
Aug 31 16:19:41 h1085305 sshd[19634]: Invalid user test from 66.238.200.241
Aug 31 16:19:42 h1085305 sshd[19639]: Invalid user test from 66.238.200.241
Aug 31 16:19:43 h1085305 sshd[19645]: Invalid user test from 66.238.200.241
Aug 31 16:19:44 h1085305 sshd[19647]: Invalid user test from 66.238.200.241
Aug 31 16:19:45 h1085305 sshd[19652]: Invalid user test from 66.238.200.241
Aug 31 16:19:46 h1085305 sshd[19657]: Invalid user test from 66.238.200.241
Aug 31 16:19:47 h1085305 sshd[19669]: Invalid user test from 66.238.200.241
Aug 31 16:20:18 h1085305 sshd[19844]: Invalid user toor from 66.238.200.241
Aug 31 16:20:19 h1085305 sshd[19848]: Invalid user toor from 66.238.200.241
Aug 31 16:20:20 h1085305 sshd[19851]: Invalid user toor from 66.238.200.241
Aug 31 16:20:22 h1085305 sshd[19858]: Invalid user toor from 66.238.200.241
Aug 31 16:20:23 h1085305 sshd[19861]: Invalid user toor from 66.238.200.241
Aug 31 16:21:00 h1085305 sshd[20040]: Invalid user irc from 66.238.200.241
Aug 31 16:21:01 h1085305 sshd[20047]: Invalid user irc from 66.238.200.241
Aug 31 16:21:02 h1085305 sshd[20052]: Invalid user ircd from 66.238.200.241
Aug 31 16:21:03 h1085305 sshd[20074]: Invalid user irc from 66.238.200.241
Aug 31 16:21:04 h1085305 sshd[20076]: Invalid user irc from 66.238.200.241
Aug 31 16:21:05 h1085305 sshd[20078]: Invalid user ircd from 66.238.200.241
Aug 31 16:21:06 h1085305 sshd[20084]: Invalid user irc from 66.238.200.241
Aug 31 16:21:07 h1085305 sshd[20090]: Invalid user irc from 66.238.200.241
Aug 31 16:21:08 h1085305 sshd[20094]: Invalid user ircd from 66.238.200.241
Aug 31 16:21:08 h1085305 sshd[20097]: Invalid user ircd from 66.238.200.241
Aug 31 16:21:14 h1085305 sshd[20122]: Invalid user irc from 66.238.200.241
Aug 31 16:21:15 h1085305 sshd[20125]: Invalid user irc from 66.238.200.241
Aug 31 16:21:32 h1085305 sshd[20184]: Invalid user robomail from 66.238.200.241
Aug 31 16:21:33 h1085305 sshd[20187]: Invalid user robomail from 66.238.200.241
Aug 31 16:21:47 h1085305 sshd[20259]: Invalid user cyrus from 66.238.200.241
Aug 31 16:21:48 h1085305 sshd[20261]: Invalid user cyrus from 66.238.200.241
Aug 31 16:22:19 h1085305 sshd[20401]: Invalid user admin from 66.238.200.241
Aug 31 16:22:20 h1085305 sshd[20403]: Invalid user admin from 66.238.200.241
Aug 31 16:22:21 h1085305 sshd[20408]: Invalid user admin from 66.238.200.241
Aug 31 16:22:22 h1085305 sshd[20412]: Invalid user admin from 66.238.200.241
Aug 31 16:22:27 h1085305 sshd[20421]: Invalid user admin from 66.238.200.241
Aug 31 16:22:28 h1085305 sshd[20423]: Invalid user admin from 66.238.200.241
Aug 31 16:22:29 h1085305 sshd[20427]: Invalid user admin from 66.238.200.241
Aug 31 16:22:30 h1085305 sshd[20431]: Invalid user admin from 66.238.200.241
Aug 31 16:22:39 h1085305 sshd[20458]: Invalid user admin from 66.238.200.241
Aug 31 16:22:40 h1085305 sshd[20463]: Invalid user admin from 66.238.200.241
Aug 31 16:22:41 h1085305 sshd[20465]: Invalid user admin from 66.238.200.241
Aug 31 16:22:42 h1085305 sshd[20467]: Invalid user admin from 66.238.200.241
Aug 31 16:22:43 h1085305 sshd[20469]: Invalid user admin from 66.238.200.241
Aug 31 16:22:44 h1085305 sshd[20473]: Invalid user irc from 66.238.200.241
Aug 31 16:22:45 h1085305 sshd[20478]: Invalid user irc from 66.238.200.241
Aug 31 16:22:46 h1085305 sshd[21504]: Invalid user irc from 66.238.200.241
Aug 31 16:22:47 h1085305 sshd[21506]: Invalid user irc from 66.238.200.241
Aug 31 16:22:48 h1085305 sshd[21510]: Invalid user irc from 66.238.200.241
 
foryoudo said:
Hey, kann es sein das dies in den logs ein Hack angriff ist?
Click to expand...

nicht im eigentlichen Sinne. Das sind "ganz normale" Script-Kiddies, die versuchen, offene Accounts, bzw. Accounts mit trivialen Passworten zu finden. Wenn Du die ssh auf einen anderen Port legst (s. Forensuche) hast Du damit Ruhe :o

Ansonsten hat der Strato-Mensch recht: Die Programme auf Deinem Server brauchen zu viele Ressourcen.
Code: 
cat /proc/user_beancounters
in der letzten Spalte siehst Du, wie oft bestimmte Ressourcen-Grenzen überschritten wurden....

Versuche, die Anzahl der laufenden Dienste auf ein Minimum zu beschränken und die notwendigen Dienste "sparsam" zu konfigurieren -- in der Forensuche findest Du einiges zum Tuning von apache und mysql.
Wenn das dann nicht reichen sollte, wirst Du wohl auf eine größere Version Deines Servers upgraden müssen:(

Viele Grüße,
LinuxAdmin
 
Salle,

habe mal den Tuning-Primer.sh Script laufen lassen.

Irrgend wie kommen recht viele fehler?

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

MySQL Version 5.0.18 i686

//bin/tuning-primer.sh: line 382: bc: command not found
//bin/tuning-primer.sh: line 383: bc: command not found
//bin/tuning-primer.sh: line 384: bc: command not found
//bin/tuning-primer.sh: line 385: bc: command not found
//bin/tuning-primer.sh: line 386: bc: command not found
//bin/tuning-primer.sh: line 387: bc: command not found
Uptime =  days  hrs  min  sec
Avg. qps = 4
Total Questions = 149783
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

SLOW QUERIES
Current long_query_time = 10 sec.
You have 0 out of 149795 that take longer than 10 sec. to complete
The slow query log is NOT enabled.
Your long_query_time may be too high, I typically set this under 5 sec.

WORKER THREADS
Current thread_cache_size = 0
Current threads_cached = 0
Current threads_per_sec = 1
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 = 10
The number of used connections is 10% of the configured maximum.
You are using less than 10% of your configured max_connections.
Lowering max_connections could help to avoid an over-allocation of memory
See "MEMORY USAGE" section to make sure you are not over-allocating

MEMORY USAGE
//bin/tuning-primer.sh: line 1117: bc: command not found
//bin/tuning-primer.sh: line 1118: bc: command not found
//bin/tuning-primer.sh: line 1142: bc: command not found
//bin/tuning-primer.sh: line 1145: bc: command not found
//bin/tuning-primer.sh: line 1146: bc: command not found
//bin/tuning-primer.sh: line 1148: bc: command not found
//bin/tuning-primer.sh: line 1150: [: -gt: unary operator expected
//bin/tuning-primer.sh: line 344: [: max_memoryHR: integer expression expected
//bin/tuning-primer.sh: line 350: [: max_memoryHR: integer expression expected
//bin/tuning-primer.sh: line 356: [: max_memoryHR: integer expression expected
//bin/tuning-primer.sh: line 363: export: `0=max_memoryHR': not a valid identifier
Max Memory Ever Allocated :  bytes
//bin/tuning-primer.sh: line 344: [: per_thread_buffersHR: integer expression expected
//bin/tuning-primer.sh: line 350: [: per_thread_buffersHR: integer expression expected
//bin/tuning-primer.sh: line 356: [: per_thread_buffersHR: integer expression expected
//bin/tuning-primer.sh: line 363: export: `0=per_thread_buffersHR': not a valid identifier
Configured Max Per-thread Buffers :  bytes
//bin/tuning-primer.sh: line 344: [: global_buffersHR: integer expression expected
//bin/tuning-primer.sh: line 350: [: global_buffersHR: integer expression expected
//bin/tuning-primer.sh: line 356: [: global_buffersHR: integer expression expected
//bin/tuning-primer.sh: line 363: export: `0=global_buffersHR': not a valid identifier
Configured Max Global Buffers :  bytes
//bin/tuning-primer.sh: line 344: [: total_memoryHR: integer expression expected
//bin/tuning-primer.sh: line 350: [: total_memoryHR: integer expression expected
//bin/tuning-primer.sh: line 356: [: total_memoryHR: integer expression expected
//bin/tuning-primer.sh: line 363: export: `0=total_memoryHR': not a valid identifier
Configured Max Memory Limit :  bytes
//bin/tuning-primer.sh: line 325: bc: command not found
Total System Memory :  G
Max memory limit seem to be within acceptable norms

KEY BUFFER
//bin/tuning-primer.sh: line 325: bc: command not found
//bin/tuning-primer.sh: line 599: bc: command not found
//bin/tuning-primer.sh: line 600: bc: command not found
//bin/tuning-primer.sh: line 325: bc: command not found
Current MyISAM index space =  M
//bin/tuning-primer.sh: line 325: bc: command not found
Current key_buffer_size =  M
Key cache miss rate is 1 : 43
Key buffer fill ratio =  %
//bin/tuning-primer.sh: line 615: [: -ge: unary operator expected
//bin/tuning-primer.sh: line 619: [: -ge: unary operator expected
//bin/tuning-primer.sh: line 623: [: -le: unary operator expected
Your key_buffer_size seems to be fine

QUERY CACHE
Query cache is supported but not enabled
Perhaps you should set the query_cache_size

SORT OPERATIONS
//bin/tuning-primer.sh: line 325: bc: command not found
Current sort_buffer_size =  K
//bin/tuning-primer.sh: line 325: bc: command not found
Current record/read_rnd_buffer_size =  K
Sort buffer seems to be fine

JOINS
//bin/tuning-primer.sh: line 325: bc: command not found
Current join_buffer_size =  K
You have had 44 queries where a join could not use an index properly
You should enable "log-queries-not-using-indexes"
Then look for non indexed joins in the slow query log.
If you are unable to optimize your queries you may want to increase your
join_buffer_size to accommodate larger joins in one pass.

Note! This script will still suggest raising the join_buffer_size when
ANY joins not using indexes are found.

OPEN FILES LIMIT
Current open_files_limit = 1024 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 = 64 tables
You have a total of 212 tables
You have 64 open tables.
Current table_cache hit rate is 7%, while 100% of your table cache is in use
You should probably increase your table_cache

TEMP TABLES
//bin/tuning-primer.sh: line 325: bc: command not found
Current max_heap_table_size =  M
//bin/tuning-primer.sh: line 325: bc: command not found
Current tmp_table_size =  M
Of 16120 temp tables, 1% were created on disk
Effective in-memory tmp_table_size is limited to max_heap_table_size.
Created disk tmp tables ratio seems fine

TABLE SCANS
//bin/tuning-primer.sh: line 325: bc: command not found
Current read_buffer_size =  K
Current table scan ratio = 5 : 1
read_buffer_size seems to be fine

TABLE LOCKING
Current Lock Wait ratio = 0 : 149922
Your table locking seems to be fine

bc: command not found

das ist doch ein programm wo bekomme ich das her? Download?
 
Last edited by a moderator:
LinuxAdmin said:
Dann lade das RPM eben manuell von einem Mirror runter: z.B.
http://ftp5.gwdg.de/pub/linux/suse/....1/inst-source/suse/i586/bc-1.06-762.i586.rpm und installiere es mit "rpm -i bc-1.06-762.i586.rpm".

Viele Grüße,
LinuxAdmin
Click to expand...

Danke :)

Nun was sagt ihr den dazu:

Code: 
tuning-primer.sh

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

MySQL Version 5.0.18 i686

Uptime = 0 days 16 hrs 30 min 11 sec
Avg. qps = 4
Total Questions = 268197
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

SLOW QUERIES
Current long_query_time = 10 sec.
You have 0 out of 268209 that take longer than 10 sec. to complete
The slow query log is NOT enabled.
Your long_query_time may be too high, I typically set this under 5 sec.

WORKER THREADS
Current thread_cache_size = 0
Current threads_cached = 0
Current threads_per_sec = 1
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 = 10
The number of used connections is 10% of the configured maximum.
You are using less than 10% of your configured max_connections.
Lowering max_connections could help to avoid an over-allocation of memory
See "MEMORY USAGE" section to make sure you are not over-allocating

MEMORY USAGE
Max Memory Ever Allocated : 34 M
Configured Max Per-thread Buffers : 155 M
Configured Max Global Buffers : 18 M
Configured Max Memory Limit : 174 M
Total System Memory : 4.90 G
Max memory limit seem to be within acceptable norms

KEY BUFFER
Current MyISAM index space = 3 M
Current key_buffer_size = 16 M
Key cache miss rate is 1 : 63
Key buffer fill ratio = 7.00 %
Your key_buffer_size seems to be too high.
Perhaps you can use these resources elsewhere

QUERY CACHE
Query cache is supported but not enabled
Perhaps you should set the query_cache_size

SORT OPERATIONS
Current sort_buffer_size = 512 K
Current record/read_rnd_buffer_size = 508 K
Sort buffer seems to be fine

JOINS
Current join_buffer_size = 132.00 K
You have had 92 queries where a join could not use an index properly
You should enable "log-queries-not-using-indexes"
Then look for non indexed joins in the slow query log.
If you are unable to optimize your queries you may want to increase your
join_buffer_size to accommodate larger joins in one pass.

Note! This script will still suggest raising the join_buffer_size when
ANY joins not using indexes are found.

OPEN FILES LIMIT
Current open_files_limit = 1024 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 = 64 tables
You have a total of 212 tables
You have 64 open tables.
Current table_cache hit rate is 4%, while 100% of your table cache is in use
You should probably increase your table_cache

TEMP TABLES
Current max_heap_table_size = 16 M
Current tmp_table_size = 32 M
Of 28902 temp tables, 0% were created on disk
Effective in-memory tmp_table_size is limited to max_heap_table_size.
Created disk tmp tables ratio seems fine

TABLE SCANS
Current read_buffer_size = 252 K
Current table scan ratio = 5 : 1
read_buffer_size seems to be fine

TABLE LOCKING
Current Lock Wait ratio = 0 : 268336
Your table locking seems to be fine
 
You must log in or register to reply here.
Back
Top