… would still be useful. Tracking Page Changes for Your Database and Bitmap Backups… strategies might look like. Using MySQL Performance Schema to debug performance issues - (Zburivsky … Perl Stored Procedures for MariaDB - (Antony Curtis, LinkedIn Corp) – I generally don’t recommend stored procedures…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
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 a memory hog. My intent with this post is dual. I would encourage MySQL Team… size, bytes 128849002496 Free buffers 1 Database pages 8252672 Old database pages 3046376 Modified db pages 23419 I’m using the information from…
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
… 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: MySQL Query Cache
July 27, 2006 By 70 Comments
… great feature called “Query Cache” which is quite helpful for MySQL Performance optimization tasks but there are number of things you… would be problem I should have started with full page caching rather than MySQL level caching but it is other story. Lets… SELECT queries are cached SHOW commands or stored procedure calls are not, even if stored procedure would simply preform select to retrieve data from…
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
… the Percona Software Repositories). Based on MySQL 5.1.66, including all the … Multiple bitmap file support for XtraDB changed page tracking has been implemented. HandlerSocket has …statements in stored procedures correctly, this caused Query_time to increase for every query stored procedure logged …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…’s a huge job; it will take many pages, and I’m not going to write that …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…applications, or apps that have a lot of stored procedures, which are more difficult to analyze because you…
Post: PROCEDURE ANALYSE
March 23, 2009 By 9 Comments
…MySQL has a native feature to perform this task – PROCEDURE ANALYSE Here is sample run of PROCEDURE…(‘blog’,'contact’,'customer’,'image’,'lab_project’,'news’,’page‘,’percona_faq’,'presentation’,'press_release’,'project’,'…data type – maximum length of data actually stored often can tell us if we …
Comment: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
August 29, 2007 By 57 Comments
… count_test WHERE b = 999 ORDER BY c LIMIT 5;”, mysql uses index to determine number of rows to examine (through… with many parameters and paging result set) is much faster than sending two queries. I use a stored procedure that accept a dynamic… same thing but one with SQL_CALC_FOUND_ROWS just stores number of records before restricting rows. If I am wrong…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
… with transactions an some with clustering) with support of partitioning stored procedures views and a lot of stuff. Think how much freedom… with MySQL Cluster but have no idea how to write storage engines or optimize for Falcon storage engine. Relatively simple 1000 page book which would cover pretty much all of MySQL features in version 4.0 becomes a book shelf for new MySQL…
Comment: A micro-benchmark of stored routines in MySQL
August 16, 2009 By 7 Comments
… 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…
