Re: Older version of MySQL server are faster than newer Versions

[Peter Brawley]

MySQL diagnostics nadir8.0.24.txt

DB sizes
InnoDB | 0.02 GB | 0.00 GB | 0.02 GB |
CSV    | 0.00 GB | 0.00 GB | 0.00 GB |
TOTALS | 0.02 GB | 0.00 GB | 0.02 GB |
MySQL version                           8.0.24          
Slow queries/sec                        0               
Queries not using indexes               0               
Queries needing full table scans/sec    0.0132          Find & optimise those queries
InnoDB buffer pool inefficiency         0.0019          Grow innodb_buffer_pool_size if > 2% or if innodb_buffer_pool_size < 70% of RAM
InnoDB page reads / pool read requests  0.0019          Grow innodb_buffer_pool_size if > 2% or if innodb_buffer_pool_size < 70% of RAM
InnoDB log file thrashing               0.0938          Best is near 0.5; grow innodb_log_file_size if well under 0.5, shrink if much larger
Time between InnoDB log rotation        0:14:09         Grow log size if < 30 min, shrink if > 60 min, but see here.
Est. best InnoDB log file size          128MB           Average hour of writes rounded up to 32MB boundary
InnoDB buffer pool reads / sec          7.9057          If high, increase Innodb_buffer_pool_size up to 70% of RAM
MyISAM key buffer size                  8MB             Min pre-8.0=40MB, max(64-bit) depends on OS and memory
MyISAM buffer hit ratio                 0               If < 10, grow key_buffer_size
MyISAM key write ratio                  0               Much higher than 1 suggests a disk write bottleneck
MyISAM key read rate                    0               
Query cache hits/inserts                0               
Query cache spills / sec                0               
Query cache hits / sec                  0               
Temp tables created/sec                 0.01            If > 20, find the queries responsible and optimise them, 
Temp tables created on disk/Questions   0               If > .05, try growing join_buffer_size, optimise responsible queries, 
Temp tables created on disk/sec         0               If high, grow tmp_table_size, max_heap_size. Avoid Blobs, use HEAP tables in queries
Database changes / connection           0.2             Use db.table syntax
Processes/connection                    0.2             If high, grow thread_cache_size
Files opened/sec                        0.02            If > 5, increase table_open_cache
Queries/sec                             1.66            Thousands is busy: you may need better hardware
Writes/sec                              0.07            If, over 50/sec, better disk hardware may be needed
Insert statements/sec                   0.07            
Inserts/sec                             216.36          Can be up to 20K/sec with efficient memory use, see here
Next table row requests/sec             3               If high, queries need optimising esp. with covering indexes
Sampling time                           0:08:50         If < 2h in a typical use period, re-do
Max MySQL RAM use                       2.6GB           Must be less than RAM available to MySQL
Available RAM                           unknown         If less than Max MySQL memory use, more memory needed

InnoDB basic stats

innobuffpool:       1024MB
bytes read/sec      27028
reads/sec           2
bytes/read          16059
writes/sec          24
bytes/write         7092
bytes written/sec   169894
rollback %          0
buffpool free       95.7%