Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 71 to 80 of 34574 10 Older Entries
Comment on Some Fun with MySQL’s History List by Andreas
+0 Vote Up -0Vote Down

I think you’ve made an error in adding seconds and milliseconds:

> I have to add the 12ms to the 0.002, which will give us 0.122 sec.

12ms = 0.012s

0.002s ( =2ms)
+0.012s (=12ms)
——-
0.014s

that’s nearly 9 times less!

Percona Live Europe 2015! Call for speakers; registration open
+0 Vote Up -0Vote Down

Percona Live is moving from London to Amsterdam this year and the event is also expanding to three full days. Percona Live Europe 2015, September 21-23, will be at the Mövenpick Hotel Amsterdam City Centre. The call for speakers and Super Saver  …

  [Read more...]
#DBHangOps 06/11/15 -- DBA Expectations and Automation
+0 Vote Up -0Vote Down

#DBHangOps 06/11/15 -- DBA Expectations and Automation

Hello everybody!

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

  • What does being a DBA mean to you?

    • What are your expectations of a DBA?
  • What's the last thing you automated and why?

You can check out the event page at https://plus.google.com/events/ctmk6ua93affd01jnfmm73i68fo on Thursday to …

  [Read more...]
Hash-based workarounds for MySQL unique constraint limitations
+1 Vote Up -0Vote Down

In the past I have written about MySQL's limitations that prevent you from creating an index over a certain length, or with more than a certain number of columns. I've offered some solutions for those problems, but many of my solutions hit another limit further down the line. For example …

  [Read more...]
Replicate MySQL to Amazon Redshift with Tungsten: The good, the bad & the ugly
+1 Vote Up -0Vote Down

Heterogenous replication involves moving data from one database platform to another. This is a complicated endevour because datatypes, date & time formats, and a whole lot more tend to differ across platforms. In fact it’s so complex many enterprises simply employ a commercial solution to take away the drudgery. Join 31,000 others and follow Sean […]

Indexing MySQL JSON Data
Employee +2 Vote Up -0Vote Down

“MySQL’s JSON data type is great! But how do you index the JSON data?” I was recently presenting at the CakePHP Cakefest Conference and was asked that very question. And I had to admit I had not been able to play, er, experiment with the JSON datatype to that level. Now I have and it is fairly easy.

1. Create a simple table
mysql> desc colors;
+--------------+----------+------+-----+---------+-------------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+----------+------+-----+---------+-------------------+
| popular_name | char(10) | YES | | NULL | |
| …





  [Read more...]
Improving the Performance of MySQL on Windows
Employee_Team +2 Vote Up -0Vote Down

In this blog entry I’d like to describe how you might be able to improve how MySQL performs on Windows by ensuring that you take advantage of a Windows specific configuration setting.

On Unix systems, MySQL programs treat the localhost host name specially. For connections to localhost, MySQL programs attempt to connect to the local server by using a Unix socket file, which has some performance advantages over a TCP/IP connection. Windows does not support Unix sockets, however, and hence does not benefit from this optimisation.

However, the use of …

  [Read more...]
Auditing MySQL with McAfee and MongoDB
+1 Vote Up -0Vote Down

Greetings everyone! Let’s discuss a 3rd Party auditing solution to MySQL and how we can leverage MongoDB® to make sense out of all of that data.

The McAfee MySQL Audit plugin does a great job of capturing, at low level, activities within a MySQL server. It does this through some non-standard APIs which is why installing and configuring the plugin can be a bit difficult. The audit information is stored in JSON format, in a text file, by default.

There is 1 JSON object for each action that takes place within MySQL. If a user logs in, there’s an object. If that user queries a table, there’s an object. Imagine 1000 active …

  [Read more...]
Improved User Parsing From The MySQL Protocol
+0 Vote Up -0Vote Down

This isn’t really a feature we should brag about, because it’s a bug that took us a while to figure out, but we believe in sharing the bad as well as the good. There’s a lot to learn from TCP reassembly and protocol reverse engineering!

We received a request from a customer to help track down the user that was sending some queries to their database. Normally we can find this information easily: the user is one of the properties of query samples, and we can just click on a sample and see it. But for this particular customer, the user was always unknown_user.

This means we weren’t able to figure out what database …

  [Read more...]
JSON and the MySQL Argonauts
Employee +1 Vote Up -0Vote Down

The MySQL 5.7.7 JSON lab release has been getting a lot of attention. At a recent conference, I was cornered by a developer who wanted to jump in with both feet by running this release on his laptop on the flight home. However the developer was not sure how to begin.

1. Down load the MySQL JSON release from http://labs.mysql.com/. You will get the choice of a Linux binary or source code. Please grab the binary if you are using Linux and un-gzip/tar the download.

2. Shut down the current running version of MySQL. I was lucky in …

  [Read more...]
10 Newer Entries Showing entries 71 to 80 of 34574 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.