RE: A question about load / queries pr second

2001-09-07 Thread Jerome Ponsin
Hello, I saw your message on the list, could you tell me which scripting language you are using (php, perl, java ?) and if you have the time could you show me your my.cnf and the result of a "show variable" request ? I am experiencing problem with 100% CPU load and can't figure what it is ? Th

mysql CPU too high and sleeping process

2001-09-06 Thread Jerome Ponsin
Hello, I have trouble with mysql consuming too much CPU with a few number of threads running. How could I reduce the CPU usage ? I unterstand that, in plain charge the CPU is high but why does it stay at that level when the charge is becoming smaller ? The process seems in major to be sleeping a