diff options
author | sasha <sasha@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-04-07 07:34:41 +0000 |
---|---|---|
committer | sasha <sasha@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-04-07 07:34:41 +0000 |
commit | 7f522167399f26f908eee6385a5a3bd02a8a2728 (patch) | |
tree | 6b20b3105293837095905fcd6a0e61686a3d65ec /src | |
parent | 0c36803f89f28d5aa6c13f37c4f25dafc9168a8c (diff) | |
download | zabbix-7f522167399f26f908eee6385a5a3bd02a8a2728.tar.gz zabbix-7f522167399f26f908eee6385a5a3bd02a8a2728.tar.xz zabbix-7f522167399f26f908eee6385a5a3bd02a8a2728.zip |
- [DEV-137] Logging of execution time of SQL statements (commented)
git-svn-id: svn://svn.zabbix.com/trunk@5593 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'src')
-rw-r--r-- | src/libs/zbxdb/db.c | 32 |
1 files changed, 11 insertions, 21 deletions
diff --git a/src/libs/zbxdb/db.c b/src/libs/zbxdb/db.c index 13dbb87b..1de8ac7d 100644 --- a/src/libs/zbxdb/db.c +++ b/src/libs/zbxdb/db.c @@ -412,9 +412,7 @@ int zbx_db_vexecute(const char *fmt, va_list args) char *sql = NULL; int ret = ZBX_DB_OK; -/* suseconds_t is not defined under UP-UX */ -/* struct timeval tv; - suseconds_t msec;*/ +/* double sec;*/ #ifdef HAVE_POSTGRESQL PGresult *result; @@ -423,8 +421,7 @@ int zbx_db_vexecute(const char *fmt, va_list args) char *error=0; #endif -/* gettimeofday(&tv, NULL); - msec = tv.tv_usec;*/ +/* sec = zbx_time();*/ sql = zbx_dvsprintf(sql, fmt, args); @@ -508,10 +505,6 @@ lbl_exec: zabbix_log(LOG_LEVEL_ERR, "Query::%s",sql); zabbix_log(LOG_LEVEL_ERR, "Query failed [%i]:%s", ret, error); sqlite3_free(error); -/* if(!sqlite_transaction_started) - { - php_sem_release(&sqlite_access); - }*/ ret = ZBX_DB_FAIL; } @@ -525,10 +518,10 @@ lbl_exec: php_sem_release(&sqlite_access); } #endif - -/* gettimeofday(&tv, NULL); - if((double)(tv.tv_usec-msec)/1000000 > 0.1) - zabbix_log( LOG_LEVEL_WARNING, "Long query: " ZBX_FS_DBL " sec, query %s", (double)(tv.tv_usec-msec)/1000000, sql );*/ + +/* sec = zbx_time() - sec; + if(sec > 0.1) + zabbix_log( LOG_LEVEL_WARNING, "Long query: " ZBX_FS_DBL " sec, \"%s\"", sec, sql);*/ zbx_free(sql); return ret; @@ -673,9 +666,7 @@ DB_RESULT zbx_db_vselect(const char *fmt, va_list args) char *sql = NULL; DB_RESULT result; -/* suseconds_t is not defined under HP=UX */ -/* struct timeval tv; - suseconds_t msec;*/ +/* double sec;*/ #ifdef HAVE_ORACLE sqlo_stmt_handle_t sth; @@ -685,8 +676,7 @@ DB_RESULT zbx_db_vselect(const char *fmt, va_list args) char *error=NULL; #endif -/* gettimeofday(&tv, NULL); - msec = tv.tv_usec;*/ +/* sec = zbx_time();*/ sql = zbx_dvsprintf(sql, fmt, args); @@ -787,9 +777,9 @@ lbl_get_table: } #endif -/* gettimeofday(&tv, NULL); - if((double)(tv.tv_usec-msec)/1000000 > 0.1) - zabbix_log( LOG_LEVEL_WARNING, "Long query: " ZBX_FS_DBL " sec, query %s", (double)(tv.tv_usec-msec)/1000000, sql );*/ +/* sec = zbx_time() - sec; + if(sec > 0.1) + zabbix_log( LOG_LEVEL_WARNING, "Long query: " ZBX_FS_DBL " sec, \"%s\"", sec, sql);*/ zbx_free(sql); return result; |