… it is a lot larger problems with MySQL 5.5 with addition of user variables, stored procedures, prepared statements etc which can be a memory hog. My intent with this post is dual. I would encourage MySQL…. You will be thanked by a lot of people running MySQL in wild. I also wanted to share some troubleshooting techniques I…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
…the behavior of the MySQL when it needs to log “not usual” queries like Events, Functions, Stored Procedures, Local Variables, etc. We’ll learn…to the procedure itself. So in this case you don’t need to replicate all your stored procedures in your slaves servers. Example: mysql> create procedure this…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… normally treated very quickly by MySQL. The moment you give someone access to MySQL Server, all MySQL Security guarantees is you …unable 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
…+————————+——-+ | Variable_name | Value | +————————+——-+ | Slave_open_temp_tables | 1 | +————————+——-+ The slave is now “vulnerable,” in…in set (0.00 sec) What you see depends on your version of MySQL, because the logging of stored procedures…
Post: Profiling MySQL stored routines
January 19, 2009 By 3 Comments
… an application based entirely on stored routines on MySQL side. Even though I haven’t worked much with stored procedures, I though it’s going to be a piece of cake. In… to check if it would be hard to implement configurable variable for switching between routine and query logging, so maybe one…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_…applications, or apps that have a lot of stored procedures, which are more difficult to analyze because …
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
… should they estimate memory consumption by MySQL Server in given configuration. What is the … step, especially specially crafted ones. Stored Procedures. Compex stored procedures may require a lot of memory … you get in practice and how memory consumption reacts to changing various variables. For …
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/function… with variables) or an error on the server. From release to release, sometimes errors appear in MySQL interpreter, or they are fixed. And in…
Post: Percona Server 5.5.8 Beta Release
February 16, 2011 By 16 Comments
…, stored procedures More diagnostics and tunability More pluggability, including pluggable authentication In addition to building on MySQL 5….in new status variables in InnoDB Show Status. Bug fixed:#698797. Variable Changes New variable innodb_adaptive_flushing_method was added. New variable…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… can be fixed by increasing net_write_timeout variable on the server so it gives you more…efficient. Another alternative is of course to use MySQL Stored Procedures which can be fit to do this simple … Using FEDERATED Tables can work for some cases in others script can be more efficient especially …
