… to store the data which required 90 requests as the single object. You have 1 request (hit) now and 10 misses which… have hundreds of page views per user per session may be good enough with caches which are effectively per user. Control invalidation Item in… complicated front page which would require a lot of cache requests and hundreds of milliseconds of CPU processing and which can…
Post: Worse than DDOS
August 18, 2008 By 5 Comments
… sure default_socket_timeout has proper value or set it per session. Set Curl Timeouts Set both TIMEOUT and CONNECT_TIMEOUT as… file gets locked while PHP request is being served. In this case because of network stall request could be taking 100+ seconds… parallel session use so only the process which actually stalls waiting on external resource will show high number of seconds since request…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
… in trouble back again, not to mention about possibly changed per session variables. Many applications are fine – ie if you have read… on your site uses same charset and does not use per session variables in some tricky way it would work perfect for… should get fresh connection ID so if you track web requests in MySQL Logs by connection ID it would still work…
Post: The Optimization That (Often) Isn't: Index Merge Intersection
December 14, 2012 By 6 Comments
… to version 5.0, MySQL could only use one index per table in a given query without any exceptions; folks that… to return the data we want. Since we’re only requesting the user_id column, which is the PK for this… dynamically-adjustable setting and can be modified globally or per-session: SET [GLOBAL|SESSION] optimizer_switch=”index_merge_intersection=off”; This is the…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
….commanual innodb_file_per_tableblogpercona.commanual innodb_…session_cache_missesblogpercona.commanual Ssl_session_cache_modeblogpercona.commanual Ssl_session_cache_overflowsblogpercona.commanual Ssl_session_cache_sizeblogpercona.commanual Ssl_session_cache_timeoutsblogpercona.commanual Ssl_sessions…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… 060717 3:07:56 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last…0 LIST OF TRANSACTIONS FOR EACH SESSION: —TRANSACTION 0 0, not started, process …workload. Note however – IO requests submited by threads executing requests are not accounted here…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…’t necessary. Q: For randomizing the slave requests, should we use some randomize function or … mentioned, many applications require different tolerance levels per query. A: Yes, that’s a good point… It depends how you store $_SESSION. I have audited sites that stored $_SESSION in the MySQL database …
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
… time for some random user requests, you are usually interested … queries were run during that session which took 148s seconds overall: # ######################################################################## … # # 1s ### # 10s+ # 160847 The stats here are aggregated per all queries which is great…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
… the read. The great thing is wsrep_causal_reads is session variables so you can mix different applications on the same…=1000000 –num-threads=1 –init-rng=on –max-requests=0 –max-time=300 run …. per-request statistics: min: 0.68ms avg: 0.88ms… running the same update statement on the different cluster node: per-request statistics: min: 0.69ms avg: 1.12ms max: 52334.76ms…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… Queueing theory. In short we can assume that users send requests with some arrival rate (which can be different in the… until asked to handle a request Benchmarks generates transactions with a given rate, i.e. M transactions per second and puts into… with DROP TABLE performance. Does DROP TABLE, running in separate session, affect a response time of queries that handle user load…
