Welcome, Guest. Please Login or Register.
November 25, 2017, 04:51:03 AM
Home Help Search Login Register
News: If you are still using YaBB SE, please consider upgrading to SMF as soon as possible.

YaBB SE Community  |  English User Help  |  FAQ  |  Topic: Large message boards and MySQL logs of slow response « previous next »
Pages: 1 ... 6 7 [8] 9 10 Reply Ignore Print
Author Topic: Large message boards and MySQL logs of slow response  (Read 63146 times)
Jeff Lewis
Global Moderator
YaBB God
*****
Posts: 10149


I'm a llama!


WWW
Re:Large message boards and MySQL logs of slow response
« Reply #105 on: July 31, 2002, 06:35:23 AM »
Reply with quote

If you're using 1.4, use BoardIndex.php from 1.3 until 1.4.1 is released.
Logged

djMostly
Noobie
*
Posts: 14


I'm a llama!


Re:Large message boards and MySQL logs of slow response
« Reply #106 on: August 01, 2002, 12:09:50 AM »
Reply with quote

tried that, but now i'm struggling with database user access problems.  ugh.  not sure if it's the "patch" or a problem with my host.
Logged
mediman
Support Team
YaBB God
*****
Posts: 2858



WWW
Re:Large message boards and MySQL logs of slow response
« Reply #107 on: August 01, 2002, 10:32:32 AM »
Reply with quote


When using the convert php i get this?

Fatal error: Call to undefined function: mysql_get_server_info() in /files/local/home/earthdome/forum/convert.php on line 10

I'm running version  3.22.32 of MySql

I have since read that i need version 3.23.xx.
Time to hassle my host.



your installation does not support get_server_info, so delete this part from the script!

mediman
Logged

mainComm Dev Team
mephisto_kur
Sr. Member
****
Posts: 308


Hi ho.


WWW
Re:Large message boards and MySQL logs of slow response
« Reply #108 on: August 02, 2002, 01:18:06 AM »
Reply with quote

Very small board..  But 8 guys post 1000 times a week...  (125 topics)...

Even so small, its noticably faster.
Logged



Awmp, ding, soo googoongee doop, dee
Googoo Fleegoogeegoo
Goo Fleegoogeegoo
Duht, Deeheeh
Oogoogoog Dtee
Oogoogagoo oogoogweee
Fleegoogeegoo, fleegow
Go go mah mah mefs sufh yeah...
djMostly
Noobie
*
Posts: 14


I'm a llama!


Re:Large message boards and MySQL logs of slow response
« Reply #109 on: August 05, 2002, 11:31:54 AM »
Reply with quote

how would one uninstall this patch?
Logged
Snowman30
Jr. Member
**
Posts: 67



WWW
Re:Large message boards and MySQL logs of slow response
« Reply #110 on: August 05, 2002, 09:34:44 PM »
Reply with quote

Im totally lost with all this.

I have 1.4 which was built up from 1.3 as an upgrade.

I have MySQL 3.23.45

now my board is slow and i want to speed it up, which of these files should i be running??? Ive downloaded the zip of the files and installed them on the server but i dont know which one i should use???

Couls someone please shed some light on this for me please.

Thanks
Logged
mephisto_kur
Sr. Member
****
Posts: 308


Hi ho.


WWW
Re:Large message boards and MySQL logs of slow response
« Reply #111 on: August 06, 2002, 12:56:42 AM »
Reply with quote

Use Convert.php first, then use Optimze.php regularly.  Convert adds the indexes and Optimize cleans 'em.
Logged



Awmp, ding, soo googoongee doop, dee
Googoo Fleegoogeegoo
Goo Fleegoogeegoo
Duht, Deeheeh
Oogoogoog Dtee
Oogoogagoo oogoogweee
Fleegoogeegoo, fleegow
Go go mah mah mefs sufh yeah...
Snowman30
Jr. Member
**
Posts: 67



WWW
Re:Large message boards and MySQL logs of slow response
« Reply #112 on: August 06, 2002, 01:16:55 AM »
Reply with quote

excellent...thanks for that...

Now is there anything else i can do to get a faster load time....im on a server that gives most of my sites viewers a ping of around 300ms so anything i can do to squueze performance out of it will help.
Logged
Frodo
Noobie
*
Posts: 21


I'm a llama!


WWW
Re:Large message boards and MySQL logs of slow response
« Reply #113 on: August 17, 2002, 08:38:48 AM »
Reply with quote


