Most mysql query log related news are at:
More mysql query log related news:
Using REGEXP in MYSQL Query marieconbgdlr.files.wordpress.com 14 Sep 2007 | 05:33 pm
Regular Expression (REGEXP) is a “powerful way of specifying a pattern for a complex search”. REGEXP is a set of string that describes what you’re looking for. Here are the operators of REGEXP that c...
Using EXPLAIN to Write Better MySQL Queries shameerc.com 10 Apr 2012 | 02:45 pm
When you issue a query, the MySQL Query Optimizer tries to devise an optimal plan for query execution. You can see information about the plan by prefixing the query with EXPLAIN. EXPLAIN is one of the...
Product Review – Jet Profiler for MySQL shameerc.com 8 Mar 2012 | 08:10 pm
It was few days back I came to know about Jet Profiler an excellent tool for profiling MySQL queries. Thanks Mr. Bjorn Melinder for offering me a professional version for free. Jet Profiler is a tool ...
删除 MySQL 二进制日志(log-bin) studyday.net 3 Sep 2011 | 12:24 am
查找当前有哪些二进制日志文件 删除bin-log(删除mysql-bin.000018之前的所有二进制日志文件) 查看日志
labs | CodeIgniter/ActiveRecord setup to use master + slave db replication fotis.posterous.com 21 Sep 2011 | 01:03 am
This is how you can set up CodeIgniter to direct mysql queries to different read/write hosts in your db replicated environment, using a db_slave for your SELECT’s, and a db_master for the INSERT/UPDAT...
How to log all MySQL queries in Drupal rndblog.com 23 Dec 2011 | 02:16 am
In order to benchmark a Drupal site performance you need to see all the database queries related to your Drupal site. In case you don’t have access to the my.cnf file If you don’t have access to the m...
Insert into multiple MySQL tables with one-to-one relationship rndblog.com 21 Jun 2011 | 06:14 am
I have been asked if there is a way to insert data into two MyISAM tables that connected by a one-to-one relationship in one MySQL query. For example: mysql> CREATE TABLE `user` ( `id` int(10) unsigne...
Automatically Purge MySQL Master Log am3n.net 10 Sep 2010 | 12:15 am
My Friend Andre Hartawan is troubling due to his mysql server at work stop operating. After quick check he found that no more disk space available on the system. Further check on /var partition he fou...
Speeding up your PHPMotion Website phpmotionmods.com 27 Feb 2010 | 09:14 pm
PHPMotion is a great script but if you have a large number of videos then things will start to slow down. This is due to a number of things from not so good html coding to mysql queries which are not...
LEARNING PHP & MYSQL – Part 9: MySQL query. vnstyling.com 11 Sep 2010 | 09:20 pm
Mặc dù đang ở công ty, tranh thủ tí thời gian rảnh rỗi tôi tiếp tục series về “Learning PHP”. Bài trước tôi đã giới thiệu với các bạn về database, cách kết nối với database, cách tạo database với phpm...
