… process waiting 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…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
… simple to use than SAN, MySQL is more simple to use than Oracle or DB2, PHP is more simple than Java. Even… other companies have their special “database” interfaces which run on top of MySQL or other databases. Other interesting development is Scalable Blob… best isolated of MySQL source leads the pack – there are bunch of interfaces to talk to MySQL cluster as PHP session storage or as…
Post: Percona sessions at the MySQL conference
March 15, 2010 By 6 Comments
…the 2010 MySQL conference. We’ll be giving a lot of informative technical talks on various …Schwartz: Performance and Feature Enhancements to MySQL and InnoDB Fernando Ipar: PHP Object-Relational Mapping Libraries In… also want to attend the Maatkit BoF session. We look forward to seeing you there….
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
… store the temporary data it will create a on-disk cache on the tmp partition with the name ML*. Here …_cache_size to hold non-transactional statements. Change the session value of binlog_format to STATEMENT just before the … a bug report to follow this issue: http://bugs.mysql.com/bug.php?id=66237
Comment: No more MySQL Crash Safe Replication in 5.0 ?
August 10, 2010 By 7 Comments
An update on this issue. As reported in http://bugs.mysql.com/bug.php?id=34058, this has since been fixed (this bug… duplicate of http://bugs.mysql.com/bug.php?id=22540) at version 5.0.46. From two tests conducted on 5.0.91…, file name ./mysql-bin.000001 The difference is consistently 27, which corresponds to unimportant binlog events: /*!40019 SET @@session.max_insert_delayed…
Comment: PHP Sessions - Files vs Database Based
March 27, 2007 By 38 Comments
… fine with MySQL itself 
It’s just my experience with an application design problem – when PHP issues locking select for the session right… of threads on a sessiondb server, and if others do the same, the situation I described occurs… then the session purgers kicks…
Comment: Are PHP persistent connections evil ?
December 28, 2009 By 32 Comments
… client processes (think mod_php); forgetting to unlock tables and not cleaning up temporary tables; poor use of session variables, etc. I have been running a high-concurrency app on Apache with the worker mpm (up to 3000 threads), with fastCGI + PHP (1 process, 24 children), connecting to mysql via…
Comment: Are PHP persistent connections evil ?
November 14, 2008 By 32 Comments
… help! in PHP mySQL, the use of SELECT FOR UPDATE and SELECT LOCK IN …sends the filled form to be updated on the client, so there is an auto mysql_close.(Which would rollback your transaction…way to store the connection persistent link resource in a session or anywhere else, so there is no way to open…
