Archive

Archive for May, 2011

Drizzle support for phpMyAdmin – week 1

May 29th, 2011 No comments

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:

Drizzle support for phpMyAdmin – plans for first week

May 21st, 2011 No comments

Coding for Summer of Code is about to begin, meaning that for the next twelve weeks you will be seeing here weekly reports on my work. I have already set up my environment and made some changes to random bits of phpMyAdmin code, mostly to facilitate access to database metadata stored in information_schema and data_dictionary schemas. At the beginning I won’t be spending entire weeks on coding because my semester ends around the end of June, but changes introduced during that period will probably have the biggest impact on Drizzle support in phpMyAdmin – at the end of June all browsing and searching features should be working correctly.

Like in previous year, my public code repository lies at http://repo.or.cz/w/phpmyadmin/crack.git, with the work occurring on the drizzle branch. Demo version, updated hourly, is at http://demo.phpmyadmin.net/gsoc-piotr/. During the first week I want to make sure that the most basic functionality works correctly, i.e. we have correct and navigation frame and database/table lists. Some work on that is already done, but there are still some missing bits. If possible, I want to extract information on table and index sizes, which I should be able to do for InnoDB tables working with InnoDB plugin (HailDB doesn’t publish necessary information in data_dictionary).

Categories: phpMyAdmin, Summer of Code 2011 Tags: