hw to delete indexes seem to be equal and one of them could possibly be removed?

[abdul ghany syed]

I have seen that there is some duplicate Indexes in my database when checking table, after seeing duplicate indexes http://prntscr.com/gss70a
i have tried to find the duplicate indexes but i am unable to identify that indexes,
 fk_i_city_id
 fk_i_city_id_2
 fk_i_city_id_3
 fk_i_city_id_4


How to drop this
fk_i_city_id_2
fk_i_city_id_3
fk_i_city_id_4

this is very strange issue i hope i well get some suggestions here

[Aficionado]

I think you should solve some major problems you seem to have (as i see from other topics you posted).

Something is very wrong in your site/setup/hosting ....

[abdul ghany syed]

Yes something wrong in site, recently i have moved my site to another host. For present i am not facing speed related issues. But site consuming more resources , i thinks its causing because of duplicate indexes. Its possible to delete that duplicate indexes?
http://prntscr.com/gstlon

[Aficionado]

If i remember correctly those are from Osclass updates (a bug). Not 100% sure about it.

Also i think they do not hurt in anything.

[abdul ghany syed]

If you dont mind could you suggest anything for this repeated issue, i have 1K+ ads and 1K users ,
1. starting site from zero ?
2. consulting a good osclass developer to resolve all issues, ( i think its difficult to resolve this type of unknown issues, but i have very limited knowledge about this.)

could you suggest which option one or two or is there any other suggestion?

[marius-ciclistu]

You could make a subdomain and install a fresh osclass there to see what happens. If the indexes are still there, you can remove them and see what happens.

Another idea is to search your osclass files for "fk_i_city_id_2" and see if it's used somewere.

In 3.7.1 there are no "fk_i_city_id_" words.

EDIT. Search your plugins' files as well for this word "fk_i_city_id_".

[abdul ghany syed]

I tried fresh installation but not get any duplicate indexes.
I searched for osclass core files for finding fk_i_city_id_2 i have not found anything related _2 _3 _4

How to remove that indexes? I have not seen any drop option for that indexes.

[Aficionado]

I tried fresh installation but not get any duplicate indexes.
I searched for osclass core files for finding fk_i_city_id_2 i have not found anything related _2 _3 _4

How to remove that indexes? I have not seen any drop option for that indexes.

Told you. I think the dups are from OSclass updates. Not in a fresh installation.

[Aficionado]

https://forums.osclass.org/3-5-x/database-issue-30878/

[abdul ghany syed]

@Aficionafo sir

If you dont mind could you suggest anything for this repeated issue, i have 1K+ ads and 1K users ,
1. starting site from zero ?
2. consulting a good osclass developer to resolve all issues, ( i think its difficult to resolve this type of unknown issues, but i have very limited knowledge about this.)

could you suggest which option one or two or is there any other suggestion?

Could you suggest any idea. Something is making my site consuming high cpu resources as well as alert option, when posting an ad and when user registration. Consuming more resources and taking 10+ sec to load a site.  But normally myn site is below 2sec to load

[Aficionado]

Could you suggest any idea?

For the dup index problem read my link above. A whole topic about it and how to drop the dups.

Not sure your problem come from that, still ....

As for what to do with your problems, if they are mysterious and not knowns, i guess you could ask help from a pro, that has also access to your server. Your hosting company perhaps.

[abdul ghany syed]

@Aficionado sir

issue resolved of indexes, you helped me a lot here..Thank you very much.
but http://prntscr.com/gt13wf and http://prntscr.com/gt141z
PRIMARY index is default by osclass? by removing that in same process like

Code: [Select]

DROP INDEX PRIMARY ON oc_t_category; will create new issues?

I seen PRIMARY index is default one and not an a issues, but in fresh installation http://prntscr.com/gt1ca7 and in old installation http://prntscr.com/gt1cs4