Advertisement:

Author Topic: Database Issue  (Read 3705 times)

Aficionado

  • Guest
Re: Database Issue
« Reply #15 on: October 13, 2015, 06:38:50 pm »
Kudos to @dinkar who discovered this !!!


teseo

  • Hero Member
  • *****
  • Posts: 6169
Re: Database Issue
« Reply #16 on: October 13, 2015, 06:49:28 pm »
1. Only oc_t_item is suffering from this (apparently not) ?

No, all the tables you see there as MySQL comments (starting with #)

Quote
2. ALL indexes in there ? I see

fk_c_currency_code

fk_i_category_id

fk_i_user_id

Each and everyone, you need to fill up up to xxxxxxxx_11 for each block. On the bright side, having right now 10 duplicates of everything, once cleaned up your database performance should be substantially improved.

Regards

Aficionado

  • Guest
Re: Database Issue
« Reply #17 on: October 13, 2015, 06:53:38 pm »
I see:

oc_t_category

oc_t_city

oc_t_city_area

oc_t_item

oc_t_item_comment

oc_t_item_stats

oc_t_keywords

oc_t_plugin_category

and

oc_t_region


Aficionado

  • Guest
Re: Database Issue
« Reply #18 on: October 13, 2015, 06:54:29 pm »
If anyone tries this REMEMBER to BACKUP first.


dev101

  • Osclass Hero
  • Hero Member
  • *
  • Posts: 2155
  • osclass.work
Re: Database Issue
« Reply #19 on: October 13, 2015, 08:27:03 pm »
Index is not stored inside database, conventional backup does not work here (you are not removing anything from db).

Aficionado

  • Guest
Re: Database Issue
« Reply #20 on: October 13, 2015, 08:48:02 pm »
Index is not stored inside database, conventional backup does not work here (you are not removing anything from db).

ok, i didn't knew that.

I test the script and seems to have worked. But now i'm opening the Indexes, i don't see any. Am i missing something ? Is this how it must be ?

See:


dev101

  • Osclass Hero
  • Hero Member
  • *
  • Posts: 2155
  • osclass.work
Re: Database Issue
« Reply #21 on: October 13, 2015, 09:01:56 pm »
Index is not stored inside database, conventional backup does not work here (you are not removing anything from db).
I just wish to correct myself here, references to duplicate keys are stored inside it, of course, otherwise it wouldn't make sense. But, the index data itself is outside database. Creating a backup will keep the database with the old problem unsolved, but you could not find anything suspicious just by comparing ~ near the same db file size.

I test the script and seems to have worked. But now i'm opening the Indexes, i don't see any. Am i missing something ? Is this how it must be ?

I think that it looks fine to me, you have removed duplicates. You can run manual check with the SHOW INDEX query and you should get the exact same result listed in your screenshot (few posts above teseo gave an example).

dinkar

  • Newbie
  • *
  • Posts: 13
Re: Database Issue
« Reply #22 on: October 13, 2015, 09:20:24 pm »
Thanks for responding too fast

I have upgraded several times since 3.1

Is there any way to fix them

Aficionado

  • Guest
Re: Database Issue
« Reply #23 on: October 13, 2015, 09:24:28 pm »
Thanks for responding too fast

I have upgraded several times since 3.1

Is there any way to fix them

The fix is here:

http://forums.osclass.org/3-5-x/database-issue-30878/msg131093/#msg131093

just see how many you have and add them (carefully with the correct numbers). Then goto your mysqladmin and run the SQL script.

Backup first !

dinkar

  • Newbie
  • *
  • Posts: 13
Re: Database Issue
« Reply #24 on: October 13, 2015, 09:32:11 pm »
I am successful in dropping the index but which one has to be kept like when i select the index
fk_i_parent_id then it automatically shifts to fk_i_parent_id_9

Aficionado

  • Guest
Re: Database Issue
« Reply #25 on: October 13, 2015, 09:35:57 pm »
I am successful in dropping the index but which one has to be kept like when i select the index
fk_i_parent_id then it automatically shifts to fk_i_parent_id_9

The FIRST without a number is to be kept. This is what i did.

dinkar

  • Newbie
  • *
  • Posts: 13
Re: Database Issue
« Reply #26 on: October 13, 2015, 09:44:21 pm »
Yes, Its done and everything is working fine

Thanks to you All

abdul ghany syed

  • Jr. Member
  • **
  • Posts: 55
  • I love awesome Classifieds
Re: Database Issue
« Reply #27 on: October 03, 2017, 11:15:59 pm »
Creating a small video is useful for us who are not a develpers, instead of solving issue we create more problems here.

Aficionado

  • Guest
Re: Database Issue
« Reply #28 on: October 03, 2017, 11:20:02 pm »
Creating a small video is useful for us who are not a develpers, instead of solving issue we create more problems here.

I think you ask too much.