try this script it makes all changes for you!
Code: [Select]
<?php<br><br>$db_name "";<br>$db_user "";<br>$db_passwd "";<br>$db_server "";<br>$db_prefix "";<br><br>mysql_connect("$db_server","$db_user","$db_passwd");<br>$vers mysql_get_server_info();<br>if(eregi("3.23",$vers)) {<br>echo "We found a MySQL Server with Version <b>$vers</b> installed!<br>";<br>echo "<font color ='red'>We change your tables to MyISAM type and analyze/optimze all tables also indices will be added!</font><br>";<br>typechanging();<br>optimize();<br>addindices();<br>} else {echo "We found a MySQL Server with Version <b>$vers</b> installed!<br>";<br>echo "<font color ='red'>tables will analyzed and optimzed and indices added will be added!</font><br>"; <br>optimize();<br>addindices();<br>}<br><br><br>function typechanging() {<br>global $db_name;<br>mysql_select_db($db_name); <br>$tables=mysql_list_tables($db_name);<br>while (list($bla)=mysql_fetch_array($tables)) {<br>$result mysql_query("ALTER TABLE $bla TYPE=MyISAM")or die("Invalid query");<br>echo "Table <font color=blue>".$bla."</font> converted to MyISAM!<br>"; <br>}<br>}<br><br>function optimize() {<br>global $db_name;<br>mysql_select_db($db_name); <br>$tables=mysql_list_tables($db_name);<br>while (list($bla)=mysql_fetch_array($tables)) {<br>$result mysql_query("OPTIMIZE TABLE $bla")or die("Invalid query");<br>echo "Table <font color=blue>".$bla."</font> analyzed and optimized!<br>"; <br>}<br>}<br><br>function addindices() {<br>global $db_name,$db_prefix;<br>mysql_select_db($db_name); <br>mysql_query("ALTER TABLE {$db_prefix}members add key(memberGroup(30)");<br>mysql_query("ALTER TABLE {$db_prefix}members add key(posts)");<br>mysql_query("ALTER TABLE {$db_prefix}members add key(memberName(30)");<br>mysql_query("ALTER TABLE {$db_prefix}members add key(dateRegistered)");<br>mysql_query("ALTER TABLE {$db_prefix}members add key(lastLogin)");<br>mysql_query("ALTER TABLE {$db_prefix}messages add key(posterTime)");<br>mysql_query("ALTER TABLE {$db_prefix}instant_messages add key (ID_MEMBER_FROM)");<br>mysql_query("ALTER TABLE {$db_prefix}instant_messages add key (ID_MEMBER_TO)");<br>mysql_query("ALTER TABLE {$db_prefix}instant_messages add key (deletedBy)");<br>mysql_query("ALTER TABLE {$db_prefix}instant_messages add key(fromName(30)");<br>mysql_query("ALTER TABLE {$db_prefix}instant_messages add key(toName(30)");<br>mysql_query("ALTER TABLE {$db_prefix}categories add key (catOrder)");<br>mysql_query("ALTER TABLE {$db_prefix}boards add key (ID_CAT)");<br>mysql_query("ALTER TABLE {$db_prefix}log_boards add key (ID_BOARD)");<br>mysql_query("ALTER TABLE {$db_prefix}log_boards add key (memberName(30)");<br>mysql_query("ALTER TABLE {$db_prefix}log_topics add key (membername(30)");<br>mysql_query("ALTER TABLE {$db_prefix}log_topics add key (logTime)");<br>mysql_query("ALTER TABLE {$db_prefix}log_topics add key (ID_TOPIC)");<br>mysql_query("ALTER TABLE {$db_prefix}log_activity add key (month)");<br>mysql_query("ALTER TABLE {$db_prefix}log_activity add key (day)");<br>mysql_query("ALTER TABLE {$db_prefix}log_activity add key (year)");<br>mysql_query("ALTER TABLE {$db_prefix}log_activity add key (mostOn)");<br>mysql_query("ALTER TABLE {$db_prefix}log_errors add key (logTime)");<br>mysql_query("ALTER TABLE {$db_prefix}log_errors add key (memberName(30)");<br>mysql_query("ALTER TABLE {$db_prefix}log_floodcontrol add key (ip(20)");<br>mysql_query("ALTER TABLE {$db_prefix}log_floodcontrol add key (logTime)");<br>mysql_query("ALTER TABLE {$db_prefix}log_karma add key (ID_TARGET)");<br>mysql_query("ALTER TABLE {$db_prefix}log_karma add key (ID_EXECUTOR)");<br>mysql_query("ALTER TABLE {$db_prefix}log_karma add key(logTime)");<br>mysql_query("ALTER TABLE {$db_prefix}log_mark_read add key (memberName(30)");<br>mysql_query("ALTER TABLE {$db_prefix}log_mark_read add key (ID_BOARD)");<br>mysql_query("ALTER TABLE {$db_prefix}log_mark_read add key (logTime)");<br>mysql_query("ALTER TABLE {$db_prefix}log_online add key (logTime)");<br>mysql_query("ALTER TABLE {$db_prefix}settings add key(variable(30)");<br>echo "<font color ='red'>Indices succesfully added!</font>";<br>}<br><br>?>

