List:General Discussion« Previous MessageNext Message »
From:Junior Ortis Date:May 8 2009 7:31am
Subject:[High]Thread creation error
View as plain text  
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
Thread
[High]Thread creation errorJunior Ortis8 May