How i discovered lucene and how did i tune it to use it with our
organization... Oops, i may have to leave out specific details
about its usage in our organization but i will try to give out a
brief general idea.
Well.... i found out lucene thru the mysql website. Was just
going thru the forums of mysql full text search engine. At that
time mysql 4.0 had just rolled out and we were using the full
text search engine of mysql. But it was terribly slow. Since the
data size was not "that" large and number of searches could also
be numbered down easily, we were able to survive on it. But we
were aware that we would be hitting a bottle-neck some time later
and well, we had to do something about it. Soooo... i was just
browsing the forums and somewhere i found someone mention that
mysql full text search is slow and a better alternative to it
would be "aspseek" or "lucene". I first tried out aspseek, but it
did not allow me to do a boolean …
This is a great bi-annual conference. Interesting people and
talks, and very well organised. Three days of tutorials, two days
main conference (two tracks), a free software bazaar on Wednesday
evening, and a social event on Thursday. The official language at
the conference is English. If you're in the area, check it
out!
My own talks:
Wednesday morning and afternoon tutorials:
-
Optimising MySQL Applications Using the
Pluggable Storage Engine Architecture
- New Features of MySQL 5.0 and 5.1 In-depth
Friday session:
- …
I was ordering Mother's Day flowers tonight to the tune of Ozzy Osbourne's "Waiting for Darkness." (Don't ask.) I haven't heard it for years, and I started to smirk at the lyrics. Like most song lyrics, they're lame.
Playing with fire
But they're screaming
When they're burned
Out of the sunlight
Hasn't anybody learnedBefore the smirk set in, the head was
banging. Great music. In my more lucid moments, I smirk. The rest
of the time, I just enjoy.
The myths around open source are much the same. I've heard them so often that I rarely take time to critically evaluate what is being said. Heck, I'm as often as not the one regurgitating them. Open source developers and vendors mime the words, singing along to the catchy tune, because it serves their interests. Anything that smacks of a contrarian opinion is …
[Read more]I thought I would take some time and increase my understanding of PHP and MySQL. I came up with an idea for a project and decided the lowest hanging fruit would be a script to track external links.
The script will reside on a go.domain.com subdomain with the name go.php. It takes a single parameter on the GET string named url, checks it for cleanness, checks that the referrer has the same domain name, then performs a 301 redirect and logs the request.
Here’s the table:
CREATE TABLE go_log
(
access_time TIMESTAMP NOT NULL DEFAULT
CURRENT_TIMESTAMP,
user_name VARCHAR(45) DEFAULT NULL,
user_ip INT UNSIGNED NOT NULL,
referer VARCHAR(500) NOT NULL,
link VARCHAR(500) NOT NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=utf8;
The referer and link columns are roughly twice as big as what a Google search reveals as the longest URL, just to be safe …
[Read more]MySQL 5.1 introduces partitioning within the table level. Lots of nice performance gains to be had. This shows great dedication to establishing the product as Enterprise Level. But, 5.1 is still Beta. What can we do in the meantime till 5.1 is released? How about partitioning tables across several MySQL instances on different machines?
Sometimes multi-table deletes fail in MySQL with a message about an unknown table. In this article I’ll explain the exact combination of circumstances that cause it to happen. First, the symptoms: delete a from db1.t1 as a inner join db1.t2 as b on a.c1 = b.c1; ERROR 1109: Unknown table 'b' in MULTI DELETE This will happen if the following are true: No database is selected or one of the tables is not in the current database The tables are aliased According the the MySQL documentation,
Most people would have heard that saying before. It seems to hold up in most areas of life where pretty much everything has to follow this rule or be deemed practically or economically impossible. You can't buy a car that is good, fast and cheap. Nor a computer. Nor (insert-most-any-product-or-service-here). If your car is good and cheap then you probably won't be breaking any speed limits. If your computer is cheap and fast then it is likely to be of dubious reliability.
The software industry is bound by the same restrictions. Traditionally having good software that gets the job done promptly and does it well means laying out significant sums of money. NASA's equipment has to be good and fast as their margin for error is so small, therefore their budget is large. Apple's products have a historical reputation for being good and fast and definitely not cheap. Microsoft's products have a reputation for being cheaper than Apple's, but also …
[Read more]A topical question is whether BLOBs should be served from a database. My colleague, Jim Starkey, invented the term BLOB and, understandably, is enthusiastic about the concept. However, others are concerned about the practical overhead. So, after some discussion, the answer is maybe, depending on your application. Here's a guide for whether hold your BLOBs in or out of a database:
- If your BLOBs are *huge* (hundreds of megabytes) then use a filing system.
- If the size of your BLOBs are tiny (sector size or smaller) then use a database.
- If you need scale-out then you've got a borderline case. Keep reading.
- If you've got a huge number of BLOBs then you've got another borderline case.
- If you want concurrency then you've got another borderline case.
- If you want relational structure (categories, tags, RSS) then use a database.
- If you want historical copies then use …
A tip posted by Heywood in the MySQL manual on how to export headings in your CSV export....
Life can be stranger than fiction.
On Tuesday I was on a MySQL/SugarCRM webinar, and Jacob from
SugarCRM mentioned that their first translation was to French.
Then, Wednesday morning, I got a translation of the opentaps CRM module
into French . . . from the developers at Nereide and creators of
Neogia, a sister project of opentaps developed in
France.
What can I say?
Merci beacoup! Viva la France, la terre de liberte, egalite,
fraternite . . . et logiciel libre!