June 19, 2013

Post: Percona Server 5.5.10 (Release Candidate)

…slow_query_log_timestamp_always. (Oleg Tsarev) Old system variable slow_query_log_microseconds_timestamp was renamed to slow_query_log_timestamp_precision. (Oleg… MySQL 5.0 or Percona Server versions prior to 5.1.7 could crash the server. (Yasufumi Kinoshita) MySQL bugs 56433 and 51325 – These MySQL

Post: Percona Server 5.1.47-rel11.0

… Percona Server is now based on MySQL 5.1.47, and XtraDB is now based on InnoDB plugin 1.0.8. XtraDB now uses… 1592. Added the –microseconds_in_slow_query_log option to use microsecond precision for the slow query log’s timestamps (issue #358412). Added… are based on 5.1.x versions Together “Percona-Server-server-51″ is the package name. 5.1.47 is the MySQL version the package…

Post: Announcing Percona Server for MySQL version 5.1.67-14.4

… Server for MySQL version 5.1.67-14.4[/caption] Percona is glad to announce the release of Percona Server for MySQL version 5.1.67… log was displayed incorrectly when slow_query_log_microseconds_timestamp variable was set to microseconds. Bug fixed #887928 (Laurynas Biveinis). Upstream bug #67983…

Post: MariaDB 5.3 is released as GA!

… commit fix, and MySQL 5.6 offers microsecond timestamp support, as well as a lot of optimizer improvements. Even the standard MySQL 5.5 offers pluggable authentication…. MariaDB 5.3 isn’t the only exciting thing, however. MariaDB 5.3 is based on MySQL 5.1, but MariaDB 5.5 will be based on MySQL 5.5

Post: Percona Server 5.1.53-12.4

…. Functionality Added or Changed  Percona Server 5.1.53-12.4 is based on MySQL 5.1.53.  New Features Added: Precompiled UDFs… crash or undefined behavior: log_slow_timestamp_every, log_slow_sp_statements, slow_query_log_microseconds_timestamp, use_global_long_query_time. (Oleg…

Post: Analyzing Slow Query Table in MySQL 5.6

…we saw the GA release of MySQL 5.6, and I wanted to…-point numerics to microsecond scale: sql/log.cc, MYSQL_QUERY_LOG::write(): 1945… that executes in less than 1.0 seconds counts as 0 seconds… Rows_examined: ‘, rows_examined, CHAR(10), ‘SET timestamp=’, UNIX_TIMESTAMP(start_time), ‘;’, CHAR(10), IF…

Post: The new cool MySQL patch has landed! Check your queries performance!

… Now long_query_time is in microseconds and you can set it ….067538 # InnoDB_pages_distinct: 20 SET timestamp=1193841780; SELECT DISTINCT c from … statistics available for this query SELECT COUNT(1) FROM t2; Important note: Although …system! The patch is available for MySQL Community 5.0.45 on Linux. …