はてなブックマーク

• あとで読む

  Percona Playback 0.6 for MySQL now available

  7 users

  mysqlperformanceblog.com

  Percona is glad to announce the release of Percona Playback 0.6 for MySQL on April 9, 2013. Downloads are available from our download site and Percona Software Repositories. Percona Playback for MySQL is a tool for replaying the load of one database server to another. Currently it can read queries from MySQL query-log and MySQL tcpdump files and run them on other MySQL server. With Percona Playbac

  • テクノロジー
  • 2013/04/10 07:33

  • mysql
  • db
  • *あとで
• あとで読む

  MySQL 5.6 - InnoDB Memcached Plugin as a caching layer

  15 users

  mysqlperformanceblog.com

  All of Percona’s open-source software products, in one place, to download as much or as little as you need.

  • テクノロジー
  • 2013/03/30 16:16

  • mysql
  • memcached
  • benchmark
• あとで読む

  Is MySQL 5.6 slower than MySQL 5.5?

  28 users

  mysqlperformanceblog.com

  There have been a number reports/benchmarks showing MySQL 5.6 to be slower than MySQL 5.5 on variety of workloads. There are many possible reasons and I believe we will learn about many of them in the next few weeks and months as MySQL 5.6 is starting to get production battle-tested and there is inflow of real world production performance data hitting MySQL Support Team at Oracle. For a number of

  • テクノロジー
  • 2013/02/19 05:44

  • mysql
  • performance
  • memo
  • *あとで
• あとで読む

  How to create/restore a slave using GTID replication in MySQL 5.6

  3 users

  mysqlperformanceblog.com

  All of Percona’s open-source software products, in one place, to download as much or as little as you need.

  • テクノロジー
  • 2013/02/10 11:13

  • MySQL
• あとで読む

  Home

  6 users

  mysqlperformanceblog.com

  All of Percona’s open-source software products, in one place, to download as much or as little as you need.

  • テクノロジー
  • 2013/01/21 23:24

  • mysql
  • linux
• あとで読む

  Full Table Scan vs Full Index Scan Performance

  3 users

  mysqlperformanceblog.com

  All of Percona’s open-source software products, in one place, to download as much or as little as you need.

  • テクノロジー
  • 2012/11/24 21:46
• あとで読む

  Replaying database load with Percona Playback

  3 users

  mysqlperformanceblog.com

  If you are planning to upgrade or make any configuration change on your MySQL database the first advice usually is: – Benchmark! How should we do that benchmark? People usually run generic benchmark tools like sysbench, tpcc or mysqlslap that are good to know the number of transactions per seconds that a database can do but it doesn’t care about your workload, data set or queries. Those tools just

  • テクノロジー
  • 2012/10/26 14:05

  • MySQL
• あとで読む

  L2 cache for MySQL

  5 users

  mysqlperformanceblog.com

  The idea to use SSD/Flash as a cache is not new, and there are different solutions for this, both OpenSource like L2ARC for ZFS and Flashcache from Facebook, and proprietary, like directCache from Fusion-io. They all however have some limitations, that’s why I am considering to have L2 cache on a database level, as an extension to InnoDB buffer pool. Fortunately, there is a project in progress Fla

  • テクノロジー
  • 2012/10/26 12:01

  • mysql
• あとで読む

  Review of MySQL 5.6 Defaults Changes

  7 users

  mysqlperformanceblog.com

  James Day just posted the great summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there are a lot of good changes and many defaults are now computed instead of hardcoded. Though some of changes are rather puzzling for me. Lets go over them: back_log = 50 + ( max_connections / 5 ) capped at 900 – The large backlog is needed when there is a high rate (spikes) of connections w

  • テクノロジー
  • 2012/10/09 18:04

  • mysql
  • *あとで
• あとで読む

  Using MySQL OPTIMIZE tables for InnoDB? Stop!

  3 users

  mysqlperformanceblog.com

  Innodb/XtraDB tables do benefit from being reorganized often. You can get data physically laid out in primary key order as well as get a better feel for the primary key and index pages, and so use less space, it’s just that MySQL OPTIMIZE TABLE might not be the best way to do it. Why you shouldn’t necessarily optimize tables with MySQL OPTIMIZEIf you’re running Innodb Plugin on Percona Server with

  • テクノロジー
  • 2012/09/21 16:20

  • mysql
• あとで読む

  Fusion-io atomic writes and DirectFS

  4 users

  mysqlperformanceblog.com

  All of Percona’s open-source software products, in one place, to download as much or as little as you need.

  • テクノロジー
  • 2012/09/21 12:26

  • DB
  • MySQL
  • *あとで
• あとで読む

  Logging Deadlock errors

  5 users

  mysqlperformanceblog.com

  All of Percona’s open-source software products, in one place, to download as much or as little as you need.

  • テクノロジー
  • 2012/09/20 20:13

  • mysql
  • tips
• あとで読む

  The Math of Automated Failover

  3 users

  mysqlperformanceblog.com

  There are number of people recently blogging about MySQL automated failover, based on production incident which GitHub disclosed. Here is my take on it. When we look at systems providing high availability we can identify 2 cases of system breaking down. First is when the system itself has a bug or limitations which does not allow it to take the right decision. Second is the configuration issue – w

  • テクノロジー
  • 2012/09/19 09:17

  • *あとで
