I've been looking from different angles on ways to make
memcached_get() (aka from libmemcached) faster.
I keep toying with different ideas... rewriting it in different
ways to see if I can get any performance changes in it.
Thus far... nada... no go.
Yesterday I had the idea of "bypass my write buffer, use writev()
to push the data to the client".
This would save me in design two memory copies.
Results?
writev() was slower.
D'oh!
What to do, what to do...
I keep a copy of glibc() on my laptop. I do this for just such
the occasion.
How is writev() implemented? It alloc's memory large enough to
contain the data, does a copy, and then calls write().
Well crap.
I have never used writev() before, the …
The latest from the MySQL community
Ideas, releases, practical guides, and perspectives from the people building with MySQL.
We are hosting a webcast this Wednesday to talk about backing up corporate data to Amazon?s Simple Storage Service (S3) using Amanda Enterprise. We will demonstrate live, how enterprise users can now use Amanda Enterprise to harness Amazon S3 for a complete data backup, archiving and disaster recovery solution. The webcast will take place on Wednesday February 27 at 10:00AM PST and will last about an hour, including a Q&A session at the end. We hope you can join us to discover a new & cost effective way to leverage online storage services such as Amazon S3 as a part of your corporate data protection strategy. Click here to register.
Sun acquires innotek (VirtualBox). The 451 Group publishes report on GPLv3 impact. Alfresco releases open source survey results. (and more)
Sun Microsystems Announces Agreement to Acquire innotek, Expanding Sun xVM Reach to the Developer Desktop, Sun Microsystems (Press Release)
The 451 Group: Latest Version of GPL Software License Causes Disruption in the Enterprise Open Source Industry, The 451 Group (Press Release)
Alfresco?s Open Source Barometer Survey Reveals Ubuntu & Red Hat Pulling Away in Linux-Based Operating System Deployments, Alfresco Software (Press Release)
…
[Read more]
A customer recently asked what the pros and cons are of using the
innodb_file_per_table. It's a good question -
since the right answer will depend a lot on your data. I'm a fan
of the file per table option, it's particularly helpful when you
delete a lot of data and want to reclaim the space. So here is
the list I came up with:
The pros:
* Normally the InnoDB tablespace never shrinks, but when using
file per table you can run run an OPTIMIZE to compact/recreate it
(this is a big win).
* You can symlink out individual tables[1] to be on different
disk subsystems (can give some improvement, but the global
tablespace is still shared).
The cons:
* You can't spread an individual table across several disks
(without file per table, it's quite easy to create many segments
of a few GB each and move them …
March 2008 will be a month of publicity for CouchDB. I will be giving a total of three presentations around the globe, the northern hemisphere, less then half of that, actually. Anyway.
March 1st, 2008 — Chemnitzer Linux Tage
As early as 9:00 a.m. on a Saturday morning, I’ll be giving the 45 minute version of my Next Generation Data Storage with CouchDB talk to a crowd of hopefully awake Linux enthusiasts. The conference is only 5€ (3€ for students), so be sure to show up! The presentation will be in German and so is the information page.
March 7th, 2008 — O’Reilly ETech — San Diego
This is a big one, and actually, they help sponsoring my flight to the US, so a big thanks upfront! In fact, this is a double session …
[Read more]March 2008 will be a month of publicity for CouchDB. I will be giving a total of three presentations around the globe, the northern hemisphere, less then half of that, actually. Anyway.
March 1st, 2008 — Chemnitzer Linux Tage
As early as 9:00 a.m. on a Saturday morning, I’ll be giving the 45 minute version of my Next Generation Data Storage with CouchDB talk to a crowd of hopefully awake Linux enthusiasts. The conference is only 5€ (3€ for students), so be sure to show up! The presentation will be in German and so is the information page.
March 7th, 2008 — O’Reilly ETech — San Diego
This is a big one, and actually, they help sponsoring my flight to the US, so a big thanks upfront! In fact, this is a double session …
[Read more]In a linkage of biblical proportions, Log Buffer #83 pointed me to Tom Kyte’s reiteration which pointed me to Coding Horror’s rant about source controlling the database schema. Now, for starters, I agree with Tom’s sarcasm and Coding Horror’s rant — the database schema really should be source controlled in the same place as the application [...]
March 2008 will be a month of publicity for CouchDB. I will be giving a total of three presentations around the globe, the northern hemisphere, less then half of that, actually. Anyway.
March 1st, 2008 — Chemnitzer Linux Tage
As early as 9:00 a.m. on a Saturday morning, I’ll be giving the 45 minute version of my Next Generation Data Storage with CouchDB talk to a crowd of hopefully awake Linux enthusiasts. The conference is only 5€ (3€ for students), so be sure to show up! The presentation will be in German and so is the information page.
March 7th, 2008 — O’Reilly ETech — San Diego
This is a big one, and actually, they help sponsoring my flight to the US, so a big thanks upfront! In fact, this is a double session …
[Read more]Probably most of MySQL users sometime had a situation when they would do changes in MySQL config file without restarting server (may be matching SET GLOBAL command to do it in run time) but either because option is misspelled or because given version does not support such option the server when would refuse to start when it restarted, either on operating system restart or recovering from MySQL Server crash. In any case it is quite nasty.
Unlike Apache MySQL service control script does not have "configtest" option so there is no straight way to check MySQL config file for errors. However you can do it by running mysqld --help option:
PLAIN TEXT CODE:
- [root@sl1 tmp]# /usr/libexec/mysqld --help
- 080212 12:39:30 [ERROR] /usr/libexec/mysqld: unknown variable 'myis_test=1'
This does not do complete check, ie it is possible to allocate 80GB to buffer pool …
[Read more]