… Oracle world, with my first exposure to the MySQL query cache, I had assumed it was caching query execution plans. In Oracle there’s a… find that MySQL was caching query result sets. Isn’t that what the InnoDB buffer cache was for? Perhaps it is because the query cache was… only simulated in PHP & Perl libraries, and that actually the execute and fetch phases happen together in MySQL. I guess that also…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 9630066 | | Bytes_received | …queries in it. Then I run the following: wget http://hackmysql.com/scripts/mysqlsla perl…queries, in total execution time. By the way, the slow query logs in the stock MySQL…
Post: Percona Server 5.1.47-rel11.0
June 21, 2010 By 13 Comments
… –use_global_long_query_time. Added the –query_cache_strip_comments option to strip comments from query before using it in query cache. Added a global… deleted during the recovery #570840 deb package conflicts with libdbd-mysql-perl The binary packages are available on our website. Starting from…
Comment: MySQL Prepared Statements
September 3, 2008 By 19 Comments
…updates . The prepare/execute file looked like: reset query cache; prepare upd from “update company set data_source_…prepare/execute file would run faster, since supposedly mysql had already done a hard parse on the… tries. Also, I tried one version using Perl DBI and its prepare and execute commands …
Comment: MySQL Prepared Statements
August 4, 2006 By 19 Comments
… statements (prepared in perl dbi/dbd, no server prepares) on my site (http://www.tbg.nu) and the query cache efficiency is at… queries. But I dont know if that has to do with perl dbi/dbd or mysql server. The issues occurs when using $dbh->{‘mysql…
Post: Should MySQL and Web Server share the same box ?
October 16, 2006 By 9 Comments
…,perl,python) per box (which is probably bad idea anyway). The good use for such extra memory is probably caching – Web page caching… or cacheing type of caching (depending on your application needs) is very good idea. One more benefit of local access to MySQL is… page generated by 1000+ queries, which is bad idea already. One case I should mention when shared MySQL and Web server makes…
Post: The tool I've been waiting for years
March 18, 2008 By 10 Comments
…cached by OS cache only so you do not have any good information from MySQL side on what data is cached…pages are cached. For example every second page cached may be helpful for point queries but does…not aligned. [root@DB01 mysql]# du -h ibdata* 246G ibdata1 [root@DB01 mysql]# perl /tmp/fincore –…
Comment: MySQL wins C'T Database Contest
August 30, 2006 By 27 Comments
… of time into this aswell as having different solutions regarding caching etc. Would be more interesting if the code/solution from… that in the perl api to communicate with mysql (DBI/DBD::mysql) there is not only one way to fire a query but a… just a single column from a mysql table through perl. On the other hand its fun with mysql at top but in this…
Post: Living with backups
November 6, 2008 By 28 Comments
…. Since the hit ratio becomes worse as the cache is being filled with random information additional I… from MySQL data directory will result in a total disaster after MySQL stops responding to the incoming queries quick …simply pause the copying. I did a simple Perl script to do just that. It works by…
Post: mk-query-digest, query comments and the query cache
…-attributes option takes two parts. The first part is a Perl regular expression which identifies which comment will be treated as… this test. You can enable query cache stripping in Percona Server at runtime: mysql> set global query_cache_strip_comments=’ON’; Query OK, 0 rows affected…