Large message boards and MySQL logs of slow response

[WedgeAntilles250]

COOL!  It did speed up the board.

I have made a ZIP file out of the scripts.  You can download it here.

[Egg]

thanks medi and Jan

it makes a BIG difference :thumbsup:

[PioneeR]

I have just converted from YaBB1GSP1 over to SE..

I have 140ish members and over 19000 posts.. I wasnt very impressed with the speed of SE...

Well not until I did the above!! WOW! What an improvement!!

Thanks!!

[jthorpe]

This made a huge difference for mine.  Running top before the change would show my server at 80-90% with only 60-70 people on a once.  Now, I had 105 on at once the other night, and the server load was almost nothing.  The queries are MUCH MUCH faster!  Amazing...

I remember posting a message a long time ago thinking there was something wrong with my board, and that is was just slow.  Now I know why.  Either way, good job Yabbse and Ralph.  I am VERY happy now, and so are my users  

[Jenni]

How can I monitor my MySQL, slow queries etc.?
I have a 500 member 20000 message board and I havent noticed that it would have been slow.

Will I be able to upgrade to newer yabbse versions after upgrading my MySQL?

[tore-]

How can I monitor my MySQL, slow queries etc.?
I have a 500 member 20000 message board and I havent noticed that it would have been slow.

Will I be able to upgrade to newer yabbse versions after upgrading my MySQL?

well, since this is an official fix, correct me if wrong, yes, you will be able to upgrade, this fix will be standard in yabb se 2

[Jeff Lewis]

Yes you'll be able to upgrade...

[Altair]

Thanks alot guys! (an now you cant tell me to get a host jeff... Me got one! YaY! Board is working fine! except for this... http://www.yabb.info/community/index.php?board=140;action=display;threadid=8486

[DMiller]

When I run the script to change, indice and optimize it returns an error.

We found a MySQL Server with Version 3.23.49-log installed!
We change your tables to MyISAM type and analyze/optimze all tables!
Invalid query

It's hanging up in the typechanging() routine.

What should I do?

Thanks!

[queks]

How abt the image checker that resize all the pic. I though i read it somewhere in the thread that this is another "main reason" that slow down the forum. Any patch for that ??

[firewired]

I optimized PinoyDVD using the supplied scripts and the speed up was dramatic for a while. Last week, we suddenly began to experience the too many connections error with increasing frequency. This happens regardless of the number of people who are online. I ran the monthly optimize script last weekend and it helped a bit.

Now the errors are back and the board is slowing down again so much so that people are starting to notice:

Site Feedback

I just ran the optimize script again for good measure. Aside from this, is there anything else that can be done?

We're on a premium plan with Hostway by the way and we've never had problems with them. Just to make sure, I've filed a trouble ticket there as well.

[Spaceman-Spiff]

has anyone written a php script for this?
my friend was wondering if it exists, since he doesnt have phpMyAdmin in his server

[Jeff Lewis]

Um...did you look about 10 posts above yours? Wedge posted one I think...

[Spaceman-Spiff]

whoops, sry, my bad  

[Vin99NL BOFH]

if i knew this only one day before

My host Powweb.com stopped hosting me becouse of server abuse.. i think this was it..