#997 4.0rel ... MySQL indexes ...

v3.3.8
closed
None
5
2009-01-10
2006-06-17
Mark Hattam
No

Maybe cosmetic, but looking at the MySQL tables for a brand new pgv4.0
release using phpMyAdmin, I see two tables whose indexing causes
phpMyAdmin to flag up alerts.

pgv_media
More than one INDEX key was created for column `m_media`

pgv_users
PRIMARY and INDEX keys should not both be set for column
`u_username`

phpMyAdmin 2.8.1
MySQL 4.1.20
php 4.4.2
MacOSX 10.4.6

Mark

Discussion

  • KosherJava

    KosherJava - 2007-04-18

    Logged In: YES
    user_id=634811
    Originator: NO

    Was this ever fixed?

     
  • KosherJava

    KosherJava - 2007-04-18
    • assigned_to: nobody --> yalnifj
     
  • Mark Hattam

    Mark Hattam - 2007-04-19

    Logged In: YES
    user_id=623181
    Originator: YES

    Nope, no-one seems to have shown any interest.

    Today's SVN 1032 comes with phpMyAdmin comments (when do a Check Tables)

    pgv_dates
    ''More than one INDEX key was created for column 'd_fact' ''

    pgv_media
    ''More than one INDEX key was created for column 'm_media' ''

    pgv_users
    ''PRIMARY and INDEX keys should not both be set for column 'u_username' ''

    Mark

     
  • Greg Roach

    Greg Roach - 2008-11-17
    • milestone: --> v3.3.8
     
  • Greg Roach

    Greg Roach - 2009-01-10

    The difficulty with this problem is that the DB interfaces available to us (Pear::DB, PHP/PDO, etc.) do not support "introspection" of indexes.

    So, we can check for the existence of tables/columns and update them as necessary, but we cannot check the existence of indexes.

    Obviously, I could fix MySQL by checking the MySQL data dictionary, but I've no idea how to do this in SQL/Server or Postgres.

    We need a database independent way of checking indexes, and I don't think there is one.

    The duplicate indexes are mostly harmless. There will be a miniscule hit on the query analyser, but I suspect you'd have difficulty measuring it.

     
  • Mark Hattam

    Mark Hattam - 2009-01-10

    OK ... we'll just leave it to the geeks to fix existing db's assuming that the indexes we create are the right ones at the moment in time the user creates the tables.

    The initial comment does start with "Maybe cosmetic ..."

    Mark

     
  • Mark Hattam

    Mark Hattam - 2009-01-10
    • status: open --> closed
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks