Re: Problem with Win32 MySQLGUI 1.7.5
Shu Xiao writes: > > Hi, > > I notice a problem with Win32 MySQLGUI 1.7.5. When I get the > result for the query. I see the escape character \ was not removed > in the result table window. Anybody notice the same problem? > > Thanks, > > Shu > Yes, all cells are escaped in order to display all values. But if your values are binary, you can view them with a zoom feature in their natural binary form. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Case-preserving is not consistent
Philip Mak writes: > On Sun, 19 Aug 2001, Lars Bruun Hansen wrote: > > > mysql> show tables from test; > > ++ > > | Tables_in_test | > > ++ > > | MyTable| > > ++ > > > > mysql> alter table MyTable add (y char(1)); > > mysql> show tables from test; > > ++ > > | Tables_in_test | > > ++ > > | mytable| > > ++ > > > > If this is not a bug how do I then get MySQL to be case-preserving for > > the table names? > > I second that this should be fixed. > > I had a similar problem once; I did an ALTER TABLE MODIFY COLUMN, which is > theoretically supposed to leave the column name unchanged (as opposed to > ALTER TABLE CHANGE COLUMN). However, I had typed the case of the column > differently, so it changed the case of the column. > > This caused my perl scripts that access the database to break, since perl > is case sensitive for variable names. > > Hi! If this is happening on Windows, we truly can not do anything about it. You could help there by forcing all table names to be lower-case by starting mysql service with a corresponding option. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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 becomes slow
Carsten H. Pedersen writes: > > ... > > > Having 27 indexes and using queries with LIKE "%...%" is a nice > > recepee for slowness. > > Why should having 27 indexes slow down a SELECT? > > / Carsten > -- > Carsten H. Pedersen > keeper and maintainer of the bitbybit.dk MySQL FAQ > http://www.bitbybit.dk/mysqlfaq It would slow down directly all commands that change tables. Indirectly it will slow down SELECT's as key buffer would not be used effectively. Also, as all 27 indices are in the same .MYI file, blocks from the same index will definitely be very fragmented. -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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 GUI
Michael Laajanen writes: > HI, > > > I have just tried the 1,6 Solaris version of the GUI but it fails. > > On the web it says it is statically linked but it is not! > > > ldd /opt/tools/applications/mysql/1.6/bin/mysqlgui > libX11.so.4 => /usr/lib/libX11.so.4 > libsocket.so.1 =>/usr/lib/libsocket.so.1 > libnsl.so.1 => /usr/lib/libnsl.so.1 > libstdc++.so.2.10.0 => (file not found) > libm.so.1 => /usr/lib/libm.so.1 > libc.so.1 => /usr/lib/libc.so.1 > libXext.so.0 => /usr/openwin/lib/libXext.so.0 > libdl.so.1 =>/usr/lib/libdl.so.1 > libmp.so.2 =>/usr/lib/libmp.so.2 > libdga.so.1 => /usr/openwin/lib/libdga.so.1 > /usr/platform/SUNW,Sun-Blade-100/lib/libc_psr.so.1 > > > We have just started to try out mysql and since we have both solaris > 8/sparc and Linux could you compile these two in the latest 1.7.5 beta? > > Statically linked ofcourse > > > Thanks > > Michael Laajanen > > > -- > Michael Laajanen, HW Engineer Reddo Networks AB > Address: Livdjursgatan 4, SE-121 62 Johanneshov (Stockholm), Sweden > email: [EMAIL PROTECTED], T: +46 739422432 F: +46 84480091 > sms: [EMAIL PROTECTED] You are right, it is not statically linked. And it is contributed binary. You can not make things statically on Solaris, as Sun does not provide necessary libs in static format. I could make a Solaris port when I find some time. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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 becomes slow
Osus writes: > Hi, > SELECT * FROM table WHERE OK=1 > it gets about 4 or 5 second at least. > I have indexes. That main table have 27 indexes to supply all possible searches. > Some searches are made on text fileds, something like "WHERE field like '%key%' >being field text field. > > I have updated mysql and apache, checked, repaired, optimized tables. I run fschk on >all the partitions. > > What can I do? I need to reduce that times... > > > Thanks Having 27 indexes and using queries with LIKE "%...%" is a nice recepee for slowness. Try normalising your schema and using fulltext search instead of LIKE "%...%". "%..%" queries can't use indices. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: problem running compiled version of mysql-3.23.41 with innodb
[EMAIL PROTECTED] writes: > Hi all, > > > i am not sure if i am at the right list. > But i will ask my question anyway. > > Here is the problem. > I have compiled Mysql version 3.23.41 with Forte 6 update 1 from Sun. > I have done this on a SPARC system and complied it 64bit. > I didn't had any prblems in compiling it with the option innodb no > errors only some warnings. > After i have instlled it i am creating my my.cnf file with all the > directory etc... > When i start it up i is creating the files, and then at the last logs > it creates it but then hangs. > you can wait for days but nothing happens after that. > > Does anybody know how i can solve this. > Here is my my.cnf file > > # Uncomment the following if you are using Innobase tables > innodb_data_file_path = ibdata1:400M > innodb_data_home_dir = /ibdata > innodb_log_group_home_dir = /ext/innodblog > innodb_log_arch_dir = /ext/innodblog > set-variable = innodb_mirrored_log_groups=1 > set-variable = innodb_log_files_in_group=3 > set-variable = innodb_log_file_size=5M > set-variable = innodb_log_buffer_size=8M > innodb_flush_log_at_trx_commit=1 > innodb_log_archive=0 > set-variable = innodb_buffer_pool_size=16M > set-variable = innodb_additional_mem_pool_size=2M > set-variable = innodb_file_io_threads=4 > set-variable = innodb_lock_wait_timeout=50 > > > Thanks in advance > Filip > ps: the main problem is that there is no error message it simply stays > there and does not give me in the error file > ready to take connections Checkout for free space on /ibdata partition and for Unix privileges. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Table corruption at MySQL 4.0.0 shutdown ?
Fournier Jocelyn [Presence-PC] writes: > Hi, > > I noticed an annoying behaviour with MySQL 4.0.0. > I have 11 tables with a lot of rows (about 1 Million and more) which are constantly >updated by a php script. > It seems after a shutdown of mysql (mysqladmin -uroot -p shutdown) and a restart, >some tables are corrupted (and not the same, it randomly occurs), and I have to run a >myisamchk to repair them. > > Here is the structure of the table : > > > CREATE TABLE searchhardwarefr9 ( >mot varchar(30) NOT NULL, >topic mediumint(8) unsigned DEFAULT '0' NOT NULL, >date date DEFAULT '-00-00' NOT NULL, >pseudo varchar(35) NOT NULL, >numreponse int(10) unsigned DEFAULT '0' NOT NULL, >PRIMARY KEY (mot, pseudo, date, numreponse, topic), >KEY pseudo (pseudo, date, numreponse, topic), >KEY numreponse (numreponse, topic), >KEY topic (topic) > ); > > -=[root@s15]=(/usr/local/var/Hardwarefr)# myisamchk -o searchhardwarefr9.MYI > <(17:31:25) > - recovering (with keycache) MyISAM-table 'searchhardwarefr9.MYI' > Data records: 977549 > Duplicate key 1 for record at 30977704 against new record at 30946580 > Duplicate key 1 for record at 30977736 against new record at 30946612 > Duplicate key 1 for record at 30977768 against new record at 30946644 > Duplicate key 1 for record at 30977796 against new record at 30946672 > Duplicate key 1 for record at 30977828 against new record at 30946704 > Duplicate key 1 for record at 30977860 against new record at 30946736 > Duplicate key 1 for record at 30977896 against new record at 30946772 > Duplicate key 1 for record at 30977928 against new record at 30946804 > Duplicate key 1 for record at 30977960 against new record at 30946836 > Duplicate key 1 for record at 30977992 against new record at 30946868 > Duplicate key 1 for record at 30978024 against new record at 30946900 > Data records: 977538 > myisamchk: warning: 11 records have been removed > > Any idea ? (hardware related or mysql related ?) > > Thank you :) > > Jocelyn Fournier > Presence-PC > As you know very well, we would truly need a repeatable test case. We are very keen of fixing our 4.0 bugs, and this could be one. It could be hardware too, but how could we know ? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: SMALL MYSQL Problem
O'SULLIVAN JOHN writes: > Hi > I am just starting to write my first client with MYSQL 3.23.39 under RH > Linux 7.1 and I had the following code. > The code compiles fine but the call to mysql_query( ) fails with following > error > > > I used the exact same query at the MYSQL prompt and it worked fine > Could anyone please tell me where I am going wrong. > > john > First, you did not say what error. Second, before you execute mysql_query, shoot out a string to stdout. You probably forgot to escape quotes or something similar. -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Problems installing mysql3.23.41 source version
sachin shetty writes: > Hello > I get the following error message when i complie the source version of > mysql3.23.41. > > checking character sets... configure: error: No number was found in > ./sql/share/charsets/Index for the latin1 character set. This is a bug in > the MySQL distribution. Please report this message to > [EMAIL PROTECTED] > > Is there something amiss in the source distribution or is there something > else to it > > > Thanks in advance > > Sachin > What GNU make, automake, autoconf versions do you use and what compiler do you use ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Upsides of MySQL?
Frank Fisher writes: > Tyrone Mills wrote: > > > good. Maybe MySQL needs to charge support fees comparable to M$ and Oracle > > to make these pinheads happier. Have a special support contract, don't offer > > anything different, just call it something "Corporate" sounding and charge > > 10 times as much... > > Monty should seriously consider this. As Tyron said, come of with a > fancy name like "Select Corporate Support" or something else, promise > 24-hour turnaround on MySQL support (which you pretty much do already), > and charge just under the MS price. > > Frank. It is truly a fine idea ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Upsides of MySQL?
Tyrone Mills writes: > In my previous job supporting MSSQL at hospitals all across North America, > Europe and Australia, Critical Incident support from M$, ranged from 36 > hours to 4 days for a resolution. Often we solved it ourselves long before > we had an answer from M$... Sad really... MySQL support is far superior, but > to pointy heads, if they don't pay a lot of money for something, it can't be > good. Maybe MySQL needs to charge support fees comparable to M$ and Oracle > to make these pinheads happier. Have a special support contract, don't offer > anything different, just call it something "Corporate" sounding and charge > 10 times as much... > time-to-resolution from a non-GPL db company? > > -- > | Nigel Wood > | PlusNet Technologies Ltd. > + -- Internet Access Solutions @ http://www.plus.net - I must admit that this sounds like a beautifull idea !! -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Developing addons for MySQL
Mike Westmacott writes: > Hi, > > I'm a researcher at the University of Southampton, and at some point I will > need to develop a multidimensional database. Initially I was just going to > write a very simple SQL server, and then I thought that it might be worth > trying to write something for MySQL. > Sadly due to our Draconian IPR (due to some important research working > falling into the rather large hands of British Telecom) I could not develop > it as something that might be able to contribute towards MySQL has a whole, > however it is something I am interested in and I was wondering what > resources (ie source!) are available for developing the MySQL server. I > couldn't find any info around (ok so I could have looked a bit harder :) > Should I be contacting a memeber of the development team? > > cheers > Mike Westmacott > PhD Researcher > IAM, ECS > University of Southampton > Southampton > England > Go to our download pages and you will find a source tarball. Direct all your questions regarding server source code issues to [EMAIL PROTECTED] -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: BDB and InnoDB in windows nt versions
Bruce Scharlau writes: > Hi all, > > I'm trying to work out which distribution of mysql supports BDB or InnoDB > tables. > I've downloaded 3.23.40 and checked 'show variables' asnd it says these > tables are not supported. > I know the docs say they should be available in the distro, but it seems > not in this version. So, who can tell me which one does? > > Cheers, > > Bruce Download MySQL-Max .. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Downsides of MySQL?
Boget, Chris writes: > Good morning. > Recently, we presented MySQL as a database option for a website that > we might be working on. We've used it as our database in the past and > we plan on using it in the future as possible. > With that said, I confess I don't have as intimate a knowledge of mySQL > to address some of the things in the email that was sent to me. I'd like > to hear what some of you have to say/think about this. I know some > of the things said below aren't entirely correct, but I'm not 100% sure > about some of the others. > > --Begin Quote-- > > MySQL - as I said at our meeting, we would not be comfortable with this > as an enterprise strength solution. MySQL is unsupported freeware and > lacks enterprise management functionality. It has a small limited feature > set compared to ORACLE, DB/2 and is lacking the functionality to support > data replication and has little capability for generating management info. > There are question marks around the scalability of the product, I'm not > sure of the locking algorithms used (whether row level or record level) - > the > fact that it is not generally used in multi-user solutions is a good enough > indication that this is not accepted database technology for > industrial-strength > multi-user systems. > The fact that it is unsupported freeware would mean that an end user would > potentially be "held to ransom" by a DBA with specific knowledge. The mySQL > security model is also not sufficiently developed for any system that > involves > money. > I would not be prepared to sign-off any solution containing mySQL. > > --End Quote-- > > I'd love to get your input. > > Thank you for your time and your knowledge. > > Chris Chris, The above text between Begin and End Quote is full of ignorance. MySQL has full replication, transactions, multi-versioning, row level locking (two last ones with InnoDB table handler), and it is scaling extremely well. It is powering some of the sites which are very heavily hit, lke Slashdot, Yahoo, and many, many others. Many large companies like IBM, Siemens etc are utilising MySQL. It is also powering some Stock Exchange's. Visit our site and find out more about our references and capabilities. There are many tools available for MySQL, either from us or from third parties. As MySQL is supporting ODBC, JDBC etc, you can use any of the tools utilising those protocols. Beside this, we take pride in providing the best commercial support for any RDBMS. Period. Visit https://order.mysql.com for more details. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: SunUltra-60 compiler problem!!
Return-Path: <[EMAIL PROTECTED]> Received: from work.mysql.com (work.mysql.com [192.58.197.161]) by platon.cytanet.com.cy (8.11.1/8.11.1) with ESMTP id f7G5g531486312 for <[EMAIL PROTECTED]>; Thu, 16 Aug 2001 08:42:11 +0300 (EEST) Received: (from root@localhost) by work.mysql.com (8.9.3/8.9.3) id HAA32761 for [EMAIL PROTECTED]; Thu, 16 Aug 2001 07:42:09 +0200 Received: from ds-ex02.arima.com.tw (c1.h203149173.is.net.tw [203.149.173.1]) by work.mysql.com (8.9.3/8.9.3) with ESMTP id HAA32750 for <[EMAIL PROTECTED]>; Thu, 16 Aug 2001 07:41:55 +0200 content-class: urn:content-classes:message Message-ID: <[EMAIL PROTECTED]> Thread-Topic: SunUltra-60 compiler problem!! Thread-Index: AcElhhxtU/UZAxGAQjOUZvL3kVfemQAbh/eg Subject: RE: SunUltra-60 compiler problem!! From: "Aru.Chen" <[EMAIL PROTECTED]> To: "Sinisa Milivojevic" <[EMAIL PROTECTED]> Date: Thu, 16 Aug 2001 13:41:15 +0800 Cc: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> X-MimeOLE: Produced By Microsoft Exchange V6.0.4712.0 X-MS-Has-Attach: X-MS-TNEF-Correlator: X-Virus-Scanned: by AMaViS perl-11 X-UIDL: MR@"!47U!![Lc"!;)]"! MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="_=_NextPart_001_01C12616.10D31BC8" Sinisa Milivojevic, I have do this 'export CXXLD=g++' config, but the problem still exist on solaris. attachments for you reference: Regards, Aru August=20 You did not do it prior to configure, or you did it all over the existing source tree with non-deleted config.cache. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Trouble upgrading to mysql ver 3.23.41
sachin shetty writes: > Hi > i have successfully installed the 3.23.39 version of mysql. but the > 3.23.41 version throws the following error when the mysqld daemon is > started > > 010815 15:14:42 mysqld started > 010815 15:14:42 Warning: setrlimit couldn't increase number of open files > to more than 64 > 010815 15:14:42 Warning: Changed limits: max_connections: 54 > table_cache: 64 > 010815 15:14:42 bdb: malloc: Not enough space: 10485760 > 010815 15:14:42 Can't init databases > 010815 15:14:42 mysqld ended > > > Any help will be appreciated...!! > Thanks > sachin > You have hit some ulimit problems. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Large data in tables
Jeremy Zawodny writes: > On Wed, Aug 15, 2001 at 09:25:27PM +0300, Sinisa Milivojevic wrote: > > > > This limit is already increased in 4.0 to 4 Gb. 4.0 will be > > available next month. > > 4.0 will be in alpha/beta testing at that point, right? It's > important not to set expections too high. :-) > > Jeremy > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 > > MySQL 3.23.29: up 60 days, processed 570,120,875 queries (108/sec. avg) I think I was quite realistic ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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 and multiple CPUs
Kevin writes: > > Does MySQL running on Solaris take advantage of multiple CPUs? > Yes, automatically ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Large data in tables
Trevor Linton writes: > I'm researching whether it is possible to store large amounts (30-70MB > files) into mysql columns. It looks as if a LONG BLOB could handle this, > however I read that the communications buffer size can only support up to 16 > MB transfers. It also said that you could increase the size of the buffer, > however it never said the name of the variable setting to change to do this. > This server is a monster, and memory and disk space are not a problem, If I > can increase the "message buffer" will this allow me to store between > 30-70MB files into these LONGBLOB fields? > > I know it seems like I should just store them into the file system but the > application at hand needs them in a database (please don't make me explain > why :-) ). Does anyone know whether MySQL is powerful enough to handle this > amount of data in a single column? Are there any other special > considerations I should take in with doing this? > > Thanks, > Trevor > > Trevor F. Linton > Systems Administrator/Web Developer > Vérité Multimedia Inc. > http://www.verite.com > DVD * CD * Web * Print * Film * Sound > Phone: 801.553.1101 x 111 > Fax: 801.553.1215 > [EMAIL PROTECTED] > > Maximum size of a row is limited in 3.23 by maximum value of max_allowed_packet, which is 16 Mb. This is maximum value due to current client - server protocol limitations. This limit is already increased in 4.0 to 4 Gb. 4.0 will be available next month. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Adding & editing tables
Ray Gurganus writes: > I am running MySQL 3.23.39, and I just installed MySQL GUI 1.7.5-1, running > on Windows 2000. I have several databases already loaded, and have a table > chosen. In the GUI, when I go to the menu commands or hotkeys to create > tables or edit tables, I get no response. Am I missing a step? Or is it a > bug? > > Ray Gurganus > Community IT Innovators > [EMAIL PROTECTED] > 202-234-1600, x365 > None of the above. Edit table is in works and create on TODO. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: SunUltra-60 compiler problem!!
Hi, When I install mysql that occur something error on solaris. attachments for you reference: Hardware Spec. Generic_105181-19 sun4u sparc SUNW,Ultra-60 CPU: 450Mhz *2 RAM: Memory: 2048M H.D: 18G *2 Soft Spc. SunOS i2dev 5.6 Mysql 3.23.41 error message as below: /bin/sh ../libtool --mode=3Dlink gcc -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_RWLOCK_T -o mysqlbind gcc -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_RWLOCK_T -o mysqlbinlog mysqlbinlog.o mini_client.o netd Undefined first referenced symbol in file __cxa_pure_virtual mysqlbinlog.o ld: fatal: Symbol referencing errors. No output written to mysqlbinlog collect2: ld returned 1 exit status make[3]: *** [mysqlbinlog] Error 1 make[3]: Leaving directory `/tmp/mysql-3.23.41/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/tmp/mysql-3.23.41/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/tmp/mysql-3.23.41' make: *** [all-recursive-am] Error 2 -- Regards, Aru August 15 You are using gcc 3.0. Do : export CXXLD=g++ prior to running configure on the fresh tarball. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: gcc 2.95.3 compile failure -"sql_lex.cc: In function `void lex_init()':"
[EMAIL PROTECTED] writes: > >Description: > > I am using the recommended ./configure options as specified by: > http://www.mysql.com/doc/S/o/Solaris.html. I am unsure how to > specifiy the GNU ld - the output from ./configure shows that I am > using the Solaris ld. Perhaps that is the problem? I run GNU make 3.79 > and GNU m4 1.4, GNU Autoconf 2.13, Automake 1.4. ./configure > knows I am using the other GNU tools bison and flex. > All attempts to compile MySQL 3.23.39 using GCC 2.95.2 or 2.95.3 fail > with this error: > These symbols are defined in lex.h. Check out that you have that file and that it is OK. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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 3.23.41 has invalid asm constrainst
Trond Eivind Glomsrod writes: > >Description: > > mysql 3.23.41 doesn't build properly on IA32 with assembly and innobase enabled. > 3.23.40 didn't have this problem > > Configure statement in spec file ("%configure" is a standard rpm macro, specifying > CFLAGS and CXXFLAGS and various prefixes) > > %configure --without-debug \ > --without-readline \ > --enable-shared \ > --with-extra-charsets=complex \ > --with-bench \ > --localstatedir=/var/lib/mysql \ > --with-unix-socket-path=/var/lib/mysql/mysql.sock \ > --with-mysqld-user="mysql" \ > --with-extra-charsets=all \ > --with-innodb \ > --enable-assembler \ > --with-berkeley-db --enable-large-files=yes --enable-largefile=yes \ > --with-thread-safe-client > > results in: > > gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include-DDBUG_OFF -O3 >-DDBUG_OFF -O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS= > 64 -D_LARGEFILE_SOURCE -DDEBUG_OFF -DUNIV_INTEL_X86 -c sync0sync.c > sync0sync.c: In function `sync_gnuc_intelx86_test_and_set': > sync0sync.c:187: impossible register constraint in `asm' > sync0sync.c:187: impossible register constraint in `asm' > sync0sync.c:187: impossible register constraint in `asm' > sync0sync.c: In function `sync_gnuc_intelx86_reset': > sync0sync.c:202: impossible register constraint in `asm' > sync0sync.c:202: impossible register constraint in `asm' > sync0sync.c:202: impossible register constraint in `asm' > make[4]: *** [sync0sync.o] Error 1 > make[4]: Leaving directory `/tmp/32683-i386/BUILD/mysql-3.23.41/innobase/sync' > make[3]: *** [all-recursive] Error 1 > make[3]: Leaving directory `/tmp/32683-i386/BUILD/mysql-3.23.41/innobase' Hi! This one is for Heikki to answer, but seems that your version of GCC imposes some constraints that previous versions, and for that matter 3.0 do not. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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 3.23.41 errors during compile
Faine, Mark writes: > Anybody seen this before: > > gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti > -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H > -I/export/home6/temp/mysql-3.23.41/include -DHAVE_RWLOCK_T -o mysqlbinlog > mysqlbinlog.o mini_client.o net_serv.o mini_client_errors.o violite.o > password.o ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a > ../myisammrg/libmyisammrg.a ../heap/libheap.a ../mysys/libmysys.a > ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -lpthread > -lthread -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread > mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0xc): undefined reference to > `__cxa_pure_virtual' > mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0x1c): undefined reference to > `__cxa_pure_virtual' > collect2: ld returned 1 exit status > make[3]: *** [mysqlbinlog] Error 1 > make[3]: Leaving directory `/export/home6/temp/mysql-3.23.41/sql' > make[2]: *** [all-recursive] Error 1 > make[2]: Leaving directory `/export/home6/temp/mysql-3.23.41/sql' > make[1]: *** [all-recursive] Error 1 > make[1]: Leaving directory `/export/home6/temp/mysql-3.23.41' > make: *** [all-recursive-am] Error 2 > > > Could use some help getting this to compile, > -Thanks > Mark > A solution for building MySQL with gcc 3.0 has been found. After unpacking a tarball and prior to running configure, run this command : export CXXLD=g++ With this we answer to all our users that started using gcc 3.0 before we did. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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 causing severe load problems on Dual-Athlon server?
Ryan Shrout writes: > This just happened a second time today... that is the most frequent yet. > > Please, you have got to help me on this! > > Ryan Shrout > Owner - Amdmb.com > http://www.amdmb.com/ > [EMAIL PROTECTED] > This definitely looks like thread related problem. Upgrade to kernel 2.4.8 and glibc 2.2.3> -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Copy of databse on my PC....
Michael T. Babcock writes: > > Thank you for your technical question to the MySQL team. > > Unfortunately, our developers are not able to answer this type of > > inquiry if you have not purchased a technical support contract. > > I'd like to know if this is now official MySQL policy (filling the list > with this letter repeatedly). > > If so, I'm unsubscribing ... > -- > Michael T. Babcock > CTO, FibreSpeed Please excuse our colleague Tonu. He thaught that he was reading a support list. He has already appologized to you, and so do I ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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 bug with if and datetime fields
Arturs Aboltins writes: > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Subject: MYSQL bug with if and datetime fields > > >Description: > In queries where datetime field is in "WHERE" condition, the same > field > in "IF" statement causes incorrect query result. > >How-To-Repeat: > #--- > - > mysql> select * from test ; > +--+-+ > | id | dt | > +--+-+ > |1 | 2001-08-14 00:00:00 | > |2 | 2001-08-15 00:00:00 | > |3 | 2001-08-16 00:00:00 | > +--+-+ > 3 rows in set (0.00 sec) > > mysql> select * from test where dt='2001-08-14 00:00:00' and dt = > if(id=1,'2001-08-14 00:00:00','1999-08-15'); > Empty set (0.95 sec) > Please try the above with 3.23.41. I think that it was fixed meanwhile. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Problems with MYSQL-D-MAx for win 98 DROP TABLE
Luciano Pulvirenti writes: > If you create a Berkeley-DB table (es. CREATE TABLE TEST TYPE BDB) is not > possible delete it after. > The command DELETE TABLE TEST responds Table unknown. > Thank You > Luciano > Your CREATE statement is a bit dubious, so check that there is such a table at all. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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
MySQL++ 1.7.9 static lib for Mac OS X
Hi1 I have built MySQL++ lib on OS X and have uploaded static version of the library for Mac OS X on MySQL++ page. OS X users just have to install manually that library and include files and can start using it. Library is built with GNU 2.95.2 and is therefore useable only with that compiler and libstdc++ that comes with it. Beside the above, OS X users will also have to make a symlink from iostream.h to ostream.h. Library and examples has been built manually, as current libtool's are still not good enough for the normal automated build of MySQL++. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: mysqld forgets location of datadir
Rene Churchill writes: > > I'm having a problem with mysql forgetting the location > of it's datadir. After the server has been running for > some time, it looses track and starts throwing errors > when I attempt to select a database. Killing mysqld > and letting safe_mysqld restart it fixes the problem > for a while, but having to do it 10 times a day is a > bit much. > > I've recompiled the server with the datadir set via > ./configure instead of the command line of safe_mysqld. > That seems to have reduced but not eliminated the > frequency of the problem. This could also be a side > effect of less traffic on the weekends. > > mysqld - 3.23.29 > gcc - 2.95.2 > OS - MaxOS 10.0, Darwin 1.3.7 > Apache - 1.3.19 > PHP - 4.0.x? > > I'm currently waiting for it to start throwing these > errors again before I can do a mysqladmin variables > and extended-status. These will be submitted via > support.mysql.com > > Has anybody else seen this kind of behavior? Any > suggestions on how to debug it? > > Thanks, > Rene > > > > > -- > René Churchill [EMAIL PROTECTED] > Vermont Web Wizard, LLC802-244-5151 > Specializing in Web Programming802-244-5512 (fax) > http://www.vtwebwizard.com No, but please if you can find when and why datadir is changed, that would be nice. Also send the output from mysqladmin var that shows that change has occured. Also check if there is anything in the logs. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: InnoDB and Multithread
If you use a same MySQL handle for several threads you have to put mutex locks around each {mysql_query() ..} -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: BSD/OS 4.1 binary for MySql
David Ross writes: > Is the freebsd-elf mysql binary available at mysql.com compatible with > BSD/OS (bsdi) 4.1? If not, is there a place to download this > binary...or am I stuck with building it myself? > > Thanks, > David You should build it yourself. Just follow instructions from the manual. Also use 4.3 as 4.1 has some serious threads problems. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Fatal warning in MySQL build Sun Solaris x86
Jeff Tanner writes: > > mysql.cc, line 1187: [__1cVbuild_completion_hash6Fbb_v_]: OPT: Unknown > linkage type in dependency graph > 1 fatal error > > Ideas? > > Thanks > > Jeff Tanner > Seattle, WA Your C++ compiler is broken. Please re-install entire GNU 2.95.2 suite. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Binary transaction log
Michael T. Babcock writes: > I've been reapplying transactions to my aforementioned screwed up database. > It seems however, that the binary transaction log doesn't quite work > properly > with user variables (with MySQL 3.23.38). I have this entry from the log: > > insert into Projects (ParentID, Name, LongDesc) values (@customer, "VPN", > "VPN Work"); > > I remember doing that transaction, and I'd done a "SELECT @customer:=ID > WHERE ..." > beforehand. Since that SELECT isn't stored in the binary log (that I can > find), the value > for @customer is NULL. > > This just seems like a bug to me (I know what my SELECT was, so I've redone > it, but > this would be a problem for large-scale restoring). > > PS. Now I feel like I'm flooding the list, but that's ok ... > -- > Michael T. Babcock > CTO, FibreSpeed Yes, this definitely looks like an omission by our part. We shall investigate and fix the matter. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Not so good transaction support
What you are trying to perform is doable with InnoDB table handler. Unlike BDB, InnoDB has multi-versioning and consistent reads. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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 server for Sun Solaris i386?
Jeff Tanner writes: > I am looking within http://www.mysql.com/downloads/mysql-3.23.html for MySQL > server for Sun Solaris i386? > Is MySQL server for Sun Solaris Sparc build-able on Sun Solaris i386? > > Thanks > > Jeff Tanner > Viathan > Seattle, WA > Hi! Either build it from source or download some older contributed binary. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Build problems (+solution) on HPUX 10.20/gcc 2.95
Harro Verkouter writes: > > Hi Michael, > Ok. So I gave it another try. I untarred the source distro into a new > directory and ran the configure command above (only different prefix). > Made absolutely no difference whatsoever: still a gazillion+-1 errors > :). Below I have a snapshot of the kind of errors that fly by my tty > > I think our gcc is broken/only half installed; it can only build 32bit > apps. > > g++ -v: > Reading specs from > /local/gcc-2.95/lib/gcc-lib/hppa2.0-hp-hpux10.20/2.95.2/specs > gcc version 2.95.2 19991024 (release) > > > > <<< snip >>> > In file included from /usr/include/fcntl.h:9, > from ../include/global.h:176, > from mysql.cc:28: > /usr/include/sys/fcntl.h:212: initializer list being treated as compound > express > ion > /usr/include/sys/fcntl.h:212: syntax error before `char' > > <<< /snip >>> > > Cheers, > > -- > > Groeten, > > > Harro Verkouter Joint Institute for VLBI in Europe > [EMAIL PROTECTED] Radiosterrenwacht Dwingeloo > Postbus 2 > tel.: (+31)(0)521-596516 7990 AA DWINGELOO, the Netherlands > fax.: (+31)(0)521-597332 > OK, reinstall 2.95.2 and if the above error repeat, re-send me those errors, plus include /usr/include/sys/fcntl.h and stat.h in a direct mail to me. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Why is there no mysql hpux11 binary for hppa1.1 (32 Bit) database
Andre Konopka writes: > Hi, > > since .38 there is no longer a HPUX11 binary for the hppa1.1 architecure > (32 Bit)?? > > > I think that the 10.20 binary is runnable but I suppose that you > compiled it > with MIT-threads. On HP-UX11 I would prefer to compile it with native > threads, do you agree? > The 10.20 binary version isn't compiled with INNOBASE??? > > Thanks Andre > Do not use 10.20 binary. As your OS / CPU combo is rare, you could build MySQL yourself. With InnoDB. Just follow closely instructions from our manual , especially regarding patches for 11.0 , compiler etc ... -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Installing mysql-3.23.40 on Solaris 2.6
Emmanuel Tubacher writes: > Hi, > > I am new to this list -and somehow to Mysql- so apologies if this topic > already > been covered (list archives ?? where ??). > > I try to install a mysql 3.23.40 version on a Solaris 2.6 with gcc > 2.95.2 and > it just won't complete compilation or even configuration. > Depending on the flags placed in the ./configure command line I get a > wide variety of troubles : > --all-static not allowed in 2.6 because of missing libraries, ld > troubles in the end of the > compilation, c++ compilation errors and so on... > > I'm not the maintainer of the system and we just can't upgrade our > servers to Solaris 2.7. > > Has anyone succeeded in compiling this version on this OS and how ? > > Binary tarball for Solaris 2.7+ doesn't work of course, because of the > absence of libcrypt_1.so > library in Solairs 2.6. > > I badly need to upgrade my 3.22 version in order to use COUNT(DISTINCT ) > > SQL limitations,databases dumps and users admin in Mysql are really > frustrating > when you come from SGBD like Sybase. I know Mysql growing up fast, but > for now... > > BTW : how to upgrade a server from 3.22 to 3.23 ? The web site says that > there is no > compatibility issue, great ! But the key question remains : what has to > be replaced > in the mysql directory ? Only the executables un mysql/bin or more ? > > Many thanks for your help. > -- > Emmanuel. Hi! If you follow instructions in the manual, section on 2.6, you will have no problem building it. Do not try static builds, as it is impossible on Solaris. To convert mysql database from 3.22 to 3.23 use a script provided for the purpose. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: AW: Compiling error in complete.c: filename_completion_function
Sebastian Kayser writes: > Sinisa Milivojevic writes: > > > The dirent.h file is located @ > > /usr/include/ > /usr/src/linux/include/linux/ > > and in various directories below > > /usr/src/mysql-3.23.40/ > > and each of these files seems to be ok. > This is not ok. There should not be any dirent.h in mysql-3.23.40 except in mit-threads, and you should not use MIT threads on your system. Check out which dirent file got included and how is DIR defined in it. You must use a pager with gcc -E to get anything usefull. > Hope you can help again. I'm a bit of unexperienced concerning these > things. > > Regards, > > Sebastian Kayser -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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++ API under Mac OS X
Halim Chtourou writes: > > I'm using GCC 2.95.2 that comes with Apple's developer tools. I'm > getting tempted to try compiling GCC 3. > > Doing a grep for the above symbols returns matches for both the static > and dynamic libsqlplus libraries, as well as libstdc++.a, which is > automatically linked in with C++ code. I even tried manually adding > -lstdc++ but that didn't help. I've also tried defining various STL > options related to templates and several different compiler options, > without much success. Is this simply incompatible with GCC version > 2.95.2? > > > -Halim > You are using the right compiler. What you should check are symlinks to dynamic and static versions of libstdc++. They should point out to the stdc++ that came with gcc 2.95.2. If that does not help, add a full path to the correct libstdc++ in your linker command. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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+gemini compile errors
Brian P. Millett writes: > Hello, > SunOS shaka 5.8 Generic_108529-08 i86pc i386 i86pc > gcc version 2.95.3 20010315 (release) > > I'm trying to compile mysql+gemini-3.23.39 on a x86 Solaris 8 box. > I get the following error which has me completly confussed: > > > > -- > Brian Millett > Enterprise Consulting Group "Shifts in paradigms > (314) 205-9030 often cause nose bleeds." > [EMAIL PROTECTED] Greg Glenn You can try two things. First , checking that your compiler is well installed and that it produces x86 binaries and second, try disabling usage of assembly with MySQL configure. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Timezone problem.
Peter Zaitsev writes: > Hello Michael, > > Tuesday, August 07, 2001, 10:20:18 PM, you wrote: > > The question is which place do you do aply timezone ? > > I found the following interesting thing: Then mysql is started it uses > correct timestamp, therefore INNODB is started with wrong timestamp... > > 010807 12:59:44 mysqld started > 010807 8:59:45 InnoDB: Started > The above means that timezone has changed between the two calls .. Between the two was tzset call. This is a typical case when a zone is changed from GMT to something else !!! And you are 4 hours before GMT, aren't you ?? If on Linux, check where does /etc/localtime point to. Simply, your startup scripts are not well setup. TZ should be set at the machine boot. > > -- > Best regards, > Petermailto:[EMAIL PROTECTED] -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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
New version of MySQL++ for VC++
Hi! A new sub-version of MySQL++ for VC++ has hit MySQL++ page. This version solves all problems that arise in building application that involve both MySQL++ and MFC classes. Those problems are now fixed and VC++ programmers may further enjoy benefits of MySQL++ API. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Timezone problem.
Peter Zaitsev writes: > Hello mysql, > > It seems like you made an incomportable changes in 3.23.40 without > taking a time to write a release note :( > > The mysql 3.23.39 used the system timezone by default: > > maindb:/spylog/mysql/logs # date > Tue Aug 7 13:31:56 MSD 2001 > > | transaction_isolation | READ-COMMITTED > > | > | timezone| MSD > > | > | tmp_table_size | 4194304 > > > Therefore MYSQL 3.23.40 does not determinate the timezone correctly: > > | > | transaction_isolation | READ-COMMITTED > > | > | timezone| Local time zone must be set--see´ manual page > > | > | tmp_table_size | 4194304 > > | > > > It uses GMT in this case which could dammage the data (as went in my > case) > > The other thing is the manual does not contains much info about > setting timezone - only option to safe_mysqld which exports TZ > variable, which does not work: > > root 19380 1 0 13:43 pts/800:00:00 sh /usr/local/mysql/bin/safe_mysqld >--mysqld=mysqld --user=mysql --pid-file=/spylog/db/mysqld.pid --timezone=MSD >--datadir=/spylog/db > > It set's the timezone according to required value but date still bad: > > | transaction_isolation | READ-COMMITTED > > | > | timezone| MSD > > | > | tmp_table_size | 4194304 > > > mysql> select now(); > +-+ > | now() | > +-+ > | 2001-08-07 09:44:44 | > +-+ > 1 row in set (0.00 sec) > > Therefore date returns correct value. > > rat:/spylog/layers # date > Tue Aug 7 13:47:05 MSD 2001 > rat:/spylog/layers # > > > Do you have any ideas about this ? How I can fix the problem ? > > > > Peter mailto:[EMAIL PROTECTED] Hi Pjotr, I just tested the above, and it worked just fine for me with 4.0. But I have noticed something. If I mess up my shell, it will mess up all programs started from it, including MySQL. We can not do anything about it ... If a shell that starts up MySQL does not have TZ set properly then there is not much we can do about it ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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[2]: Timezone problem.
Peter Zaitsev writes: > Hello Sinisa, > > Tuesday, August 07, 2001, 4:48:56 PM, you wrote: > > 1) SUSE. Destributions does not have TZ variable set by default. And > the idea is it worked quite well wothout it with .39 > 2) The strange thing is why settng TZ makes mysql to print correct > timezone in variables but still produces the wrong time ? > > > -- > Best regards, > Petermailto:[EMAIL PROTECTED] Hello Pjotr, We did not changed it recently. If you take a look at Changelog, you will see that nothing like that was introduced. mysqld.cc has the following code at the beginning : tzset(); and that is all. Regarding a strange thing when you set TZ that it changes time, this is /bin/sh doing by help of kernel, of course. Check it out. Change TZ and watch your time change. We truly can't do anything about it. We must use OS C API functions for such things. Anyway, all those functions we use are POSIX compliant. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: MyOdbc to unix
SRIVATSAN RAGHURAMAN writes: > Hi Venu, > I want some sample codes for ODBC connection to MySQL. Where can I get it? > R.Srivatsan > [EMAIL PROTECTED] To connect from Unix or from Windows ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Build problems (+solution) on HPUX 10.20/gcc 2.95
[EMAIL PROTECTED] writes: > Description: > I tried to compile the mysql client stuff. > The first configure command was: > ./configure --prefix=/jaw0_3/jops/verkout --without-server --without-docs >--without-bench --without-debug --with-pthread > > This (obviously) did not fully work. Almost everyting was built, except the >mysql binary (mysql{admin,show,..} were ok (and did work). > When compiling mysql.cc it gave *a lot* of errors, on include and >some other files. Mostly errors on lines wher _fpos_t and/or int64 were used. Thanks ... We shall try to fix our configure script. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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++ API under Mac OS X
Halim Chtourou writes: > I was able to compile and install the MySQL++ API on my Mac OS X system, > however, whenever I try to run a program linked against the library, I > get undefined symbol errors. > > dyld: bin/wopsql Undefined symbols: > __t12basic_string3ZcZt18string_char_traits1ZcZt23__malloc_alloc_template1i0. > nilRep > ___iomanip_setw__FR3iosi > __t23__malloc_alloc_template1i0.__malloc_alloc_oom_handler > __t24__default_alloc_template2b0i0._S_end_free > __t24__default_alloc_template2b0i0._S_free_list > __t24__default_alloc_template2b0i0._S_heap_size > __t24__default_alloc_template2b0i0._S_start_free > __t12basic_string3ZcZt18string_char_traits1ZcZt24__default_alloc_template2b0i0. > nilRep > > Seems like a similar problem as described in the post: > http://www.geocrawler.com/archives/3/362/1999/5/50/1804413/ > However, the solution in that post does not produce any different > results. > > This even happens for the MySQL++ example programs. > > Anyone have any suggestions? I'd really really like to be able to use > this in a project I'm working on, but MySQL++'s lack of portability > seems rather insane. Tons of patching required to just get it working > on minor gcc version increments. Is this inflexibility due to the > design of MySQL++, design of GNU's STL, or all both? > > -Halim Chtourou > Hi! First of all, every new version of GNU compiler has it's own STL library and it's own set of quirks !! MySQL++ can not do anything about it! You could try uisng GCC 3.0 , for which you will find patch on MySQL++ page. May be 3.0 has lesser problems in porting. Regarding the above symbols they look to me like normal STL symbols. Check out which library you have to add to linker command. What GNU version did you use anyway ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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-3.23.40 - Compiler errors with Sun WorkShop 6
Rob McMahon writes: > >Description: > mysqld.cc will not compile with Sun Workshop 6 > CC: Sun WorkShop 6 2000/08/30 C++ 5.1 Patch 109490-01 > Failing with the following errors: > "mysqld.cc", line 1484: Error: Cannot use const char* to initialize char*. > >>>>char* p = strrchr(opt_name, FN_EXTCHAR); This is a known issue with Sun compiler, due to different strchr prototype. Change that line to : char* p = strrchr((const char *)opt_name, FN_EXTCHAR); -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: LOAD DATA INFILE performance testing
Jeff Tanner writes: > > I running a test on mysql to test its performance of doing a bulk insert > into a table using LOAD DATA INFILE. > > The table is simple: > > CREAT TABLE test ( > valueCHAR(32) NOT NULL PRIMARY KEY > ) > > The test is simple: > a) clear table > b) time performance of inserting X unique values into table from a > single file (each value on a new line) > > # of unique valuestime in seconds > 10 0.05 > 1000.05 > 1K 0.10 > 10K0.75 > 100K 10 > 500K 125 > 1M 500 > 5M 55000 > > My concern is the last entry of 5 million entries. Is there a mysql system > variable I should reset to improve performance? > > Thanks > > Jeff Tanner > Viathan > Seattle, WA No, but you could crate a table without index and add primary key after loading of data. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Borland MySQL client
Erlend Stromsvik writes: > Hi > > I having a little trouble with mysql, with the lack of sub-selects. > > Yes, I have read about joins, both the manual and from the MySQL book by > Paul Dubois, but none of those provide any 'real' info about what to do. > > It's ok to do join on table1, table2 and table3 as long as they are limited > to 10 records each, as in all of the examples you find on the net. But what > about my tables. I have one with 1,14 million and one with 136.000 and a > third with 65.000 records. What I want to do is to check for a match between > a record from table1 in table2 and from table1 to table3 > > ex. from table1 to 2: > select * from table1 where col1 in (select col2 from table2); > > > Would be nice to hear from someone who manages good sized databases. > > > Regards > Erlend Stromsvik Regardless of whether you use join's or subselects, the same number of rows has to be reviewed. What you have calculated is a Cartesian product, not join. But not as much as you think. JOIN's require that common columns are defined, which is done in ON or in WHERE clause. Make sure that you have proper indices on those columns and join will be much faster then corresponding sub-select. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: libmysqlclient[_r].so + pthreads + gdb
Vladimir Zidar writes: > It is gdb-5.0, Mandrake 8 version, with patch for threaded application under > new glibc/kernel. > That one is not very good for threaded apps. That is why we use gdb from snapshots. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Borland MySQL client
I will forward your mail to the programmer that contributed Borland version. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: (almost) unable to compile with gcc 3.0
[EMAIL PROTECTED] writes: > >Description: > When compiling with gcc-3.0 there are problems with > libstdc++, which is not linked to the executables > There also seems to be a problem with libwrap, who is > complaining about functions being called with wrong number > of arguments (this is not a prob with 2.95.4) > >How-To-Repeat: > Compile mysql with gcc 3.0 > >Fix: > set LDFLAGS=-lstdc++ Hi! MySQL must NOT be linked with libstdc++ ! To prevent that export CXX=gcc before running configure on the fresh tarball. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: link errors when compiling the client
Caryl Rahn writes: > I am getting link error when I try to compile with the mysqlclient library. > I tried adding -lgz at the end of my link line as the documentation > suggests. It cannot find -lgz > What can I do to fix this? > > Thanks, > > Caryl Rahn > Senior Operations Programmer > Siemens Building Technologies, Inc. > Security Systems Division > (954) 377-5955 > It is -lz, not -lgz ... What error message do you get ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Compiling error in complete.c: filename_completion_function
Sebastian Kayser writes: > Hi, > > i get the following error when trying to compile MYSQL 3.23.40 with only > the --prefix option set: > > > complete.c: In funtion `filename_completion_function´: > complete.c:1467: syntax error before `*´ > complete.c:1481: `directory´ undeclared (first use in this function) > complete.c:1484: `DIR´ undeclared (first use in this function) > > > but in complete.c these lines are as follows: > > 1463: filename_completion_function (text,state) > 1464: char *text; > 1465: int state; > 1466: { > 1467: static DIR *directory = (DIR *)NULL; > . > . > . > 1481: if (directory) > > > It seems as if it doesn't get the DIR type. What's wrong with this ? > > I've read someone else that this can be because of a missing file > libread.a, but this file is located at /usr/lib/libread.a > > Can someone help ? > > Thanks, > > Sebastian Kayser Hi! You have something wrong on your system. Some include files has messed in and changed things. It is also possible that your dirent.h file is missing or is messed. You can either use ready made readline for your system, or use gcc -E and find out which include file messes up. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Duplicate entry for SELECT query
Ivan Lulukyan writes: > Hi All. > Strange thing.The query below: > > select concat(domain,path,file) as url, title, '' as blank1, docdate, size, > date as lastmod, 'keywords' as keyw, description as descr, a.ID, sum((word > like 'acc')) as r, ( sum(word like 'acc')) as qu, f.ID, author, > class,charset,lang,'content' as content, count(*) as suma from words as w > left join aname_word as aw on w.ID=aw.wordID left join anames as a on > a.ID=aw.anameID left join files as f on f.ID=a.fileID left join paths as p > on p.ID=f.pathID left join domains as d on d.ID=p.domainID left join > file_names as fn on fn.ID=f.file_nameID left join path_names as pn on > pn.ID=p.path_nameID left join charsets as c on c.ID=f.charsetID left join > classes as l on l.fileID=f.ID left join class_names as ln on ln.ID=l.classID > where ((word like 'acc')) group by f.ID having qu>0 order by r desc > > answer me with > > ERROR 1062 at line 1: Duplicate entry '4783' for key 1 > > How can it be? > > Regards, > > Ivan Lulukyan > ACC > Armenia > Hi! Please CHECK all of the above tables for a corruption. If any of them is corrupted, REPAIR it and try again the above query. If the above errors happens with non-corrupted tables and with our latest binary for your OS, we would like to take a closer look at it. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: libmysqlclient[_r].so + pthreads + gdb
Vladimir Zidar writes: > >Description: > mysql refuses connection [local/unix-socket] when client is ran under GDB, > and linked with pthread library. It doesn't need to call any pthread_*() > function, it just fails when linked with it. > > >How-To-Repeat: > > #include > #include > > > main() > { > MYSQL m; > > if(mysql_connect(&m, NULL, "root", "mysqlroot")) { > printf("Connect okay\n"); > mysql_close(&m); > } else { > fprintf(stderr, "MYSQL:%d %s\n", mysql_errno(&m), mysql_error(&m)); > } > } > > > gcc m2.c -o m2 -D_REENTRANT -lmysqlclient_r > > gdb ./m2 > > run > > This looks most likely like gdb issue. Try the latest gdb snapshot available. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Further FreeBSD 4.3 Issues (CPU hogging)
Ken Menzel writes: > Hi Michael, > Sounds like the mysqld may have been stuck in a tight loop then. > Any ideas Sinisa? > Try the truss once more if it happens again. I can't think of > anything that would cause this. > Let me know what happens, also try the truss when the server is > running normally just to see the output and make sure you know how to > do it, even on an idle server it Prints something like this: > (null)() = 0 (0x0) > gettimeofday(0x283558e8,0x0) = 0 (0x0) > clock_gettime(0x0,0xbfafefa4)= 0 (0x0) > poll(0x82df000,0x2,0x0) = 0 (0x0) > > Ken Hi! I must admit I have not followed a thread, so I do not know what is a basic problem -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: CREATE INDEX -- bug?
David White writes: > I have a problem with some data disappearing after a CREATE INDEX > statement. Here's the sequence of events: > > 1. I have the tables MASTER_ACCOUNT, MASTER_EMAIL, MASTER_GROUP, > MASTER_INDIVIDUAL, TMP_PHONE_DAY, TMP_PHONE_FAX, and TMP_PHONE_NIGHT. > All of these are populated with lots of data, between 20,000 and 250,000 > rows each. There are other tables in the database, but these are the only > ones that I'm interested in here. > > 2. I run a Perl script. It uses DBI (1.14) to access the > database. It contains the lines: > > $dbh->do("CREATE INDEX ma ON $DB_SOURCE.MASTER_ACCOUNT(RACCOUNT)"); > $dbh->do("CREATE INDEX mi ON $DB_SOURCE.MASTER_INDIVIDUAL(RACCOUNT)"); > $dbh->do("CREATE INDEX mg ON $DB_SOURCE.MASTER_GROUP(RACCOUNT)"); > $dbh->do("CREATE INDEX me ON $DB_SOURCE.MASTER_EMAIL(RACCOUNT)"); > $dbh->do("CREATE INDEX pd ON $DB_SOURCE.TMP_PHONE_DAY(RACCOUNT)"); > $dbh->do("CREATE INDEX pn ON $DB_SOURCE.TMP_PHONE_NIGHT(RACCOUNT)"); > $dbh->do("CREATE INDEX pf ON $DB_SOURCE.TMP_PHONE_FAX(RACCOUNT)"); > > So far, everything is ok. The tables have all of their data, and are > indexed. > > 3. Later, I run the script again. (None of the data has changed in > the interim.) This will try to create duplicate indices, which is a > mistake that I hadn't thought about. I don't get any warning about > duplicate indices. Further, all of the data gets erased from the > tables! It looks like: > > -rw-rw1 mysqlmysql9674 Aug 3 09:45 MASTER_ACCOUNT.frm > -rw-rw1 mysqlmysql 0 Aug 3 09:45 MASTER_ACCOUNT.MYD > -rw-rw1 mysqlmysql1024 Aug 3 09:45 MASTER_ACCOUNT.MYI > -rw-rw1 mysqlmysql8686 Aug 3 09:45 MASTER_EMAIL.frm > -rw-rw1 mysqlmysql 0 Aug 3 09:45 MASTER_EMAIL.MYD > -rw-rw1 mysqlmysql1024 Aug 3 09:45 MASTER_EMAIL.MYI > -rw-rw1 mysqlmysql8772 Aug 3 09:45 MASTER_GROUP.frm > -rw-rw1 mysqlmysql 0 Aug 3 09:45 MASTER_GROUP.MYD > -rw-rw1 mysqlmysql1024 Aug 3 09:45 MASTER_GROUP.MYI > ... and so forth for all of the tables mentioned. Hi! This should not have happened !! Please try our latest 3.23.40 binary and see if there is anyway you can reproduce the problem. If you can reproduce it with our binaries (and your settings are all OK), we would like to take a closer look at your tables. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: socket error: Can't connect to local MySQL server through socket '' (111)
Charles Mégnin writes: > I am getting an error message > > Can't connect to local MySQL server through socket '' (111) > > trying to connect via mySQLgui on my Linux box running RH6.2 > I do have a > /tmp/mysql.sock > with proper authorizations > and have no problem connecting to the serverwithout the client. > Thanks for your clues > Charles All you have to do is follow instructions from README that came with mysqlgui. This is a relevant excerpt: When you start mysqlgui for the first time, you'll need to tell it how to connect to the MySQL server. To do this, click on the ``Options'' button. Select the ``Server'' tab and fill in the fields that indicate where to find the server. On Unix, if you have problems with mysqlgui not knowing the location of the socket file for connections to localhost, enter the full pathname of the socket file in the ``SQL command on the start-up'' field. On Windows, this field is used if you wish to specify the named pipe option. Then select the ``Client'' tab and fill in your MySQL user name. Take care to select the right value for the ``Ask for password'' button, depending on whether or not you want mysqlgui to prompt you for your MySQL password. After you have filled in the server and client values, click on the ``Save'' button. From then on, each time mysqlgui starts up, it will connect to the MySQL server automatically. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Thinking of switching from MyISAM to InnoDB
Nick Seidenman writes: > > Apparentlly there's a 4 GB limit to a MyISAM file when the table it contains > has VARCHAR, TEXT, or BLOB columns. In order to get around this limitation I > was looking to switching to InnoDB table types. As this looks like a > relatively new subsystem I'm wondering if it is stable enough for production > systems, or is it still too new (and too "feature-prone".) I'd appreciate > hearing feedback on this. If I do wind up switching, it won't be for at > least a month. > > TiA, > > nick > > > Nick Seidenman, CISSP > Director of Software Development > Hyperon, Inc. > www.hyperon.com There is no 4 Gb limit in MyISAM with later 3.23 versions. This limit is imposed by a filesystem only. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: floor/ceiling with myodbc
Kevin X Lin writes: > Hi there, > > I'm running into problems with functions "floor/ceiling" when I use > Visual Basic to talk to mySQL through myODBC. > > My code looks like this: > sSQL = "select floor(3.2)" > Set rs = MySQL_conn.Execute(sSQL) > > I got rs.eof = true after execution of the query. However the following > codes works fine. > sSQL = "select round(3.2)" > Set rs = MySQL_conn.Execute(sSQL) > rs.fields(0)=3 > > Can anyone tell if this is a bug of myODBC or VB's problem? > Sorry, but what is your problem ?? round(3.2) = 3 The above is quite true. As you have not specified number of decimals, MySQL is using default of 0, which conforms with SQL 92 standard. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Delete
Eric Fegraus writes: > Hello, > I just checked the list for answer to this question and looks like there > hasn't been one. I have a similar problem, I want to delete a record > from a table where the value of the field is equal to the value of a > field in another table. > > delete from table1 where table1.column = table2.column; > > Any thoughts? > > Thanks, > Eric > Beside Jeremy's valuable comment, you should know that the above is already possible in 4.0. 4.0 will be released this autumn. -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Query Not Using Indexing
Adam Douglas writes: > Ahh what do you mean "all tables are not related with common columns"? They > are not suppose to be related with a common columns. PostalCodeInfo and > Company table are completely two different things. > > Yes that is correct, I've resolved the issue with PostalCodeInfo for > indexing in the query. I had column types not matching the same through my > tables. But I'm still lost as to why I can not get CompanyShipInfo to use > indexing in the query. > > That's find but shouldn't I still be able to go down even further as to how > many rows are analyzed? CompanyShipInfo has 235 rows and all are being read > by the query. Here's the new explain of the query below. > > Another thing that happens is when I tried to ALTER PostalCodeInfo and > PostalCodeReps table schemas MySQL seemed to be hung and put the CPU usage > at 99.0% to 99.02% (never ending it seems). Both those tables only have > 42657 rows each. Any ideas why these two tables seem to hang when anything > major is done on them? Funny thing is it seems to be random when you execute > a query that uses these two tables. Is there something I'm missing for MySQL > configuration or bad table design? I'll post the table schema's below the > explain query. MySQL is truly doing it's best in your case. If of 6 tables you have a broken chain of relations, you will have a Cartesian product. Regarding ALTER TABLE, that is also expected behaviour, as MySQL is re-building indices and has to use lot's of CPU. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: mySQLd won't die under Darwin (Mac OS X 10.0.4)
Mark Tully writes: > Hi Sinisa, > > The server functions fine, I can run queries on it and I've lot it linked > into a bulletin board through php and apache and that works like a dream. > But it still won't die! > > mysqladmin -uroot -psql shutdown > > Returns without any complaint but the tasks are still going. > > If I stick a sudo before the above command it hangs and I have to kill that > off as well (although kill works for that - phew). > > The only way of killing them seems to be kill -KILL or it's synonym kill -9. > > I've not had any other thread related problems with my install. > > Any other pointers? > > Mark > Can you check with mysqladmin proc in which state were connections after shutdown ?? Sometimes it takes time for all threads to be killed ... I know that older Darwin versions did not require any thread libs, but may be this one does ?? Can you check it out with http://www.prnet.de/RegEx/mysql.html ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Bug in MySQL-4.0
Fournier Jocelyn [Presence-PC] writes: > Hi, > > I caught a bug in MySQL-4.0, but I don't know how to reproduce it ;) > > Here is the description : > > mysqld got signal 11; > This could be because you hit a bug. It is also possible that this binary > or one of the libraries it was linked agaist is corrupt, improperly built, > or misconfigured. This error can also be caused by malfunctioning hardware. > We will try our best to scrape up some info that will hopefully help diagnose > the problem, but since we have already crashed, something is definitely wrong > and this may fail > > > It seems to be linked with the new mysql union feature, but I don't use UNION in my >code ;) > > > Regards, > > Jocelyn Fournier > Presence-PC > www.presence-pc.com > > If you don't use UNION's, then they can not cause the crash. First check whether may be memory was not overrun. Otherwise, we do need a repeatable test case in order to pinpoint a bug. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: LOAD DATA INFILE with JDBC
Curtis Spencer writes: > Is this possible with 2.0 version (type 4 I think) MM driver found on > www.gjt.org? Also how do the file reading privileges for this work because > I tried doing it and it gave me an authorization error even though my mysql > user has FILE on it's privileges. Also, the file to read is chmod 774, so > it should be readable by all. > > Any ideas, > > Thanks Check two things : - file is on the server. If not use LOCAL clause - In both cases provide a full pahtname for the file -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Problem.
Ashadul Khan writes: > Dear Sir, > > I'm new to mysql. So please forgive me if I may sound so stupid. > > I did install mysql database. I also downloded you > Sun Solaris 2.7 Sparc static binary of MySQLGUI 1.6 > > After I unziped what should I do? How can this to work? > > My database is running on Sun Solaris 2.8. Your help is all > I need. > > Thanks > Ash. It is possible that Solaris distro of MySQLGUI does not have a README, so I am sending the one to you by separate mail. Just follow those instructions. -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: MySQL GUI
Marc Liyanage writes: > > Hi there, > > > Yup, but that is for the "old" Classic Mac OS, right? > > I looked around and did not find a port that runs directly > on the Aqua UI, which is what would be needed to run this software. > > > > > > > -- > _ > Marc Liyanage [EMAIL PROTECTED] > http://www.entropy.ch >ICQ 5077985 Yes, but write to the author. He once told me he knows how to port it to OS X. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: libz.a on AIX 4.3.3
Vish Kolla writes: > Hi, > > We are trying to install mysql on AIX 4.3.3 and have encountered > the following errors. MySQL is dependent upon libz.a(shr.o). Where > can we find this library ? Did anyone encounter this problem before ? > If so what is a viable solution ? > > Please respond to me directly as I am not on the list. > > Thanks, > Vish Kolla. > You can find that library at ftp.gnu.org. Build it from source, that is the best way to do it. On the side note : What are you using MySQL for and why on AIX. Why not Solaris ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: A small suggestion for the development team...
Bruce Stewart writes: > Hi Monty and all, > > I believe that you are planning to introduce foreign key support in a future > version of MySQL (I think version 4.0). > > Could you consider offering an option to the definition of a foreign key > which specifies the error message to return if the FK is violated. > something like: > > "ALTER TABLE mytable ADD CONSTRAINT mytable_FK FOREIGN KEY (myfield) > REFERENCES myothertable (myotherfield) MSG 'A friendly totally customizable > message'" > > > Thanks, > Bruce Foreign keys will not be introduced in 4.0. May be in 4.1 ... 4.0 will have cascading deletes and updates , which provides some of the functionality of foreign keys. 4.0 will also save FK info, for use in documentation and in programs that can optimize join queries, like mysqlgui -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: MySQL GUI
Marc Liyanage writes: > >I'm looking into it right now after reading your cc'd mails > >to the list. I'm not on the list BTW, you need to cc me... > > > > > > > >>>But as there is FLTK library for OS X and as there are GNU tools > >>>available, it is quite doable. > > > >Can someone point me to this particular FTLK for OS X? > > > >This seems to require that one is running X11 on > >Mac OS X, right? How many end-users would be willing > >to install XFree86 just for this application? What do > >you folks think? > > > >Also, flvw does not seem to build under OS X, > >it assumes "ar" flags that are invalid under OS X, > >and dynamic linker settings that don't work either... > > > > > >Cheers > > > >-Marc > > > > > > > > > > > >-- > >_ > >Marc Liyanage [EMAIL PROTECTED] > > http://www.entropy.ch > >ICQ 5077985 > > > >Yoda I am. Grammar I can't. > >_________ > You can try to do it without X. Go to www.fltk.org and to Bazaar page. You will find there a version of FLTK for Macintosh. If you have problems, write to the author. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Problem compiling on HPUX 10.20
Ing. Gustavo Edelstein writes: > Hi Sinisa, > I've downloaded the gnu make, installed it OK and tried to compile again > MySQL. This is the new err msg: > > make[1]: Entering directory `/usr/local/mysql-3.22.32/sql/share' > make[1]: Nothing to be done for `all'. > make[1]: Leaving directory `/usr/local/mysql-3.22.32/sql/share' > make[1]: Entering directory `/usr/local/mysql-3.22.32/sql' > g++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr/local\" > " > -DDATADIR="\"/usr/local/var\"" -DSHAREDIR=" > \"/u > sr/local/share/mysql\"" -DHAVE_CONFIG_H -I../mit-pth > read > s/include -I./../include-I./../regex > -I. -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates -DHAVE > _BRO > KEN_SNPRINTF -c mysqld.cc > mysqld.cc: In function `void close_connections()': > mysqld.cc:262: implicit declaration of function `int shutdown(...)' > mysqld.cc: In function `void server_init()': > mysqld.cc:581: implicit declaration of function `int setsockopt(...)' > mysqld.cc: In function `void * handle_connections_sockets(void *)': > mysqld.cc:1589: implicit declaration of function `int getsockname(...)' > make[1]: *** [mysqld.o] Error 1 > make[1]: Leaving directory `/usr/local/mysql-3.22.32/sql' > make: *** [all-recursive] Error 1 > > Thanks &best regards, > > Ing. Gustavo A. Edelstein > Tech. Mgr. > Equiplus Argentina S.A. Are you using 2.95.2 ?? If not please do. Also apply DCE patch. If MIT threads are not up-to-date get the latest version from MIT. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: hostname.err
Werner Stuerenburg writes: > > > You have turned binary logging or replication ON. > > True. How did I do that? > > my.cnf says > > # Start logging > log > log-slow-queries > > Oh, I see ... some place else: log-bin > > Sorry for the confusion. > > > -- > Herzlich > Werner Stuerenburg > Keine probleme -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: driver for mysql
muruganandam writes: > i want to connect mysql DB through C++ code(on linux).. > can any one give me the necessary URL from which i can download the driver.. > and the related info about the drivers(like most stable.etc.,) > > thanks in advance > > muruganandam Try using our 3.23 C API and MySQL++, our C++ API . Both are found on our site. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Compiling error
Have you tried setting CXX to gcc and CXXFLAGS to "-fno-rtti -fno-exceptions" ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Problem compiling on HPUX 10.20
Jose Vilmar Estacio de Souza writes: > Hi, > Sorry by my dumb question. > Could you tell me where I could find this manual? Also in what section of the >manual could I find the info about the patches for hp-ux 10.20? > Many thanks in advance! Our manual comes with both binary and source distros. In source distro it is in Docs subdir. It has a whole section on 10.20, where you will find info on patches. If you still have problems, consider taking our support (https://order.mysql.com). -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: mySQLd won't die under Darwin (Mac OS X 10.0.4)
Mark Tully writes: > From: Mark Tully <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: mySQLd won't die under Darwin (Mac OS X 10.0.4) > > >Description: > Downloaded source archive, compiled as of instructions. > The mySQLd server is started as root and it switches down to the > mysql user. It can be started using the "mysql.server start" command > or by "safe_mysqld --user=mysql &" and it appears to work fine. > However it just won't die! > kill doesn't work on either the mysql process or the script, the > "mysqladmin -u root shutdown" command similarly fails and the > "mysql.server stop" command times out. The only way I can stop it > is by manually killing off the script and then the server with > "kill -KILL". > The pid is recorded correctly and retrieved correctly by the > mysql.server stop command, but kill is just completely ineffectual. > >How-To-Repeat: > sudo mysql.server start > sudo mysql.server stop > Killing mysqld with pid 386 > Wait for mysqld to exit\c > .\c > .\c > .\c > . > . > . > gave up waiting! > >Fix: > sudo kill -KILL > sudo kill -KILL > Looks like a thread - related problem to me. Simply signals are not wroking ... Try this : Start MySQL server then try connecting to it and running some simple queries. If it works, then mysqladmin shutdown MUST work, provided user has ROOT privileges. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Crashing
Chris Hilbert writes: > I have been able to crash my server by doing a FLUSH TABLES in MySQL > 3.23.36 on Linux. Any ideas why it would die like this during normal > use? Or how to fix it? > > Thanks, > > Chris Hilbert There have been numerous bugs fixed since .36. Try our 3.23.40 binary and if you can repeat that crash, please let us know ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Unable to make readline
kevin curry writes: > SEND-PR: -*- send-pr -*- > SEND-PR: Lines starting with `SEND-PR' will be removed > automatically, as > SEND-PR: will all comments (text enclosed in `<' and > `>'). > SEND-PR: > From: kcurry > To: [EMAIL PROTECTED] > Subject: [50 character or so descriptive subject here > (for reference)] > > >Description: > When I try to "make all" i get the following error: > Making all in readline > GCC: gcc version 2.7.2 > Compilation info: CC='gcc' CFLAGS='' CXX='gcc' > Configure command: ./configure > --with-unix-socket-path=/var/tmp/mysql.sock > --with-low-memory --with-mit-threads=yes > --without-perl --enable-thread-safe-client > --with-berkeley-db --with-innodb > Perl: This is perl, version 5.005_03 built for > sun4-solaris > > > = > Kevin S. Curry > > E-Mail: [EMAIL PROTECTED] > Alt E-Mail: [EMAIL PROTECTED] > AOL IM: monkeymanksc > YAHOO IM: monkeyman_ksc > Work Phone: 703.516.6258 Your gcc is too old. Use version 2.95.2. Also, do not use MIT threads. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: hostname.err
Werner Stuerenburg writes: > To track down problems, I downloaded hostname.err, hostname.log > and hostname-slow.log and, as these were quite big (log = 350 > MB), I deleted them on the host. > > I remember that I turned on slow query logging and did not create > the log myself. Therefore, I assumed that MySQL would create all > these files anew. > > Instead, I found a new file called hostname-bin.001 which grew > rapidly and has nearly 800 MB after a week. I had a quick look > into that file and it looked pretty much like a log file to me. > I couldn't find any information about this kind of beast. > > Finally, I created empty files hostname.err, hostname.log and > hostname-slow.log yesterday and find that .err and .log have been > written to, which may be normal. In addition, .001 has been > written to also recently. > > Any explanation to what is happening here? My ISP says they > didn't do anything with MySQL. > > -- > Herzlich > Werner Stuerenburg Hi! Check up startup variables or global config file. You have turned binary logging or replication ON. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Innodb and statistics
Rafal Jank writes: > hi, > since analyze table doesn't work for Innodb tables, where does optimizer get > statistics needed for making proper query plan from? > For example, how does it know which index is more selective or in which order > tables should be joined? > -- > _/_/ _/_/_/ - Rafa³ Jank [EMAIL PROTECTED] - > _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl > _/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625 >_/ _/ _/ ==* http://szukaj.wp.pl *==-- > InnoDB indices provide all info required, plus they are rather well balanced. ANALYZE TABLE does not provide info for optimizer, it just stores key distribution for the table. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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 GUI
Michael Collins writes: > Perhaps Marc Liyanage would be willing to do it? He already has some > great packages available for easy install to Mac OS X: > > http://www.entropy.ch/software/macosx/ > > BTW, thanks Marc! > > Michael > > -- > __ > ||| Michael Collins ||| > ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] > ||| Seattle, WA, USA ||| http://www.lassodev.com > I would provide him with all the help I could deliver -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Can login to my default DB, but not an additional one
John Woodward writes: > Dear sirs, > > Possible (minor?) bug? > > I'm a newbie to MySQL and MySQLGUI, but I have a fair amount of experience w/Paradox >and MS Access. > > I am using www.phpwebhosting.com to host my web site (www.Rebates4Sure.com). > > I can telnet to Rebates4Sure.com, login in, and use a command "mysql -q" and >successfully login. At that point, I can issue the "use" command for either my >default DB or the additional DB phpwebhosting has created / configured / enabled for >me (Rebates). > > However, when I use MySQLGUI 1.7.5-1, I can successfully login to my default DB, but >when I try to "use Rebates", I get an error message "Access denied for user: >'[EMAIL PROTECTED]' to database 'Rebates'. Other methods of tweaking >didn't fare any better. > > I don't know, but I think I need to be identified as user 'nekote@dogwood' or >possibly as 'nekote@localhost' rather than what MySQLGUI appears to be automatically >generating for me. > > FWIW > > Thanks, > John Woodward This is simply a problem of setting up user@host privileges. It is possible that you have been granted globar privs with user@"%" but database privs with user@localhost. System administrator on the phpwebhosting site should be able to fix that. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Can MySql runs on the Stratus B11.0 HP-UX 64 bits machine
c cw_1 writes: > Hello, > > We have a Stratus HP-UX 64 bits (version B11.0) machine, > I would like to know if MySQL can run on the Stratus Box. > If it can, will it cause any problem? > Can MySQL be configured to the 64 bits to run on the Stratus? > > Thanks in advance. > > Connie What HP-UX version is that ?? Try 3.23.39 binary for 11.00 if it is 11.00. Otherwise, you will have to build MySQL. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Problem compiling on HPUX 10.20
Ing. Gustavo Edelstein writes: > Hi list members, > > After > ./configure --prefix=/usr/local/mysql > > I do a make and when change dir to mit-pthreads, I got following err msg: > > Making all in mit-pthreads > Make: Must be a separator on rules line 26. Stop. > > Thanks for any help. > > Ing. Gustavo A. Edelstein > Tech. Mgr. > Equiplus Argentina S.A. > __ > Quiere viajar ? www.NosVamos.com > __ > Visit us On Line at www.equiplus.com > Email addresses: > Operations: [EMAIL PROTECTED] > Consulting: [EMAIL PROTECTED] > Technical: [EMAIL PROTECTED] > Web related: [EMAIL PROTECTED] > General: [EMAIL PROTECTED] > Hi! Please use GNU make. Even better, use 10.20 binaries available on our site. Also, follow our manual versus required patches for 10.20 -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Query Not Using Indexing
Adam Douglas writes: > Correct 6 tables are being joined. Here's the explain of the query below > (btw, I'm not getting a index on CompanyShipInfo and PostalCodeInfo not > CompanyRep like I previous said). Excuse me if this seems dumb but I'm not > sure what you are saying in the last two comments. I understand an index > could be missing but where? I'll put the indexing/schema below the explain > for you. Basically I need to get the query to run faster. I have three > queries one for our Applied Product, Unitary Product and Wholesalers. A user > will send to the query a US Zip Code and based on that zip code it will > return the representative(s) that looks after that area (according to zip > code) for each product line. It takes about 14 seconds to run this query and > two others via PHP. Now this seems to vary and sometimes renders mysqld > useless. Mysqld will not accept at times user logins or even checking for > database status. The CPU usage on this process when it doesn't work goes > from 99.0% to 99.02%. It doesn't seem to matter how long you leave it, never > seems to end. Now the biggest tables I have is PostalCodeInfo and > PostalCodeReps. Both contain about 42657 rows, so table size is not a > problem. > If you scrutinize more closely your query and your table you can notice that : - all tables are not related with common columns - There are two indices missing - MySQL is using all of the indices available except on some small tables, like CompanyShipInfo -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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 GUI
Michael Collins writes: > What is MySQL GUI exactly? Is it like the MySQL module to Webmin for > viewing the database schema and manipulate table and column names? As > well as view the row details. Is it more capable or equivalent? How > about as compared to phpMyAdmin? > > I have not been able to take a look since there is no Mac OS X > version (yet?). There are quite a few more that are separate GUI > applications (meaning they don't run in a Web browser) now available > on Mac OS X: MacSQL, SQL4X, SQLBOSS > > > Anyone know others? > > -- > Michael > __ If there is a kind soul that would like to build mysqlgui for Mac OS X, it would be nice. I would have built it , but I do not have Mac, and I do have a lock of time. But as there is FLTK library for OS X and as there are GNU tools available, it is quite doable. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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 GUI
David Damstra writes: > I am having problems with the MySQL GUI for Win32. On my Win2000 Pro > machine my unzipper ( Aladdin Expander) cannot write to the target > directory specified in the archive because it does not exist. Any ideas? > > > David Damstra > One Protocol, Inc. > [EMAIL PROTECTED] > 616.732.6300 > 616.732.6301 Fax > Use WinZip and you will have no problems unpacking. Unpack it in any directory and then follow instructions in README. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Query Not Using Indexing
Adam Douglas writes: > I'm running MySQL v3.22.32. Here's my problem I run the following > select query and both CompanyRep and PostalCodeInfo tables are not > using my Indexing. Why? How can I get these two tables to use indexing > to speed up my query. You can look at my indexing on the two tables > below the query. > > Any help would be greatly appreciated, thanks! > > SELECT > Company.Company_Name, > CompanyShipInfo.Ship_Addr1, > CompanyShipInfo.Ship_Addr2, > CompanyShipInfo.Ship_City, > ProvincesStates.Prov_State_Name, > Countries.Country_Name, > CompanyShipInfo.Ship_Postal_Code, > Company.Phone, > Company.Fax, > Company.Email, > Company.Web_Page > FROM > CompanyRep, Company, CompanyShipInfo, PostalCodeInfo, > ProvincesStates, Countries > WHERE > ( > CompanyShipInfo.Prov_State_ID=PostalCodeInfo.Prov_State_ID > AND PostalCodeInfo.Postal_Code=98188 > AND CompanyRep.Company_ID=Company.Company_ID > AND CompanyShipInfo.Company_ID=Company.Company_ID > AND CompanyShipInfo.Prov_State_ID=ProvincesStates.Prov_State_ID > AND CompanyShipInfo.Country_ID=Countries.Country_ID > AND Company.Company_Status_ID=1 > AND CompanyRep.Invoice_Only=0 > AND CompanyRep.Wholesale_Rep=-1 > ) > > mysql> show index from CompanyRep; > +++---+--+---+-- > -+-+--+ > | Table | Non_unique | Key_name | Seq_in_index | Column_name > | Collation | Cardinality | Sub_part | > +++---+--+---+-- > -+-+--+ > | CompanyRep | 0 | PRIMARY |1 | > CompanyRep_ID | A | 213 | NULL | > | CompanyRep | 1 | Company_ID|1 | Company_ID > | A |NULL | NULL | > | CompanyRep | 1 | Wholesale_Rep |1 | > Wholesale_Rep | A |NULL | NULL | > | CompanyRep | 1 | Invoice_Only |1 | > Invoice_Only | A |NULL | NULL | > +++---+--+---+-- > -+-+--+ > > mysql> show index from PostalCodeInfo; > +++---+--+-- > ---+---+-+--+ > | Table | Non_unique | Key_name | Seq_in_index | > Column_name | Collation | Cardinality | Sub_part | > +++---+--+-- > ---+---+-+--+ > | PostalCodeInfo | 0 | PRIMARY |1 | > Postal_Code_Info_ID | A | 42657 | NULL | > | PostalCodeInfo | 1 | Prov_State_ID |1 | > Prov_State_ID | A |NULL | NULL | > | PostalCodeInfo | 1 | Country_ID|1 | > Country_ID | A |NULL | NULL | > | PostalCodeInfo | 1 | Postal_Code |1 | > Postal_Code | A |NULL | NULL | > +++---+--+-- > ---+---+-+--+ > > > - > 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 > > -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Query Not Using Indexing
Adam Douglas writes: > I'm running MySQL v3.22.32. Here's my problem I run the following > select query and both CompanyRep and PostalCodeInfo tables are not > using my Indexing. Why? How can I get these two tables to use indexing > to speed up my query. You can look at my indexing on the two tables > below the query. > > Any help would be greatly appreciated, thanks! > > SELECT > Company.Company_Name, > CompanyShipInfo.Ship_Addr1, > CompanyShipInfo.Ship_Addr2, > CompanyShipInfo.Ship_City, > ProvincesStates.Prov_State_Name, > Countries.Country_Name, > CompanyShipInfo.Ship_Postal_Code, > Company.Phone, > Company.Fax, > Company.Email, > Company.Web_Page > FROM > CompanyRep, Company, CompanyShipInfo, PostalCodeInfo, > ProvincesStates, Countries > WHERE > ( > CompanyShipInfo.Prov_State_ID=PostalCodeInfo.Prov_State_ID > AND PostalCodeInfo.Postal_Code=98188 > AND CompanyRep.Company_ID=Company.Company_ID > AND CompanyShipInfo.Company_ID=Company.Company_ID > AND CompanyShipInfo.Prov_State_ID=ProvincesStates.Prov_State_ID > AND CompanyShipInfo.Country_ID=Countries.Country_ID > AND Company.Company_Status_ID=1 > AND CompanyRep.Invoice_Only=0 > AND CompanyRep.Wholesale_Rep=-1 > ) Hi! You have 6 tables in a join. Possible causes of not using indices could be some index missing or low number of rows. Beside that, you do have Cartesian product as there are some tables not related. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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, MS SQL and a push subscription?
Sebastian Frost writes: > Hello, > > I spent the last days with searching a solution for the following > problem: > > We have to synchronise an MS SQL database in the USA with a mySQL > database in germany. The programmer who supports the database in the > USA likes to do that via a push-Subscription, which is an MS SQL > feature (not a very save feature I read!?). So, my question is: Is > there a way to do that with these different Databases? And if not: Is > there another way to connect an MS SQL- to a mySQL database to Publish > a Database from one server to another? I've searched Tutorials, > Newsgroups and Mailinglist-Archives for many hours without finding a > solution, so this list is my last chance. Please help, if you can. > > Best regards, > > Sebastian Frost > > > Schulz interaktiv GmbH | Wandsbeker Allee 1 | 22041 Hamburg > Fon +49 (40) 236 106 - 13 | Fax +49 (40) 236 106 - 15 > Mail [EMAIL PROTECTED] > You could write a C or C++ program with both API's included and read from one handle and write to another. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Hanging on Inserts
DS writes: > Hi All, > > I have a problem that came out of nowhere and seems > only to affect inserts and only on 2 tables. > > The machine is a linux box w/ 2gig of memory and 2 > pentium gig procs.. Mysql 3.23 One script that locks > the tables, does an insert in one query to a table > that is 120,000 record and another which is 100,000 > records both <10 mb in size. > > a week or so ago, the perl script that does these > inserts into these tables started to hang. The table > does not get updated, all the other queries stop and > the system load goes through the roof. > > We optomize the tables daily and on these tables the > time has increased a lot. I am reading the FM and it > says 4gig is no problem.. I am at 7mb and hanging on a > smoking machine... > > Any ideas where to look for problems? > > Thanks in Advance.. > > David > Hi! First use our binary. Second use kernel 2.4 SMP. Third check free space on both datadir and TMPDIR. Third, if nothing of the above helps, send the output from mysqladmin proc when that hanging occurs. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Privilege settings
Mike Blezien writes: > > Ok, now I understand, the "global" would refer to the privileges set in the > mysql db user table then,..correct?? :) and the privileges set in the db table > are specific to that particular database. Sound right?? > > thanks > > > Mike(mickalo)Blezien > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > Thunder Rain Internet Publishing > Providing Internet Solutions that work! > http://www.thunder-rain.com > Tel: 1(225)686-2002 > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > Yes, global privs cover all databases on that server , database privs cover all tables in that database etc. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Privilege settings
Mike Blezien writes: > Hi all, > > trying to figure out the relationship of the mysql User and db tables. Now when > a database is created and privileges are assigned to the new db, the db table is > updated and the user table is updated, but in the privilege columns of the user > table, all are set to 'N' but the appropriate privileges are set to 'Y' in the > db table for that particular database. > > Is there something I'm missing or doing wrong?? > > > Mike(mickalo)Blezien > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > Thunder Rain Internet Publishing > Providing Internet Solutions that work! > http://www.thunder-rain.com > Tel: 1(225)686-2002 > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Nope, you are not missing anything. There are four level of privileges in MySQL: - global - database - table - column It is important to know that privileges are OR'd not AND'd, so there are no problems with your setup. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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 3.23.40-Solaris8-Gcc3.0 error compiling with gemini
Faine, Mark writes: > I'm trying to intall mysql 3.23.40 on Solaris 8 ( GCC 3.0 ) but I'm having a > little difficulty. Whenever it gets to the gemini directory it errors out > with the following: > > /usr/local/bin/gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../incl -I../msgs-O3 > -DDBUG_OFF -O6 -DHAVE_CURSES_H -I/export/home6/temp/mysql-3.23.40/include > -DHAVE_RWLOCK_T -c tmdoundo.c > ../ctstset > ctstset: Compile tstset.cc --> tstset.[c|s] --> tstset.o > tstset.s: Assembler messages: > tstset.s:43: Error: Unknown segment type > tstset.s:43: Error: Rest of line ignored. First ignored character is `"'. > tstset.s:63: Error: Unknown segment type > tstset.s:63: Error: Rest of line ignored. First ignored character is `"'. > -rw-r--r-- 1 root other 2252 Jul 27 13:39 tstset.c > -rwxr-xr-x 1 root other 32426 Jul 27 13:39 tstset.cc > -rw-r--r-- 1 root other897 Jul 30 08:42 tstset.s > > Thanks, > -Mark You could try disabling assembler, which is MySQL default on SPARC and x86. If that does not help, inform GCC people and try using InnoDB instead. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Security problem with 3.23.38
Robert Cross writes: > > > I wrote: > >Try first granting USAGE on *.* to both users with 'identified by ...' > >and then try granting database rights. > > Thanks Sinisa, that works perfectly. I've now got a wonderful small and > fast database > that I can let the users into! > > Bob Cross. You are welcome. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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: Security problem with 3.23.38
Robert Cross writes: > > I've got a wierd problem with 3.23.38, built from source, running on RedHat > v6.2 (Intel). Put simply the wildcard character for user access doesn't > work. From my reading of the docs any of the following: > > grant all on mtdb.* to user1 identified by "bozo1"; > grant all on mtdb.* to user2@"%" identified by "bozo2"; > > should allow the specified users access to the mtdb database from any host > (assuming that they can input the password correctly!). > > Well - it doesn't work. Unless I GRANT for each user on each system that > they are likely to use they can't get in and get error 1045 - access > denied. > > Am I doing something terminally stupid, is there something wrong with my > build, or is it a bug? > > Ta > > Bob Cross. Hi! Try first granting USAGE on *.* to both users with 'identified by ...' and then try granting database rights. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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