Hallo zusammen,
ich habe seit dem letzten Update auf 15.10 deutliche Performance Probleme und sehr oft Abstürze der "Akonadi_Ressource". Ich vermute das hat was mit dem mysql zu tun (siehe Fehlerlog), da auch mysql oft hohe CPU Last fordert. Leider bin ich mysql Leihe...
Errorlog vom mysql Test:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 | 2015-12-05 13:13:30 4760 [Note] Plugin 'FEDERATED' is disabled. 2015-12-05 13:13:30 7fc6ceba5740 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2015-12-05 13:13:30 4760 [Note] InnoDB: Using atomics to ref count buffer pool pages 2015-12-05 13:13:30 4760 [Note] InnoDB: The InnoDB memory heap is disabled 2015-12-05 13:13:30 4760 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2015-12-05 13:13:30 4760 [Note] InnoDB: Memory barrier is not used 2015-12-05 13:13:30 4760 [Note] InnoDB: Compressed tables use zlib 1.2.8 2015-12-05 13:13:30 4760 [Note] InnoDB: Using Linux native AIO 2015-12-05 13:13:30 4760 [Note] InnoDB: Not using CPU crc32 instructions 2015-12-05 13:13:30 4760 [Note] InnoDB: Initializing buffer pool, size = 80.0M 2015-12-05 13:13:30 4760 [Note] InnoDB: Completed initialization of buffer pool 2015-12-05 13:13:30 4760 [Note] InnoDB: Highest supported file format is Barracuda. 2015-12-05 13:13:30 4760 [Note] InnoDB: 128 rollback segment(s) are active. 2015-12-05 13:13:30 4760 [Note] InnoDB: Waiting for purge to start 2015-12-05 13:13:30 4760 [Note] InnoDB: 5.6.27 started; log sequence number 8391806777 2015-12-05 13:13:30 4760 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50529, now running 50627. Please use mysql_upgrade to fix this error. 2015-12-05 13:13:30 4760 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50529, now running 50627. Please use mysql_upgrade to fix this error. 2015-12-05 13:13:30 4760 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50529, now running 50627. Please use mysql_upgrade to fix this error. 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure 2015-12-05 13:13:30 4760 [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-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50529, now running 50627. Please use mysql_upgrade to fix this error. 2015-12-05 13:13:30 4760 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50529, now running 50627. Please use mysql_upgrade to fix this error. 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure 2015-12-05 13:13:30 4760 [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-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure 2015-12-05 13:13:30 4760 [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-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Column count of mysql.threads is wrong. Expected 14, found 3. Created with MySQL 50529, now running 50627. Please use mysql_upgrade to fix this error. 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'users' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure 2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure 2015-12-05 13:13:30 4760 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.27-0ubuntu1' socket: '/tmp/akonadi-matthias.tQpLsk/mysql.socket' port: 0 (Ubuntu) 2015-12-05 13:13:30 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-05 13:13:30 7fc6bd900700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."collectionattributetable" 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-12-05 13:13:30 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-05 13:13:30 7fc6bd900700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."collectionmimetyperelation" 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-12-05 13:13:30 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-05 13:13:30 7fc6bd900700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."collectionpimitemrelation" 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-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."collectiontable" 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-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."flagtable" 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-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."mimetypetable" 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-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."parttable" 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-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."parttypetable" 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-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."pimitemflagrelation" 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-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."pimitemtable" 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-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."pimitemtagrelation" 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-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."relationtable" 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-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."relationtypetable" 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-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."resourcetable" 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-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."schemaversiontable" 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-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."tagattributetable" 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-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."tagremoteidresourcerelationtable" 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-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."tagtable" 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-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."tagtypetable" 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. |
Im Netz gibt es dazu ein paar bugfixe, aber damit kam doch als Leihe nicht klar...
Kann mir hier jemand weiterhelfen?
Im Anhang den gesamten Testbericht von Akonadi.
Vielen Dank
MAtthias