MariaDB common-schema

[GoogleCodeExporter]

Which version of common_schema are you using? (specify revision+distribution)
common_schema_percona_server-r218.sql

Which component is failing? (specify the view, function, etc.)
VIEW innodb_index_rows
VIEW innodb_index_stats

What is the expected output? What do you see instead?
Install common-schema. Error.
I don't know if this is MariaDB or Percona issue (I don't have a Percona server 
to test).

Can you provide with sample data?
ERROR 1054 (42S22) at line 5410: Unknown column 'row_per_keys' in 'field list'

------------------------------
[root@process ~]# diff common_schema_percona_server-r218.sql 
common_schema_percona_server-r218-MariaDB.sql
5420c5420
<     TRIM(SUBSTRING_INDEX(SUBSTRING_INDEX(row_per_keys, ',', SEQ_IN_INDEX), 
',', -1)) AS incremental_row_per_key

---
>     TRIM(SUBSTRING_INDEX(SUBSTRING_INDEX(rows_per_key, ',', SEQ_IN_INDEX), 
',', -1)) AS incremental_row_per_key
5435c5435
<       ROUND((index_size - 1)/(index_size - leaf_pages), 1),

---
>       ROUND((index_total_pages - 1)/(index_total_pages - index_leaf_pages), 
1),
5439c5439
<       ROUND(1 + log(leaf_pages)/log((index_size - 1)/(index_size - 
leaf_pages)), 1),

---
>       ROUND(1 + log(index_leaf_pages)/log((index_total_pages - 
1)/(index_total_pages - index_leaf_pages)), 1),

[root@process ~]# mysql -u******* -p < 
common_schema_percona_server-r218-MariaDB.sql
Enter password: 
complete
Installation complete. Thank you for using common_schema!

Original issue reported on code.google.com by gabr...@e-radical.ro on 5 Sep 2012 at 2:50

[GoogleCodeExporter]

Hi,
This is documented, and is due to changes to Percona Server schema 
(row_per_keys changed to rows_per_key in Percona Server 5.5.8-20.0).

Fortunately for you, just yesterday common_schema 1.1 was released, where the 
newer schema is supported. So please upgrade. I'm happy to re-open this bug if 
problem persists (I did not test with MariaDB).

Original comment by shlomi.n...@gmail.com on 5 Sep 2012 at 3:42

• Changed state: Done