Re: MySQL 5.1.24-rc has been released (part 1 of 2)

2008-04-16 Thread Christian Hammers
On Wed, 16 Apr 2008 16:43:01 +0200 Kent Boortz <[EMAIL PROTECTED]> wrote: > > * Disk Data: Important Change: It is no longer possible on >32-bit systems to issue statements appearing to create Disk >Data log files or data files greater than 4 GB in size. >(Trying to create log files o

Re: Stored proc permissions question

2007-02-28 Thread Christian Hammers
On 2007-02-28 Gary W. Smith wrote: ... > If I'm understanding the docs correct (which I'm probably not), I should > create the procedure with [EMAIL PROTECTED] > > CREATE [EMAIL PROTECTED] PROCEDURE Better add "SQL SECURITY DEFINER" to it. .. > The next question is what permissions do I need t

Re: Stored proc permissions question

2007-02-28 Thread Christian Hammers
On 2007-02-28 Gary W. Smith wrote: > Basically, here is the stored proc. It works, but only for root. Is it > possible to allow user to execute this without having SELECT access to > the table users? If so, how? Do you know about the "SQL SECURITY { DEFINER | INVOKER }" options to CREATE PRO

Re: Key buffer partially unused - why

2007-02-20 Thread Christian Hammers
On 2007-02-20 Martijn van den Burg wrote: > Hi, > > I have allocated 500MB to key_buffer_size, but only 324MB is in use > (64%). > > Am I right to assume that this can mean one of the following: (1) all > indexes have already been cached and together they are just 324 MB, Do "find /var/lib/mysq

Re: No Data on table

2007-02-19 Thread Christian Hammers
On 2007-02-19 Nhadie Ramos wrote: > Hi Christian, > > Thanks for the reply. I got the table repaired and deleted some data on it. > What combination can i use to overcome the 4GB limit? Read http://www.suse.de/~aj/linux_lfs.html and google a bit. Basically any recent Kernel 2.4 or 2.6 should do

Re: Data back up for innodb tables - Copy paste

2007-02-18 Thread Christian Hammers
On 2007-02-19 abhishek jain wrote: > I want to copy paste the data files of Innodb database, is it possible, i > mean can i just copy the data files like that we do for myisam tables If you mean for a daily backup while the server is running: No! You often end up with corrupted tables doing that

Re: No Data on table

2007-02-18 Thread Christian Hammers
Hello On 2007-02-18 Nhadie wrote: > I had an error that my database is already full, when i do a select there > is always no result even select * from tablename. > > but when i look at it on /var/lib/mysql i can see the size of the file is > still huge, > > -rw-rw 1 mysql mysql 9174 F

Re: Updating from 4.0.20 to 5.0.27

2007-02-07 Thread Christian Hammers
On 2007-02-06 Dan Nelson wrote: > In the last episode (Feb 06), Tim Johnson said: > > I'm currently using OS linux slackware 10.0 with MySQL version 4.0.20 > > I currently use python and rebol APIs to MySQL, not PHP. > > > > I've downloaded mysql-standard-5.0.27-linux-i686.tar.gz > > Questions:

Re: rounding digits after decimal sign

2007-02-02 Thread Christian Hammers
On 2007-01-31 [EMAIL PROTECTED] wrote: > Can anyone point me to a section of manual or link how to reduce digits Lookup the manual for "round()" but be sure that you understand it if you use round in financial applications as it might be unexpected for you: mysql> SELECT 25E-1 = 2.5, round(25

Re: InnoDB vs MyISAM

2007-01-04 Thread Christian Hammers
On 2007-01-04 Octavian Rasnita wrote: > I have seen that by default some tables are created as InnoDB and some as > MyISAM. > > I guess the table type is not chosen randomly. How is it chosen the table > engine used? You can set a global and IIRC a database specific default for the database typ

Re: URGENT: Question on table storage

2006-12-19 Thread Christian Hammers
On 2006-12-19 Prem wrote: > I am using this table to store all the websites accessed by each employees. I hope you're aware that your country might have data privacy laws, too.. > There is no primary key on that table since the same employee will access > more than > 100 sites per day. If ther

Re: ORDER BY RAND() gives me duplicate rows sometimes

2006-11-09 Thread Christian Hammers
On 2006-11-09 Daevid Vincent wrote: > I am using this query to pull three random comments from a table: > > "SELECT *, DATE_FORMAT(created_on, '%b %D') as date_format FROM comments > ORDER BY RAND() LIMIT 3"; > > The problem is that sometimes, I get two of the same comment. How can I > refine t

Re: mysqldump problem

2006-11-09 Thread Christian Hammers
On 2006-11-09 VenuGopal Papasani wrote: > hi all, > I have got a problem with mysql and i want to uninstall it and then > re-install it but the problem is how to recover my data. This seldom solves problems. What problem do you have, maybe we can help without having you uninstall your server :)

