Home > phpMyAdmin, Summer of Code 2011 > Drizzle support for phpMyAdmin – week 1

Drizzle support for phpMyAdmin – week 1

May 29th, 2011

With first week over, phpMyAdmin is now able to correctly handle displaying of navigation frame and database / table lists for Drizzle. The changes introduced this week were:

  • reading of table size and average row length from table cache (meaning that it works only if table is loaded into Drizzle’s cache),
  • showing row counts for PBMS tables, internally they are treated as InnoDB tables with approximate row count of 0,
  • database list tab works correctly, the number of available statistics is way down when compared to MySQL, but its a direct consequence of lack of table statistics in Drizzle,
  • I hid tabs for features not supported by Drizzle: Replication, Privileges, Engines (this will get replaced with a new Plugins tab),
  • due to how privileges work, everyone is treated as a superuser,
  • home page no more shows any “MySQL” headers when connected to a Drizzle server,
  • some internal changes that are not directly related to this week’s planned tasks, but involve my future work, i.e. removal of deprecated PMA_DBI_get_fields, changes to PMA_DBI_get_columns

Week ago I hoped to get accurate table and index sizes for InnoDB, as the engine itself makes it possible to access this data (as the amount of disk pages used by object), but it appears that only Percona makes this information available. MySQL seems to use it internally with its SHOW FULL TABLE STATUS, and Drizzle has currently no way of accessing it.

During next week I want to create a new server tab – Plugins, which replaces Engines tab for MySQL, and provides a list of all loaded plugins.

Categories: phpMyAdmin, Summer of Code 2011 Tags:
Comments are closed.