…didn’t last long, and after a few hours I believe everyone felt the energy and enthusiasm…. in years.” Darren Cassar called it “one of the best MySQL conferences since I started attending four years …week. Photos of the conference are on Google Plus. Looking through the photos makes me feel nostalgia …
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
… Russian speaking country, when our Russian knowledge is a serious plus. Russians are however leaders in contacting us via email and… one hour, especially if working with small project implemented by beginner. It may be as simple as adding few indexes and tuning MySQL… bill efficient hours rather than wall clock hours but it means you get less of them. Also we should be following MySQL and…
Post: The MySQL optimizer, the OS cache, and sequential versus random I/O
April 28, 2008 By 17 Comments
…could take several days to run with one join order takes an hour with another, and the optimizer chose the…choose the faster one? That’s what this post is about. Let’s start with the MySQL query optimizer. The…rows / 117 bytes per row / 4096 bytes per read), plus about 150 million random I/Os for the …
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… because we used MyISAM tables which are not ACID complaint. Plus we only measured Power to keep things simple. We tested… only one query which does not complete within an hour in 5.1 and MySQL 6.0 can complete all queries within an hour…-off time to 3 hours to give MySQL more time to complete the queries: Query MySQL 5.0.23 MySQL 6.0.4Ratio Query13784…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
… a quadruple extra large EC2 server (currently priced at $2/hour for a non-reserved instance) with a software RAID10 array…: Server one in the datacenter is maybe a $10k machine with a $3000 disk array (say $4000 total per year plus colo… in the cloud costs about $17k to run per year, plus about $1500 per year in disk cost (up to $3000…
Post: Predicting how long data load would take
May 24, 2007 By 12 Comments
… and copy it back in a binary form. MySQL Configuration Different storage engines have different settings which… could see data load speed of 60GB during one hour and 10GB during another depending on the tables… (allowing to fit all BTREE indexes in memory) plus we loaded data in parallel and our rows…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
… from application to the application and from load to load. Plus what is the most important within same application the lag… running for hours which stalls replication progress for this time. As MySQL Replication goes in single thread it is enough for one statement to get stuck to have all replication stalled. Long Queries – MySQL Replication executes queries one after another on…
Comment: Why MySQL could be slow with large tables ?
August 22, 2010 By 139 Comments
… wrote give me any result at all in over 12 hours. This is being done locally on a laptop with 2… GB? (There are only 3 fields of a one characterseach in the table plus one field of 40 characters, which is inexed and is the filed being used for the sql statement relating both tables). MySQL…
Post: MySQL and Sun - Oportunity for smaller companies ?
March 26, 2008 By 10 Comments
… a fix for you within an hours and roll it into next release … from pricing standpoint and quality standpoint – MySQL Support is still very good compared … as competent and not as uniform quality. Plus it takes much longer time to … much larger and more complicated for one person to know all the code. …
Post: New Presentations published (Meetup and Highload)
November 7, 2008 By 1 Comment
…. Innodb Scalability and New Features (Russian), Scaling MySQL-powered Web Sites by Sharding and Replication (Russian…people mentioned their invite mentioned it will be one hour only… bad luck. It is also a … narrow topic for the same presentation length plus, really, the narrow topic means it is …
