As I’ve blogged many times, MySQLers frequently share off-work interests and running is one of them. I’ve also blogged about social media, which usually use MySQL under the hood. Now I’ve combined the two (running and social media) with the insight that running is a religion: I’m propagating Runnism, the Religion of Running.
It started as a thought …
[Read more]In a blog entry I’ve explained why I consider running a religion and why I want to spread this religion with social media. Still, what’s the point with doing it worldwide? Isn’t enough to do it close to my own front door, either at home in Munich, Germany or in my native Finland?
The reason relates to my interest for other countries, cultures and languages. Through my work, I’ve travelled a lot especially last year, as Ambassador of the product of my former employer. As I …
[Read more]Ryan posted an article on the MySQL Performance Blog about how to use mk-query-digest to analyze and understand your memcached usage with the same techniques you use for MySQL query analysis. This is an idea that came to me during the 2009 MySQL Conference, while talking to our friends from Schooner, who sell a memcached appliance.
It suddenly struck me that the science of memcached performance is basically nonexistent, from the standpoint of developers and architects. Everyone treats it as a magical tool that just performs well and doesn’t need to be analyzed, which is demonstrably and self-evidently false. memcached itself is very fast, true, so it doesn’t usually become a performance bottleneck the way a database server does. But that’s not the point. There is a …
[Read more]
I'm pleased to announce the release of Spider storage engine
version 0.15.(beta)
http://spiderformysql.com/
The main changes in this version are following.
- Add table parameter "auto_increment_mode".
- Add server parameter "spider_auto_increment_mode".
Spider supports 3 modes.
0:Use a count that Spider get from the remote server
with exclusive lock for auto increment value.
1:Use a count that Spider has internal for auto
increment value.
2:Auto increment value is given by the remote
server.
- Add server parameter "spider_ping_interval_at_trx_start".
Performance improvement by frequency decrease of
checking broken connections.
Please see "99_change_logs.txt" in the download documents for
checking other changes.
Enjoy! …
Recently I tried out Google Analytics on heidisql.com for 2 weeks
- nice statistics, really. But for sporadic statistics I thought
that it's not worth giving each and every visitor a
cookie and some dubious JavaScript, spying out several personal
information. So I removed the Analytics webbug again now.
Additionally we had a Ohloh badge somewhere at the bottom of the page. I
decided to also remove that, although that didn't send a cookie,
but slowed down page loading significantly, and it seemed not to
be of much interest.
So I am proud to have heidisql.com free of web bugs again. Of
course, that doesn't apply to the ads at the very top of the page
besides the HeidiSQL logo.
Btw, if you're worried about your privacy online, the Ghostery Firefox
plugin is definitely for you.
Kontrollbase VMware appliance is uploaded and ready for use. Get it here: http://kontrollsoft.com/software-downloads
Had to fix a service process error on the original release of the appliance. It’s now fixed and the machine export is running. I’ll have the new file uploaded and ready for use at approximately 20:00PST (GMT +8).
We’re pleased to announce that Kontrollbase 2.0.1-rev70 is available as a VMware Appliance. This means you can download it and run it with VMware Player, Vmware Server 2, or ESXi 3.5 which greatly simplifies the whole installation process. It’s configured as follows:
So, get it now by downloading here: http://kontrollsoft.com/software-downloads
Ryan posted an article on the MySQL Performance Blog about how to use mk-query-digest to analyze and understand your memcached usage with the same techniques you use for MySQL query analysis. This is an idea that came to me during the 2009 MySQL Conference, while talking to our friends from Schooner, who sell a memcached appliance. It suddenly struck me that the science of memcached performance is basically nonexistent, from the standpoint of developers and architects.
This is the 155th edition of Log Buffer, the weekly review of database blogs.
SQL Server
On the SQL Server blogs this week, CSS SQL Server Engineers demonstrated that using DateDiff can query performance problems in SQL 2005 and 2008.
The kind of problems, perhaps, that Linchi Shea examines in his post on linked server security configuration and how it can hurt you. Linchi writes, …
[Read more]