June 18, 2013

Post: MariaDB 5.3 is released as GA!

… that our support contracts cover MariaDB as a first-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition… fix, and MySQL 5.6 offers microsecond timestamp support, as well as a lot of optimizer improvements. Even the standard MySQL 5.5 offers…

Post: MySQL 5.6: Improvements in the Nutshell

…created the outline of improvements available in MySQL 5.6 which I thought was …open – Support for multiple table_open_cache instances – Large (over 4GB) redo logs support Optimizer and …queries – Full Text Search index for Innodb – Microsecond TIME precision – Precise spatial operations in GIS …

Post: Percona Server 5.5.10 (Release Candidate)

… innodb_enable_unsafe_group_commit was deleted. The existing MySQL variable innodb_support_xa can be used instead. (Yasufumi Kinoshita) Old system…_timestamp_always. (Oleg Tsarev) Old system variable slow_query_log_microseconds_timestamp was renamed to slow_query_log_timestamp_precision. (Oleg…

Post: Figuring out what limits MySQL Replication

… quite soon, so I decided to check what is limiting MySQL Replication speed. My first idea was to check it based… query log, happily the server was running MySQL with slow query log with microsecond resolution so I could check exactly which update… kinds of MySQL Logs. Too bad MySQL Binary log is the only one which it does not support natively. Happily it supports “raw” query…

Post: New MySQL Community Release Policies published

… our patches for microsecond resolution of slow queries over half a year ago. These patches had a good support from MySQL Professional Services Team and Monty himself but still the process just stalled. It really looks like MySQL took…

Post: MySQL Releases first real Community Release

… into community version. The great question however why MySQL did not announce the split just now when …stuff if there were no real engineering done to support it. The questions which I’m pretty curious … fact we have submitted our slow query log with microseconds patch so we’ll see how quickly and …

Post: Introducing tcprstat, a TCP response time tool

… For many simple protocols such as HTTP and MySQL, this is the moral equivalent of a …max, and standard deviation of the response times, in microseconds. These are repeated for the 95th and 99th…to downloads are on the Percona wiki. Commercial support and services are provided by Percona. Bug reports,…

Post: How much overhead DRDB could cause ?

…and configuration) more synchronous IO operations – MySQL binary logs are not preallocated…microseconds. With such case even considering extra overhead besides network IO we’re speaking about 300 microseconds vs 5000 microseconds… see DRBD to have direct support for Infiniband or Dolphin interconnect …

Post: Updated msl (microslow) patch, installation walk-through!

… to have in your slow log. For example to have microsecond query timing and InnoDB statistics you would need to set… disable it. “innodb” is only available with the patch supporting that feature. Can be changed at run time with both… taken more than long_query_time microseconds to execute to file. This option is standard MySQL, however after you apply the patch…

Post: How Percona Develops Open-Source Software

… the sake of full disclosure. How We Support Our Work This work is usually supported by our customers. (It happens, but not… stand behind the builds and we support them. The builds power some of the most demanding MySQL installations in the world. All… there were a built-in type in MySQL that could store date and time with microsecond precision? Lots of people have asked…