Skip to content

# Three wishes for a new year

MySQL Opinions secondary September 23, 2014September 23, 2014

Another new year by Jewish calendar. What do I wish for the following year?

1. World peace
2. Good health to all
3. Multi-core execution for queries

After having evaluated a few columnar databases, and having seen how a single query gets 24 cores busy, I can’t look at MySQL the same way again. The fact that a single query consumes a single core only doesn’t seem right in the year 2014. Shard-query is a cool application-level attempt to solve the above; I would like to see stuff like this implemented inside the server (or inside the storage engine where possible).

None of my wishes in previous years [2010], [2011], [2012], [2013] came true (and mostly gone worse). I’m still willing to settle for two out of three.

- Twitter
- LinkedIn
- WhatsApp
- Email
- Facebook
- Print

###
7
Leave a Reply

5 Comment threads
2 Thread replies
0 Followers
Most reacted comment
Hottest comment thread
4 Comment authors
Recent comment authors

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe
Notify of
Guest
ik_5

At least with multi-core, Firebird does support it since version 2.5, and with 3.0 it’s even better 🙂

Happy new year

Guest
Nadav Kavalerchik

What about this:
http://www.percona.com/blog/2014/01/23/percona-server-improve-scalability-percona-thread-pool/

Guest
Nadav Kavalerchik

Or this…
https://mariadb.com/kb/en/mariadb/documentation/optimization-and-tuning/buffers-caches-and-threads/thread-pool/threadpool-in-55/

Author
shlomi

Nadav,
The thread pool relates to aggregating multiple client connections on a single thread. I’m interested in running a single query on multiple cores. The two are unrelated.

Guest
Vadimtk

Shlomi,

I wonder what columnar databases you evaluated and what conclusion you came to ?

Author
shlomi

Vadim,
I evaluated InfoBright, InfiniDB and Vertica (the latter I only evaluated briefly and I can’t claim deep understanding — and anyway ownership was taken by newly created BI team and declared as winner, rightfully).

Yes, I have some deep insights on Infobright and some not-so-deep insights on InfiniDB.
Some of these insights are not so good (we didn’t adopt any of the two) which is the reason why I’m still postponing publishing my results.

Three wishes for a new year | MySQL

[…] of my wishes in previous years [2010], [2011], [2012], [2013], [2014] came true (and mostly gone worse). I’m still willing to settle for two out of […]

wpDiscuz
Send to Email Address Your Name Your Email Address Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.