Re: Regular expression not working as expected (documented)?

2006-11-08 Thread Christian Hammers
On 2006-11-08 Leandro Guimarães Faria Corcete DUTRA wrote: > > > u.login REGEXP > > > '^wa[bhkl][_[.period.]-acegmnopqrsuvwxyz]{1,5}[14Lt][23890IJOQ].*... > > > But I get, among otherss, a string beginning with 'walt' (several, in > > > fact). > > > > Probably MySQL don't know about th

Re: Regular expression not working as expected (documented)?

2006-11-08 Thread Christian Hammers
On 2006-11-08 Leandro Guimarães Faria Corcete DUTRA wrote: > u.login REGEXP > '^wa[bhkl][_[.period.]-acegmnopqrsuvwxyz]{1,5}[14Lt][23890IJOQ].*' ... > But I get, among otherss, a string beginning with 'walt' (several, in fact). Probably MySQL don't know about this "[.period.]" thing and

Re: wait_timeout help

2006-11-07 Thread Christian Hammers
On 2006-11-07 Sayed Hadi Rastgou Haghi wrote: > Thanks > But this sets. GLOBAL wait_timeout variable. > Cab be seen by SHOW GLOBAL VARIABLES not by SHOW VARIABLES; Ah, yes, MySQL is very confusing about this special variable: You have to use "interactive_timeout = XXX" to change what is called "

Re: wait_timeout help

2006-11-07 Thread Christian Hammers
On 2006-11-07 Sayed Hadi Rastgou Haghi wrote: > Dear All, > > I want to set wait_timeout variable on mysqld startup. > Is there any way to do that? Put "wait_timeout = XXX" into the "[mysqld]" stanza of your /etc/mysql/my.cnf (or wherever your global config file is). bye, -christian- -- MyS

Re: Sorting MySQL queries

