what does it mean? bug or feature?
Hello mysql, mysql version: 4.0.14-standard for linux linux kernel: 2.4.21 mysqladmin -umef -p shutdown Enter password: ./bin/mysqld_safe: line 1: 31500 Segmentation fault nohup /usr/local/mysql/bin/mysqld --defaults-file=/var/lib/mysql/my.cnf --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/sight2.pid --skip-locking --log-slow-queries /var/lib/mysql/server.err 21 Number of processes running now: 1 mysqld process hanging, pid 31502 - killed 030730 00:45:52 mysqld restarted -- Best regards, Andrey mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Recovery in MySql
Hello Inbal, Wednesday, January 29, 2003, 4:13:24 PM, you wrote: IO Hi All, IO I have MySql on Windows. IO Today i had an electrical power interruption in the middle of working. IO The database remain not consistent and i could not continue working with it. IO Is there any Recovery after crash mechanism in mySql? IO Thanks, Inbal http://www.mysql.com/doc/en/Disaster_Prevention.html -- Best regards, Andreymailto:[EMAIL PROTECTED] - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Nothing about logs in startup options but logs created
From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] 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-rw1 mysqlmysql 4270959 Jan 11 22:47 /var/lib/mysql/sql3-bin.001 -rw-rw1 mysqlmysql 260107 Jan 11 22:45 /var/lib/mysql/sql3-slow.log -rw-rw1 mysqlmysql21915456 Jan 11 22:47 /var/lib/mysql/sql3.log How-To-Repeat: Simply run mysqld. Fix: I don't know. Submitter-Id: submitter ID Originator: Organization: organization of PR author (multiple lines) MySQL support: none Synopsis: synopsis of the problem (one line) 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-x1 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 lrwxrwxrwx1 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How disable query log?
Hi, all! I am compile mysql-4.0.9 for PPC64 with GLIBC64. It's nothing about logging in mysql.server startup script and in my.cnf, but mysqld create log file and write a lot of queries to it. How i can disable this? My configure options: ./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 --without-debug --without-isam --with-extra-charsets=complex - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: How disable query log?
It's *nothing* about query logging in configuration files! # 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 Friday, January 10, 2003, 10:25:00 PM, you wrote: PD At 18:59 +0300 1/10/03, Andrey V. Ignatov wrote: Hi, all! I am compile mysql-4.0.9 for PPC64 with GLIBC64. It's nothing about logging in mysql.server startup script and in my.cnf, but mysqld create log file and write a lot of queries to it. How i can disable this? My configure options: ./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 --without-debug --without-isam --with-extra-charsets=complex PD The log isn't enabled by default, so it must be getting turned on PD *somewhere* at startup time. Check all your option files, not just PD one. Run this command to check what options are getting passed to PD it from option files: PD mysqld --print-defaults - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[3]: How disable query log?
1) logs file names: hostname.log , hostname-bin.001-4 and all of them created in datadir. hostname = sql3 2) i am delete all log files from /var/lib/mysql and run mysqld --user=mysql And all files create again :( -rw-rw1 mysqlmysql 14686 Jan 11 01:40 sql3-bin.001 -rw-rw1 mysqlmysql 15 Jan 11 01:39 sql3-bin.index -rw-rw1 mysqlmysql 149 Jan 11 01:39 sql3-slow.log -rw-rw1 mysqlmysql 11640 Jan 11 01:40 sql3.001 -rw-rw1 mysqlmysql 143581 Jan 11 01:40 sql3.log -rw-rw1 mysqlmysql 5 Jan 11 01:39 sql3.pid Saturday, January 11, 2003, 2:16:29 AM, you wrote: PD At 23:45 +0300 1/10/03, Andrey V. Ignatov wrote: It's *nothing* about query logging in configuration files! PD Okay, that's strange. Next step: PD - What's the name of the log file that the server is logging to? PD - Does logging occur if you shut down the server (with mysql.server stop, PDfor example), and then start mysqld manually? Friday, January 10, 2003, 10:25:00 PM, you wrote: PD At 18:59 +0300 1/10/03, Andrey V. Ignatov wrote: Hi, all! I am compile mysql-4.0.9 for PPC64 with GLIBC64. It's nothing about logging in mysql.server startup script and in my.cnf, but mysqld create log file and write a lot of queries to it. How i can disable this? PD The log isn't enabled by default, so it must be getting turned on PD *somewhere* at startup time. Check all your option files, not just PD one. Run this command to check what options are getting passed to PD it from option files: - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php