Colleagues, at the request of security workers at work, had to roll back from MqSQL 5.5 to 5.1, because Of support from RedHat there is only this version. Exported database from 5.5. imported into 5.1. Everything works, except replication server. Error connecting to master. I associate this problem with this (the result of the mysql_upgrade command ):

Repairing tables performance_schema.cond_instances Error : Unknown table engine 'PERFORMANCE_SCHEMA' error : Corrupt performance_schema.events_waits_current Error : Unknown table engine 'PERFORMANCE_SCHEMA' error : Corrupt performance_schema.events_waits_history Error : Unknown table engine 'PERFORMANCE_SCHEMA' error : Corrupt performance_schema.events_waits_history_long Error : Unknown table engine 'PERFORMANCE_SCHEMA' error : Corrupt performance_schema.events_waits_summary_by_instance Error : Unknown table engine 'PERFORMANCE_SCHEMA' error : Corrupt performance_schema.events_waits_summary_by_thread_by_event_name Error : Unknown table engine 'PERFORMANCE_SCHEMA' error : Corrupt performance_schema.events_waits_summary_global_by_event_name Error : Unknown table engine 'PERFORMANCE_SCHEMA' error : Corrupt performance_schema.file_instances Error : Unknown table engine 'PERFORMANCE_SCHEMA' error : Corrupt performance_schema.file_summary_by_event_name Error : Unknown table engine 'PERFORMANCE_SCHEMA' error : Corrupt performance_schema.file_summary_by_instance Error : Unknown table engine 'PERFORMANCE_SCHEMA' error : Corrupt performance_schema.mutex_instances Error : Unknown table engine 'PERFORMANCE_SCHEMA' error : Corrupt performance_schema.performance_timers Error : Unknown table engine 'PERFORMANCE_SCHEMA' error : Corrupt performance_schema.rwlock_instances Error : Unknown table engine 'PERFORMANCE_SCHEMA' error : Corrupt performance_schema.setup_consumers Error : Unknown table engine 'PERFORMANCE_SCHEMA' error : Corrupt performance_schema.setup_instruments Error : Unknown table engine 'PERFORMANCE_SCHEMA' error : Corrupt performance_schema.setup_timers Error : Unknown table engine 'PERFORMANCE_SCHEMA' error : Corrupt performance_schema.threads Error : Unknown table engine 'PERFORMANCE_SCHEMA' error : Corrupt Running 'mysql_fix_privilege_tables'... ERROR 29 (HY000) at line 349: File '/var/log/general.log' not found (Errcode: 13 ) FATAL ERROR: Upgrade failed

Tried to do optimization and repair - does not help. Please indicate the way to solve the problem. thank

    1 answer 1

    PERFORMANCE_SCHEMA - a feature that appeared in 5.5, in 5.1 it does not work. The server of version 5.5 within the framework of this feature created tables for keeping statistics of performance, and 5.1 does not understand what to do with them. REPAIR does not help - nothing is "broken" and there is nothing to "repair".

    The ideal option is to dump all the databases you need at 5.5, completely remove the MySQL server with all its data, set up clean 5.1 and restore the databases from dumps. Do not forget about mysql users.

    • 5.5 completely removed, 5.1 from scratch set. Base sdampil with 5.5 and imported in 5.1. It is no longer to roll back, because The databases are imported and there are already changes to them. - lsv
    • That is, did you do all this right away on the production, without checking in the test environment? - AntonioK
    • Unfortunately yes. I did not expect that there may be problems - lsv
    • Downgrade major (ax -> ay) version is always a potentially dangerous situation. How much data is in the database, how much is the total dump of the whole? - AntonioK
    • 10 bases. The total amount of 80 MB. From the moment of import of databases on 5.1, there are already changes in it that will be quite problematic to restore. - lsv