… client. So in MySQL 4.1 Prepared statement came. Do not mix these native Server Side Prepared Statements with emulated prepared statements which JDBC… sometimes buggy code. I had a lot of problems with PHP prepared statements. It is getting better but still it is less… ahead for MySQL Prepared statements – many of the problems such as extra round trip, non working query cache or non working prepared statements…
Post: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
If you’re following MySQL or PHP landscape you should have seen announcement by MySQL to develop pure PHP driver. If not – Here is… queries and warn if these is something obviously wrong. Emulated Prepared Statements I would like to have easy time to switch… to take care of emulating these for me. Arrays in Prepared Statements Dealing with certain types of queries, ie queries with…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
….000009 | | init | 0.000014 | | optimizing | 0.000002 | | statistics | 0.000005 | | preparing | 0.000006 | | executing | 0.000001 | | Sorting result | 0.000002 | | Sending… as such I have reported a bug: http://bugs.mysql.com/bug.php?id=67647 Metadata locking behaves differently for queries that…
Post: Upcoming webinar on Data Recovery for MySQL
April 6, 2011 By 5 Comments
…on 26th of April on data recovery for MySQL. Almost every long serving DBA has been … What you can learn by attending: * Prepare for recovery (prerequisites) * Preparing your data * Identifying the structure and state…://percona-events.webex.com/percona-events/onstage/g.php?t=a&d=669733263 Regards…
Post: Upcoming Webinar on HA solutions for MySQL
January 7, 2011 By 1 Comment
… new, we keep receiving many questions regarding HA and MySQL so we thought it would be a good idea … will be a revised version of the presentation I prepared for the UC 2010 (talk actually was given by …: https://percona-events.webex.com/percona-events/onstage/g.php?t=a&d=665815392 Regards, Yves
Post: Handling big result sets
June 26, 2006 By 13 Comments
… improved. How? Let’s look mysql_query function: http://www.php.net/manual/en/function.mysql-query.php. Unfortunately there is nothing interesting for… you have query which retrieves a lot of data from MySQL prepared statements may also perform better, probably because of binary protocol…
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
… and thoroughly tested. PHP‘s PDO library does something similar, interpolating parameter values into a query string before prepare. But I’m… using PHP: $placeholders = join(“,”, array_fill(0, count($params), “?”)); $sql = “SELECT * FROM Bugs WHERE bug_id IN ($placeholders)”; $stmt = $pdo->prepare($sql… load onto their database server. Their MySQL server became CPU-bound, while their multiple PHP application servers were often idle, waiting for…
Post: Alternatives of PHP ?
September 9, 2006 By 28 Comments
… of XMLs into mysql database with PHP script, I was thinking about PHP alternatives. Why do I need that ? 1. PHP is slow – I… mind. List of my requirements: – Stable binding to MySQL, support of new protocol with prepared statement is necessary. – good XML handling – Fast… Perl, Ruby, Java, C, C++, even Python supports only old mysql protocol (am I wrong here?). Excluding Java (see my requirements…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
We’re working with web site preparing for massive growth. To make sure it handles large data … memory_limit PHP config variable because that only controls memory which passes via PHP memory management which does not apply to MySQL result… can’t use mysql_num_rows() and mysql_data_seek() if you use this method but this is told in PHP manual and…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… such as PostgreSQL (plugable indexes etc), Apache, PHP or Linux Kernel. Yes in MySQL 5.1 the situation is changes – now there… about Prepared Statements in MySQL 4.1 which came without query cache support but even worse not all of statements could be prepared… time. For example Query Cache support for Prepared Statements is only fixed in MySQL 5.1 and Most of other items are…
