June 19, 2013

Post: Bug#12704861

November 20, 2011 By 1 Comment

…be a very serious problem that is fixed in MySQL 5.1.60. I’ll repeat here the …crash recovery will itself crash. The last sentence (“there is no redo log record for file extension in the …were to go looking for bugs, we could certainly find more around various operations and growing tablespace files. …

Filed Under: MySQL

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…,000 directory records with name, address, and the like. We are using MySQL 5.5.30 and MySQL 5….’OH!!” Why is MyISAM able to locate this record but InnoDB cannot find it at all? I suspect that … MyISAM FTS, the results may surprise you. That last point bears particular emphasis, as it also illustrates…

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

Post: How to recover deleted rows from an InnoDB Tablespace

February 20, 2012 By 4 Comments

… that can help us to find the different indexes and types. mysql (information_schema) > select i.INDEX… our hands the last step is to import it in our database: mysql (employees) > LOAD DATA INFILE…rows affected (0.01 sec) Records: 3 Deleted: 0 Skipped: 0 Warnings: 0 mysql (employees) > select * from …

Filed Under: Insight for DBAs, MySQL

Post: MySQL Slow query log in the table

May 31, 2007 By 1 Comment

…MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file … typical operations like finding how many queries were accumulated in the logs or finding 10 last queries is not …. This is actually where being able to sort records by physical position quickly without need to have…

Filed Under: Insight for DBAs Tagged With:

Post: Site was down today, support and web hosting.

August 31, 2007 By 27 Comments

During last one and a half year we had pretty good track record with MySQL Performance Blog – there were times when site was… when I got it) the server had very good track record with basically zero failures during this time – there were some… so clueless which is good. Though now they can’t find any record of a call I made 3 hours ago. Anyway…

Filed Under: Events and Announcements Tagged With:

Post: High-Performance Click Analysis with MySQL

December 22, 2008 By 13 Comments

… three (Google, Yahoo, MSN) provides real-time reporting last time I was involved with them (and I …have the clicks column record the total, and the blue_clicks column record only blue clicks; to find out non-…that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, …

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

Post: How does MySQL Replication really work?

January 9, 2013 By 9 Comments

…t even find it. So, I decided to write one now. Of course, there are many aspects of MySQL replication,…Row based – in this case these are changes to records, sort of row diffs if you will But … the following in “show slave status\G”: Master_Log_File – last file copied from the master (most of the …

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

Post: Full Text Search Webinar Questions Followup

August 24, 2012 By 5 Comments

… and you’ll be emailed a link to the recording. During my webinar, a number of attendees asked …new data to the MySQL database or else periodically batch-insert data that has changed since last time you …have to be coded to search both indexes to find all matches among the most current data.  You …

Filed Under: Events and Announcements, Insight for Developers, MySQL

Post: Using LVM for MySQL Backup and Replication Setup

August 21, 2006 By 53 Comments

…original file system Why snapshot based MySQL backups are great ? There are number … but before that you should probably record binary log position which is done…might want to keep some of last binary logs just in case, …instead of SHOW MASTER STATUS to find out appropriate binary log position. Be …

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

Post: Recovery after DROP & CREATE

August 22, 2012 By 1 Comment

… KEY (`actor_id`), KEY `idx_actor_last_name` (`last_name`) ) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET…records into the same position in the pages. So, table_id and index_id of the dropped table gets overwritten. mysql…table. Sometime it’s not possible to find the index_id. Either because too …

Filed Under: MySQL Tagged With: , ,
« Older Posts
Newer Posts »