Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
Been working on a CMS for a few months now and noticed that in phpMyAdmin
it shows that one table in the database (mysql) has bad overhead, so I keep
having to optimize the table.

What causes this to happen so I can get rid of the problem or is it normal?
all the table actually hold is text.

 this is the table structure:-

        txt_id mediumint(8) UNSIGNED NOT NULL auto_increment,
    txt_mod_id mediumint(8) UNSIGNED NOT NULL,
    txt_fulltext text,
    PRIMARY KEY (txt_id)

any ideas?

Re: Overhead

Tree*Rat schreef:
Quoted text here. Click to load it

Yes: comp.databases.mysql

Erwin Moller

"There are two ways of constructing a software design: One way is to
make it so simple that there are obviously no deficiencies, and the
other way is to make it so complicated that there are no obvious
deficiencies. The first method is far more difficult."
-- C.A.R. Hoare

Re: Overhead

Tree*Rat escribió:
Quoted text here. Click to load it

The table design itself doesn't say much. Just have a look at your code
and look for common errors: fetching unnecessary data, redundant
queries, filtering by non-indexed columns... Also, MySQL itself offers
several tools to optimize queries: slow queries log, explain plans...
But that's beyond the scope of this group ;-)

-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://bits.demogracia.com
-- Mi web de humor al baño María: http://www.demogracia.com

Re: Overhead


Quoted text here. Click to load it

thanks, found some good articles that are interesting! goona take so
reading though! lol.

Site Timeline