I am considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program… user to lock records for edit/update, so the transaction is not interrupted until the transaction is finished/committed? A example of…
Post: Introducing Zend DBi as a MySQL Replacement on IBM i
May 8, 2012 By Leave a Comment
… remain compatible with MySQL in the future, so it is a no-lock-in solution. If you want to leave the IBM i… our own Percona Server variant of the MySQL server. We have a history of improving the MySQL server and finding and solving bugs in it — we’ve even found and solved bugs on the IBM i…
Post: Webinar: MySQL and SSD
May 8, 2012 By Leave a Comment
Just as a reminder – tomorrow, May-9, 2012, at 11am PDT I will be giving a free webinar “MySQL and SSD”. This is the same talk I gave on Percona Live MySQL Conference, so if you were there – you probably will find nothing new. Otherwise, you are welcome to join!
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… the very frequent cases with performance problems with MySQL is what they happen every so often or certain times. Investigating them we find out what the cause is…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
… lock. No, that would cause blocking that would defeat the purpose of the tool. Q: When you say bail out, what does… or relevant args, the replication breaks reliably on the __tmp_x table why ? The first question sounds like a potential MySQL bug. Are you… bug to be happening. In reply to the second question, the 2.1 version of the tool does NOT have any features to…
Post: Percona Server 5.5.23-25.3 released!
May 16, 2012 By 2 Comments
… are available here and from the Percona Software Repositories). Based on MySQL 5.5.23, including all the bug fixes in it, Percona Server 5.5.23-25.3 is now the current… is open-source and free, all the details of the release can be found in the 5.5.23-25.3 milestone at…
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
… and improvements. List of changes: Fixes merged from upstream (Codership-mysql) Support for MyISAM, now changes to MyISAM tables are replicated…_sst_method=skip, useful when you start all nodes from the same sources (i.e. backup) Ability to pass list of IP addresses for a new node, it will connect to the first available Binaries are available from downloads area or from…
Post: Zero-downtime schema changes webinar recording
May 8, 2012 By Leave a Comment
The recording and slides for my webinar on zero-downtime schema changes with MySQL are available now. Don’t miss Vadim’s webinar tomorrow!
Comment: InnoDB's gap locks
May 7, 2012 By 14 Comments
… 1207 sec, process no 2909, OS thread id 1100101952 inserting mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1216, 1 row lock(s) MySQL thread id 31929, query id 484616 localhost root update insert… PHYSICAL RECORD: n_fields 1; compact format; info bits 0 0: len 8; hex 73757072656d756d; asc supremum;; —————— The lock_mode is “X…
Comment: Moving Subtrees in Closure Table Hierarchies
May 2, 2012 By 7 Comments
… with indentation (for each level) with the datas. I know the level of each branch (with the length column) but they are different for each and can be more or less in the future. How can reordered the receive… html. With the tree traversal, it is easy to do so because you’re “walking the path”. I’m using MySQL, PHP or…
