…MySQL ….commanual datetime_formatblogpercona….Performance_schema_mutex_classes_lostblogpercona.commanual Performance_schema_mutex_instances_lostblogpercona.commanual Performance_schema_rwlock_classes_lostblogpercona.commanual Performance_schema_rwlock_instances_lostblogpercona.commanual Performance…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…the difference in response time. Refresh method performance comparison For demonstration purposes, I did … | <-- too high +------------------+ 1 row in set (0.68 sec) mysql> select sum(total_lines) from dashboard_customer_sales ;… with flexviews.get_uow_id_from_datetime() function. If you pass a NULL …
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
…’s come to the MySQL configuration. MySQL Configuration I used Percona Server…` int(11) NOT NULL AUTO_INCREMENT, `dateandtime` datetime DEFAULT NULL, `cashregisterid` int(11) NOT …performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… MariaDB as a first-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions MariaDB in many places…’re different) offer flexibility in schemas Microsecond time resolution for DATETIME and similar time-based types, as well as microseconds in…
Comment: Slow Query Log analyzes tools
June 10, 2008 By 84 Comments
…of mysql, with this patch applied (we compile mysql from source ourselves anyway, so this is still a fair performance test… the next push @{$queries{$connection}{$datetime}}, $query if length($query); $connection = $1; $starttime{$connection} = $datetime if (($datetime $_) { sleep $now – $_; } # Now …
Comment: Beware of MyISAM Key Cache mutex contention
August 14, 2008 By 10 Comments
…multiple MyISAM tables are included, the performance is worse than only one MyISAM … my_number | varchar(255) start_time | datetime end_time | datetime The index for the table …OK | +———————————+———-+———-+ 4 rows in set (0.02 sec) mysql> LOAD INDEX INTO CACHE lps.user…
Comment: Real-Life Use Case for "Barracuda" InnoDB File Format
April 24, 2008 By 11 Comments
… has been performed by simple ALTER TABLE. Some table-related … NULL, `html` mediumtext, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `query_count` int(…_id` (`word_document_id`) ) ENGINE=InnoDB mysql> show table status like ‘document_queries’\G *************************** …
Comment: How to find wrong indexing with glance view
March 8, 2010 By 27 Comments
…much in 2010. MySQL surprisingly supports declarative integrity constraints. But wait being MySQL there must …an extraordinarily inefficient plan resulting in horrendous performance by using one of these foreign key… decimal(10, 4) not null, order_date datetime not null, last_updated timestamp not …
Post: Back from OpenSource Database Conference
November 9, 2006 By 1 Comment
… for some other reason. There were number of talks about MySQL by Arjen Lentz, Me and Giuseppe Maxia . There also were… about PHP6 localization and DateTime handling in PHP 5.2+ I wish there would be some hard core performance optimization sessions for PHP applications which did not exist. Attending Arjens session about typical MySQL/PHP Mistakes I…
