One may think changing PHP session handler from file based to database driven is fully transparent. … serialized on 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: New Keynote Speakers and Sponsors and Applications Open for DotOrg Pavilion for Percona Live MySQL Conference and Expo
January 22, 2013 By Leave a Comment
…whom praised the breadth and caliber of the sessions. The conference was so popular that we …Zaitsev, CEO of Percona, will speak on the state of the MySQL ecosystem in his welcome address … Web and PHP Magazine 2013 MySQL Community Awards Nominations are now open for the 2013 MySQL Community Awards. …
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
… possibly changed per session variables. Many applications are fine – ie if you have read-only page and everything on your site uses same charset and does not use per session variables in some tricky way…” driver for PHP effort by MySQL team I hope this issue could be fixed. Internal guys sure have more leverage on server development…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… as such I have reported a bug: http://bugs.mysql.com/bug.php?id=67647 Metadata locking behaves differently for queries that… in web applications its typical to see a “sessions” table that is accessed on every request, then care should be taken when… waiting to run on the same table, and as such I have reported the bug: http://bugs.mysql.com/bug.php?id=67873
Post: Amazon Web Services and HP Keynotes at Percona Live MySQL Conference and Expo
February 14, 2013 By 1 Comment
… DaniWeb, Software Developer’s Journal, and Web and PHP Magazine. One Day Passes Now Available and … Birds of a Feather (BOF) sessions at the Percona Live MySQL Conference enable attendees with interests … to propose, explain, exhort, or rant on any MySQL-related topic for five minutes. Their topic …
Post: Speaking on OpenSource Database Conference, Frankfurt
October 26, 2006 By Leave a Comment
… have two sessions on upcoming OpenSource Database Conference in Frankfurt 6-8 November. One session will be general MySQL Performance Optimization workshop the other will be focused on Innodb architecture and optimization. If you’re visiting this event or International PHP…
Post: MySQL on OSCON
July 26, 2007 By 13 Comments
…MySQL, and Databases for that reason. Our talk comparing performance of MySQL Storage Engines had probably 20-30 people, Monty’s talk on MySQL…sessions etc. Or may be people think they know they need to know about MySQL already and nothing cool happened from MySQL…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
Today I gave a presentation on “Read/Write Splitting with PHP” for Percona Webinars. If you missed it, you can still … MySQL replication. Therefore all nodes stay in sync much more reliably. Also, you can enable wsrep_causal_reads for a given session…? A: It depends how you store $_SESSION. I have audited sites that stored $_SESSION in the MySQL database for persistence, but when we…
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… module (or mysql – waiting on long query to come back) – this is our query if it is waiting on the session file lock we…
Post: mk-query-digest, query comments and the query cache
… 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… cache stripping in Percona Server at runtime: mysql> set global query_cache_strip_comments=’ON‘; Query OK, 0 rows affected (0.00…