19 April 2014

The Ruby Reflector

Topic

MySQL

  Source Favicon
By Fernando Laudares of MySQL Performance Blog 3 months ago.
Email

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

ENGINE: InnoDB

VERSION: 10

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

CREATE TIME…

mysqlperformanceblog.com Read
  Source Favicon
Email

…familiar with the basics of the Rails framework and have previously worked with Rails 3.2 or earlier, then this is the ideal book for you. It is assumed that you have some prior experience with the development of applications. This book will help you to upgrade your existing knowledge and also ensure its applicability. You will be expected to setup Rails, MySQL / PostgreSQL, Mongodb and required dependencies themselves.

oreillynet.com Read
  Source Favicon
Email

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 …

mysqlperformanceblog.com Read
  Source Favicon
Email

…and Percona XtraDB Cluster comes with 5.5 versions, and it is in line with default MySQL version, which again is 5.5.

I expect this release will make it much easier for users to get familiar with our software, so you can go and try this today!

The post Percona Software in Ubuntu 14.04 LTS ( Trusty Tahr) release appeared first on MySQL Performance Blog .

mysqlperformanceblog.com Read
  Source Favicon
By Dominic of Blog | The Working Group 7 months ago.
Email

…for each of the following database platforms that you have used in a live production environment: mySQL, Postgres, Redis, Mongo

Score +2 if you have created an API for a production environment.

Score +2 if you have used Chef or Puppet or other deployment automation tools.

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, …

blog.twg.ca Read
  Source Favicon
By Paar of MySQL Performance Blog 3 days ago.
Email

Finding bugs in MySQL is not only fun, it's also something I have been doing the last four years of my life.

Whether you want to become the next Shane Bester (who is generally considered the most skilled MySQL bug hunter worldwide), or just want to prove you can outsmart some of the world's best programmers, finding bugs in MySQL is a skill not reserved anymore to top QA engineers armed with a loads of scripts, expensive flash storage and top-range server hardware. Off course, …

mysqlperformanceblog.com Read
  Source Favicon
By Dominic of Blog | The Working Group over 1 year ago.
Email

…for each of the following database platforms that you have used in a live production environment: mySQL, Postgres, Redis, Mongo,

Score +2 if you have created an API for a production environment,

Score +2 if you have used Chef or Puppet or other deployment automation tools,

Score - 5 if you generally use ftp to deploy applications,

Score +2 if you have excellent HTML and css skills, and add a bonus +1 if you can show us something significant that you coded in HTML5,

Score …

blog.twg.ca Read
  Source Favicon
By Todd Hoff of High Scalability 4 days ago.
Email

Engineers (All-Levels) to design and develop scalable software written in Java and MySQL for backend component of software that manages application architectures. Apply here .

Fun and Informative Events

Safeguard Commercial Success with a Strategic Monitoring Approach . Does your enterprise have adequate monitoring strategies in place to deal with tech challenges that can otherwise impact revenue and damage your corporate brand? Register now to learn why …

highscalability.com Read
  Source Favicon
By Patrick of Kalzumeus Software 16 days ago.
Email

My abstraction for how much data I have is "One MySQL database and one Redis database containing records on tens of thousands of people on behalf of hundreds of customers. That data is worth hundreds of thousands of dollars to me." I have no bloody clue how large it is in bytes, and — accordingly — had to both measure that and then do Excel modeling (factoring in expected rate of growth, compression ratios, deduplication, etc etc) to guess what Tarsnap would cost me in the …

kalzumeus.com Read
  Source Favicon
By Glenn West of Mental Paging Space over 1 year ago.
Email

…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 …

mentalpagingspace.blogspot.com Read