2006-11-06 Thread Christian Hammers
On 2006-11-06 Dotan Cohen wrote: > > Make a second column that only contains > >ALTER TABLE table ADD cooked_subject; > >UPDATE table SET cooked_subject = ereg_replace('^(a|the) ', '', subject); > >(I don't know how the regular expression function was called exactly but > > you get t

Re: Sorting MySQL queries

2006-11-06 Thread Christian Hammers
On 2006-11-06 Dotan Cohen wrote: > I have a list of subjects, such as "Linux", "Open Source", and "the > World Wide Web". The subjects are stored in MySQL and being retrieved > via php. I currently organize them alphabetically with MySQL's "ORDER > BY ASC" argument, however, if there is a precedi

Re: Default Column Value

2006-11-05 Thread Christian Hammers
Hi On 2006-11-05 Bill Guion wrote: > In one of my tables I have a start_date - timestamp (2007-07-04). A > separate column, start_yr_mo, has 200704 (first seven characters of > timestamp without the '-'). Both are entered manually. Can I define > start_yr_mo as a default of, for example, set st

Re: source compilatio or install precompiled packages

2006-10-24 Thread Christian Hammers
On 2006-10-24 Jose Manuel Peso wrote: > Why is recommended the precompiled package install way (as i read in the > downloads page)? Because a different compiler version or different installed libraries can result in a slightly different binary. If you happen to experience a bug later it's easier

Re: mysql within firewall

2006-10-05 Thread Christian Hammers
Hello Peter On 2006-10-05 Peter Gershkovich wrote: > Problem: > > When we run a large query (returns 4000 records) on a firewalled > XServe (OS X 10.4) against Mysql database (outside firewall) on an > AIX (Version 5.2) machine the database server intermittently > generates the following er

Re: Mysqlimport complex question

2006-10-04 Thread Christian Hammers
On 2006-10-04 Scott Hamm wrote: > OBJECTIVE: > INPUT: > E524541015.txt:20061004|,535,999|Scot|Hamm|,410|||101 Walter > Rd|Dover|MD|76709|,041| ... > Been trying to get mysqlimport to use these characters to no avail, how do > I get around to it? I can't answer your question but think that yo

Re: Glitch in Query Optimizer

2006-10-03 Thread Christian Hammers
he compound > index. Ugh. Any ideas? Search the docs for "FORCE INDEX ()" and "IGNORE INDEX ()" if you don't want to rely on MySQL's cleverness. bye, -christian- -- Christian Hammers WESTEND GmbH | Internet-Business-Provider Technik

Re: How to make this work ?

2006-09-01 Thread Christian Hammers
On Fri, Sep 01, 2006 at 03:17:14PM +0530, [EMAIL PROTECTED] wrote: > How to make this work "CREATE TABLE DB2.tblname LIKE DB1.tblname;" It does work perfectly with 5.0. Mabe cross-database queries didn't work with earlier versions? Which version do you use? > Can we have simultaneous connect

Understanding Query-Cache math...

2006-09-01 Thread Christian Hammers
ry_cache_wlock_invalidate | OFF| +--+----+ thanks, -christian- -- Christian Hammers WESTEND GmbH | Internet-Business-Provider Technik CISCO Systems Partner - Authorized Reseller Lütticher Straße 10

Re: How to utilize 16 logical CPUs

2006-08-22 Thread Christian Hammers
032 0 4230 0 7 5 88 0 1 0 0 2958220 139712 383074800 0 596 3904 0 8 5 87 0 bye, -christian- -- Christian Hammers WESTEND GmbH | Internet-Business-Provider Technik CISCO Systems Partner - Autho

Re: How to utilize 16 logical CPUs

2006-08-22 Thread Christian Hammers
ot;. The datadir is only 4GB in total so that I even guess that almost all tables will fit into the process memory. bye, -christian- -- Christian Hammers WESTEND GmbH | Internet-Business-Provider Technik CISCO Systems Partner - Authorized Reseller

Re: How to utilize 16 logical CPUs

2006-08-22 Thread Christian Hammers
| | wait_timeout| 28800 | +-+--------+ 199 rows in set (0.00 sec) -- Christian Hammers WESTEND GmbH | Internet-Business-Provider Technik CISCO Systems Partner - Authorized Reseller

How to utilize 16 logical CPUs

2006-08-22 Thread Christian Hammers
n result from inefficient queries and wrong configuration settings, too, but as this would get quite complex then I first want to rule out this cause) thanks, -christian- -- Christian Hammers WESTEND GmbH | Internet-Business-Provider Technik CISCO Sy

Re: Lots of threads in "opening tables" and "closing tables" state

2006-06-27 Thread Christian Hammers
Hallo On Thu, Jun 22, 2006 at 01:54:07PM -0500, Dan Buettner wrote: > Christian, I hope raising the open_files_limit helps (I think it > should). I second Brent's suggestion to enable the thread_cache. > > Please do report back and let us know how you fare. The effect that lots of tables are i

Re: Lots of threads in "opening tables" and "closing tables" state

2006-06-22 Thread Christian Hammers
| | version_compile_os | pc-linux-gnu | | wait_timeout| 28800 | +-+------

Lots of threads in "opening tables" and "closing tables" state

2006-06-22 Thread Christian Hammers
g tables | SELECT data.id, data.xms_created created, data.xms_modified modified, data.xms_l | -- Christian Hammers WESTEND GmbH | Internet-Business-Provider Technik CISCO Systems Partner - Authorized

Re: Problems upgrading from 4.0 to 4.1

2005-04-11 Thread Christian Hammers
ed record at 112 Did you found the files on the incoming/ dir and do you have any news on this case? If it's not something extremly stupid from my side, can you open a bug report to make the issue easier to track? bye, -christian- -- Christian Hammers WESTEND GmbH | Inter

Re: Problems upgrading from 4.0 to 4.1

