Search found 27 matches

by nE0sIghT
Thu Aug 04, 2011 2:54 am
Forum: [3.0.x] Support Forum
Topic: Slowdown: huge topics & mysql
Replies: 12
Views: 2133

Re: Slowdown: huge topics & mysql

EXreaction wrote:You could try making an index for the three columns
Our system administrator created such index yesterday.

And now explain returns:
untitled.png
untitled.png (17.94 KiB) Viewed 1959 times
For last night there is no slow queries in log
sqlhjalp wrote:Can you email me the explain and more details.
Sent
by nE0sIghT
Wed Aug 03, 2011 3:32 pm
Forum: [3.0.x] Support Forum
Topic: Slowdown: huge topics & mysql
Replies: 12
Views: 2133

Re: Slowdown: huge topics & mysql

Please run `analyze table posts` and repeat explain. If there are any differences post the new one here. Same result Are the topics that you mentioned consistently taking 10+ seconds to load No. I just see a bunch of slow queries in log. All related to this viewtopic query Do you have any public to...
by nE0sIghT
Wed Aug 03, 2011 3:16 am
Forum: [3.0.x] Support Forum
Topic: Slowdown: huge topics & mysql
Replies: 12
Views: 2133

Re: Slowdown: huge topics & mysql

Support Request Template What version of phpBB are you using? phpBB 3.0.9 What is your board's URL? http://forum.awd.ru Who do you host your board with? No answer given How did you install your board? I used the download package from phpBB.com Is your board a fresh install or a conversion? Conversi...
by nE0sIghT
Tue Aug 02, 2011 4:28 pm
Forum: [3.0.x] Support Forum
Topic: Slowdown: huge topics & mysql
Replies: 12
Views: 2133

Re: Slowdown: huge topics & mysql

Problem query located in the viewtopic.php at line 933: // Go ahead and pull all data for this topic $sql = 'SELECT p.post_id FROM ' . POSTS_TABLE . ' p' . (($join_user_sql[$sort_key]) ? ', ' . USERS_TABLE . ' u': '') . " WHERE p.topic_id = $topic_id " . ((!$auth->acl_get('m_approve', $forum_id)) ? ...
by nE0sIghT
Tue Aug 02, 2011 4:20 pm
Forum: [3.0.x] Support Forum
Topic: Slowdown: huge topics & mysql
Replies: 12
Views: 2133

Re: Slowdown: huge topics & mysql

The problem is that when user viewing 1 topic page (e.g. 20 posts), mysql sorts all topic posts.

The questions:
1) Is this phpbb's design mistake?
2) Can it be fixed?

Thx for reply
by nE0sIghT
Tue Aug 02, 2011 4:11 pm
Forum: [3.0.x] Support Forum
Topic: Slowdown: huge topics & mysql
Replies: 12
Views: 2133

Slowdown: huge topics & mysql

Latest phpBB, MySQL 5.1.54-log, InnoDB 8x Xeon 12Gb RAM From the mysql-slow.log: # Time: 110802 20:01:22 # User@Host: x @ localhost [] # Query_time: 16.996054 Lock_time: 0.000054 Rows_sent: 20 Rows_examined: 9298 SET timestamp=1312300882; SELECT p.post_id FROM phpbb_posts p WHERE p.topic_id = 27082 ...
by nE0sIghT
Fri Jan 15, 2010 10:20 pm
Forum: phpBB Discussion
Topic: [Discuss] A Change in Development Leadership
Replies: 59
Views: 10682

Re: [Discuss] A Change in Development Leadership

Thanks for all yours great work Meik !
by nE0sIghT
Fri Jul 06, 2007 10:25 am
Forum: [2.0.x] MODs in Development
Topic: [BETA] Jabber IM MoD 1.1.2
Replies: 36
Views: 8222

Re: [BETA] Jabber IM MoD 1.1.2

function stream_get_transports() available only in PHP5 and later, so i think your's php version is lower than 5 It is not so fatal, try to aply this patch: # #-----[ OPEN ]------------------------------------------ # admin/admin_jabber.php # #-----[ FIND ]------------------------------------------ ...
by nE0sIghT
Sat Mar 03, 2007 5:35 pm
Forum: [2.0.x] MODs in Development
Topic: [BETA] Jabber IM MoD 1.1.2
Replies: 36
Views: 8222

A new version 1.1.2 is available now.
It's mostly bugfix release, but also brings new feature - optional sending of part of new post with new-post-notification on JabberID.
by nE0sIghT
Tue Feb 27, 2007 7:25 pm
Forum: [2.0.x] MODs in Development
Topic: [BETA] Jabber IM MoD 1.1.2
Replies: 36
Views: 8222

Yep, AJAX is SOMETHING good, BUT it is NO NEED to use it in THIS mod since it is not provide some full JABBER IM SUPPORT NOR make phpBB a some kind of Jabber CLIENT. It is just use JABBER protocol instead(or with) e-mail forum features This mod does not need some real-time client-server features lik...
by nE0sIghT
Wed Feb 21, 2007 7:14 am
Forum: [2.0.x] MODs in Development
Topic: [BETA] Jabber IM MoD 1.1.2
Replies: 36
Views: 8222

Re: Features

I have found a bug, that prevents messages to be sent if JID containing extended characters(like cyrilic). To make it work, use this patch: # #-----------[ FIND ]--------------- # VALUES('$last_id', '{$jid}', '" . (function_exists("iconv") ? iconv($jabberLang, "UTF-8", preg_replace("#(?<!\r)\n#s", "...
by nE0sIghT
Mon Feb 19, 2007 9:23 pm
Forum: [2.0.x] MODs in Development
Topic: [BETA] Jabber IM MoD 1.1.2
Replies: 36
Views: 8222

And next update 1.1.1 is available!
This is bugfix release.
Because of many code changes in version 1.1 i returned to BETA MoD status. New features needs more testing
by nE0sIghT
Sun Feb 18, 2007 3:08 am
Forum: [2.0.x] MODs in Development
Topic: [BETA] Jabber IM MoD 1.1.2
Replies: 36
Views: 8222

The new version 1.1 is here!
Functionality is considerably expanded, speed of work is increased, think bugs are corrected. More details - in changelog
by nE0sIghT
Fri Jul 07, 2006 8:37 am
Forum: [2.0.x] MODs in Development
Topic: [BETA] Jabber IM MoD 1.1.2
Replies: 36
Views: 8222

Yep, this is a reason for incompatibility. If u send me your phpBB files on e-mail i can in a few days change MoD file to be compatible with your installation, BUT i recommend to you to install 2.0.21 board(Especially because you have not any other mods, this process will be very easy for you)

Go to advanced search