…them. In many cases the better they are the busier they are, so this is…know about Sphinx’s capabilities. Many people think of Sphinx as a …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: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… only 1G is in memcached, I keep pushing data out of memcached to make room for new records …database. You would be surprised how many people use this type of system as I run into this type of application frequently. … we could get more? I mean our reads are going pretty fast, but our writes leave a …
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
… slides. I can only imagine how enormous effort it required but… 2 parts – the break in one room was when other had session … at other time. And this was same for many other speakers. Second – …people – good engineers are extremely hard to find in Russia now as the market is pretty hot. A lot of people…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…this in. The next step would be to decide How Much Memory do you need for other needs. This…or other important processes to make room for file cache. OS may find…do not know what lies in the swap – there are portions of both … of swap IO you’re in trouble. Second, many people think – who cares if some…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…some of the questions but as people still poking me about this I decided to publish the …how many random and sequential read aheads can be happening at the same time HT: All read-aheads are performed in…performance substantially. I assume there is lots of room to tune the flushes, since I never …
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
…this and MySQL Inc would provide a supported MySQL binary. (I was in the room with Monty when he detailed how long this… and the threads, as with too many threads, the system spends more time…would also caution people to clearly understand and test, what are “connections” and what are “active …
