ndb_mgm> all report MemoryUsage
Node 1: Data usage is 11%(632 32K pages of total 5440)
Node 1: Index usage is 22%(578 8K pages of total 2592)
Node 2: Data usage is 61%(3331 32K pages of total 5440)
Node 2: Index usage is 40%(1039 8K pages of total 2592)
ndb_mgm>
Oh, and that’s coming from saved command history.
(as seen when upgrading my cluster here to mysql-5.1.19 ndb-6.2.3 - i.e. MySQL Cluster Carrier Grade Edition - i.e. the -telco tree)
BusinessWeek reports MySQL continuing with their IPO preparations. As a long-time user (about ten years now), and almost as long-time customer (in many companies, obviously currently and most significantly Sulake and Habbo), I wish you guys the best of luck on that road. Don't lose your sight of the ballgame while doing that -- we need you to continue to do better with the product itself while the distractions of investor communications will be great.
I'm sure we can all name a few nuisances in every software product we use, and I certainly have a few of those of the MySQL database, but what I really admire the guys for is their approach to innovating in the sales …
[Read more]
You may have noticed the excitement about MySQL
Proxy. But perhaps you failed to realize what you can do with
it.
Here's a simple tutorial that will guide you through your first
Proxy experience. You will be able to use macros with the
standard mysql client.
Assuming that you are working on the box where your MySQL server
is, do the following:
/path/to/sbin/mysql-proxy --proxy-lua-script=rewrite.lua
--proxy-profiling
mysql -u USERNAME -pPASSWORD -h …
The last two weeks I have been working on a .NET application
using MySQL (3.21) for data storage. The application is basically
a stand-alone PC application where MySql is used to store a lot
of data from test equipment.
This is a bit different from what I spend most of my time on. No
web site with lost of concurrent session, but instead a lot of
installations of the software on local PC's. The also means we
can not tune parameters on a live system, we have to set them
before delivering to customers. Basically this is the main
problem, since we don't know how the system will be run.
Well, if the scenario is different, the most important action was
the same. Changing the field order in one of the indexes to match
the queries better was our number one action, and the impact was
larger than all other actions together. If your indexes are not
righ, you should fix it before anything else.
An upgrade to MySql …
So the other day I stumbled over the slides of the InnoDB talk at this years MySQL users conf and I noticed "gap locking" somewhere in the middle. I have never heard of "gap locking" so I was quite intrigued by what that might be. From what I understand its InnoDB's solution to implementing REPEATABLE READ (though until MySQL 5.1 it seems this feature is also enabled for READ COMMITTED). I guess its a fairly unique approach and from my current understanding to be feasible it expects short running transactions, which luckily are quite common in web applications that most of us care about.
The problem InnoDB is trying to solve here are situations where overlapping transactions cause phantoms. Now the first surprise was when I read that gap locking is implemented by locking the relevant ranges on the index or more particular …
[Read more]Paul Doscher, CEO of JasperSoft, has proved me wrong. Two years ago when I joined as an advisor to JasperSoft, I worried that a company so new to open source (despite the Jasper community on which it was built) would struggle to truly get open source religion.
Paul, however, has adeptly made the shift from CEO to open source CEO, with JasperSoft doing exceptionally well in the market in consequence. In this eighteenth installment of our Open Source CEO Series, I talked with Paul about the transition.
Name, position, and company of executive
Paul Doscher, President and CEO, JasperSoft, an
open source Business Intelligence company.
Year company was founded and year you joined it
JasperSoft was originally founded as Panscopic Software in 2001.
I joined the company in February 2004 and led …
If you haven’t got MySQL Proxy yet, then stop and get it now. Jan announced the release a few days ago of this new product offering from MySQL.
I first heard about MySQL Proxy at the recent MySQL Conference 2007 and actually used it a few weeks later to help address slow running queries during benchmarking with a granularity of milliseconds — Wow. The product has grown immensely since then and I’ve watched in true amazement at the speed of development by Jan, who I only found out recently was the creator of …
[Read more]I was reading some points on a Blog post today here. I didn’t see it via Planet MySQL but via a Google Alert.
The post has several good beginner points on MySQL Performance, but included the point “Literal current date is better than using the CURRENT_DATE() function because literals will use the query cache but functions won?t.”
How true, I must admit I’d not considered this in reviewing code for sites that use the Query Cache heavily. Non deterministic functions invalid use of the Query Cache (Except for recent Bug #29053 which is also an interesting read. Note to self, read the new bugs more often when free time permits). Back on point.
So if you have a query like “Select the news for …
[Read more]Untangle releases open source security software for SMBs. Trolltech to offer Greenphones to select open source community members. GroundWork unveils training program. (and more)
Untangle Brings the Open Source Movement to Small Business Network Security, Untangle (Press Release)
Trolltech Offers Open Source Community a Mobile Development Platform with Qtopia Greenphone Grant Program, Trolltech (Press Release)
Groundwork Breaks Ground On Groundwork University, GroundWork Open Source (Press Release)
…
[Read more]