Fork me on GitHub

Changes for #91

Description changed by Franz (2010-08-02 22:19:20)

 1:  1:
 We're noticing significant performance differences in FluxBB 1.4.X vs. the 1.2.X series. I'm going to attach a few things that come to mind, and I'd be glad to chip in more, but here we go. We're noticing significant performance differences in FluxBB 1.4.X vs. the 1.2.X series. I'm going to attach a few things that come to mind, and I'd be glad to chip in more, but here we go.
  
 +[quote]
 $ mysqladmin status $ mysqladmin status
 Uptime: 309733  Threads: 1  Questions: 31691959  Slow queries: 1110  Opens: 1146  Flush tables: 1  Open tables: 291  Queries per second avg: 102.320 Uptime: 309733  Threads: 1  Questions: 31691959  Slow queries: 1110  Opens: 1146  Flush tables: 1  Open tables: 291  Queries per second avg: 102.320
 $ mysqld --version $ mysqld --version
 mysqld  Ver 5.1.47-log for unknown-linux-gnu on x86_64 (Source distribution) mysqld  Ver 5.1.47-log for unknown-linux-gnu on x86_64 (Source distribution)
 $ uname -a $ uname -a
 Linux gudrun 2.6.34-ARCH #1 SMP PREEMPT Mon Jul 5 22:12:11 CEST 2010 x86_64 Intel(R) Xeon(TM) CPU 2.80GHz GenuineIntel GNU/Linux Linux gudrun 2.6.34-ARCH #1 SMP PREEMPT Mon Jul 5 22:12:11 CEST 2010 x86_64 Intel(R) Xeon(TM) CPU 2.80GHz GenuineIntel GNU/Linux
 +[/quote]
  
 All FluxBB tables are InnoDB. All FluxBB tables are InnoDB.
  
 +[quote]
 mysql> SELECT TABLE_SCHEMA, count(*) TABLES, concat(round(sum(table_rows)/1000000,2),'M') rows, concat(round(sum(data_length)/(1024*1024*1024),2),'G') DATA, concat(round(sum(index_length)/(1024*1024*1024),2),'G') idx, concat(round(sum(data_length+index_length)/(1024*1024*1024),2),'G') total_size, round(sum(index_length)/sum(data_length),2) idxfrac FROM information_schema.TABLES WHERE table_schema = 'fluxbb' GROUP BY TABLE_SCHEMA; mysql> SELECT TABLE_SCHEMA, count(*) TABLES, concat(round(sum(table_rows)/1000000,2),'M') rows, concat(round(sum(data_length)/(1024*1024*1024),2),'G') DATA, concat(round(sum(index_length)/(1024*1024*1024),2),'G') idx, concat(round(sum(data_length+index_length)/(1024*1024*1024),2),'G') total_size, round(sum(index_length)/sum(data_length),2) idxfrac FROM information_schema.TABLES WHERE table_schema = 'fluxbb' GROUP BY TABLE_SCHEMA;
 +--------------+--------+--------+-------+-------+------------+---------+ +--------------+--------+--------+-------+-------+------------+---------+
 | TABLE_SCHEMA | TABLES | rows   | DATA  | idx   | total_size | idxfrac | | TABLE_SCHEMA | TABLES | rows   | DATA  | idx   | total_size | idxfrac |
 +--------------+--------+--------+-------+-------+------------+---------+ +--------------+--------+--------+-------+-------+------------+---------+
 | fluxbb       |     17 | 23.14M | 1.34G | 0.91G | 2.26G      |    0.68 | | fluxbb       |     17 | 23.14M | 1.34G | 0.91G | 2.26G      |    0.68 |
 +--------------+--------+--------+-------+-------+------------+---------+ +--------------+--------+--------+-------+-------+------------+---------+
 1 row in set (0.84 sec) 1 row in set (0.84 sec)
 +[/quote]