Welcome, Guest. Please Login or Register.
November 17, 2017, 11:14:26 PM
Home Help Search Login Register
News: If you are still using YaBB SE, please consider upgrading to SMF as soon as possible.

YaBB SE Community  |  General Category  |  Feedback  |  Topic: Mysql Optimizer - where did it go? « previous next »
Pages: [1] Reply Ignore Print
Author Topic: Mysql Optimizer - where did it go?  (Read 9628 times)
akpcep
Noobie
*
Posts: 33


I'm not a f*ckin llama.


WWW
Mysql Optimizer - where did it go?
« on: February 26, 2004, 09:16:25 AM »
Reply with quote

Hi,

I seem to remember there was a little script you could run that added extra indices to the Yabb tables - I've been searching these boards for an hour but all the links to it are dead. Can someone please point me to it's current location?

Many thanks.
Logged

[Unknown]
Global Moderator
YaBB God
*****
Posts: 7830



WWW
Re:Mysql Optimizer - where did it go?
« Reply #1 on: February 26, 2004, 11:06:09 PM »
Reply with quote

Well, you don't want *extra* indexes or anything, just the right amount of them.

However, if you click the "Optimize Database" link in your admin center it should speed things up a little.

-[Unknown]
Logged
akpcep
Noobie
*
Posts: 33


I'm not a f*ckin llama.


WWW
Re:Mysql Optimizer - where did it go?
« Reply #2 on: February 27, 2004, 02:34:14 AM »
Reply with quote

Thanks for your reply!

I think I found a thread in which the indices were listed, and my install already had them all. I've turned off the click log and stats and what have you so I think it's about as fast as it's going to get.

Hey ho!
Logged

Pages: [1] Reply Ignore Print 
YaBB SE Community  |  General Category  |  Feedback  |  Topic: Mysql Optimizer - where did it go? « previous next »
 


Powered by MySQL Powered by PHP YaBB SE Community | Powered by YaBB SE
2001-2003, YaBB SE Dev Team. All Rights Reserved.
SMF 2.0.12 | SMF © 2016, Simple Machines
Valid XHTML 1.0! Valid CSS!
Page created in 0.082 seconds with 19 queries.