May 25, 2012

Post: PHP Sessions - Files vs Database Based

One may think changing PHP session handler from file based to database driven is fully transparent. … based sessions PHP will lock session file for whole script execution duration, which means all requests from the same sessions will be serialized on PHP level, which means they also will be serialized for single user on database level. If you change to store PHP sessions

Post: Worse than DDOS

…. If you’re using PHP functions make sure default_socket_timeout has proper value or set it per session. Set Curl Timeouts… stages and just setting timeout is not enough. Beware of PHP sessions “files” handler I already wrote about this topic, but when… are much easier with say memcached session storage – this does not cause any locks for parallel session use so only the process…

Post: mk-query-digest, query comments and the query cache

…” SQL queries with additional information such as the PHP source line and user session information by embedding this information in a specially…, and that this comment includes important information, such as the PHP session ID, and the application user name. This allows mk-query… information to display only queries from a particular file, particular session or particular user for example. The –embedded-attributes option takes…

Post: Are PHP persistent connections evil ?

… pooling would be extremely helpful but with default Processed based PHP installations it does not work. Interesting enough these problem of… trouble back again, not to mention about possibly changed per session variables. Many applications are fine – ie if you have read… your site uses same charset and does not use per session variables in some tricky way it would work perfect for…

Comment: PHP Sessions - Files vs Database Based

… on the same session as you would have processes waiting on the same file in case of file based PHP sessions. If you have high concurrency within single session it of course does not work well but in this case plain MySQL sessions based session storage may not…

Comment: PHP Sessions - Files vs Database Based

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…

Comment: PHP Sessions - Files vs Database Based

….virtualthinking.com/loadhtml.php?where=scripts&what=art_show.php&db_target=00000000024 It doesn’t implement a custom session handler, but it works in a similar manner, and has the added benefit of being able to work with traditional PHP sessions

Comment: Beyond great cache hit ratio

Jonathan, use repcached patch for memcached – it is stable solution that we used to share php session state over cluster (php stores session via memcache handler)

Post: Commodity Hardware, Commodity Software and Commodity People

…, MySQL is more simple to use than Oracle or DB2, PHP is more simple than Java. Even for the same Vendors… lighter top part ? The same way as you can run PHP as part of Apache but you can hook it up… are bunch of interfaces to talk to MySQL cluster as PHP session storage or as a REST Web Service, which are all…

Post: Percona sessions at the MySQL conference

…: Performance and Feature Enhancements to MySQL and InnoDB Fernando Ipar: PHP Object-Relational Mapping Libraries In Action Baron Schwartz: Read-Write… you, you might also want to attend the Maatkit BoF session. We look forward to seeing you there. It’s going…