Does anybody know if this amount of memory usage is normal? (taken from *top*)
PID USER PRI NI SIZE SWAP RSS SHARE LC STAT %CPU %MEM TIME COMMAND
677 root 9 0 19228 0 18M 1580 1 S 0.0
2.1 0:07 mysqld
679 root 9 0 19228 0 18M 1580 0 S 0.0
2.1 0:14 mysqld
680 root 9 0 19228 0 18M 1580 0 S 0.0
2.1 0:04 mysqld
keeps going for 30 connections
Why does the SIZE so high? It would seem to me that the SHARE should be much closer
to the SIZE value... Why doesn't mySQL share
more of its memory? Can I make mySQL share more?
I would think that the database keys would be shared between the processes... Are they?
I have attached the my.cnf file
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 9:37 AM
Subject: mysqldump generates invalid SQL for "db" table
> >Description:
> Performing a "mysqldump --all-databases --opt" produces invalid
> SQL for the "db" table i.e.:
> KEY User(User)
> Attempting to rebuild tables with the mysql client using this SQL fails
> with a syntax error.
>
> If the SQL is modified to:
> KEY User (User)
> then the mysql client creates the "db" table happily.
>
> >How-To-Repeat:
> mysqldump --all-databases --opt > foo.sql
> mysql < foo.sql
> >Fix:
> Ensure a space character seperates the KEY name and parenthesis.
>
> >Submitter-Id: <submitter ID>
> >Originator: Neil Darlow
> >Organization:
>
> >MySQL support: none
> >Synopsis: mysqdump generates invalid SQL for "db" table
> >Severity: serious
> >Priority: high
> >Category: mysql
> >Class: sw-bug
> >Release: mysql-3.23.32 (Source distribution)
> >Server: /usr/local/bin/mysqladmin Ver 8.14 Distrib 3.23.32, for unknown-openbsd2.7
>on i386
> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> and you are welcome to modify and redistribute it under the GPL license
>
> Server version 3.23.32
> Protocol version 10
> Connection Localhost via UNIX socket
> UNIX socket /var/mysql/mysql.sock
> Uptime: 4 days 1 hour 40 min 12 sec
>
> Threads: 7 Questions: 878 Slow queries: 1 Opens: 180 Flush tables: 1 Open
>tables: 12 Queries per second avg: 0.002
> >Environment:
>
> System: OpenBSD kandb 2.7 KANDB#0 i386
>
>
> Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc
>/usr/bin/cc
> GCC: Reading specs from /usr/lib/gcc-lib/i386-unknown-openbsd2.7/2.95.2/specs
> gcc version 2.95.2 19991024 (release)
> Compilation info: CC='cc' CFLAGS='-O2 ' CXX='c++' CXXFLAGS='-O2 '
>LDFLAGS='-L/usr/local/lib'
> LIBC:
> -r--r--r-- 1 root bin 687102 Dec 11 19:34 /usr/lib/libc.a
> -r--r--r-- 1 root bin 563475 Dec 11 19:34 /usr/lib/libc.so.25.0
> Configure command:
./configure --enable-shared --enable-static --localstatedir=/var/mysql --with-libwrap
--with-mysqld-user=mysql --with-unix-socket-p
ath=/var/mysql/mysql.sock --without-perl --without-debug --without-readline
--without-bench --without-mit-threads --prefix=/usr/loca
l --sysconfdir=/etc
>
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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
