16 April 2014

The Ruby Reflector

Topic

MySQL

  Source Favicon
By Todd Hoff of High Scalability 16 hours 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 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

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

…this vulnerability in all cases. I do not have hard numbers but I would guess no more than 10-20% of MySQL (and variants) installations would be vulnerable, even before you look at when they are exposed to the Internet.

To find out whenever MySQL is dynamically compiled with OpenSSL or yaSSL you can use this command: [root@localhost vagrant]# ldd /usr/sbin/mysqld | grep ssl libssl.so.10 => /usr/lib64/libssl.so.10 (0x00007fb7f4cbc000

It will show "libssl" for server …

mysqlperformanceblog.com Read
  Source Favicon
Email

…presentations. I would like to thank our great keynote speakers who covered a wide variety of topics including MySQL 5.7, integrating MySQL and Hadoop, SSD storage, OpenStack, and the future of running MySQL at scale. If you couldn't attend this year, you can watch the keynote recordings by visiting the conference website . I was particularly interested in the presentation on MySQL 5.7 from Tomas Ulin, VP of MySQL Engineering for Oracle, which demonstrated …

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 Patrick of Kalzumeus Software 13 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 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 15 days ago.
Email

How to Scale MySQL for Big Data Applications . A Guide to Evaluating TokuDB on March 20th at 1pm ET. You can do more than you think with the MySQL you already have. Learn how to use MySQL or MariaDB in Big Data applications by simply upgrading the storage engine with TokuDB. Register now .

April 3 Webinar: The BlueKai Playbook for Scaling to 10 Trillion Transactions a Month . As the industry's largest online data exchange, BlueKai knows a thing …

highscalability.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