A few days I wrote a bit on my first results of comparing
MySQL with MongoDB as a Key-Value Store, something that has been
going on for way to long, but I am not finished yet. Last time I
used MySQL Embedded Library to bypass the MySQL Client Server
protocol to see what the overhead was, and the result was that it
is big (and again, note that the same networking was used with
MongoDB and I was also using Unix Domain Sockets, as well as
plain TCP/IP, so don't ask me to fix any network issues I might
have). Using Embedded Server with InnoDB was actually faster than
using MongoDB, some 3 times faster compared to using the client /
server protocol.
That one out of the way, I now wanted to see what I could get if
I used the storage engine that was fastest in Client / Server
mode, MEMORY. That took a while to fix, as to have an …
Taxonomy upgrade extras: galeraclusterMySQL Clusterchannelfail-overreplication
During and after Henriks great talk about Galera Cluster at the FrOSCon 2012 in St. Augustin we found 2 important things related to Galera Cluster for MySQL:
- The InnoDB double write buffer (
…
Want to leverage the high-speed load utilities, distinctive memory caches, full text indexes, and other performance-enhancing mechanisms that MySQL offers to fuel today's critical business systems.
The authentic MySQL Performance Tuning course, in 4 days, teaches you to evaluate the MySQL architecture, learn to use the tools, configure the database for performance, tune application and SQL code, tune the server, examine the storage engines, assess the application architecture, and learn general tuning concepts.
You can take this course in one the following three ways:
- Training-on-Demand: Access the streaming video, instructor delivery of this course from your own desk, at your own pace. Book time for hands-on practice when it suits you.
- Live-Virtual Class: Take this …
Linuxcon is next week in San Diego and I will be speaking on The Proper Care and Feeding of a MySQL Database for Linux System Administrators. I will be in the Oracle booth with SWAG — and I hope to see you there!.
The Children’s pool used to be one of my favorite places to SCUBA dive before seals and sea lions took over. A nice two knot rip current was like an escalator out past the sea wall to some very interesting reefs off shore.
I was in San Diego a few weeks ago and can report the best pizza is at Fillipi’s in the near by Little Italy Section, the best food with a view is at C-level, and you should try to see the Cactus garden opposite the famous zoo.
…
For the week of August 24th, 2012: Everybody’s Preparing for OpenWorld Dispelling the Rumors of MySQL’s Impending Doom On Piracy of Design IOUG Podcast 24-AUG-2012 Rumors of MySQL’s Doom by Oracle / Design Piracy Subscribe to this Podcast (RSS) or … Continue reading →
If you have followed, or have tried to follow, my different
attempts at getting Key-Value Store, in this case represented by
MongoDB, from MySQL on a single machine with all data in RAM. I
have not been very successful so far, but many smart people, way
smarter than yours truly, has been giving me suggestions for
things to try to get MySQL closer to the performance of MongoDB,
where MongoDB did some 110 k row reads per second, whereas MySQL
was at best reading some 43 k rows per second (using the HEAP /
MEMORY storage engine) and 46 k row reads per second (using NDB
and without CLIENT_COMPRESS). Note that not all combinations has
been tested, so it would be reasonably safe to assume that using
the HEAP / MEMORY storage engine and excluding the memory storage
engine, would be even faster than the 43 k rows when using
CLIENT_COMPRESS.
As I could see that the CPU load on mysqld was very high, and as
everything is in memory and hence there …
Besides of voices of Lata Mangeshkar, Rahat Fateh Ali Khan and Celine Dion, the thing which ticks my heart to no bound is the blogs written by various bloggers covering Oracle, SQL Server, and MySQL related technologies. This Log Buffer Edition is brimming with those chords in Log Buffer #283. Enjoy !!! Oracle: Angela Poth [...]
At the end of September, the MySQL Connect 2012 conference will be held as part of Oracle OpenWorld in San Francisco. MySQL Connect is a two day event that allows attendees to focus on MySQL at a technical depth with presentations and interaction with many of the MySQL developers, engineers and other knowledgeable staff. There is also a range a international speakers to give broader knowledge to the presentations.
I am presenting a Hands-On Lab on Sunday 30th September 16:15 - 17:15 entitled HOL10474 - MySQL Security: Authentication and Auditing. The sessions goes through an introduction to the plugin API and how it can help expand the capabilities of MySQL. Since it is a hands-on lab, …
[Read more]Recent MySQL versions (first the chaotic series of releases that preceeded 5.5 – 5.2, 6.0 and 5.4 – and now 5.6) adds new ‘character sets’ to MySQL. But little of it is useful.
Let us take it from the beginning: before 4.1 MySQL supported a wide range of single-byte character sets: regional ones (‘latin1′/Western, ‘latin2′/Central-european, arabic etc.) as well as strictly national ones (hebrew, ‘armsci’/Armenian, ’tis60′/Thai etc.) and also a few multibyte *non-unicode* character sets for Chinese, Korean and Japanese. 4.1 added the support for Unicode to MySQL with the UTF8 and UCS2 charsets. Since then UTF16, UTF8MB4 (they are useful to a limited amount of users) and also UTF32 was added and in early 5.6 UTF16LE (and they are not useful at all)
What does it mean? Let’s start with a Wikipedia quote. …
[Read more]I promised to still post some general comments about the MySQL ecosystem, to conclude my outlook of State of the MySQL forks and Drizzle. I will do this now in the form of answering questions I got in the comments, twitter and some that I make up just myself.