June 18, 2013

Post: MySQL Consulting - Being on your own

…- we may have work piling or days becoming idle pretty quickly. With customers it means sometimes we… you’re working onsite you get 8 billable hours per day, 40 billable hours per week, when you …hours rather than wall clock hours but it means you get less of them. Also we should be following MySQL

Post: Death match! EBS versus SSD price, performance, and QoS

… 72040.6 sda3 25.5 2.7 1.6 3.8 0.2 1.5 47% 1 78041.7 sda3 25… a quadruple extra large EC2 server (currently priced at $2/hour for a non-reserved instance) with a software RAID10 array…) is both large and variable even though the devices are idle most of the time. In some time periods, the write…

Post: Estimating Replication Capacity

…1 hour worth of binary logs within 1 hour. I will…vs staying idle. Note you can speak about idle replication …mysql> select * from information_schema.user_statistics where user=”#mysql_system#” \G *************************** 1. row *************************** USER: #mysql…14 0 # Tmp table 8.30G 0 2.01M…

Post: Rendundant Array of Inexpensive Servers

…it extremely unlikely to fail, because you have 4 hour onsite repair agreement and because it is just …are no performance gotchas (ie 8 core server can be slower than 4 core with MySQL). It is best if…on the server which will be where sitting doing idle. How many spare servers you need – you would …

Post: When to use Hardware upgrade instead of Software Optimization

…10 servers one of them is overloaded and 8 are almost idle. In this case proper balancing is the …you do a backup or at 15 minutes off hour when you have some cron job running. In such…as moving from 4 Core systems to 8 Core reduced performance for many MySQL systems even though hardware itself was…