… entire dataset is about 4GB and only 1G is in memcached, I keep pushing data out of memcached to make room for new records… surprised how many people use this type of system as I run into this type of application frequently. Keeping it simple, ensures that application is generally…
Post: Introducing our Percona Live speakers
May 10, 2011 By 4 Comments
…is about the things you don’t know about Sphinx’s capabilities. Many people…in date order (not importance order) and with an indication of how many rows are in…in San Francisco and it could happen again here, even with the additional rooms…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… up first slave. This command output is pretty simple and leaves no room for mistakes: mysql…in this output there are 3 log file names and log file positions which can get confusing, and indeed I often see people… confusion so many years later. The mistake of using Master_Log_File is in fact VERY…
Post: HighLoad 2007 Review
October 6, 2007 By 1 Comment
…. Speakers were very open in many cases sharing data about their…only imagine how enormous effort it required but it is very … parts – the break in one room was when other had …this is about it. It was very surprising to see no Google people attending, even though they now have office in Russia. In…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
…while factoring this in. The next step would be to decide How Much Memory do you need for other needs. This …swap IO you’re in trouble. Second, many people think – who cares if some of buffer pool is swapped out, I …care at values close to 14G as there is not much room left for other things. P.S I …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…is a busy man so I got answers to only some of the questions but as people still poking me about this…how many read-ahead requests can be queued at once. Q13: Is there any IO concurrency control – how many…is lots of room…
