… by allowing users to extend the server’s functionality with their own code, and this is what …be set to control what is logged by the plugin: – audit_record_cmds : This is the list of commands …I think proper audit trail support has been an important missing feature on the server, which has made …
Post: Using flow control functions for performance monitoring queries
May 24, 2008 By 12 Comments
… big fan on flow control functions like IF or CASE used in MySQL Queries …generation log for some site and reports number of requests, average request time as well as …important to do such grouping by user functions because otherwise you will not catch important but may be less used functions…
Post: MySQL Error control changes
February 19, 2007 By 4 Comments
… control was improved, such as strict mode was added to change famous MySQL behavior of…you might not notice part of your application does not function. Also monitoring often monitors …”Plugable Storage Engine” concept the importance of storage engines is decreased – if one of these storage engine can…
Post: Finding your MySQL High-Availability solution - The definitions
October 9, 2009 By 10 Comments
…function of the level of availability and has to be compared with the downtime cost. If an HA setup with a level of availability of…importance of the application. Single point of failure (SPOF) Single points of…
Post: Living with backups
November 6, 2008 By 28 Comments
…by my last sentence, but it is not important right now. Either way the data is out… not get flushed. MySQL obviously takes advantage of this functionality just as any other application and this is…some tricks, but it’s mostly beyond your control. Otherwise, when copying physical data files, in order…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…controls the minimum amount of time it takes to refresh the view, and therefore the minimum amount of…of the SQL features available to SELECT statements. Refresh type Aggregation Outer join All SQL functions…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… relevance must have some effect on the speed of the query. I didn’t control for these variations, but that would be… FT functionality. So one solution may include advanced features that are must-have for your application, but are not so important for another application. I tried to test only the functionality all these solutions had in common…
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
…control was renamed to slow_query_log_use_global_control….updated version of the original implementation of the Remove Excessive Function Calls feature, which removes some fcntl calls to improve performance. (Oleg Tsarev) Bug #727704 – When using the Expand Table Import feature, importing…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…. For goal driven performance optimization it is important there is enough instrumentation and production performance …not profile or waits we do not have control of, for example when processing had to wait … it carefully or you can add tracing functionality to the application. All the same. Once …
Post: Adventures in archiving
February 11, 2013 By 16 Comments
…function leveraging zlib to provide compression of data. MySQL’s Archive storage engine. Tooling The tooling phase consisted of… compression) non_compressed_data (Our test control) Now we needed to generate the ‘payload… and a subsequent 63 minutes for import. Results Size on disk Engine Compression …
