{"id":1021,"date":"2019-03-05T06:35:01","date_gmt":"2019-03-04T21:35:01","guid":{"rendered":"https:\/\/manadream.net\/kat_blog\/?p=1021"},"modified":"2019-10-09T15:40:28","modified_gmt":"2019-10-09T06:40:28","slug":"mysql-doesnt-exist-error","status":"publish","type":"post","link":"https:\/\/katblog.manadream.net\/index.php\/2019\/03\/05\/mysql-doesnt-exist-error\/","title":{"rendered":"\u3010MySQL\u3011\u300cTable &#8216;performance_schema.session_variables&#8217; doesn&#8217;t exist\u300d\u30a8\u30e9\u30fc\u306e\u89e3\u6c7a\u65b9\u6cd5\u3010\u7c21\u5358\u3011"},"content":{"rendered":"<p>\u3069\u3046\u3082\u3001kat\u3067\u3059\u3002<\/p>\n<p>\u4eca\u56de\u306f\u3001MySQL\u3067\u767a\u751f\u3057\u305f\u30a8\u30e9\u30fc\u306e\u89e3\u6c7a\u65b9\u6cd5\u306b\u3064\u3044\u3066\u66f8\u3044\u3066\u3044\u3053\u3046\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<p>\u3068\u304f\u306b\u3001<strong>\u30d0\u30fc\u30b8\u30e7\u30f3\u30a2\u30c3\u30d7\u3057\u305f\u969b\u306a\u3069\u306b\u767a\u751f\u3057\u3084\u3059\u3044\u30a8\u30e9\u30fc<\/strong>\u3068\u306a\u308a\u307e\u3059\u306e\u3067\u3001\u304a\u56f0\u308a\u306e\u65b9\u306f\u662f\u975e\u3084\u3063\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u305d\u308c\u3067\u306f\u3001\u65e9\u901f\u8aac\u660e\u3057\u3066\u3044\u3053\u3046\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n<h2 class=\"wp-block-heading\">\u4e8b\u8c61<\/h2>\n\n\n\n<p>MySQL\u306b\u3066\u3001<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nshow variables like &quot;chara%&quot;;\n<\/pre><\/div>\n\n\n<p>\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001\u4e0b\u8a18\u306e\u30a8\u30e9\u30fc\u304c\u8868\u793a\u3055\u308c\u308b\u3002<\/p>\n\n\n<div class=\"custom_error1\">Table &#8216;performance_schema.session_variables&#8217; doesn&#8217;t exist<\/div>\n\n\n<h2 class=\"wp-block-heading\">\u89e3\u6c7a\u65b9\u6cd5<\/h2>\n\n\n\n<p>MySQL\u3092\u8d77\u52d5\u3057\u305f\u72b6\u614b\u3067\u3001\u30b3\u30f3\u30bd\u30fc\u30eb\uff08XAMPP\u306e\u5834\u5408\u306f\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u30d1\u30cd\u30eb\u306eShell\uff09\u304b\u3089\u3001\u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nmysql_upgrade -u root -p -P 3306\n<\/pre><\/div>\n\n\n<p>\u4e0a\u8a18\u304c\u4e0a\u624b\u304f\u3044\u3051\u3070\u3001\u89e3\u6c7a\u3059\u308b\u306f\u305a\u3067\u3059\u304c\u3001<\/p>\n\n\n<div class=\"custom_error1\">Table &#8216;mysql.innodb_table_stats&#8217; doesn&#8217;t exist<\/div>\n\n\n<p>\u3068\u3044\u3063\u305f\u30a8\u30e9\u30fc\u304c\u51fa\u308b\u5834\u5408\u306f\u3001\u4e0b\u8a18\u3082\u5b9f\u65bd\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">mysql_upgrade\u3067\u30a8\u30e9\u30fc\u304c\u51fa\u308b\u5834\u5408<\/h3>\n\n\n\n<p>\u4e0b\u8a18SQL\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\ndrop table innodb_index_stats;\ndrop table innodb_table_stats;\ndrop table slave_master_info;\ndrop table slave_relay_log_info;\ndrop table slave_worker_info;\n<\/pre><\/div>\n\n\n<p>MySQL\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u5185\uff08XAMPP\u306e\u5834\u5408\u306fC:\\xampp\\mysql\\data\\mysql\uff09\u306e\u3001\u4e0b\u8a18\u30d5\u30a1\u30a4\u30eb\u3092\u524a\u9664\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"simple-box4\">\n<p>innodb_index_stats*<br \/>innodb_table_stats*<br \/>slave_master_info*<br \/>slave_relay_log_info*<br \/>slave_worker_info*<\/p>\n<\/div>\n\n\n<p>\u4e0b\u8a18\u306eSQL\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TABLE `innodb_index_stats` (\n`database_name` varchar(64) COLLATE utf8_bin NOT NULL,\n`table_name` varchar(64) COLLATE utf8_bin NOT NULL,\n`index_name` varchar(64) COLLATE utf8_bin NOT NULL,\n`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n`stat_name` varchar(64) COLLATE utf8_bin NOT NULL,\n`stat_value` bigint(20) unsigned NOT NULL,\n`sample_size` bigint(20) unsigned DEFAULT NULL,\n`stat_description` varchar(1024) COLLATE utf8_bin NOT NULL,\nPRIMARY KEY (`database_name`,`table_name`,`index_name`,`stat_name`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;\n\nCREATE TABLE `innodb_table_stats` (\n`database_name` varchar(64) COLLATE utf8_bin NOT NULL,\n`table_name` varchar(64) COLLATE utf8_bin NOT NULL,\n`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n`n_rows` bigint(20) unsigned NOT NULL,\n`clustered_index_size` bigint(20) unsigned NOT NULL,\n`sum_of_other_index_sizes` bigint(20) unsigned NOT NULL,\nPRIMARY KEY (`database_name`,`table_name`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;\n\nCREATE TABLE `slave_master_info` (\n`Number_of_lines` int(10) unsigned NOT NULL COMMENT 'Number of lines in the file.',\n`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.',\n`Master_log_pos` bigint(20) unsigned NOT NULL COMMENT 'The master log position of the last read event.',\n`Host` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'The host name of the master.',\n`User_name` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The user name used to connect to the master.',\n`User_password` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The password used to connect to the master.',\n`Port` int(10) unsigned NOT NULL COMMENT 'The network port used to connect to the master.',\n`Connect_retry` int(10) unsigned NOT NULL COMMENT 'The period (in seconds) that the slave will wait before trying to reconnect to the master.',\n`Enabled_ssl` tinyint(1) NOT NULL COMMENT 'Indicates whether the server supports SSL connections.',\n`Ssl_ca` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The file used for the Certificate Authority (CA) certificate.',\n`Ssl_capath` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The path to the Certificate Authority (CA) certificates.',\n`Ssl_cert` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the SSL certificate file.',\n`Ssl_cipher` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the cipher in use for the SSL connection.',\n`Ssl_key` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the SSL key file.',\n`Ssl_verify_server_cert` tinyint(1) NOT NULL COMMENT 'Whether to verify the server certificate.',\n`Heartbeat` float NOT NULL,\n`Bind` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'Displays which interface is employed when connecting to the MySQL server',\n`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',\n`Uuid` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The master server uuid.',\n`Retry_count` bigint(20) unsigned NOT NULL COMMENT 'Number of reconnect attempts, to the master, before giving up.',\n`Ssl_crl` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The file used for the Certificate Revocation List (CRL)',\n`Ssl_crlpath` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The path used for Certificate Revocation List (CRL) files',\n`Enabled_auto_position` tinyint(1) NOT NULL COMMENT 'Indicates whether GTIDs will be used to retrieve events from the master.',\nPRIMARY KEY (`Host`,`Port`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Master Information';\n\nCREATE TABLE `slave_relay_log_info` (\n`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.',\n`Relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the current relay log file.',\n`Relay_log_pos` bigint(20) unsigned NOT NULL COMMENT 'The relay log position of the last executed event.',\n`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.',\n`Master_log_pos` bigint(20) unsigned NOT NULL COMMENT 'The master log position of the last executed event.',\n`Sql_delay` int(11) NOT NULL COMMENT 'The number of seconds that the slave must lag behind the master.',\n`Number_of_workers` int(10) unsigned NOT NULL,\n`Id` int(10) unsigned NOT NULL COMMENT 'Internal Id that uniquely identifies this record.',\nPRIMARY KEY (`Id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Relay Log Information';\n\nCREATE TABLE `slave_worker_info` (\n`Id` int(10) unsigned NOT NULL,\n`Relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,\n`Relay_log_pos` bigint(20) unsigned NOT NULL,\n`Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,\n`Master_log_pos` bigint(20) unsigned NOT NULL,\n`Checkpoint_relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,\n`Checkpoint_relay_log_pos` bigint(20) unsigned NOT NULL,\n`Checkpoint_master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,\n`Checkpoint_master_log_pos` bigint(20) unsigned NOT NULL,\n`Checkpoint_seqno` int(10) unsigned NOT NULL,\n`Checkpoint_group_size` int(10) unsigned NOT NULL,\n`Checkpoint_group_bitmap` blob NOT NULL,\nPRIMARY KEY (`Id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Worker Information';\n<\/pre><\/div>\n\n\n<p>\u518d\u5ea6\u3001\u4e0b\u8a18\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nmysql_upgrade -u root -p -P 3306\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">\u78ba\u8a8d<\/h2>\n\n\n\n<p>\u518d\u5ea6\u3001\u4e0b\u8a18\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3001\u30a8\u30e9\u30fc\u304c\u51fa\u306a\u3051\u308c\u3070\u6210\u529f\u3067\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nshow variables like &quot;chara%&quot;;\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">\u6700\u5f8c\u306b<\/h2>\n\n\n<p>\u3044\u304b\u304c\u3060\u3063\u305f\u3067\u3057\u3087\u3046\u304b\uff1f<\/p>\n<p>\u4e0a\u8a18\u306e\u30a8\u30e9\u30fc\u306f\u3001MySQL\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u30a2\u30c3\u30d7\u3092\u3057\u305f\u969b\u306a\u3069\u306b\u3088\u304f\u767a\u751f\u3057\u307e\u3059\u3002<\/p>\n<p>\u624b\u9806\u3055\u3048\u9593\u9055\u3048\u306a\u3051\u308c\u3070\u3001\u6570\u5206\u3067\u7d42\u308f\u308b\u304b\u3068\u601d\u3044\u307e\u3059\u306e\u3067\u3001\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u305f\u969b\u306f\u3001\u662f\u975e\u8a66\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u4ee5\u4e0a\u3001\u300c&#8221;Table &#8216;performance_schema.session_variables&#8217; doesn&#8217;t exist&#8221; \u30a8\u30e9\u30fc\u306e\u89e3\u6c7a\u65b9\u6cd5\u300d\u3067\u3057\u305f\uff5e\u3002<\/p>","protected":false},"excerpt":{"rendered":"<p>\u3069\u3046\u3082\u3001kat\u3067\u3059\u3002 \u4eca\u56de\u306f\u3001MySQL\u3067\u767a\u751f\u3057\u305f\u30a8\u30e9\u30fc\u306e\u89e3\u6c7a\u65b9\u6cd5\u306b\u3064\u3044\u3066\u66f8\u3044\u3066\u3044\u3053\u3046\u3068\u601d\u3044\u307e\u3059\u3002 \u3068\u304f\u306b\u3001\u30d0\u30fc\u30b8\u30e7\u30f3\u30a2\u30c3\u30d7\u3057\u305f\u969b\u306a\u3069\u306b\u767a\u751f\u3057\u3084\u3059\u3044\u30a8\u30e9\u30fc\u3068\u306a\u308a\u307e\u3059\u306e\u3067\u3001\u304a\u56f0\u308a\u306e\u65b9\u306f\u662f\u975e\u3084\u3063\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002 \u305d\u308c\u3067\u306f\u3001\u65e9<\/p>\n","protected":false},"author":1,"featured_media":1052,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_locale":"","_original_post":"","_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[18,19],"tags":[58,32,57,44],"class_list":["post-1021","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-db","category-mysql","tag-db","tag-it","tag-mysql","tag-44","ja"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/katblog.manadream.net\/wp-content\/uploads\/2019\/03\/mysql.jpg","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paUgnN-gt","_links":{"self":[{"href":"https:\/\/katblog.manadream.net\/index.php\/wp-json\/wp\/v2\/posts\/1021"}],"collection":[{"href":"https:\/\/katblog.manadream.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/katblog.manadream.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/katblog.manadream.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/katblog.manadream.net\/index.php\/wp-json\/wp\/v2\/comments?post=1021"}],"version-history":[{"count":32,"href":"https:\/\/katblog.manadream.net\/index.php\/wp-json\/wp\/v2\/posts\/1021\/revisions"}],"predecessor-version":[{"id":2586,"href":"https:\/\/katblog.manadream.net\/index.php\/wp-json\/wp\/v2\/posts\/1021\/revisions\/2586"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/katblog.manadream.net\/index.php\/wp-json\/wp\/v2\/media\/1052"}],"wp:attachment":[{"href":"https:\/\/katblog.manadream.net\/index.php\/wp-json\/wp\/v2\/media?parent=1021"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/katblog.manadream.net\/index.php\/wp-json\/wp\/v2\/categories?post=1021"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/katblog.manadream.net\/index.php\/wp-json\/wp\/v2\/tags?post=1021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}