Sunday, March 16, 2014

Dimension Unit Measurements Supported in Android

Pixels px
Actual screen pixels

Inches in
Physical measurement

Millimeters mm
Physical measurement

Points pt
Common font measurement unit

Screen density independent pixels dp
Pixels relative to 160dpi screen(Preferable for dimension screen compatibility)

Scale-independent pixels sp
Best for scalable font display

Friday, March 7, 2014

how to send a running program to backgroud in linux?

Ctrl + Z && bg
then the program will run in background and you can't kill it by ctrl + C unless you use
then the program will back to foreground.

If you want to run a program at the beginning, (you may want to use the same terminal while the programming is running), add & at the end.
./program &

website for self-learning programming

Here are some websites you can learn how to code by yourself online.

1. Codecademy

2. Treehouse

3. One Month Rails

4. Hackerrank

Sunday, March 2, 2014

reclaim unused space for mysql

The problem is that mysql will not release the disk space after delete operations to an InnoDB table. That means the disk usage of mysql will not change even you delete half of the data in the database, which will be a large waste for disk usage.

There are two ways to reorganize the physical storage of table data and associated index data to reduce storage space.

but optimize table can only be performed for one table, if you want to optimize all the databases, you could either write a script to do it or use mysqlcheck command instead.
MYSQLCHECK -o --all-databases

2.  Resize the InnoDB Tablespace (if not use innodb_file_per_table?)
  1. use mysqldump to dump all the InnoDB tables, including InnoDB tables located in MySQL database.
  2. stop the server.
  3. remove all the existing tablespace files (*.ibd), including the ibdata and ib_log files. Do not forget to remove *.ibd files for tables located in the MySQL database. 
  4. remove any .frm files for InnoDB tables.
  5. configure a new tablespace.
  6. restart the server
  7. import the dump files. 
If your databases only use the InnoDB engine, it may be simpler to dump all databases, stop the server, remove all databases and InnoDB log files, restart the server, and import the dump files.