About MYSQL

[kp3011]

I have been using your redhat hosting for quite some time because you provided free MYSQL services. :rolleyes:

It was completely fine at the beginning, but now, when my forum database (I am using your redhat hosting and the forum program was phpBB 2.0.10) grew up to about 220KB, something terrible happened. The loading speed is terribly slow, ranging from at least 15 seconds to about 1 minute. Also, the little icons (e.g. this one -> ) loading slowly. It is especially annoying when a lot of them are displayed (just like the screen now. on the left, there are a lot of smilies)

Can anything be done about it, no matter by me or by you? I know that providing free service for MYSQL is not easy, but I do hope that the loading speed could be improved.

Or does switching the hosting server (still stay at polarhome, coz I feel good of the service ) to e.g. mandrake help? thanks :rolleyes:

[DenisF]

By the looks of your question, it's not mysql that's causing the problem..
the problem is bandwdith, polarhome [as you know] only has 1mbit upload, shared between 10 servers and 40,000~ active users.
nothing that can be done about that, sadly, unless some swedish ISP decides to offer T1 / T3 at the price of normal DSL...

As per mandrake, it only has 96k upload [12kB/ps], but the number of users is very low [20~ active], so you might 'enjoy' it a bit more than redhat, for the time being.
[btw, mandrake is the only polarhome server that isn't hosted in sweden, so even if polarhome itself goes down / gets overloaded / whatever, mandrake will still be up]

Regards,
/DenisF

[kp3011]

<!--QuoteBegin-DenisF+Aug 30 2004, 03:17 PM--></div><table border='0' align='center' width='95%' cellpadding='3' cellspacing='1'><tr><td>QUOTE (DenisF @ Aug 30 2004, 03:17 PM)</td></tr><tr><td id='QUOTE'><!--QuoteEBegin-->By the looks of your question, it's not mysql that's causing the problem..
the problem is bandwdith, polarhome [as you know] only has 1mbit upload, shared between 10 servers and 40,000~ active users.
nothing that can be done about that, sadly, unless some swedish ISP decides to offer T1 / T3 at the price of normal DSL...

As per mandrake, it only has 96k upload [12kB/ps], but the number of users is very low [20~ active], so you might 'enjoy' it a bit more than redhat, for the time being.
[btw, mandrake is the only polarhome server that isn't hosted in sweden, so even if polarhome itself goes down / gets overloaded / whatever, mandrake will still be up]

Regards,
/DenisF[/quote]
oic thank you.

[sjaz]

redhat% uptime
17:47:13 up 17 days, 9:24, 1 user, load average: 20.17, 23.14, 24.44
redhat%


Of cpu course loads of 2000% doesnt help.

[sjaz]

19268 naveed 25 0 6016 828 352 R 13.4 0.0 586:42 0 perl
6160 naveed 25 0 6016 816 352 R 13.4 0.0 490:59 0 perl
9719 naveed 25 0 5840 412 176 R 13.4 0.0 251:06 0 perl
26887 naveed 25 0 6016 820 352 R 13.4 0.0 236:18 0 perl
4172 naveed 25 0 6012 812 352 R 11.9 0.0 222:29 0 perl
19722 naveed 25 0 6016 876 352 R 11.9 0.0 172:25 0 perl
1049 mysql 17 0 35724 10M 1456 S 1.4 1.0 405:06 0 mysqld
12348 chaz 31 15 1212 1212 764 R N 0.4 0.1 0:01 0 top

Bastard naveed comes to mind.

[DenisF]

Redhat's athlon xp 1700+ can handle 20x loads just fine, even with a 20x it will be faster than mandrake on 0x

anyway, wanna email the guy and ask'm nicely to stop spamming the system with his proc's ?

[sjaz]

handling 20 loads fine? ... its lagging like a mofo... *yet downloads quick* so its not bandwidth.

[sjaz]

Hi,

I am writing to ask that you use less of the Redhat.Polarhome.Com system resources … your perl processes are crippling the server. Your processes alone are using over 50% of the cpu sustained. I am asking that you reduce the usage as this is making things harder for other users.

Regards,

Sjaz
Polarhome Support Moderator

Done.

[DenisF]

/me hugs chaz

[sjaz]

/me throws a brick at naveed