Re: Default users privileges
Jang wrote: Hello, I'm new in this MySQL list. I only want to know what are the default privileges that are required, so that a normal user (wihtout any special priv.) can acces only to his DB, create tables, manage, insert, ..., his tables. I have try some differents config, but never have reach the right privs. Please, detail me also how and where (/MySQL tables) to create this default user, and the strict needed privs... Thanks very much. (Sorry for my bad english, i'm french, and it's difficult to find GOOD french docum. about MySQL) Best regards Jang create database user_database grant all privileges on user_database.* to user@host identified by 'password' See GRANT syntax in manual for more information. There should be no need to directly modify the mysql tables. - 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 I have two (or more) different SQL-databases on the same server?
Hi, Can I have two (or more) different SQL-databases running at the same time on the same server (or same computer)? Does it varies between the systems? And if I can, are they all available to PHP at the same time? If you *really* mean different databases, then yes, no problem (one of my production machines has 5), and they will all be available to PHP, subject, obviously to permissions. If you mean can you have more than one instance of MYSQL running, that's different. You may be able to (I've no experience here), but why would you want to? The Hooker -- "The more crap you put up with, the more crap you're going to get" - 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: Connectivity to MySQL DB
Sanjeev Kabra wrote: Hi, I installed MyODBC and even configured it. MySQL db running on Solaris is running under the root user. While defining the DSN using MyODBC in the username I tried putting root user and the password for the same but I keep getting error "can't connect to MySQL Server". The instance for MySQL is running. Is there any way to test the login process. I can logon MySQL db on using machine. Basically we are planning to user Actualte report writing tool and MySQL db. If you know any body using combination please let me know. Thanks. Sanjeev You must grant privileges to users on remote machines. See the manual for sintax on the GRANT command.. For example if you wanted users on a machine with a specific IP to have all access to a specific database you could do mysql grant all privileges on table.* to [EMAIL PROTECTED] identified by 'password' if the server is on a "trusted" network and you just want to allow access from any machine using a specific account you would o mysql grant all privileges on *.* to username@% identified by 'password' bascialy when you install mysql it is only set up to alllow access using user=root from the "localhost" - 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
Please can this newsgroup be added to the demon newsgroups
I used to be subscribed to the ISP 'Globalnet'. I have now moved to the ISP 'Demon'. I can no longer obtain this newsgroup, I rang Demon and they informed me that the newsgroup had to be submitted to them! Please could someone who knows how, submit this newsgroup to Demon. Thanks. Legal Disclaimer: Internet communications are not secure and therefore Exact Abacus does not accept legal responsibility for the contents of this message. Any views or opinions presented are solely those of the author and do not necessarily represent those of Exact Abacus unless otherwise specifically stated. - 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: wait_timeout?
On Tue, Jan 30, 2001 at 12:26:34PM -0600, Meyer, Patrick wrote: I am slowly gaining connections to the database that just sleep. I know these can arise from not closing the database. I am accessing it via MyODBC from Active Server Pages. However, I set wait_timeout to 3600... I have some that have been there for days... just sleeping. Why doesn't MySQL disconnect them from the timeout? Maybe I just don't understand wait_timeout. That's odd. I haven't had the need to use wait_timeout, so I can't say what you should expect. But I'd expect that it should work as documented. Do they appear to have anything particular in common? Same host/user/db? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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 and Fortran
Hello, does anyone know a way to use a mysql database in a fortran program? I want to use something like embedded SQL in the fortran program (f2c or g77 on a linux machine). Manfred Meier [EMAIL PROTECTED] - 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 Balancing.
On Tue, Jan 30, 2001 at 02:35:29PM -0700, Nathan Cook wrote: It seems like I have seen somewhere that load balancing and fail-over-services are available for MySQL, to share the load and mirror the data between two machines. Other than MySQL's built-in replication, which doesn't handle fail-over yet, I don't know of any which are MySQL-specific. There are various open source and commercial projects/products which do high-availability for various services on Linux, but I don't have any experience with them. I'd appreciate hearing back on the list about what you discover. I'm sure others would as well. Good luck, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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 history or tracabitity
On Wed, Jan 31, 2001 at 09:44:06AM +0100, Chappuis J.-Vincent wrote: Hi all ! I would like to know when the fields value has been changed and by wich user ? Does it exist a trace or an history of the tables in mysql database ? Maybe. If logging is enabled on the server, you can probably track down the change. If not (and you have no backups from earlier), you're mostly out of luck. You could check the timestamp on the .frm file for the table to see when it was last changed, but that won't tell you WHO changed it. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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
Very Urgent
Iam Getting the error "Unable to Connect to Local MySql Server through socket 'var/lin/mysql/ mysql.sock" my Version For MySql is 3.22.32. What is Th solutin For this mail me asap adieu Balaji.N Get free email and a permanent address at http://www.netaddress.com/?N=1 - 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: number of tables in a db
On Tue, Jan 30, 2001 at 09:44:55AM -0600, johnny p. wrote: I have several tables in my db that can potentially become *very* large *very* quickly. I was thinking about creating a table for each user of my database to keep data separate and allow each table to be 4GB due to OS restrictions. How many tables can a database have in it? Lots. :-) How many files can you put in a directory on your OS and still have reasonable performance? Divide that number by 3 and you'll have the number you seek. or should i create a database for each user with an identical table? and... in that case... how many databases can MySQL successfully handle at any given time? Similar issue. Just don't divide by 3. Since MySQL stores databases as directories full of files, and each table is composed of 3 files, it boils down the the performance of your operating system and how its filesystem is implemented. Are you talking about a few hundred or a few million? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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: Please can this newsgroup be added to the demon newsgroups
On Thu, Feb 01, 2001 at 08:47:21AM -, Stephen Livesey wrote: I used to be subscribed to the ISP 'Globalnet'. I have now moved to the ISP 'Demon'. I can no longer obtain this newsgroup, I rang Demon and they informed me that the newsgroup had to be submitted to them! Please could someone who knows how, submit this newsgroup to Demon. Huh? This is a mailing list, not a newsgroup. Someone might be mirroring it to a newsgroup somewhere, but why don't you simply subscribe to the mailing list? Otherwise, your ISP is the best place to ask about getting them to add the group. They'd certainly know better than most of us (who don't use the same ISP that you do). Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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 script
On Thu, Feb 01, 2001 at 02:12:03PM +1300, Quentin Bennett wrote: Hi, Each time I install mysql from a binary release that I have created, I have to modify safe_mysqld so that it can be called from mysql.server. This is because safe_mysqld checks to see if it knows what is going on before checking the command line args to see where things should be. Shouldn't this be fixed. so that mysql.server can call safe_mysqld 'out of the box'? I'm sure that if you produce a patch that makes the script a bit smarter, the MySQL maintainers would be glad to incorporate it (provided that it doesn't break anything, of course). Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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: Please can this newsgroup be added to the demon newsgroups
At 08:47 01/02/2001 +, Stephen Livesey wrote: I used to be subscribed to the ISP 'Globalnet'. I have now moved to the ISP 'Demon'. I can no longer obtain this newsgroup, I rang Demon and they informed me that the newsgroup had to be submitted to them! Please could someone who knows how, submit this newsgroup to Demon. newsgroups can be submitted to Demon by emailing [EMAIL PROTECTED] and the [EMAIL PROTECTED], indicating which newsgroup you would like to add. That's how I did it in the Netherlands. Frank - 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 got signal 11 every 10 minutes
"Matis, Jan" wrote : Hallo, I have small problem with my sql (again :) version:3.23.32 linux: SuSE 6.2 kernel: 2.2.16, 2.2.18, 2.4.1 lib: libc-2.1.2-31 (suse) compiled: gcc-2.95.2, egcs 2.7.2.3 compilation parameters: --prefix=/opt/mysql ( --without-debug --enable-assembler) memory: 1GB processor: 2* PIII 550Mhz ps uax | grep mysqld | wc -l : between 100 and 600 (really :) this machine is db backend for one wide used portal ( 3 web machines with apache and php 4.0.4pl1 with patched persistent connections) I tryed all combinations of this but in my db.err is really often mysqld got signal 11. Does anybody have an idea what can I do ? is it possible that this is caused by bad written php scripts ? (because I'm not developer but I know how our developers work :) if yes where in php scripts should I search a bug ? Jan Matis Hi Jan, If you check this mailing list archive, you will see that there are other reports of "signal 11" problems either on FreeBSD or Linux. I posted such a message myself on Jan 18th and I am still getting this kind of problem since then. It may run several days without problem or crash 3 times within 2 hours. I did not post anything again since I could not set up a reproducible test case. I really think the problem is with MySQL not your PHP frontend. I use MySQL with 2 web front-ends coded in Perl (mod_perl) and this problem appeared when I switched the backend from miniSQL to MySQL (going back to miniSQL is not an option since it has its own limitations). My configuration is close to yours (Linux RedHat 6.2, 2.2.14 kernel; PIII-733, 2Gb RAM) and MySQL load similar (between 300 and 500 persistent connections, about 300 queries/s). Hope this helps -- Joseph Bueno NetClub/Trader.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: To thread or not to thread this is the question ..........
On Wed, Jan 31, 2001 at 09:14:23PM +0100, Marcello Giovagnoli wrote: Hi, I have a problem with mysql 3.23.30 (binary distribution) and Slackware 7. Runnining different programs that access to database, the numbers of mysqld grow up. But when a single program exit, the number of mysqld processes should decrease by one. This works on RedHat 7.0 with the same mySQL distribution, but on Slackware 7 the number of mysqld never goes down, and they keep the maximum memory used in the last big query. So I tried to compile the last source distribution 3.23.32 on Slackware 7, but I got the same thing. I know that the mysqld should be threads not processes, and the memory used should be shared with all running mysqld, but something does not work properly. Do you think that the version of libpthread-0.8.so on Slackware 7 could be the cause ? (RedHat 7.0 has the libpthread-0.9.so). I cannot upgrade the OS now, and I think that is not a nice idea moving on the fly libpthread-0.9.so from RedHat to Slackware (the system is up and there are 102 users connected !!!). Could someone help me ? I'd suggest using a statically linked binary from the MySQL web site. The fact that it's statically linked means that you don't have to worry about other libraries that may or may not be buggy on your system. It sounds like you've done that, but if that's the case you should see the same behavior on both systems. Are the MySQL configuration files the same on both machines? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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: decode() with wrong password?
On Thu, Feb 01, 2001 at 04:19:06PM +0800, msquared wrote: What happens if you pass decode() the wrong password? Does it fail to decode? Does it simply return scrambled data? Try it and see. :-) -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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 got signal 11 every 10 minutes
On Thu, Feb 01, 2001 at 09:14:36AM +0100, Matis, Jan wrote: Hallo, I have small problem with my sql (again :) version:3.23.32 linux: SuSE 6.2 kernel: 2.2.16, 2.2.18, 2.4.1 lib: libc-2.1.2-31 (suse) compiled: gcc-2.95.2, egcs 2.7.2.3 compilation parameters: --prefix=/opt/mysql ( --without-debug --enable-assembler) memory: 1GB processor: 2* PIII 550Mhz ps uax | grep mysqld | wc -l : between 100 and 600 (really :) this machine is db backend for one wide used portal ( 3 web machines with apache and php 4.0.4pl1 with patched persistent connections) I tryed all combinations of this but in my db.err is really often mysqld got signal 11. Does anybody have an idea what can I do ? is it possible that this is caused by bad written php scripts ? (because I'm not developer but I know how our developers work :) if yes where in php scripts should I search a bug ? Have you tried using the binary tarball from the MySQL web site? http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.32-pc-linux-gnu-i686.tar.gz Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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
cant connect to localhost
HI all I can connect to Mysql server but cannnot connect to localhost(when no other application is running on localhost) please let me know if anybody has any solution Thanks shantanu - 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
Solaris SPARC installation
Hi all, I have installed MySQL 3.22.26a on a Solaris SPARC machine. When I try to run mysql_install_db I get the following message: - Creating db table Creating host table Creating user table Creating func table Creating tables_priv table Creating columns_priv table ld.so.1: /usr/local/mysql/libexec/mysqld: fatal: libstdc++.so.2.10.0: open failed: No such file or directory Killed Installation of grant tables failed! -- libstdc++.so.2.10.0 is in /usr/local/lib on my machine. Is this problem familiar to anyone? Thanks in advance! David -- david birchfield http://music.columbia.edu/~dab http://mojobisquits.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: Solaris SPARC installation
I do have libstdc++.so.2.10 already - so how do I set LD_LIBRARY_PATH? Thanks so much! David On Thu, 1 Feb 2001, Quentin Bennett wrote: Hi, Do you have libstdc++.so.2.10.0 somewhere on your system. If not, you'll need to get it, if so you'll need to set LD_LIBRARY_PATH to point to the directory in which is resides Hope this helps Regards Quentin -Original Message- From: David Birchfield [mailto:[EMAIL PROTECTED]] Sent: Thursday, 1 February 2001 13:34 To: [EMAIL PROTECTED] Subject: Solaris SPARC installation Hi all, I have installed MySQL 3.22.26a on a Solaris SPARC machine. When I try to run mysql_install_db I get the following message: - Creating db table Creating host table Creating user table Creating func table Creating tables_priv table Creating columns_priv table ld.so.1: /usr/local/mysql/libexec/mysqld: fatal: libstdc++.so.2.10.0: open failed: No such file or directory Killed Installation of grant tables failed! -- libstdc++.so.2.10.0 is in /usr/local/lib on my machine. Is this problem familiar to anyone? Thanks in advance! David -- david birchfield http://music.columbia.edu/~dab http://mojobisquits.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
Default users privileges
Hello, I'm new in this MySQL list. I only want to know what are the default privileges that are required, so that a normal user (wihtout any special priv.) can acces only to his DB, create tables, manage, insert, ..., his tables. I have try some differents config, but never have reach the right privs. Please, detail me also how and where (/MySQL tables) to create this default user, and the strict needed privs... Thanks very much. (Sorry for my bad english, i'm french, and it's difficult to find GOOD french docum. about MySQL) Best regards Jang - 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: Starting server on Sun Solaris
Thanks for your help - of course it was as simple as . Best to all, David On Thu, 1 Feb 2001, Quentin Bennett wrote: Hi, When you say 'hangs', what do you mean? Does CTRL-C work? Does the server have to be killed with kill -9? Are you running the program in the background? # bin/safe_mysqld If so, can mysql CLI connect to the running server? Regards quentin -Original Message- From: David Birchfield [mailto:[EMAIL PROTECTED]] Sent: Thursday, 1 February 2001 15:57 To: [EMAIL PROTECTED] Subject: Starting server on Sun Solaris Hi all, I have completed the installation of MySQL on Solaris 8, but when I run safe_mysqld the machine just hangs after giving the prompt: "Starting mysqld daemon with databases from /usr/local/mysql/var" it seems to go ahead and write /tmp/mysql.sock but stalls after that. thanks for any troubleshooting help! Best, David -- david birchfield http://music.columbia.edu/~dab http://mojobisquits.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 - but how?
Connecting to the tables in MySQL works fine. For example I can connect to the MySQL tables using MS Access. I would like to know if it is possible to connect to the tables of another database from MySQL. So instead of going from MS Access to MySQL I would go from MySQL to an AS400. Do I somehow use the command CONNECT [] to change the database? -Original Message- From: Scott Baker To: John Halladay; MySQL List (E-mail) Sent: 1/31/2001 2:09 PM Subject: Re: MyODBC - but how? You just create a DSN in the control panel, and tell your ODBC compliant software to use that data source. At 11:46 AM 1/31/2001 -0700, John Halladay wrote: I have just installed MyODBC on my machine (Windows ME) and everything is working fine, but I've looked through the manual and I can't find anything showing commands on how to connect to other databases. Can someone point me in the right direction? Thanks. John Halladay - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] "Children today are tyrants. They contradict their parents, gobble their food, and tyrannize their teachers." - Socrates - 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
Win mysqlc client anomaly - 2nd request
Does anyone know why the Windows version of mysqlc (the command line client with READLINE support) doesn't support the SOURCE command? Thanks, Mark Chalkley - 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
myisamchk on large tables fails
I am running MySQL 3.23.32 on Linux 2.2.16 with large file support. Large tables (tens of GB) work fine. mysqladmin variables shows large file support is enabled. The problem I am having showed up when I loaded a bunch of data into a simple non-indexed table and then tried to do the following to build the indexes: (NOTE: the reason I do it this way is to hopefully increase speed since I know ALTER TABLE makes a complete copy of the table and this table is over 8GB) mysqladmin flush-tables cd ~mysql/Database/ mv table.MYD table.MYD.saved SQL truncate table; SQL ALTER TABLE table ADD PRIMARY KEY (field1, field2); SQL ALTER TABLE table ADD INDEX indexname (field2); mysqladmin flush-tables mv table.MYD.saved table.MYD myisamchk -t /db/ -r -q -O sort_buffer_size=512M table.MYI The output/error I get is: - check key delete-chain - check record delete-chain - recovering (with sort) MyISAM-table 'RawMatch.MYI' Data records: 201326371 - Fixing index 1 myisamchk: Error writing file '/db/STAHOIjf' (Errcode: 27) myisamchk: error: 27 when fixing table MyISAM-table 'RawMatch.MYI' is not fixed because of errors Try fixing it by using the --safe-recover (-o) option I looked up error 27 using the perror tool and got: Error code 27: File too large Now, this filesystem definately has large file support since there are already files over 2GB on it that work. It also has plenty of free space. I made sure to direct the temporary files to a partition with space. So my question is, why is this happening? How can I fix it? I haven't tried safe-recover yet as I get the impression it would take a LONG time to complete, and although the documentation says it uses less disk space, I don't know if it would help. I am now just going to do the alter table on the full database, which will mean it makes a full copy, inefficient, but hopefully it will work. But I would like to know what causes this error and what I can do to fix it. Are there other good ways of importing lots of data into a table and then building the index later? Thanks, Chris PGP signature
Re: Queries upon queries
mySQL currently does not support stored queries or views, though views are planned in a future version of mySQL according to http://www.mysql.com/doc/T/O/TODO.html. You can achieve a good speed increase using mySQL as a back end to Access. The amount of performance improvement will depend greatly on good use of indexes. Be sure that anything included in a WHERE clause in an Access linked table is an index in mySQL. All tables should have primary keys and you'll find that form interfaces work better if all tables also include a TIMESTAMP(14) column. We've had very good success with porting Access applications to a mySQL backend here simply by uploading the tables into the mySQL server and then re-linking them as ODBC linked tables in Access. [EMAIL PROTECTED] wrote: We're looking at moving a web-based application currently built with Microsoft Access and Cold Fusion to a real database platform. I've only just started poking around mySQL, so I'm not really up on its capabilities. One of the things this application relies on fairly heavily is stored queries (aka stored procedures and/or views, depending on what platform you're coming from). There are sometimes five or six layers of SQL, with one query using other queries for their data, between the tables and what the user eventually sees. Poking around the documentation, it appears that mySQL doesn't support that sort of thing. Do I have that right, or am I missing something important? Even if I can't get deeply layered queries with mySQL, is there a relatively painless way of building them with some other tool (say, php or perl and the appropriate modules)? Am I likely to get a significant boost to performance if I keep Access in the middle for queries but move the tables to mySQL? - 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: Database/table encryption
msquared wrote: I'm working for a company that has a paranoid client, and the client wants their database to be 'secure'. By 'secure' they mean that even if someone gains root access on the server, the data in the database can't be compromised (obtained). I can think of a couple of ways to do this, but I don't know if they're practical. The first is to have MySQL store the tables and such in an encrypted fashion, at the file layer. Can anyone else offer any alternative suggestions, or some guidance? Most standard way is prorably having encrypted filesystems support in kernel (http://www.linuxi.org) and then having MySQL databases on it. I do not believe into too big security when intruder already have root but encryption will anyway help. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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: Once again ... row to column conversion
On Wed, Jan 31, 2001 at 08:50:44PM +0100, leo.putz wrote : Sorry for having to post the same problem a second time - but by now I'm really at a loss. Is there really no one out there to give me a hint? I need the output of a query result (all query information is in one row) in one column (!). So, e.g., if you have all temperature lows in one row, how can I retrieve the data in form of one column? How about CONCAT'enating all ? SELECT CONCAT( id, ' ', temp1, ' ', temp2) as allinone FROM Temp WHERE php meets zimt m. -- Markus Fischer, http://josefine.ben.tuwien.ac.at/~mfischer/ EMail: [EMAIL PROTECTED] PGP Public Key: http://josefine.ben.tuwien.ac.at/~mfischer/C2272BD0.asc PGP Fingerprint: D3B0 DD4F E12B F911 3CE1 C2B5 D674 B445 C227 2BD0 - 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: Increasing number of processes
On Wed, Jan 31, 2001 at 02:32:23PM -0800, Chuck Carson wrote: I need to run more mysql processes than the default of 3. Where is this configured? MySQL runs as a single process but is multi-threaded. It dynamically spawns new threads for incoming connections. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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 - JSP - Please help - URGENT
Connection myConn = DriverManager.getConnection("jdbc:mysql:///test_db1?user=Usernamepassword=pas sword"); Try with: Connection myConn = DriverManager.getConnection("jdbc:mysql://localhost/test_db1,"user","passwor d"); === Saludos, Enric Badia SONRIE, LAS COSAS NO OCURREN POR CASUALIDAD. - S O N R I Eweb : http://www.sonrie.com Pompeyo, 4e-mail: [EMAIL PROTECTED] 25006 Lleida Tel : +34 973 725 093 Spain Fax : +34 973 725 281 - - 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 few queries about optimising MySQL variables
On Wed, Jan 31, 2001 at 09:12:05AM +, Basil Hussain wrote: I think I understand this now. The table_cache is the maximum number of tables MySQL can keep open all the time. If your table_cache is lower than the actual number of tables in use (in my case 64 versus 70), then when a table that is not already open needs to be used, MySQL must open it, and so increments the Opened_tables status variable. In an ideal world, Opened_tables would be nil (or very low), as MySQL would already have all the tables open, yes? Yes. Queries that require a full table scan (those which don't or can't use indexes). "Sequential scans" can mean "full table scans". So, basically, a large record_buffer is only useful if your queries operate in a non-efficient fashion by not using indexes? I try to optimise all of my queries, and I'm pretty sure that reducing it to something like 4Mb would be alright. Basically, yes. But there are cases in which a full table scan is the fastest way to do something, and MySQL may decide to do that. You didn't mention the key_buffer. If configured well, you can get a great performance boost from it. My key_buffer is currently at 128Mb, but I'm considering upping that to 192Mb or maybe even 256Mb. Probably the former, as I don't have tables with hundereds of thousands of records to contend with. Sounds like you've got a good understanding of what's going on now. Good luck. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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
can't build mysql under solaris 7
Trying to build mysql-3.23.32 under solaris 7 with gcc version 2.95.2 19991024 (release) got error message : gcc -DDEFAULT_CHARSET_HOME=\"/usr/local\" -DDATADIR=\"/usr/local/var\" -DSHAREDIR=\"/usr/local/share/mysql\" -DUNDEF_THREADS_HACK -I./../include -I../include -I ./.. -I.. -I.. -O6 -DDBUG_OFF -DHAVE_CURSES_H -I/export/home/iav/mysql-3.23.32/include -DHAVE_RWLOCK_T -c libmysql.c -fPIC -DPIC -o .libs/libmysql.lo In file included from ../include/global.h:151, from libmysql.c:23: /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/include/math.h:5: math.h: No such file or directory make[2]: *** [libmysql.lo] Error 1 what does it mean? What is than math.h, it cann't find? I ried to find it myself - and fail: # find / -name math.h /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/include/math.h /export/home/iav/mysql-3.23.32/mit-pthreads/include/math.h What I do incorrect? best regards, Igor - 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
Documentation bug on use of '' in mysql.user.host?
Description: After U/G to 3.23.32 from 3.22.25 we can't make any inbound TCP/IP connections if the mysql.user.host field is blank. UNIX socket connections still work. The documentation says that '' is the same as '%', but it doesn't seem to be true. How-To-Repeat: Fix: Submitter-Id: submitter ID Originator: Organization: Community Internet plc MySQL support: none Synopsis: Documentation bug on use of '' in mysql.user.host? Severity: non-critical Priority: medium Category: mysql Class: doc-bug Release: mysql-3.23.32 (Source distribution) Server: /usr/local/bin/mysqladmin Ver 7.11 Distrib 3.22.25, for dec-osf4.0e on alphaev56 TCX Datakonsult AB, by Monty Server version 3.23.32 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 1 hour 55 min 25 sec Threads: 42 Questions: 54078 Slow queries: 17 Opens: 603 Flush tables: 1 Open tables: 63 Environment: System: OSF1 alpha02.community.net.uk V4.0 1229 alpha Machine: alpha Some paths: /usr/local/bin/perl /usr/bin/make /usr/gnu/bin/gmake /usr/gnu/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/gnu/lib/gcc-lib/alpha-dec-osf4.0f/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='cc -pthread -std1' CFLAGS='' CXX='cxx -pthread -O' CXXFLAGS='' LDFLAGS='' LIBC: lrwxr-xr-x 1 root system17 Jun 25 1999 /lib/libc.a - ../ccs/lib/libc.a lrwxr-xr-x 1 root system17 Jun 25 1999 /usr/lib/libc.a - ../ccs/lib/libc.a Configure command: ./configure '--with-named-thread-libs=-lpthread -lmach -lexc -lc' --prefix=/usr/local/mysql --localstatedir=/mysql Perl: This is perl, version 5.004_04 built for alpha-dec_osf - 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 security?
msquared a crit : Perhaps you want to distribute a CD full of databases, and people buy access to specific databases. access = password IMHO, this method can't protect the content of the CD. Hace a closer look : - you have read acces to the CD (files-level read access), but your MySQL server asks for a password when you want to read a particular table. - so, copy the content of the CD to hard-disk (included privs database) - edit manually (vi -b) the passwords table, replace the existing encrypted password with one you know the clear text - use MySQL with the table stored on the hard-disk - you are prompted for a password, enter yours - you have access to the CD content without the original password ( you have just win some maps of Australia :) I think it would work Nicob - 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 got signal 11 every 10 minutes
Have you tried using the binary tarball from the MySQL web site? http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.32-pc-linux-gnu-i686.ta r.gz Jeremy no I didn't ...so I changed it now and we will see on afternoon :) Jan - 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
CASE..END not working in ORDER BY clause?
hi there! it seems logical to me that using CASE...END in an ORDER BY clause ought to work. i can set up a CASE statement in a SELECT: SELECT CASE test.ID WHERE 1 THEN 2 WHERE 2 THEN 1 END AS c and i get the expected output. however, if i then try to move the whole case statement into the clause (ORDER BY CASE test.ID...END), then mysql seems to completely ignore the CASE...END instead; i.e. the table is sorted as it would be without the CASE...END (if i do ORDER BY CASE test.ID...END, test.name - then it will simply be ordered by test.name). additionally, if i leave the SELECT CASE...END AS c and then try to ORDER BY c, mysql complains that column c is not known. any ideas on what i'm missing here? this is using 3.23.32, compiled today. it did the same thing with a .27-gamma release. thanks. -damon - 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 got signal 11 every 10 minutes
Now I can say I tryed http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.32-pc-linux-gnu-i686.ta r.gz too and it dind't helped mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died Attemping backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong Bogus stack limit or frame pointer, aborting backtrace Number of processes running now: 0 Jan - 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
Incorrect data returned by REGEXP or RLIKE
I have been running the 'menagerie' tutorial from the mySQL manual and sure enough SELECT * FROM pet WHERE name REGEXP "[wW]"; returns Claws, Bowser and Whistler. However, when I run SELECT * FROM pet WHERE name REGEXP "[w]"; (or [W]) I still get the same results. Is there something I need to set to make the expression case sensitive? - 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: Newbie question
On Thu, Feb 01, 2001 at 02:25:15PM +1000, Peter Likidis wrote: I hope this hasn't been asked before but I have asked in multiple NGs etc and no one seems to know how to answer it. I have gone through the instructions on setting up MYSQL on the server (MacOS X). The problem is there is no socket. I have no idea what I did wrong. I cannot find a socket file anywhere so I'm assuming one was never created. I have set the /tmp directory for writing so it can be created. But alas still doesn't help. So how do I create /tmp/mysqld.sock??? Is the MySQL server running? It will create the socket when it starts. If it IS running, it may have created it in a place you're not expecting to find it. You way want to run a `find' and figure out where it's at, then. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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
myODBC question
Hi there, A DB newbie question - can I use MS Access for remote mySQL databases using myODBC?? Thanks.
Newbie question
I hope this hasn't been asked before but I have asked in multiple NGs etc and no one seems to know how to answer it. I have gone through the instructions on setting up MYSQL on the server (MacOS X). The problem is there is no socket. I have no idea what I did wrong. I cannot find a socket file anywhere so I'm assuming one was never created. I have set the /tmp directory for writing so it can be created. But alas still doesn't help. So how do I create /tmp/mysqld.sock??? - 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: wait_timeout? More Info.
Primarily the database serves the web server so it is always the same host. The database may vary, but some more than others. I feel confident that some path through an ASP either crashes or the connection close command is never reached or does not exist. However, I would think that the timeout would still kill those they are sleeping... for days. BTW, I am running 2.23.32 on Win2K. I have been trying to come up with an easy way to know which ASP has the error in it. Only thing I can think of is to create dozens of usernames and use a different one in each file ick... that will take some time. [EMAIL PROTECTED] - Original Message - From: "Jeremy D. Zawodny" [EMAIL PROTECTED] To: "Meyer, Patrick" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 2:48 AM Subject: Re: wait_timeout? On Tue, Jan 30, 2001 at 12:26:34PM -0600, Meyer, Patrick wrote: I am slowly gaining connections to the database that just sleep. I know these can arise from not closing the database. I am accessing it via MyODBC from Active Server Pages. However, I set wait_timeout to 3600... I have some that have been there for days... just sleeping. Why doesn't MySQL disconnect them from the timeout? Maybe I just don't understand wait_timeout. That's odd. I haven't had the need to use wait_timeout, so I can't say what you should expect. But I'd expect that it should work as documented. Do they appear to have anything particular in common? Same host/user/db? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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 time problems in Access
Actually to ensure updateable tables in MS Access you need a TIMESTAMP(14) and an AUTO_INCREMENT column. Pat... [EMAIL PROTECTED] - Original Message - From: "Scott Baker" [EMAIL PROTECTED] To: "Gregory King" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 31, 2001 11:43 AM Subject: Re: myODBC time problems in Access I'm trying to remember... yes I did have that problem. It's fixed now. I think you just need to have a primary key that is auto_incremented and the newest MyODBC. At 06:49 PM 1/30/2001 -0800, Gregory King wrote: Im trying to use myodbc to enter some data through MS access. The problem is, when I link to the table it shows the data in my data formatted fields all messed up. The data in the mysql table is fine, it is something the odbc driver or access is doing. I read on the Egroup that Scott Baker was having a simular problem in September, but I didnt see any responses to his request for help. - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] "Children today are tyrants. They contradict their parents, gobble their food, and tyrannize their teachers." - Socrates - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: myisamchk on large tables fails
You state that the temporary files are on a separate partition. Does the filesystem on this partition support large files? Chris Black wrote: I am running MySQL 3.23.32 on Linux 2.2.16 with large file support. Large tables (tens of GB) work fine. mysqladmin variables shows large file support is enabled. The problem I am having showed up when I loaded a bunch of data into a simple non-indexed table and then tried to do the following to build the indexes: (NOTE: the reason I do it this way is to hopefully increase speed since I know ALTER TABLE makes a complete copy of the table and this table is over 8GB) mysqladmin flush-tables cd ~mysql/Database/ mv table.MYD table.MYD.saved SQL truncate table; SQL ALTER TABLE table ADD PRIMARY KEY (field1, field2); SQL ALTER TABLE table ADD INDEX indexname (field2); mysqladmin flush-tables mv table.MYD.saved table.MYD myisamchk -t /db/ -r -q -O sort_buffer_size=512M table.MYI The output/error I get is: - check key delete-chain - check record delete-chain - recovering (with sort) MyISAM-table 'RawMatch.MYI' Data records: 201326371 - Fixing index 1 myisamchk: Error writing file '/db/STAHOIjf' (Errcode: 27) myisamchk: error: 27 when fixing table MyISAM-table 'RawMatch.MYI' is not fixed because of errors Try fixing it by using the --safe-recover (-o) option I looked up error 27 using the perror tool and got: Error code 27: File too large Now, this filesystem definately has large file support since there are already files over 2GB on it that work. It also has plenty of free space. I made sure to direct the temporary files to a partition with space. So my question is, why is this happening? How can I fix it? I haven't tried safe-recover yet as I get the impression it would take a LONG time to complete, and although the documentation says it uses less disk space, I don't know if it would help. I am now just going to do the alter table on the full database, which will mean it makes a full copy, inefficient, but hopefully it will work. But I would like to know what causes this error and what I can do to fix it. Are there other good ways of importing lots of data into a table and then building the index later? Thanks, Chris Part 1.2Type: application/pgp-signature - 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
Idea: Automated server tuning?
Hi all, In the light of my recent experiences with tuning my MySQL server, I had a few ideas about how getting optimum performance from your MySQL server could be made a little easier for everyone. My idea is to have some kind of facility to 'auto-tune' the server configuration variables for you. Although tuning manually seems to be more trial-and-error than deduction and formulation, I'm sure that it's possible to work out rules for what needs to be configured and how from information that is usually readily available about the environment that the server is running in. Here are some examples of what I mean: 1. The key_buffer_size variable could probably be fairly accurately set according to available system memory, sizes of indexes on current tables and by analysing EXPLAIN output from common SELECT queries from logs. 2. Parameters that are very OS-specific, such as flush_time for Win9x systems and thread_concurrency on Solaris. 3. Things like tmp_table_size could be set according to available system memory and answers from the user about what kind of disk subsystem they're using (maybe not even this - a simple disk benchmark may provide useful info here). These are just initial thoughts, so I could be wrong, but I'm sure there's a grain of sense in there somewhere. What I envisage is something that could operate in either (or maybe both) of two ways. Overall it would be some kind of program that will grab information about the system (i.e. CPU type, RAM, disk subsystem, etc.), status and variable information from MySQL and recent logs it is given access to - maybe even a few answers from the user about things it can't deduce on it's own. It could produce a report about what things are most significant about your usage and environment and some recommendations for configuration settings (maybe even implement them for the user, although that may be a bit *too* automated). It might either be something that you run on a one-off basis, or something that you run persistently over a period of time that would record information it needs at regular intervals in order to get a 'bigger picture' and make more informed recommendations. I'd like to know what people think - whether it's just crazy and would never be feasible or if it could genuinely be something possible and something useful. If it only inspires the MySQL developers to contemplate something like this for a future version of MySQL, then that would great. But otherwise, I like to think that someday I might be able to accomplish it, given some more experience and the time to research everything (and of course, learn some C/C++). Regards, Basil Hussain ([EMAIL PROTECTED]) - 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 script
If you are installing from a binary release that you created, and need to fix save_mysqld after each installation, then you should complain to the person that created the binary release. Or did I miss something? Quentin Bennett wrote: Hi, Each time I install mysql from a binary release that I have created, I have to modify safe_mysqld so that it can be called from mysql.server. This is because safe_mysqld checks to see if it knows what is going on before checking the command line args to see where things should be. Shouldn't this be fixed. so that mysql.server can call safe_mysqld 'out of the box'? Regards Quentin Bennett Transport Systems Division Infinity Solutions Phone: + 64 9 358 9720 Fax : + 64 9 309 4142 mailto:[EMAIL PROTECTED] http://www.infinity.co.nz - 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
Slackware AND mySQL 3.23.32 memory problems ....
hi! "Marcello" == Marcello Giovagnoli [EMAIL PROTECTED] writes: Marcello Hi, Marcello I'm sorry, for my previus question "To thread or not to thread " Marcello but now all it's OK. :) Marcello Looking at /etc/my.cnf, i could see two variables: Marcello set-variable= thread_cache=8 Marcello set-variable= thread_concurrency=8 # Try number of CPU's*2 Marcello this should set the edge to the maximum threads up to 8 and the mysqld Marcello running daemons are, at least, 8 !(is'nt it ?) Yes. Marcello And the process size, or thread size, decrease when the program goes down Marcello with 3.23.32. Marcello Regards Marcello marcello Regards, Monty - 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: Virtual memory exhausted making mysqlgui
Petras Virzintas writes: Hi, I'm trying to make mysqlgui on Linux 6.x. I have the following problem and any advice will be welcome: g++ -O3 -g -pipe -fforce-mem -fforce-addr -I. -I../mysql++-1.7.8/sqlplusint -I../mysql-3.23.26/include -c do_sql.cc do_sql.cc: In function `static void Sinisa_je_blesav::table_callback(class Sinisa_je_blesav *, void *)': do_sql.cc:542: virtual memory exhausted cpp: output pipe has been closed make: *** [do_sql.o] Error 1 TIA Petras Hi! Kick out -pipe out of compile options. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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
Problem with update logging under Solaris
I am running MySQL 3.22.32 on a sun enterprise server, but I am having problems with update logging. When update logging is specified in the /etc/my.cnf file and the MySQl process restarted logging will commence but will stop after a few hours (the number of hours is variable!). Connecting to the MySQL server and doing a 'show variables' shows that update logging is switched on. However no logfile is written even if a specific flush-logs comand is issued. There is a script regularly rotating the logfile (every 5 minutes) for replication purposes but no other log rotation happenening. There is no filespace issue (the logfile is being written to an 80 GB drive that it only 28% full) nor is there a permissions problem (after all the logfile is written when the server is started). Restarting the MySQL process will restart logging but it dies after a few hours once again. Has anyone out there had this problem or better yet know how to avoid it??? Unfortunately upgrading to MySQL 3.23 is NOT an option. Thanks in advance Neil - 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: select-Problem
Sir, Joe Celko's 'SQL For Smarties' has two chapters devoted to tree problems. After a quick look in the book, it appears to me that you can use one of his algorithms if you restructure your table and adapt his SQL to the MySQL dialect. See the chapter on Nested Set Models. Bob Hall Hi, I have a recursive Problem. I have a Table with columns "id", "name" and "pid". E.g: name1 name11 name12 name121 name122 name13 name2 name21 In the Table it would look like: id, name, pid 1 name1 0 2 name11 1 3 name12 1 4 name121 3 5 name122 3 6 name13 1 7 name2 0 8 name21 7 Is there any select statement, which give me the path e.g to the id 5? I want to provide the 5 and will get the following: id5 (pid3) - id3 (pid1) - id1 (pid0) name122 - name12 - name1 Do you have any idea? Oliver -- [EMAIL PROTECTED] * [EMAIL PROTECTED] * [EMAIL PROTECTED] * [EMAIL PROTECTED] - 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 Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - 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: Very Urgent
1. Start the mysqld. 2. Make sure it is opening the socket in /var/lin/mysql 3. Make sure /var/lin/mysql is set mode 775 Balaji Nallathambi wrote: Iam Getting the error "Unable to Connect to Local MySql Server through socket 'var/lin/mysql/ mysql.sock" my Version For MySql is 3.22.32. What is Th solutin For this mail me asap adieu Balaji.N Get free email and a permanent address at http://www.netaddress.com/?N=1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL + htdig
There are some reserved words in new release. Read the manual. - Original Message - From: Paco Martinez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 3:39 PM Subject: MySQL + htdig Is there any problem with htdig and MySQL 3.23.??? My PC was executing "htdig htfuzzy, htmerge", etc and suddenly all indexes into tables MySQL were duplicated. For example, there is an index called "count" and another index was added with name "count_2". Is there any warning using "mysql" command ?? Thank you - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mySQL 3.23.32 memory optimization ....
Hi, firstly thanks for your answer, [EMAIL PROTECTED] works very very well ! We are doing a very hard work with mySQL , used as main database inside our ERP Oasi. (instead of DB2 or ORACLE). We have a performance problem with memory usage. the process accesses to database via ODBC (iodbc2-12+myodbc2.50.22) and all seems to be OK, except for the memory usage. We have a table with 1,5 millions of record that a client program needs to scan and the client process size grows up because it reserves memory to store rows. do_query(), inside execute.c calls mysql_store_result(), and in this way all the data is transefferd to the client. I tryed to uncomment the portion of the code above in execute.c having: . if (stmt_options.cursor_type == SQL_CURSOR_FORWARD_ONLY) stmt-result=mysql_use_result(stmt-dbc-mysql); else stmt-result=mysql_store_result(stmt-dbc-mysql); . and I have set the correct option before the SQLPrepare() statement: SQLSetStmtOption(vst-startHstmt,SQL_CURSOR_TYPE,SQL_CURSOR_FORWARD_ONLY); I don't need the scrolled cursor, so in this way the driver calls mysql_use_result saving a lot of memory. It works, but when I execute another query, building a different statement, with or without setting the statement option for the cursor type, (note that the code perform another SQLAllocStatement()), i got this error: --- SQL error : -1 line number: 107 SQL state : S1000 native error code : 2014 [TCX][MyODBC]Commands out of sync; You can't run this command now the query is: [select * from archcont where codcon = ?] archcont is another table, a little one. I know that the comment in execute.c says: /* We can't use USE_RESULT because SQLRowCount will fail in this case! */ but i don't need to use SQLRowCount when i set the cursor type as SQL_CURSOR_FORWARD_ONLY, of course. Anyway, if there is another method to save memory, please let me know how I can do it, without change my code (if it is possible). Regards marcello marcello giovagnoli Logical System s.r.l. Via Rocco Scotellaro 23 60035 JESI AN ITALY e-mail: [EMAIL PROTECTED] --- - 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
Serious MySQL internal deadlock
It seems that MySQL 3.23.32 has an internal deadlock problem, causing the database to stop responding. Situation: 6 processes (each on a different system) connect to a mysql database and insert various system data into a set of MyISAM tables. Each process uses the user 'logdaemon' which has insert privilege to the required tables. Data is extacted by php scripts using the user 'logreader', which has select privilege to the required tables. It happens at least once a day that MySQL stops responding. First I did assume that missing locks could cause the problem, so I modified all accesses to the database to use read and write locks on the required tables. This didn't help. If you look at the attached output of the 'show processlist' command the most obvious thing to see is that 2 IDs are in state 'System Lock' on the same table. Killing the threads doesn't help. The thread state changes to 'killed' but that's it. Regular shutdown of MySQL is impossible, all MySQL PIDs must be sent the TERM signal. Note that even as MySQL is compiled with BDB support there are only MyISAM tables. All inserts are "regular" inserts, there is no 'insert delayed'. the amount of inserts/day of all tables of this database is about 1. The amount of selects is currently much lower (less than 1000/day). Thus concurrent inserts and selects to the same table may easily cause a denial of service condition. The only perhaps non-standard thing I did here was not to set a default database but to address the tables directly (db.table) which may be, ahem, not usual but still is a valid way to access a table. I'm going now to change this, i.e. all connecting processes will set the database and see if the problem persists. Nevertheless this is a somewhat bad situation that should be resolved as soon as possible. As a side effect of this problem I had the database first set to replicate in Robin Round manner between three systems. Unfortunately, when the above situation happens and MySQL must be killed, replication is killed for good, too, as the slave thread of the killed MySQL database will just loop in a 'waiting to reconnect after a failed read' state after MySQL restart. Thus the current replication setup is already that there's just two shadow databases for the master that handles all reads and writes. This leads to an additional thought: What happens to replication after a power outage or a system crash? Yes, I' using a ups but it can happen, that these things fail, causing a home made power outage. It wouldn't be too good if a non-standard shutdown of a slave would mean to restart replication from scratch. Andreas Steinmetz D.O.M. Datenverarbeitung GmbH Id UserHostdb Command TimeState Info 7 replicate 10.1.1.2NULLBinlog Dump 78339 Waiting for update NULL 9 replicate 10.1.1.6NULLBinlog Dump 78339 Waiting for update NULL 187 logdaemon 10.1.1.3NULLQuery 7015System lock LOCK TABLES syslog.pcp WRITE 188 logdaemon 10.1.1.7NULLQuery 6963Opening tables LOCK TABLES syslog.pcp WRI TE 189 logdaemon 10.1.1.6NULLQuery 6961Opening tables LOCK TABLES syslog.pcp WRI TE 190 logdaemon 10.1.1.4NULLQuery 7017System lock LOCK TABLES syslog.pcp WRITE 191 logdaemon 10.1.1.2NULLQuery 6961Opening tables LOCK TABLES syslog.pcp WRI TE 192 logdaemon localhost NULLQuery 6963Opening tables LOCK TABLES syslog.pcp WR ITE 246 logreader 10.1.1.3NULLQuery 6465Opening tables lock tables syslog.ipchain s read 247 logreader 10.1.1.3NULLQuery 6447Opening tables lock tables syslog.ipchain s read 248 logreader 10.1.1.3NULLQuery 6230Opening tables lock tables syslog.ipchain s read 249 logreader 10.1.1.3NULLQuery 5651Opening tables lock tables syslog.ipchain s read 250 logreader 10.1.1.3NULLQuery 5640Opening tables lock tables syslog.ipchain s read 251 logreader 10.1.1.3NULLQuery 4606Opening tables lock tables syslog.ipchain s read 252 logreader 10.1.1.3NULLQuery 4493Opening tables lock tables syslog.ipchain s read 253 logreader 10.1.1.3NULLQuery 3445Opening tables lock tables syslog.ipchain s read 254 logreader 10.1.1.3NULLQuery 3145Opening tables lock tables syslog.ipchain s read 255 logreader 10.1.1.3NULLQuery 2329Opening tables lock tables syslog.ipchain s read 256 logreader 10.1.1.3NULLQuery 1332Opening tables lock tables syslog.ipchain s read 257 logreader 10.1.1.3NULLQuery 1088Opening tables lock tables syslog.ipchain s read
Re: How can I do this ???
Yes that is true but what I want to get at is. Like I want to get all Childs of the Parents. But NOT the Parents. Meaning if the one with a Parent ID is the PARENT then the Others with his ID in the Parent_ID field is his children, And I want this to happen like create a Treeiew for Instance where all the Parents is shown and then all those under them occrding to the Parent ID. Well I short I am Using Delphi and want to link the tables master source with each other and if I look at it then then there is no data, If I run the select select * from People where PARENT_ID= OBJID I get no data. But this must be dynamic. Not a query at a time. I hope I can make sense for I dont understand mySelf but thanks for your time and help Johannes Rus wrote: According to your question it could be done as simple as select * from People where PARENT_ID = 1 or OBJID = 1 :) - Original Message - From: Johannes Pretorius [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 4:43 PM Subject: How can I do this ??? Hi there 0---0 Sorry for stupid Q but I have the following Table named People OBJID - int(11) not null auto_increment NAME - varchar(25) PARENT_ID - int(11) Now if my data is as follows OBJID | NAME | PARENT_ID --- 1None0 2 Other1 how can I get the Childs back (those who's Parent_ID is not 0), But Linked to a specific Parent ID !!. Like somehting like this select * from People where PARENT_ID = OBJID and OBJID = 1 I know the obove wont work but I kinda neet something with that logic. Thanks In advance for any help Johannes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
merging databases
What would be the best way to take two separate databases, and merge them together into a third database? From the discussions i've read, it seems that dumping them both, then importing them to this new database might be a way of doing it, but is a good way? will it work? Can you suggest a better way, or any problems with this way? Andrew. - 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: merging databases
If all tables name are unique, and if you can bear the downtime, just shut down the server and copy the files of one of the database to another database will do - Original Message - From: "Andrew Dennison" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 11:21 PM Subject: merging databases What would be the best way to take two separate databases, and merge them together into a third database? From the discussions i've read, it seems that dumping them both, then importing them to this new database might be a way of doing it, but is a good way? will it work? Can you suggest a better way, or any problems with this way? Andrew. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE:mySQL is winning
But you still have to buy the ORACLE software right? If the ORACLE database were free then I would be very interested Chris Web Engineer Chartway Federal Credit Union - Original Message - From: "Fowler, J.T." [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 10:17 AM Subject: RE:mySQL is winning My error - I had the [EMAIL PROTECTED] URL in my notepad not the correct ORACLE link For news about how to "FOR FREE" convert from mySQL to ORACLE: http://www.oracle.com/ip/deploy/database/featurestory/index.html?mysql.html My apologies for going brain dead. Thanks, J.T.Fowler 512-326-6371 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL is winning
So sprach Fowler, J.T. am Thu, Feb 01, 2001 at 09:17:13AM -0600: My error - I had the [EMAIL PROTECTED] URL in my notepad not the correct ORACLE link Well, I still don't get it - why should I want to shell out a huge amount of money? I mean, your post would fit a lot better, if this was a Oracle mailinglist Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die guenstige Art an Linux Distributionen zu kommen Uptime: 1 day 20 hours 13 minutes - 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: how to get the union of the values in a SET column ?
I was hoping that since each member of the SET really represents a number, that there would be some bitwise operation that would painlessly produce all the members of the SET that appear at least once. Sir, I apologize for taking so long to respond. I was moving some furniture this weekend and dropped a desk on my keyboard. No worries Bob. I've only just got back online myself (though my excuse is more hedonistic - was snowboarding). You are right about SETs, and I am blind. The obvious solution is the bitwise or. MySQL has a summary function called Bit_Or(). Unfortunately, it returns a decimal representation of the result, so you have to massage it a little. SELECT Bin(Bit_Or(column_name)) FROM your_table; Excellent. I actually tried the Bit_or and Bit_and() functions but must have screwed up on my binary conversion aaah! b/c the results I had didn't seem to make sense. The Bin() function is very handy. The bits are in reverse order; if your SET declaration includes a, b, c, and d, and you columns include all but b, you'll get 1101 from the SELECT statement. This is fine if you're going to process the bits in your client. But if you want to display the bits in MySQL in the same order as your SET declaration, you can use Reverse(Binary(Bin(Bit_Or(column_name which will give you 1011. Awesome. That's just the ticket. Thank you very much again, chas - 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.32 memory optimization ....
Hi Monty, Why do you need to retrieve so many rows to the client? Can't you use LIMIT to restrict the number of result rows? The point is that the program scans the entire table and process each row in a diffrent way, executing other queryes inside the main SQLFetch() loop. Someting like this: SQLExecute(hstmt1,query1) while(SQLFetchRow(hstmt1) == SQL_SUCCESS ) { ... ... SQLExecute(hstmt2,query2) while(SQLFetchRow(hstmt2) == SQL_SUCCESS ) { .. } }. Perhaps the code should be rewritten, to reflect the right way to write code that uses database, but in my source code i don't use ODBC directly, it is embedded, I have someting like this: dbSetKey(Db,"table1","column1,column2"); . dbSetValue("table1.column1", value); ... err=dbStart(Db,"table1") while(!err) { . . err=dbStart(Db,"table2") while(!err) { dbNext(Db,"table2"); } dbNext(Db,"table1"); } dbStart() build the right query with the where condition and order by using ODBC. For each running program I have one instance of mysqld connected to. There are up to 300 programs written in this way and they works, I can't modify them in a few time. Are you sure you close the statement before doing another ? The reason this happens is that mysql_free_result() is not called for the previous query and there is still on the connections data for the previous query. Executing mysql_free_result() will quickly discard all rows from the server so that you can issue a new command against it. Reading the manual :( It seems that i can do this ONLY using mysql_store_result(), because each mysqld instance can do only one query at a time, is it correct ? If yes, I need some way to reduce the client memory usage, processing big tables. I can implement something build a select with limit n1,2n re-run the query when SQLFetchRow() fails. I don't have notice how the other databases works in this cases. In my opinion the right way to work around this problem should be to use a temporary file to store results for the big tables, forcing this option with a parameter as SQL_BIG_TABLES=1, in this case mysql_store_result() can store the result in a file, i can issue the SQLFreeResult() and build another query. What do you think about ? Which version of MyODBC do you use? myodbc-2.50.22 If you have an very old MyODBC versions which includes an old mysqlclient lib this may explain your problems; Older mysql_free_result() versions didn't read the old result from the connections and because of this one would get the error message you got if one didn't read all rows from the result before calling mysql_query() again. Thanks, Monty marcello - 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: How can I do this ???
This works for me in access SELECT families.objid, families.name, families.parentid, families_1.objid, families_1.name, families_1.parentid FROM families LEFT JOIN families AS families_1 ON families.objid = families_1.parentid WHERE ((families.parentid)=0); -Original Message- From: Johannes Pretorius [SMTP:[EMAIL PROTECTED]] Sent: 01 February 2001 15:13 To: MySQL Subject: Re: How can I do this ??? Yes that is true but what I want to get at is. Like I want to get all Childs of the Parents. But NOT the Parents. Meaning if the one with a Parent ID is the PARENT then the Others with his ID in the Parent_ID field is his children, And I want this to happen like create a Treeiew for Instance where all the Parents is shown and then all those under them occrding to the Parent ID. Well I short I am Using Delphi and want to link the tables master source with each other and if I look at it then then there is no data, If I run the select select * from People where PARENT_ID= OBJID I get no data. But this must be dynamic. Not a query at a time. I hope I can make sense for I dont understand mySelf but thanks for your time and help Johannes Rus wrote: According to your question it could be done as simple as select * from People where PARENT_ID = 1 or OBJID = 1 :) - Original Message - From: Johannes Pretorius [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 4:43 PM Subject: How can I do this ??? Hi there 0---0 Sorry for stupid Q but I have the following Table named People OBJID - int(11) not null auto_increment NAME - varchar(25) PARENT_ID - int(11) Now if my data is as follows OBJID | NAME | PARENT_ID --- 1None0 2 Other1 how can I get the Childs back (those who's Parent_ID is not 0), But Linked to a specific Parent ID !!. Like somehting like this select * from People where PARENT_ID = OBJID and OBJID = 1 I know the obove wont work but I kinda neet something with that logic. Thanks In advance for any help Johannes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
API for c
Where can i get API for c?? I need API to use a gcc compiler in a freebsd OS!!! tkz!! []'s Jader
Re: [CGI] Gas Prices
By now you're probably thinking gasoline priced at about $1.49 is cheap. Me too! As it is now $1.58 for regular unleaded. Now that the oil Just an off topic observation. $1.58 is cheap. Here, (in the UK) our Gas price is $6 a gallon. (Yes, six US dollars a gallon). Its kinda annoying to hear people complaining about gas being $1.50 as "high" ;) Red - 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 is winning
"AS" == Alexander Skwar [EMAIL PROTECTED] writes: AS Well, I still don't get it - why should I want to shell out a huge AS amount of money? I mean, your post would fit a lot better, if AS this was a Oracle mailinglist The point, I beleive, is that Oracle finds MySQL such a threat to their business that they have to put out a migration kit to make it easy for people to switch to their product. It shows that the popularity of MySQL is being taken seriously by the majors. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - 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 text searches
Geoff Coffey wrote: I am new here... I am in the process of migrating a site built with FileMaker Pro to MySQL and PHP mostly because filemaker's web capabilities are too limiting. In one situation, we have a database of about 20,000 rows that contains two text columns. One is the full text of a resume and the other is the full text of a cover letter. I'm trying to decide how to enable searching from a web form. I've not actually tried it, but I suspect using "LIKE" will be lousy. In Sybase it certainly would be. I found a thread on this list discussing just this, and the suggestion was made that I create a few tables to store keywords and map them to record ids etc. My problem with this is it makes it impossible to do searches on a phrase. I think the users would often search for "Microsoft Word" for instance, and it would find every candidate that mentions "Microsoft" and "Word", but not necessarily together. But it would be acceptable to limit it to word searches if need be (filemaker doesn't support this now in a fast way anyway). Are there any other options than this? You can support phrases, using the keyword method you mention by first generating a list of all docs that have your words using they keyword method, you can then use LIKE '%Microsoft Word%' against the narrowed list of documents. - 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: How can I do this ???
Heres the minimal version just to list children SELECT families_1.name FROM families INNER JOIN families AS families_1 ON families.objid = families_1.parentid WHERE (((families.objid)=1) AND ((families.parentid)=0)); I dont actually use mySQL but am considering it as an option but this code should work on mySQL you might not need the AS keywords and you certainly don't need all the parenthesis but they shold do no harm. good luck -Original Message- From: Johannes Pretorius [SMTP:[EMAIL PROTECTED]] Sent: 01 February 2001 15:13 To: MySQL Subject:Re: How can I do this ??? Yes that is true but what I want to get at is. Like I want to get all Childs of the Parents. But NOT the Parents. Meaning if the one with a Parent ID is the PARENT then the Others with his ID in the Parent_ID field is his children, And I want this to happen like create a Treeiew for Instance where all the Parents is shown and then all those under them occrding to the Parent ID. Well I short I am Using Delphi and want to link the tables master source with each other and if I look at it then then there is no data, If I run the select select * from People where PARENT_ID= OBJID I get no data. But this must be dynamic. Not a query at a time. I hope I can make sense for I dont understand mySelf but thanks for your time and help Johannes Rus wrote: According to your question it could be done as simple as select * from People where PARENT_ID = 1 or OBJID = 1 :) - Original Message - From: Johannes Pretorius [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 4:43 PM Subject: How can I do this ??? Hi there 0---0 Sorry for stupid Q but I have the following Table named People OBJID - int(11) not null auto_increment NAME - varchar(25) PARENT_ID - int(11) Now if my data is as follows OBJID | NAME | PARENT_ID --- 1None0 2 Other1 how can I get the Childs back (those who's Parent_ID is not 0), But Linked to a specific Parent ID !!. Like somehting like this select * from People where PARENT_ID = OBJID and OBJID = 1 I know the obove wont work but I kinda neet something with that logic. Thanks In advance for any help Johannes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 - Filemaker Tip
Hi all, I just came across this little tid-bit of information today and thought I'd share it, seeing as it's potentially very useful to anyone trying to export records from MySQL and then import them into a 'repeating' field in Filemaker Pro. When importing a text file of single-field records, Filemaker considers the ASCII character 29 to be a repeating field seperator. So, you may wonder how you can export records terminated by ASCII-29 using MySQL... You can get ASCII-29 by using hexadecimal representation - it's simply 0x1d. So, to export a certain field like this, you simply do: SELECT field FROM table WHERE something = 'foo' INTO OUTFILE '/path/to/whatever.txt' LINES TERMINATED BY 0x1d Then just transfer it to your Mac/PC and import this text file into the repeating field of the record you desire. Et voila! Regards, Basil Hussain ([EMAIL PROTECTED]) - 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: Antwort: mySQL is winning
On Thu, Feb 01, 2001 at 04:21:15PM +0100, [EMAIL PROTECTED] wrote: On 01.02.2001 14:54:11 Fowler, J.T. wrote: Migration Kit for MySQL to Oracle on Linux Now Available. Moving just got easier with the new MySQL-to-Oracle Migration Workbench-the ideal migration software for developers who want to migrate open-source database on Linux to Oracle on Red Hat Linux 6.2. Hmm?? In how far is MySQL winning? Isn't that a sign that it's losing? I mean, if this were a Oracle-To-MySQL kit, I would understand you The announcement is an explicit indicator that Oracle has taken notice of the MySQL world, and felt a need to respond. - 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: How can I do this ???
thanks A lot. :).. Julian Strickland wrote: This works for me in access SELECT families.objid, families.name, families.parentid, families_1.objid, families_1.name, families_1.parentid FROM families LEFT JOIN families AS families_1 ON families.objid = families_1.parentid WHERE ((families.parentid)=0); -Original Message- From: Johannes Pretorius [SMTP:[EMAIL PROTECTED]] Sent: 01 February 2001 15:13 To: MySQL Subject: Re: How can I do this ??? Yes that is true but what I want to get at is. Like I want to get all Childs of the Parents. But NOT the Parents. Meaning if the one with a Parent ID is the PARENT then the Others with his ID in the Parent_ID field is his children, And I want this to happen like create a Treeiew for Instance where all the Parents is shown and then all those under them occrding to the Parent ID. Well I short I am Using Delphi and want to link the tables master source with each other and if I look at it then then there is no data, If I run the select select * from People where PARENT_ID= OBJID I get no data. But this must be dynamic. Not a query at a time. I hope I can make sense for I dont understand mySelf but thanks for your time and help Johannes Rus wrote: According to your question it could be done as simple as select * from People where PARENT_ID = 1 or OBJID = 1 :) - Original Message - From: Johannes Pretorius [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 4:43 PM Subject: How can I do this ??? Hi there 0---0 Sorry for stupid Q but I have the following Table named People OBJID - int(11) not null auto_increment NAME - varchar(25) PARENT_ID - int(11) Now if my data is as follows OBJID | NAME | PARENT_ID --- 1None0 2 Other1 how can I get the Childs back (those who's Parent_ID is not 0), But Linked to a specific Parent ID !!. Like somehting like this select * from People where PARENT_ID = OBJID and OBJID = 1 I know the obove wont work but I kinda neet something with that logic. Thanks In advance for any help Johannes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: Serious MySQL internal deadlock
On 01-Feb-2001 Sinisa Milivojevic wrote: HI! Most probably processes are waiting for the slave to get updated. To circumvent the problem, you should : - use our binary (if possible) - avoid LOCK TABLES, which truly is necessary only in some rare cases Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team Actually I did avoid using lock tables but got hit by this problem. Thus I tried with lock tables. Using supplied binaries is no choice as for certain reasons all systems involved are completely built from source. I can't really see a reason why a slave being updated should lock the master for good. Nevertheless there's just one programmable switch between the master and the slaves involved and the network speed is 200MBits/s (channel bonding) so this can't really be the reason for the problem. If I can do anything to help to sort this out I'll happily do so. Andreas Steinmetz D.O.M. Datenverarbeitung GmbH - 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: [CGI] Gas Prices
And i thought 72.9 Cents (Canadian) per litre was expensive :( Redvers Davies [EMAIL PROTECTED] on 02/01/2001 09:03:19 AM To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] (Ray Ray), [EMAIL PROTECTED] (mySQL Mailing List), [EMAIL PROTECTED] (Jeff Hunt), [EMAIL PROTECTED] (Ed Holmes), [EMAIL PROTECTED] (Chris Goehrig), [EMAIL PROTECTED] (CGI Mailing List), [EMAIL PROTECTED] (Bill Turay), [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] (bcc: Marko Sarunac/ISM-BC) Subject: Re: [CGI] Gas Prices By now you're probably thinking gasoline priced at about $1.49 is cheap. Me too! As it is now $1.58 for regular unleaded. Now that the oil Just an off topic observation. $1.58 is cheap. Here, (in the UK) our Gas price is $6 a gallon. (Yes, six US dollars a gallon). Its kinda annoying to hear people complaining about gas being $1.50 as "high" ;) Red - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
c and mysql
Where can i get an exemple of connection using c with mysql! for gcc with freebsd OS. tkz! []'s Jader
Not Urgent . Please Don't care. (Can't Connect to Mysql Server on 192.9.200.2 (10055))
Would you please offer me something please ? From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2 (10055)) Description: I am connecting from Visual Basic 6 to Mysql via ODBC DSN. When i made 94 sleeped connection after 94 can't connect to a server. It says : [TCX][MYODBC]Can't Connect to Mysql Server on 192.9.200.2 (10055) Is it fault of myodbc or mysql server? Is it normal. If there a maximum connection limit for process ? I think it is abnormal cause everyone is talking about 10.000 Web Hit. Is it cause from sleeped process list ? I increased maximum connection to 200 but it not works. I think it is not related with maximum connection . It is related with maximum process number. How-To-Repeat: Run this code on Microsoft Visual Basic 6 ENT Edition. For i = 1 To 200 Set Temp_Bag(i) = New ADODB.Connection Temp_Bag(i).Open "DSN=Avukatpro;UID=avukatpro;PWD=avukatpro" Next i It hangs 94 on Winnt. It hangs 60 on Win 95. It hangs 50 on Win98 SE. Fix: Any offer? What means 10055 ? I check-out documents. Can't see any recomend or definition for this error number. Additional Information : Host: 3.23.30-gamma ClientInfo: 3.23.6-alpha HostInfo: 192.9.200.2 via TCP/IP ProtoInfo: 10 I stopped on 93 process and got process list. It is attached. Synopsis: synopsis of the problem (one line) Submitter-Id: Yusuf Incekara Originator: Yusuf Incekara Organization: Avukatpro Limited Sirketi MySQL support: None Severity: Critical Priority: High Category: mysqld, ODBC Class: sw-bug,ODBC-bug Release: mysql-3.23.26-beta Exectutable: mysqld-nt and mysqld-opt Environment: PIII 700 MHZ Intel,256 MB RAM with WinNT4 , Same Problem on PIII MHZ Intel with 128 MB Ram System:WinNT4 with Service Pack 6a, Internet Explorer 5 Same problem on Windows 95 Osr 2 Same Problem on Windows 98 SE Compiler: ? Architecture: i686 +-+---+---+---+-+--+---+--+ | Id | User | Host | db| Command | Time | State | Info | +-+---+---+---+-+--+---+--+ | 1 | root | INCEKARA2 | mysql | Sleep | 1114 | | | | 189 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 190 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 191 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 192 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 193 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 194 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 195 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 196 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 197 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 198 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 199 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 200 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 201 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 202 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 203 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 204 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 205 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 206 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 207 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 208 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 209 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 210 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 211 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 212 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 213 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 214 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 215 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 216 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 217 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 218 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 |
Re: myODBC question
Speaking as one who tried working with such a connection, FORGET IT. While entering data, I might get all or half a record entered when the message arrives telling me the information cannot be posted, because another user was editing that record (which I could tell was simply NOT the case), and I had the option of either dropping my input, or put the whole record in the past buffer. Occasionally, I would get lucky and get a whole record entered and saved, but mostly, my datbase was getting filled with gaps. Get phpMyAdmin. It is far more reliable solution. On 1 Feb 2001, at 12:06, (Mr) Pekka Gaiser wrote: Hi there, A DB newbie question - can I use MS Access for remote mySQL databases using myODBC?? Thanks. John Jensen 520 Goshawk Court Bakersfield, CA 93309 - 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: [CGI] Gas Prices
I think I'd be buying one of those hybrid cars if I were you. They get something like 60 miles per gallon. I think I'd be riding my bike more too... Oh, and last I checked, gas here in Ohio is $1.28/gallon today. :) -Angela Redvers Davies wrote: By now you're probably thinking gasoline priced at about $1.49 is cheap. Me too! As it is now $1.58 for regular unleaded. Now that the oil Just an off topic observation. $1.58 is cheap. Here, (in the UK) our Gas price is $6 a gallon. (Yes, six US dollars a gallon). Its kinda annoying to hear people complaining about gas being $1.50 as "high" ;) Red - 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 -- Angela Curtis Innovative Business Consultants http://www.ibc2001.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 is winning
I have no problem with paying for good software or good services; that deserves payment. I just hate to pay for something, only to find it doesn't do what I need it to do, the warrantee is worthless, and getting tech support is like pulling teeth. Argh! Basic business practice should be taught in grade school, not reserved for MBA programs. On 1 Feb 2001, at 10:51, Christopher Bone wrote: But you still have to buy the ORACLE software right? If the ORACLE database were free then I would be very interested Chris Web Engineer Chartway Federal Credit Union - Original Message - From: "Fowler, J.T." [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 10:17 AM Subject: RE:mySQL is winning My error - I had the [EMAIL PROTECTED] URL in my notepad not the correct ORACLE link For news about how to "FOR FREE" convert from mySQL to ORACLE: http://www.oracle.com/ip/deploy/database/featurestory/index.html?mysql .htmlMy apologies for going brain dead. Thanks, J.T.Fowler 512-326-6371 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Jensen 520 Goshawk Court Bakersfield, CA 93309 - 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
Error running makefile
Hi Attempting to make nysql-3.23.32 on a DEC alpha Tru64 box. Keep getting error /install-dir/lib/mysql ( no such file or directory ). Anybody seen this before ? Thank You John Markunas - 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: c and mysql
In the manual. www.mysql.com On 01 Feb 2001 17:29:02 -0200, Jader Wallauer wrote: Where can i get an exemple of connection using c with mysql! for gcc with freebsd OS. tkz! []'s Jader - 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
Fw: [CGI] Gas Prices
- Original Message - From: "Ren Tegel" [EMAIL PROTECTED] To: "Redvers Davies" [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 7:17 PM Subject: Re: [CGI] Gas Prices This sure would be a reason for microsoft to distribute less cd's and more pre-installed os's due to 'increased distribution costs' :) ps... you send a cc to your address book... but also to the mysql mailing list.. now whole world knows your private contacts? regards rene - Original Message - From: "Redvers Davies" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: "Ray Ray" [EMAIL PROTECTED]; "mySQL Mailing List" [EMAIL PROTECTED]; "Jeff Hunt" [EMAIL PROTECTED]; "Ed Holmes" [EMAIL PROTECTED]; "Chris Goehrig" [EMAIL PROTECTED]; "CGI Mailing List" [EMAIL PROTECTED]; "Bill Turay" [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 6:03 PM Subject: Re: [CGI] Gas Prices By now you're probably thinking gasoline priced at about $1.49 is cheap. Me too! As it is now $1.58 for regular unleaded. Now that the oil Just an off topic observation. $1.58 is cheap. Here, (in the UK) our Gas price is $6 a gallon. (Yes, six US dollars a gallon). Its kinda annoying to hear people complaining about gas being $1.50 as "high" ;) Red - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: c and mysql
On Thu, Feb 01, 2001 at 05:29:02PM -0200, Jader Wallauer wrote: Where can i get an exemple of connection using c with mysql! for gcc with freebsd OS. tkz! []'s Jader 1) Any of the C clients in a MySQL source distribution: mysql, mysqladmin, mysqlshow, etc. 2) http://www.mysql.com/Downloads/Contrib/Examples/samp_db.tar.gz (the source distribution for the New Riders MySQL book) - 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 Balancing.
I have read on replication, just recently. What I could gather from the manual: The replication creates an exact mirror of a database on another server using a parent server to a daughter server method. Which brings up two issues: How long is the lag? How could I use this to load balance? My thoughts are: If the lag time is insignificant than I could use a php script to round-robin connect between the two db servers and load balance selects that way, but inserts _have_ to be done to the parent. Now, using php and theoretically if both servers are identical, when the parent was disconnected I could have the inserts go directly to the daughter server, but then when the parent comes back-up they need to be able to synchronize. Any ideas on how to do this? I just need some way for two servers to provide the exact same information at near perfect real-time and if machine A goes down then machine B will take all requests and then re-sync when machine A comes back online. It seems like this is impossible without some sort of two way replication available. Any input is welcome. Thank You! .:: Nathan Cook [ [EMAIL PROTECTED] ] ::. Systems Network Administrator :: Programmer [ phone - 208.343.3110 ][ pager - 208.387.9983 ] - Original Message - From: "Jeremy D. Zawodny" [EMAIL PROTECTED] To: "Nathan Cook" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 1:51 AM Subject: Re: Load Balancing. On Tue, Jan 30, 2001 at 02:35:29PM -0700, Nathan Cook wrote: It seems like I have seen somewhere that load balancing and fail-over-services are available for MySQL, to share the load and mirror the data between two machines. Other than MySQL's built-in replication, which doesn't handle fail-over yet, I don't know of any which are MySQL-specific. There are various open source and commercial projects/products which do high-availability for various services on Linux, but I don't have any experience with them. I'd appreciate hearing back on the list about what you discover. I'm sure others would as well. Good luck, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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
you can tell
dear Sir : MySQL 3.22 on my linux 486 PC seems work so good. when I compile a simple C API programe which catched from the MySQL tutorial, it chokes at the end of compile process . the programe is as follows: #include stdio.h #include mysql.h #define def_host_name NULL #define def_user_name NULL #define def_password NULL #define def_db_name NULL MYSQL *conn; int main(int argc,char *argv[]) { conn=mysql_init(NULL); mysql_real_connect( conn, def_host_name, def_user_name, def_password, def_db_name, 0, /*port defaut*/ NULL, /*socket default*/ 0);/*flag*/ mysql_close(conn); exit(0); } I compile as follows: gcc -o client my_simplest_prog -I/home/MySQL/MySQL/include \ -L/home/MySQL/MySQL/lib \ -lmysqlclient then I get : /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open': my_open.o(.text+0x14):undefined reference to 'open64' /home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format': mf_format.o(.text+0x201):undefined reference to '__lxstat64' /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open': my_open.o(.text+0x21):undefined reference to 'fopen64' nothing left to do with the situation, I beg your help. anyway I'm a newcomer. thank you very much. please send message to [EMAIL PROTECTED] - 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
query optimization suggestion
When using mySQL I've learned to avoid OR in any queries as much as possible . Almost always this causes a major speed decrease. Consider this table: CREATE TABLE test( userID int, # (non-unique) testID int, # (non-unique) PRIMARY key(testid,userid) ); Suppose this table is populated with 1,000,000 rows. Then do this: DELETE FROM test WHERE userID= AND testID20 OR testID80; This query is EXTREMELY slow becasue it looks at every row in the DB. A significant improvement can be acheived by splitting it into 2 statements: DELETE FROM test WHERE userID= AND testID20; DELETE FROM test WHERE userID= AND testID80; On real data I've acheived at least a ten fold increase doing this. This is easy to optimize from the client side, however, I don't see any reason why this optimization can't or shouldn't be build into the server. Whenever an OR can be split into two separate queries on the same index this optimization should work. Food for thought. - 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
Web site developed with perl, html using mySQl as the backend
Hi all just wanted some professional opinions on my web site located at http://www.IWantYourStuff.com I developed the site using HTML (of course) with Perl scripts accessing a mySQL database. If anyone would like to comment on it or make any suggestions please drop me a line. Thanks. - 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 text searches
Geoff Coffey wrote: I am new here... I am in the process of migrating a site built with FileMaker Pro to MySQL and PHP mostly because filemaker's web capabilities are too limiting. In one situation, we have a database of about 20,000 rows that contains two text columns. One is the full text of a resume and the other is the full text of a cover letter. I'm trying to decide how to enable searching from a web form. I've not actually tried it, but I suspect using "LIKE" will be lousy. In Sybase it certainly would be. I found a thread on this list discussing just this, and the suggestion was made that I create a few tables to store keywords and map them to record ids etc. My problem with this is it makes it impossible to do searches on a phrase. I think the users would often search for "Microsoft Word" for instance, and it would find every candidate that mentions "Microsoft" and "Word", but not necessarily together. But it would be acceptable to limit it to word searches if need be (filemaker doesn't support this now in a fast way anyway). Are there any other options than this? This is a big software enginering topic... If you want to do the search with LIKE, do it, but the performance will decrease as soon as you put more and more texts... By the other way, using lists of words would be ok, but has some problems, one is the "Microsoft Word" that you say. I think the more inexpensive (in time and money) way to implement this is using the LIKE clausure but making backups of the query in a "cache" so if other user ask about something like that the system will bring it back in a flash... Then you can search even in the "cache" database... Making search engines is not a trivial thing, but this may be an aproach... -- Gonzalo Aguilar. Madrid, Espaa (Spain) | Reymad Studios | [EMAIL PROTECTED] | Privado| [EMAIL PROTECTED] | + - 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 optimization suggestion
Shouldn't the first query have parenthesis? As in: DELETE FROM test WHERE userID=X AND (testID20 OR testID80); Even if it works the other way, parenthesis make it more clear what you're trying to accomplish. -Angela Michael Griffith wrote: When using mySQL I've learned to avoid OR in any queries as much as possible . Almost always this causes a major speed decrease. Consider this table: CREATE TABLE test( userID int, # (non-unique) testID int, # (non-unique) PRIMARY key(testid,userid) ); Suppose this table is populated with 1,000,000 rows. Then do this: DELETE FROM test WHERE userID= AND testID20 OR testID80; This query is EXTREMELY slow becasue it looks at every row in the DB. A significant improvement can be acheived by splitting it into 2 statements: DELETE FROM test WHERE userID= AND testID20; DELETE FROM test WHERE userID= AND testID80; On real data I've acheived at least a ten fold increase doing this. This is easy to optimize from the client side, however, I don't see any reason why this optimization can't or shouldn't be build into the server. Whenever an OR can be split into two separate queries on the same index this optimization should work. Food for thought. - 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 -- Angela Curtis Innovative Business Consultants http://www.ibc2001.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
Chinese encoding full text index
Hi! I really need a search engine that can make my users able to do a free text search in my MySQL database. I have 800 records, so a query like SELECT * FROM table WHERE content LIKE '%searchtext%' goes really slow. I wonder if MySQL support Chinese encoding full text index? Please help me out here! awa - 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 text searches
From: "Geoff Coffey" [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 5:25 PM I am in the process of migrating a site built with FileMaker Pro to MySQL and PHP mostly because filemaker's web capabilities are too limiting. In one situation, we have a database of about 20,000 rows that contains two text columns. One is the full text of a resume and the other is the full text of a cover letter. I'm trying to decide how to enable searching from a web form. snip I also saw mention of a FULL-TEXT index. Is anybody using this? I think it would be a good bet, if I can get 3.23 to build on our setup, and if it is stable. It would certainly save me lots of trouble... I would definately go for the FULLTEXT index. Using LIKE statements as in "WHERE a LIKE '%someword%' ..." always causes the DB to make a sequential scan - not good. I'm using FULLTEXT myself - on a table with about 4.2 MB text, it generates an index file with a size around 2 MB. Only downside I find with the FULLTEXT is that you cannot search for 'someword%' - but it's a price I have no problem paying. - Carsten - 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 optimization suggestion
Shouldn't the first query have parenthesis? As in: DELETE FROM test WHERE userID=X AND (testID20 OR testID80); Even if it works the other way, parenthesis make it more clear what you're trying to accomplish. -Angela Actually, yes. Sorry about the poor example. My point is that sometimes applications can be sped up by splitting OR queries into two separate queries, and I believe many times the server could recognize this, although I am wrong in this particular example. I'll have to check my code for an exact situation. Michael - 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 text searches
on 2/1/01 1:36 PM, Gonzalo Aguilar at [EMAIL PROTECTED] wrote: Making search engines is not a trivial thing, but this may be an aproach... I appreciate all the replies. In my original post I also asked about the FULL TEXT index type. If I may ask again, has anyone had any experience with this? Can you comment on it's stability (it's listed as "beta" on the site). In general, how long is something in that state? I don't suppose this particular site will go live for another couple months (it's running fine in filemaker now). Do the FULL TEXT searches perform well? Are the results good? In order to get it working, I'd have to build 3.23 and I had trouble with that when I first tried, but I'm sure I could get it working with a little effort... Thanks, Geoff - 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
duplicating rows
Hello list, After searching the documentation on the site, as well as the archives, I have yet to find the answer to this question. If I have overlooked it somewhere, just point me in the right direction. The question: I have two tables, set up exactly the same, except the names of the tables are different. Table 1 is called: active_users Table 2 is called: deleted_users When "joe_smith" wishes to be deleted, I want to remove his entry from the active_users table, and place it into the delete_users table, with exactly the same information. Something like: replicate * from active_users where user_name = "joe_smith" into table deleted_users; All entries in Table 1 are unique by user_name (joe_smith in this case), but such is not the case in the deleted_users (there is more than one joe_smith in the world, if one cancels, we need to allow another one to signup), which is why I can't just add an extra column to tell if the user is active or not. I could do a select from active_users, store the information, then insert into deleted_users, then delete from active_users, but that is three steps when it seems there should be an easier (more efficient) way. Any ideas or links to archives or documentation is appreciated. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Aaron Williams [EMAIL PROTECTED] Dev. Engineering StarNet Incorporated WholeSale Dial-Upwww.megapop.net =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Binary data
Hi Barry, I do not know what do you use for feeding your database, but in Perl you shoud use the DBI module, and insert the binary data through bindings. use DBI; use strict; ... my $dbh = DBI-connect("dbi:mysql:image_db", "user", "password") || die "$DBI::errstr\n"; # connect to the database ... my $sth = $dbh-prepare("INSERT jpeg_table SET size_x = $size_x, size_y = $size_y, image_data = ?;") || die "$DBI::errstr\n"; # prepare the insert statement, replacing the image data with a question mark $sth-bind_param(1, $image_data); # binding the binary data $sth-execute() || die "$DBI::errstr\n";# executing the insert ... $dbh-disconnect(); # disconnect Regards, Peter Szekszardi PortoLogic Ltd. Portal building, design, net survey and more... On Wed, 31 Jan 2001, Barry Radloff wrote: hi I am pretty new at this and would like to know how does one store a binary blob to the mysql DB ie I would like to store a jpeg to the db Thanks Barry Radloff RD Media24 - 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 optimization suggestion
In the last episode (Feb 01), Michael Griffith said: CREATE TABLE test( userID int, # (non-unique) testID int, # (non-unique) PRIMARY key(testid,userid) ); Suppose this table is populated with 1,000,000 rows. Then do this: DELETE FROM test WHERE userID= AND testID20 OR testID80; This query is EXTREMELY slow becasue it looks at every row in the DB. A significant improvement can be acheived by splitting it into 2 statements: DELETE FROM test WHERE userID= AND testID20; DELETE FROM test WHERE userID= AND testID80; Avoiding ORs is a good idea, but I don't think your example demonstrates it. The real problem is ORs on two different columns. You have: "(testID20 AND userID=) OR testID80", which can be optimized with a two-column index on (testID,userID). A better example would be "DELETE FROM test WHERE userID= OR testID=". On real data I've acheived at least a ten fold increase doing this. This is easy to optimize from the client side, however, I don't see any reason why this optimization can't or shouldn't be build into the server. Whenever an OR can be split into two separate queries on the same index this optimization should work. What you're suggesting here is splitting a query into a UNION of two smaller queries, essentially. But this is not always the best way. Keep in mind that your DELETE example doesn't have to worry about records that are true for both halves of your OR (since the record would get deleted by the first statement). If it were really a SELECT query, mysql would have to run the first half of the query, remember all the record numbers, then run the second query and make sure that no duplicate records are returned: SELECT * FROM test WHERE userID= or testID=; i.e.full table scan would become (if mysql supported UNION): SELECT DISTINCT * FROM ( SELECT * FROM test WHERE userID= UNION SELECT * FROM test WHERE testID= ); i.e.random record pull based on userID index + random record pull based on testID index + mergesort + remove duplicate records If there is a lot of overlap between the two OR clauses, or the percentage of returned records is high relative to the size of the table, doing a full table scan would be faster. -- Dan Nelson [EMAIL PROTECTED] - 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: duplicating rows
Can be done in two steps, but not in one: insert into deleted_users select * from active_where where username='joe'; delete form active_users where username='joe'; what you mention about usernames not being unique in the deleted_users table is not a problem as long as you don't have a primary or unique key on username.. but you should make some primary key in the delete_users table, an auto_increment or something for maintenance purposes. Right, there is an auto_increment column in the active_users, which will get carried over into the deleted_users table. Since each entry in the active_user will be auto_incremented, all of the rows in the deleted_users will have a unique identifer as well. At any rate, I guess two steps are better than three. Thanks for the help. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Aaron Williams [EMAIL PROTECTED] Dev. Engineering StarNet Incorporated WholeSale Dial-Upwww.megapop.net =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: duplicating rows
It is in the manual. Approximately ( Don;t have manual in front of me ): insert into deleted_users select from active_users where user_name = "joe_smith"; delete from active_users where user_name = "joe_smith"; Aaron Williams wrote: Hello list, After searching the documentation on the site, as well as the archives, I have yet to find the answer to this question. If I have overlooked it somewhere, just point me in the right direction. The question: I have two tables, set up exactly the same, except the names of the tables are different. Table 1 is called: active_users Table 2 is called: deleted_users When "joe_smith" wishes to be deleted, I want to remove his entry from the active_users table, and place it into the delete_users table, with exactly the same information. Something like: replicate * from active_users where user_name = "joe_smith" into table deleted_users; All entries in Table 1 are unique by user_name (joe_smith in this case), but such is not the case in the deleted_users (there is more than one joe_smith in the world, if one cancels, we need to allow another one to signup), which is why I can't just add an extra column to tell if the user is active or not. I could do a select from active_users, store the information, then insert into deleted_users, then delete from active_users, but that is three steps when it seems there should be an easier (more efficient) way. Any ideas or links to archives or documentation is appreciated. - 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 security?
Hi! On Feb 01, Nicolas GREGOIRE wrote: msquared a ecrit : Perhaps you want to distribute a CD full of databases, and people buy access to specific databases. access = password IMHO, this method can't protect the content of the CD. Hace a closer look : - you have read acces to the CD (files-level read access), but your MySQL server asks for a password when you want to read a particular table. - so, copy the content of the CD to hard-disk (included privs database) - edit manually (vi -b) the passwords table, replace the existing encrypted password with one you know the clear text - use MySQL with the table stored on the hard-disk - you are prompted for a password, enter yours - you have access to the CD content without the original password ( you have just win some maps of Australia :) I think it would work Nicob It wouldn't work if the password is used to decrypt the content. And there could be different passwords for different maps. Having different passwords for every possible combination of maps from the CD poses an interesting mathematical problem, but I am not sure it's impossible. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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: Database/table encryption
Hi! On Feb 01, Tõnu Samuel wrote: msquared wrote: I'm working for a company that has a paranoid client, and the client wants their database to be 'secure'. By 'secure' they mean that even if someone gains root access on the server, the data in the database can't be compromised (obtained). I can think of a couple of ways to do this, but I don't know if they're practical. The first is to have MySQL store the tables and such in an encrypted fashion, at the file layer. Can anyone else offer any alternative suggestions, or some guidance? Most standard way is prorably having encrypted filesystems support in kernel (http://www.linuxi.org) and then having MySQL databases on it. I do not believe into too big security when intruder already have root but encryption will anyway help. A note about too big security: If they want MySQL to send decrypted data to client, then intruder (having root) would be able to read them from memory anyway. If they want the client to handle the encryption, there's no need for encrypted filesystem - all the crypto is done by client. Not that I wanted to say that encrypted filesystem is useless... :-) Reading decrypted data from memory is more complex task indeed. Just one has to know the limitations of his solution. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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: _slow_ index generation
Hi! On Jan 30, Sheer El-Showk wrote: Please cc [EMAIL PROTECTED] on any response, I'm on the list but I filter to a file, thanks. Can someone (maybe with some MySQL-innards code experience) please explain this problem: Generating an index on the first character of a varchar(70) on a 350 meg table on a PII 366 128 MB Ram, normal IDE disk takes over 17000 seconds (ie it never even finished but the process took that much time in "show processlist" before I finally killed it). And the server was not hung in any way ... in fact I watched it generate a ~550Mb temporary table in the MySQL data dir (filename began with a hash #sql). In fact the system's resources, disk access aside, weren't even being strained ... ~8% memory, 3-4% CPU. All I can say now is that MySQL variable that determines the buffer size for repair_by_sort (which is used to recreate indexes) is myisam_sort_buffer_size. Try to increase its value. What is your table structure (SHOW CREATE TABLE output) ? Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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: Linux limited to 256 connections by default?
well I believe this has to do with the file descriptors, but I use RH 7.0 and you can change the file descriptor max under /proc/sys/fs/file-max and inode-max On Thu, 1 Feb 2001, Chuck Carson wrote: I was under the impression ulimit controlled this, but someone just told me that by default, the linux kernel only supports 256 simultaneous connections, thus MySQL is limitd to 256 connections unless running on a modified kernel. This does not sound right to me so I thought I would ask here. We are currently performance testing MySQL on RH 6.2. I have rebuilt the kernels to allow more shared memory (for some other apps) but have done nothing that would affect a limit such as this. I know I have some Oracle databases running on the same kernels (2.2.18smp) that allow more than 256 connections. Can anyone shed some light on this? Thanks, CC - 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 -- -Spinlock EmpireQuest Creator http://www.empirequest.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