MySQL Database Analysis (0.2b)

Logout > Database CheckMyPages > Restricted to chk_ >

There are 13 tables and 24 stored procedures matching chk_
Contains approximately 11k records
With an overall score of 64%
Report took 1 seconds to run

Table chk_file_type_action has 111 rows

  • The unique index file_type contains the nullable columns file_type
  • This table is not referenced by your stored procedures
  • This table has no primary key

Table chk_ftp_files has 0 rows

  • This table has no indexes
  • This table has a plural name while most table names are singular

Table chk_log has 2450 rows

  • Table has 675 sets of duplicate rows
  • This table has no unique index
  • This table has no primary key
  • The index user_id contains the nullable columns upd_time and user_id

Table chk_next_site has 0 rows

  • The unique index pid contains the nullable columns pid

Table chk_output has 1550 rows

  • Table has 1388 sets of duplicate rows
  • This table has no unique index
  • This table has no primary key
  • The index user_id contains the nullable columns seq_str and user_id

Table chk_param has 5 rows

  • The unique index user_id contains the nullable columns url_id ,   name and user_id
  • This table has no primary key

Table chk_rpt_values has 7 rows

  • The unique index name contains the nullable columns name
  • This table is not referenced by your stored procedures
  • This table has no primary key
  • This table has a plural name while most table names are singular

Table chk_site has 0 rows

Table chk_tmp_depth has 1015 rows

  • This table has no indexes
  • Is this table required?
  • This table has no primary key

Table chk_type has 71 rows

  • Table has 2 sets of duplicate rows
  • This table has no unique index
  • This table has no primary key
  • The index field_name contains the nullable columns field_name and type_value

Table chk_url_hierarchy has 1 rows

  • This table has no unique index
  • This table has no primary key
  • Different compound index order to table chk_param
  • The index user_id contains the nullable columns url_id and user_id

Table chk_user has 6569 rows

  • Table has 4 sets of duplicate rows
  • This table has no unique index
  • This table has no primary key
  • The index user_id contains the nullable columns user_id

Table chk_warning has 0 rows

  • This table has no unique index
  • Different compound index order to table chk_param
  • The index user_id contains the nullable columns url_id and user_id


by Mike Robinson