mysql list server users

select user,host from mysql.user;

mysql grant access syntax

Sample:

grant all on *.* to 'root'@'123.233.423.34' identified by 'passw'

More Info:
http://dev.mysql.com/doc/refman/5.1/en/grant.html

HTML select elements by css selectors

var arr = element.querySelectorAll( css_selector );
var first_elm = element.querySelector( css_selector );

https://developer.mozilla.org/en/DOM/Document.querySelectorAll

Linux: Calculate directories size

# du -h
# du -h --max-depth=1
# du -h | tail -n 1

Linux: Mount USB drive

- Plug the USB drive
- fdisk -l
- create a mounting folder. i.e. /media
- mount -t vfat /dev/sdb1 /media

To unmount
- umount /media

Compress and split large files

# create archives
$ tar cz my_large_file_1 my_large_file_2 | split -d -b 1024MiB - myfiles_split.tgz_

# uncompress
$ cat myfiles_split.tgz_* | tar xz

This solution avoids the need to use an intermediate large file when (de)compressing. Use the tar -C option to use a different directory for the resulting files. btw if the archive consists from only a single file, tar could be avoided and only gzip used:

# create archives
$ gzip -c my_large_file | split -d -b 1024MiB - myfile_split.gz_

# uncompress
$ cat myfile_split.gz_* | gunzip -c > my_large_file

Apache Performance Tuning

http://httpd.apache.org/docs/2.0/misc/perf-tuning.html

Performance Related settings:

EnableMMAP Off // default is ON