Activities

October 2009
M T W T F S S
« Aug   Nov »
 1234
567891011
12131415161718
19202122232425
262728293031  

MySQL Server optimization tricks

These variables will help him to optimize or tuning mysql easily.

1. Lock and unlock mysql tables

LOCK TABLE Books READ; LOCK TABLES Books READ, BookOrders WRITE; b. Unlocking tables

UNLOCK TABLES;

2. Variables to be monitored Threads_connected Created_temp_disk_tables Handler_read_first innodb_buffer_pool_wait_free key_reads max_used_connections open_tables==< tables_cache Select_full_join slow_queries uptime

3. REPAIR TABLE

[…]

Automated MySQL backup for Windows

I have recently re-setup a full backup mechanism both for MySQL database and webfiles. I uses mysql dump for backing up the db and use normal copy command to backup web files.

backup structure is like this. 1. database will dump to a ftp location on daily wises after the compression and another remote program […]

PHP throws an Error on IIS “Invalid access to memory location”

How to solve the IIS error on php script execution.

Yesterday I setup a IIS which is configure to run Php scripts using ISAPI module. But after some time I noticed that things were not going correctly and I got php exception errors on web like “Invalid access to memory location” Google will give some […]