| View previous topic :: View next topic |
| Author |
Message |
peter_poulsen
Guru
Joined: 12 Feb 2003
Posts: 387
Location: Denmark
|
 Posted: Mon Jul 11, 2005 11:22 am Post subject: Giant SQL.log file [SOLVED] |
 |
|
I'm running a php script from the console to where I'm executing some SQL commands. Apparently PHP like to drop a log file with statements like:
| Code: | php -f copy_dat 23c-8e0 ENTER SQLGetInfoW
HDBC 00C12360
UWORD 8 <SQL_FETCH_DIRECTION>
PTR 0012FA4C
SWORD 4
SWORD * 0x0012FA32
php -f copy_dat 23c-8e0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 00C12360
UWORD 8 <SQL_FETCH_DIRECTION>
PTR 0012FA4C
SWORD 4
SWORD * 0x0012FA32 (4)
|
I guess that is nice enough if it was not because the data base is over 20GB and the size of the log file reaches a size of 2GB very quickly. The only reason it does not get larger is simply that I have run out of disk space 
Is there any way I can disable this logging facility?
Last edited by peter_poulsen on Thu Jul 14, 2005 4:10 pm; edited 1 time in total |
|
| Back to top |
|
 |
keli
Apprentice
Joined: 18 Jul 2003
Posts: 210
Location: TgMures, RO
|
| Posted: Mon Jul 11, 2005 12:16 pm Post subject: |
|
|
you can disable php's logging from php.ini, but I'm not sure wether php is the culprit for SQL.log. You might want to check the config of your database server as well (what DB are you using, by the way?)
_________________
"The future masters of technology will have to be lighthearted and intelligent. The machine easily masters the grim and the dumb."
Marshall McLuhan, 1969 |
|
| Back to top |
|
|
peter_poulsen
Guru
Joined: 12 Feb 2003
Posts: 387
Location: Denmark
|
| Posted: Mon Jul 11, 2005 12:33 pm Post subject: |
|
|
hrmm... found the error. Really stupid configuration error of my DB  Sorry! |
|
| Back to top |
|
|
|
Desktop Environments
