I’m using Redmine to manage projects and bug reports, I was needing a daily report with spent time by user on each project, nothing complicated, but I wanted a cross-reference result like Excel dynamic tables. As we know, MySQL doesn’t support dynamic cross-reference queries but I make an approach:
1. Write the main query with rows: project identifier, task subject and total hours in a date range.
SELECT p.identifier, e.issue_id, i.subject, round(SUM(e.hours),2) AS total_hours FROM redmine_nsp.time_entries e INNER JOIN redmine_nsp.issues i ON e.issue_id = i.id INNER JOIN …[Read more...]
Get the best from both worlds with bundled packages: a training course and a certification exam voucher. You save 20% when you buy training and certification in discount packages.
Training helps you acquire product expertise. Certification proves this expertise to your future employers.
There are two MySQL Discount Packages: MySQL Database Administration and …[Read more...]
Well, currently I am into the third week of mongodb node course
"M101JS: MongoDB for Node.js Developers" and I am pretty
Lots of personal learning into node and mongodb.
The third week subject of "Patterns, Case Studies & Tradeoffs" is really interesting.
Here is a list of topics, I learned about:
- Mongodb rich documents concept.
- Mongodb schema use cases.
- Mongodb one:one, one:many, many:many use cases.
- How to select schema based on the usage like whether you want max performance
or it may be a tradeoff.
Optimization involves improving the performance of a database server and queries that run against it. Optimization reduces query execution time and optimized queries benefit everyone that uses the server. When the server runs more smoothly and processes more queries with less, it performs better as a whole. To learn more about how a MySQL developer can make a difference with optimization, take the MySQL Developers training course.
This 5-day instructor-led course …[Read more...]
Introduction So here’s a recent requirement that I’ve just encountered. I have a shared MySQL database I have several users that I want them to be able to create new databases However, I don’t want them to see each other’s databases And just to be absolutely clear, I obviously don’t want to give them all […]
Prior to version 3.10, MySQL Enterprise Backup (MEB) used zlib compression for in-memory compression of datafiles. The compression worked by splitting the innodb datafiles into fixed size blocks and compressing each block independently.After searching on the web we found there are many compression algorithms available which can be used for compression. This triggered the idea of testing the performance of available compression algorithms. If the benchmark shows improved performance we can make backup and/or restore faster by adding the new compression algorithm to MEB.
Implementation : …[Read more...]
The MySQL Utilities Team is pleased to announce the latest
release candidate (RC) release of MySQL Utilities. This release
includes a number of improvements for useabilty, stability, and a
few enhancements. A complete list of all improvements can be
found in our release_notes.
We have also included two new utilities.
I've completed a new release of the Connector/Arduino! The new
release contains some major improvements with memory
Memory, What …
Parallel replication is in MariaDB 10.0. I did some benchmarks on the code in 10.0.9. The results are quite good! Here is a graph that shows a 10-times improvement when enabling parallel replication:
The graph shows the transaction per second as a function of
number of slave worker threads, when the slave is executing
events from the master at full speed. The master binlog was
generated with sysbench oltp.lua. When the binlog is enabled on
the slave and made crash-safe (
--innodb-flush-log-at-trx-commit=1), the slave is about
ten times faster at 12 worker threads …