…concurrent unhappy , and that behavior was partially reverted in MySQL 5.6.16 with the fix for bug # 71017 . But the fundamental problem is still there: mysqldump --single-transaction does not guarantee consistency with concurrent DDL statements and updates to non-transactional tables.+ mysqldump --single-transaction has been alleviated with metadata locks in MySQL 5.5, which however made some users
So the fact that FTWRL is an overkill for backups has …
mysql> SELECT * FROM information schema.tables WHERE table_schema='test' and table_name='testA'\G
*************************** 1. row ***************************
TABLE CATALOG: def
TABLE SCHEMA: test
TABLE NAME: testA
TABLE TYPE: BASE TABLE
ROW FORMAT: Compact
TABLE ROWS: 0
AVG ROW LENGTH: 0
DATA LENGTH: 16384
MAX DATA LENGTH: 0
INDEX LENGTH: 0
DATA FREE: 0
AUTO INCREMENT: NULL
Based on MySQL 5.6.16 , including all the bug fixes in it, Percona Server 5.6.16-64.0 is the current release in the Percona Server 5.6 series. All of Percona's software is open-source and free, all the details of the release can …
mysql> SELECT [...]
10 rows in set (0.45 sec)
And let's look at pt-diskstats: #ts device rd_s rd_avkb wr_s wr_avkb busy in_prg 1.0 sda2 0.0 0.0 16.0 9.2 0% 0 1.0 sda2 0.0 0.0 0.0 0.0 0% 0 1.0 sda2 0.0 0.0 0.0 0.0 0% 0 1.0 sda2 0.0 0.0 16.0 4.0 1% 0 1.0 sda2 0.0 0.0 0.0 0.0 0% 0 1.0 sda2 0.0 0.0 0.0 0.0 0% 0 1.0 sda2 …
Score +2 if you have created an API for a production environment.
Score - 5 if you've only used ftp to deploy applications.
Score +1 if you ride a bike.
Score +1 if you play an instrument.
Score +1 if you speak another language.
Score +1 if you paint, draw, sculpt, …
@ rilt : Mysql dead, now in production using @ python driver.
@ CompSciFact : "No engineered structure is designed to be built and then neglected or ignored." -- Henry Petroski
Arundhati Roy : Revolutions can, and often have, begun with reading.
Brett Slatkin : 3D printing is to design what continuous deployment is to code.
Wellgot on that right quick: Facebook wants to use drones to blanket remote …
…Apply here .(All-Levels) to design and develop scalable software written in and MySQL for backend component of software that manages application architectures.
Fun and Informative Events
WhichShould You Use? Benchmark Results - TokuMX vs. MongoDB. March 5th at 1pm ET. It may be easy to choose a database, but do you know which distribution is best for you? Which will perform better? Which will scale further? …
Score +2 if you have created an API for a production environment,
Score - 5 if you generally use ftp to deploy applications,
Recently I switched my website from, hosted on , to , which I now host on . This post is an overview of why, how and any pain points I came across during the migration.
Why switch from Wordpress to Jekyll?
I've been on Wordpress for 7 or 8 years. It's a great tool. However my website is fairly simple . I have 3 pages and a blog. Wordpress is big, it's complex, and runs on Jekyll is a light weight static site generator.with a MySQL database.
…proving the bottleneck. In surfing I found that MariaDB had "spun" out of mysql. MariaDB is a drop-in replacement for mysql, and is totally open source. My test bed is a mac-mini, and sure I can throw hardware at the problem, but its far more interesting to look at optimizing. So I used brew, a open-source package manager for osx, I installed MariaDb. I had a existing 20Gig database, and it picked it up, and used it just fine. The surprising thing is I saw a 30% increase in performance …