Reputation
2,469
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
2 11 18
Newest
 Excavator
Impact
~238k people reached

Jun
25
comment MySQL 5.1.34 on NFS w/NetApp
Please specify which logs you are concerned about separating. I would assume you mean the ib_logfile* and I can understand your concern. If I found that I needed to squeeze out a little extra performance I would still separate it as I said in my answer, and just understand that I will have to recover it from local storage (or where ever) to repair after a crash. However, I see no risk in separating the mysql-bin.* or (shudder) mysqld.log (aka:General Query Log) if you happen to use them. I would strongly advise against the latter.
Jun
25
answered MySQL 5.1.34 on NFS w/NetApp
Jun
25
revised vim re-edit as root
fixed grammar
Jun
25
comment How do you use VIM to edit tabular data (tables)? Specifically, BIND (named) DNS db files
SpoonMeiser is exactly correct.
Jun
23
answered How do you use VIM to edit tabular data (tables)? Specifically, BIND (named) DNS db files
Jun
23
awarded  Scholar
Jun
22
comment Is it time to upgrade production MySQL 5.0 servers to 5.1?
We have ~25 apps on the 3 platforms mentioned. Nearly all of them see new releases at least every 3 weeks. Most of them several times a week, and a few several times a day during sprints. I think the developers could weed out anything on the dev/staging env. Since they all use ORM's I can't imagine any issues. Better query optimization, and index selection are only behavior changes I foresee in the handling of the kind of SQL generated by these ORM's. I'm more concerned with: Has MySQL 5.1 proven itself yet?
Jun
22
asked Is it time to upgrade production MySQL 5.0 servers to 5.1?
Jun
20
answered Optimize apache/php/mysql running on VPS for heavy load
Jun
20
answered Fastest way to move MySQL database to a new system while minimizing downtime?
Jun
16
answered vim re-edit as root
Jun
16
comment vim re-edit as root
@dbr, I think it is worth mentioning that after you overwrite the file (with tee as sudo), you will get prompted with [O]k or [L]oad. The later option will erase your undo history an reset the "modified flag" allowing you to exit without being warned to save changes. The former option, which I prefer, will preserve your undo history, but will cause you to get warned when you try to quit. You have to use :q! to quit in this case. I do this so I can validate (e.g. :!sudo /etc/init.d/httpd configtest) and rollback/reedit if I need to.
Jun
16
comment vim re-edit as root
@rkthkr, if "vim restarted and run as root" you would be unable to save any edits you have made, and lose your undo history. But if that is what you want... [Ran out of characters.] See the "answer" I'm about to write.
Jun
16
awarded  Commentator
Jun
15
comment How do you use VIM to edit tabular data (tables)? Specifically, BIND (named) DNS db files
This looks like a very cool plugin. From what I can tell it modifies that file, rather than simply presenting it in a special way. Thank you for the lead. I will use this plugin for some things, but I cannot use it for my DNS zone files. The admin would flip out (and rightfully so) if I alter every line of every file I touch.
Jun
15
answered Is there any reason to use 64bit MySQL (and OS) on small databases?
Jun
15
comment Is there any reason to use 64bit MySQL (and OS) on small databases?
How big do you expect your dataset to grow to? Disk space and/or number of rows is what I am asking for.
Jun
15
asked How do you use VIM to edit tabular data (tables)? Specifically, BIND (named) DNS db files
Jun
13
comment How can I export the privileges from MySQL and then import to a new server?
Great info in that link, thanks. Bookmarked.
Jun
13
answered Permanent SSH Connection via Bash Script?