The method I would like to describe is based on the webserver lighttpd.
Lighttpd is a single process webserver written for high traffic sites. It supports fast-cgi out of the box which makes it ideal for hosting PHP applications. There are lots of nice modules for the daily work like mod_access or mod_rewrite. For more infos see the internals
There are also some benchmarks there. Lighty´s home is always worth having a look at.
In the laundry list of items I did today, I pulled the sphinx
storage engine code that was just released. I had seen a blog
post on its release and I wanted to see how the developers had
implemented it.
I have not yet tried the code, I just read through it to see how
they implemented it. I had been curious to see how they would do
this, since the fulltext code in MySQL is not very well exposed
in the storage engine interface (a bit better in 5.1, but not
perfect). They took the approach of using a special field in the
schema to pass along search queries. This means that you will
have to define your tables in exactly their schema format (much
how the ha_httplog engine works, though it has a slightly more
flexible approach to schema). They reused the Federated
connection field to determine location, and did the correct thing
of extending the URL mechanism that Federated uses.
They pass the query by identifying the "query" …
So once a week I pull roughly 250,000 RSS feeds in a single
snapshot. Its not consistent and only represents what a slice of
blogosphere has published at any given time. I've polled websites
for years, and more recently URLs/RSS. An article on Business 2.0
got me interested in breaking up the entries by individual word.
I was curious to just see how often some words were being
mentioned. The Business 2.0 article was on who and what you
should not being putting your attention into. It had the
"Slashdot is out, and Digg" is in comment.
While I think Digg is a great site, I just do not buy the work
Jeremy pointed out on Slashdot vs Digg. Digg may be growing, but
I believe that its relevancy is not as high as Slashdot's. I also
think that do to the nature of it being an open site with no
editorial, eventually it will water down its own effect by being
to broad.
The numbers:
mysql> select word_id, word, …
MySQL AB, the developer of the worldâ??s most popular open source database, today announced its participation in the Microsoft Visual Studio Industry Partner (VSIP) program as an Alliance-level partner. With over 240 members, Microsoftâ??s VSIP program gives partners the tools and resources they need to successfully integrate their tools, components and services into the Visual Studio 2005 development environment.
C.J. Blathers about recent major changes in his life.
https://colliertech.com/~cjcollier/confidential/sateOfTheCJ20060625.ogg
https://colliertech.com/~cjcollier/confidential/sateOfTheCJ20060625.mp3
Mail me for credentials.
Jason Maynard of Credit Suisse First Boston, enfant terrible of the software analyst community (well, if you're a proprietary vendor, anyway), is at it again. He's got a great "Mavericks vs. Microsoft" series going, with a June 23, 2006 report coming from a call with Marten Mickos, CEO of MySQL. He makes some interesting points, including:
Currently a private company, MySQL is...the world's most popular open source database with more than 8 million active installations.
The primary revenue stream for the company comes from the conversion of free downloads of its database product into support contracts. So far, the conversion rate to paying customers runs about 1 for every 1,000 downloads. MySQL’s database has been downloaded close to 100M …
Today we put the finishing touches on another article for the
Developer's Zone page. This one centered on how to implement
foreign keys via triggers into MySQL. This is important when your
application requires referential integrity and the storage engine
you'd like to use, as in the case of MyISAM or more specifically
NDB (Cluster), does not support this functionality
natively.
In the article we cover:
Some of the advantages of foreign key enforcement include:
Sometime it is needed to handle a lot of rows on client side.
Usual way is send query via mysql_query and than
handle the result in loop mysql_fetch_array
(here I use PHP functions but they are common or similar for all
APIs, including C).
Consider table:
PLAIN TEXT SQL:
From Monday to Wednesday we at eZ systems AS had our internal developers
conference in Skien, Norway.
Since I joined eZ systems only recently, this was the opportunity
for me to get to know all employees that gathered from all over
the world. Most of the Tuesday was reserved for a "Crew Day" with
some "team-building" which took place in a forest nearby.
On Thursday and Friday the eZ publish conference
2006 took place.
During the conference I met with …
From Monday to Wednesday we at eZ Systems AS had our internal
developers conference in Skien, Norway.
Since I joined eZ systems only recently, this was the opportunity
for me to get to know all employees that gathered from all over
the world. Most of the Tuesday was reserved for a "Crew Day" with
some "team-building" which took place in a forest nearby.
On Thursday and Friday the eZ publish conference
2006 took place.
During the conference I met with Sébastien Hordeaux of WaterProof SARL,
the …