mysqlbinlog segfaults with host args
$ mysqlbinlog --host=mysqlserver --table=sometable --database=somedb \ --user=someuser --password=somepassword Segmentation fault. $ strace mysqlbinlog --host=mysqlserver --table=sometable \ --database=somedb \ --user=someuser --password=somepassword (...) old_mmap(NULL, 1203040, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40119000 mprotect(0x40235000, 39776, PROT_NONE) = 0 old_mmap(0x40235000, 24576, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x11c000) = 0x40235000 old_mmap(0x4023b000, 15200, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x4023b000 close(3)= 0 mprotect(0x40051000, 49152, PROT_READ|PROT_WRITE) = 0 mprotect(0x40051000, 49152, PROT_READ|PROT_EXEC) = 0 munmap(0x40038000, 99141) = 0 --- SIGSEGV (Segmentation fault) --- +++ killed by SIGSEGV +++ This happens with any version I have installed on Linux 2.4.x, either Suse or Gentoo, gcc 2.95.3 or 3.2.1, MySQL version 3.23.x or 4.0.4 and 4.0.6. -- Nicolas MONNET (Tech) [EMAIL PROTECTED] Carpe Diem - 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: What is relay-bin log?
On Mon, 2002-10-21 at 14:25, Michael Widenius wrote: Which log files is it that you want to delete ? (Please give an example for this) If you have a problem that old relay logs are not deleted, try to upgrade to MySQL 4.0.4 ; We recently fixed a bug in this code. This is still happening with 4.0.5a (Std, with InnoDB). # grep relay /service/svc-mysql/run --relay-log=/mysql/logs/relay \ --relay-log-info-file=/mysql/logs/relay.info \ --relay_log_space_limit=500M \ # ls -al (...) -rw-rw1 mysqlmysql541557913 Dec 16 17:04 relay.001 (...) # mysqladmin processlist (...) | 2 | system user | none | | Connect | 539| Waiting for relay log space to free | (...) # mysqladmin shutdown nothing happens # svc -t /service/svc-mysql nothing still # svc -k /service/svc-mysql ; rm relay.* this works ... # mysql --version mysql Ver 12.16 Distrib 4.0.5a-beta, for pc-linux (i686) # /usr/local/libexec/mysqld --version /usr/local/libexec/mysqld Ver 4.0.5a-beta for pc-linux on i686 -- Nicolas MONNET (Tech) [EMAIL PROTECTED] Carpe Diem - 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: What is relay-bin log?
On Mon, 2002-12-16 at 16:20, Nicolas MONNET (Tech) wrote: (...) Nevermind. This was due to an error in the replication; but nonetheless, it is impossible to shutdown mysqld cleanly if it's waiting for relay logs to be freed. -- Nicolas MONNET (Tech) [EMAIL PROTECTED] Carpe Diem - 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
4.0.5: can't disable any logs!
No matter what I do on the command line for mysqld, or in my.cnf, ALL logs get activated! I'm using the Gentoo ebuilds, with mysqld started from an svscan run script for supervision. Any ideas? I'm lost here! -- Nicolas MONNET (Tech) [EMAIL PROTECTED] Carpe Diem - 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: Serwer Hardware p4 or pIII ?
On Wed, 2002-12-04 at 15:23, Helmut Apfelholz wrote: --- Simon Green [EMAIL PROTECTED] wrote: MySQL uses memory and HDD the most and so processor speed is not so important. Well, processor speed is also important, on some of our servers processors are almost 100% occupied. If your bottleneck is memory speed, you will see 100% CPU usage even if the CPU actually spend 99% of its time idle, waiting for data to come in. I'm not too up to date on the latest RAM technology, but I hear there's several types of DDR, the most expensive one being significantly faster. Or is it? Anyone care to share some insight on this? - 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: Re: 'Persistant' temporary tables
On Mon, 2002-11-18 at 15:06, [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: On Sun, 2002-11-17 at 00:08, Dan wrote: So I'd like to either keep the connection open across multiple php pages if possible, or just create normal tables and then delete them when I'm done. But the 2nd way would mean I'd have to check for the existance of the table before making it, in case someone else is logged in and already has their own tmp tables... But I don't know how to check for the existance of tables. How should I go about this? Thanks in advance! Here's how I would do it: CREATE TABLE temptablelist ( id INTEGER NOT NULL auto_increment, creation DATETIME, userVARCHAR(100) ); Then name your tables mytemptable_$id, and DROP them in a cron every so often if they're more than $some_max_age old. HTH - 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: MySql uses 98% CPU
On Mon, 2002-11-04 at 11:58, Dicky Wahyu Purnomo wrote: Pada Mon, 4 Nov 2002 11:55:59 +0100 Toni [EMAIL PROTECTED] menulis: Hello I've got mysql 3.23.47 running on a freebsd 4.5 box for long time without problems, until now that consumes nearly all available CPU. Also, I am unable to stop the server using mysqladmin -u root shutdown (the process freezes) neither can restart it. If I kill -9 the process it restarts and keeps using all my resources. Aparently there isn't any other active process on the machine. I have checked at mysql.com but I couldn't find any related information. ¿Where could this problem come from? ¿Any solution? Check the running queries show processlist ... or mysqladmin -p processlist ... or even better use mytop / mtop for some condition (high cpu usage), optimize your tables, or mysqlcheck -or -A -p You should avoid kill -9 (safe_mysqld/mysql) ... it's only for desperate move ... :D We get the same thing on FreeBSD machines quite often, and it's not related to the actual work being done; MySQL can sit idle but use up all CPU. It happens after a few days/weeks of uptime. Switching to Linux fixed it ;) The difference with what Dicky describes is that for us the MySQL servers still works; it just looks like there's a rogue thread running around doing nothing. - 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
Looking for tool to pretty print table structures
Hi there, Does any of you know of a utility to pretty print mysql table structures? I have a pretty big and messy DB I need to work on, and I would like to be able to print the table structures with nice tables. Any pointers? - 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: MySQl db as filesystem.
On Fri, 2002-10-11 at 17:07, Ed Carp wrote: Should'nt be too hard to do thanks to PODFUK® AKA uservfs: Just goes to show you that Linux is so flexible, any hare-brained idea can be implemented in software sigh. But you didn't answer my question - why would you want to do such a thing? How could it possibly be useful? Adding yet another layer of complexity to ext2fs (or ext3fs, which makes even less sense) is insane, unless you're doing it just to say you can (same goes for the idiotic idea of building an interface into MySQL to produce XML output), or for a *very* specialized application. But, as Jeff Goldblum said in the movie Independence Day, (paraphrase) Just because you can doesn't mean you should. A good reason to do it would be for example to be able to use preexisting file-based tools on the database. - 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: MySQl db as filesystem.
On Fri, 2002-10-11 at 10:06, Ed Carp wrote: At 12:58 +0200 10/10/02, Alex Polite wrote: Is there any way I could display a MySQL database as a filesystem under Linux? What does that mean? I think he wants to mount a MySQL database as a filesystem, like CFS with the loopback driver. The answer is almost certainly no - why would you want to do such a thing? sql, query Should'nt be too hard to do thanks to PODFUK® AKA uservfs: http://uservfs.sf.net - 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