Search found 10 matches

by mouragio
Sat Nov 28, 2009 8:24 pm
Forum: [3.0.x] Support Forum
Topic: Low performance mysql problem?
Replies: 17
Views: 785

Re: Low performance mysql problem?

I think tonight I've found the problem. I've searched for the query; en he was envoked bij the rss.php.

Since i've disabled the rss feeds earlier this evening; no lockups; forums are very quick, and the processstatus shows fast responce times.

So my problem looks solved.
by mouragio
Mon Nov 23, 2009 12:15 pm
Forum: [3.0.x] Support Forum
Topic: Low performance mysql problem?
Replies: 17
Views: 785

Re: Low performance mysql problem?

ok; well I dunno any more.... 20 minutes ago the server has hung up itself (too many connections)... restart of mysql-server was very slow; now it is running again. The strange thing is that the "old" server (Dell 1950 64bit 4GB/ 2x146GB SAS) was running very smoothly with the same site (did only an...
by mouragio
Mon Nov 23, 2009 10:25 am
Forum: [3.0.x] Support Forum
Topic: Low performance mysql problem?
Replies: 17
Views: 785

Re: Low performance mysql problem?

I'm a little bit further now... The tables topics and forums are now on innodb instead of MyISAM, that part doesn't lock anymore Problem with the slow query exist: | Id | User | Host | db | Command | Time | State | Info | +-------+---------+-----------+-------------+---------+------+----------------...
by mouragio
Fri Nov 13, 2009 9:30 am
Forum: [3.0.x] Support Forum
Topic: Low performance mysql problem?
Replies: 17
Views: 785

Re: Low performance mysql problem?

another thing; looks like there is another problem... the slowdown doesn't seem to be in the above.... just had another; yesterday in the evening this list was very, very long... this one is a bit shorter; but... the state "locked" doesn't seem very good... +--------+---------+-----------+----------...
by mouragio
Fri Nov 13, 2009 9:03 am
Forum: [3.0.x] Support Forum
Topic: Low performance mysql problem?
Replies: 17
Views: 785

Re: Low performance mysql problem?

thanx... update will be done as soon as it's out of RC; but i think that has nothing to do with the performance...

what i saw was that the old server was a dell 1950; so 64 bit machine... this one is a compaq dl580; 32 bits...

But that should not make a diffrece; or will it?
by mouragio
Tue Nov 10, 2009 9:51 am
Forum: [3.0.x] Support Forum
Topic: Low performance mysql problem?
Replies: 17
Views: 785

Re: Low performance mysql problem?

ok; thank you... Maybe it's the SEO... i will look further in it.
by mouragio
Tue Nov 10, 2009 9:10 am
Forum: [3.0.x] Support Forum
Topic: Low performance mysql problem?
Replies: 17
Views: 785

Re: Low performance mysql problem?

hmmm doens't look like a mod... mods installed: -Quickreply - RSS feeds 2.0 - Ultimate SEO 0.60 - paypal donate Just got a longrunner myself; and it was on the "view latest posts" query... had a tail on the slow query log and instantly it came with the same: # Time: 091110 10:09:24 # User@Host: vwfo...
by mouragio
Tue Nov 10, 2009 8:57 am
Forum: [3.0.x] Support Forum
Topic: Low performance mysql problem?
Replies: 17
Views: 785

Re: Low performance mysql problem?

ok; I've asked what mods are implemented...

that could be :) thanxx for the answer. will return with the result...
by mouragio
Tue Nov 10, 2009 8:00 am
Forum: [3.0.x] Support Forum
Topic: Low performance mysql problem?
Replies: 17
Views: 785

Re: Low performance mysql problem?

ow one more thing... the forum that is added is an version 3.0.5; so up to date....
by mouragio
Tue Nov 10, 2009 7:59 am
Forum: [3.0.x] Support Forum
Topic: Low performance mysql problem?
Replies: 17
Views: 785

Low performance mysql problem?

hi All; a little history: On my server Compaq DL580G2 with >4 GB ram and 4x36,4 SCSI disks in raid 5; has the following: - Mysql server 5.1.40 - Mysql Client 5.1.40 - Apache 2.2 - Php 5 On this server i've an forum with phpbb 3.01 (I knwo; i must upgrade). the performance was reasonable. Last week i...

Go to advanced search