[High]Thread creation error

[High]Thread creation error

am 08.05.2009 09:31:06 von Junior Ortis

Hi all, after random times not only about high usage, i have this
message on Mysql Administrator ( Windows ), logged to my Dedicated
Database ( Linux ).

Here is a print of error:
http://img25.imageshack.us/img25/2342/mysqlthreaderror.jpg
Here is a print of putty using 'top' on dedicated server:
http://img15.imageshack.us/img15/2412/tophym.jpg
Here is a print of ./mysqltuner.pl
http://img5.imageshack.us/img5/8991/mysqltuner.jpg
Here is a print of ./tuning-primer.sh
http://img17.imageshack.us/img17/544/tunning.jpg

And finally a print of my.cnf
http://img6.imageshack.us/img6/2877/83767908.jpg

Here my mysqladmin extended-status

mysqladmin status
Uptime: 188937 Threads: 10 Questions: 21396848 Slow queries: 1 Opens: 501

mysqlreport

Flush tables: 3 Open tables: 124 Queries per second avg: 113.249
MySQL 5.0.77-log uptime 2 7:18:39 Thu May 7 23:31:40 2009

__ Key ____________________________________________________________ _____
Buffer used 302.78M of 1.56G %Used: 18.92
Current 400.58M %Usage: 25.04
Write hit 79.26%
Read hit 99.83%

__ Questions ___________________________________________________________
Total 22.84M 114.7/s
DMS 22.49M 113.0/s %Total: 98.50
Com_ 459.78k 2.3/s 2.01
-Unknown 174.07k 0.9/s 0.76
QC Hits 52.34k 0.3/s 0.23
COM_QUIT 5.14k 0.0/s 0.02
Slow 3 s 1 0.0/s 0.00 %DMS: 0.00 Log: ON
DMS 22.49M 113.0/s 98.50
REPLACE 11.65M 58.5/s 51.01 51.79
SELECT 4.34M 21.8/s 18.99 19.28
DELETE 4.18M 21.0/s 18.29 18.56
INSERT 2.17M 10.9/s 9.51 9.65
UPDATE 160.05k 0.8/s 0.70 0.71
Com_ 459.78k 2.3/s 2.01
admin_comma 173.95k 0.9/s 0.76
show_status 140.38k 0.7/s 0.61
show_innodb 140.03k 0.7/s 0.61

__ SELECT and Sort _____________________________________________________
Scan 574.01k 2.9/s %SELECT: 13.24
Range 4.89k 0.0/s 0.11
Full join 0 0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 208.82k 1.0/s
Sort range 578.84k 2.9/s
Sort mrg pass 0 0/s

__ Query Cache _________________________________________________________
Memory usage 11.08M of 128.00M %Used: 8.65
Block Fragmnt 35.60%
Hits 52.34k 0.3/s
Inserts 4.25M 21.4/s
Insrt:Prune 4.25M:1 21.4/s
Hit:Insert 0.01:1

__ Table Locks _________________________________________________________
Waited 59.71k 0.3/s %Total: 0.26
Immediate 22.54M 113.2/s

__ Tables ____________________________________________________________ __
Open 136 of 500 %Cache: 27.20
Opened 513 0.0/s

__ Connections _________________________________________________________
Max used 13 of 50 %Max: 26.00
Total 5.28k 0.0/s

__ Created Temp ________________________________________________________
Disk table 439 0.0/s
Table 141.93k 0.7/s Size: 32.0M
File 14 0.0/s

__ Threads ____________________________________________________________ _
Running 1 of 10
Cached 3 of 200 %Hit: 99.75
Created 13 0.0/s
Slow 0 0/s

__ Aborted ____________________________________________________________ _
Clients 260 0.0/s
Connects 7 0.0/s

__ Bytes ____________________________________________________________ ___
Sent 8.93G 44.8k/s
Received 8.03G 40.3k/s

__ InnoDB Buffer Pool __________________________________________________
Usage 0 of 0 %Used: 0.00
Read hit 0.00%
Pages
Free 0 %Total: 0.00
Data 0 0.00 %Drty: 0.00
Misc 0 0.00
Latched 0.00
Reads 0 0/s
From file 0 0/s 0.00
Ahead Rnd 0 0/s
Ahead Sql 0 0/s
Writes 0 0/s
Flushes 0 0/s
Wait Free 0 0/s

__ InnoDB Lock _________________________________________________________
Waits 0 0/s
Current 0
Time acquiring
Total 0 ms
Average 0 ms
Max 0 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 0 0/s
Writes 0 0/s
fsync 0 0/s
Pending
Reads 0
Writes 0
fsync 0

Pages
Created 0 0/s
Read 0 0/s
Written 0 0/s

Rows
Deleted 0 0/s
Inserted 0 0/s
Read 0 0/s
Updated 0 0/s



Thanks this erros is ending my life =D

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org