2005-04-08 Thread Christian Hammers
-4.0.24 but reproducible gets emptied during a REPAIR TABLE on MySQL-4.1.10a. bye, -christian- -- Christian Hammers WESTEND GmbH | Internet-Business-Provider Technik CISCO Systems Partner - Authorized Reseller Lütticher Straße 10

Re: DATE & TIME

2005-04-06 Thread Christian Hammers
On Wed, Apr 06, 2005 at 12:06:37PM +0200, Hans Bernard wrote: > i need to have the time in this output. in MySQL database > phpmyadmin always puts -00-00 > > i need it to be like this > 01-APR-2005 >> DD-MMM- Use date_format(, "%d-%b-%Y %H:%m") in your SELECT? bye, -christian- --

Problems upgrading from 4.0 to 4.1

2005-04-05 Thread Christian Hammers
ing different than latin1 nor table sizes near 4GB. All tables were checked and dumped on a regular basis without problems. After recreating them I had no further problems so far. bye, -christian- -- Christian Hammers WESTEND GmbH | Internet-Business-Provider Technik

mysqlcheck (not myisamchk) harmful?

2004-07-29 Thread Christian Hammers
Hello A user of the Debian packages that I maintain reported a problem with the "mysqlcheck --all-databases --fast --quiet" command that is run in the "/etc/init.d/mysql" script just after the server is up and running as reported by "mysqladmin ping". According to all documentation that I found a

Idea: Syntax help on command line

2003-03-27 Thread Christian Hammers
Hello I use the mysql command line tool quite often and always wondered why there's no feature that lets me quickly see the syntax of a "FOREIGN KEY" or "GRANT" command. Now while browsing the source I found the new "syntax" command in 4.0.12 and got the idea of implementing this syntax help of my

Re: lsof +L1 - mysql.err.1 unlinked ...

