|
|
Joined: May 2003
Posts: 115
Journeyman
|
Journeyman
Joined: May 2003
Posts: 115 |
hi all,
forums been running fine for about a weeks of 6.5b but the last 2 days its been sooooooo slow, i've tried to find in the admin section the sql cleanup thingy lol!!! but cant see it... any ideas
Generated in 15.258 seconds in which 15.169 seconds were spent on a total of 23 queries. Zlib compression enabled.
|
|
|
|
Joined: Oct 2003
Posts: 2,305
Old Hand
|
Old Hand
Joined: Oct 2003
Posts: 2,305 |
u talking optimize tables of 6.4? yeah thats basically gone in 6.5 but you can do a query in the sql section of the control panel.
|
|
|
|
Joined: May 2003
Posts: 115
Journeyman
|
Journeyman
Joined: May 2003
Posts: 115 |
yeah thanks!! Do you know what query i need to run? Cheers
|
|
|
|
Joined: Oct 2003
Posts: 2,305
Old Hand
|
Old Hand
Joined: Oct 2003
Posts: 2,305 |
depends on the table but think MOST are myisam
you can some of the following
to check the table use
myisamchk --quick --check-only-changed --sort-index --analyze
to optimize it use
OPTIMIZE [LOCAL | NO_WRITE_TO_BINLOG] TABLE tbl_name [, tbl_name] ...
as in
OPTIMIZE TABLE `w3t_WiggButtsandBooties`
if innodb type you can
ALTER TABLE [tbl_name] TYPE=innodb
to optimize it
|
|
|
|
Joined: May 2003
Posts: 115
Journeyman
|
Journeyman
Joined: May 2003
Posts: 115 |
Hey thanks... didnt make any difference though... Cheers
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 1,157
Joined: July 2001
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|