|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
06-17-2005, 05:27 PM
|
#1 |
|
Confirmed User
Join Date: Jan 2005
Posts: 1,648
|
MySQL server question
I got a PHP script running, I wanna know what SQL commands it executes on a certain DB on the MySQL server to figure out that the algo its ranking the thumbs.
Any MySQL option to log every single SQL query? |
|
|
|
06-17-2005, 05:29 PM
|
#2 |
|
Confirmed User
Join Date: Aug 2004
Location: Toronto
Posts: 2,421
|
yeaasssss
|
|
|
|
|
06-17-2005, 05:30 PM
|
#3 |
|
The Hustler
Join Date: Feb 2005
Posts: 4,993
|
huh... KILLA KILLA THE DOPE MAKES TEH SKRILLA
|
|
|
|
|
06-17-2005, 05:35 PM
|
#4 |
|
Confirmed User
Join Date: Apr 2003
Location: Loveland, CO
Posts: 5,526
|
not sure if this will do what you want, by the
mysqladmin extended-status will show what's running in the mySQL environment. actually, there's a bunch of options with "mysqladmin" from the command line to see what's going on at a certain point. about automating it, i'd guess modify the PHP script and log what it's doing. *shrug*
__________________
Your post count means nothing. |
|
|
|
|
06-17-2005, 05:37 PM
|
#5 | |
|
Confirmed User
Join Date: Jan 2005
Posts: 1,648
|
Quote:
|
|
|
|
|
|
06-17-2005, 05:41 PM
|
#6 |
|
Confirmed User
Join Date: Jan 2004
Posts: 1,238
|
add to mysql option :
--enable-logging this will create hostname.log in your datadir with all mysql queries
__________________
Managed US/NL Hosting [ [Reality Check Network ] Dell XEON Servers + 1/2/3 TB Packages ICQ: 4-930-562 |
|
|
|
|
06-17-2005, 05:44 PM
|
#7 | ||
|
Confirmed User
Join Date: Apr 2003
Location: Loveland, CO
Posts: 5,526
|
Quote:
Quote:
__________________
Your post count means nothing. |
||
|
|
|
|
06-17-2005, 06:56 PM
|
#8 | |
|
Confirmed User
Join Date: Jan 2005
Posts: 1,648
|
Quote:
 |
|
|
|
|
