MySQL Database Analysis (0.2b)

Logout > Database CheckMyPages > Restricted to chk_ >
Problem with SQL: select count(*), sum(table_rows) from chkdb_tabsTable 'CheckMyPages.chkdb_tabs' doesn't exist

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

Problem with SQL: select table_rows from chkdb_tabs where table_name='chk_file_type_action' Table 'CheckMyPages.chkdb_tabs' doesn't exist

Table chk_file_type_action has 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

Problem with SQL: select table_rows from chkdb_tabs where table_name='chk_ftp_files' Table 'CheckMyPages.chkdb_tabs' doesn't exist

Table chk_ftp_files has rows

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

Problem with SQL: select table_rows from chkdb_tabs where table_name='chk_log' Table 'CheckMyPages.chkdb_tabs' doesn't exist

Table chk_log has 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

Problem with SQL: select table_rows from chkdb_tabs where table_name='chk_next_site' Table 'CheckMyPages.chkdb_tabs' doesn't exist

Table chk_next_site has rows

  • The unique index pid contains the nullable columns pid
  • This table has no primary key

Problem with SQL: select table_rows from chkdb_tabs where table_name='chk_output' Table 'CheckMyPages.chkdb_tabs' doesn't exist

Table chk_output has rows

  • Table has 1553 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

Problem with SQL: select table_rows from chkdb_tabs where table_name='chk_param' Table 'CheckMyPages.chkdb_tabs' doesn't exist

Table chk_param has rows

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

Problem with SQL: select table_rows from chkdb_tabs where table_name='chk_rpt_values' Table 'CheckMyPages.chkdb_tabs' doesn't exist

Table chk_rpt_values has 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

Problem with SQL: select table_rows from chkdb_tabs where table_name='chk_site' Table 'CheckMyPages.chkdb_tabs' doesn't exist

Table chk_site has rows

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

Problem with SQL: select table_rows from chkdb_tabs where table_name='chk_tmp_depth' Table 'CheckMyPages.chkdb_tabs' doesn't exist

Table chk_tmp_depth has rows

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

Problem with SQL: select table_rows from chkdb_tabs where table_name='chk_type' Table 'CheckMyPages.chkdb_tabs' doesn't exist

Table chk_type has 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 type_value and field_name

Problem with SQL: select table_rows from chkdb_tabs where table_name='chk_url_hierarchy' Table 'CheckMyPages.chkdb_tabs' doesn't exist

Table chk_url_hierarchy has 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

Problem with SQL: select table_rows from chkdb_tabs where table_name='chk_user' Table 'CheckMyPages.chkdb_tabs' doesn't exist

Table chk_user has rows

  • This table has no indexes

Problem with SQL: select table_rows from chkdb_tabs where table_name='chk_warning' Table 'CheckMyPages.chkdb_tabs' doesn't exist

Table chk_warning has rows

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


by Mike Robinson