Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 48 10 Older Entries

Displaying posts with tag: Server Tuning (reset)

OurSQL Episode 180: Sharing the Load
+0 Vote Up -0Vote Down

This week we talk to Justin Swanhart about Shard-Query, a massively parallel processing query engine for MySQL. Ear candy is about mydumper, and At the Movies is "Common Deadly MySQL Development Mistakes."

Events
Percona Live
DB Hangops - every other Wednesay at noon Pacific time
Upcoming MySQL events (http://www.mysql.com/news-and-events/events/)

Training
SkySQL Trainings

read more

OurSQL Episode 172: A New Proxy
+0 Vote Up -0Vote Down

This week, we talk with Ivan Zoratti of SkySQL about MaxScale, a new MySQL proxy. Ear Candy is about accidentally removing a dependent package, and At the Movies is a DB Hangops recording of MaxScale, replication saturation and monitoring.

Events
DB Hangops - every other Wednesay at noon Pacific time
Upcoming MySQL events, including Tech Tours (http://www.mysql.com/news-and-events/events/)

Training
SkySQL Trainings
Tungsten University trainings

read more

OurSQL Episode 166: Top Hat Options
+1 Vote Up -0Vote Down

This week we discuss fine-tuning Galera Cluster. In this week's ear candy we talk about recent changes to mysqldump and locking; At the Movies presents "Using Amazon Web Services for MySQL at Scale".

Events
DB Hangops - every other Wednesay at noon Pacific time
FOSDEM 2014 - Sat February 1 - Sun February 2 in Brussels, Belgium.
Upcoming MySQL events (http://www.mysql.com/news-and-events/events/)

Training
SkySQL Trainings

read more

OurSQL Episode 165: Top Hat Cluster
+0 Vote Up -0Vote Down

This week we talk about how to install and set up Galera Cluster. Ear Candy talks about the new MySQL repos from Oracle and what to know about using them; At the Movies is Michael Stonebreaker talking about how to process today's big data transactional processing needs.

Galera Cluster
Codership documentation of Galera Cluster
Installing Percona XtraDB Cluster on Ubuntu documentation
MariaDB's Galera Cluster documentation

read more

OurSQL Episode 145: Biblical Tools, part 3
+3 Vote Up -0Vote Down

This week we finish up talking about the Openark Kit for MySQL. Ear Candy is using both --master-data and --tab with mysqldump, and At the Movies features Robert Hodges of Continuent presenting Scalable MySQL Operation in the Cloud with Continuent Tungsten.

Openark Kit series:
Part 1
Part 2

Openark Kit
oak-purge-master-logs
PURGE BINARY LOGS at the MySQL manual page.

read more

OurSQL Episode 139: Starting to Perform
+1 Vote Up -0Vote Down

This week we discuss the basics of using the performance schema in MySQL 5.5 and 5.6. Ear Candy is about a temporal gotcha when using dates and times that do not exist, and At the Movies is David Stokes giving some useful for System Administrators who also are in a DBA role.

News
Continuent's Tungsten Replicator is now completely open source
TokuDB is now open source

read more

OurSQL Episode 138: The Relevance of Tungsten
+2 Vote Up -0Vote Down

This week we discuss Tungsten and MySQL 5.6 replication with friend of the show, Giuseppe Maxia (aka the Data Charmer). Ear Candy is MariaDB's Cassandra storage engine, and At the Movies is Giuseppe's "MySQL 5.6 Replication – features and usability" video from Open Database Camp.

Events
DB Hangops in May will be Wed May 8th and 22nd.
Upcoming MySQL tech tours (http://www.mysql.com/news-and-events/events/)

Training
SkySQL Trainings
Tungsten University trainings

read more

OurSQL Episode 136: Digging for Information
+1 Vote Up -0Vote Down

We discuss INFORMATION_SCHEMA with plenty of examples on useful queries. In this week's Ear Candy, we talk about resident versus virtual memory on Linux, and in At the Movies has a video about MongoDB.

Events
DB Hangops in May will be Wed May 8th and 22nd noon pacific time.
Upcoming MySQL tech tours (http://www.mysql.com/news-and-events/events/)

Training
SkySQL Trainings
Tungsten University trainings

read more

OurSQL Episode 135: Another Kind of Buffer
+1 Vote Up -0Vote Down

This week, we explain the InnoDB and Memcached integration in MySQL 5.6. Ear Candy is about the nonexistent 2-step deadlock detection in MariaDB and At the Movies is Colin Charles talking about the features of MariaDB 10.

InnoDB and memcached in MySQL 5.6
memcached official page
InnoDB integration with memcached MySQL manual page
History of the term NoSQL
setting up the InnoDB memcached plugin in MySQL 5.6

read more

OurSQL Episode 133: MySQL on Auto-Tune
+2 Vote Up -0Vote Down

This week, we talk about variables with changed default values in MySQL 5.6. Ear Candy is the pt-config-diff tool and At the Movies is Tim Callaghan of Tokutek talking about Fractal Trees.

Changed Defaults in MySQL 5.6

Percona's article about default variable differences in MySQL 5.5 and MySQL 5.6

MySQL 5.6 manual page about changes to server defaults in MySQL 5.6.

back_log

read more

Showing entries 1 to 10 of 48 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.