2003-01-10 Thread Christian Hammers
Hello On Tue, Jan 07, 2003 at 11:25:18PM +0100, Christian Jaeger wrote: > >I have always these mysql.err.1 files not unlinked in all my > >mysqlservers, and only a mysqld restart resolve these (nor reload > >neither mysqladmin refresh doesn't unlink them). The err file is created by safe_mysqld

Do I have to modify mysql-bin.index when purging old binary logs?

2002-12-24 Thread Christian Hammers
Hi Subject says all, is everything fine when I just flush-logs every morning and remove every logfile that is older than 30 days? Or do I have to delete the corresponding line from the index file as well? Whatfor is it needed, btw? bye, -christian- # for the bot: mysql php query -

Package references deprecated errno@GLIBC_2.0 symbol because it uses errno without including errno.h

2002-11-10 Thread Christian Hammers
Hello The following bug was reported against the Debian mysql package bug seems to be a generall problem. bye, -christian- On Sun, Nov 10, 2002 at 02:32:08PM +0100, Luca Barbieri wrote: > Package: libmysqlclient10 > Version: 3.23.53-3 > Severity: important > > One or more programs or libraries

Please clarify copyright of shared library.

2002-11-10 Thread Christian Hammers
Hello The follwing bug was reported against the Debian libmysqlclient10 package. Can you comment on this? The mentioned /usr/share/doc/ copyright file includes a copy of http://www.mysql.com/doc/C/o/Copyright.html bye, -christian- On Sun, Nov 10, 2002 at 05:03:06PM +0100, Andreas Metzler wrote

2 bugs in mysqlaccess

2002-08-26 Thread Christian Hammers
Hello First bug: The contact address is no longer existing: "BUGs can be reported by email to [EMAIL PROTECTED]" Second bug: perl does not substitute the '~' char to the home directory: > --- /tmp/mysqlaccess.orig 2002-08-27 08:25:23.0 +0200 > +++ /usr/bin/mysqlaccess

Re: Bug#151302: mysql-server: transparent gzip support on selected columns

2002-06-29 Thread Christian Hammers
Hello MySQL developers I forward this in behalf of a Debian user who filed a bug report against the Debian package. bye, -christian- On Fri, Jun 28, 2002 at 07:21:26PM +, [EMAIL PROTECTED] wrote: > Package: mysql-server > Version: 3.23.50-1 > Severity: wishlist > > > Currently I have abo

Re: restart/flush needed when using symlinks?

2002-06-21 Thread Christian Hammers
Hello Is a restart/reload or a "flush tables" necessary when creating or removing databases? bye, -christian- cookie-for-the-robot: sql,query -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet & Security for Profes

Patch for mysql_read_default_options segfault

2002-05-20 Thread Christian Hammers
Hello FYI, here is a patch that was submitted through the Debian Bug Tracking System for bug #145322. (for those who don't like to upgrade etc.. it is fixed in the 3.23.50) bye, -christian- On Mon, May 20, 2002 at 06:55:19PM +0200, [EMAIL PROTECTED] wrote: > Hi, > > I had a similar problem

Re: compile problem with 3.23.50

2002-04-24 Thread Christian Hammers
On Wed, Apr 24, 2002 at 02:27:40PM +0300, Sinisa Milivojevic wrote: > > mysqld.cc:2428: at this point in file > > /usr/include/tcpd.h:119: too few arguments to function `int hosts_access(request > > _info *)' > > mysqld.cc:2429: at this point in file > > /usr/include/tcpd.h:153: too few arguments

What's up with the mysql_read_default_group segfault bug?!

2002-04-16 Thread Christian Hammers
Hi That using mysql_read_default_group can produce segfaults is known since at least a month and there were two independend bug reports, one from me: http://listarchive.nextrieve.com/mysql//200203/msg01938.html Are there any patches available? Monty said something about 3.23.50 but although the

typo in configure regarding enable-local-infile

2002-03-29 Thread Christian Hammers
Hi In case nobody noticed yet: configure.in line 590: # compile with strings functions in assembler AC_ARG_ENABLE(local-infile, [ --enable-local-infile If LOAD DATA LOCAL INFILE is enabled by default.], [ ENABLED_

Re: bug: segfaults with mysql_read_default_group!

2002-03-11 Thread Christian Hammers
On Mon, Mar 11, 2002 at 04:11:08PM +0200, Sinisa Milivojevic wrote: > > There is a problem with the myslq_read_default_group function! > > It's DBI 1.21, DBD::MySQL 1.2216 and mysql-3.23.49, compiled on the very > > latest Debian unstable (I'm the mysql maintainer of Debian). > This is the only c

bug: segfaults with mysql_read_default_group!

2002-03-10 Thread Christian Hammers
Hello There is a problem with the myslq_read_default_group function! It's DBI 1.21, DBD::MySQL 1.2216 and mysql-3.23.49, compiled on the very latest Debian unstable (I'm the mysql maintainer of Debian). bye, -christian- There is no section "ch" in /etc/mysql/my.cnf and no ~ch/.my.cnf. The sam

Where is 3.22.35? I need it due to the coredump bugfix.

2002-02-28 Thread Christian Hammers
Hello I was notified about a coredump bug in MySQL 3.22.xx. As this can be used as DoS I like to update the MySQL packages I maintain for the Debian GNU/Linux distribution. I would like to have specifically the 3.22.35 as the bug seems to be fixed there according to the changelog and I don't li

[patch] corrected manpage headers

2002-01-28 Thread Christian Hammers
Hello To get apropos working and the header comply to man(8) you should apply the following command on the man/ directory: perl -pi -e 's/^\.TH\s+(\S+?)\s+.*/sprintf(".TH %s 1 \"19 December 2000\" \"MySQL 3.23\" \"MySQL database\"", lc($1))/e' *.1 bye, -christian- <[EMAIL PROTECTED]> -

Re: Bug#129284: mysql-client: some short options doesn't work

2002-01-15 Thread Christian Hammers
FYI -christian- On Mon, Jan 14, 2002 at 11:54:42PM +0100, Artur R.Czechowski wrote: > Package: mysql-client > Version: 3.23.46-2 > Severity: minor > > mysqldump: invalid option -- Q > long GNU option --quota-names used instead works > Please fix documentation or client :) > > Sincerelly >

Fwd: Bug#128473: [patch] the mysql crashes on the -D option

2002-01-10 Thread Christian Hammers
FYI -christian- On Wed, Jan 09, 2002 at 08:52:34PM +0100, Sjoerd Simons wrote: > Package: mysql-client > Version: 3.22.32-6 > Severity: normal > Tags: patch > > mysql -D causes a segv, the attached patch to mysql.cc seems to fix > this.. ... > --- mysql.cc.orig Wed Jan 9 20:46:07 2002 > +

WISHLIST: auto_increment after delete

2001-12-03 Thread Christian Hammers
somewhere but still it's hard to use..) thanks, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet & Security for ProfessionalsFax 0241/911879 WESTEND ist CISCO S

Re: Bug#119076: mysql-server: signal 11

2001-11-12 Thread Christian Hammers
Hello I forward this bug report to this list as it seems to be not Debian specific. MySQL crashes with several kinds of /etc/nsswitch.conf configurations. bye, -christian- On Tue, Nov 13, 2001 at 11:45:27AM +1100, Brian May wrote: > >>>>> "Christian" == Christi

Re: Bug#117819: mysqld 3.23.43 returns no data instead of correct result

2001-11-01 Thread Christian Hammers
Hi I forward this to you from the Debian bug tracking system as it seems to be an upstream problem. Please keep the reply-to. bye, -christian- On Wed, Oct 31, 2001 at 09:42:56PM +, Petr Vandrovec wrote: > Package: mysql-server > Version: 3.23.43-2 > Tags: upstream > > Hi, > I have simp

Bug? SET @T="db"; SELECT * FROM @T;

2001-10-25 Thread Christian Hammers
Hi The above statement does not work :-( This is sad as it would be a nice feature. bye, -christian- mysql> SET @RF='user'; Query OK, 0 rows affected (0.00 sec) mysql> SELECT * FROM @RF; ERROR 1064: You have an error in your SQL syntax near '@RF' at line

build problems on powerpc with 3.23.42

2001-09-23 Thread Christian Hammers
Hello I have problems building the mysql package for the Debian distribution on powerpc. More infos below. Feel free to contact me for further details. bye, -christian- make[3]: Entering directory `/home/ch/debian/mysql-3.23.42/sql' g++ -DMYSQL_SERVER -DDEFAULT_MYSQL_H

myodbc2.50.37 failed to build on ia64

2001-09-03 Thread Christian Hammers
FYI -christian- > Date: Sat, 25 Aug 2001 21:46:03 -0700 > From: Randolph Chung <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Reply-To: Randolph Chung <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > > Package: myodbc2.50.37 > Version: 2.50.37-3 > Severity: important > > See attached build log. Look

won't build on hppa

2001-06-14 Thread Christian Hammers
Hello Does anybody know how to get MySQL build on HPPA architecture? bye, -christian- -- Real men don't take backups. They put their source on a public FTP-server and let the world mirror it. -- Linus Torvalds Package: mysql Version: 3.23.39-1

fails to build on ARM architecture

2001-05-20 Thread Christian Hammers
Hello Does anybody know if MySQL can be build on the arm architecture? (This bug was reported against the Debian MySQL packages) bye, -christian- With 3.23.37-3 I'm now seeing a different failure: gcc -DDEFAULT_CHARSET_HOME=\"/usr\" -DDATADIR=\"/var/lib/mysql\" -DSHAREDIR=\"/usr/share/mysq

[jcz@mylinepcx.com: Bug#95872: replication failure]

2001-04-30 Thread Christian Hammers
Hello This came through the Debian BugTrackingSystem but I have no clue about it. bye, -christian- Package: mysql-server Version: 3.23.33-3 Severity: normal from /var/log/mysql.err: 010430 16:06:52 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 4 010430 16:

Problems with udf functions.

2001-04-26 Thread Christian Hammers
p;c, &d) != 4) { /* cannot happen - init checks this...?! */ *is_null=1; *error=1; return 0; } *is_null=0; *error=0; return (long unsigned int)( a*0x0100 + b*0x0001 + c*0x0100 + d); } -- Christian HammersWESTEND GmbH - Aachen und Dueren

