| 1 |
########### mysql-test\t\slow_query_log_file_func.test ######################### |
| 2 |
# # |
| 3 |
# Variable Name: slow_query_log_file # |
| 4 |
# Scope: GLOBAL # |
| 5 |
# Access Type: Dynamic # |
| 6 |
# Data Type: Boolean # |
| 7 |
# Default Value: OFF # |
| 8 |
# Valid Values: ON, OFF # |
| 9 |
# # |
| 10 |
# # |
| 11 |
# Creation Date: 2008-03-17 # |
| 12 |
# Author: Salman Rawala # |
| 13 |
# # |
| 14 |
# Description: Test Cases of Dynamic System Variable "slow_query_log_file" # |
| 15 |
# that checks functionality of this variable # |
| 16 |
# # |
| 17 |
# Reference: http://dev.mysql.com/doc/refman/5.1/en/ # |
| 18 |
# server-system-variables.html#option_mysqld_slow_query_log_file # |
| 19 |
# # |
| 20 |
################################################################################ |
| 21 |
|
| 22 |
|
| 23 |
--echo '#--------------------FN_DYNVARS_018_01-------------------------#' |
| 24 |
#################################################################### |
| 25 |
# Verifying log file after setting it in opt file # |
| 26 |
#################################################################### |
| 27 |
|
| 28 |
let $MYSQLD_DATADIR= `select @@datadir`; |
| 29 |
--echo ## Checking if my_slow_test.log exists in servers datadir ## |
| 30 |
--replace_result $MYSQLD_DATADIR MYSQLD_DATADIR |
| 31 |
--file_exists $MYSQLD_DATADIR/my_slow_test.log |
| 32 |
|
| 33 |
--echo ## This case should pass because we have set this filename in opt file ## |