|
If you have missed Michael McFadden's session at the last MySQL Conference, here's a chance to catch up. On June 11, at 17:00 UTC Michael McFadden will present at a free webinar, on the subject of Faster Data Reduction and Smoothing for Analysis & Archival in MySQL. Don't let the "For ISVs" distract you. This session is a collection of very practical and down to earth tips for tasks that can be in the TODO list of any DBA. |
In addition to being practical, …
[Read more]|
If you have missed Michael McFadden's session at the last MySQL Conference, here's a chance to catch up. On June 11, at 17:00 UTC Michael McFadden will present at a free webinar, on the subject of Faster Data Reduction and Smoothing for Analysis & Archival in MySQL. Don't let the "For ISVs" distract you. This session is a collection of very practical and down to earth tips for tasks that can be in the TODO list of any DBA. |
In addition to being practical, …
[Read more]
Die Idee ist einfach großartig:
The PHP BBQ tour is one week tour from Monday, 15.06 - Sunday,
21.06.2009 visiting the german PHP user groups. The tour is an
offering and a suggestion to the user group to come together for
a barbecue instead of meeting in conference rooms in the middle
of the summer, when the days are long. Everybody is invited to
join the tour and to visit the PHP user group in his neighbor
town.
Die Tour geht durch die folgenden Städte: München, Frankfurt,
Karlsruhe, Berlin, Dortmund, Hamburg und finally Kiel.
Mehr Infos gibt es bei der MySQL Forge. Vielleicht sieht man sich ja?
For one our project I needed proxy solution, and mysql-proxy is
one of well-known, so it was logical first choice. The obvious
question which come in mind is what performance penalty we have
using mysql-proxy, version 0.7.1.
So it is easy to test. (By the way sysbench recently was pushed
to Launchpad, see lp:sysbench, and Percona is going to be active
developer of this project and scripting benchmarks).
I took lp:sysbench with LUA script oltp_complex_ro, and tested for couple connections, here are results (in transactions per second, more is better)
| Threads | MySQL-5.0.77 | MySQL-proxy+MySQL-5.0.77 |
| 1 | 660.02 | 349.86 |
| 2 | 1158.66 | 477.77 |
| 4 | … |
Just a quick and dirty stored function for MySQL that takes two DATETIME arguments and produces a readable difference in hours, days, weeks, months or years. Hope it’s useful.
Update: Roland Bouman has managed to optimize the function quite a bit, see http://rpbouman.blogspot.com/2009/06/mysql-refactoring-stored-function.html
DELIMITER //
CREATE FUNCTION TimeDiffUnits (old DATETIME, new DATETIME) RETURNS CHAR(50) DETERMINISTIC NO SQL
BEGIN
DECLARE diff INTEGER;
SET diff = UNIX_TIMESTAMP(new) - UNIX_TIMESTAMP(old);
CASE
WHEN (diff < 3600) THEN
RETURN CONCAT(FLOOR(diff / 60) , ' Minutes');
WHEN (diff < 86400) THEN
RETURN CONCAT(FLOOR(diff / 3600), ' Hours');
WHEN (diff < 604800) THEN
RETURN CONCAT(FLOOR(diff / 86400), ' Days'); …Kickfire today announced a new series of Webinars for the data warehousing mass market, co-presented with Sun Microsystems and the Kimball Group, the definitive source for dimensional data warehousing expertise. The data warehousing mass market is comprised of deployments in the gigabytes to low terabytes which, according to an IDC/ComputerWorld survey, represent over three-quarters of the total market.
The webinar series will begin on June 25th at 1:00 pm PDT.
MySQL Workbench has some nice export features. They include:Forward engineer SQL Create ScriptForward Engineer SQL ALTER ScriptSynchronize With SQL Create ScriptExport as PNGExport as SVGExport as Single Page PDFExport as Single Page PostScript FileExport options (just choose File Menu then Export option):
About six months ago, the question of storing images in a database came up. This is one of my favorite topics, and has many database-agnostic parts.
Personally, I think “tell me about storing images in a database” is actually a great interview question, because you will be able to see the difference between someone who has just memorized “what’s right” versus someone who is really thinking. It also helps you see how someone will communicate — if they just say “NEVER do it, it’s as bad as crossing the streams!” then they are a type of person that gives you a short answer, without much explanation, and without many nuances. (That may be what you are looking for, but usually you want someone who gives reasons for why they strongly feel one way or another).
Consider the following cases:
What about storing …
We’ve been looking for a Drizzle regression for some time now, and today I decided I would take a step back and make another attempt to find it. The first step in doing this was to reproduce this consistently and find a baseline. We’ve noticed it most dramatically with a 16 concurrent connection test from sysbench in read-only mode. I used two 16-core Intel machines running Linux we have for development. We’ve noticed the regression on certain machines but not all, and these two machines provided one of each. I also setup a MySQL 5.1.35 server to use as a baseline to give some comparisons outside of Drizzle. So first, a few more details on the machines:
Machine 1: 16 core, 16GB RAM, cache sizes from dmesg: [ 0.010000] CPU: L1 I cache: 32K, L1 D cache: 32K [ 0.010000] CPU: L2 cache: 4096K From /proc/cpuinfo: cache_alignment : 64 Machine 2: 16 core, 40GB RAM, cache sizes from dmesg: [ …[Read more]