Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 41 to 50 of 33897 10 Older Entries
MySQL - The Slotted Counter Pattern
+0 Vote Up -0Vote Down

It is a common database pattern to increment an INT column when an event happens, such as a download. Early last year at GitHub we started encountering issues with slow UPDATES to these types of counters.

You can go far with this pattern until bursts of these types of events happen in parallel and you experience contention on a single row. When multiple transactions are trying to update the counter you are essentially forcing these transactions to run serially which is bad for concurrency.

You can see here a dramatic increase in query time when a burst like this occurred:

To avoid problems like this we had to do this kind of counting differently. We …

  [Read more...]
Identifying useful info from MySQL row-based binary logs
+0 Vote Up -0Vote Down

As a MySQL DBA/consultant, it is part of my job to decode the MySQL binary logs – and there are a number of reasons for doing that. In this post, I’ll explain how you can get the important information about your write workload using MySQL row-based binary logs and a simple awk script.

First, it is important to understand that row-based binary logs contain the actual changes done by a query. For example, if I run a delete query against a table, the binary log will contain the rows that were deleted. MySQL provides the mysqlbinlog utility to decode the events stored in MySQL binary logs. You can read more about …

  [Read more...]
How to Deploy High Availability CloudStack with MariaDB Galera Cluster
+0 Vote Up -0Vote Down

January 20, 2015 By Severalnines

Apache CloudStack is a turnkey orchestration platform to deliver IaaS clouds. As a cloud infrastructure scales to hundreds or thousands of servers, with production environments supporting multiple applications and services, high availability becomes a key requirement. Just as for OpenStack, it is possible to deploy the CloudStack management server in a multi-node installation. Since the management server uses a MySQL database to store the state of all its …

  [Read more...]
Case Study: VividCortex Helps PayLease Manage Massive Amounts of Data
+0 Vote Up -0Vote Down

PayLease is the leading online payment processor for property managers and HOAs. The company serves thousands of property management clients across the United States and was seeking a solution to help them better manage their massive amount of data and minimize slow periods.

Before VividCortex, they had to sort through nearly 10 gigabytes of data each time there was an issue, a cumbersome process that often proved ineffective. PayLease also wanted a tool that would better equip them to prevent future issues. They needed a predictive solution to flag issues that could become high priority down the road.

PayLease …

  [Read more...]
Architecture of data warehouse which is based on MQ
+0 Vote Up -0Vote Down

Recently, we create a mysql data warehouse which is based on message queue.

Most companies must prepare for particular queries in their systems if they consider to split their databases or tables into many pieces.

some problems should be solved in this situation:

1. how to get correct results in-time
2. how to build strong data warehouse for future analyst

These policies were used by YHD

They have already deployed a middle-ware …


  [Read more...]
Log Buffer #405, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

This Log Buffer Edition rides on the wave of new ideas in the database realms. From Oracle technologies through MySQL to the SQL Server, things are piping hot.

Oracle:

The Call for Papers for the Rittman Mead BI Forum 2015 is currently open, with abstract submissions open to January 18th 2015.

The replicat process is the apply process within the Oracle …

  [Read more...]
#DBHangOps 01/22/15 -- MySQL Event Scheduler, InnoDB IO Capacity, and more!
+0 Vote Up -0Vote Down

#DBHangOps 01/22/15 -- MySQL Event Scheduler, InnoDB IO Capacity, and more!

Hello everybody!

Join in #DBHangOps this Thursday, January, 22, 2015 at 11:00am pacific (18:00 GMT), to participate in the discussion about:

  • MySQL Event Scheduler

    • What use cases do you have?
  • What is everyone's understanding of innodb_io_capacity?
  • Percona Live MySQL Conference and Expo 2015

    • What are you excited about?

You can check out the …

  [Read more...]
#DBHangOps 02/05/15 -- MySQL Event Scheduler, InnoDB IO Capacity, and more!
+0 Vote Up -0Vote Down

#DBHangOps 02/05/15 -- MySQL Event Scheduler, InnoDB IO Capacity, and more!

Hello everybody!

Join in #DBHangOps this Thursday, February, 5, 2015 at 11:00am pacific (18:00 GMT), to participate in the discussion about:

  • MySQL Event Scheduler

    • What use cases do you have?
  • What is everyone's understanding of innodb_io_capacity?
  • Percona Live MySQL Conference and Expo 2015

    • What are you excited about?

You can check out the …

  [Read more...]
Jörg Brühe: Introducing Myself: Jörg Brühe
+2 Vote Up -0Vote Down

For some time already, FromDual's "Our Team" page lists me, and it even reveals that I joined in September, 2014. Also for some time, the list of FromDual blogs contains an entry "Jörg's Blog", but it doesn't lead to any entries. It is high time to fix this and create entries, starting with an introduction of myself.

Often, in such introductions people use the phrase of "the new kid on the block". I won't. If I am to use those words, I will arrange them as "the kid on the new block". The reason is that I don't feel as a new kid in the MySQL village (or is it a city?), let alone in DBMS country.

Ever since I left university (Technical University of Berlin, Germany), I have …

  [Read more...]
Looking deeper into InnoDB’s problem with many row versions
+0 Vote Up -0Vote Down

A few days ago I wrote about MySQL performance implications of InnoDB isolation modes and I touched briefly upon the bizarre performance regression I found with InnoDB handling a large amount of versions for a single row. Today I wanted to look a bit deeper into the problem, which I also filed as a bug.

First I validated in which conditions the problem happens. It seems to happen only in REPEATABLE-READ isolation mode and only …

  [Read more...]
10 Newer Entries Showing entries 41 to 50 of 33897 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.