… uses dynamic SQL in stored procedures extensively. They found that it was awkward because of the limits of the procedure language MySQL offers, and also… data string, followed by invalid SQL syntax: http://example.com/page.php?param=string’ TEST TEST TEST Hopefully, you have written…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
…in other good discussion points about when selecting Sphinx would still be useful. Tracking Page…. Internals of new InnoDB features in MySQL 5.6 - (Vadim Tkachenko, Percona) – …in 5.6! Perl Stored Procedures for MariaDB - (Antony Curtis, LinkedIn Corp) – I generally don’t recommend stored procedures…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…it is a lot larger problems with MySQL 5.5 with addition of user variables, stored procedures, prepared statements etc which can be…132183490560; in additional pool allocated 0 Internal hash tables (constant factor + variable factor) Adaptive hash index 4422068288 (2039977928 + 2382090360) Page hash …
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
… would be problem I should have started with full page caching rather than MySQL level caching but it is other story. Lets… or stored procedure calls are not, even if stored procedure would simply preform select to retrieve data from table. Avoid comment (and space) in the…_limit was implemented which limits result set which can be stored in query cache. If you need larger queries to be cached…
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
…). Based on MySQL 5.1.66, including all the bug fixes in it, Percona …in the 5.1.66-14.2 milestone at Launchpad. New Features: Multiple bitmap file support for XtraDB changed page… statements in stored procedures correctly, this caused Query_time to increase for every query stored procedure logged …
Comment: A micro-benchmark of stored routines in MySQL
August 16, 2009 By 7 Comments
… I found that writing stuff in PHP was about ten times faster. If you add in that MySQL stored procedures don’t have a debugger, it’s a tough sell to write pages and pages of business logic in them.
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… a huge job; it will take many pages, and I’m not going to write…Created_disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value … or apps that have a lot of stored procedures, which are more difficult to analyze …
Post: PROCEDURE ANALYSE
March 23, 2009 By 9 Comments
… in the table but I’ve omitted everything by few rows. mysql> select * from node procedure analyse…blog’,'contact’,'customer’,'image’,'lab_project’,'news’,’page‘,’percona_faq’,'presentation’,'press_release’,'project… helpful in more cases than ENUM data type – maximum length of data actually stored …
Comment: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
August 29, 2007 By 57 Comments
…. But in “EXPLAIN SELECT SQL_CALC_FOUND_ROWS * FROM count_test WHERE b = 999 ORDER BY c LIMIT 5;”, mysql uses index… SQL_CALC_FOUND_ROWS in queries that use complex where (for example search queries with many parameters and paging result set) is much faster than sending two queries. I use a stored procedure that accept a dynamic…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
…in MySQL Development is what is is quickly leaving this Commodity Space in terms of overall feature complexity. MySQL…) with support of partitioning stored procedures views and a lot of…page book which would cover pretty much all of MySQL features in version 4.0 becomes a book shelf for new MySQL…
