…a MySQL stored procedure API, called the SQL_API which is used to define the view. These stored procedures maintain…always use the stored procedures to modify the dictionary. Do not modify it directly. convert.php You are…’ section. I’ll discuss others in future blog posts. Enable the view to use it…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
…some of the misconceptions that many other blogs and articles have about this security risk. …code that is mature and thoroughly tested. PHP‘s PDO library does something similar, …stored procedures extensively. They found that it was awkward because of the limits of the procedure language MySQL …
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…is time for you to get your own blog). I should have replied much earlier but … (plugable indexes etc), Apache, PHP or Linux Kernel. Yes in MySQL 5.1 the situation is changes …not get major regressions. I’m saying about Stored Procedures which were released without proper development and debugging…
Post: Percona Welcomes Justin Swanhart
May 26, 2010 By 2 Comments
… as a MySQL DBA at Gazillion, Yahoo, and Kickfire. Justin has become a regular contributor here on the MySQL Performance Blog as well… stored procedure managed solution for materialized view creation and maintenance in MySQL 5.1 as well as instrumentation-for-php, a suite of PHP classes…
