August 2016 - discuss - lists.mariadb.org

[Maria-discuss] Orphaned TokuDB tables
by Rich Prohaska 02 Aug '16

02 Aug '16

Hello All, Sometimes, TokuDB gets left in a state where it thinks that parts of a table exist (as observed in TokuDB's file map), but not all of the underlying files (the TokuDB data files and/or the frm file) exist. This probably occurs due to the interaction between the non-transactional DDL that MySQL/MariaDB uses to create or drop tables, and the transactional TokuDB engine underneath. There is some bug there. So, what can one do to remove broken TokuDB file maps? There is an internal fractal tree called the tokudb.directory that names high level data names to an underlying file that the data is stored in. The tokudb_file_map information schema dumps out the contents of this tree. The key to this tree is the high level data name (called a dname). In TokuDB, this data name consists of the database name, the table name, and the index name. There is also a tree for the table (called status) that contains table wide metadata. I added the tokudb_delete_dnames_from_directory tool to the https://github.com/prohaska7/mariadb-server/tree/fix-tokudb-filemap branch. This standalone tool can be used to delete dnames from the tokudb.directory. Standalone means that MariaDB must have been previously shutdown cleanly (which puts the tokudb recovery logs in a nice clean state so that the tool does not have to run crash recovery). The input to the tool is the MariaDB data directory with nice and clean tokudb recovery logs along with a sequence of dname's. The tool transactionally deletes rows from the tokudb.directory fractal tree, which updates the recovery logs. Building the tool requires a MariaDB build environment a simple compile sequence something like this: gcc -g -o tokudb_delete_dnames_from_directory tokudb_delete_dnames_from_directory.cc -I$TFT/buildheader -L$TFT/src -ltokufractaltree Running the tool looks something like this: Get the dnames of interest from the tokudb_file_map. In this case, they are ./test/s-main and ./test/s-status. shutdown MariaDB ./tokudb_delete_dnames_from_directory ~/projects/mariadb-server-install/data ./test/s-main ./test/s-status

2 2

[Maria-discuss] New Question: Missing CentOS7 RPM: MariaDB-10.1.16-centos7-x86_64-cassandra-engine.rpm?
by AskMonty KB 02 Aug '16

02 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by justin.w.calloway_60714. Please answer it at http://mariadb.com/kb/en/missing-centos7-rpm-mariadb-10116-centos7-x86_64-c… as the person asking the question may not be subscribed to the mailing list. -------------------------------- It appears the rpm for the Cassandra storage engine is not available in your repository for centos7 or rhel7. The package exist in in centos 6 repository but not 7, is this on purpose? Is the Cassandra storage engine supported on CentOS7? Example of Cassandra storage engine rpm in the CentOS6 repo: http://yum.mariadb.org/10.1/centos6-amd64/rpms/ Example of the CentOS7 repo not containing the Cassandra storage engine rpm: http://yum.mariadb.org/10.1/centos7-amd64/rpms/ -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/missing-centos7-rpm-mariadb-10116-centos7-x86_64-c…

1 0

[Maria-discuss] New Question: MONyog Monitoring
by AskMonty KB 02 Aug '16

02 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/monyog-monitoring/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is MONyog capable of monitoring INNODB table locks and mutex locks?? Also can it monitor binary logs of MariaDB database.?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-monitoring/

1 0

[Maria-discuss] New Question: MONyog Table Alert
by AskMonty KB 02 Aug '16

02 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/monyog-table-alert/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- How do i set up an alert for all the tables in all databases if they grow more than specified size ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-table-alert/

1 0