What do I do with this? I am using tripod.co.uk and at first it was really fast, but now with like 30 topics and 200 posts, members are complaining how slow it is. I have defianately seen an increase in speed also. I tried running the first one in this topic in phpmyadmin as a query, it worked, no difference. Then I tried running your code mediman, and i get an error in my db name where there is no error! What do I do?
Logged
Daniel D.
Mod Team
YaBB God
*****
Posts: 2935



Re:Large message boards and MySQL logs of slow response
« Reply #114 on: August 17, 2002, 09:11:57 AM »
Reply with quote

1. Copy the code into notepad.
2. Insert your datas in the first lines (db password, db name etc.).
3. Save it as 'optimize.txt'.
4. Upload it to your FTP server in the YaBB SE directory and rename it to 'optimize.php'.
5. Run it in your browser - that's it !
« Last Edit: August 17, 2002, 09:17:08 AM by Daniel D. » Logged

Stud Muffin
Full Member
***
Posts: 120


Oh baby!!


WWW
Re:Large message boards and MySQL logs of slow response
« Reply #115 on: August 17, 2002, 05:54:35 PM »
Reply with quote

Do you need to put the board in maint mod before you run the optimize scipt?

Code: [Select]
function optimize() {
global $db_name;
mysql_select_db($db_name);
$tables=mysql_list_tables($db_name);
while (list($bla)=mysql_fetch_array($tables)) {
$result = mysql_query("OPTIMIZE TABLE $bla")or die("Invalid query");
echo "Table <font color=blue>".$bla."</font> analyzed and optimized!<br>";
}
}
Logged

Thanks to all the YaBBSE team, a great forum :)
OAP clan Forum
Compuart
Quality, Quality, Quality!
YaBB God
*****
Posts: 1283



WWW
Re:Large message boards and MySQL logs of slow response
« Reply #116 on: August 18, 2002, 05:50:18 PM »
Reply with quote

In case the 1.4.1 boardindex still isn't going fast enough, here's a mod that reduces the number of queries 3 * number_of_boards times.
Logged

medizinmann
Guest
Re:Large message boards and MySQL logs of slow response
« Reply #117 on: August 18, 2002, 06:39:58 PM »
Reply with quote

Do you need to put the board in maint mod before you run the optimize scipt?
No, because mysql will lock your tables during optimizing!

@compuart nice script
« Last Edit: August 24, 2002, 04:14:41 PM by medizinmann » Logged
medizinmann
Guest
Re:Large message boards and MySQL logs of slow response
« Reply #118 on: August 24, 2002, 04:17:31 PM »
Reply with quote

we updatet the dboptimizer.php

please download it here http://www.yabb.info/community/attachments/dbmain2.zip

both scripts will be includet in adminsecion (as a mod)

m.

« Last Edit: August 26, 2002, 06:04:32 PM by medizinmann » Logged
goosemoose
Sr. Member
****
Posts: 256


I'm a llama!


Re:Large message boards and MySQL logs of slow response
« Reply #119 on: September 16, 2002, 12:21:33 PM »
Reply with quote

Is this included in 1.4.1 then, or should I run this and compuart's mod?
Logged

MobileYaBB v.3 [75% done]
All in One MemberList 1.0
Integrated Chat v 2.0
Pages: 1 ... 6 7 [8] 9 10 Reply Ignore Print 
YaBB SE Community  |  English User Help  |  FAQ  |  Topic: Large message boards and MySQL logs of slow response « previous next »
 


Powered by MySQL Powered by PHP YaBB SE Community | Powered by YaBB SE
2001-2003, YaBB SE Dev Team. All Rights Reserved.
SMF 2.0.12 | SMF © 2016, Simple Machines
Valid XHTML 1.0! Valid CSS!
Page created in 0.089 seconds with 19 queries.