…the amazing MySQL manual, especially the option and variable …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: PHP Sessions - Files vs Database Based
March 27, 2007 By 38 Comments
… same session at the same time. First of course means you may have your session data damaged because you will have lost session variables… 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…
Post: MySQL should have dynamic durability settings
April 8, 2008 By 4 Comments
… flushes data to operation system cache (so if MySQL crashes transaction is not lost) but does not save from OS crashes or… transaction can be decided for each transaction separately in session context. What MySQL Could do to take it further is to implement… have normal COMMIT which behaves default way set for the session, COMMIT DELAYED to flush transaction log some time in the…
Post: Percona sessions at the MySQL conference
March 15, 2010 By 6 Comments
… Baron Schwartz: MySQL Graphing and Trending with Cacti Vadim Tkachenko: XtraBackup: Hot Backups and More Aleksandr Kuzminsky: Recovery of Lost or Corrupted InnoDB Tables Ryan Lowe: Achieving PCI Compliance with MySQL Yves Trudeau: How to choose High Availability solutions for MySQL… you, you might also want to attend the Maatkit BoF session. We look forward to seeing you there. It’s going…
Post: Announcing Percona Server 5.5.27-28.0
August 23, 2012 By 5 Comments
…and the minimum index record size. By adding the session variable innodb_merge_sort_block_size block size …. Percona Server has implemented ability to have a MySQL Utility user who has system access to do… spurious duplicate key errors (and, as a result, lost data due to some rows being updated rather…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
…drwx—— 2 root root 16K ago 2 12:36 lost+found Nothing. No files on the partition …size to hold non-transactional statements. Change the session value of binlog_format to STATEMENT just before… most likely killing system in the end. Conclusion MySQL can creates temporary files even thought those …
Post: Back from RIT2007
April 20, 2007 By 6 Comments
… I almost lost my voice after first day of the conference. The session schedule was too packed in my opinion. Sessions were running by 30 minutes (3 sessions in a raw without… for 3 sessions I and Andrew wrote specially for this conference on MySQL Presentations page. Next week I’m going to MySQL Users…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…to get major inconsistence because relay logs will be lost if you just re-point slave. So at …data locally with SQL_LOG_BIN=0 set for session. If the large portion of data trashed you may… Replication breakage (or running out of sync) due to MySQL bugs or wrong use. Interesting enough very few people…
Comment: Percona XtraDB Cluster reference architecture with HaProxy
February 1, 2013 By 63 Comments
…, only 1 node is written at a time. If you lost inserts from the application, there can be many reasons for… doesn’t know what mysql is, it only acts as a tcp level load balancer. So, one tcp session comes in, it goes to one node, if an other TCP session comes in, it goes to…
