…Handler_commitblogpercona.commanual Handler_deleteblogpercona.commanual Handler_prepareblogpercona.commanual Handler_read_firstblogpercona.commanual Handler_read_keyblogpercona.commanual Handler_read_lastblogpercona.commanual Handler_read_nextblogpercona.commanual Handler…
Post: PHP Sessions - Files vs Database Based
March 27, 2007 By 38 Comments
One may think changing PHP session handler from file based to database driven is fully transparent. In … 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: Diagnosing and Fixing MySQL Replication + Early Bird Registration Extended!
September 19, 2011 By 1 Comment
… a Percona Consultant speak on Replication. “Replication is one of MySQL’s most widely-used features, and despite significant improvements over… any number of factors, either internal or external to your MySQL database. For those who do not have a thorough understanding…? Come see others speak on topics from Handler Socket to Programmatic Queries. With 45 sessions not including the keynotes you are bound…
Post: MySQL: Followup on UNION for query optimization, Query profiling
August 14, 2006 By 14 Comments
…mysql> show status like “Handler%”; +—————————-+——-+ | Variable_name | Value | +—————————-+——-+ | Handler_commit | 0 | | Handler_delete | 0 | | Handler_discover | 0 | | Handler_prepare | 0 | | Handler_read_first | 0 | | Handler_read_key | 1 | | Handler…
Comment: PHP Sessions - Files vs Database Based
April 10, 2012 By 38 Comments
With suggested mysql backed memcached as session handler, there still exists problem with concurrency between simultaneous requests overwriting each others $_SESSION variable. On a… ( http://scache.nanona.fi ) to completely drop using the generic session handler and instead split data on small enough fragments to reduce…
Comment: PHP Sessions - Files vs Database Based
April 5, 2007 By 38 Comments
…PHP Sessions – Files vs Database Based Dicas para utilização de mysql como “session handler”. Notei um dia desses que php 5.2… por padrão e com isso, suporte a sqlite como “session handler”. Verei algum esquema em breve para compartilhar sessão entre…
Comment: PHP Sessions - Files vs Database Based
October 24, 2007 By 38 Comments
Yes, memcached is great, but it is a cache nonetheless that is stored in memory. In case you run out of memory for the memcached daemon, your session data might end up getting garbage collected. I personally recommend using an memcached session handler backed by a mysql database.
Post: Percona XtraDB Cluster (PXC): what about GRA_*.log files ?
December 19, 2012 By Leave a Comment
…_3.log: data [root@node2 mysql]# ls -l GRA_3_3.log -rw-rw—-. 1 mysql mysql 106 Nov 29 23:28 GRA…_3-bin.log: MySQL replication log [root@node2 mysql]# mysqlbinlog -vvv GRA_3_3-bin.log /*!40019 SET @@session.max_insert_delayed_threads….actor; Duplicate entry ’447′ for key ‘PRIMARY’, Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event’s master…
Post: Worse than DDOS
August 18, 2008 By 5 Comments
… of PHP sessions “files” handler I already wrote about this topic, but when troubleshooting this all takes another angle. Default file handler means… (or mysql – waiting on long query to come back) – this is our query if it is waiting on the session file lock… are much easier with say memcached session storage – this does not cause any locks for parallel session use so only the process…
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
… GA versions of MySQL 5.1 is ‘MIXED’ STATEMENT*; The binlog_format variable can still be changed per sessions which means it… ‘t1′, Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event’s master log mysql-bin.000001, end_log_pos… currently executing at relay log file: mysql_sandbox25162-relay-bin.000002 at position: 340718. MySQL 5.1 ships with a new version…
