solucionar - xampp mysql not found

error mysql: Tabla "mysql". "innodb_table_stats" no encontrado

Question

Recibo el siguiente error en la edición de la comunidad mysql 5.6:

: Error: Table "mysql"."innodb_table_stats" not found. InnoDB: Recalculation of persistent statistics requested for table "mydatabase"."mytable" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.

¿Cómo soluciono este error?

Answer 1

Esto resultó ser un problema de permiso para mí. Como esto estaba en una máquina de desarrollo donde los permisos no están bloqueados, pude solucionarlo con bastante facilidad:

sudo chmod -R 775 /usr/local/mysql/data

... si eso te lo resuelve, entonces genial. Pero si el problema está en una máquina de producción, es posible que desee investigar los permisos un poco más a fondo que mi solución.

tal vez le gustaría probar esto en su lugar:

sudo chown mysql.mysql -R /usr/local/mysql/data

Answer 2

Lea este documento de MySQL para obtener más información sobre Persistent Statistics .

Para desactivar esta función, agregue innodb_stats_persistent = 0 a my.cfg y reinicie su servidor mysql.

Answer 3

Me encontré con este problema en un servidor de producción recientemente y las respuestas más comunes que encontré implican dejar caer tablas, borrar archivos, etc. me hicieron sentir un poco incómodo.

Así que pensé que podría ser útil señalar a las personas que lean esto en el futuro que en mi caso la causa real del error fue que mi partición raíz se llenó. He estado haciendo un volcado de MySQL en ese momento y lo guardé en el lugar equivocado. Entonces, la solución fue simplemente liberar espacio en el disco y reiniciar el servicio.

Puede ser una idea comprobar que este no es el caso para usted antes de pasar a las soluciones estándar que implican jugar con la estructura de MYSQL y tienen el potencial de ser un poco más arriesgado.

Buena suerte,

Answer 4

Mira este enlace:

http://bugs.mysql.com/file.php?id=19725

Esto resolvió mi problema. Como es una descarga directa, aquí está el código.

/ * solución temporal para el problema con el instalador de Windows para MySQL 5.6.10 en máquinas con Windows 7. Hice el procedimiento en un MySql limpio instalado, y funcionó para mí, al menos detuvo líneas de errores innodb en el registro y el uso de tablas innodb transitorias. Por lo tanto, hágalo bajo su propio riesgo ..

1. descartar estas tablas de mysql: innodb_index_stats innodb_table_stats slave_master_info slave_relay_log_info slave_worker_info

2. borre todos los .frm y .ibd de las tablas de arriba.

3. ejecute este archivo para volver a crear las tablas anteriores (fuente five-tables.sql).

4. reiniciar mysqld. Cheers, CNL * /

CREATE TABLE `innodb_index_stats` (
  `database_name` varchar(64) COLLATE utf8_bin NOT NULL,
  `table_name` varchar(64) COLLATE utf8_bin NOT NULL,
  `index_name` varchar(64) COLLATE utf8_bin NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `stat_name` varchar(64) COLLATE utf8_bin NOT NULL,
  `stat_value` bigint(20) unsigned NOT NULL,
  `sample_size` bigint(20) unsigned DEFAULT NULL,
  `stat_description` varchar(1024) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`database_name`,`table_name`,`index_name`,`stat_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;

CREATE TABLE `innodb_table_stats` (
  `database_name` varchar(64) COLLATE utf8_bin NOT NULL,
  `table_name` varchar(64) COLLATE utf8_bin NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `n_rows` bigint(20) unsigned NOT NULL,
  `clustered_index_size` bigint(20) unsigned NOT NULL,
  `sum_of_other_index_sizes` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`database_name`,`table_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;

CREATE TABLE `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'';

CREATE TABLE `slave_relay_log_info` (
  `Number_of_lines` int(10) unsigned NOT NULL COMMENT ''Number of lines in the file or rows in the table. Used to version table definitions.'',
  `Relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT ''The name of the current relay log file.'',
  `Relay_log_pos` bigint(20) unsigned NOT NULL COMMENT ''The relay log position of the last executed event.'',
  `Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT ''The name of the master binary log file from which the events in the relay log file were read.'',
  `Master_log_pos` bigint(20) unsigned NOT NULL COMMENT ''The master log position of the last executed event.'',
  `Sql_delay` int(11) NOT NULL COMMENT ''The number of seconds that the slave must lag behind the master.'',
  `Number_of_workers` int(10) unsigned NOT NULL,
  `Id` int(10) unsigned NOT NULL COMMENT ''Internal Id that uniquely identifies this record.'',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT=''Relay Log Information'';

CREATE TABLE `slave_worker_info` (
  `Id` int(10) unsigned NOT NULL,
  `Relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `Relay_log_pos` bigint(20) unsigned NOT NULL,
  `Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `Master_log_pos` bigint(20) unsigned NOT NULL,
  `Checkpoint_relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `Checkpoint_relay_log_pos` bigint(20) unsigned NOT NULL,
  `Checkpoint_master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `Checkpoint_master_log_pos` bigint(20) unsigned NOT NULL,
  `Checkpoint_seqno` int(10) unsigned NOT NULL,
  `Checkpoint_group_size` int(10) unsigned NOT NULL,
  `Checkpoint_group_bitmap` blob NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT=''Worker Information'';

Answer 5

mismo problema pero la tabla de bloqueo '' gtid_slave_pos '', Create gtid_slave_pos

CREATE TABLE `gtid_slave_pos` (
  `domain_id` int(10) unsigned NOT NULL,
  `sub_id` bigint(20) unsigned NOT NULL,
  `server_id` int(10) unsigned NOT NULL,
  `seq_no` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`domain_id`,`sub_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT=''Replication slave GTID state'';