June 19, 2013

Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

June 10, 2013 By 3 Comments

…the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force …directory and file name components in a bitmap file name could stop the server starting if the innodb_data… Bug fixed #1186690. Under very rare circumstances, deleting a zero-size bitmap file at …

Filed Under: MySQL, Percona Server, Percona Software Tagged With:

Post: Percona Server 5.6.11-60.3 first Release Candidate now available

June 3, 2013 By 3 Comments

…” align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] …concurrency. Bug fixed #1185686. Under very rare circumstances, deleting a zero-size bitmap file at the …directory and file name components in a bitmap file name could stop the server starting if the innodb_data…

Filed Under: MySQL, Percona Server, Percona Software Tagged With: ,

Post: How to Monitor MySQL with Percona's Nagios Plugins

February 22, 2012 By 11 Comments

… deleted but remain open via a filehandle. Wrong filesystem privileges. It’s very easy for a file to creep into MySQL‘s data directory… inconvenient times. The pmp-check-mysql-file-privs plugin checks whether MySQL owns every file and directory within its data directory. InnoDB is getting stuck…

Filed Under: Insight for DBAs, MySQL

Post: How to recover deleted rows from an InnoDB Tablespace

February 20, 2012 By 4 Comments

… to delete the records of the employee 10008 from the table “salaries”. After the “accidental” deletion of rows you should stop MySQL, take…/recovery-tool/data. After the compile process we need to copy the salaries.ibd tablespace to the recovery-tool’s data directory. In…, 3 rows affected (0.01 sec) Records: 3 Deleted: 0 Skipped: 0 Warnings: 0 mysql (employees) > select * from salaries where emp_no…

Filed Under: Insight for DBAs, MySQL

Post: Using Flexviews - part two, change data capture

March 25, 2011 By 26 Comments

… has serious drawbacks, such that it can’t identify deleted rows and MySQL timestamps may not be flexible enough. The trigger method…/ subdirectory. Create the settings file: Change to the flexviews/consumer directory and copy the consumer.ini.example file to consumer.ini… sec) Records: 2 Duplicates: 0 Warnings: 0 And delete data in a second transaction: mysql> delete from test.demo where c1=1; Query OK…

Filed Under: Insight for DBAs, Insight for Developers, MySQL

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… call this data set “SEO” – it’s about 20MB of actual data. The other one is a set of about 790K directory records… in our database directory: -rw-rw—-. 1 mysql mysql 8632 Feb 20 15:54 dir_test_innodb.frm -rw-rw—-. 1 mysql mysql 213909504 Feb… (0.00 sec) mysql> delete from dir_test_innodb LIMIT 200000; Query OK, 200000 rows affected (8.65 sec) mysql> optimize table dir…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: How to recover a single InnoDB table from a Full Backup

January 25, 2012 By 10 Comments

…-10 | | 10008 | 52668 | 2000-03-10 | 2000-07-31 | +——–+——–+————+————+ mysql> DELETE FROM salaries WHERE emp_no=10008; The next step … data directory: # cp /tmp/2012-01-22_14-13-20/employees/salaries.ibd /var/lib/mysql/data/employees/ Import the new tablespace: mysql> …

Filed Under: Insight for DBAs, MySQL, Percona Software

Post: Concatenating MyISAM files

November 19, 2012 By 5 Comments

… previous disaster recovery work where a database directory has been wiped out that the MyISAM…Data records: 3 – Fixing index 1 Data records: 6 And then, back in mysql: mysql> use test Database changed mysql>… mysql> delete from test_concat_part where id = 44; Query OK, 1 row affected (0.00 sec) mysql…

Filed Under: MySQL

Post: MySQL 5.6: Improvements in the Nutshell

January 27, 2013 By 16 Comments

… outline of improvements available in MySQL 5.6 which I thought …/O Instrumentation – Improved EXPLAIN – - Explain for UPDATE/DELETE queries – - JSON output with more information – … – New configuration files defaults – User Defined DATA DIRECTORY for Innodb Tables – Connection Attributes New …

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , ,

Post: A quest for the full InnoDB status

October 31, 2008 By 4 Comments

… full status output into innodb_status. file located in MySQL data directory. Unfortunately this is a startup time parameter, so unless you… deleted mysqld 11886 mysql 5u REG 253,10 130932 12 /tmp/ibuQBSgo (deleted) mysqld 11886 mysql 6u REG 253,10 0 13 /tmp/ibLVtBuZ (deleted…

Filed Under: Insight for DBAs Tagged With: ,
« Older Posts