… clauses with columns that had single-column indexes on them, MySQL could sometimes make use of the multiple indexes. For instance… different, and there isn’t likely to be a one-size-fits-all silver bullet solution. For example, one option would… I recommend against using index hints for one very simple reason: stuff happens. Just a few possibilities: A new version of MySQL…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… until you get a crash, meaning if your production database size growths load changes or you happen to have failure during…. So when I would recommend to use DRBD with MySQL ? There some good reasons to use DRBD with MySQL though as I mentioned… transaction loss and automated fail over. Whenever you’re using MySQL Cluster, DRBD or MySQL Replication you have to have some compromises.
Post: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
Yesterday I’ve attended MySQL Customers Conference in London. This event is much smaller size than Users Conference (one day and about 170 people attending) and surely less geeky – there were no one from MySQL… default transactional storage engine in MySQL 6.0 – I did not truly understand if it will be recommended transactional storage engine or…
Post: Watch out for Marketing benchmarks
August 23, 2006 By 7 Comments
… times faster. This however came at cost of larger code size and more complex code which had slowed down some things… openness is best practice. During my work for MySQL I recommended not to use MySQL for certain applications (ie when queries and schema… interesting enough many of these customers stayed with MySQL for other applications or checked MySQL when new version was released. In general…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
… sync the metadata of the file also (size, name, access time, etc.), but for the…insert_zip_clean). Bugs Fixed: #802825 / #61341 in MySQL (Yasufumi Kinoshita). Compatibility Collations Two new collations, … invasive and not widely used. Instead, we recommend using the much safer LRU Dump/Restore patch…
Post: Percona XtraDB Cluster Feature 1: High Availability
January 17, 2012 By 20 Comments
… XtraDB Cluster. 1. The Cluster consists of Nodes. Recommended configuration is to have at least 3 nodes,… point is that you can convert your existing MySQL / Percona Server into Node and roll Cluster using… Each node contains a cache, ring-buffer, (the size is configurable) of last N changes, and the…
Post: InnoDB/XtraDB Training in New York City!
September 25, 2009 By 2 Comments
… went great – 100% of survey respondents said they would recommend the same course to a friend. I’m…time will be around 5 PM. With the class size going down, we have a little freedom to tweak…our early bird special (a copy of High Performance MySQL 2nd Ed). Interested in signing up? Registration…
Post: devops webinar - follow up Q&A
November 6, 2012 By 5 Comments
… are important but also the amount of record and the size of tables must be equivalent. A full table scan could… becomes problematic. Q: for version control of schemas, do you recommend full schema definition, full definitions with change deltas, or deltas…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
….com/supportingmysql/entry/server_defaults_changes_in_mysql , in documentation now at http://dev.mysql.com/doc/refman/5.6/en/server… at https://blogs.oracle.com/supportingmysql/entry/mysql_server_5_6_default . thread_cache_size is quite low, and dynamic based on… are good and I recommend them after reading about how they work. I’m currently preparing our recommendations for a baseline setup…
Post: Long PRIMARY KEY for Innodb tables
October 3, 2006 By 8 Comments
… but meta data such as original image sizes, file size as well as thumbnail location on … checking/repairing large MyISAM tables in case of MySQL/System crash is painful and great to be… in your case rather than accepting general recommendations without giving much thought on which assumptions …
