Release 0.9.0 of RediSQL, SQL steroids for Redis
RediSQL, Redis on SQL steroids.
RediSQL is a Redis module that provides full SQL capabilities to Redis, it is the simplest and fastest way to get an SQL database up and running, without incurring in difficult operational issues and it can scale quite well with your business.
The fastest introduction to RediSQL is our homepage
tl;dr This release introduce one simple new command REDISQL.STATISTICS
. The new command returns the amount of time each command is been called and how many of those calls were successfully and how many returned errors. The command does not introduce noticeable slowdowns.
This release is the smallest, however it provide the foundation for the next major releases.
Motivation
The infrastucture behind the REDISQL.STATISTICS
commands is needed for the next major release of RediSQL.
Moreover it provides an useful tool for the administrator of the instance allowing them to spot inefficiencies.
How to use
Just invoke the command without any arguments to get an array of all the counters, extra arguments are ignored for the moment.
After using RediSQL for few commands, the output of REDISQL.STATISTICS
could be the following.
The CERATE_DB
line means that the REDISQL.CREATE_DB
command is been invoked once. The CREATE_DB OK
lines means that the command succeeded once.
Let's analyze the CREATE_STATEMENT
lines as well.
This line says that the command is been invoked 3 times.
The next line specify that the commands completed successfully 1 time out of 3.
The last line confirms that out of the 3 times we invoked the command, 2 of them failed for some reason.
Of course the math need to check out and the sum of successful and erroneous runs should match with the number of invocation.
Implementation
This command is implemented with atomic counters, they are fast and provide a simple and easy way to manage concurrent access.
We careful tested the performance to make sure that the slowdown introduces by the counter is not noticeable.
Last updated