…Cache The fact Falcon has separate row cache is great as it means it can have much more data cached in the same cache… is also area where detailed documentation is missing so far. [-] No protection from partial …- what happens on row updates, are they stored in the same position or in another location…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… | Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 9630066 | | Bytes_received | 38563413074 | | … and make sure I didn’t miss anything important or write something in a… or apps that have a lot of stored procedures, which are more difficult to …
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… memory requrement for this step, especially specially crafted ones. Stored Procedures. Compex stored procedures may require a lot of memory Prepared statements… Innodb Table Cache. Innodb has its own table cache in which meta data about each table accessed from the start is stored. It… list. On the contrary I’m quite sure I’ve missed something (drop me a note if you have something to…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… “Read/Write Splitting with PHP” for Percona Webinars. If you missed it, you can still register to view the recording and… best scalability, I’d recommend storing $_SESSION in an in-memory data store such as Memcached or APC. Store in $_SESSION only values…, store it more deliberately in a persistent database. Q: Can you compare / contrast this approach with using a write-through cache? A…
Post: On Good Instrumentation
May 31, 2010 By 1 Comment
… would be affected. In is important for response time summary stored in the logs which are easy to query so you… or Memcache. I also like to see numbers of calls stored together with attributed response time. For example I’d like… high miss ratio. Checking what is going on with memcache01 shows it just was restarted (and hence has almost empty cache). This…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… is working on scalable blog streaming to make it possible store large blobs such as images in the database efficiently. The… Dynamo and SimpleDB, Hadoop Another angle of customization of data store and processing was using non SQL and not systems – Google… is missing now is not the database but rather concept and platform – developers do not want to care about database and caching…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… > connections can be much more modest. DVD Store was special > type of application which was …, so > database connection may become the issue. Caching should be > good help in this case though….applications I have to fix have number of indexing missing which > requires queries to do full table scans…
Comment: When should you store serialized objects in the database?
January 21, 2010 By 47 Comments
…. My point is that using MySQL like a key/value store makes caching incredibly easy. So, there’s actually very little read… tradeoffs (flexible schema even with huge tables and dead simple caching in exchange for somewhat reduced write performance) made perfect sense… to become so focused on the data store‘s esoteric performance characteristics that they miss the bigger picture. There are a lot…
Post: Thoughts on MySQL Replication
July 7, 2006 By 18 Comments
… write up about using MySQL replication. The piece I find missing however is good description of warning about limits of this…. Third one is to use cache – something like memcached, besides pure caching it can be used to store object version information so you… have data you’re accessing to be cached in memory by MySQL cache or OS cache. As slaves replicate the same data and…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…. Q30: Question about using solid state disks for storing ib_log* files; I know that innodb writes …, when a battery-backed disk controller write-back cache does the same thing. PZ: First Indeed writes… one at a time, that are esentially reads misses (10ms each). The reads are not excactly sequential,…
