… engine was announced as a potential Innodb successor. A “MySQL Network” commercial subscription product was announced in what later evolved into… and Sun is now closed after overcoming a number of bottlenecks, including strong opposition by Monty. There is a lot of…
Post: To find the bottleneck, stop guessing and start measuring
August 4, 2008 By 8 Comments
… the bottleneck? The process is slow, and neither machine is really doing much work. Why? Maybe you guessed the network. Nope, not the network either. There was plenty of spare network capacity. If I told you…
Post: How network can impact MySQL Operations ?
September 1, 2008 By 5 Comments
… servers. The mystery could be easily resolved while looking at network topology. Some database servers were connected to Switch A others… to be the bottleneck. What does this tell us ? Even if you’re the DBA you better to understand network topology to… to restore these in parallel efficiently ? Will there be enough network bandwidth to pipe them through. These and similar questions are…
Post: FaceBook Search, Search for social networks
August 12, 2007 By 4 Comments
… this stage it is not getting the documents which becomes bottleneck. Working with database instead of with web documents has another… able to draw pager properly. The hard part in social network search is permissions and ranking – not all objects are public…
Post: Benchmarks challenges of XtraDB Cluster
April 20, 2012 By 5 Comments
… easily can became bottleneck in the benchmarks – this is network. In case of simple client-server setup, the network is not fully utilized… account that there is an internal network communication between nodes also, and that makes a network tuning as the critical part of…, pay an attention to network component. It is very easy that a client or a client network becomes bottleneck. Follow @VadimTk !function(d…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
… speed as well as space needed or be a serious bottleneck depending on circumstances and approach used. First I should mention… local copy as well as less network bandwidth requirements in case you’re backing up to network storage. Compression on the destination… cases however it is not fast enough and becomes the bottleneck for all the backup process. Recently I did a little…
Post: MySQL caching methods and tips
April 4, 2011 By 5 Comments
… access is expensive for your application. It often requires CPU, network and disk access, all of which can take a lot… usually face two bottlenecks: disk IO and CPU usage. Disk IO is expensive, and even if the disk bottleneck is eliminated, the…
Post: The perils of uniform hardware and RAID auto-learn cycles
November 16, 2010 By 16 Comments
… example, there was no shared storage; servers were on different network segments and in different racks; and so on. I had… seen this before — for example, a query cache bottleneck, or an insert buffer bottleneck, or any of a variety of other things…
Comment: To find the bottleneck, stop guessing and start measuring
August 7, 2008 By 8 Comments
… easily filled up 30 slides with all manner of possible bottlenecks. With all those considerations, the only possible approach, which I… application. As it turned out, those teams were tossing the bottleneck back and forth between them like a hot potato without… was inserting a strategically located sleep statement. The over-clogged network and database queue was spewing so many errors that the…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
April 24, 2007 By 117 Comments
… which can simulate CPU overloading vs. HDD overloading vs. network overloading vs. software bottleneck (blocking threads) etc. Is it possible with PHPTestSuite… is a standard “acceptable” response time for modern distributed enterprise network applications. 1 second is “excellent”, and 10 seconds is “maximum…
