Category Archives: Coding

All kinds of Programming.

Check system load in php on linux

By | September 17, 2010

System load System load is a measure of how busy the system is running the processes. Higher system load simply means more processes are running and more are waiting to be run. When coding php applications, it sometimes is useful or necessary to find the current load on the server/system. For example if you want… Read More »

List foreign keys in mysql

By | September 5, 2009

information_schema The following query will list out the foreign keys in mysql. It finds it out from the information_schema database. The output is a clean table listing out all foreign keys from all databases +———————–+————-+ | foreign key | references | +———————–+————-+ | orders.client_id | clients.id | | line_items.order_id | orders.id | | line_items.product_id |… Read More »