Overhead

[Tree*Rat]

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?

[Erwin Moller]

Tree*Rat schreef:

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?

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

[=?ISO-8859-1?Q?=22=C1lvaro_G=2E_Vicario=22?=]

Tree*Rat escribió:

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?

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
--

[Captain Paralytic]

On 4 Nov, 09:07, "Tree*Rat" <[e-mail]:

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

http://www.google.com/search?q=mysql+overhead

[Tree*Rat]

Captain Paralytic <pa**********@yahoo.comwrote in news:41579880-dab6-
41********************@q26g2000prq.googlegroups.co m:

http://www.google.com/search?q=mysql+overhead

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