… Server has introduced innodb_read_views_memory and innodb_descriptors_memory status variables in the Extended Show Engine … a memory leak if query cache was used together with InnoDB. Bug fixed #1170103. Fixed … for Percona Server for MySQL 5.5.31-30.3 are available in our online documentation. Bugs …
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… but are interested in listening to the presentation, it’s currently up and available for viewing over at … that MySQL is up and running. That said, there are plenty of other MySQL and OS-level status variables … was, honestly, why would you ever want to use MySQL on top of something like that? I can’…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… default glibc memory allocator is used. Bug fixed #1131187 (Alexey Kopytov). Removed trx_list scan in read_view_open_now() which is another…_max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III). Fixed the upstream bug #62578 which caused MySQL client to abort…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… default glibc memory allocator is used. Bug fixed #1131187 (Alexey Kopytov). Removed trx_list scan in read_view_open_now() which is another…_max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III). Fixed the upstream bug #62578 which caused MySQL client to abort…
Post: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
…4096 updatable-views-with-…used as technique to detect the value for DEFAULT variables for SESSION variables, yet for some GLOBAL variables…MySQL variables in automated way a lot more convenient would be extending INFORMATION_SCHEMA.GLOBAL_VARIABLES Currently as of MySQL 5.5 it contains only variable…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
…alignright” width=”300″] Investigating MySQL Replication Latency in Percona XtraDB Cluster[/caption]…data center latency point of view though the server hardware is… wsrep_causal_reads is session variables so you can mix …As promised the script I was using for testing. Appendix2: Percona XtraDB …
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…percona2 Now let’s check the status variables: | wsrep_local_state_comment | Synced (6) | |…’ to clear the current input statement. percona1 mysql> use test ERROR 1047 (08S01): Unknown command …in the log file: 120724 10:58:09 [Note] WSREP: evs::proto(86928728-d56d-11e1-0800-f7c4916d8330, GATHER, view…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option and variable reference table. But just as frequently, I want to look up blog posts on variables…innodb_use_native_aioblogpercona.commanual innodb_use_….commanual locked_in_memoryblogpercona.commanual …checksblogpercona.commanual updatable_views_with_limitblogpercona….
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…create temp tables; the same applies to views and probably some other things I’m … I can also set a bunch of user variables — they use memory too. And they can be … sec) mysql> select get_lock(@a, 1); +—————–+ | get_lock(@a, 1) | +—————–+ | 1 | +—————–+ 1 row in set …
Post: MySQL should have dynamic durability settings
April 8, 2008 By 4 Comments
If you’re using Innodb tables MySQL has innodb_flush_log_at_trx_commit variable which defines how durable your transactions are. If… fact that user viewed certain item to implement recommendations it does not matter if this update is lost in crash conditions. You… session variable, this is really where it belongs as decision how to commit transaction can be decided for each transaction separately in…
