The new stable version of innotop is now released. Version 1.8.1 is a bug-fix-only release, with no new features. It’s available for immediate download.
Further Reading:
We’ve had quite a bit of feedback already, so many thanks to all of you who have shared your thoughts with us!
However, if you’ve not voted yet, please take a moment and let us know what you’d most like to see in MariaDB 5.6:
http://www.skysql.com/content/new-server-functionality-have-your-say
As always, thank you, and we look forward to hearing from you.
Traditionally the most benchmarks are focusing on throughput. We all get used to that, and in fact in our benchmarks, sysbench and tpcc-mysql, the final result is also represents the throughput (transactions per second in sysbench; NewOrder transactions Per Minute in tpcc-mysql). However, like Mark Callaghan mentioned in comments, response time is way more important metric to compare.
I want to pretend that we pioneered (not invented, but started to
use widely) a benchmark methodology when we measure not the final
throughput, but rather periodic probes (i.e. every 10 sec).
It allows us to draw “stability” graphs, like this one
where we can see not only a final result, but how the system behaves in dynamic.
What’s wrong with existing …
[Read more][Rails] Unicorn ignores SIGUSR2 completely?:
It doesn’t. See the link.
I guess that most folk who read this blog are IT people in one
way or the other. I do not expect my mother to read it, or even
my wife. This is, after all, mostly about rather geeky technical
computer things. But what do I do, when I am at work? I have been
asked this more times than I care to remember, and I think this
goes for most of you. Your significant other asks, your mum, some
realtive, a guy you meet on a train or in a bar.
So what do we do, really? 50 years ago, the kind of jobs we do
didn't even exist, and now most young people today can't figure
out what a world without computers would be like. A large
organization with 10s of thousands of employees managing all
those people and all their production completely without
computers? Not even thinkable these days, but way into the 1960s,
computers was not something for everyone or even for every
corporation, and many didn't even know what to do with them, did
they have one. …
Again, I have moved to a new hosting provider after my free-tier with Amazon EC2 expired. As usual I was looking for a good VPS provider with a decent price, providing good support and in particular a provider supporting FreeBSD, my favorite OS for server (for desktop I still prefer GNU/Linux.)
This time I have carefully reviewed many options and have finally settled with RootBSD, one of the reputed VPS hosting providers if you are choosing FreeBSD as your server OS. One of the prime reasons for choosing FreeBSD is its performance, stability and the FreeBSD ports system.
Although my …
[Read more]
From command line we have the entire MySQL server on hands (if we
have privileges too of course) but we don’t have a overall
overview, at this point the show table status
command is every useful, or not?.
This is what we get when run show table status in a
standard 80×25 terminal screen:
We can maximize the terminal window and decrease font size, but not all the time we need that lots of info. Some time ago I develop a stored procedure to get a global overview including functions and stored procedures. The result is pretty comprehensible:
call tools.sp_status(database()); +----------------------------+--------+-------+---------+-----------------+ | Table Name | Engine | Rows | Size | Collation | …[Read more]
A few years ago I wrote about Asynchronous Shard Queries verses Synchronous
Shard Queries, and in this post I talked about having to write a
server to handle this for me in Java. Now I do it in PHP and got
great results that are posted below.
Building the Feed was taking 100ms up to 40 seconds on the
initial load, if the feed is out of cache. This is not acceptable
for me as an engineer or the users I serve. Although the 40
seconds was rare it still is wrong.
The problem is as I added more shards to handle our data growth,
the feed got proportionally slower. To build the feed for large
users I would have to hit each server or at the very least a
large percentage of them. Adding capacity made things slower in
my Synchronous World.
My options to fix this issue where, do what I did in the past …
A fourth and final Connector/J extension point I covered in my JavaOne and Silicon Valley Code Camp presentations is load-balancing strategies. This exists in order to allow you to define behavior for balancing load across multiple back-end MySQL server instances. MySQL Connector/J’s load-balancing implementation is a simple internal connection pool. What appears to your application as a single Connection object can actually have multiple physical connections to MySQL servers underneath (one per configured host/port pair). At specific points, Connector/J will re-balance and choose another host to interface with. This extension point allows you to define how Connector/J determines …
[Read more]Just a note to let you all know that SkySQL is hiring! We’re currently looking for candidates for the following positions:
Or feel free to check out our Careers page or email us your CV, today, at careers@skysql.com.
