|
|
pressrelease RSS Feed
View jtmcnaught's IsPopularOnLine RSS Feed
Super queries Specials at Amazon.com Everyday!
| 05/09/2007 03:47 PM |
| Locking Unlocking MYSQL Tables Transactions using PHP script code |
|
MYSQL PHP Table Locking
MYSQL PHP Lock ON OFF Script Code Snippit Example
MYSQL PHP update queries with locking can be rewritten as below :
$query = "LOCK TABLES table1 WRITE, Table2 WRITE";
mysql_query($query);
$query = "UPDATE table1 SET table1_id = 21 WHERE table1_id = 3";
mysql_query($query);
$query = "UPDATE table2 SET table2id = 10 WHERE table2id = 3";
mysql_query($query);
$query = ...
|
| 04/17/2007 12:44 AM |
| First Online Indian Real Estate Discussion Forum |
|
INDIAN REAL ESTATE FORUM First Online Indian Real Estate Discussion Forum Indian realty sector is immensely promising and most sought after for a wide variety of reasons. And the positive attributes of India is definitely going to help the booming property market grow by leaps and bounds in the near future. Indian economy ...
|
| 06/05/2007 12:15 AM |
| 4 Ways To Improve Your Link Popularity Posted By : Jay Moncliff |
|
4 Ways To Improve Your Link Popularity Posted By : Jay Moncliff ...There are numerous factors which a search engine has to consider in order to rank various queries of which link popularity is a crucial factor. (http://jtmcnaught.computer-giveaway.net)
|
| 08/08/2007 11:38 AM |
| MYSQL-How to Monitor SQL Queries Executing in MYSQL. |
|
Monitor MYSQL Queries
How to Monitor MYSQL Queries
The first thing you need to do is turn on logging of queries in MySQL. Be warned that this should only be done on your development server! Logging MYSQL queries really slows things down as it logs every single query to a file!
1- Find and open your MySQL configuration file, usually /etc/mysql/my.cnf on Ubuntu and find the section within that says "Logging and Replication"...
...
|
comments