TYPE=BDB is ignored!

2001-04-16 Thread Christian Hammers
Hello I compiled on an UltraSparc II Linux with libc-2.2.2 and say CREATE TABLE t (t int) TYPE=BDB; but it creates a MyISAM without any warning. Why? BDB seems to be compiled in correctly: ch@vore:~/test$ nm usr/bin/mysqld |grep berke 000822c0 t _GLOBAL_.D.have_berkeley_db

please tell me what "Init" in processlist means

2001-03-23 Thread Christian Hammers
e problems with...something... Can anybody explain what "Init" does? thanks in advance, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet & Security for ProfessionalsFax 0241/911879 WESTEND ist CI

warning: mysql local root exploit when running as root

2001-03-22 Thread Christian Hammers
thod! bye, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet & Security for ProfessionalsFax 0241/911879 WESTEND ist CISCO Systems Partner - Premium Certified Hi, At first, an apology if this came

BUG: alter table destroys symbolic links!

2001-03-22 Thread Christian Hammers
his is a way to more around the system administrators disk-quota settings! This was tested with the latest MySQL-3.23.35 on linux (ext2 & reiserfs, although this shouldn't matter in for the symlink handling) bye, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren

[philb@gnu.org: Bug#88186: mysql: Fails to build on ARM: char sign issue?]

2001-03-18 Thread Christian Hammers
Hi Hope this helps you to make mysql working on ARM architecture, too. bye, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet & Security for ProfessionalsFax 0241/911879 WESTEND ist CISCO Systems Par

What to optimize when disc activita is very high?

2001-03-15 Thread Christian Hammers
=2 # Try number of CPU's*2 set-variable= myisam_sort_buffer_size=16M -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet & Security for ProfessionalsFax 0241/911879 WESTEND ist CISCO S

Re: decimal(8,2) rounding bug or still "to be expected" behaviour?

2001-03-09 Thread Christian Hammers
uding errors when adding the sums) bye, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet & Security for ProfessionalsFax 0241/911879 WESTEND ist CISCO Sys

Re: optimizing select on big table

2001-03-09 Thread Christian Hammers
PACK_KEYS=1; I realized that timestamp is my "main" column but does adding another seperat timestamp something? The docs say that searching for the first part of a multiple-key is fine. bye, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701

optimizing select on big table

2001-03-09 Thread Christian Hammers
| +-+---+---+-+-+--+-+-+ | channel_traffic | range | PRIMARY | PRIMARY | 8 | NULL | 1636199 | where |used; Using temporary | +-+---+---+-+-+-

decimal(8,2) rounding bug or still "to be expected" behaviour?

2001-03-09 Thread Christian Hammers
-christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet & Security for ProfessionalsFax 0241/911879 WESTEND ist CISCO Systems Partner - Pre

Re: optimising joins: where vs. using/on

2001-03-08 Thread Christian Hammers
right? > If you have 5 hour selects you are probably missing some vital indexes, or > you are using a long of like '%blah' or "OR" ... or using 1.5GB big tables... thanks, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-

optimising joins: where vs. using/on

2001-03-08 Thread Christian Hammers
tablea a LEFT JOIN table b USING (id) LEFT JOIN table c USING (nr) Is one of the two ways preferred about the other? I like my way as it is easier to read and understand but would use anything to gain some speed in my 5+ hour selects... bye, -christian- -- Christi

wishlist: create_tmp_priv in mysql.db

2001-03-08 Thread Christian Hammers
r the right to populate the harddisc with permanent data i.e. with real create statements. Or is there an easier solution? bye, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet & Security for ProfessionalsFax 02

Question regarding query optimising with between

2001-03-06 Thread Christian Hammers
; Using index | +----+---+---+--+-+--++- + 1 row in set (0.00 sec) -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] I

