One may think changing PHP session handler from file based to database driven is fully transparent. In many cases it is, sometimes … on PHP level, which means they also will be serialized for single user on database level. If you change to store PHP sessions 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: Back from OpenSource Database Conference
November 9, 2006 By 1 Comment
I’m just back from OpenSource Database Conference and PHP International Conference which took place in Frankfurt. I’ve uploaded … some hard core performance optimization sessions for PHP applications which did not exist. Attending Arjens session about typical MySQL/PHP Mistakes I was surprised…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 31 Comments
… faster with MySQL than with most other databases. Not only connects are expensive but you … extremely helpful but with default Processed based PHP installations it does not work. Interesting enough …, not to mention about possibly changed per session variables. Many applications are fine – ie if …
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
… head not to mention understanding all ups and downs of database management system. This sounds nice in theory but there are… few other companies have their special “database” interfaces which run on top of MySQL or other databases. Other interesting development is Scalable… are bunch of interfaces to talk to MySQL cluster as PHP session storage or as a REST Web Service, which are all…
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 (nÃ… por padrão e com isso, suporte a sqlite como “session handler”. Verei algum esquema em breve para compartilhar sessão…
Post: Speaking on OpenSource Database Conference, Frankfurt
October 26, 2006 By Leave a Comment
I’ll have two sessions on upcoming OpenSource Database Conference in Frankfurt 6-8 November. One session will be general MySQL Performance Optimization… and optimization. If you’re visiting this event or International PHP Conference which runs parallel to this even drop me a…
Post: Percona sessions at the MySQL conference
March 15, 2010 By 6 Comments
… Databases Matt Yonkovit: The Five Minute DBA Bill Schuler, Baron Schwartz: Performance and Feature Enhancements to MySQL and InnoDB Fernando Ipar: PHP… you, you might also want to attend the Maatkit BoF session. We look forward to seeing you there. It’s going…
Comment: PHP Sessions - Files vs Database Based
June 6, 2009 By 38 Comments
[...] PHP Sessions – Files vs Database Based | MySQL Performance Blog Share and [...]
Post: linux.conf.au 2012 roundup
January 24, 2012 By Leave a Comment
… as the filesystem for the database server in the not too distant future. Mistakes Were Made This session explores a number of… the database servers we all love and use. Migrating to PHP 5.4 Probably quite useful if you’re dealing with PHP (although I wasn’t in this session). Finding vulnerabilities in PHP…
Comment: mk-query-digest, query comments and the query cache
… all queries which correspond to single PHP session (and being able to aggregate such data from multiple database servers if needed) is really…