| LinHES Forums http://forums.linhes.org/ |
|
| My backups have become HUGE! http://forums.linhes.org/viewtopic.php?f=17&t=24180 |
Page 1 of 2 |
| Author: | mattbatt [ Wed Jun 03, 2015 10:32 pm ] |
| Post subject: | My backups have become HUGE! |
So I got an error that my backup partition was 98% full. I also discovered using xymon that MySQL database is heading towards filling the drive as well. Here's the graph: https://www.dropbox.com/s/43yvr59z854ju ... h.png?dl=0 Here is the err file https://www.dropbox.com/s/d7vxog4fk9gup ... i.txt?dl=0 OK how do I fix this? |
|
| Author: | mattbatt [ Sat Jun 06, 2015 9:32 pm ] |
| Post subject: | Re: My database has become HUGE! |
Here are the warnings I found. Code: 140713 23:13:01 [Note] Event Scheduler: Purging the queue. 0 events 140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 183 user: 'mythtv' 140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 172 user: 'mythtv' 140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 141 user: 'mythtv' 140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 133 user: 'mythtv' 140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 88 user: 'mythtv' 140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 20 user: 'mythtv' 140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 17 user: 'mythtv' 140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 15 user: 'mythtv' 140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 14 user: 'mythtv' 140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 12 user: 'mythtv' 140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 6 user: 'mythtv' 140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 5 user: 'mythtv' 140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 4 user: 'mythtv' 140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 3 user: 'mythtv' 140713 23:13:03 [Warning] /usr/bin/mysqld: Forcing close of thread 2 user: 'mythtv' 140713 23:13:03 InnoDB: Starting shutdown... 140713 23:13:04 InnoDB: Shutdown completed; log sequence number 2982779 140713 23:13:04 [Note] /usr/bin/mysqld: Shutdown complete 140713 23:13:04 mysqld_safe mysqld from pid file /data/srv/mysql/gimli.pid ended 140713 23:13:51 mysqld_safe Starting mysqld daemon with databases from /data/srv/mysql 140713 23:13:55 InnoDB: The InnoDB memory heap is disabled 140713 23:13:55 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140713 23:13:55 InnoDB: Compressed tables use zlib 1.2.7 140713 23:13:56 InnoDB: Initializing buffer pool, size = 128.0M 140713 23:13:56 InnoDB: Completed initialization of buffer pool 140713 23:13:56 InnoDB: highest supported file format is Barracuda. 140713 23:13:59 InnoDB: Waiting for the background threads to start 140713 23:14:00 InnoDB: 1.1.8 started; log sequence number 2982779 140713 23:14:00 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 140713 23:14:00 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 140713 23:14:00 [Note] Server socket created on IP: '0.0.0.0'. 140713 23:14:02 [Note] Event Scheduler: Loaded 0 events 140713 23:14:02 [Note] /usr/bin/mysqld: ready for connections. Version: '5.5.28' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Source distribution 140713 23:19:27 [Note] /usr/bin/mysqld: Normal shutdown 140713 23:19:27 [Note] Event Scheduler: Purging the queue. 0 events 140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 37 user: 'mythtv' 140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 24 user: 'mythtv' 140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 21 user: 'mythtv' 140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 20 user: 'mythtv' 140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 19 user: 'mythtv' 140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 18 user: 'mythtv' 140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 16 user: 'mythtv' 140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 15 user: 'mythtv' 140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 14 user: 'mythtv' 140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 13 user: 'mythtv' 140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 12 user: 'mythtv' 140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 10 user: 'mythtv' 140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 9 user: 'mythtv' 140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 8 user: 'mythtv' 140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 7 user: 'mythtv' 140713 23:19:29 [Warning] /usr/bin/mysqld: Forcing close of thread 4 user: 'mythtv' 140713 23:19:29 InnoDB: Starting shutdown... 140713 23:19:29 InnoDB: Shutdown completed; log sequence number 2982779 140713 23:19:29 [Note] /usr/bin/mysqld: Shutdown complete 140713 23:19:29 mysqld_safe mysqld from pid file /data/srv/mysql/gimli.pid ended 140714 00:45:55 mysqld_safe Starting mysqld daemon with databases from /data/srv/mysql Code: 140714 140714 3:02:56 [ERROR] Invalid (old?) table or database name 'lost+found'
140714 10:20:57 mysqld_safe Starting mysqld daemon with databases from /data/srv/mysql 140714 10:21:00 InnoDB: The InnoDB memory heap is disabled 140714 10:21:00 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140714 10:21:00 InnoDB: Compressed tables use zlib 1.2.7 140714 10:21:00 InnoDB: Initializing buffer pool, size = 128.0M 140714 10:21:01 InnoDB: Completed initialization of buffer pool 140714 10:21:01 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 140714 10:21:01 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 140714 10:21:05 InnoDB: Waiting for the background threads to start 140714 10:21:06 InnoDB: 1.1.8 started; log sequence number 3282695 140714 10:21:06 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 140714 10:21:06 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 140714 10:21:06 [Note] Server socket created on IP: '0.0.0.0'. 140714 10:21:07 [Note] Event Scheduler: Loaded 0 events 140714 10:21:07 [Note] /usr/bin/mysqld: ready for connections. Version: '5.5.28' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Source distribution 140714 23:04:05 [Note] /usr/bin/mysqld: Normal shutdown |
|
| Author: | mattbatt [ Sat Jun 06, 2015 9:40 pm ] |
| Post subject: | Re: My database has become HUGE! |
these keep repeating Code: 2015-03-31 00:15:35 1542 [Note] RSA private key file not found: /data/srv/mysql//private_key.pem. Some authentication plugins will not work.
2015-03-31 00:15:35 1542 [Note] RSA public key file not found: /data/srv/mysql//public_key.pem. Some authentication plugins will not work. 2015-03-31 00:15:35 1542 [Note] Server hostname (bind-address): '*'; port: 3306 2015-03-31 00:15:35 1542 [Note] IPv6 is available. 2015-03-31 00:15:35 1542 [Note] - '::' resolves to '::'; 2015-03-31 00:15:35 1542 [Note] Server socket created on IP: '::'. 2015-03-31 00:15:36 1542 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened. 2015-03-31 00:15:36 1542 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened. 2015-03-31 00:15:36 1542 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:15:36 1542 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:15:36 1542 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:15:36 1542 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type bigint(20), found type int(11). 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:15:37 1542 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11). 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11). 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Column count of mysql.threads is wrong. Expected 14, found 3. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'users' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure 2015-03-31 00:15:37 1542 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure 2015-03-31 00:15:37 1542 [Note] Event Scheduler: Loaded 0 events 2015-03-31 00:15:37 1542 [Note] /usr/bin/mysqld: ready for connections. Version: '5.6.23' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) 2015-03-31 00:55:06 1542 [Note] /usr/bin/mysqld: Normal shutdown 2015-03-31 00:55:06 1542 [Note] Giving 6 client threads a chance to die gracefully 2015-03-31 00:55:06 1542 [Note] Event Scheduler: Purging the queue. 0 events 2015-03-31 00:55:06 1542 [Note] Shutting down slave threads 2015-03-31 00:55:08 1542 [Note] Forcefully disconnecting 2 remaining clients 2015-03-31 00:55:08 1542 [Warning] /usr/bin/mysqld: Forcing close of thread 24 user: 'mythtv' 2015-03-31 00:55:08 1542 [Warning] /usr/bin/mysqld: Forcing close of thread 11430 user: 'mythtv' 2015-03-31 00:55:08 1542 [Note] Binlog end 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'partition' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_METRICS' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_CMPMEM' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_CMP' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_LOCKS' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'INNODB_TRX' 2015-03-31 00:55:08 1542 [Note] Shutting down plugin 'InnoDB' 2015-03-31 00:55:08 1542 [Note] InnoDB: FTS optimize thread exiting. 2015-03-31 00:55:08 1542 [Note] InnoDB: Starting shutdown... 2015-03-31 00:55:09 1542 [Note] InnoDB: Shutdown completed; log sequence number 45612514 2015-03-31 00:55:09 1542 [Note] Shutting down plugin 'BLACKHOLE' 2015-03-31 00:55:09 1542 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2015-03-31 00:55:09 1542 [Note] Shutting down plugin 'ARCHIVE' 2015-03-31 00:55:09 1542 [Note] Shutting down plugin 'CSV' 2015-03-31 00:55:09 1542 [Note] Shutting down plugin 'MEMORY' 2015-03-31 00:55:09 1542 [Note] Shutting down plugin 'MRG_MYISAM' 2015-03-31 00:55:09 1542 [Note] Shutting down plugin 'MyISAM' 2015-03-31 00:55:09 1542 [Note] Shutting down plugin 'sha256_password' 2015-03-31 00:55:09 1542 [Note] Shutting down plugin 'mysql_old_password' 2015-03-31 00:55:09 1542 [Note] Shutting down plugin 'mysql_native_password' 2015-03-31 00:55:09 1542 [Note] Shutting down plugin 'binlog' 2015-03-31 00:55:09 1542 [Note] /usr/bin/mysqld: Shutdown complete 150331 00:55:10 mysqld_safe mysqld from pid file /data/srv/mysql/gimli.pid ended 150331 00:56:17 mysqld_safe Starting mysqld daemon with databases from /data/srv/mysql 2015-03-31 00:56:19 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2015-03-31 00:56:19 1523 [Note] InnoDB: Using atomics to ref count buffer pool pages 2015-03-31 00:56:19 1523 [Note] InnoDB: The InnoDB memory heap is disabled 2015-03-31 00:56:19 1523 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2015-03-31 00:56:19 1523 [Note] InnoDB: Memory barrier is not used 2015-03-31 00:56:19 1523 [Note] InnoDB: Compressed tables use zlib 1.2.8 2015-03-31 00:56:19 1523 [Note] InnoDB: Using Linux native AIO 2015-03-31 00:56:19 1523 [Note] InnoDB: Not using CPU crc32 instructions 2015-03-31 00:56:19 1523 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2015-03-31 00:56:20 1523 [Note] InnoDB: Completed initialization of buffer pool 2015-03-31 00:56:20 1523 [Note] InnoDB: Highest supported file format is Barracuda. 2015-03-31 00:56:30 1523 [Note] InnoDB: 128 rollback segment(s) are active. 2015-03-31 00:56:30 1523 [Note] InnoDB: Waiting for purge to start 2015-03-31 00:56:30 1523 [Note] InnoDB: 5.6.23 started; log sequence number 45612514 2015-03-31 00:56:30 1523 [Note] RSA private key file not found: /data/srv/mysql//private_key.pem. Some authentication plugins will not work. 2015-03-31 00:56:30 1523 [Note] RSA public key file not found: /data/srv/mysql//public_key.pem. Some authentication plugins will not work. 2015-03-31 00:56:30 1523 [Note] Server hostname (bind-address): '*'; port: 3306 2015-03-31 00:56:30 1523 [Note] IPv6 is available. 2015-03-31 00:56:30 1523 [Note] - '::' resolves to '::'; 2015-03-31 00:56:30 1523 [Note] Server socket created on IP: '::'. 2015-03-31 00:56:30 1523 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened. 2015-03-31 00:56:30 1523 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened. 2015-03-31 00:56:30 1523 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:56:30 1523 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:56:30 1523 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:56:30 1523 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure 2015-03-31 00:56:30 1523 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type bigint(20), found type int(11). 2015-03-31 00:56:30 1523 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure 2015-03-31 00:56:30 1523 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure 2015-03-31 00:56:30 1523 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:56:30 1523 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:56:30 1523 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure 2015-03-31 00:56:30 1523 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11). 2015-03-31 00:56:30 1523 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure 2015-03-31 00:56:30 1523 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11). |
|
| Author: | mattbatt [ Sat Jun 06, 2015 9:44 pm ] |
| Post subject: | Re: My database has become HUGE! |
I think this might be the key "please use mysql upgrade to fix this error. How do I do that? Code: 2015-03-31 00:56:30 1523 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2015-03-31 00:56:30 1523 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened. 2015-03-31 00:56:30 1523 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:56:30 1523 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. 2015-03-31 00:56:30 1523 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50528, now running 50623. Please use mysql_upgrade to fix this error. |
|
| Author: | tscholl [ Sun Jun 07, 2015 12:37 pm ] |
| Post subject: | Re: My database has become HUGE! |
Almost sounds like a wrong version of the database was restored. |
|
| Author: | mattbatt [ Mon Jun 08, 2015 9:39 pm ] |
| Post subject: | Re: My database has become HUGE! |
Here is the last two days entries into /data/srv/mysql/gimli.err I notice that all of these errors show up around the time I shut down LinHES. Code: 2015-06-07 00:38:19 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2015-06-07 00:38:19 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."music_radios" 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. 2015-06-07 00:38:19 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:19 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."music_radios" 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. 2015-06-07 00:38:20 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:20 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:20 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:20 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."music_radios" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:20 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:20 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."music_radios" 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. 2015-06-07 00:38:20 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:20 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."music_radios" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:20 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:20 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."music_radios" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:25 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:25 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."record_tmp" 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. 2015-06-07 00:38:25 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:25 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."record_tmp" 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. 2015-06-07 00:38:26 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:26 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:26 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:26 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."record_tmp" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:26 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:26 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."record_tmp" 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. 2015-06-07 00:38:26 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:26 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."record_tmp" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:26 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:26 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."record_tmp" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:31 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:31 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weatherdatalayout" 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. 2015-06-07 00:38:31 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:31 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weatherdatalayout" 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. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."weatherdatalayout" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weatherdatalayout" 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. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."weatherdatalayout" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."weatherdatalayout" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weatherscreens" 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. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weatherscreens" 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. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."weatherscreens" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weatherscreens" 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. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."weatherscreens" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."weatherscreens" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weathersourcesettings" 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. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:32 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weathersourcesettings" 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. 2015-06-07 00:38:33 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:33 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:33 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:33 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."weathersourcesettings" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:33 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:33 7f7a7f0b5700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weathersourcesettings" 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. 2015-06-07 00:38:33 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:33 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."weathersourcesettings" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:33 7f7a7f0b5700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:33 7f7a7f0b5700 InnoDB: Recalculation of persistent statistics requested for table "mythconverg"."weathersourcesettings" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2015-06-07 00:38:36 7f7a7d122700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:36 7f7a7d122700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."music_radios" 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. 2015-06-07 00:38:36 7f7a7d122700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:36 7f7a7d122700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."record_tmp" 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. 2015-06-07 00:38:36 7f7a7d122700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:36 7f7a7d122700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weatherdatalayout" 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. 2015-06-07 00:38:36 7f7a7d122700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:36 7f7a7d122700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weatherscreens" 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. 2015-06-07 00:38:36 7f7a7d122700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:36 7f7a7d122700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weathersourcesettings" 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. 2015-06-07 00:38:40 1668 [ERROR] Invalid (old?) table or database name 'lost+found' 2015-06-07 00:38:41 7f7a7d122700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:41 7f7a7d122700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."music_radios" 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. 2015-06-07 00:38:42 7f7a7d122700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:42 7f7a7d122700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."record_tmp" 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. 2015-06-07 00:38:43 7f7a7d122700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:43 7f7a7d122700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weatherdatalayout" 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. 2015-06-07 00:38:43 7f7a7d122700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:43 7f7a7d122700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weatherscreens" 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. 2015-06-07 00:38:43 7f7a7d122700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-06-07 00:38:43 7f7a7d122700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."weathersourcesettings" 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. 2015-06-07 00:46:32 1668 [ERROR] Invalid (old?) table or database name 'lost+found' 2015-06-07 00:46:33 1668 [ERROR] Invalid (old?) table or database name 'lost+found' 2015-06-07 00:46:33 1668 [ERROR] Invalid (old?) table or database name 'lost+found' 2015-06-07 00:46:59 1668 [ERROR] Invalid (old?) table or database name 'lost+found' 2015-06-07 00:47:00 1668 [ERROR] Invalid (old?) table or database name 'lost+found' 2015-06-07 00:47:00 1668 [ERROR] Invalid (old?) table or database name 'lost+found' 2015-06-07 01:00:49 1668 [Note] /usr/bin/mysqld: Normal shutdown 2015-06-07 01:00:49 1668 [Note] Giving 4 client threads a chance to die gracefully 2015-06-07 01:00:49 1668 [Note] Event Scheduler: Purging the queue. 0 events 2015-06-07 01:00:50 1668 [Note] Shutting down slave threads 2015-06-07 01:00:52 1668 [Note] Forcefully disconnecting 4 remaining clients 2015-06-07 01:00:52 1668 [Warning] /usr/bin/mysqld: Forcing close of thread 3660402 user: 'mythtv' 2015-06-07 01:00:52 1668 [Warning] /usr/bin/mysqld: Forcing close of thread 3609483 user: 'mythtv' 2015-06-07 01:00:52 1668 [Warning] /usr/bin/mysqld: Forcing close of thread 3654003 user: 'mythtv' 2015-06-07 01:00:52 1668 [Warning] /usr/bin/mysqld: Forcing close of thread 3660345 user: 'mythtv' 2015-06-07 01:00:52 1668 [Note] Binlog end 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'partition' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_METRICS' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_CMPMEM' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_CMP' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_LOCKS' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'INNODB_TRX' 2015-06-07 01:00:53 1668 [Note] Shutting down plugin 'InnoDB' 2015-06-07 01:00:53 1668 [Note] InnoDB: FTS optimize thread exiting. 2015-06-07 01:00:53 1668 [Note] InnoDB: Starting shutdown... 2015-06-07 01:00:59 1668 [Note] InnoDB: Shutdown completed; log sequence number 59573264 2015-06-07 01:00:59 1668 [Note] Shutting down plugin 'BLACKHOLE' 2015-06-07 01:00:59 1668 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2015-06-07 01:00:59 1668 [Note] Shutting down plugin 'ARCHIVE' 2015-06-07 01:00:59 1668 [Note] Shutting down plugin 'CSV' 2015-06-07 01:00:59 1668 [Note] Shutting down plugin 'MEMORY' 2015-06-07 01:00:59 1668 [Note] Shutting down plugin 'MRG_MYISAM' 2015-06-07 01:00:59 1668 [Note] Shutting down plugin 'MyISAM' 2015-06-07 01:00:59 1668 [Note] Shutting down plugin 'sha256_password' 2015-06-07 01:00:59 1668 [Note] Shutting down plugin 'mysql_old_password' 2015-06-07 01:00:59 1668 [Note] Shutting down plugin 'mysql_native_password' 2015-06-07 01:00:59 1668 [Note] Shutting down plugin 'binlog' 2015-06-07 01:00:59 1668 [Note] /usr/bin/mysqld: Shutdown complete 150607 01:01:00 mysqld_safe mysqld from pid file /data/srv/mysql/gimli.pid ended 150607 01:06:43 mysqld_safe Starting mysqld daemon with databases from /data/srv/mysql 2015-06-07 01:06:47 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2015-06-07 01:06:49 1544 [Note] InnoDB: Using atomics to ref count buffer pool pages 2015-06-07 01:06:49 1544 [Note] InnoDB: The InnoDB memory heap is disabled 2015-06-07 01:06:49 1544 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2015-06-07 01:06:49 1544 [Note] InnoDB: Memory barrier is not used 2015-06-07 01:06:49 1544 [Note] InnoDB: Compressed tables use zlib 1.2.8 2015-06-07 01:06:49 1544 [Note] InnoDB: Using Linux native AIO 2015-06-07 01:06:49 1544 [Note] InnoDB: Not using CPU crc32 instructions 2015-06-07 01:06:49 1544 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2015-06-07 01:06:49 1544 [Note] InnoDB: Completed initialization of buffer pool 2015-06-07 01:06:50 1544 [Note] InnoDB: Highest supported file format is Barracuda. 2015-06-07 01:06:56 1544 [Note] InnoDB: 128 rollback segment(s) are active. 2015-06-07 01:06:56 1544 [Note] InnoDB: Waiting for purge to start 2015-06-07 01:06:56 1544 [Note] InnoDB: 5.6.23 started; log sequence number 59573264 2015-06-07 01:06:56 1544 [Note] RSA private key file not found: /data/srv/mysql//private_key.pem. Some authentication plugins will not work. 2015-06-07 01:06:56 1544 [Note] RSA public key file not found: /data/srv/mysql//public_key.pem. Some authentication plugins will not work. 2015-06-07 01:06:56 1544 [Note] Server hostname (bind-address): '*'; port: 3306 2015-06-07 01:06:56 1544 [Note] IPv6 is available. 2015-06-07 01:06:56 1544 [Note] - '::' resolves to '::'; 2015-06-07 01:06:56 1544 [Note] Server socket created on IP: '::'. 2015-06-07 01:06:59 1544 [Note] Event Scheduler: Loaded 0 events 2015-06-07 01:06:59 1544 [Note] /usr/bin/mysqld: ready for connections. Version: '5.6.23' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) 2015-06-08 00:38:32 1544 [ERROR] Invalid (old?) table or database name 'lost+found' |
|
| Author: | mattbatt [ Mon Jun 08, 2015 9:43 pm ] |
| Post subject: | Re: My database has become HUGE! |
BTW I did do the database upgrade as suggested in the error log, however it was very quiet so I'm not sure what it did if anything. |
|
| Author: | mattbatt [ Tue Jun 23, 2015 9:05 pm ] |
| Post subject: | Re: My database has become HUGE! |
update: my /data/srv/mysql drive is almost full now too. [img] https://www.dropbox.com/s/f1d1w7uvn18f4 ... .png?raw=1 [/img] |
|
| Author: | tscholl [ Wed Jun 24, 2015 9:01 am ] |
| Post subject: | Re: My database has become HUGE! |
Do you have backend logging to the database enabled? I had a problem with this awhile back and had a discussion on how to disable it. http://forum.linhes.org/viewtopic.php?f ... t=+logging If thats the case you could truncate the log tables. Just a thought. Also what version are you running? |
|
| Author: | mattbatt [ Wed Jun 24, 2015 9:23 pm ] |
| Post subject: | Re: My database has become HUGE! |
8.3 everything should be up to date. I'll give that a try soon. Would the logging have turned it'self on a few months ago or when I upgraded to 8.3 . That's about when the problems started. |
|
| Author: | tscholl [ Thu Jun 25, 2015 8:20 am ] |
| Post subject: | Re: My database has become HUGE! |
I wouldn't think so unless you have a custom script somewhere. Log into mysql mysql -umythtv -p mythconverg select * from logging will tell you whats there. TRUNCATE TABLE logging; should clear the logging table if it has data there, |
|
| Author: | mattbatt [ Thu Jun 25, 2015 3:32 pm ] |
| Post subject: | Re: My database has become HUGE! |
Well my mythbackend.log is only 444Kb so that's not nearly as big as my sudo log 70Mb. There is still something making my backups huge. |
|
| Author: | mattbatt [ Fri Jun 26, 2015 5:40 am ] |
| Post subject: | Re: My database has become HUGE! |
it looks like the partition for /data/srv/mysql is getting filled by ibdata1, ib_logfile0 and ib_logfile1 can anyone else confirm these are or are not normal sizes for these files? Code: # ls -lha
total 116M drwx------ 10 mysql root 4.0K Jun 23 19:04 . drwxr-xr-x 5 root root 4.0K Apr 22 20:56 .. -rw-rw---- 1 mysql mysql 56 Mar 27 00:40 auto.cnf -rw-rw---- 1 mysql root 1.5M Jun 26 00:06 gimli.err -rw-rw---- 1 mysql mysql 5 Jun 23 19:04 gimli.pid -rw-rw---- 1 mysql mysql 18M Jun 26 00:06 ibdata1 -rw-rw---- 1 mysql mysql 48M Jun 26 00:06 ib_logfile0 -rw-rw---- 1 mysql mysql 48M Mar 27 00:40 ib_logfile1 drwx------ 2 mysql mysql 4.0K Jun 7 00:46 lost@002bfound drwx------ 2 root root 16K Jul 10 2014 lost+found drwx------ 2 mysql root 4.0K Jun 7 00:47 mysql -rw-r--r-- 1 root root 6 Jun 7 00:47 mysql_upgrade_info drwx------ 2 mysql mysql 20K Jun 26 00:06 mythconverg drwx------ 2 mysql mysql 4.0K Jul 14 2014 ncid drwx------ 2 mysql mysql 4.0K Jun 7 00:46 performance_schema drwx------ 2 mysql root 4.0K Jan 8 2014 test drwx------ 2 mysql mysql 4.0K Jul 14 2014 zm |
|
| Author: | brfransen [ Fri Jun 26, 2015 7:23 am ] |
| Post subject: | Re: My database has become HUGE! |
Those are all about the same size on my system. mythconverg is where you will probably find what the largest table are. Use sudo ncdu /data/srv/mysql (install if needed: pacman -S ncdu) to find the largest files. |
|
| Author: | bgrant3406 [ Fri Jun 26, 2015 1:44 pm ] |
| Post subject: | Re: My database has become HUGE! |
Took a quick peek at my Mythconverg directory and here is what I see, I have about 400 SD/HD recordings stored as a point of reference, my "iblog" files are in the same range (if not identical) to what you have posted. Code: [root@mbe mythconverg]# ls -lSh
total 234M -rw-rw---- 1 mysql mysql 105M Jun 26 00:10 recordedseek.MYD -rw-rw---- 1 mysql mysql 96M Jun 26 00:10 recordedseek.MYI -rw-rw---- 1 mysql mysql 4.6M Jun 26 05:29 program.MYI -rw-rw---- 1 mysql mysql 4.0M Jun 26 08:59 oldrecorded.MYI -rw-rw---- 1 mysql mysql 3.6M Jun 26 05:29 credits.MYI -rw-rw---- 1 mysql mysql 3.3M Jun 26 05:29 program.MYD -rw-rw---- 1 mysql mysql 3.3M Jun 26 08:59 oldrecorded.MYD -rw-rw---- 1 mysql mysql 1.9M Jun 26 05:29 people.MYI -rw-rw---- 1 mysql mysql 1.6M Jun 26 05:29 credits.MYD -rw-rw---- 1 mysql mysql 1.4M Jun 26 05:29 people.MYD -rw-rw---- 1 mysql mysql 513K Jun 26 05:29 programgenres.MYD -rw-rw---- 1 mysql mysql 470K Jun 26 05:29 programgenres.MYI -rw-rw---- 1 mysql mysql 428K Jun 26 05:29 programrating.MYI -rw-rw---- 1 mysql mysql 400K Jun 26 05:29 programrating.MYD -rw-rw---- 1 mysql mysql 251K Jun 26 00:10 recordedcredits.MYI -rw-rw---- 1 mysql mysql 224K Jun 26 00:10 record_tmp.ibd -rw-rw---- 1 mysql mysql 192K Jun 26 00:10 music_songs.ibd -rw-rw---- 1 mysql mysql 192K Jun 26 00:10 romdb.ibd -rw-rw---- 1 mysql mysql 176K Jun 26 00:10 gamemetadata.ibd -rw-rw---- 1 mysql mysql 171K Jun 26 00:10 oldprogram.MYD -rw-rw---- 1 mysql mysql 164K Jun 26 00:10 recordedmarkup.MYI -rw-rw---- 1 mysql mysql 150K Jun 26 11:21 recorded.MYD |
|
| Page 1 of 2 | All times are UTC - 6 hours |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|
