Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 11 to 20 of 33584 10 Older Entries
Chegg
+0 Vote Up -0Vote Down

Pythian revamped Chegg’s MySQL architecture and processes and has provided 24×7 operations and incident management support and continual architectural guidance for Chegg’s MySQL, MongoDB,and Cassandra environments for the past five years—prior to, during, and after their IPO. Pythian also spearheaded an implementation on Amazon Web Services’ cloud for the elasticity needed by an educational application’s cyclical peaks. Chegg’s partnership with Amazon and Pythian has allowed for rapid growth and constant evolution without sacrificing performance. Many years later, Chegg still has no in-house DBAs, and relies on Pythian’s …

  [Read more...]
Monitor MySQL Performance Interactively With VividCortex
+0 Vote Up -0Vote Down

If you’re monitoring MySQL performance on dozens or hundreds of servers, chances are you have a “rainbow chart” – a time-series chart with hundreds of tiny area graphs stacked on top of each other, crawling imperceptibly one pixel at a time across the big-screen monitor in your office. The trouble with these charts is they’re hard to see. It takes many minutes for enough new pixels to display after a change. In the meantime you can’t see the change clearly.

At VividCortex, we think we’ve found a better way to keep tabs on what’s going on in your infrastructure: a bubble visualization. It is compact, and …

  [Read more...]
Scaling TokuDB Performance with Binlog Group Commit
+0 Vote Up -0Vote Down

TokuDB offers high throughput for write intensive applications, and the throughput scales with the number of concurrent clients.  However, when the binary log is turned on, TokuDB 7.5.2 throughput suffers.  The throughput scaling problem is caused by a poor interaction between the binary log group commit algorithm in MySQL 5.6 and the way TokuDB commits transactions.   TokuDB 7.5.4 for Percona Server 5.6 fixes this problem, and the result is roughly an order of magnitude increase in SysBench throughput for in memory workloads.

MySQL uses two phase commit protocol to synchronize the MySQL binary log with the …

  [Read more...]
InnoDB’s multi-versioning handling can be Achilles’ heel
+1 Vote Up -0Vote Down

I believe InnoDB storage engine architecture is great for a lot of online workloads, however, there are no silver bullets in technology and all design choices have their trade offs. In this blog post I’m going to talk about one important InnoDB limitation that you should consider.

InnoDB is a multiversion concurrency control (MVCC) storage engine which means many versions of the single row can exist at the same time. In fact there can be a huge amount of such row versions. Depending on the isolation mode you have chosen, InnoDB might have to keep all row versions going back to the earliest active read view, but at the very …

  [Read more...]
New Webinar: A DevOps Guide to Database Infrastructure Automation for eCommerce
+0 Vote Up -0Vote Down

December 17, 2014 By Severalnines

For an online shop, the website is the cash register. It has to be open for business 24 hours a day.

As the ops person on duty, when you get a call at 3am after your website went down, your priority number one is to restore the service asap. But why can we not have our application stack automatically recover, and not have the pager wake us at all? Why do we still stick to tedious manual processes, which take up time and resources, and hinder future growth?

Infrastructure automation isn’t easy, but it’s not rocket science either, says Riaan Nolan. Riaan has been in …

  [Read more...]
Memory summary tables in Performance Schema in MySQL 5.7
Employee_Team +1 Vote Up -0Vote Down

One of great innovation in MySQL 5.7 is memory summary tables в Performance Schema and corresponding views in sys schema

And as troubleshooting freak I have huge reason to greet this feature.

Before version 5.7 we had very limited abilities to diagnose memory issues in MySQL. We could use operating system tools, such as vmstat, top, free, but they only showed what MySQL server uses memory, but do not show how. In version 5.7 things changed. …



  [Read more...]
How to install osCommerce on Ubuntu 14.04 (Trusty Tahr)
+1 Vote Up -0Vote Down

How to install osCommerce on Ubuntu 14.04 (Trusty Tahr)

This document describes how to install osCommerce in Ubuntu 14.04. Open Source Commerce (osCommerce) is a popular e-Commerce and online store-management software program that may be easily used on any web server with PHP and MySQL installed. osCommerce is available to users as a free software under the General Public License (GNU) The versatile and fuss-free software enables easy setting up and maintenance of e-stores using minimal effort. This tutorial describes the process of installing osCommerce on Ubuntu 14.04.

December Tip of the Month: Find Queries that Lack Indexes
+0 Vote Up -0Vote Down

It’s an ancient tradition amongst MySQL DBAs to analyze slow query log files and sort the results by the so-called “index ratio” to find badly indexed queries. The “index ratio,” in this case, is a heuristic derived from the ratio of rows read to rows returned. The thinking goes that if a query is reading lots of rows and returning only a few, it might be missing an index.

The trouble with this is that it’s very prone to false positives: GROUP BY queries, for example, will often read lots of rows and aggregate them into few.

Instead of relying on a surrogate measure such as this sometimes-accidentally-right ratio, why not get the …

  [Read more...]
5 reasons to move data to Amazon Redshift
+0 Vote Up -0Vote Down

Join 28,000 others and follow Sean Hull on twitter @hullsean. Amazon is rolling out new database offerings at a rapid clip. I wondered Did MySQL and Mongodb just have a beautiful baby called Aurora? That was last month. Another that’s been out for a while is the data warehouse offering called RedShift. 1. old-fashioned SQL […]

Galera Cluster for MySQL vs MySQL (NDB) Cluster: A High Level Comparison - Webinar Replay & Slides
+0 Vote Up -0Vote Down

December 16, 2014 By Severalnines

 

Thanks to everyone who attended and participated in last week’s webinar on 'Galera Cluster for MySQL vs MySQL (NDB) Cluster: A High Level Comparison'. If you missed the sessions or would like to watch the webinar again & browse through the slides, they are now available online.

 

In this webinar, Severalnines VP of Products, Alex Yu, who was part of the team at Ericsson who originally developed the NDB storage engine in 2001, gave an overview of the two clustering architectures and discussed their respective strengths and …

  [Read more...]
10 Newer Entries Showing entries 11 to 20 of 33584 10 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.