Search found 148 matches

by lanzer
Sun Jan 04, 2004 5:35 am
Forum: 2.0.x Support Forum
Topic: MySQL problem
Replies: 13
Views: 465

Hello alitokmen: The problem which you mentioned has to do with the fact that your MySQL server had trouble creating temp tables when it needs to. Temp tables are created on memory consuming queries that involves sorting or grouping. Notice that it's trying to write to the temp folder with the (MYI)...
by lanzer
Fri Dec 05, 2003 9:03 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631375

Re: Thoughts on buddy list

Do you believe this will be a problem even with appropriate indexing? The index should be hit first, and with the granularity that you are talking about a combination key with (my_user_id, other_user_id) should be very efficient. From my ideal implementation I plan to have friends list information ...
by lanzer
Fri Dec 05, 2003 3:09 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631375

Thoughts on buddy list

Started working on a buddylist system 3 months ago. Been having constant delays because of upgrade and maintenance issues. The buddylist was completed and working, but it struck me that what I've got could cause a lot of database slowdown because I have all each buddy/ignore info stored as single ro...
by lanzer
Fri Dec 05, 2003 2:32 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631375

I've just made an alteration to move the lookups from get_db_stat to a cronjob in the same way that you surgested for the to do it for online users and last posts for forums since I have quite a large users table, (only arround 10 post per user) and even tho the users lookups are fairly quick, ther...
by lanzer
Thu Dec 04, 2003 4:45 pm
Forum: 2.0.x Discussion
Topic: phpBB and mod_security for Apache httpd?
Replies: 2
Views: 279

Hi guys, mod_security and mod_dosevasive are two mods that I'm very interested in trying. Unfortunately my Mandrake 9.x distros don't seem to come with apxs even when I got httpd2-devel installed, and at that point I ran out of time. :cry:

Please keep us posted on your finding. :wink:
by lanzer
Thu Dec 04, 2003 4:25 pm
Forum: 2.0.x Discussion
Topic: Smilies and mysql-server load
Replies: 3
Views: 407

On the server end, smilies are just a bunch of search and replace much like BBCODE, but yes, the more smilies, the more passes it needs to make. The bigger problem is that the animated smilies often take up a lot of CPU power on the client's computer. Having too many smilies will crash Internet Expl...
by lanzer
Thu Dec 04, 2003 1:30 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631375

Hi Darkangel: When it comes to indexes, the few indexes that I added were all mentioned in my previous posts. It's mainly the post_id + topic_id combo I added for post table, and the forum_id + topic_id combo for the topics table. The post table index is almost mandatory to have a forum that can do ...
by lanzer
Thu Dec 04, 2003 6:18 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631375

Re: Silly performance hacks

Hello Atari: Hey if MySQL works great on Linux, then why consider using something else? Installing any Linux distribution then MySQL is only a day's work, then you'll have yourself a solid database server that'll stay up for months. It's good stuff. I have no problem sharing my setup info, I just he...
by lanzer
Wed Dec 03, 2003 2:19 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631375

Can't get enough of query enhancements

In the corner of my eye I spotted a few queries that were taking a few seconds to load, and so a few changes were made: file: functions_post.php $sql = "SELECT MAX(post_id) AS last_post_id FROM " . POSTS_TABLE . " WHERE topic_id = $topic_id"; had been changed to $sql = "SELECT post_id AS last_post_i...
by lanzer
Wed Dec 03, 2003 1:51 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631375

Speeding up memberlist.

Just made another silly modification earlier: Saw a few queries taking a few minutes to complete, turns out the memberlist is slowing the site down today. By default it sorts by registration date, and the SQL statements also sorts by registration date. Though reg date is not indexed, so instead if y...
by lanzer
Tue Dec 02, 2003 3:18 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631375

Re: Silly performance hacks

Hi Atari, here's a list of our current setup: 4 Forum front end, 1 graphics front end, 1 misc. service frontend, 1 avatar server, and one database backend. Of the 4 forums: - 3 are P4 2.6Ghz machines with 2G of RAM, one IDE HD (taking 50 page/second, setup to take ~250 simultaneous connections) - 1 ...
by lanzer
Tue Dec 02, 2003 2:50 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631375

Hello bboombotz: Well I'm no PHP/MySQL expert neither, just somone thrown in the lion's den with a lot of hungry lions. :) Right now our POST_TEXT_TABLE size is 4GB. Imagine if everytime someone request a search, that the server needs to seek through 4GB worth of data from the HD, that would be too ...
by lanzer
Mon Dec 01, 2003 2:29 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631375

Silly performance hacks

One thing that I did a while back was a silly threadview update hack. Basically, everytime someone views a thread, a counter goes up by one. To avoid so many database updates on such a trivial data, I made a quick mod on viewtopic.php: $sql = "UPDATE " . TOPICS_TABLE . " SET topic_views = topic_view...
by lanzer
Fri Nov 28, 2003 8:53 pm
Forum: 2.0.x Discussion
Topic: 2 Forums Using 3 DB's. One for each forum and one for users
Replies: 26
Views: 1955

Hi Fix_it_guy: Sorry for the late reply. Work's been hell. If you need more detail here's an example: Add this to the end of the db.php file, right before "?>" $db_user = new sql_db('<hostname>', '<username>', '<password>', $dbname, false); if(!$db->db_connect_id) { message_die(CRITICAL_ERROR, "Coul...
by lanzer
Fri Nov 28, 2003 7:03 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631375

InFamous> Please post at Gaia Online or PM me, do not listen to rumours. Zemog > Thanks for the input. I remember running a test code to catch repeated characters but I don't know what happened to it. Shows you how organized I am. :) The number hack is cool too, something I never thought about. Anyw...

Go to advanced search