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

Displaying posts with tag: mysql (reset)

Fresh Japanese translations online!
Employee +0 Vote Up -0Vote Down

Look here:

MySQL 5.6 リファレンスマニュアル (含むMySQL Cluster 7.3-7.4マニュアル)
 http://dev.mysql.com/doc/refman/5.6/ja/index.html
MySQL Enterprise Monitor 3.0.18 マニュアル
 http://dev.mysql.com/doc/mysql-monitor/3.0/ja/index.html
MySQL Enterprise Backup ユーザーズガイド (バージョン 3.11.1)
 http://dev.mysql.com/doc/mysql-enterprise-backup/3.11/ja/index.html

  [Read more...]
MariaDB 10.1.5 now available
+0 Vote Up -0Vote Down

Download MariaDB 10.1.5

Release Notes Changelog What is MariaDB 10.1?

MariaDB APT and YUM Repository Configuration Generator

The MariaDB project is pleased to announce the immediate availability of …

  [Read more...]
The InnoDB Change Buffer
Employee_Team +1 Vote Up -0Vote Down

One of the challenges in storage engine design is random I/O during a write operation. In InnoDB, a table will have one clustered index and zero or more secondary indexes.  Each of these indexes is a B-tree.  When a record is inserted into a table, the record is first inserted into clustered index and then into each of the secondary indexes.  So, the resulting I/O operation will be randomly distributed across the disk.  The I/O pattern is similarly random for update and delete operations. To mitigate this problem, the InnoDB storage engine uses a special data structure called the …

  [Read more...]
High availability using MySQL in the cloud
+0 Vote Up -0Vote Down

Next Wednesday (June 10) I’ll be co-presenting a webinar on using MySQL in the cloud for High Availability (HA). Joining me will be 451 Research analyst Jason Stamper and together we’ll talk about the realities of HA using MySQL in the cloud and how vendors are responding to changing application requirements with new developments that can enhance your deployment.

We’ll also present a comparison of available solutions along with key best practices you can follow for successfully attaining HA in the cloud with MySQL. The webinar is …

  [Read more...]
Percona XtraDB Cluster 5.6.24-25.11 is now available
+0 Vote Up -0Vote Down

Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on June 3rd 2015. Binaries are available from downloads area or from our software repositories.

Based on Percona Server

  [Read more...]
MySQL as an Oracle DBA
Employee_Team +0 Vote Up -0Vote Down

A quick question, which I’ve asked once before –

if you were an Oracle DBA, then learned MySQL, what do you wish you knew before you got started?

Also, what was helpful to you as you learned?  (Websites, #mysql on irc, documents, etc.)  What do you wish you had (or want to have now) if you are a DBA for both Oracle databases and MySQL databases?

Ie, what would be good to give an Oracle DBA who wants to start learning or supporting MySQL as well?  Please respond with comments here, or directly email me at ben-dot-krug-at-oracle-dot-com.

Thanks!


Optimizing Percona XtraDB Cluster for write hotspots
+0 Vote Up -0Vote Down

Some applications have a heavy write workload on a few records – for instance when incrementing a global counter: this is called a write hotspot. Because you cannot update the same row simultaneously from multiple threads, this can lead to performance degradation. When using Percona XtraDB Cluster (PXC), some users try to solve this specific issue by writing on multiple nodes at the same time. Good idea or bad idea? Read on!

Simultaneous writes on a standalone InnoDB server

Say you have these 3 transactions being run …

  [Read more...]
Using Perl and MySQL to Automatically Respond to Retweets on Twitter
Employee_Team +1 Vote Up -0Vote Down

In my previous post, I showed you a way to store tweets in MySQL, and then use Perl to automatically publish them on Twitter.

In this post, we will look at automatically sending a “thank you” to people who retweet your tweets — and we will be using Perl and MySQL again.

Just like in the first post, you will need to register your application with Twitter via apps.twitter.com, and obtain the following:

consumer_key …
  [Read more...]
Is 80% of RAM how you should tune your innodb_buffer_pool_size?
+0 Vote Up -0Vote Down

It seems these days if anyone knows anything about tuning InnoDB, it’s that you MUST tune your innodb_buffer_pool_size to 80% of your physical memory. This is such prolific tuning advice, it seems engrained in many a DBA’s mind.  The MySQL manual to this day refers to this rule, so who can blame the DBA?  The question is: does it makes sense?

What uses the memory on your server?

Before we question such advice, let’s consider what can take up RAM in a typical MySQL server in their broad …

  [Read more...]
Setup and configure MySQL backup using Holland and Xtrabackup
+0 Vote Up -0Vote Down

Setting up a database backup is a primary task for database administrators and we see perl and shell scripts wrapped around few of the backup-tools in practice. With right tools things can look easy and today we shall look into one of that! MySQL Database backup can be done with mysqldump, mysqlhotbackup, xtrabackup, lvm / […]

10 Newer Entries Showing entries 61 to 70 of 17050 10 Older Entries

Planet MySQL © 1995, 2015, 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.