[hazelsct@mit.edu: Bug#88186: mysql: Fails to build on ARM: char sign issue?]

2001-03-02 Thread Christian Hammers
Hello Any ideas? -christian- Package: mysql Version: 3.23.33-1 Severity: normal Greetings, The build fails on ARM. Here's the end of the build log: g++ -DMYSQL_SERVER-DDEFAULT_MYSQL_HOME="\"/usr\"" -DDATADIR="\"/var/lib/mysql\"" -DSHAREDIR="\"/usr/share/mysql\""-DHAVE_CO

Re: Antwort: tab-completition not working with libreadline4

2001-02-26 Thread Christian Hammers
that helped, thank you. Now I think I have to read a bit docs what this rehash thing does and why I suddenly have to type it. bye, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet & Security for Profes

tab-completition not working with libreadline4

2001-02-26 Thread Christian Hammers
Hello Since a few weeks tablename completition using tab is not working any longer. I build with bundled lbireadline and with my system libreadline (4.2) but neither work as I am used to. Any ideas? bye, -christian- - Befor

[chris@debian.org: Bug#86033: [PATCH] Alpha patches for mysql]

2001-02-19 Thread Christian Hammers
Hello In case this patch wasn't post here. bye, -christian- Package: mysql Version: 3.23.33-1 Severity: important Tags: patch Below is a patch against mysql 3.23.31 (but applies well to 3.23.33-1) for things to work properly on Alpha. I've been applying this diff against most of the mysq

Re: MySQL 3.23.33 released

2001-02-13 Thread Christian Hammers
Michael, it would be very nice if you would mark security related bugs so that admins who are not subscribed on Bugtraq see them, too. This is at least the second time where I got information about security bugs in MySQL *only* via 3rd party and not from the web page nor from the changelog. Disa

chroot strangenesses

2001-02-04 Thread Christian Hammers
Hi I don't understand the way mysql tries to jail itself with --chroot. If I start mysqld --chroot=/var/lib/mysql_jail then it gives me an error saying that it wasn't able to initialize the databases. When I copy the mysql database somewhere into the jail it works. But - when I modify the my

SSL - is it there?

2001-01-28 Thread Christian Hammers
Hello I realised several SSL keywords in the Makefiles but cannot find a way to activate SSL/TLS via ./configure. Did I miss something or is there no SSL support implemented yet? Can I expect it for the future? (Would be great!) bye, -christian- -- Save the forests, eat more

Patch for build problems on Alpha!

2001-01-22 Thread Christian Hammers
Hello Here is something from the Debian bug tracking system for you. If fixes the compilation problems on Alpha architecture. bye, -christian- -- codito ergo sum - I code, therefore I am! On Sun 21 Jan 2001, Cristian Ionescu-Idbohrn wrote: > downloaded 3.23.31. Builds just fi

a bug? regarding udf functions and SubString_Index()

2001-01-22 Thread Christian Hammers
Hi Let's look at this: # select SubString_Index("10.0.0.0/24","/",1); 10.0.0.0 # select ewu_aton("10.0.0.0"); 167772160 # select ewu_aton( SubString_Index("10.0.0.0/24","/",1) ); 280239936 Why this? My self written ewu_aton seems to work korrectly when calling it with any normal argument. The

"show logs" crashes client?!

2001-01-21 Thread Christian Hammers
In case this wasn't reported before: "show logs" in the server makes the client crash. Christopher Lameter reported this via the Debian bug tracking system. bye, -christian- -- codito ergo sum - I code, therefore I am!

Undefined reference in libmysqlclient.a

2001-01-21 Thread Christian Hammers
-christian- -- You know you're a nerd when your os uptime is longer than you've ever had a girlfriend. ([EMAIL PROTECTED]) Yup, that fixes it.. thanks. I wonder why it compiled OK on redhat but not debian. On Sun, Jan 21, 2001 at 01:10:16PM +0100, Christian Hammer

Security patch from 3.23.31 backported to 3.22.32 !

2001-01-21 Thread Christian Hammers
nds a problem with this patch thanks, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet & Security for ProfessionalsFax 0241/911879 WESTEND ist CISCO Systems Partner - Premium Certified Dans un message

[cristian.ionescu-idbohrn@axis.com: Bug#82737: building mysql-3.23.30 packages from source fails]

2001-01-21 Thread Christian Hammers
as argument 4 of `log_archive(DB_ENV *, char ***, unsigned int, void * (*)(long unsigned int))' ha_berkeley.cc:252: passing `void * (*)(unsigned int)' as argument 4 of `log_archive(DB_ENV *, char ***, unsigned int, void * (*)(long unsigned int))' make[4]: *** [ha_berkeley.o] Error

Security fix from .31 for 3.22.32? (for Debian "potato")

2001-01-20 Thread Christian Hammers
Can anybody provide me a short diff that only fixes this security bug? thanks in advance, -christian- aka [EMAIL PROTECTED] -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet & Security for ProfessionalsFax 0241/911879