bira
Tue 20th Jun '00, 9:53am
Hi,
I still seem to run into MySQL problems, although not as often as it was up until a week ago. Back them mysqld crashed at least twice a day; now it crashes once every 2-3 days.
Yesterday, we decided to restart it with the --log option, so we can see the next time it crashes what was the last thing that was done, cos maybe it's some specific problem or a specific query?
In any case, in the mean time I would like some advice on some MySQL settings.
First, my specs: Dedicated server, running BSDi 4 with MySQL 3.22.32 and PHP 3.0.12.
Hardware-wise: PIII 450, 512mb RAM, 20gb hard drive (if that matters).
Now the MySQL variables are the default ones -- we did not change anything there.
A few problems:
1) 24 hours after mysqld was restarted, I already have 105 Slow_queries. Is that normal? Should that worry me?
2) On Sunday after the GP race we had a lot of traffic, and the BB was almost not moving! It was so slow, it was almost impossible to open any page. I never ever had that problem, with the same amount of traffic and more, on UBB even though I had half the memory back then
3) I often get a MySQL "too many connections" error. The thing is, when I tried to change some settings - start the mysqld with usr/local/bin/safe_mysqld -O key_buffer=28M -O sort_buffer=4M -O max_connections=300 & -- not only did the CPU usage shoot up the roof, also there was no way to connect to the MySQL server, not via phpmyadmin or via the BB, even though mysqld and safe_mysql were seen running in TOP. So we stopped it and restarted it back in the default variables.
Please let me know if you need more info, and I appreciate the help.
Thanks,
Bira
p.s.
the mysqld with log on has been running for 24 hours now, undisturbed, and the log file size is 213,466,333 -- is that normal?? it's very big :o
[Edited by bira on 06-20-2000 at 08:55 PM]
I still seem to run into MySQL problems, although not as often as it was up until a week ago. Back them mysqld crashed at least twice a day; now it crashes once every 2-3 days.
Yesterday, we decided to restart it with the --log option, so we can see the next time it crashes what was the last thing that was done, cos maybe it's some specific problem or a specific query?
In any case, in the mean time I would like some advice on some MySQL settings.
First, my specs: Dedicated server, running BSDi 4 with MySQL 3.22.32 and PHP 3.0.12.
Hardware-wise: PIII 450, 512mb RAM, 20gb hard drive (if that matters).
Now the MySQL variables are the default ones -- we did not change anything there.
A few problems:
1) 24 hours after mysqld was restarted, I already have 105 Slow_queries. Is that normal? Should that worry me?
2) On Sunday after the GP race we had a lot of traffic, and the BB was almost not moving! It was so slow, it was almost impossible to open any page. I never ever had that problem, with the same amount of traffic and more, on UBB even though I had half the memory back then
3) I often get a MySQL "too many connections" error. The thing is, when I tried to change some settings - start the mysqld with usr/local/bin/safe_mysqld -O key_buffer=28M -O sort_buffer=4M -O max_connections=300 & -- not only did the CPU usage shoot up the roof, also there was no way to connect to the MySQL server, not via phpmyadmin or via the BB, even though mysqld and safe_mysql were seen running in TOP. So we stopped it and restarted it back in the default variables.
Please let me know if you need more info, and I appreciate the help.
Thanks,
Bira
p.s.
the mysqld with log on has been running for 24 hours now, undisturbed, and the log file size is 213,466,333 -- is that normal?? it's very big :o
[Edited by bira on 06-20-2000 at 08:55 PM]