… about bugs like this which provide a trivial way to crash MySQL to the user with basic privileges and asking me what… 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…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… down and restart the slave gracefully, rather than simulating a crash with kill -9, and see what happens. $ ./node1/stop $ ./node1… whole transaction is inside a stored procedure? Whether this works or not depends, again, on how the stored procedure call is logged to the…) What you see depends on your version of MySQL, because the logging of stored procedures has changed over time. If just the CALL…
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 …Bug fixed #917942 (Mark Callaghan, Laurynas Biveinis). Crash-resistant replication would break with binlog XA… in stored procedures correctly, this caused Query_time to increase for every query stored procedure logged …
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…consumes too much memory it may be crashing , failing to execute queries or make … Here is why: List of rarely considered MySQL Server Memory Requirements Thread buffers can …this step, especially specially crafted ones. Stored Procedures. Compex stored procedures may require a lot of memory Prepared…
Comment: Can MySQL temporary tables be made safe for statement-based replication?
May 27, 2008 By 8 Comments
… were looking directly at the binlogs and I was actually crash-testing my slaves. So I took a look at my… that I am using a stored procedure and that I have my code surrounded by START TRANSACTION; COMMIT; mysql> SHOW binlog events IN… drop table statement isn’t rolled back in a crash – because a crash would drop the tmp table anyway. Then I decided…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…InnoDB table was corrupt and mysql shuts down Your server or RAID controller crashes and all data …schema’s. It does not handle views/triggers/procedures etc. Run with –no-schemas, instead use … feature and allows you to cost effectively store long term backups with little additional work Tips/…
