… The syntax below if specific for MySQL, but note that SchemaSpy works for pretty much all the popular RDBMS out there. java… the table sizes and an easy way to use the search feature of your browser to zero in on a particular table Constraints – lists the explicit Foreign Key constraints in the database (this does not…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
…_record_cmds : This is the list of commands you want written to the log (all the lists in these variables are comma separated). As… case. Maybe someone more knowledgeable in MySQL internals can enlighten me here. – audit_record_objs : List of database objects (tables, according to the docs…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…MySQL 5.6.11, including all the bug fixes in it, Percona Server 5.6.11-60.3 is the first RC release in…. Complete list of the ported features can be seen in Percona Server … the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS,…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… the perfect case for read-only transaction optimization in MySQL 5.6, because all SELECT queries in the AUTOCOMMIT mode are, by definition, read…: First of all, we used a smaller dataset for this benchmarks round, since reportedly Dimitri was using 8 tables with 1M rows… the read-only transactions optimization in MySQL 5.6 virtually eliminates contention on the mutex protecting the list of transactions, its applicability is…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…| +————–+—–+——–+——+——–+———+————–+——-+ SYS_INDEXES This table lists all indexes the table has, secondary as well as the primary. CREATE TABLE `SYS_INDEXES` ( `TABLE_ID`… their content. Index id in our example is 1679: mysql> SELECT * FROM SYS_FIELDS WHERE …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…Repositories). Based on MySQL 5.5.30, including all the bug fixes in it, Percona Server 5… fixed #1131187 (Alexey Kopytov). Removed trx_list scan in read_view_open_now() which is another…Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing. …
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… omission: pt-table-sync. It’s still unclear if or how one would sync a cluster that, in theory, doesn’…-in MySQL options No more “pt-stalk — -h db1 -u me”. pt-stalk 2.2 and pt-mysql-summary 2.2 have all…net/percona-toolkit/+milestone/2.2.1 for the full list. If you upgrade from 2.1 to 2.2, …
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… fixed #1131187 (Alexey Kopytov). Removed trx_list scan in read_view_open_now() which is …–innodb-optimize-keys and –no-data options, all secondary key definitions would be lost. Bug …Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing. …
Post: Percona Toolkit 2.2.2 released; bug fixes include pt-heartbeat & pt-archiver
May 6, 2013 By 2 Comments
… Percona Live MySQL Conference & Expo 2013 the week before last, we quietly …–show-all option in pt-query-digest. This had been removed in 2.2.1, but resulted in too much output in …in a DSN table (–recursion-method=dsn). See https://launchpad.net/percona-toolkit/+milestone/2.2.2 for the full list…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…baseline HDD configuration for MySQL (configuration A, listed at the bottom of…FlashCache does substantially better, coming in at an average of …MySQL & Benchmark Configuration All benchmarks were conducted with the following: sysbench –num-threads=32 –test=tests/db/oltp.lua –oltp_tables…
