… Innodb tables and you’re not actively changing users, stored procedures etc (which are stored in MyISAM tables anyway) you can consider using…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… problems with MySQL 5.5 with addition of user variables, stored procedures, prepared statements etc which can be a memory hog. My…
Comment: mysql-proxy, urgh performance and scalability ?
February 27, 2012 By 27 Comments
… Over. – Sharding. – Query Router. In addition it is better support stored-procedure and transparent between Mysql Server and application client. SQL Relay…
Post: MySQL Stored Procedures problems and use practices
June 12, 2007 By 21 Comments
…, instead slow query log will contain full stored procedure calls. On the other hand Stored Procedures Indeed can help to Improve MySQL Performance. For… was about 10% slower than 4.1 without stored procedures but was 20% faster if Stored Procedures are used. And this is of course… to do more work to send it back than Stored Procedure to process it. Stored Procedures also have number of performance gotchas which I…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
…())’ STORED PROCEDURES The behaviour of stored procedures and functions are completely different. If our stored procedure write data to our tables the queries inside the procedure get logged and not the call to the procedure itself…
Post: Profiling MySQL stored routines
January 19, 2009 By 3 Comments
… application based entirely on stored routines on MySQL side. Even though I haven’t worked much with stored procedures, I though it’s… don’t want to go over the complicated logic of stored procedure just to figure out what queries are being executed. This…
Post: Stored Function to generate Sequences
April 2, 2008 By 15 Comments
… help them to convert their sequence generation process to the stored procedure and even though I have already seen it somewhere I… also helpful if you need to decouple ID generation from storing the data – for example IDs are generated on central server and when stored on number of servers or to number of individual tables…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… to run their queries. Stored Procedures – How much memory can stored procedure allocate ? say can you create 1000 variables in stored procedure and set 1M result… with other stored procedure language constructions but I do not think tight memory allocation policy is enforced. Stored Procedures Cursors – Cursors inside of stored procedures are…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… 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… problem either. Interestingly, I also created a version of the stored procedure that doesn’t begin and commit a transaction. After calling…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
… includes a MySQL stored procedure API, called the SQL_API which is used to define the view. These stored procedures maintain the Flexviews data… joins, is the value proposition for Flexviews. The flexviews.refresh() stored procedure The first parameter to flexviews.refresh() is the materialized view…
