Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
troubles with my db
It seems that there is something wrong with the db of my site and due to this, I am getting slow speeds
I only use phpMyAdmin to repair/optimise tables but today for the first time I used “check table” which returned these results:
<pre>Problems with indexes of table `textpattern`
More than one FULLTEXT key was created for column `Title`
More than one FULLTEXT key was created for column `custom_2`
Problems with indexes of table `txp_discuss`
More than one FULLTEXT key was created for column `message`
Problems with indexes of table `txp_form`
PRIMARY and INDEX keys should not both be set for column `name`
Problems with indexes of table `txp_lang`
UNIQUE and INDEX keys should not both be set for column `lang`
Problems with indexes of table `txp_lxs_forumcache`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `txp_page`
PRIMARY and INDEX keys should not both be set for column `name`
Problems with indexes of table `txp_plugin`
UNIQUE and INDEX keys should not both be set for column `name`
Problems with indexes of table `txp_section`
PRIMARY and INDEX keys should not both be set for column `name`
Problems with indexes of table `txp_subscribers`
PRIMARY and INDEX keys should not both be set for column `user_id`</pre>
I’m not sure if the results above are common or if they show the beginnings of a major problem. (I am no programmer). What worries me the most is the “FULLTEXT” errors and the “Problems with indexes of table”.
My diagnostics pass fine and I am using 4.03/sv1209
Can anyone tell me if the above is normal?
Last edited by colak (2006-02-01 15:55:51)
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: troubles with my db
Yes, there are a few unnecessary indices on tables. However that will only affect write-performance, and in the context of our use cases (php-scipts that read and write to/from the database-tables with at most tens of thousands of records, the performance-hit is hardly measureable [let alone noticable]).
Those messages are not related to your “slow speeds” problems.
Offline
Re: troubles with my db
> Sencer wrote:
> Yes, there are a few unnecessary indices on tables. However that will only affect write-performance, and in the context of our use cases (php-scipts that read and write to/from the database-tables with at most tens of thousands of records, the performance-hit is hardly measureable [let alone noticable]).
Those messages are not related to your “slow speeds” problems.
Hi sencer.
As always you are always there for us. Thanks!
Is there a way I can fix these unnecessary indices?
Last edited by colak (2006-02-01 17:30:32)
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Pages: 1