…quickly by MySQL. The moment you give someone access to MySQL Server, all MySQL Security…by opening transaction and doing a lot of updates, or simply keeping transaction open…. Stored Procedures – How much memory can stored procedure allocate ? say can you create 1000 variables in stored procedure and…
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 …binary log transaction cache, when committing or rolling back a statement or a transaction. Bug fixed …individual statements in stored procedures correctly, this caused Query_time to increase for every query stored procedure logged …
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… if the whole transaction is inside a stored procedure? Whether this works or not depends, again, on how the stored procedure call is logged to the binary log. Let’s create a stored procedure to hold the transaction, which this time… */ 7 rows in set (0.00 sec) What you see depends on your version of MySQL, because the logging of stored procedures has changed…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…algorithm computes changes in multiple transactions. After each transaction it must wait for FlexCDC to process changes from that transaction. In practice, this… includes a MySQL stored procedure API, called the SQL_API which is used to define the view. These stored procedures maintain the Flexviews…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…is quite helpful for MySQL Performance optimization …stored procedure calls are not, even if stored procedure would simply preform select to retrieve data from table. Avoid comment (and space) in…in chunks so it is even harder to implement. Might not work with transactions – Different transactions…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… should they estimate memory consumption by MySQL Server in given configuration. What is the …default thread stack, net buffer etc. If transaction is started some more space can add…this step, especially specially crafted ones. Stored Procedures. Compex stored procedures may require a lot of memory …
Post: Stored Function to generate Sequences
April 2, 2008 By 17 Comments
…their sequence generation process to the stored procedure and even though I have …in transactions without serializing transactions which require access to same sequence, though it is not as safe as if you use Innodb table in…sequential value as in the case above can be quite helpful – in MySQL 5….
Post: MySQL Workshops: Chicago & London this April
March 15, 2013 By Leave a Comment
… stored procedures, triggers and events. Operating and Troubleshooting for MySQL on Wednesday & Thursday, April 10 & 11 This MySQL workshop will cover: Understand MySQL … stored on disk and in memory. Understand what InnoDB does internally when data is written, and how features like the transaction …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… hosted application for data mining stock market transactions,” or whatever the case may be we’…s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition…applications, or apps that have a lot of stored procedures, which are more difficult to analyze because …
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…Store your backups on more than one server. In addition to local copies, store…transactional tables are used Almost no locking, if not using myisam tables Built in…does not handle views/triggers/procedures etc. Run with –no-…MySQL in parallel using all your resources available Downloading from s3 in…
