…. If different – we are on the slave. The following stored procedure writes ‘master’ or ‘slave’ in the `replication_status` table. It… (whoami VARCHAR(12) NOT NULL); DELIMITER $$ DROP PROCEDURE IF EXISTS `test`.`deduce_whoami` $$ CREATE PROCEDURE `test`.`deduce_whoami` () BEGIN TRUNCATE TABLE uuid…
Comment: MySQL VIEW as performance troublemaker
April 10, 2008 By 57 Comments
…: Try using Stored Procedure, for this example. DELIMITER $$ DROP PROCEDURE IF EXISTS `test2`.`user_count` $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `user_count`(param1…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
March 11, 2007 By 117 Comments
delimiter // CREATE PROCEDURE inserttf(p1 int) BEGIN DECLARE v1 INT DEFAULT 0; WHILE …)); SET v1 = v1 + 1; END WHILE; END // delimiter ; delimiter // CREATE PROCEDURE inserttn(p1 int) BEGIN DECLARE v1 INT DEFAULT 0; WHILE…)); SET v1 = v1 + 1; END WHILE; END // delimiter ; delimiter // CREATE PROCEDURE insertti(p1 int) BEGIN DECLARE v1 INT DEFAULT 0; WHILE…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
… borked sales driven development process. Another example could be stored procedures. They were put in as “tick box requirement” again driven… that entire chunk of code when working on Drizzle. Stored Procedures have their use today, but it’s not difficult to…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
… 5.6! Perl Stored Procedures for MariaDB - (Antony Curtis, LinkedIn Corp) – I generally don’t recommend stored procedures, but I need to…
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
… of individual statements in stored procedures correctly, this caused Query_time to increase for every query stored procedure logged to the slow…
Comment: Avoiding auto-increment holes on InnoDB with INSERT IGNORE
January 6, 2012 By 8 Comments
… to generate my 25M lines. I use a procedure to fill a table : create procedure table_lines (nb int) begin declare runnb…
Post: Intel 320 SSD write performance - contd.
September 28, 2011 By 8 Comments
… help, and only secure erase procedure allows to return to initial state. There are commands for this procedure for reference. hdparm –user…
Comment: MySQL Stored Procedures problems and use practices
September 6, 2010 By 21 Comments
… approach guarantees validity of executed code, as an executed stored procedure/function/trigger does the same operations and gives the same… version. The first approach is more beneficial during debugging stored procedures, functions, and triggers, and other important code.
Comment: MySQL VIEW as performance troublemaker
August 25, 2010 By 57 Comments
… can be a lot more efficient to use a stored procedure to generate a table – effectively a materialized view – rather than… very low in my application, I have instead used stored procedures to drop and recreate the tables with the de-normalized…
