June 20, 2013

Post: Infinite Replication Loop

October 10, 2011 By 2 Comments

… are replicating over and over in a Multi Master Replication relationship. This happens because those …looping statement were first inserted. Another way to see it is by monitoring your MySQL server with cacti…the wrong server-id are performed on the two slaves (mysql 3 and mysql 4) and the new events…

Filed Under: MySQL

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

March 4, 2013 By 7 Comments

… exactly identical to the same query when performed against InnoDB data, OR that the results…mysql: SET GLOBAL innodb_ft_server_stopword_table=’test/innodb_ft_list2′; Query OK, 0 rows affected (0.00 sec) mysql: INSERT… or may not be the case with multi-byte character sets or with ideographic languages…

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

Post: Why Swapping is bad for MySQL Performance ?

January 18, 2010 By 11 Comments

… the swap. This causes swapping and causes performance problems. This much is obvious. But how… designed before SSD era. For example Insert Buffer in MySQL makes a special effort to avoid (delay…lets see what swapping does for concurrent (multi CPU, multi client) processing. Database Locks/Latches are…

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

Post: High-Performance Click Analysis with MySQL

December 22, 2008 By 13 Comments

…, with no delays. Finally, the analysis is usually multi-dimensional.  The typical user wants to be… hard-to-scale database server for the initial insertion, because you can write CSV files with any…star schemas.  The problem is that MySQL doesn’t tend to perform well on a data warehousing workload….

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

Post: On Character Sets and Disappearing Tables

June 21, 2012 By 1 Comment

…that we want to achieve the best performance possible, so we’re going to… TABLE recovery LIKE `#sql2-3c13-14`; INSERT INTO recovery SELECT * FROM `#sql2-3c13-…something of an inconsistency present when MySQL won’t allow us to change… allow us to change from a multi-byte character column to a single-…

Filed Under: Insight for DBAs, MySQL

Post: MySQL and PostgreSQL SpecJAppServer benchmark results

July 25, 2007 By 13 Comments

… be more in terms of performance due to architecture optimizations. The other big issue is using MySQL 5.0.27 which has… where most of MySQL sweet spots come from. MySQL performance gains usually come from MySQL unique features – non transactional MyISAM, Multi Value inserts, Query Cache, Merge…

Filed Under: Benchmarks Tagged With:

Post: Announcing Percona Playback 0.5

November 26, 2012 By

… change can affect the overall performance of your database server. This… in our documentation. Bugs fixed: Multi-line queries in the slow…SELECT but the UPDATE,DELETE and INSERT ones as well. So be…libmysqlclient –mysql-host=10.8.2.10 \ –mysql-username=root –mysql-password=passW0rd –mysql-schema…

Filed Under: MySQL

Post: Test Drive of Solid

September 22, 2006 By 5 Comments

…=latin1 insert into test2 values (1,’Mysql‘),(2,’Solid’),(3,’MyISAM’); mysql> begin; mysql> update test2 set names=’mysql‘ where id=1; Session 2: mysql> begin; mysql… you would expect from multi versining engine – all the meaning of multi versioning is to allow you to perform consistent read even if…

Filed Under: Uncategorized Tagged With: ,

Post: Read/Write Splitting with PHP Webinar Questions Followup

January 23, 2013 By 4 Comments

…be a high performance cost? A: Connecting to a MySQL database isn’t a great performance cost, compared …. Q: What about write splitting (updates,inserts) on multiple MySQL servers? Or is it possible to …. Percona XtraDB Cluster reduces the hazards of multi-writing by keeping all the instances in sync…

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

Post: Detailed review of Tokutek storage engine

April 28, 2009 By 21 Comments

…Beside it TokuDB does not scale well on multi-cores even in only SELECT queries. What …data. – Despite Inserts and Deletes are fast, updates are not expected to show the same performance gain, … can be from simple apache logs put into mysql, application performance logs to more complex log like clicks…

Filed Under: Uncategorized Tagged With:
« Older Posts
Newer Posts »