… stored procedure calls. On the other hand Stored Procedures Indeed can help to Improve MySQL Performance. For DBT2 benchmarks we’ve tried a while back MySQL… code versions, one using stored procedures and other doing same thing using direct statements. This allows to debug and profile most of the…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
… what some migration strategies might look like. Using MySQL Performance Schema to debug performance issues - (Zburivsky Danil, Pythian) – I haven’…improvements in 5.6! Perl Stored Procedures for MariaDB - (Antony Curtis, LinkedIn Corp) – I generally don’t recommend stored procedures, but I need …
Comment: MySQL Stored Procedures problems and use practices
August 30, 2009 By 21 Comments
I had very bad experience with mysql stored procedure and triggers. I think mysql should provide a tool for stored procedure programming with debug facility.
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
…does offer advantages particularly if triggers or stored procedures are used, or if non deterministic functions …relay log file: mysql_sandbox25162-relay-bin.000002 at position: 340718. MySQL 5.1 ships … options are “–base64-output” and “-v”. For debugging row based logs, I suggest ‘–base64-output…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…customer may call and ask “how long to debug server lockups?” It could be ten minutes, …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…, or apps that have a lot of stored procedures, which are more difficult to analyze because …
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… get major regressions. I’m saying about Stored Procedures which were released without proper development and debugging support. These are just few examples… inside who can figure things out and even patch MySQL if needed. So MySQL went to chase Enterprise market and develop enterprise…
Comment: MySQL Stored Procedures problems and use practices
September 6, 2010 By 21 Comments
… DBMS_DEBUG in Oracle; it is used in dbForge Studio for MySQL. This approach guarantees validity of executed code, as an executed stored procedure… the peculiarities of executing stored code with each released server version. The first approach is more beneficial during debugging stored procedures, functions, and triggers…
Comment: MySQL Pays attention to Bugs (Finally!)
May 21, 2009 By 5 Comments
… up market for enterprise database adding views, triggers, stored procedures etc which is what MySQL “core” market did not need so much. At… resync them (maatkit or Google patches have solution for these). Debugging and profiling stored procedures is another example.
Comment: MySQL Stored Procedures problems and use practices
June 27, 2010 By 21 Comments
…’m not completely agree with you that stored procedures are evil. After all, they significantly improve…a business logic. They are tricky to debug, yes, but there are plenty of debuggers…to look at? – Toad for MySQL (Free) – Illatis StepIn ($39) – Debugger for MySQL ($49) – dbForge Studio for MySQL ($…
Comment: MySQL Stored Procedures problems and use practices
June 13, 2007 By 21 Comments
I completely agree, trying to develop stored procedures on MySQL is a nightmare. No debugging, you have a syntax error often gives you the wrong line. You also missed the strange situation you are not allowed to use variable in certain constructs – e.g. in the LIMIT clause