• あとで読む

  Actively monitoring replication connectivity with MySQL's heartbeat

  6 users

  mysqlperformanceblog.com

  Until MySQL 5.5 the only variable used to identify a network connectivity problem between Master and Slave was slave-net-timeout. This variable specifies the number of seconds to wait for more Binary Logs events from the master before abort the connection and establish it again. With a default value of 3600 this has been a historically bad configured variable and stalled connections or high latenc

  • テクノロジー
  • 2012/09/09 13:39

  • mysql
  • *あとで
• あとで読む

  Intel SSD 910 in tpcc-mysql benchmark

  5 users

  mysqlperformanceblog.com

  All of Percona’s open-source software products, in one place, to download as much or as little as you need.

  • テクノロジー
  • 2012/09/08 01:51

  • SSD
  • MySQL
• あとで読む

  ALTER TABLE: Creating Index by Sort and Buffer Pool Size

  3 users

  mysqlperformanceblog.com

  All of Percona’s open-source software products, in one place, to download as much or as little as you need.

  • テクノロジー
  • 2012/06/28 09:18

  • mysql
• あとで読む

  Announcing Percona XtraBackup 2.0.1

  3 users

  mysqlperformanceblog.com

  All of Percona’s open-source software products, in one place, to download as much or as little as you need.

  • テクノロジー
  • 2012/06/26 21:59

  • MySQL
• あとで読む

  DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL

  4 users

  mysqlperformanceblog.com

  Suppose you have turned on innodb_file_per_table (which means that each table has its own tablespace), and you have to drop tables in a background every hour or every day. If its once every day then you can probably schedule the table dropping process to run during off-peak hours. But I have seen cases where the tables had to be dropped more frequently (like every other hour), or when there was no

  • テクノロジー
  • 2012/06/25 10:19

  • mysql
• あとで読む

  Percona XtraDB Cluster reference architecture with HaProxy

  3 users

  mysqlperformanceblog.com

  All of Percona’s open-source software products, in one place, to download as much or as little as you need.

  • テクノロジー
  • 2012/06/21 09:44

  • mysql
• あとで読む

  Building Indexes by Sorting In Innodb (AKA Fast Index Creation)

  3 users

  mysqlperformanceblog.com

  All of Percona’s open-source software products, in one place, to download as much or as little as you need.

  • テクノロジー
  • 2012/06/20 09:58

  • MySQL
• あとで読む

  Percona Toolkit versions 2.0.5 and 2.1.2 released

  5 users

  mysqlperformanceblog.com

  All of Percona’s open-source software products, in one place, to download as much or as little as you need.

  • テクノロジー
  • 2012/06/13 10:08

  • mysql
• あとで読む

  read_buffer_size can break your replication

  3 users

  mysqlperformanceblog.com

  There are some variables that can affect the replication behavior and sometimes cause some big troubles. In this post I’m going to talk about read_buffer_size and how this variable together with max_allowed_packet can break your replication. The setup is a master-master replication with the following values: max_allowed_packet = 32M read_buffer_size = 100M To break the replication I’m going to loa

  • テクノロジー
  • 2012/06/07 07:47

  • ifttt
• あとで読む

  Data Compression in InnoDB for Text and Blob Fields

  3 users

  mysqlperformanceblog.com

  All of Percona’s open-source software products, in one place, to download as much or as little as you need.

  • テクノロジー
  • 2012/05/31 16:43

  • mysql
• あとで読む

  Binary log file size matters (sometimes)

  3 users

  mysqlperformanceblog.com

  All of Percona’s open-source software products, in one place, to download as much or as little as you need.

  • テクノロジー
  • 2012/05/27 11:37

  • MySQL
  • ifttt
• あとで読む

  How to Change innodb_log_file_size

  3 users

  mysqlperformanceblog.com

  All of Percona’s open-source software products, in one place, to download as much or as little as you need.

  • テクノロジー
  • 2011/07/11 00:11

  • innodb
  • mysql
• あとで読む

  MySQL Connection Timeouts

  3 users

  mysqlperformanceblog.com

  All of Percona’s open-source software products, in one place, to download as much or as little as you need.

  • テクノロジー
  • 2011/07/09 14:46

  • mysql
  • linux
• あとで読む

  MySQL Performance Blog � What to tune in MySQL Server after installation

  39 users

  mysqlperformanceblog.com

  Tuning For Your HardwareDepending on the hardware you have installed MySQL on, some variables need to be set based on the machine (or VM) specifications. The following variables are largely dependent on your hardware: innodb_buffer_pool_size Generally, set to 50% – 70% of your total RAM as a starting point. It does not need to be set any larger than the total database size.innodb_log_file_size Thi

  • 暮らし
  • 2006/09/30 09:17

  • mysql
  • tuning
  • performance
  • パフォーマンス
  • チューニング
  • db
• あとで読む

  MySQL Performance Blog � APC or Memcached

  4 users

  mysqlperformanceblog.com

  A while back I did Cache Performance Comparison for LAMP Stack. Looking at this data you can see memcached is about 5 times as slow as APC, and this is with tests done on localhost – with network difference is going to be larger, even with fastest network. Such latency can add up especially if you’re, being lazy “P” Developer, request objects from cache one by one rather than fetching all items yo

  • テクノロジー
  • 2006/09/28 18:32

  • memcached
  • APC
  • MySQL

次のページ