Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Apache2: Logging To A MySQL Database With mod_log_sql (Debian Etch)
This guide shows how you can write the Apache2 access log to a MySQL database instead of a file. To achieve this, I use the Apache2 module mod_log_sql. I'm using a Debian Etch server in this tutorial.
Apache2: Logging To A MySQL Database With mod_log_sql (Debian Etch)
This guide shows how you can write the Apache2 access log to a MySQL database instead of a file. To achieve this, I use the Apache2 module mod_log_sql. I'm using a Debian Etch server in this tutorial.
Today at 1PM EST I am presenting the second part of memcached for MySQL webinar. I was told that the registration numbers look as good as the previous one. This one will be a bit more technical than the previous webinar. Sorry for the late notice but hope you can join!
While reading my RSS feeds this morning I picked up this:
YouTube Must Give All User Histories To
Viacom
After Scientology's DMCA request on Slashdot we made
an active choice to squash data on users to limit the possibility
of this sort of request. We randomized incoming trackable data on
users and tossed everything but aggregate data for long term
storage.
Why?
For one, we simply did not need to keep terabytes of log data
sitting around collecting dust. Secondly, while the data might be
useful for determining trends we risked our user's privacy. We
believed this was unacceptable. One court request and we could be
handing over who knows what to any company that could find an
uneducated judge to sign away the privacy of …
SELECT ... FROM
tblProduct as prd FORCE INDEX(vProductName,iCategoryId,eProductType,vProductImage,fPrice,eProductStatus,dProductDateAdded)
LEFT OUTER JOIN (SELECT bidjoin.* FROM tblProduct as prdjoin, tblBid as bidjoin WHERE bidjoin.iProductId = prdjoin.iProductId) bid ON prd.iProductId = bid.iProductId
, tblCategory as cat FORCE INDEX(vCategoryName,eCategoryStatus,dCategoryDateAdded)
, tblAuctionProduct as aucprd FORCE INDEX(iRequiredBids,iProductId,eAuctionType,iFreeBidLevel,fAdminFee,dDateClosed)
, tblPurchaseProduct as purprd FORCE INDEX(dProductCloseDate,iProductId,iTotalInventory,dLastUpdated)I know, unreadable. But the main issue today is the FORCE INDEX. This is just one query (real, with permission - I just adjusted some identifiers) from an app that is litterally full of queries using FORCE INDEX. So what does FORCE INDEX do? It forces the MySQL optimiser to use the specified index (or choose from one of the specified, if multiple), …
[Read more]Mike is asking I`m hoping that MySQL stored procedures will work properly. Especially multiple calls in one request. in reply to PDO_MYSQLND: R[a|u]mbling and a breeze of progress. Mike, it depends what you mean by "properly". If you use the API properly it works fine with mysqlnd. Read on for code examples.
| mysqlnd | libmysql | |||
|---|---|---|---|---|
| Emulated PS | Native PS | Emulated PS | Native PS | |
| buffered fetch | PASS | PASS | PASS* | PASS* |
| unbuffered fetch | PASS | PASS | …
Mike is asking I`m hoping that MySQL stored procedures will work properly. Especially multiple calls in one request. in reply to PDO_MYSQLND: R[a|u]mbling and a breeze of progress. Mike, it depends what you mean by "properly". If you use the API properly it works fine with mysqlnd. Read on for code examples.
| mysqlnd | libmysql | |||
|---|---|---|---|---|
| Emulated PS | Native PS | Emulated PS | Native PS | |
| buffered fetch | PASS | PASS | PASS* | PASS* |
| unbuffered fetch | PASS | PASS | …
Mike is asking I`m hoping that MySQL stored procedures will work properly. Especially multiple calls in one request. in reply to PDO_MYSQLND: R[a|u]mbling and a breeze of progress. Mike, it depends what you mean by "properly". If you use the API properly it works fine with mysqlnd. Read on for code examples.
| mysqlnd | libmysql | |||
|---|---|---|---|---|
| Emulated PS | Native PS | Emulated PS | Native PS | |
| buffered fetch | PASS | PASS | PASS* | PASS* |
| unbuffered fetch | PASS | PASS | …
So, I am working on MemProxy some. Mainly, I am trying to
implement more of the Cache-Control header's many options.
The one that has me a bit perplexed s-maxage. Particularly
when combined with max-age.
s-maxage is the maximum time in seconds an item should remain in
a shared cache. So, if s-maxage is set by the application
server, my proxy should keep it for that amount of time at the
most. Up until now, I have just been looking at
max-age. But, s-maxage is the proper one for a proxy to use
if it is present. I do not send the s-maxage through
because this is a reverse proxy and, IMO, that is proper behavior
for an application accelerating proxy. However, I do send
forward the max-age value that is set by the application
servers. If no max-age is set, I send a default as defined
in the script. Also, if no-cache …
I've been getting lots of inquiries from recruiters recently looking to find good people for various tech companies. Two in particular might be interesting if you're in the market or know someone who is.
Technology Evangelist at New York City Based Startup
If you saw Fred Wilson's post Are You A Connector?, you know a bit about this job already. It's a NYC based startup developing a new platform in an area that's likely to see serious growth in the next few years.
They're looking for someone with coding experience who loves showing other developers and users how stuff works: on stage, via blogs, in screencasts, and so on. It's important that this person have a technical (programming) background and also be very comfortable getting in front of people to demo and speak.
The company is New York based and this job is too. However, …
[Read more]