// This cpp file is a generated trace that consists of the following "sections": // // - Connection parameters // - Helper functions // - The actual trace (marked by ****** Begin/End of trace ******) // - Functions to create and populate the necessary tables // - A dump of the current mysql variables // This cpp file should be compilable with: // gcc -g -I ${MYSQL_DIR}/include ${THIS_FILE} ${MYSQL_DIR}/lib/libmysqlclient.a -lm -lz -lstdc++ // To replay the trace you should have a database "baan", or you can change the // DB_NAME define below. If you do so, then also verify all mysql_stmt_prepare and // mysql_query calls because each table name is qualified with the database name. // You should also have two users: bsp/bsp, which has SELECT, INSERT, UPDATE, DELETE // privileges on all objects and baan/baan (the owner), which has ALL PRIVILEGES. // You may choose to use other users/passwords by changing the USER_*/OWNER_* defines // below. Don't forget to modify the HOST_NAME define. // // The trace replays successfully if the program silently terminates with exit status 0. // Connection parameters #define HOST_NAME "nlbaldev1" #define USER_NAME "bsp" #define USER_PWD "bsp" #define OWNER_NAME "baan" #define OWNER_PWD "baan" #define DB_NAME "baan" // use "#define ASSERT_EQ (void)" to disable data validation #define ASSERT_EQ(X,Y) assert( check_eq(X,Y) ) #define ASSERT_EQ_DATETIME(X,Y,M,D,h,m,s) assert( check_eq_datetime(X,Y,M,D,h,m,s) ) #include #include #include #include #include "mysql.h" void create_tables(void); // Global variables int mysql_ret; int count; int mysql_err; MYSQL_TIME mysql_time; MYSQL_RES *mysql_result; MYSQL_ROW mysql_row; const unsigned long select_cursor = CURSOR_TYPE_READ_ONLY; const unsigned long update_cursor = CURSOR_TYPE_FOR_UPDATE; const unsigned long no_cursor = CURSOR_TYPE_NO_CURSOR; // Helper functions void set_bind_attrs( MYSQL_BIND *mysql_bind, int ext_type, void *buf, int bufsz, unsigned long *act_len, my_bool *is_null ) { mysql_bind->buffer_type = (enum enum_field_types)ext_type; mysql_bind->buffer = buf; mysql_bind->length = act_len; mysql_bind->is_null = is_null; mysql_bind->buffer_length = bufsz; } void bind_time(void *ptr,int ye,int mo,int da,int ho,int mi,int se) { MYSQL_TIME t = {ye,mo,da,ho,mi,se}; memcpy(ptr,&t,sizeof(t)); } int check_eq(unsigned long v,unsigned long val) { return( v == val ); } int check_eq(void *ptr,const char *val) { return( memcmp((char*)ptr,val,strlen(val))==0); } int check_eq(void *ptr,int val) { return( *((int*)ptr) == val ); } int check_eq(void *ptr,float val) { return( *((float*)ptr) == val ); } int check_eq(void *ptr,double val) { return( *((double*)ptr) == val ); } int check_eq_datetime(void *ptr,int ye,int mo,int da,int ho,int mi,int se) { MYSQL_TIME *t = (MYSQL_TIME*)ptr; return (t->year == ye) && (t->month == mo) && (t->day == da) && (t->hour == ho) && (t->minute == mi) && (t->second == se); } int main(void) { // Create the tables needed to run this trace create_tables(); // ****** Begin of trace ****** MYSQL *sess_1; sess_1 = mysql_init( NULL ); assert(sess_1); // actuals: HOST_NAME="nlbaldev1", _NAME="bsp", _PWD="bsp", DB_NAME="baan" mysql_real_connect(sess_1, HOST_NAME, USER_NAME, USER_PWD, DB_NAME, 0, NULL, 0); mysql_autocommit(sess_1, 0); mysql_query(sess_1, "SET SESSION sql_mode=ERROR_FOR_DIVISION_BY_ZERO"); mysql_query(sess_1, "SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED"); MYSQL_STMT *stmt_1; stmt_1 = mysql_stmt_init(sess_1); mysql_stmt_attr_set(stmt_1,STMT_ATTR_CURSOR_TYPE,(const void *) &select_cursor); mysql_ret = mysql_stmt_prepare(stmt_1,"SELECT a0.t_empno,a0.t_hiredate FROM baan.tdbtst120000 a0 WHERE a0.t_hiredate = ?",82); assert(mysql_ret==0); count = mysql_stmt_param_count(stmt_1); assert( count==1 ); MYSQL_BIND *param_1 = (MYSQL_BIND *)calloc(1, sizeof(MYSQL_BIND)); MYSQL_BIND *output_1 = (MYSQL_BIND *)calloc(2, sizeof(MYSQL_BIND)); char data_1[36]; unsigned long len_1; my_bool null_1; set_bind_attrs(¶m_1[0],10,&data_1,36,&len_1,&null_1); char data_2[4]; unsigned long len_2; my_bool null_2; set_bind_attrs(&output_1[0],3,&data_2,4,&len_2,&null_2); char data_3[36]; unsigned long len_3; my_bool null_3; set_bind_attrs(&output_1[1],10,&data_3,36,&len_3,&null_3); null_1 = 0; len_1 = 0; bind_time(data_1, 1965,1,1,0,0,0); mysql_stmt_bind_param(stmt_1,param_1); count = mysql_warning_count(sess_1); assert(count==0); mysql_ret = mysql_stmt_execute(stmt_1); assert(mysql_ret==0); count = mysql_warning_count(sess_1); assert(count==0); mysql_stmt_bind_result(stmt_1,output_1); count = mysql_warning_count(sess_1); assert(count==0); mysql_ret = mysql_stmt_fetch(stmt_1); assert(mysql_ret == 0); count = mysql_warning_count(sess_1); assert(count==0); ASSERT_EQ(data_2,10); ASSERT_EQ_DATETIME(data_3, 1965,1,1,0,0,0); count = mysql_warning_count(sess_1); assert(count==0); mysql_ret = mysql_stmt_fetch(stmt_1); assert(mysql_ret == 100); count = mysql_warning_count(sess_1); assert(count==0); mysql_stmt_free_result(stmt_1) || mysql_stmt_reset(stmt_1); null_1 = 0; len_1 = 0; bind_time(data_1, 1965,1,1,0,0,0); mysql_stmt_bind_param(stmt_1,param_1); count = mysql_warning_count(sess_1); assert(count==0); // ERROR: next statement should succeed successfully mysql_ret = mysql_stmt_execute(stmt_1); assert(mysql_ret==1); count = mysql_warning_count(sess_1); assert(count==0); mysql_err = mysql_stmt_errno(stmt_1); assert( mysql_err==2013 ); // Lost connection to MySQL server during query mysql_stmt_close(stmt_1); mysql_ret = mysql_rollback(sess_1); assert(mysql_ret==1); mysql_err = mysql_errno(sess_1); assert( mysql_err==2006 ); // MySQL server has gone away mysql_ret = mysql_rollback(sess_1); assert(mysql_ret==1); mysql_err = mysql_errno(sess_1); assert( mysql_err==2006 ); // MySQL server has gone away // ****** End of trace ****** } // Following code creates all tables needed to run this trace void create_dbtst120000( void ) { FILE *fp = fopen("/tmp/baan_table_dump","w"); fprintf(fp,"%s\n","-- MySQL dump 10.10"); fprintf(fp,"%s\n","--"); fprintf(fp,"%s\n","-- Host: nlbaldev1 Database: baan"); fprintf(fp,"%s\n","-- ------------------------------------------------------"); fprintf(fp,"%s\n","-- Server version\0115.0.6-beta-nightly-20050515-debug"); fprintf(fp,"%s\n",""); fprintf(fp,"%s\n","/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;"); fprintf(fp,"%s\n","/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;"); fprintf(fp,"%s\n","/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;"); fprintf(fp,"%s\n","/*!40101 SET NAMES utf8 */;"); fprintf(fp,"%s\n","/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;"); fprintf(fp,"%s\n","/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;"); fprintf(fp,"%s\n","/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;"); fprintf(fp,"%s\n","/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;"); fprintf(fp,"%s\n",""); fprintf(fp,"%s\n","--"); fprintf(fp,"%s\n","-- Table structure for table `tdbtst120000`"); fprintf(fp,"%s\n","--"); fprintf(fp,"%s\n",""); fprintf(fp,"%s\n","DROP TABLE IF EXISTS `tdbtst120000`;"); fprintf(fp,"%s\n","CREATE TABLE `tdbtst120000` ("); fprintf(fp,"%s\n"," `t_empno` int(11) NOT NULL,"); fprintf(fp,"%s\n"," `t_firstnme` varchar(20) collate latin1_bin NOT NULL,"); fprintf(fp,"%s\n"," `t_midinit` varchar(20) collate latin1_bin NOT NULL,"); fprintf(fp,"%s\n"," `t_lastname` varchar(20) collate latin1_bin NOT NULL,"); fprintf(fp,"%s\n"," `t_workdept` varchar(6) collate latin1_bin NOT NULL,"); fprintf(fp,"%s\n"," `t_phoneno_1` varchar(20) collate latin1_bin NOT NULL,"); fprintf(fp,"%s\n"," `t_phoneno_2` varchar(20) collate latin1_bin NOT NULL,"); fprintf(fp,"%s\n"," `t_phoneno_3` varchar(20) collate latin1_bin NOT NULL,"); fprintf(fp,"%s\n"," `t_hiredate` date NOT NULL,"); fprintf(fp,"%s\n"," `t_job` varchar(20) collate latin1_bin NOT NULL,"); fprintf(fp,"%s\n"," `t_edlevel` int(11) NOT NULL,"); fprintf(fp,"%s\n"," `t_sex` int(11) NOT NULL,"); fprintf(fp,"%s\n"," `t_birthdte` date NOT NULL,"); fprintf(fp,"%s\n"," `t_salary` double NOT NULL,"); fprintf(fp,"%s\n"," `t_bonus` float NOT NULL,"); fprintf(fp,"%s\n"," `t_Refcntd` int(11) NOT NULL,"); fprintf(fp,"%s\n"," `t_Refcntu` int(11) NOT NULL,"); fprintf(fp,"%s\n"," PRIMARY KEY (`t_empno`),"); fprintf(fp,"%s\n"," UNIQUE KEY `Itdbtst120000_2` (`t_workdept`,`t_empno`)"); fprintf(fp,"%s\n",") ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;"); fprintf(fp,"%s\n",""); fprintf(fp,"%s\n","--"); fprintf(fp,"%s\n","-- Dumping data for table `tdbtst120000`"); fprintf(fp,"%s\n","--"); fprintf(fp,"%s\n",""); fprintf(fp,"%s\n",""); fprintf(fp,"%s\n","/*!40000 ALTER TABLE `tdbtst120000` DISABLE KEYS */;"); fprintf(fp,"%s\n","LOCK TABLES `tdbtst120000` WRITE;"); fprintf(fp,"%s\n","INSERT INTO `tdbtst120000` VALUES (10,'CHRISTINE ','I ','HAAS ','A00 ','15972 ','1218 ','23548 ','1965-01-01','PRES ',18,2,'1933-08-24',52750,1000,0,0),(20,'MICHAEL ','L ','THOMPSON ','B01 ','5164 ','27599 ','25190 ','1973-10-10','MANAGER ',18,1,'1948-02-02',41250,800,0,0),(30,'SALLY ','A ','KWAN ','C01 ','9478 ','19968 ','2310 ','1975-04-05','MANAGER ',20,2,'1941-05-11',38250,800,0,0),(50,'JOHN ','B ','GEYER ','E01 ','4375 ','22823 ','14762 ','1949-08-17','MANAGER ',16,1,'1925-09-15',40175,800,0,0),(60,'IRVING ','F ','STERN ','D11 ','1028 ','23402 ','2418 ','1973-09-14','MANAGER ',16,1,'1945-07-07',32250,500,0,0),(70,'EVA ','D ','PULASKI ','D21 ','19520 ','22171 ','32503 ','1980-09-30','MANAGER ',16,2,'1953-05-26',36170,700,0,0),(90,'EILEEN ','W ','HENDERSON ','E11 ','6933 ','27989 ','3896 ','1970-08-15','MANAGER ',16,2,'1941-05-15',29750,600,0,0),(100,'THEODORE ','Q ','SPENSER ','E21 ','14707 ','1498 ','32072 ','1980-06-19','MANAGER ',14,1,'1956-12-18',26150,500,0,0),(110,'VINCENZO ','G ','LUCCHESSI ','A00 ','15740 ','16047 ','2234 ','1958-05-16','SALESREP ',19,1,'1929-11-05',46500,900,0,0),(120,'SEAN ',' ','O\\'CONNELL ','A00 ','3275 ','4340 ','5832 ','1963-12-05','CLERK ',14,1,'1942-10-18',29250,600,0,0),(130,'DOLORES ','M ','QUINTANA ','C01 ','14216 ','15493 ','16966 ','1971-07-28','ANALYST ',16,2,'1925-09-15',23800,500,0,0),(140,'HEATHER ','A ','NICHOLLS ','C01 ','30764 ','22995 ','32329 ','1976-12-15','ANALYST ',18,2,'1946-01-19',28420,600,0,0),(150,'BRUCE ',' ','ADAMSON ','D11 ','25621 ','11648 ','14230 ','1972-02-12','DESIGNER ',16,1,'1947-05-17',25280,500,0,0),(160,'ELIZABETH ','R ','PIANKA ','D11 ','6345 ','6588 ','8396 ','1977-10-11','DESIGNER ',17,2,'1955-04-12',22250,400,0,0),(170,'MASATOSHI ','J ','YOSHIMURA ','D11 ','29194 ','18786 ','5457 ','1978-09-15','DESIGNER ',16,1,'1951-01-05',24680,500,0,0),(180,'MARILYN ','S ','SCOUTTEN ','D11 ','5278 ','28881 ','16126 ','1973-07-07','DESIGNER ',17,2,'1949-02-21',21340,500,0,0),(190,'JAMES ','H ','WALKER ','D11 ','23003 ','16523 ','27274 ','1974-07-26','DESIGNER ',16,1,'1952-06-25',20450,400,0,0),(200,'DAVID ',' ','BROWN ','D11 ','26612 ','26000 ','14007 ','1966-03-03','DESIGNER ',16,1,'1941-05-29',27740,600,0,0),(210,'WILLIAM ','T ','JONES ','D11 ','774 ','13176 ','2622 ','1979-04-11','DESIGNER ',17,1,'1953-02-23',18270,400,0,0),(220,'JENNIFER ','K ','LUTZ ','D11 ','25314 ','21587 ','31867 ','1968-08-29','DESIGNER ',18,2,'1948-03-19',29840,600,0,0),(230,'JAMES ','J ','JEFFERSON ','D21 ','6552 ','6721 ','7385 ','1966-11-21','CLERK ',14,1,'1935-05-30',22180,400,0,0),(240,'SALVATORE ','M ','MARINO ','D21 ','22216 ','20176 ','17659 ','1979-12-05','CLERK ',17,1,'1954-03-31',28760,600,0,0),(250,'DANIEL ','S ','SMITH ','D21 ','5032 ','7192 ','25007 ','1969-10-30','CLERK ',15,1,'1939-12-12',19180,400,0,0),(260,'SYBIL ','P ','JOHNSON ','D21 ','29652 ','27544 ','24212 ','1975-09-11','CLERK ',16,2,'1936-10-05',17250,300,0,0),(270,'MARIA ','L ','PEREZ ','D21 ','26329 ','22223 ','8325 ','1980-09-30','CLERK ',15,2,'1953-05-26',27380,500,0,0),(280,'ETHEL ','R ','SCHNEIDER ','E11 ','22144 ','1434 ','15052 ','1967-03-24','OPERATOR ',17,2,'1936-03-28',26250,500,0,0),(290,'JOHN ','R ','PARKER ','E11 ','28122 ','5712 ','19208 ','1980-05-30','OPERATOR ',12,1,'1946-07-09',15340,300,0,0),(300,'PHILIP ','X ','SMITH ','E11 ','17680 ','27551 ','10202 ','1972-06-19','OPERATOR ',14,1,'1936-10-27',17750,400,0,0),(310,'MAUDE ','F ','SETRIGHT ','E11 ','32231 ','31781 ','20050 ','1964-09-12','OPERATOR ',12,2,'1931-04-21',15900,300,0,0),(320,'RAMLAL ','V ','MEHTA ','E21 ','7446 ','32718 ','14876 ','1965-07-07','FIELDREP ',16,1,'1932-08-11',19950,400,0,0),(330,'WING ',' ','LEE ','E21 ','11336 ','5872 ','5226 ','1000-01-01','FIELDREP ',14,1,'1941-07-18',25370,500,0,0),(340,'JASON ','R ','GOUNOT ','E21 ','28911 ','18216 ','26017 ','1947-05-05','FIELDREP ',16,1,'1926-05-17',23840,500,0,0);"); fprintf(fp,"%s\n","UNLOCK TABLES;"); fprintf(fp,"%s\n","/*!40000 ALTER TABLE `tdbtst120000` ENABLE KEYS */;"); fprintf(fp,"%s\n",""); fprintf(fp,"%s\n","/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;"); fprintf(fp,"%s\n","/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;"); fprintf(fp,"%s\n","/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;"); fprintf(fp,"%s\n","/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;"); fprintf(fp,"%s\n","/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;"); fprintf(fp,"%s\n","/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;"); fprintf(fp,"%s\n","/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;"); fprintf(fp,"%s\n",""); fclose(fp); const char *cmd = "mysql --user="OWNER_NAME" --password="OWNER_PWD" --host="HOST_NAME" "DB_NAME" < /tmp/baan_table_dump"; int ret = system(cmd); if ( ret != 0 ) fprintf(stderr,"Command \"mysql --user="OWNER_NAME" --password="OWNER_PWD" --host="HOST_NAME" "DB_NAME" < /tmp/baan_table_dump\" failed\n",cmd); } void create_tables( void ) { create_dbtst120000(); } #if 0 // Output of "show variables" # # Variable_name Value # auto_increment_increment 1 # auto_increment_offset 1 # automatic_sp_privileges ON # back_log 50 # basedir /usr1/mysql/mysql-5.0.6-beta-nightly-20050515-linux-i686/ # binlog_cache_size 32768 # bulk_insert_buffer_size 8388608 # character_set_client latin1 # character_set_connection latin1 # character_set_database latin1 # character_set_results latin1 # character_set_server latin1 # character_set_system utf8 # character_sets_dir /usr1/mysql/mysql-5.0.6-beta-nightly-20050515-linux-i686/share/mysql/charsets/ # collation_connection latin1_swedish_ci # collation_database latin1_swedish_ci # collation_server latin1_swedish_ci # completion_type 0 # concurrent_insert 1 # connect_timeout 5 # datadir /usr1/mysql/mysql-5.0.6-beta-nightly-20050515-linux-i686/data/ # date_format %Y-%m-%d # datetime_format %Y-%m-%d %H:%i:%s # div_precision_increment 4 # default_week_format 0 # delay_key_write ON # delayed_insert_limit 100 # delayed_insert_timeout 300 # delayed_queue_size 1000 # expire_logs_days 0 # flush OFF # flush_time 0 # ft_boolean_syntax + -><()~*:""&| # ft_max_word_len 84 # ft_min_word_len 4 # ft_query_expansion_limit 20 # ft_stopword_file (built-in) # group_concat_max_len 1024 # have_archive NO # have_bdb NO # have_blackhole_engine NO # have_compress YES # have_crypt YES # have_csv NO # have_example_engine NO # have_federated_engine NO # have_geometry YES # have_innodb YES # have_isam NO # have_ndbcluster NO # have_openssl NO # have_query_cache YES # have_raid NO # have_rtree_keys YES # have_symlink YES # init_connect # init_file # init_slave # innodb_additional_mem_pool_size 1048576 # innodb_autoextend_increment 8 # innodb_buffer_pool_awe_mem_mb 0 # innodb_buffer_pool_size 8388608 # innodb_checksums ON # innodb_concurrency_tickets 500 # innodb_data_file_path ibdata1:10M:autoextend # innodb_data_home_dir # innodb_doublewrite ON # innodb_fast_shutdown 1 # innodb_file_io_threads 4 # innodb_file_per_table OFF # innodb_flush_log_at_trx_commit 1 # innodb_flush_method # innodb_force_recovery 0 # innodb_lock_wait_timeout 10 # innodb_locks_unsafe_for_binlog OFF # innodb_log_arch_dir # innodb_log_archive OFF # innodb_log_buffer_size 1048576 # innodb_log_file_size 5242880 # innodb_log_files_in_group 2 # innodb_log_group_home_dir ./ # innodb_max_dirty_pages_pct 90 # innodb_max_purge_lag 0 # innodb_mirrored_log_groups 1 # innodb_open_files 300 # innodb_sync_spin_loops 20 # innodb_table_locks ON # innodb_support_xa ON # innodb_thread_concurrency 8 # innodb_thread_sleep_delay 10000 # interactive_timeout 28800 # join_buffer_size 131072 # key_buffer_size 16777216 # key_cache_age_threshold 300 # key_cache_block_size 1024 # key_cache_division_limit 100 # language /usr1/mysql/mysql-5.0.6-beta-nightly-20050515-linux-i686/share/mysql/english/ # large_files_support ON # large_pages OFF # large_page_size 0 # license GPL # local_infile ON # locked_in_memory OFF # log OFF # log_bin OFF # log_bin_trust_routine_creators OFF # log_error # log_slave_updates OFF # log_slow_queries OFF # log_warnings 1 # long_query_time 10 # low_priority_updates OFF # lower_case_file_system OFF # lower_case_table_names 0 # max_allowed_packet 1047552 # max_binlog_cache_size 4294967295 # max_binlog_size 1073741824 # max_connect_errors 10 # max_connections 100 # max_delayed_threads 20 # max_error_count 64 # max_heap_table_size 16777216 # max_insert_delayed_threads 20 # max_join_size 4294967295 # max_length_for_sort_data 1024 # max_relay_log_size 0 # max_seeks_for_key 4294967295 # max_sort_length 1024 # max_tmp_tables 32 # max_user_connections 0 # max_write_lock_count 4294967295 # multi_range_count 256 # myisam_data_pointer_size 6 # myisam_max_sort_file_size 2147483647 # myisam_recover_options OFF # myisam_repair_threads 1 # myisam_sort_buffer_size 8388608 # engine_condition_pushdown OFF # net_buffer_length 8192 # net_read_timeout 30 # net_retry_count 10 # net_write_timeout 60 # new OFF # old_passwords OFF # open_files_limit 1024 # optimizer_prune_level 1 # optimizer_search_depth 62 # pid_file /usr1/mysql/mysql-5.0.6-beta-nightly-20050515-linux-i686/data/nlbaldev1.pid # port 3306 # preload_buffer_size 32768 # protocol_version 10 # query_alloc_block_size 8192 # query_cache_limit 1048576 # query_cache_min_res_unit 4096 # query_cache_size 0 # query_cache_type ON # query_cache_wlock_invalidate OFF # query_prealloc_size 8192 # range_alloc_block_size 2048 # read_buffer_size 131072 # read_only OFF # read_rnd_buffer_size 262144 # relay_log_purge ON # relay_log_space_limit 0 # rpl_recovery_rank 0 # secure_auth OFF # server_id 1 # skip_external_locking ON # skip_networking OFF # skip_show_database OFF # slave_net_timeout 3600 # slave_transaction_retries 10 # slow_launch_time 2 # socket /var/lib/mysql/mysql.sock # sort_buffer_size 524252 # sql_mode # storage_engine MyISAM # sql_notes ON # sql_warnings ON # sync_binlog 0 # sync_replication 0 # sync_replication_slave_id 0 # sync_replication_timeout 10 # sync_frm ON # system_time_zone CEST # table_cache 64 # table_type MyISAM # thread_cache_size 0 # thread_stack 196608 # time_format %H:%i:%s # time_zone SYSTEM # timed_mutexes OFF # tmp_table_size 33554432 # tmpdir # transaction_alloc_block_size 8192 # transaction_prealloc_size 4096 # tx_isolation REPEATABLE-READ # updatable_views_with_limit YES # version 5.0.6-beta-nightly-20050515-debug # version_comment Source distribution # version_compile_machine i686 # version_compile_os pc-linux # wait_timeout 28800 # #endif // Output of "show variables"