Mysql 4.1.3-beta stalls when flush privileges
I know that I should use mysqlbug to report bugs, but my mysqlbug prints mysqlbug: problem report sent >Description: When there are rows in mysql.columns_priv table query flush privileges stalls when query repeatly. >How-To-Repeat: Insert some rows in mysql.columns_priv table. Try to query flush privileges repeatly. >Fix: Have no idea. >Submitter-Id: [EMAIL PROTECTED] >Originator:User & >Organization: Ymir Entertainment >MySQL support: none >Synopsis: stall when flush privileges >Severity: serious >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-4.1.3-beta (FreeBSD port: mysql-client-4.1.3) >C compiler:cc (GCC) 3.3.3 [FreeBSD] 20031106 >C++ compiler: c++ (GCC) 3.3.3 [FreeBSD] 20031106 >Environment: @ "/tmp/mysqlbug-25983/mysqlbug" 53 lines, 3406 characters written >Environment: System: FreeBSD SQL3.metin2.co.kr 5.2.1-RELEASE FreeBSD 5.2.1-RELEASE #0: Mon Feb 23 20:45:55 GMT 2004 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/GENERIC i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using built-in specs. Configured with: FreeBSD/i386 system compiler Thread model: posix gcc version 3.3.3 [FreeBSD] 20031106 Compilation info: CC='cc' CFLAGS='-O -pipe -mcpu=pentiumpro -D__USE_UNIX98 -D_REENTRANT -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -O3 -fno-omit-frame-pointer -fno-gcse' CXX='c++' CXXFLAGS='-O -pipe -mcpu=pentiumpro -D__USE_UNIX98 -D_REENTRANT -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -O3 -fno-omit-frame-pointer -fno-gcse -O -pipe -mcpu=pentiumpro -D__USE_UNIX98 -D_REENTRANT -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -O3 -fno-omit-frame-pointer -fno-gcse -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS='' ASFLAGS='' LIBC: -r--r--r-- 1 root wheel 892348 Feb 24 04:41 /lib/libc.so.5 -r--r--r-- 1 root wheel 1730766 Feb 24 04:41 /usr/lib/libc.a lrwxrwxrwx 1 root wheel 14 May 2 09:43 /usr/lib/libc.so -> /lib/libc.so.5 Configure command: ./configure '--localstatedir=/var/db/mysql' '--without-debug' '--without-readline' '--without-libedit' '--without-bench' '--without-extra-tools' '--with-libwrap' '--with-mysqlfs' '--with-vio' '--with-low-memory' '--with-ndbcluster' '--with-comment=FreeBSD port: mysql-client-4.1.3' '--enable-thread-safe-client' '--with-charset=euckr' '--with-extra-charsets=all' '--with-mysqld-ldflags=-all-static' '--enable-assembler' '--with-berkeley-db' '--with-named-thread-libs=-DHAVE_GLIBC2_STYLE_GETHOSTBYNAME_R -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -L/usr/local/lib -llthread -llgcc_r -llstdc++ -llsupc++' '--without-server' '--prefix=/usr/local' '--build=i386-portbld-freebsd5.2.1' 'CFLAGS=-O -pipe -mcpu=pentiumpro -D__USE_UNIX98 -D_REENTRANT -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -O3 -fno-omit-frame-pointer -fno-gcse' 'CXX=c++' 'build_alias=i386-portbld-freebsd5.2.1' 'CC=cc' 'CXXFLAGS=-O -pipe -mcpu=pentiumpro -D__USE_UNIX98 -D_REENTRANT -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -O3 -fno-omit-frame-pointer -fno-gcse -O -pipe -mcpu=pentiumpro -D__USE_UNIX98 -D_REENTRANT -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -O3 -fno-omit-frame-pointer -fno-gcse -felide-constructors -fno-rtti -fno-exceptions' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Solaris Performance Issue
Hi Jeremy, I didn't find any resouce limit but the performace is very bad. Do you have any suggestion how to tune the solaris to provide the better performance for Solaris? Linda - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Linda" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, July 10, 2004 6:06 AM Subject: Re: Solaris Performance Issue > On Wed, Jul 07, 2004 at 06:23:45PM +0800, Linda wrote: > > Hi, > > > > My old mysql is 3.23.56 on RedHat9(Intel). After moving mySQL to > > Solaris 9 (Sun F280R/2GB Memory) and upgrading mySQL to 4.0.20, I > > got a lot of complaints about the performance for select and > > update. Have anyone can tell me if there is anything I should tune > > for Solaris or MySQL to improve the performance. > > Without knowing what sort of bottlenecks you're seeing, it's really > hard to say. What's the resource limit? CPU? Disk? RAM? > > BTW, I've found Sun boxes of that vintage (I have MySQL on a 280R > also) to be quite a bit slower than much cheaper Intel hardware. > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > [book] High Performance MySQL -- http://highperformancemysql.com/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fw: Can't start server
Hmm...can someone help me on this? Many thanks. - Forwarded by Joseph S CHUNG/OGCIO/HKSARG on 2004-07-12 09:40 - Joseph S CHUNG To: [EMAIL PROTECTED] 2004-07-09 15:10 cc: Subject: Can't start server || | [ ] Urgent | || || | [ ] Return Receipt | || I install mysql 4.0 with RPM on Fedora2, which comes with mysql 3.23. When I try to start mysql server, the /var/log/mysqld.log file record the following error message: " mysqld started Warning : Asked for 196608 thread stack, but got 126976 Can't start server : Bind on unix socket : Permission denied Do you already have another mysqld server running on socket : /var/lib/mysql/mysql.sock ? Aborting /usr/sbin/mysqld: Shutdown Complete mysqld ended " There is no mysqld running. Any idea? Thanks, Joseph -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Cost of joins?
I know the boat has probably sailed by now on this thread, but as far as I saw nobody has thrown in what I was going to say. A simple blanket statement like "Design for understanding, logic and maintenance, not performance." is a little too glossy. You can't put all database usage into the one basket like that. Some applications rely on a database purely as a backend, thus, a convoluted but extremely high performance design may be favoured over a logical but average performance one. Some applications will rely on logic and user understanding to ensure that data is preserved and stored correctly, therefore a more logical layout will be favoured over a confusing one that may perform somewhat better. In the end it's up to the database designer to make the right decision as to what's most appropriate for the application. "If you need more performance, throw more hardware at it" You will find that in many situations throwing more hardware is _still_ not going to help. Optimizing your queries, application, tuning your server and database design is where it's going to count most. With optimizations in these areas only you can cut a query that took many hours previously down to sub second, adding more hardware in this situation is still going to leave you with an undesirably high execution time. While I understand where you're going with your comments, I think it's important to make sure people know these things. Kind Regards, Lachlan Mulcahy -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: Friday, 9 July 2004 10:28 PM To: Margaret MacDonald; [EMAIL PROTECTED] Subject: Re: Cost of joins? Design for understanding, logic and maintenance, not performance. If you need more performance, throw more hardware at it - a larger cache (settings -> memory), faster disks and a faster CPU. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Accessing Mysql using API's
I dont think so, but I might be wrong. I belive in your case u have to write a custom app that listens on port 3306 and checks for every data transfer. Karam --- Sheraz <[EMAIL PROTECTED]> wrote: > Hello > > I need to access the mysql's connection handling ,, > are there any exposed API's that can allow me to > see > what is being received on 3306 for serverand can > i > hold that data for some checks so that if my check > goes perfrect ill let allow that data to pass on to > server for further request ? > > Your help will be appriciated > Thanks > Sheraz > > > > > > __ > Do you Yahoo!? > New and Improved Yahoo! Mail - Send 10MB messages! > http://promotions.yahoo.com/new_mail > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > __ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Accessing Mysql using API's
Hello I need to access the mysql's connection handling ,, are there any exposed API's that can allow me to see what is being received on 3306 for serverand can i hold that data for some checks so that if my check goes perfrect ill let allow that data to pass on to server for further request ? Your help will be appriciated Thanks Sheraz __ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Need help with my LEFT JOIN query...
Jeff Why are you doing a LEFT JOIN instead of a INNER JOIN right now you are getting all rows from first table regardless of match condition so all of the rows for a.ProductID FROM ImportLiebermansStep3Add are being returned try the inner join instead Martin - Original Message - From: "Jeff Gannaway" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, July 10, 2004 5:18 PM Subject: Need help with my LEFT JOIN query... > I'm trying to SELECT a field (ProductID) from 'Table a' WHERE two > corresponding fields are equal (a.PUBLISHER = b.Vendor AND a.NUMBER = b.VIN) > > > Table 'a' (approximately 100,000 records): > ++ > | ImportLiebermansStep3Add | > ++ > | ProductID | PUBLISHER | NUMBER | > +---+---++ > | ACC_4076 | ACC | 4076 | > | BCD_300 | BCD | 300| > | DEC_R50 | DEC | R50| > | WIN_220 | WIN | 220| > +---+---++ > > Table 'b' (approximately 20,000 records): > ++ > | ProductsOLD| > ++ > | ProductID | Vendor| VIN| > +---+---++ > | | ACC | 4076 | > | | BCD | | > | | DEC | R50| > +---+---++ > > > Here's my Query > > SELECT a.ProductID FROM ImportLiebermansStep3Add a > LEFT JOIN ProductsOLD b ON a.PUBLISHER=b.Vendor AND a.NUMBER=b.VIN > WHERE b.ProductID IS NULL; > > But this query runs, and runs, and runs, and runs, and runs without ever > giving results. > > What am I missing??? > > Thanks! > -Jeff Gannaway > ___ > > http://RadioU.com > This Is Where Music Is Going - Listen Online! > ___ > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
oscommerce online offline replication
Hi All This may be a longshot or it could just be the place where the answer is. I have asked something similiar before regarding this but never could a clear view of the way to proceed. Anyway, here it is. Simply I have an offline mirror of oscommerce what I woould like to do is keep the online version updated with the offline recordset (products) is there a way to do this without overwriting the tables? Ideally there are other fields from the online version I would like to keep updated offline in which case there is always an exact copy on and offline? If there is a way to do this I would appreciate any clues, links, books, and methods and programming techniques to achieve this. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
set character set
Hello, I am not able to change character set using "set character set". /etc/my.cnf (important parts) [client] character-sets-dir = /usr/local/share/mysql/charsets --- content of that directory: dns:/usr/local/share/mysql/charsets# ls cp1251.conf dos.conf hp8.conflatin1.conf usa7.conf cp1257.conf estonia.conf hungarian.conf latin2.conf win1250.conf croat.conf german1.conf Index latin5.conf win1251.conf danish.conf greek.confkoi8_ru.confREADME win1251ukr.conf dec8.confhebrew.conf koi8_ukr.conf swe7.conf - but when I enter mysql, I can't change it to any of those charsets. mysql> set character set "danish"; ERROR 1115: Unknown character set: 'danish' mysql> set character set "czech"; ERROR 1115: Unknown character set: 'czech' mysql> set character set "swe7"; ERROR 1115: Unknown character set: 'swe7' mysql> set character set "latin1"; ERROR 1115: Unknown character set: 'latin1' mysql> set character set "win1250"; ERROR 1115: Unknown character set: 'win1250' I have 4.0.20 (compiled by myself) Am I doing something wrong? Btw, when I specify default-character-set = czech in my.cnf, it works! But it works for whole server and that's exactly what I don't need. I need it just for any domains so their owners have to specify some "SET CHARACTER ..." after connection to db is made. Or is there any other workaround for solving this? Need to recode db to "czech" for several domains (db users...) Best regards and thanks for any advice. I am solving this for months :( Roman -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Which records are not contained in 2 different tables?
In article <[EMAIL PROTECTED]>, Jeff Gannaway <[EMAIL PROTECTED]> writes: > I've got one huge table (table a), and two smaller tables (tables b and c) > I need to find which records in 'table a' are not in 'table b' nor are > they in 'table c'. > The Primary Key for all 3 tables is 'ProductID'. > I looked at the LEFT JOIN command in the docs, but it looks like you > can only compare 1 table to 1 table. > How do I do this? With MySQL 4.1.x you can do SELECT a, b FROM a LEFT JOIN (SELECT b FROM b UNION SELECT c FROM c) AS x ON x.b = a.a WHERE x.b IS NULL; The workaround for older versions would be a temporary table. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
