Nothing about logs in startup options but logs created
Nothing about logs in startup options but logs created
am 11.01.2003 21:49:16 von Andrey
From: andrey@emax.ru
To: mysql@lists.mysql.com
Subject: Nothing about logs in startup options but logs created
>Description:
It's nothing in /etc/init.d/mysql.server and my.cnf files about logs. But if i start mysqld
with '/etc/init.d/mysql.server start' or standalane by 'mysqld --user=mysql' logs files immediately
created. Logs file created in mysql datadir:
-rw-rw---- 1 mysql mysql 4270959 Jan 11 22:47 /var/lib/mysql/sql3-bin.001
-rw-rw---- 1 mysql mysql 260107 Jan 11 22:45 /var/lib/mysql/sql3-slow.log
-rw-rw---- 1 mysql mysql 21915456 Jan 11 22:47 /var/lib/mysql/sql3.log
>How-To-Repeat:
Simply run mysqld.
>Fix:
I don't know.
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: none
>Synopsis:
>Severity: non-critical
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.9-gamma (Source distribution)
>C compiler: gcc (GCC) 3.2.1
>C++ compiler: g++ (GCC) 3.2.1
>Environment:
System: Linux sql3 2.4.21-pre3 #2 SMP Fri Jan 10 12:07:26 EET 2003 ppc64 unknown unknown GNU/Linux
Architecture: ppc64
Some paths: /usr/bin/perl /usr/bin/make /opt/ppc64/powerpc64-linux/bin/gcc /opt/ppc64/powerpc64-linux/bin/cc
GCC: Reading specs from /opt/ppc64/lib/gcc-lib/powerpc64-linux/3.2.1/specs
Configured with: /var/mef/glibc64/src/gcc-3.2.1/configure --build=powerpc-linux --host=powerpc-linux --target=powerpc64-linux --enable-languages=c,c++,f77 --enable-__cxa_atexit --disable-nls --prefix=/opt/ppc64
Thread model: posix
gcc version 3.2.1
Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' ASFLAGS=''
LIBC: (64-bit GLIBC)
-rwxr-xr-x 1 root root 1668120 Jan 10 16:20 /opt/ppc64/powerpc64-linux/lib/libc-2.3.1.so
-rw-r--r-- 1 root root 2375846 Jan 10 16:20 /opt/ppc64/powerpc64-linux/lib/libc.a
-rw-r--r-- 1 root root 226 Jan 7 18:16 /opt/ppc64/powerpc64-linux/lib/libc.so
lrwxrwxrwx 1 root root 13 Jan 7 18:17 /opt/ppc64/powerpc64-linux/lib/libc.so.6 -> libc-2.3.1.so
-rw-r--r-- 1 root root 7112 Jan 10 16:20 /opt/ppc64/powerpc64-linux/lib/libc_nonshared.a
Configure command: ./configure '--without-berkley-db' '--with-named-curses-libs=/opt/ncurses-5.3/lib/libncurses.a' '--build=powerpc64-linux' '--prefix=/usr/local/mysql' '--localstatedir=/var/lib/mysql' '--sysconfdir=/etc/mysql' '--sbindir=/usr/local/mysql/bin' '--libexecdir=/usr/local/mysql/bin' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' /usr/local/mysql/bin' '--libexecdir=/usr/local/mysql/bin' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock'
Output from mysqld --print-defaults:
mysqld would have been started with the following arguments:
--port=3306
--socket=/var/run/mysqld/mysqld.sock
--skip-locking
--set-variable=max_connect_errors=1000
--set-variable=max_connections=600
--default-character-set=win1251
--set-variable=key_buffer=128M
--set-variable=max_allowed_packet=1M
--set-variable=table_cache=512
--set-variable=sort_buffer=2M
--set-variable=record_buffer=2M
--set-variable=thread_cache=12
--set-variable=thread_concurrency=6
--set-variable=myisam_sort_buffer_size=64M
--set-variable=query_cache_size=64M
--set-variable=query_cache_limit=1M
--set-variable=query_cache_type=1
--innodb_data_home_dir=/var/lib/mysql/
--innodb_data_file_path=ibdata1:1500M;ibdata2:1500M;ibdata3: 1500M;ibdata4:1500M;ibdata5:1500M:autoextend
--innodb_log_group_home_dir=/var/lib/mysql/
--innodb_log_arch_dir=/var/lib/mysql/
--set-variable=innodb_buffer_pool_size=256M
--set-variable=innodb_additional_mem_pool_size=20M
--set-variable=innodb_log_file_size=128M
--set-variable=innodb_log_buffer_size=8M
--innodb_flush_log_at_trx_commit=0
--set-variable=innodb_lock_wait_timeout=20
--set-variable=innodb_thread_concurrency=6
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail bugs-thread13461@lists.mysql.com
To unsubscribe, e-mail
Re: Nothing about logs in startup options but logs created
am 12.01.2003 21:08:49 von Peter Zaitsev
On Saturday 11 January 2003 23:49, Andrey V. Ignatov wrote:
> From: andrey@emax.ru
> To: mysql@lists.mysql.com
> Subject: Nothing about logs in startup options but logs
> created
Dear Anderey,
Thank your for your bug report.
This looks like rather strange problem. I can't be sure if it
is the bug as MySQL does not only reads options single my.cnf
file, so it is rather possible logging is enabled in other file.
Moreover nowdays it is possible to enable query runtime by
setting appropriate GLOBAL variable.
Could you please send me your "variables" output ?
Could you please starting mysqld from mysql_safe with
--defaults-file=/etc/my.cnf on different port and socket this
would skip reading of all other configuration files as well as
possible setting logging option from the program. Also you may
run with --no-defaults option and set all required options from
command line.
If you'll still have desctibed behavior we'll have to investigate
the problem firther.
>
> >Description:
>
> It's nothing in /etc/init.d/mysql.server and
> my.cnf files about logs. But if i start mysqld with
> '/etc/init.d/mysql.server start' or standalane by 'mysqld
> --user=mysql' logs files immediately created. Logs file
> created in mysql datadir: -rw-rw---- 1 mysql mysql
> 4270959 Jan 11 22:47 /var/lib/mysql/sql3-bin.001 -rw-rw----
> 1 mysql mysql 260107 Jan 11 22:45
> /var/lib/mysql/sql3-slow.log -rw-rw---- 1 mysql mysql
> 21915456 Jan 11 22:47 /var/lib/mysql/sql3.log
>
> >How-To-Repeat:
>
> Simply run mysqld.
>
> >Fix:
>
> I don't know.
>
> >Submitter-Id:
> >Originator:
> >Organization:
>
>
>
> >MySQL support: none
> >Synopsis:
> >Severity: non-critical
> >Priority: medium
> >Category: mysql
> >Class: sw-bug
> >Release: mysql-4.0.9-gamma (Source distribution)
> >
> >C compiler: gcc (GCC) 3.2.1
> >C++ compiler: g++ (GCC) 3.2.1
> >Environment:
>
> System: Linux sql3 2.4.21-pre3 #2 SMP Fri Jan 10 12:07:26 EET
> 2003 ppc64 unknown unknown GNU/Linux Architecture: ppc64
>
> Some paths: /usr/bin/perl /usr/bin/make
> /opt/ppc64/powerpc64-linux/bin/gcc
> /opt/ppc64/powerpc64-linux/bin/cc GCC: Reading specs from
> /opt/ppc64/lib/gcc-lib/powerpc64-linux/3.2.1/specs Configured
> with: /var/mef/glibc64/src/gcc-3.2.1/configure
> --build=powerpc-linux --host=powerpc-linux
> --target=powerpc64-linux --enable-languages=c,c++,f77
> --enable-__cxa_atexit --disable-nls --prefix=/opt/ppc64 Thread
> model: posix
> gcc version 3.2.1
> Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS=''
> LDFLAGS='' ASFLAGS='' LIBC: (64-bit GLIBC)
> -rwxr-xr-x 1 root root 1668120 Jan 10 16:20
> /opt/ppc64/powerpc64-linux/lib/libc-2.3.1.so -rw-r--r-- 1
> root root 2375846 Jan 10 16:20
> /opt/ppc64/powerpc64-linux/lib/libc.a -rw-r--r-- 1 root
> root 226 Jan 7 18:16
> /opt/ppc64/powerpc64-linux/lib/libc.so lrwxrwxrwx 1 root
> root 13 Jan 7 18:17
> /opt/ppc64/powerpc64-linux/lib/libc.so.6 -> libc-2.3.1.so
> -rw-r--r-- 1 root root 7112 Jan 10 16:20
> /opt/ppc64/powerpc64-linux/lib/libc_nonshared.a Configure
> command: ./configure '--without-berkley-db'
> '--with-named-curses-libs=/opt/ncurses-5.3/lib/libncurses.a'
> '--build=powerpc64-linux' '--prefix=/usr/local/mysql'
> '--localstatedir=/var/lib/mysql' '--sysconfdir=/etc/mysql'
> '--sbindir=/usr/local/mysql/bin'
> '--libexecdir=/usr/local/mysql/bin'
> '--with-unix-socket-path=/var/run/mysqld/mysqld.sock'
> /usr/local/mysql/bin' '--libexecdir=/usr/local/mysql/bin'
> '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' Output
> from mysqld --print-defaults:
> mysqld would have been started with the following arguments:
> --port=3306
> --socket=/var/run/mysqld/mysqld.sock
> --skip-locking
> --set-variable=max_connect_errors=1000
> --set-variable=max_connections=600
> --default-character-set=win1251
> --set-variable=key_buffer=128M
> --set-variable=max_allowed_packet=1M
> --set-variable=table_cache=512
> --set-variable=sort_buffer=2M
> --set-variable=record_buffer=2M
> --set-variable=thread_cache=12
> --set-variable=thread_concurrency=6
> --set-variable=myisam_sort_buffer_size=64M
> --set-variable=query_cache_size=64M
> --set-variable=query_cache_limit=1M
> --set-variable=query_cache_type=1
> --innodb_data_home_dir=/var/lib/mysql/
> --innodb_data_file_path=ibdata1:1500M;ibdata2:1500M;ibdata3: 15
>00M;ibdata4:1500M;ibdata5:1500M:autoextend
> --innodb_log_group_home_dir=/var/lib/mysql/
> --innodb_log_arch_dir=/var/lib/mysql/
> --set-variable=innodb_buffer_pool_size=256M
> --set-variable=innodb_additional_mem_pool_size=20M
> --set-variable=innodb_log_file_size=128M
> --set-variable=innodb_log_buffer_size=8M
> --innodb_flush_log_at_trx_commit=0
> --set-variable=innodb_lock_wait_timeout=20
> --set-variable=innodb_thread_concurrency=6
>
>
>
> ------------------------------------------------------------ --
>------- Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail
> bugs-thread13461@lists.mysql.com To unsubscribe, e-mail
>
--
MySQL 2003 Users Conf. -> http://www.mysql.com/events/uc2003/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Peter Zaitsev
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Moscow, Russia
<___/ www.mysql.com
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail bugs-thread13465@lists.mysql.com
To unsubscribe, e-mail
Re[2]: Nothing about logs in startup options but logs created
am 12.01.2003 22:25:25 von Andrey
Sunday, January 12, 2003, 11:08:49 PM, you wrote:
PZ> On Saturday 11 January 2003 23:49, Andrey V. Ignatov wrote:
>> Subject: Nothing about logs in startup options but logs
>> created
PZ> Thank your for your bug report.
PZ> Could you please send me your "variables" output ?
It's my default configuration output:
| back_log | 50
| basedir | /usr/local/mysql-4.0.9-gamma/
| binlog_cache_size | 32768
| bulk_insert_buffer_size | 8388608
| character_set | win1251
| character_sets | latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos
german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek
win1250 croat cp1257 latin5
| concurrent_insert | ON
| connect_timeout | 5
| convert_character_set |
| datadir | /var/lib/mysql/
| delay_key_write | ON
| delayed_insert_limit | 100
| delayed_insert_timeout | 300
| delayed_queue_size | 1000
| flush | OFF
| flush_time | 0
| ft_min_word_len | 4
| ft_max_word_len | 254
| ft_max_word_len_for_sort | 20
| ft_boolean_syntax | + -><()~*:""&|
| have_bdb | NO
| have_innodb | YES
| have_isam | NO
| have_raid | NO
| have_symlink | DISABLED
| have_openssl | NO
| have_query_cache | YES
| init_file |
| innodb_additional_mem_pool_size | 20971520
| innodb_buffer_pool_size | 268435456
| innodb_data_file_path |
ibdata1:1500M;ibdata2:1500M;ibdata3:1500M;ibdata4:1500M;ibda ta5:1500M:autoextend
| innodb_data_home_dir | /var/lib/mysql/
| innodb_file_io_threads | 4
| innodb_force_recovery | 0
| innodb_thread_concurrency | 6
| innodb_flush_log_at_trx_commit | 0
| innodb_fast_shutdown | ON
| innodb_flush_method |
| innodb_lock_wait_timeout | 20
| innodb_log_arch_dir | /var/lib/mysql/
| innodb_log_archive | OFF
| innodb_log_buffer_size | 8388608
| innodb_log_file_size | 134217728
| innodb_log_files_in_group | 2
| innodb_log_group_home_dir | /var/lib/mysql/
| innodb_mirrored_log_groups | 1
| interactive_timeout | 28800
| join_buffer_size | 131072
| key_buffer_size | 134217728
| language | /usr/local/mysql-4.0.9-gamma/share/mysql/english/
| large_files_support | ON
| local_infile | ON
| locked_in_memory | OFF
| log | ON
| log_update | ON
| log_bin | ON
| log_slave_updates | OFF
| log_slow_queries | ON
| log_warnings | OFF
| long_query_time | 10
| low_priority_updates | OFF
| lower_case_table_names | OFF
| max_allowed_packet | 1047552
| max_binlog_cache_size | 4294967295
| max_binlog_size | 1073741824
| max_connections | 600
| max_connect_errors | 1000
| max_delayed_threads | 20
| max_heap_table_size | 16777216
| max_join_size | 18446744073709551615
| max_sort_length | 1024
| max_user_connections | 0
| max_tmp_tables | 32
| max_write_lock_count | 4294967295
| myisam_max_extra_sort_file_size | 268435456
| myisam_max_sort_file_size | 9223372036854775807
| myisam_recover_options | OFF
| myisam_sort_buffer_size | 67108864
| net_buffer_length | 16384
| net_read_timeout | 30
| net_retry_count | 10
| net_write_timeout | 60
| open_files_limit | 0
| pid_file | /var/lib/mysql/sql3.pid
| port | 3306
| protocol_version | 10
| read_buffer_size | 2093056
| read_rnd_buffer_size | 262144
| rpl_recovery_rank | 0
| query_cache_limit | 1048576
| query_cache_size | 67108864
| query_cache_type | ON
| server_id | 1
| slave_net_timeout | 3600
| skip_external_locking | ON
| skip_networking | OFF
| skip_show_database | OFF
| slow_launch_time | 2
| socket | /var/run/mysqld/mysqld.sock
| sort_buffer_size | 2097144
| sql_mode | 0
| table_cache | 512
| table_type | MYISAM
| thread_cache_size | 12
| thread_stack | 65536
| tx_isolation | REPEATABLE-READ
| timezone | Local time zone must be set--see z
| tmp_table_size | 33554432
| tmpdir | /tmp/
| version | 4.0.9-gamma-log
| wait_timeout | 28800
PZ> Could you please starting mysqld from mysql_safe with
PZ> --defaults-file=/etc/my.cnf on different port and socket this
PZ> would skip reading of all other configuration files as well as
PZ> possible setting logging option from the program. Also you may
PZ> run with --no-defaults option and set all required options from
PZ> command line.
I run mysqld_safe --no-defaults --port 3333 --pid-file=/var/mef/bugs/mysql/sql3.pid
--socket=/var/mef/bugs/mysql/mysql.sock --datadir=/var/mef/bugs/mysql
And get 'variables':
| back_log | 50
| basedir | /usr/local/mysql-4.0.9-gamma/
| binlog_cache_size | 32768
| bulk_insert_buffer_size | 8388608
| character_set | latin1
| character_sets | latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos
german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek
win1250 croat cp1257 latin5 |
| concurrent_insert | ON
| connect_timeout | 5
| convert_character_set |
| datadir | /var/mef/bugs/mysql/
| delay_key_write | ON
| delayed_insert_limit | 100
| delayed_insert_timeout | 300
| delayed_queue_size | 1000
| flush | OFF
| flush_time | 0
| ft_min_word_len | 4
| ft_max_word_len | 254
| ft_max_word_len_for_sort | 20
| ft_boolean_syntax | + -><()~*:""&|
| have_bdb | NO
| have_innodb | YES
| have_isam | NO
| have_raid | NO
| have_symlink | DISABLED
| have_openssl | NO
| have_query_cache | YES
| init_file |
| innodb_additional_mem_pool_size | 1048576
| innodb_buffer_pool_size | 8388608
| innodb_data_file_path | ibdata1:10M:autoextend
| innodb_data_home_dir |
| innodb_file_io_threads | 4
| innodb_force_recovery | 0
| innodb_thread_concurrency | 8
| innodb_flush_log_at_trx_commit | 0
| innodb_fast_shutdown | ON
| innodb_flush_method |
| innodb_lock_wait_timeout | 50
| 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_mirrored_log_groups | 1
| interactive_timeout | 28800
| join_buffer_size | 131072
| key_buffer_size | 8388600
| language | /usr/local/mysql-4.0.9-gamma/share/mysql/english/
| large_files_support | ON
| local_infile | ON
| locked_in_memory | OFF
| log | ON
| log_update | ON
| log_bin | ON
| log_slave_updates | OFF
| log_slow_queries | ON
| log_warnings | OFF
| long_query_time | 10
| low_priority_updates | OFF
| lower_case_table_names | OFF
| max_allowed_packet | 1048576
| max_binlog_cache_size | 4294967295
| max_binlog_size | 1073741824
| max_connections | 100
| max_connect_errors | 10
| max_delayed_threads | 20
| max_heap_table_size | 16777216
| max_join_size | 18446744073709551615
| max_sort_length | 1024
| max_user_connections | 0
| max_tmp_tables | 32
| max_write_lock_count | 4294967295
| myisam_max_extra_sort_file_size | 268435456
| myisam_max_sort_file_size | 9223372036854775807
| myisam_recover_options | OFF
| myisam_sort_buffer_size | 8388608
| net_buffer_length | 16384
| net_read_timeout | 30
| net_retry_count | 10
| net_write_timeout | 60
| open_files_limit | 0
| pid_file | /var/mef/bugs/mysql/sql3.pid
| port | 3333
| protocol_version | 10
| read_buffer_size | 131072
| read_rnd_buffer_size | 262144
| rpl_recovery_rank | 0
| query_cache_limit | 1048576
| query_cache_size | 0
| query_cache_type | ON
| server_id | 1
| slave_net_timeout | 3600
| skip_external_locking | ON
| skip_networking | OFF
| skip_show_database | OFF
| slow_launch_time | 2
| socket | /var/mef/bugs/mysql/mysql.sock
| sort_buffer_size | 2097144
| sql_mode | 0
| table_cache | 64
| table_type | MYISAM
| thread_cache_size | 0
| thread_stack | 65536
| tx_isolation | REPEATABLE-READ
| timezone | Local time zone must be set--see z
| tmp_table_size | 33554432
| tmpdir | /tmp/
| version | 4.0.9-gamma-log
| wait_timeout | 28800
PZ> If you'll still have desctibed behavior we'll have to investigate
PZ> the problem firther.
And in both configurations logging enabled :((
>>
>> >Description:
>>
>> It's nothing in /etc/init.d/mysql.server and
>> my.cnf files about logs. But if i start mysqld with
>> '/etc/init.d/mysql.server start' or standalane by 'mysqld
>> --user=mysql' logs files immediately created. Logs file
>> created in mysql datadir: -rw-rw---- 1 mysql mysql
>> 4270959 Jan 11 22:47 /var/lib/mysql/sql3-bin.001 -rw-rw----
>> 1 mysql mysql 260107 Jan 11 22:45
>> /var/lib/mysql/sql3-slow.log -rw-rw---- 1 mysql mysql
>> 21915456 Jan 11 22:47 /var/lib/mysql/sql3.log
>>
>> >How-To-Repeat:
>>
>> Simply run mysqld.
>>
>> >Fix:
>>
>> I don't know.
>>
>> >Submitter-Id:
>> >Originator:
>> >Organization:
>>
>>
>>
>> >MySQL support: none
>> >Synopsis:
>> >Severity: non-critical
>> >Priority: medium
>> >Category: mysql
>> >Class: sw-bug
>> >Release: mysql-4.0.9-gamma (Source distribution)
>> >
>> >C compiler: gcc (GCC) 3.2.1
>> >C++ compiler: g++ (GCC) 3.2.1
>> >Environment:
>>
>> System: Linux sql3 2.4.21-pre3 #2 SMP Fri Jan 10 12:07:26 EET
>> 2003 ppc64 unknown unknown GNU/Linux Architecture: ppc64
>>
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail bugs-thread13466@lists.mysql.com
To unsubscribe, e-mail
Re: Nothing about logs in startup options but logs created
am 12.01.2003 22:34:12 von Paul DuBois
At 23:08 +0300 1/12/03, Peter Zaitsev wrote:
>On Saturday 11 January 2003 23:49, Andrey V. Ignatov wrote:
>> From: andrey@emax.ru
>> To: mysql@lists.mysql.com
>> Subject: Nothing about logs in startup options but logs
>> created
>
>
>Dear Anderey,
>
>Thank your for your bug report.
>
>This looks like rather strange problem. I can't be sure if it
>is the bug as MySQL does not only reads options single my.cnf
>file, so it is rather possible logging is enabled in other file.
>Moreover nowdays it is possible to enable query runtime by
>setting appropriate GLOBAL variable.
Peter,
A little earlier history. I'd asked Andrey to post the output of
mysqld --print-defaults to see if it was picking up logging options
from *any* of the options files, and there was nothing in the output
to indicate logging.
Looks pretty mysterious to me as well. I don't see the cause.
>
>
>Could you please send me your "variables" output ?
>
>Could you please starting mysqld from mysql_safe with
>--defaults-file=/etc/my.cnf on different port and socket this
>would skip reading of all other configuration files as well as
>possible setting logging option from the program. Also you may
>run with --no-defaults option and set all required options from
>command line.
>
>If you'll still have desctibed behavior we'll have to investigate
>the problem firther.
>
>
>>
>> >Description:
>>
>> It's nothing in /etc/init.d/mysql.server and
>> my.cnf files about logs. But if i start mysqld with
>> '/etc/init.d/mysql.server start' or standalane by 'mysqld
>> --user=mysql' logs files immediately created. Logs file
>> created in mysql datadir: -rw-rw---- 1 mysql mysql
>> 4270959 Jan 11 22:47 /var/lib/mysql/sql3-bin.001 -rw-rw----
>> 1 mysql mysql 260107 Jan 11 22:45
>> /var/lib/mysql/sql3-slow.log -rw-rw---- 1 mysql mysql
>> 21915456 Jan 11 22:47 /var/lib/mysql/sql3.log
>>
>> >How-To-Repeat:
>>
>> Simply run mysqld.
>>
>> >Fix:
>>
>> I don't know.
>>
>> >Submitter-Id:
>> >Originator:
>> >Organization:
>>
>>
>>
>> >MySQL support: none
>> >Synopsis:
>> >Severity: non-critical
>> >Priority: medium
>> >Category: mysql
>> >Class: sw-bug
>> >Release: mysql-4.0.9-gamma (Source distribution)
>> >
>> >C compiler: gcc (GCC) 3.2.1
>> >C++ compiler: g++ (GCC) 3.2.1
>> >Environment:
>>
>> System: Linux sql3 2.4.21-pre3 #2 SMP Fri Jan 10 12:07:26 EET
>> 2003 ppc64 unknown unknown GNU/Linux Architecture: ppc64
>>
>> Some paths: /usr/bin/perl /usr/bin/make
>> /opt/ppc64/powerpc64-linux/bin/gcc
>> /opt/ppc64/powerpc64-linux/bin/cc GCC: Reading specs from
>> /opt/ppc64/lib/gcc-lib/powerpc64-linux/3.2.1/specs Configured
>> with: /var/mef/glibc64/src/gcc-3.2.1/configure
>> --build=powerpc-linux --host=powerpc-linux
>> --target=powerpc64-linux --enable-languages=c,c++,f77
>> --enable-__cxa_atexit --disable-nls --prefix=/opt/ppc64 Thread
>> model: posix
>> gcc version 3.2.1
>> Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS=''
>> LDFLAGS='' ASFLAGS='' LIBC: (64-bit GLIBC)
>> -rwxr-xr-x 1 root root 1668120 Jan 10 16:20
>> /opt/ppc64/powerpc64-linux/lib/libc-2.3.1.so -rw-r--r-- 1
>> root root 2375846 Jan 10 16:20
>> /opt/ppc64/powerpc64-linux/lib/libc.a -rw-r--r-- 1 root
>> root 226 Jan 7 18:16
>> /opt/ppc64/powerpc64-linux/lib/libc.so lrwxrwxrwx 1 root
>> root 13 Jan 7 18:17
>> /opt/ppc64/powerpc64-linux/lib/libc.so.6 -> libc-2.3.1.so
>> -rw-r--r-- 1 root root 7112 Jan 10 16:20
>> /opt/ppc64/powerpc64-linux/lib/libc_nonshared.a Configure
>> command: ./configure '--without-berkley-db'
>> '--with-named-curses-libs=/opt/ncurses-5.3/lib/libncurses.a'
>> '--build=powerpc64-linux' '--prefix=/usr/local/mysql'
>> '--localstatedir=/var/lib/mysql' '--sysconfdir=/etc/mysql'
>> '--sbindir=/usr/local/mysql/bin'
> > '--libexecdir=/usr/local/mysql/bin'
>> '--with-unix-socket-path=/var/run/mysqld/mysqld.sock'
>> /usr/local/mysql/bin' '--libexecdir=/usr/local/mysql/bin'
>> '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' Output
>> from mysqld --print-defaults:
>> mysqld would have been started with the following arguments:
>> --port=3306
>> --socket=/var/run/mysqld/mysqld.sock
>> --skip-locking
>> --set-variable=max_connect_errors=1000
>> --set-variable=max_connections=600
>> --default-character-set=win1251
>> --set-variable=key_buffer=128M
>> --set-variable=max_allowed_packet=1M
>> --set-variable=table_cache=512
>> --set-variable=sort_buffer=2M
>> --set-variable=record_buffer=2M
>> --set-variable=thread_cache=12
>> --set-variable=thread_concurrency=6
>> --set-variable=myisam_sort_buffer_size=64M
>> --set-variable=query_cache_size=64M
>> --set-variable=query_cache_limit=1M
>> --set-variable=query_cache_type=1
>> --innodb_data_home_dir=/var/lib/mysql/
>> --innodb_data_file_path=ibdata1:1500M;ibdata2:1500M;ibdata3: 15
>>00M;ibdata4:1500M;ibdata5:1500M:autoextend
>> --innodb_log_group_home_dir=/var/lib/mysql/
>> --innodb_log_arch_dir=/var/lib/mysql/
>> --set-variable=innodb_buffer_pool_size=256M
>> --set-variable=innodb_additional_mem_pool_size=20M
>> --set-variable=innodb_log_file_size=128M
>> --set-variable=innodb_log_buffer_size=8M
>> --innodb_flush_log_at_trx_commit=0
>> --set-variable=innodb_lock_wait_timeout=20
>> --set-variable=innodb_thread_concurrency=6
>>
>>
>>
>> ------------------------------------------------------------ --
>>------- Before posting, please check:
>> http://www.mysql.com/manual.php (the manual)
>> http://lists.mysql.com/ (the list archive)
>>
>> To request this thread, e-mail
>> bugs-thread13461@lists.mysql.com To unsubscribe, e-mail
>>
>
>--
> MySQL 2003 Users Conf. -> http://www.mysql.com/events/uc2003/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Peter Zaitsev
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
> /_/ /_/\_, /___/\___\_\___/ Moscow, Russia
> <___/ www.mysql.com
>
>
>----------------------------------------------------------- ----------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail bugs-thread13465@lists.mysql.com
>To unsubscribe, e-mail
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail bugs-thread13467@lists.mysql.com
To unsubscribe, e-mail
Re: Re[2]: Nothing about logs in startup options but logs created
am 17.01.2003 17:15:47 von Peter Zaitsev
On Monday 13 January 2003 00:13, Andrey V. Ignatov wrote:
> Sunday, January 12, 2003, 11:08:49 PM, you wrote:
>
> PZ> On Saturday 11 January 2003 23:49, Andrey V. Ignatov wrote:
> >> From: andrey@emax.ru
> >> To: mysql@lists.mysql.com
> >> Subject: Nothing about logs in startup options but logs
> >> created
>
> PZ> This looks like rather strange problem. I can't be sure
> if it PZ> is the bug as MySQL does not only reads options
> single my.cnf PZ> file, so it is rather possible logging is
> enabled in other file. PZ> Moreover nowdays it is possible to
> enable query runtime by PZ> setting appropriate GLOBAL
> variable.
I've added the bug to our bug tracking system. We shall
investigate the problem
Would it be possible for you to provide us with access to
Linux/PPC64 so we could debug the problem ?
also I'm wondering if mysql-test passes for you on this platform
?
--
MySQL 2003 Users Conf. -> http://www.mysql.com/events/uc2003/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Peter Zaitsev
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Moscow, Russia
<___/ www.mysql.com
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail bugs-thread13514@lists.mysql.com
To unsubscribe, e-mail
Re[4]: Nothing about logs in startup options but logs created
am 17.01.2003 18:21:08 von Andrey
Friday, January 17, 2003, 7:15:47 PM, you wrote:
PZ> On Monday 13 January 2003 00:13, Andrey V. Ignatov wrote:
>> Sunday, January 12, 2003, 11:08:49 PM, you wrote:
>>
>> PZ> On Saturday 11 January 2003 23:49, Andrey V. Ignatov wrote:
>> >> From: andrey@emax.ru
>> >> To: mysql@lists.mysql.com
>> >> Subject: Nothing about logs in startup options but logs
>> >> created
PZ> I've added the bug to our bug tracking system. We shall
PZ> investigate the problem
Ok. Thanks :)
PZ> Would it be possible for you to provide us with access to
PZ> Linux/PPC64 so we could debug the problem ?
I am not sure about access. Could I help to debug this problem with
something else?
PZ> also I'm wondering if mysql-test passes for you on this platform
PZ> ?
Yes mysql passed all tests from mysql test case with my configure
options.
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail bugs-thread13515@lists.mysql.com
To unsubscribe, e-mail