Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 41 to 50 of 33583 10 Older Entries
What happens when your application cannot open yet another connection to MySQL
+2 Vote Up -0Vote Down

Have you ever experienced a situation where one moment you can connect to the MySQL database and the next moment  you cannot, only to be able to connect again a second later? As you may know one cannot open infinite connections with MySQL. There’s a practical limit and more often than not it is imposed by the underlying operating system. If you’re getting:

ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.0.10' (99)

…there’s a good chance you’re hitting such limit. What might be misleading in the information above is whom (which side) is preventing the connection from …

  [Read more...]
Global Counters And Average Patient Temperature
+0 Vote Up -0Vote Down

Our recent blog post on finding wasted prepare/execute/close cycles showed how per-statement analysis can find individual queries that are not being repeatedly executed after being prepared. To recap, we found a number of statements in our own application that were being prepared, executed, and then never re-executed. This means 3 network round-trips instead of just executing the statement directly, which takes only 1 round-trip. By fixing this, we materially decreased load on our …

  [Read more...]
#DBHangOps 12/11/14 -- Mixing Metadata with Data, InnoDB Compression, and more!
+0 Vote Up -0Vote Down

#DBHangOps 12/11/14 -- Mixing Metadata with Data, InnoDB Compression, and more!

Hello everybody!

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

  • Mixing Metadata and Data (requested by Shlomi Noach)

    • E.g. schema representing some data instead of metadata
  • InnoDB Compression (requested by John Cesario)

    • How did you performance tune it for MySQL 5.6?
    • Expected metrics changes when …
  [Read more...]
If Eventual Consistency Seems Hard, Wait Till You Try MVCC
+4 Vote Up -0Vote Down

This should sound familiar:

One of the great lies about NoSQL databases is that they’re simple. Simplicity done wrong makes things a lot harder and more complicated to develop and operate. Programmers and operations staff end up reimplementing (badly) things the database should do.

Nobody argued this line of reasoning more vigorously than when trying to defend relational databases, especially during the darkest years (ca. 2009-2010), when NoSQL still meant NO SQL DAMMIT, all sorts of NoSQL databases were sprouting, and most of them were massively overhyped.

But as valid as those arguments against NoSQL’s …

  [Read more...]
General Purpose Storage Engines in MariaDB
+1 Vote Up -0Vote Down

MariaDB tries to encourage use of many storage engines, which Oracle doesn't bother with. The ones that could be considered -- occasionally! -- as InnoDB replacements are: Mroonga, TokuDB, and Aria.

Mroonga

I predicted that Mroonga would be in MariaDB 10.0.8, and behold, here it is in MariaDB 10.0.15. Truly I am the Nostradamus of the database world.

It's a general-purpose storage engine, in that it doesn't have serious limitations regarding what can be stored or indexed. I think its "column-store" feature has limited appeal, but as I saw …

  [Read more...]
A Free Tutorial On Go's Database/SQL Package
+1 Vote Up -0Vote Down

Do you use Google’s Go language (golang)? Do you use a relational database such as MySQL or PostgreSQL with it? Do you want to learn how to?

Go has a package called database/sql for connecting to relational databases. There’s package documentation, but you’ll need to read the source code if you really want to understand how to use the package. The documentation doesn’t really explain how to use the package, it just explains what it does.

Fortunately, there’s a free, online, opensource tutorial that fills this need. If you haven’t read it, I highly …

  [Read more...]
Using MySQL Sandbox to test replication behavior
+2 Vote Up -0Vote Down

It is easy to set up a replication topology with MySQL Sandbox, and I use it for lots of testing scenarios. For example I used MySQL Sandbox to run the tests for yeterday's post about the way UUIDs are replicated in row-based replication (RBR) versus statement-based replication (SBR).

Here's how easy it is to set up a replicated sandbox for testing:

Installing MySQL Sandbox

If you've never installed MySQL Sandbox before, you can do so by …

  [Read more...]
Where is the Language Data?
+1 Vote Up -0Vote Down

Image if you will,  a geographic database of locations and the language/s spoken there with keys to a dictionary of common words with keys the same word in all other languages.   And again image this database was like a wiki, so it could crowd sourced.  You could put in your own home and “English spoken here”.  And maybe this database would have keys to the words spoken in each language.

If there was an API for this database you could do simple application language translations.  Programs would not need to code tables for translations.  The “PUSH” or “OK” button would just have a key to that word.  A web app …

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

Another centurion mark achieved by the Log Buffer as it reaches 400. Freshness and uniqueness of Log Buffer still is as youthful as was with the edition 1. Enjoy the gems of Oracle, SQL Server and MySQL.

Oracle:

What Cloud Infrastructure Will Best Deliver?

Adaptive Case Management 12c and ADF Human Tasks.

What Does “Backup Restore …

  [Read more...]
Simple Backup Management of Galera Cluster using s9s_backup
+0 Vote Up -0Vote Down

December 8, 2014 By Severalnines

Percona XtraBackup is a great backup tool with lots of nice features to make online and consistent backups, although the variety of options can be a bit overwhelming. s9s_backup tries to make it simpler for users, it creates an easy to use interface for XtraBackup features such as full backups, incremental backups, streaming/non-streaming, and parallel compression.

Backups are organized into backup sets, consisting of a full backup and zero or more incremental backups. s9s_backup manages …

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