Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-4662

Initial Percona Server 8.0 documentation

    XMLWordPrintable

    Details

    • Type: Admin & Maintenance Task
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 8.0.13-3
    • Component/s: Documentation
    • Labels:
      None

      Description

      Changes in Percona Server 8.0 from 5.7

      Removed features due to upstream changes

      • Query Response Time plugin has been removed due to Performance Schema providing statement execution time histogram data (https://dev.mysql.com/doc/refman/8.0/en/statement-histogram-summary-tables.html)
      • SE enforcement removed because of upstream SE blacklisting feature
      • LOCK BINLOG FOR BACKUP has been removed due to the introduction of performance_schema.log_status table.
      • innodb_flush_method=ALL_O_DIRECT removed due to being incompatible with the new redo logging implementation.
      • InnoDB memory size information reporting in SHOW ENGINE INNODB STATUS has been removed due to the same information being available in Performance Schema memory summary tables

      User-visible changes

      • CMake option -DWITH_SYSTEM_LIBS=ON configures with -DWITH_READLINE=system instead of -DWITH_EDITLINE=system
      • Redo log section extensions in SHOW ENGINE INNODB STATUS output now print the high watermark value of "Modified age" due to 8.0 new redo log scheme
      • TODO SET STATEMENT FOR -> SET_VAR

      Removed features due to lack of user uptake

      These might be reinstated based on demand.

      • INFORMATION_SCHEMA.XTRADB_RSEG table
      • Expanded program option modifiers
      • Utility user
      • pseudo_server_id
      • CSV_MODE
      • max_slowlog_files and max_slowlog_size
      • innodb_show_verbose_locks

      Deprecated feature removals

      • The deprecated scalability metrics plugin has been removed
      • CONCURRENT_CONNECTIONS column in INFORMATION_SCHEMA.THREAD_STATISTICS table, whose value was always zero, has been removed.
      • innodb_kill_idle_transactions system variable, which was a deprecated alias for kill_idle_transactions, has been removed.
      • mysqld_safe NUMA support
      • Query cache patches have been removed due to query cache removal: qc_miss value of log_slow_filter system variable; QC_hit flag of slow query log extensions; "Waiting on query cache mutex" thread state in processlist; query_cache_strip_comments system variable;

      Other doc updates

      • "expanded program option modifiers" examples need to replace query cache with something else
      • Any code examples referring to any INFORMATION_SCHEMA.INNODB_SYS_* table (i.e. INODB_SYS_TABLESPACES) need to remove "SYS_" from the table/view name (https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-3.html)
      • List of upstream bugs fixed in Percona Server 8.0 (Up-to-date as of 8.0.4)

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                borys.belinsky Borys Belinsky (Inactive)
                Reporter:
                laurynas.biveinis Laurynas Biveinis (Inactive)
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - Not Specified
                    Not Specified
                    Logged:
                    Time Spent - 58 minutes
                    58m