One may think changing PHP session handler from file based to database driven is fully transparent. … PHP level, which means they also will be serialized for single user on database level. If you change to store PHP sessions in MySQL instead this effect may be no more true and you may have number of requests executing for the same session…
Post: Worse than DDOS
August 18, 2008 By 5 Comments
…. 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… (or mysql – waiting on long query to come back) – this is our query if it is waiting on the session file lock…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 31 Comments
… it. Persistent connections were added to PHP during times of MySQL 3.22/3.23 when MySQL was simple enough so you could… trouble back again, not to mention about possibly changed per session variables. Many applications are fine – ie if you have read… but they need some MySQL support to be properly implemented. Now with new “mysqlnd” driver for PHP effort by MySQL team I hope…
Comment: PHP Sessions - Files vs Database Based
March 27, 2007 By 38 Comments
… 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 work for you either because there will be large chance to loose session variables updates…
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: 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… for MySQL but why could not one develop smaller and lighter top part ? The same way as you can run PHP as… 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
… Schuler, Baron Schwartz: Performance and Feature Enhancements to MySQL and InnoDB Fernando Ipar: PHP Object-Relational Mapping Libraries In Action Baron Schwartz… Zaitsev: Choosing Hardware and Operating Systems for MySQL Peter Zaitsev: Instrumenting your Application for MySQL and Memcached Peter Zaitsev: InnoDB Architecture and… 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
March 27, 2007 By 38 Comments
I used MySQL for user identification since my first day in php development because it felt natural thing to do. Why should I use PHP sessions instead? Is there any advantage?
Post: MySQL on OSCON
July 26, 2007 By 13 Comments
… to much interest in the MySQL, and Databases for that reason. Our talk comparing performance of MySQL Storage Engines had probably 20… end related talks such as PHP performance optimization or High Performance JavaScript were attended extremely well. MySQL BOF supported by bear and… visit sessions etc. Or may be people think they know they need to know about MySQL already and nothing cool happened from MySQL…
Post: mk-query-digest, query comments and the query cache
… the LAMP stack. Instrumentation-for-php collects information about the PHP process such as wall time, cpu time, mysql query times, etc, and… user session information by embedding this information in a specially formatted SQL comment. This information can then be cross-referenced between MySQL…, and that this comment includes important information, such as the PHP session ID, and the application user name. This allows mk-query…