Welcome to Geeklog, Anonymous Friday, March 29 2024 @ 04:30 am EDT

Geeklog Forums

Database indexes


Blaine in Maine

Anonymous
Is there a list anywhere that shows what indexes are set up for the various gl_forum tables?

I am specifically interested in the gl-forum_settings table and the gl_forum_log table?

Thanks in advance.

~L
 Quote

Status: offline

Fanny Mae

Forum User
Junior
Registered: 06/03/04
Posts: 22
Nobody have an answer to database indexes? I'm interested Confused

 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
The easiest way to find that information would be to look at the database in phpMyAdmin. Or use the forum's SQL install file in plugins/forum/sql

bye, Dirk
 Quote

Status: offline

Fanny Mae

Forum User
Junior
Registered: 06/03/04
Posts: 22
Thanks Dirk,

While looking at the database I saw that one did not have an index and another had a duplicate index. I figured there should be a list of indexes available, so that I could correct, and or replace any missing indexes.

I'll try plugins/forum/sql
 Quote

Status: offline

Fanny Mae

Forum User
Junior
Registered: 06/03/04
Posts: 22
Looks like we were missing the second index on forum_id.

Not sure if that is what was causing the posts in a thread to show out of order, but hope so. All other indexes were OK.

Thanks Dirk


PRIMARY KEY (forum_id),
KEY forum_cat (forum_cat),
KEY forum_id (forum_id) <-----------MISSING

 Quote

All times are EDT. The time is now 04:30 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content