June 20, 2013

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

… in listening to the presentation, it’s currently up and available for viewing over at percona…A: I covered this a bit during the session, but to provide a bit more commentary. …in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db …

Post: Percona Live MySQL Conference 2013 wrap-up

…, tutorial, and breakout session speakers who presented insights into MySQL and MySQL-related technologies in over 110 sessions across four days. Special … session recordings To access all of the currently available slides from one web page, visit the conference website and complete the Sessions

Post: 10 years of MySQL User Conferences

… to “MySQL Conference and Expo” that year and moves to its current location at the convention center in Santa Clara, California. MySQL celebrated… available for MySQL. Facebook mentions they have over 1,800 MySQL Servers. MySQL Enterprise provides Monthly Rapid Updates [MRU] while Community MySQL versions updated… O’Reilly with Oracle providing a keynote and a few sessions. The conference is extended to include a lot of other…

Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer

… any information how memcached cache time expiry being apply into MySQL 5.6 memcached. e.g. if i want to store… vs 5.6 innodb write/read with no memcached layer? Currently I am considering any possible usage of this new feature… so far I think it may able to apply on session codes. Thanks

Post: PHP Sessions - Files vs Database Based

… old file based session behavior with MySQL Sessions ? If you have dedicated connection to session database and use Innodb tables for your session storage you… however – you can use it as an extra to your current MySQL Sessions system without need to change how it works internally. If…

Post: An update on Percona Live MySQL Conference & Expo 2012

… to create an account and submit proposals. We’re currently looking for session proposals; more on that later. We have been working… a cadre of the core MySQL developers to submit talks about what is new in MySQL, the MySQL roadmap for the future, and… juices flowing, and submit those session and tutorial proposals on DRBD, partitioning, community toolkits, security, using MySQL with NoSQL, geospatial functionality, cloud…

Post: Ultimate MySQL variable and status reference list

MySQL manual, …_row_lock_current_waitsblogpercona.commanual…session_cache_missesblogpercona.commanual Ssl_session_cache_modeblogpercona.commanual Ssl_session_cache_overflowsblogpercona.commanual Ssl_session_cache_sizeblogpercona.commanual Ssl_session_cache_timeoutsblogpercona.commanual Ssl_sessions

Post: Troubleshooting MySQL Memory Usage

… memory is being used by current MEMORY tables: mysql> select sum(data_length+index_length…sessions have created which temporary tables (both in memory and not): mysql> select * from information_schema.global_temporary_tables \G *************************** 1. row *************************** SESSION

Post: Can we improve MySQL variable handling ?

… as technique to detect the value for DEFAULT variables for SESSION variables, yet for some GLOBAL variables setting them back and… dealing with MySQL variables in automated way a lot more convenient would be extending INFORMATION_SCHEMA.GLOBAL_VARIABLES Currently as of MySQL 5… refer to “default” or “startup” in addition to “global” and “session” prefixes which are available now it would be quite nice.

Post: Percona Welcomes MySQL 5.6!

MySQL Consulting,  MySQL Support, MySQL Server Development, and MySQL Remote DBA teams: Our MySQL Consulting Team and MySQL Support Team can work together to audit your current… chance to do so. MySQL 5.6 will be well covered in talks, Birds of a Feather sessions, and hallway conversations. As…