|
Re:forum is so damn slow 4 Months, 3 Weeks ago
|
|
|
TCF wrote:
this is the latest development, a message from support, what do you reckon?
I was actually looking up your account due to a huge mysql problem, and I
think this would explain your problems with memory and slowness. The
problem are these queries below being ran on the "oscarlover" database.
They are taking over 2700 seconds (over 45 minutes) to run, causing your
oscarlover database to be locked and not usable, causing high load on the
tachibana mysql server which effects your databases and all other
customers on it, plus due to the slowness it makes your memory usage on
the web server go very high. We cannot allow such long running queries
on the shared hosting mysql server to cause high load. When I found the
mysql server, the load was in the high 20's (normal load is 1 to 3):
There are 2 possibilities, your indexes on db are wrong, send us db structure (data not needed). Or you have 1000's connections to the web, which means many customers, or spammers/robots.
|
|
jerry (User)
Senior Boarder
Posts: 156
|
 Logged
|
|
|
The administrator has disabled public write access.
|
|
|
Re:forum is so damn slow 4 Months, 3 Weeks ago
|
|
|
Sorry, what do you mean structure.
|
|
TCF (User)
Junior Boarder
Posts: 48
|
Logged
|
|
|
The administrator has disabled public write access.
|
|
|
Re:forum is so damn slow 4 Months, 3 Weeks ago
|
|
|
TCF wrote:
Sorry, what do you mean structure.
If you are using phpmyadmin, choose your joomla db - export - UNcheck data - Go.
Attach it here, we will see.
|
|
jerry (User)
Senior Boarder
Posts: 156
|
Logged
|
|
|
The administrator has disabled public write access.
|
|
|
Re:forum is so damn slow 4 Months, 3 Weeks ago
|
|
TCF wrote:
This ok?
ok, problem found, missing indexes... i will write script for you... but now i am busy.
|
|
jerry (User)
Senior Boarder
Posts: 156
|
Logged
|
|
|
The administrator has disabled public write access.
|
|
|
Re:forum is so damn slow 4 Months, 3 Weeks ago
|
|
|
you're a star, thx. I wonder if this happened when I upgraded to 1.0.4? I remember that when I pasted in the script, I got errors on all of it, but then the forum started working, I bet you it's got something to do with that?
|
|
TCF (User)
Junior Boarder
Posts: 48
|
Logged
|
|
|
The administrator has disabled public write access.
|
|
|
Re:forum is so damn slow 4 Months, 3 Weeks ago
|
|
jerry wrote:
TCF wrote:
This ok?
ok, problem found, missing indexes... i will write script for you... but now i am busy.
choose your joomla db - sql and run this code, hopefully it runs without errors (if no, copy-paste them here).
| Code: |
ALTER TABLE jos_fb_messages
DROP KEY hold_catid_id,
ADD KEY thread (thread),
ADD KEY parent (parent),
ADD KEY catid (catid),
ADD KEY ip (ip),
ADD KEY userid (userid),
ADD KEY time (time),
ADD KEY locked (locked),
ADD KEY hold_time (hold,time);
ALTER TABLE jos_fb_messages_text
DROP KEY mesid,
ADD PRIMARY KEY mesid (mesid);
ALTER TABLE jos_fb_moderation
ADD PRIMARY KEY (catid,userid);
ALTER TABLE jos_fb_sessions
ADD PRIMARY KEY (userid);
ALTER TABLE jos_fb_subscriptions
ADD KEY thread (thread),
ADD KEY userid (userid);
ALTER TABLE jos_fb_users
ADD PRIMARY KEY (userid);
|
|
|
jerry (User)
Senior Boarder
Posts: 156
|
Logged
|
|
|
Last Edit: 2008/07/03 16:30 By jerry.
Reason: removed parent
|
|
|
The administrator has disabled public write access.
|
|
|
Re:forum is so damn slow 4 Months, 3 Weeks ago
|
|
|
error
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(hold,catid,id),
ADD KEY thread (thread),
ADD KEY parent (parent),
ADD KEY' at line 2
|
|
TCF (User)
Junior Boarder
Posts: 48
|
Logged
|
|
|
The administrator has disabled public write access.
|
|
|
Re:forum is so damn slow 4 Months, 3 Weeks ago
|
|
|
TCF wrote:
error
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(hold,catid,id),
ADD KEY thread (thread),
ADD KEY parent (parent),
ADD KEY' at line 2
ok, find and replace wasn't so good, now it should be ok.
|
|
jerry (User)
Senior Boarder
Posts: 156
|
Logged
|
|
|
Last Edit: 2008/07/03 15:47 By jerry.
|
|
|
The administrator has disabled public write access.
|
|
|
Re:forum is so damn slow 4 Months, 3 Weeks ago
|
|
|
ok, find and replace wasn't so good, now it should be ok.
sorry Jerry, I'm not quite with you.
|
|
TCF (User)
Junior Boarder
Posts: 48
|
Logged
|
|
|
The administrator has disabled public write access.
|
|
|
Favoured: 0
