sorted by: recent | see :
popular
Content Tagged with Maintenance + MySQL
MOONGIFT: " Del.icio.usをバックアップ「MySQLicious」:オープンソースを毎日紹介
opensource: del.icio.us tag/opensource
MySQL
tools
del.icio.us
Maintenance
opensource
Utility
SocialBookmark
Certain links moved or removed
I’ve made slight changes to the site should it interest anyone. The link to mysqlsniffer has been removed (though the page is still there). The links to Optimize and Intricacies have been consolidated into Documents. And the Feedback link is now Contact. Tragically exciting.
How to check and optimize MySQL tables in parallel
I wanted to point out something that might not be obvious from the name: MySQL Parallel Dump can be used as a generic wrapper to discover tables and databases, and fork off worker processes to do something to them in parallel. That "something" can easily be invoking mysqlcheck -- or any other program. This makes it really easy for you to do multi-threaded whatever-you-need-to-do on MySQL tables. Here's how.
HackMySQL.com returns to normal
The hiatus is over; I am reasonably settled at my new home. Therefore, HackMySQL.com is back to normal operation.
Parlez-vous le français? Je peux parler le français mais pas bien. Si vous voulez, on peut essayer à parler en français. Merci de votre patience.
Xen, fdisk, resize, why oh why...
dd if=/dev/zero count= >> /var/lib/xen/images/shiitake.dsk
Then? I need to increase the partition map for my disk:
fdisk /dev/xvda
What did I do in fdisk? I deleted the partition, and then recreated it with the new available blocks. Of course the machine was running at the time. What is life without a few risks? But I have to ask myself, why doesn't fdisk have a resize command? I swear that tool hasn't changed in well over a decade.
I am running LVM so then I had to:
pvresize /dev/xvda2
lvresize -L +5G /dev/VolGroup00/LogVol00
And finally since the filesystem is ext3:
e2fsck -f /dev/mapper/VolGroup00-LogVol00
resize2fs /dev/mapper/VolGroup00-LogVol00
So why post all of this here? For one it took me a while to figure it out, so I now have a record.
The other reason is to complain about virt-manager. The GUI, hell the command line controller, could have done all of this for me. The steps to increase a partition are quite byzantine and frankly I can see the entire "pay for time" equation pushing someone into just wanting to buy VMWare.
It works :)
HackMySQL.com hiatus: July, August, September
I am moving halfway across the world. Therefore, for the remainder of July and all of August and September HackMySQL.com will not be actively maintained. This means no updates to scripts or articles and very limited response to feedback.
Daniel Nichter: HackMySQL.com hiatus: July, August, September
I am moving halfway across the world. Therefore, for the remainder of July and all of August and September HackMySQL.com will not be actively maintained. This means no updates to scripts or articles and very limited response to feedback.
Site interruptions this weekend
hackmysql.com is moving to (mt) Media Temple this weekend. Because of Memorial Day, I suspect that site traffic will be really low, so perhaps no one will even notice.
hackmysql.com host change
I doubt that anyone will notice, but I thought it would be at least polite to mention that hackmysql.com is moving to a new host. Therefore, some time this week the site may be inaccessible.
