0

I've been having allot of issues with my mysql databases on Windows dying on me. About once a week or so it will refuse to work and I'll spend all night poking at it & a few computer restarts later things will magically start working it seems.

I've done some searching but didn't turn up much.

What would cause these errors whenever I try to access a table?

2014-01-06 20:10:14 c7c InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2014-01-06 20:10:14 c7c InnoDB: Error: Fetch of persistent statistics requested for table "memory28_web"."core_settings" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
1

I have just addressed this a month ago: InnoDB: Error: Table "mysql"."innodb_table_stats" not found after upgrade to mysql 5.6

This usually happens when one upgrades mysql from 5.5 to 5.6. The cuurrent tools for MySQL upgrading does not account for the only 5 system tables that are InnoDB.

Such errors are really innocuous and would not impede InnoDB, provided you do not activate features that need them.

This answer does not address your real issues. It just explain away the error message you posted.

You can create the tables in phpmyadmin. Just run this:

CREATE TABLE `mysql`.`slave_master_info` (
  `Number_of_lines` int(10) unsigned NOT NULL COMMENT 'Number of lines in the file.',
  `Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the master binary log currently being read from the master.',
  `Master_log_pos` bigint(20) unsigned NOT NULL COMMENT 'The master log position of the last read event.',
  `Host` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'The host name of the master.',
  `User_name` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The user name used to connect to the master.',
  `User_password` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The password used to connect to the master.',
  `Port` int(10) unsigned NOT NULL COMMENT 'The network port used to connect to the master.',
  `Connect_retry` int(10) unsigned NOT NULL COMMENT 'The period (in seconds) that the slave will wait before trying to reconnect to the master.',
  `Enabled_ssl` tinyint(1) NOT NULL COMMENT 'Indicates whether the server supports SSL connections.',
  `Ssl_ca` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The file used for the Certificate Authority (CA) certificate.',
  `Ssl_capath` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The path to the Certificate Authority (CA) certificates.',
  `Ssl_cert` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the SSL certificate file.',
  `Ssl_cipher` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the cipher in use for the SSL connection.',
  `Ssl_key` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the SSL key file.',
  `Ssl_verify_server_cert` tinyint(1) NOT NULL COMMENT 'Whether to verify the server certificate.',
  `Heartbeat` float NOT NULL,
  `Bind` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'Displays which interface is employed when connecting to the MySQL server',
  `Ignored_server_ids` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The number of server IDs to be ignored, followed by the actual server IDs',
  `Uuid` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The master server uuid.',
  `Retry_count` bigint(20) unsigned NOT NULL COMMENT 'Number of reconnect attempts, to the master, before giving up.',
  `Ssl_crl` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The file used for the Certificate Revocation List (CRL)',
  `Ssl_crlpath` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The path used for Certificate Revocation List (CRL) files',
  `Enabled_auto_position` tinyint(1) NOT NULL COMMENT 'Indicates whether GTIDs will be used to retrieve events from the master.',
  PRIMARY KEY (`Host`,`Port`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Master Information';

UPDATE 2014-01-17 11:00 EST

You last commented

It's weird, the database says those tables exist when trying to create them. But the errors say they don't... MySql is behaving ok at the moment. I'm going to keep this question open for a bit I think. Look for more clues next time it dies on me

The reason MySQL says the tables exist in simple. First, here is an XRay of InnoDB

InnoDB Architecture

If you look at ibdata1 in the picture, you see the data dictionary. The data dictionary is insisting that the tables exist. Your solution to clean this up is

With a clean data dictionary, you can now create the missing InnoDB system tables.

Give it a Try !!!

  • I saw that answer but didn't quite follow. Do I need to created a "mysql" database? Or would these tables be created for example under my "memory_28" database – Andrew Walters Jan 7 '14 at 2:45
  • There is a database called mysql which contains th grant tables, stored procedures and other physical files needed for system startup. – RolandoMySQLDBA Jan 7 '14 at 2:46
  • I'm kind of a newbie to mysql land. Would I be able to access this database through phpmyadmin generally? If not how would you recommend running queries against the Db? – Andrew Walters Jan 7 '14 at 2:49
  • @RolandoMySQLDBA It seems likely that there are other issues if the server wasn't upgraded properly. Would it make sense to (re-)run the mysql_upgrade script? – James L Jan 7 '14 at 6:47
  • @RolandoMySQLDBA Thanks for your help, I'm going to try and create the tables this evening! – Andrew Walters Jan 7 '14 at 15:13
0

You can try stopping the mysql service, and then physically moving your ib_logfile# files to a backup location or other location, and then restarting the mysql service. Doing so will cause the mysql service to rebuild the ib_logfile files and will often resolve the issue that you're encountering. Please do post whether this resolves your issue.

You can create those tables by importing this sql file on MySQL server http://bugs.mysql.com/file.php?id=19725

You can refer this MySQL forum post: http://forums.mysql.com/read.php?22,578559,579891#msg-579891

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.