Today was fairly productive, I pushed the last piece of code into
5.1 for mysqlslap that I wanted to make sure would make the 5.1
beta freeze date (January 4th for the those playing at
home).
So what does mysqlslap do? Basically its a load generation
application. It has three stages, create schema, load data, and a
general purpose run.
If can take queries from the command line for each stage or it
can read in queries from a file. Patrick Galbraith added a
primitive operation for it to generate data for all three if you
need be.
What you then do is specify bits likes
--concurrency="1,8,64,1024" and it will run the tests at each
concurrency level (--concurrency handles the general purpose
stage while --concurrency-load will handle the load stage). You
are not required to run all of the stages so its safe to just run
general queries against existing data sets.
You can also run --iterations …
I recently migrated a Nucleus CMS from MySQL 4.x to MySQL 5.0 but
upon migration, I get the following message
ERROR 1054 (42S22): Unknown column 'i.inumber' in 'on clause'
when running the query:
SELECT i.inumber as itemid, i.iblog as blog, i.ititle as title, i.ibody as body, m.mname as author, m.mrealname as authorname, i.itime, i.imore as more, m.mnumber as authorid, m.memail as authormail, m.murl as authorurl, c.cname as category, i.icat as catid, i.iclosed as closed, t.tags as tags, t.item_id as item_id FROM nucleus_item as i, nucleus_member as m, nucleus_category as c LEFT join nucleus_plug_tags as t ON t.item_id=i.itemid WHERE i.iauthor=m.mnumber and i.iblog=1 and i.icat=c.catid and i.idraft=0 and (( match (ititle,ibody,imore) against ('aids') > 0 ) or ( t.tags LIKE '%/aids/%') ) and i.itime<="2005-12-28 19:15:54" ORDER BY i.itime DESC;
The interesting thing is …
In the much-vaunted blogosphere, I find that people are either dull or too cowed to tell the truth undiluted. 2005 saw everyone and their dog starting a blog, but most are vapid and useless to a large audience. (That's not to say they're not important and useful to one's immediate peers.)
In open source, there are very few blogs I've found worth following. To be worth my time (and yours, I should think), the blogs need to impart real information - either objective news or, more likely, solid data gleaned from real-world experience. Most do neither. And of the two, I think the latter (i.e., experience) is more important than the news. No one has figured out open source completely yet as a business, leaving all sorts of room for idea-sharing. That's why we started the Open Source Business Conference, and it's what any good open source blog should do.
A few people have asked me which …
[Read more]
A few people have asked me which blogs I follow. (OK, two of the
three inquirers were my children, but....) Here's a list. (Dave
Rosenberg and I have complained before that there isn't much
intelligent discussion of open source in the blogosphere. If you
know of something worthwhile, please share, either directly
(masay @ osbc . com) or in the comments. My primary objective in
posting these is to elicit feedback on others I should be
reading.)
The List
-
InfoWorld's Open Resource by Dave
Rosenberg...and me. I suppose this is a bit self-serving, but I
was reading Dave's blog long before I joined it. Dave's blog is
the best place to get unvarnished opinions on open source (plus
web services and other random stuff). Dave doesn't bother to
try to put a veneer on rubbish.
- …
There have been some reactions about my MySQL - PostgreSQL article that I wrote
recently.
I received a kind email from Magnus Hagandar, who is one of
PostgreSQL's developers (the PostgreSQL website states: "Has done
major work on the Win32 port and wrote much of the Win32
Installer."). He answered some of my unclear questions about
Postgresql (and allowed me to post it here in my blog, so here it
is):
Hi!
Stumbled across
http://db4free.blogspot.com/2005/12/mysql-postgresql.html,
thought I
should answer two questions for you. You get it in mail since you
rblog
doesn't permit anon postings and I don't have an account :)
> When a transaction is started and you write a SQL statement
that has a
> syntax error in it, PostgreSQL rolls back the transaction …
I've been busy exploring open source software for some years
now.
I think it was Erik, a friend of mine, that first told me and
explained what open source software was about. Then, he was right
in the middle of developing the backup tool Abakt
and we then discussed XML as a format for storing configuration
data. He used (and still uses, I think) an open source SAX
parser, I can't remember which one exactly.
Anyway, he introduced me to MySQL, OpenOffice, Mozilla - all
these different kinds of products. My initial reaction was one of
disbelief: How in the world could this software be free
of charge? Put another way, how can it be free of charge, and be
of good quality too? What's the catch?
I then briefly …
For those of you with mail accounts on colliertech.org:
http://colliertech.org/phpsaadmin/
Tell me if you'd like me to add you to the list of folks who can
use that tool, and you can add addresses to your black/whitelist
from your web browser.
To get this working, I read these docs:
http://spamassassin.apache.org/dist/sql/README
The INSTALL file from this dist:
http://www.misak.dk/download/phpsaadmin/
The main bit is that you need to turn on the -q or -Q flag for
your spamassassin daemon. For Debian-based systems, edit
/etc/defaults/spamassassin
You'll also need to make a small modification to
/etc/spamassassin/local.cf
…
For those of you with mail accounts on colliertech.org:
http://colliertech.org/phpsaadmin/
Tell me if you'd like me to add you to the list of folks who can
use that tool, and you can add addresses to your black/whitelist
from your web browser.
To get this working, I read these docs:
http://spamassassin.apache.org/dist/sql/README
The INSTALL file from this dist:
http://www.misak.dk/download/phpsaadmin/
The main bit is that you need to turn on the -q or -Q flag for
your spamassassin daemon. For Debian-based systems, edit
/etc/defaults/spamassassin
You'll also need to make a small modification to
/etc/spamassassin/local.cf
…
There's an interesting article in BusinessWeek by Steve Hamm "Java? It's So Nineties" which posits that LAMP's rise in popularity may be coming at Java's expense. While there are plenty of shops that continue to use Java, especially on the backend, I do think Java, or rather J2EE, is a somewhat specialized technology in the Enterprise. Typically J2EE application servers are deployed on the most highly scaled transactional systems, but not on a lot of the "bread and butter" tactical IT applications that need to be built. Outside of this, Java has had limited success on the desktop and for front end applications.
Peter Yared, CEO of ActiveGrid, has launched his company specifically to help provide additional tools to facilitate scale-out of …
[Read more]