We're improving the MySQL Server defaults, as announced by Tomas Ulin at MySQL Connect. Here's what we're changing:
|
Setting |
Old | New | Notes |
| back_log | 50 | 50 + ( max_connections / 5 ) capped at 900 |
|
| binlog_checksum | NONE |
CRC32 |
New variable in 5.6. 5.5 doesn't accept the checksums. Use NONE if you want to read … |
Recently, our CEO, John Partridge had a chance to talk about novel database technologies for “Big Data” with Peter Cohan of Forbes.
According to the article, “Fractal Tree indexing is helping organizations analyze big data more efficiently due to its ability to improve database efficiency thanks to faster ‘database insertion speed, quicker input/output performance, operational agility, and data compression.’” As a start-up based on “the first algorithm-based breakthrough in the database world in 40 years,” Toktuetek is following in the footsteps of firms such as Google and RSA, which also relied on novel algortithm advances as core to their technology.
To read the full article, and to see how Tokutek is helping companies tackle big data, see …
[Read more]I was digging through some old project code and found this script. Sometimes one finds oneself in an odd situation and needs to convert regular SQL, say from a MySQL database dump, into SQLite3 format. There’s not too much else to say, but here is a script that helps with the process. It can likely be improved but this handles the items that came up during conversion on initial runs.
#!/bin/sh #### # NAME: convert-mysql-to-sqlite3.sh # AUTHOR: Matt Reid # DATE: 2011-03-22 # LICENSE: BSD #### if [ "x$1" == "x" ]; then echo "Usage: $0 " exit fi cat $1 | grep -v ' KEY "' | grep -v ' UNIQUE KEY "' | grep -v ' PRIMARY KEY ' | sed '/^SET/d' | sed 's/ unsigned / /g' | sed 's/ auto_increment/ primary key autoincrement/g' | sed 's/ smallint([0-9]*) / integer /g' | sed 's/ tinyint([0-9]*) / integer /g' | sed 's/ int([0-9]*) / integer /g' | sed 's/ character set [^ ]* / /g' | sed 's/ enum([^)]*) / varchar(255) /g' | sed 's/ on …[Read more]
Keeping with the tradition of great MySQL Community events, the first annual MySQL Connect conference is now in the books. It was great to see so many familiar faces in the crowd and at the podium sharing their ideas and thoughts on the evolution of MySQL under Oracle. The headliner of the conference was Tomas' keynote announcement of the fully featured and fully enabled MySQL 5.6 Release Candidate. This new article on the MySQL DevZone summarizes all of the great new features ready for Community adoption, all MySQL Engineering blogs and where and how to download all of …
[Read more]TokuDB® is a proven solution that scales MySQL® and MariaDB® from GBs to TBs with unmatched insert and query speed, compression, replication performance and online schema flexibility. Tokutek’s recently launched TokuDB v6.5 delivers all of these features and more, not just for HDDs, but also for flash memory.
Originally Aired: October 10th
AVAILABLE ON DEMAND
TokuDB v6.5:
A colleague, Kris, commented recently on a recent find I made on 5.6.7-rc1 which while not the end of the world does seem to severely limit the use of the new GTID features, or if nothing else make it a pain to use.
Today I found another related issue, when trying to check the syntax of one of the MySQL commands. That’s now reported as bug#67073.
All of these are sort of edge cases but do make 5.6 look a little rough round the edges, when the rest of the product is actually really good and a great improvement from The MySQL 5.5 GA version that everyone uses. That’s really a shame.
I did report the Original problem as SR 3-6270525721 : MySQL 5.6.7-rc1, grants, replication and GTID cause problems, but of course that’s …
[Read more]We've been fully operational for one year today. Time to take a quick breath and look back at a year that was among the most exciting in our lives, and time to look ahead to the next 12 months. In which things are likely to get even better.
We've been fully operational for one year today. Time to take a quick breath and look back at a year that was among the most exciting in our lives, and time to look ahead to the next 12 months. In which things are likely to get even better.
<
p>
This blog post simply lists and describes a few of the most
interesting new features in MySQL 5.6. The list is simply my
preferences based on my development interest and what I think is
very interesting feaures in general.
In MySQL we develop new features using worklogs, the development
is divided into milestones and the MySQL 5.6 development was
divided into 6 different milestones. In total there was around
200 worklogs developed in MySQL 5.6 which is a quite impressive
set of new features. Naturally there is also a ton of bug fixes
in MySQL 5.6 as well but I won't go into those here.
In this blog I will only mention 30-40 of those worklogs, but
even this is a fairly large number of interesting features.
I will discuss features in areas of interest.
Partitioning
Let's start with partitioning. We developed partitioning
originally as a 5.1 feature. Now development is …
I have read so many content concerning the blogger lovers but this piece of writing is in fact a fastidious piece of writing, keep it up.