I wanted to write a few administrative updates in one so I didn’t spam everyone’s feed …
Post: MySQL Configuration Wizard Updated
January 26, 2012 By 5 Comments
We’ve released an updated version of the MySQL Configuration Wizard we announced at the … tools helps you become a more productive MySQL user and administrator!
Comment: A few administrative updates
August 27, 2009 By 12 Comments
[...] A few administrative updates | MySQL Performance Blog :feed-readers, spam-everyone, [...]
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… database behavior to match my needs. I love this Zero administration thing and I would like database to manage things for… isolation modes is supported, including no support for SELECT FOR UPDATE. This is also why Falcon has Optimistic locking concurrency which… information about is regarding handling fragmentation – what happens on row updates, are they stored in the same position or in another…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 139 Comments
… the following activity: Per day: 1. INSERTS: 1,000 2. UPDATES: 200 3. SELECTS: 1 million Since this is a predominantly…-slow.log sql-mode=TRADITIONAL concurrent_insert=2 low_priority_updates=1 The problem was that at about 3pm GMT the… fraction of INSERTs and UPDATEs)? We explored a bunch of issues including questioning our hardware and our system administrators 
When we switched…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
…. Moreover, I have not seen broken systems, where installing or updating a RPM package would be impossible without resolving tons of… MySQL. By default it not only starts database, but also updates system tables (if needed), scans all tables for consistency problems… resources available online. But if you are a skilled systems administrator or your company hires one, then you could use pretty…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
… replication conflicts All slaves are in read_only mode Simple administrative commands can remove master role from a node Pacemaker stonith… saner behavior. One of the important setting is “log_slave_updates = OFF” (default value). In some cases, if slaves are logging replication updates, it may cause failover issues. Also, the solution relies on…
Comment: Flexviews is a working scalable database transactional memory example
May 19, 2011 By 3 Comments
… commit a transaction UPDATE the trx id field ..UPDATE trx SET trx id trx id 1.From ….Dear MySQL database administrator please drop…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… thus the logic for applying changes via ON DUPLICATE KEY UPDATE is the same. All of the fastest incremental materialized view… even be set up without the aid of your database administrator. As long as all of the nodes share a common…` * storage node result set merge optimization enabled: ON DUPLICATE KEY UPDATE `origin_airport_id`=VALUES(`origin_airport_id`), `count(*)`=`count(*)` + VALUES…
Post: Checking for a live database connection considered harmful
May 5, 2010 By 38 Comments
… ago I saw a Ruby on Rails app where the ‘Administrator command: statistics’ command was taking over 40% of the server… BEGIN # 3 0x6E85B9A9C9FF813E 868.0335 6.0% 6923 0.1254 UPDATE scores # 4 0xA3A0423749EC0E37 851.0152 5.8% 6020 0.1414 UPDATE user_datas # 5 0x813031B8BBC3B329 822.0041 5.6% 23299 0….
