Linux HugeTLBfs: Improve MySQL Database Application Performance

http://www.cyberciti.biz/tips/linux-hugetlbfs-and-mysql-performance.html Applications that perform a lot of memory accesses (several GBs) may obtain performance improvements by using large pages due to reduced Translation Lookaside Buffer (TLB) misses. HugeTLBfs is memory management feature offered in Linux kernel, which is valuable for applications that use a large virtual address space. It is especially useful for database applications […]

Turning Hugepages for Oracle on linux server

http://vnhacker.blogspot.com/2007/07/khng-phi-c-hng-khng-l-tt-tt.html Không phải cứ “hàng khủng” là tốt Cách đây hơn 2 tháng, một khách hàng của tôi có một project rất quan trọng: nâng cấp máy chủ database từ Oracle 9i lên Oracle 10g cho hệ thống core-banking của họ. Mọi việc diễn ra tốt đẹp cho đến ngày đưa hệ thống vào production. […]

RoboMirror – GUI tool of RoboCopy

http://robomirror.sourceforge.net/ RoboMirror is a GUI front-end for the quite popular Robocopy.exe command-line utility for Windows. Robocopy is shipped with Windows since Vista and available as free SDK tool for previous Windows versions (RoboMirror already includes it). It allows to robustly synchronize two directory trees, both locally and across the network. It is therefore often used […]

Dump and restore a single table from .sql

http://stackoverflow.com/questions/6682916/how-to-backup-a-single-table-in-a-mysql-database Dump a table mysqldump db_name table_name > table_name.sql mysqldump -u <db_username> -h <db_host> -p db_name table_name > table_name.sql Restore mysql -u <user_name> -p db_name mysql> source <full_path>/table_name.sql or in one line mysql -u username -p db_name < /path/to/table_name.sql Dump and restore a single table from a compressed (.sql.gz) format Credit: John McGrath Dump mysqldump […]

Skip certain tables with mysqldump

http://stackoverflow.com/questions/425158/skip-certain-tables-with-mysqldump   To restrict certain tables from the mysqldump command, we can use the –ignore-table option. So you could do mysqldump -u username -p database –ignore-table=database.table1 –ignore-table=database.table2 > database.sql To skip their contents when copying, but keep the structure: mysqldump -h <host> -u <username> -p <schema> –no-data > db-structure.sql mysqldump -h <host> -u <username> -p […]

Add new user with Database MySQL

CREATE USER ‘w2project’@‘localhost’ IDENTIFIED BY ‘***’; GRANT USAGE ON * . * TO ‘w2project’@‘localhost’ IDENTIFIED BY ‘***’ WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; CREATE DATABASE IF NOT EXISTS `w2project` ; GRANT ALL PRIVILEGES ON `w2project` . * TO ‘w2project’@‘localhost’;   GRANT ALL PRIVILEGES ON DBname.* TO user@127.0.0.1 IDENTIFIED BY ‘Ps@oordddddd’;

UPDATE-RC.D CHEAT SHEET

http://www.jamescoyle.net/tag/cheat-sheet Debian and Ubuntu use the servicecommand to control services andupdate-rc.d for adding and removing services from start up. Using the servicecommand we can start, stop, restart and display all available services. With update-rc.d we can add and remove services and add them to the Ubuntu/ Debian start up scripts. As Linux operating systems have multiple states, […]