… exist in the perl api for mysql (dbi/dbd) and can be used as: $dbh->{‘mysql_use_result‘}=0; #disable $dbh->{‘mysql_use_result‘}=1; #enable and since mysql 4.1 server based prepares can be used…
Comment: MySQL wins C'T Database Contest
August 30, 2006 By 27 Comments
… (for example if the 3364 opm mysql result was using memcached, how would the 120 opm postgre result be affected of such caching?) – THEN… opm while mysql gets 3664 (even thou there are mysql results as low as 137 opm in this benchmark). I can just use a… different algorithm. An example is that in the perl api to communicate with mysql (DBI/DBD::mysql) there is not only one way to…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… manual way.) The result looks like this: +———————————–+———————-+———————-+ | Variable_name | Value | Value…, such as Class::DBI, which does $dbh->….com/scripts/mysqlsla perl mysqlsla -lt slow /…possible to use a patched binary, we can use MySQL Proxy…
Comment: MySQL Prepared Statements
September 3, 2008 By 21 Comments
… … execute upd using @id . I had thought the prepare/execute file would run faster, since supposedly mysql had …over several tries. Also, I tried one version using Perl DBI and its prepare and execute commands and it…even though it wasn’t being used. So, I’m convinced the results are real. Why did …
Post: Living with backups
November 6, 2008 By 28 Comments
…simple copy operation from MySQL data directory will result in a total disaster after MySQL stops responding to the…simply pause the copying. I did a simple Perl script to do just that. It works …the application that copies the data: use POSIX “:sys_wait_h”; use DBI; $pid= fork(); if ($pid == 0) { …
