Re: mysql on redhat 7.0
Sanjeev Adhyapak wrote: We have installed redhat 7.0 server on one machine and want to run mysql server on that. The installation is default. After that only the root is allowed to connect to the server and if login as different user i am getting the error as error 111 connection refused. If anybody has started it then plese let me know. MySQL packages included with RH7 are broken. Take newer ones from RedHat updates or http://www.mysql.com. -- 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: MySQL over ODBC
If mysqlserver is not installed on your computer then first try to connect remote host from mysql client. mysql -h 192.168.0.1 -u root if you can connect via this way then odbc can resposible about this situation. But i don't think so. Problem is about permissions to remote clients. If not problem may be in your DSN configuration. See http://www.avukatpro.com/mysql.html for tested and working properly DSN configuration. Regards. Yusuf Incekara - Original Message - From: denis mettler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 4:36 PM Subject: MySQL over ODBC Hi there, i received the following message: [TCX][MyODBC] Host 'XYZ' is not allowed to connect to this MySQL Server (#1130) any ideas regards denis - 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: win to linux
Try to dump your database from Linux first. Then put them into Windows via ftp. Then import it into a Windows. I am using MySQL on windows platform. How can I port mt datas from MySQL server on windows to MySQl server on Linux? Thanks for all. - 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
Help Needed
Hi I just downloaded MYsql for windows NT. I'm running it on Windows2000 Advanced Server. Everything loads fine and it is running ok but, when I try to run Winmysqladmin the program loads up for only about 2 seconds and then closes. Any ideas on what I need to do? Thanks Joe - 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: Help Needed
Hello Pat Well, I really feel stupid! Under the gun with this any I really don't have a clue. I also need to install some type of DBI foe windows2000 advanced server too and I'm now downloading a perl file off of mysql.com. I really have no idea working with windows. My main OS that I have been working with was FreeBSD server. Again thanks for the time that you took out to help me out! Joe Pat Sherrill wrote: Expected behaviour, look in your Tray on the Taskbar for a stoplight icon. Pat... - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 17, 2001 6:12 PM Subject: Help Needed Hi I just downloaded MYsql for windows NT. I'm running it on Windows2000 Advanced Server. Everything loads fine and it is running ok but, when I try to run Winmysqladmin the program loads up for only about 2 seconds and then closes. Any ideas on what I need to do? Thanks Joe - 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 3.23.35 is released
On 17-Mar-2001 Greg Cope wrote: Michael Widenius wrote: Hi! Greg On the off chance any ideas when this (A Gemini THandler) 3.23.x release Greg may be and when we might see a public 4.x alpha. I know the answer will Greg probably be "When its ready" but a small clue would be nice :-) Lets guess a bit :) 3.23.36 with GEMINI should happen within 2 weeks. 4.0-alpha should happen within 2 months. Er. Is there any way you guys can actually form a stable branch, and a development branch? It would be nice to get a stable version of mysql with replication, and that's not going to happen with all of these new features being pumped into a supposedly "stable" branch. Regards, Monty Thanks Monty, your work is much appreciated by me and many others. I'm looking forward to a GEMINI 3.23.X and especially 4.0-alpha (when thier ready) Thanks again. Greg --- Dynamic Hosting HTTP://www.L8R.net/ "We Provide Static Hostnames for Dynamic IP's" - 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: shared library libz.a
Summanen,Jack writes: Umm I went looking for libz.a under which subdirectory? I checked lib and gnu, and no libz.a unless I am looking in the wrong place. Look for zlib. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, 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
Re: INNOBASE
Cal Evans writes: Other than the (sparse) documentation in the manual, is there any other documentation available for INNOBASE files? Cal http://www.calevans.com Hi! Try : http://www.innobase.fi Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, 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
Query optimization
Hi all, I have a query in my program which is taking to long when I get data in the database. I'm currently testing with ~40.000 articles in the system. The query which I'm using is (takes about 2 secs ): SELECT Article.ID as ArticleID FROM eZArticle_Article AS Article, eZArticle_ArticleCategoryLink as Link, eZArticle_ArticlePermission AS Permission, eZArticle_Category AS Category WHERE ( ( ( Permission.GroupID='-1') AND Permission.ReadPermission='1' ) ) AND Article.IsPublished = 'true' AND Link.CategoryID='1' AND Permission.ObjectID=Article.ID AND Link.ArticleID=Article.ID AND Category.ID=Link.CategoryID ORDER BY Article.Published DESC LIMIT 10,10 I've tested with indexing and table optimizing: alter table eZArticle_Article add index ( ID ); alter table eZArticle_Article add index ( Name ); alter table eZArticle_ArticlePermission add index ( ObjectID ); alter table eZArticle_ArticleCategoryLink add index ( ArticleID ); alter table eZArticle_ArticleCategoryLink add index ( CategoryID ); alter table eZArticle_ArticlePermission add index ( ReadPermission ); alter table eZArticle_ArticlePermission add index ( WritePermission ); alter table eZArticle_Article add index ( Published ); optimize table eZArticle_Article; optimize table eZArticle_ArticlePermission; optimize table eZArticle_ArticleCategoryLink; optimize table eZArticle_Category; Is it possible to optimize this query further? Or is this the kind of speed I would get from this kind of query. Test machine: Dual PIII 800 with SCSI hardware RAID and 512 MB ram. -- Brd Farstad Systems developer ez.no | developer.ez.no | zez.org - 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: several problems
On Fri, 16 Mar 2001, Daniel Soto Armijo wrote: Why the user interface of MySQL is very difficult? Why is not more friendly like MS SQL Server user interface? I tried to use and configure MySQL and I get nothing. H. I'll probably get flamed for this, but you wouldn't be using either if you weren't at least trying to be a DBA, and if you need a cute little point-and-click interface before you can figure something out, you have no business being near a db server. IMHO, of course. -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS
RE: import out of MS SQL Server into mysql
BlankI never found one so I wrote a simple FoxPro program that opens the MS SQL database and builds a file similar to what mysqldump would build. If you find a generic tool please post the URL! Cal http://www.calevans.com -Original Message- From: Michael Blood [mailto:[EMAIL PROTECTED]] Sent: Friday, March 16, 2001 10:59 PM To: MYSQL Subject: import out of MS SQL Server into mysql Has any one heard of a good way to import from MS SQL Server into a new mysql database. I have a small (120 MB) database that I would like to convert to mysql and I was hoping that there was some sort of tool that will allow me to do it while maintaining the DDL Any suggestions are greatly appreciated Michael Blood Matraex Technologies [EMAIL PROTECTED]
RE: INNOBASE
Thanks for the reply but I'm not seeing any useful documentation. Specifically, is there a comprehensive list of all the my.cnf settings along with a detailed explanation of what they mean? Or is the one in the MySQL manual complete? Also, is there a tutorial or some sort of list of steps necessary to go through to setup MySQL for running with INNOBASE tables? I thought I understood but when I started loading data into my table, it started blowing chunks. Cal http://www.calevans.com -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 17, 2001 6:49 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: INNOBASE Cal Evans writes: Other than the (sparse) documentation in the manual, is there any other documentation available for INNOBASE files? Cal http://www.calevans.com Hi! Try : http://www.innobase.fi Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, 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
RE: INNOBASE
Cal Evans writes: Thanks for the reply but I'm not seeing any useful documentation. Specifically, is there a comprehensive list of all the my.cnf settings along with a detailed explanation of what they mean? Or is the one in the MySQL manual complete? Also, is there a tutorial or some sort of list of steps necessary to go through to setup MySQL for running with INNOBASE tables? I thought I understood but when I started loading data into my table, it started blowing chunks. Cal http://www.calevans.com Hi! MySQL manual contains info on all Innobase startup variables available so far. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, 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
Re: MySQLGUI 1.7.4
Thomas Schwerk writes: Hi, I' trying to use MySQL Gui 1.7.4 and keep getting the following error: Can't connect to local MySQL server through socket '' (111) I'm using Redhat 7.2 and have tried it with the semi-static and the static versions of MySQLGui. Connecting to the server with mysql is no problem. I'm using MySQL Version 3.23.33. Any thoughts? Best regards, Tom Hi! RedHat 7.2 ?? I heard only about 7.1 beta 2. Anyway, all you have to do is follow instructions from README that comes with either of the above distro's. Here is a relevant excerpt :: When you start it for the first time, click on ``Options'' button, fill up all entries correctly and click on ``Save'' button. From then on, you will logon automatically to the running server on every mysqlgui startup. Take care to put the right value in ``Ask for password'' button. Also, if you have problems with location of socket files on *nix, enter a full path of the socket file in the ``SQL command on the start-up''. This input field is used on Windoze if you wish to specify that named pipe option. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, 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
MySQL remote access
I have remote access to a MySQL database. I would like to be able to "download" a table or portions of a table to my local computer so as to work with the data using other tools for simple data manipulation. Can this be done? How? Any tips or pointers in the right direction would be greatly 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 remote access
Mark, That's not really that way you work with RDBS engines. It's not a desktop database like Access or FoxPro. (mmFox Pro!) What is the problem you are trying to solve? Is the remote connection too slow? You can always use mysqldump to create a MySQL script that will rebuild the database on your local machine. (Assuming you have MySQL loaded on your local machine.) But you won't be able to just access the files directly, you will have to have a copy of mysqld running. HTH, Cal http://www.calevans.com -Original Message- From: Mark H. Shin [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 17, 2001 9:15 AM To: [EMAIL PROTECTED] Subject: MySQL remote access I have remote access to a MySQL database. I would like to be able to "download" a table or portions of a table to my local computer so as to work with the data using other tools for simple data manipulation. Can this be done? How? Any tips or pointers in the right direction would be greatly 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 - 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: Access rights
Check the manual for the GRANT command. It holds the secret that you are searching for. :) You can use it to grant specific rights to databases or tables within databases. Once you have granted rights for a user, then use mysql -u username -p the -p is only necessary if the user you are trying to login in as needs a password. HTH, Cal http://www.calevans.com -Original Message- From: Jerry Davis [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 17, 2001 9:15 AM To: MYSQL Subject: Access rights 1) How do I give access to other users in MySQL? 2) How do I give access to tables to other users? 3) How do I create another database and then give access to that database to other users? I can get into the test database as user x but I can't get even get an access error when trying mysql with user root. ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) Jerry -- Boycott the outlaw Microsoft - and use Linux - the Software that gives you Freedom to choose! - 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
Password problem
Hi, I am trying to set up a passsword a system root for the root MySQL server for the 1st time (rpm download) I get the following error message: [root@localhost MySQL]# /usr/bin/mysqladmin -u mysql -p password 'x1234!' Enter password: /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'mysql@localhost' (Using password: YES)' if I run the same command as MySQL root (ie: user mysql): bash$ /usr/bin/mysqladmin -u mysql -p password 'x1234!' Enter password: /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! The socket is on /tmp but not on /var/lib/mysql/ Also, should the user specified with -u be 'mysql' (a valid id on my system) or should the argument remain 'root' ? Thanks for your input, Charles - 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.35 is released
On Sat, Mar 17, 2001 at 06:56:34AM -0500, [EMAIL PROTECTED] wrote: On 17-Mar-2001 Greg Cope wrote: Michael Widenius wrote: Hi! Greg On the off chance any ideas when this (A Gemini THandler) 3.23.x release Greg may be and when we might see a public 4.x alpha. I know the answer will Greg probably be "When its ready" but a small clue would be nice :-) Lets guess a bit :) 3.23.36 with GEMINI should happen within 2 weeks. 4.0-alpha should happen within 2 months. Er. Is there any way you guys can actually form a stable branch, and a development branch? It would be nice to get a stable version of mysql with replication, and that's not going to happen with all of these new features being pumped into a supposedly "stable" branch. Don't enable innobase or gemini, and you'll have a stable server. Seriously, if you don't even compile in the new features, there's little danger of them affecting you. 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: Innobase in MySQL
Andy, thank you for your benchmark :). I was also going to measure these, but have not had time yet. But what parameters you used in my.cnf? You have a lot of RAM in your system, and you could make the Innobase buffer pool big. I've benchmarked a few scenarios to load mysqldumped data into an innobase-table (about 27 columns, mostly int's and float's) with about 150.000 rows with primary key and an additional unique key. The mysqldumped data was generated one insert per row (not dumped with --extended-inserts). 1. cat test.sql | mysql innobase = 306 seconds 2. cat test.sql | mysql innobase, but with autocommit=0 and all inserts between BEGIN/COMMIT = 124 seconds If you use autocommit = 1, then Innobase has to flush the log to disk after each individual insert, which makes it slow. It is better to use autocommit = 0, if you have enough space in your tablespace for the rollback segment. 3. same as 1. but with index creation after the inserts. = 264 seconds + additional 59 seconds for index recreation. 4. same as 2. but with index creation after the inserts. = 75 seconds + additional 59 seconds for index recreation. How do you create the index? With ALTER TABLE? I noticed that in 3. and 4. the machine load was constantly at 100% during the inserts. but during index recreation the load springs wildley between 0 and 100%, so the machine is not maxed out in terms of CPU utilization here (in other Innobase has to write to the log which causes some disk i/o, reducing CPU utilization. Also, when the database has written the log files full, Innobase has to make a checkpoint, that is, flush written pages from the buffer pool. You could try making your log files very big, say 150 MB in total, to get a better CPU utilization, and also the buffer pool bigger, if it is not yet big. words, the machine is waiting for something to do :-). The same applies to 2. when commit() was send. I tested also 1. and 3. with a myisam-table. Index recreation draws constantly 100% load from the machine here, therfore it's faster. results: 5. same as 1. but with myisam type = 116 seconds 6. same as 3. but with myisam type = 65 seconds + additional 33 seconds for index recreation. system is a celeron 466 / 66MHz FSB, 512 MB RAM, Linux 2.4.2, mysql-3.23.35 If the numbers are not useful to anybody, think of this posting as spam and forget myself... Totally the opposite of spam! I got useful information from this! Best regards, Heikki Tuuri Innobase Oy --Andy You could add to the campaign below MS Word documents :). /"\ \ / ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \ AND POSTINGS - 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-DBI-perl-bin
Hello guys Does anyone know where I can get the MySQL-DBI-perl-bin RPM distribution (version 3.23.17-1.i386). I'm running a RH6.0 box. Thanks a lot *Wilmar Prez * IT Department * Libraries System *University of Antioquia *tels: +(57)4 2105145 *+(57)3 4612166 * Medelln - Colombia - 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
synopsis of the problem (one line)
Description: when i first start the mysqld i get error @HOSTNAME@ COMMAND NOT FOUND. AND WHEN I TRY TO CHANGE PASSWORD I GET ACESS DENIED FOR ROOT AT LOCALHOST USING YES please help How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: Submitter-Id: submitter ID Originator:Rolando Roman Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.35 (Official MySQL binary) Server: ./mysqladmin Ver 8.18 Distrib 3.23.35, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.35 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 2 min 27 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.007 Environment: System: Linux virtuoso 2.4.2 #2 Sun Feb 25 10:21:55 GMT+5 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O6 -mpentium ' CXX='gcc' CXXFLAGS='-O6 -mpentium -felide-constructors' LDFLAGS='-static' LIBC: -rwxr-xr-x 1 root root 4070406 Aug 5 2000 /lib/libc.so.6 -rw-r--r-- 1 root root 19185232 Aug 5 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Aug 5 2000 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared - 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
[MAILER-DAEMON@263.net: Undelivered Mail Returned to Sender]FYI
Description: when i first start the mysqld i get error @HOSTNAME@ COMMAND NOT FOUND. AND WHEN I TRY TO CHANGE PASSWORD I GET ACESS DENIED FOR ROOT AT LOCALHOST USING YES please help How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: Submitter-Id: submitter ID Originator:Rolando Roman Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.35 (Official MySQL binary) Server: ./mysqladmin Ver 8.18 Distrib 3.23.35, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.35 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 2 min 27 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.007 Environment: System: Linux virtuoso 2.4.2 #2 Sun Feb 25 10:21:55 GMT+5 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O6 -mpentium ' CXX='gcc' CXXFLAGS='-O6 -mpentium -felide-constructors' LDFLAGS='-static' LIBC: -rwxr-xr-x 1 root root 4070406 Aug 5 2000 /lib/libc.so.6 -rw-r--r-- 1 root root 19185232 Aug 5 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Aug 5 2000 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared - 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 - End forwarded message - -- SuSe 7.0 Linux 2.4.2 i686 Sat Mar 17 11:05:00 EST 2001 - 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
Compiling mysql
I am trying to compile mysql on a 233 AMD. The video adaptor is: Description: S3 86C764_1[Trio 32/64 vers 1] Manufacturer: S3 Inc Device: Unknown Driver: XF86_S3 PCI Information: Vendor ID: 0x5333 Card ID: 0x8611 Slot Number: 4 PCI Information: 0x5333,0x8611,4 The vesion of mysql that I have is: mysql-3.22.16b-gamma I am using gcc 2.8.1 to compile and the OS is Corel LinuxOS. I get the following error: In file included from /usr/include/termios.h:40, from /usr/include/termcap.h:48, from mysql.cc:43: /usr/include/bits/termios.h:28 warning: 'NCCS' redefined /usr/include/asm/termbits.h:10 warning: this is the location of the previous definition In file included from /usr/include/termios.h:40, from /usr/include/termcap.h:48, from mysql.cc:43: /usr/include/bits/termios.h:30 redefinition of 'struct termios' /usr/include/asm/termbits.h:18 previous definition here make[2]: ***[mysql.o] Error 1 make[2]: Leaving directory '/usr/local/src/mysql-3.22.16a-gamma/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory '/usr/local/src/mysql-3.22.16a-gamma' make: *** [all-recursive] Error 2 --- Kathleen Ferguson --- [EMAIL PROTECTED] --- EarthLink: It's your Internet.
Ynt: ODBC trouble - please help
try microsoft msdn web site at : http://msdn.microsoft.com see properties opening your odbc connection in exclusive mode/or not. Regards. - Original Message - From: Wojciech Spychaa [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 07, 2001 11:14 AM Subject: ODBC trouble - please help I 've got problem with ODBC support for Microsoft Access Very ofeten i can't edit records because one error. ODBC driver says "there is another user editing same record in this time" This isn't true - because i work alone :-( Is anyone who can help me? Thanks Wojtek - 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
PHP query
Hi, I am having problems with my query trying to call a list of interests. When someone signs up too the site they choose 7 different interests from a list and it can be in any different configuration. I am having a hard time getting it to query, and amy getting this error message: SELECT clients.CUserName,clients.CFirstName,clients.CLastName,clients.CCity,clients.CGender,clients.CMarital,clients.CCommunity,clients.CHeight,clients.CKids,clients.CBody,clients.CEducation,clients.CChurch,clients.CEmail,i1,i2,i3,i4,i5,i6,i7 FROM clients,interests WHERE (CCity LIKE '%' AND CHeight LIKE '%' AND CKids LIKE '%' AND CAge LIKE '%' AND CMarital LIKE '%' AND Interests LIKE ('' OR '' OR '' OR '' OR '' OR '' OR '') AND clients.CUserName = interests.CUserName) ORDER BY CCity, CLastName Warning: Supplied argument is not a valid MySQL result resource in c:\phpweb/searchresults1.php on line 462 Found profiles that matched your search criteria. Here is my original code for the query. $query = "SELECT clients.CUserName,clients.CFirstName,clients.CLastName,clients.CCity,clients.CGender,clients.CMarital,clients.CCommunity,clients.CHeight,clients.CKids,clients.CBody,clients.CEducation,clients.CChurch,clients.CEmail,i1,i2,i3,i4,i5,i6,i7 FROM clients,interests WHERE (CCity LIKE '$Qcity' AND CHeight LIKE '$Qheight' AND CKids LIKE '$Qkids' AND CAge LIKE '$Qage' AND CMarital LIKE '$Qmarital' AND Interests LIKE ('$i1' OR '$i2' OR '$i3' OR '$i4' OR '$i5' OR '$i6' OR '$i7') AND clients.CUserName = interests.CUserName) ORDER BY CCity, CLastName Thanks in advance! Kelly - 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: INNOBASE
Hi! I exchanged some emails with Cal and he got his database running today. If you have repeating problems with creating the Innobase database, check that you have deleted all Innobase data files and log files, also a possible small archived log file, before trying the database creation again. Forgotten log files which are out of sync can cause problems. A thing I have not mentioned in section 8.7 of the manual is that a row in Innobase uses some 23 bytes + 1-2 bytes * number of columns more space than it does in MyISAM. The primary index does not take space, since also the data is stored in the index records, but secondary indexes use more space than for MyISAM, because each index record contains also the value of the primary key. The 23 extra bytes are needed for multiversioning and row level locking, and the 1-2 bytes per column contain a pointer to the column. If there is less than 256 bytes of data in the row, the pointer is 1 byte, otherwise 2 bytes. Also the space allocation in the Innobase tablespace is such that a table may reserve more space than the size of the rows: for tables of size 32 database pages, Innobase allocates space in chunks of 64 pages to reduce disk space fragmentation. Finally, when you query the amount of free space in the tablespace with SHOW TABLE STATUS as described in section 8.7, Innobase will give you a value which is smaller than the actual physical space in the tablespace. The reason for this is that some space is reserved in individual pages for small tables, and also some space is reserved for special situations like a rollback resulting from an error in an SQL statement. Also the rollback segment will reserve space. If you have long-running consistent reads and lots of updates or deletes in the database, the space reserved by the rollback segment can be considerable. Inserts do not grow the rollback segment, except for the time the transaction doing the insert is active (= not committed or rolled back), but for updates and deletes we have to preserve old versions of the rows as long as a consistent read might want to see them. Regards, Heikki Cal Evans writes: Thanks for the reply but I'm not seeing any useful documentation. Specifically, is there a comprehensive list of all the my.cnf settings along with a detailed explanation of what they mean? Or is the one in the MySQL manual complete? Also, is there a tutorial or some sort of list of steps necessary to go through to setup MySQL for running with INNOBASE tables? I thought I understood but when I started loading data into my table, it started blowing chunks. Cal http://www.calevans.com Hi! MySQL manual contains info on all Innobase startup variables available so far. Regards,Sinisa - 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
Heavy Load
hey, i'm running serveral mysql servers on powerful machines - dual processor, 2 GB memory, etc... Most of the databases store temporary data only. I need the maximum performance from these servers and have a lot of connections to the database. My problem is this - whenever the number of queries sent to the database increases, or the CPU usage increases under heavy load, mysql crashes. This has been a consistent behaviour. The system is under testing phase and the servers just give up under a reasonably heavy load. This is the my.cnf file - [mysqld] skip-locking set-variable= key_buffer=640M set-variable= max_allowed_packet=10M set-variable= table_cache=640 set-variable= sort_buffer=6M set-variable= record_buffer=6M set-variable= thread_cache=16 set-variable= thread_concurrency=16 set-variable= myisam_sort_buffer_size=64M log-bin server-id = 1 set-variable= max_connections=2000 set-variable= max_connect_errors=1 set-variable= back_log=2900 set-variable= connect_timeout=15 set-variable= wait_timeout=57600 set-variable= interactive_timeout=57600 [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=256M set-variable= sort_buffer=256M set-variable= read_buffer=2M set-variable= write_buffer=2M [myisamchk] set-variable= key_buffer=256M set-variable= sort_buffer=256M set-variable= read_buffer=2M set-variable= write_buffer=2M According to me, the database should become slow under heavy load - it should not just crash. The backtrace is also incomplete. And it is consistent for every crash. Any ideas why this could be happening? I'm using PHP to access the database on RH 6.2 with kernel 2.4.2. I'm using latest versions of everything. Thanks, Vinod Do You Yahoo!? Get your free @yahoo.co.in address at http://mail.yahoo.co.in - 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
Delayed index creation (Was:Re: Innobase in MySQL)
Greg, I think mysqldump and import work for all table handlers in the same way in MySQL. But to get the maximum performance, there are some optimizations available. Andreas Vierengel measured that using autocommit=0 makes the import much faster for Innobase. You have to issue a commit after you have imported the table. You should also set Innobase log files very big, say 150 MB, to reduce checkpointing and disk i/o during the import. Delayed index creation is technically not very difficult to implement, but on the TODO list it comes probably after several other items. Innobase already has an optimization which speeds up insertions to secondary indexes if the insertions would result in disk i/o. The optimization is called insert buffering. If a secondary index is non-unique, then Innobase does not need to read the index page in to check the uniqueness criterion. Instead, Innobase will insert the secondary index record into a main-memory cache, from which the insertions are done to disk in batches, saving a lot of disk i/o. If the insertions are disk-bound, I have measured that insert buffering can speed them up some 15 times. It would be nice if someone would measure dump and import speed for real-world tables. Andreas measured for a 150 000-row table import speed of some 1000 rows per second. (See his posting in thread Re:Innobase in MySQL). Regards, Heikki At 12:31 AM 3/17/01 +, you wrote: Michael Widenius wrote: Hi! Try: mysqldump --tab=directory This does basicly what you want. After that, it's up to Heikki to fix Innobase to do delayed creation of indexes. It would be very handy if Innobase (and the GEMINI when it comes along) where to support mysqldump in the standard way, as I assume it works as such and I and many others would have to change thier backup scripts. Delayed index creation is very usefull (in saving time) in larger DB loads via a mysqldump - Hiekki is this difficult ? Thanks all for your work. Greg Peter At least it would be a standart way to quickly backup data and recover Peter it for all table handlers (backup probably does not work for all tablr Peter types yet) 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 - 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
Benchmarking innobase tables
Hello I've compiled mysql-3.23.35 with innobase support - it runs much better than BDB for me - and run a simple benchmark with the following script: use DBI; my $DB= DBI-connect("dbi:mysql:innobase","chris",shift) or die; $DB-{RaiseError}=1; $DB-do("drop table if exists speedtest"); $DB-do("create table speedtest (a int not null primary key, b int not null) type=innobase"); $DB-do("set autocommit=0"); # or =1 my $ins=$DB-prepare("insert into speedtest values(?,?)"); foreach (0..1000) { eval { $ins-execute(int(rand(1000)),int(rand(10)) ); }; if ($@) {warn $@} else {$done++} } # $DB-do("commit"); # uncommented for some test print "have inserted $done entries\n"; On a lightly loaded powermac G3 running linuxppc I get the following results: myisam table: 2000 inserts/sec. innobase table: autocommit=0, rollback after each insert: 59 insert+rollback/sec. autocommit=0, one rollback at the end: 2926 inserts/sec. autocommit=0, one commit at the end:2763 inserts/sec. autocommit=1: 34 inserts/sec. In the last case I can hear the head from the hard disk vibrating, it seems that innobase synches each commit through to the disk oxide. I'm sure innobase isn't the fastest database in the world if this is true for everyone. Why could this be the case for me? Some system info: LinuxPPC June 1999, Kernel 2.2.17-0.6.1, glibc-2.1.3-0j gcc-2.95.3-2f Innobase data is written to an IDE harddisk. Cheers Christian Jaeger - 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: INSERT records into multiple tables
Yeah, this is why some people like the idea of having transaction supports in the tables, to make sure both the inserts to the two tables succeed, or none of them do. Currently MyISAM does not support this, only the newly introduced Berkeley DB tables support this feature although it is assumed quite a bit slower than the native MyISAM tables (albet a bit buggier as well)... Good luck! Patrick you can't. You have to do 2 seperate inserts. (Sorry) Cal http://www.calevans.com -Original Message- From: Bryan Wheelock [mailto:[EMAIL PROTECTED]] Sent: Friday, March 16, 2001 3:47 PM To: [EMAIL PROTECTED] Subject: INSERT records into multiple tables I'm just learning how to use MySQL and I am searching for a more simple way of doing an INSERT query into multiple tables simultaneously. I have done my best to nominalize my DB but that creates but I'm confused as to how to insert data into the DB and have all the related table be updated. I think that I can work out some way using conditional statements in PHP to insert the data into all the records, but I'm thinking there must be a more elegant and faster way of doing this. e.g. table people 1Bryanstudent 2Jill teacher 3 Bob student table job 1student 2teacher If I want to insert a record to table PEOPLE : insert into people values('4', 'Jon', doctor) How can I do this without having to also do a separate insert into table JOB? You need to Understand the rules so you can break them intelligently," the Dalai Lama - 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
2 Tables
Hi there, Another problem. i have the following tables: table 1: id, primary key, auto increment name varchar(50) city varchar(50) phone varchar(25) table 2: categorie_id, primary key, auto_increment kategorie varchar(50) in table one i have the contacts and in table two the categories (Business, privat...) but how can i link these tables for a query. i ask because i know that mysql doesn't support foreign keys. thanks in advance denis - 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: 2 Tables
On Sat, 17 Mar 2001 22:04:37 +0100, "Denis Mettler" [EMAIL PROTECTED] wrote: Denis, Can't you tie the table 1 id and the table 2 category_id together?? Or are this going to be different?? If they are going to be different, I would suggest then create a "linking" table to link table 1 to table 2. Cheers, table 1: id, primary key, auto increment name varchar(50) city varchar(50) phone varchar(25) table 2: categorie_id, primary key, auto_increment kategorie varchar(50) in table one i have the contacts and in table two the categories (Business, privat...) but how can i link these tables for a query. i ask because i know that mysql doesn't support foreign keys. Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - 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: causes for slowdowns/lockups?
Hello. On Sat, Mar 17, 2001 at 10:05:25PM +0100, [EMAIL PROTECTED] wrote: Thanks for your quick reply. My database is nearly 700 megs alltogether, 320 of those megs are the main table which also receives the most queries. Well, in this case 1GB wouldn't hurt. 512MB is not enough to keep the main stuff (plus indexes) in memory and let enough space for the OS to do effective caching. But I agree, I would avoid upgrading a production system if it is avoidable. [...] Since the little sorting being done in my queries is not done on indices, I would guess your suggestion of optimizing the indices is useless in my case. Sorting the data file resp. indexes doesn't only speed up sorting. It speeds up retrievel, too. Best with 'range' selections, because the next needed value was maybe in the same block and is already in memory. Also disk usage in smaller (because less 'holes' are left in the files), but that you get with isamchk alone (without sorting), too. There are some other side-effects, I don't want to go in detail to now. If you have a spare test system, just try my suggestion and see with vmstat or a similar tool if it helps with your application. It is certainly worth a try. Is there anything else that can be done? I have noticed a couple of the most common queries use temporary tables.. are these temporary tables on disk or in memory? I don't know exactly from mind. IIRC, they are in-memory except if they exceed a certain size. There should be a config variable for that limit, but I am not positive about that. I seem to remember having read somewhere that using SQL_SMALL_RESULT makes temporary tables go in memory. Is that correct, and will it help me? I remember the same thing. Why don't you just have a look in the manual? http://www.mysql.com/doc/manual.php?search_query=SQL_SMALL_RESULTsubmit=Searchdepth=0 (and follow the link to the SELECT section) Some other pointers: - If you are not using latest 3.23.x you may want to consider upgrading. Between 3.22.x and early 3.23.x and nowadays were a lot changes improving speed and concurrency. - 5-10 queries per second is not that much, except if they are complex. You said you think they are optimized well, but could you nevertheless post the EXPLAINs for some of the common ones? - I am especially wondering about that 0.5 load, I would expect it to be far lower. Do you have any explanation for that (but maybe I am too used to dual processor systems meanwhile). Bye, Benjamin. [...] You did not say how large your database and your logs are. If more memory can help to keep most stuff in memory, I would go this way. Which also may help is to optimize tables with (my)isamchk: ordering the indexes (-S) and the data according to the most used sort (-R#) help reduce disk seeks and can result in a speed increase of factor 3 or more (_can_, your mileage may vary). [...] On Sat, Mar 17, 2001 at 08:04:55PM +0100, [EMAIL PROTECTED] wrote: Hello, My database, used as a backend for a web application, gets an average of 5-10 selects per second, as well as inserts every few seconds, and updates even less often. With the queries being fairly well optimized, and the most commonly used table having no empty blocks in the data file (concurrent select/inserts), I would expect the dual PIII/700mhz/512mb to stand up pretty well. I use the LOW_PRIORITY keyword with most of the update statements to speed up the flow of select statements. And the server does stand up very well, with load averages seldom over 0.50, and using show processlist I've been unable to detect any table lock conflicts at all. It stands up well, that is, only until I run my nightly log analyzer cron job. I run it with a niceness of +20, and it takes up less than 5% cpu and less than 2% memory on average (from what I've seen in top). But ten seconds after I've started it, Mysql has completely buckled, showing a processlist full of locked tables and hanging selects. Even if I abort the analyzing job after half a minute, it's too late. Mysql is hanging and doesn't recover until I stop the web server and wait a minute or two for it to process the hanging queries. I realize I could solve the problem easily by doing the analyzing on a different machine, but I'm interested in why this fairly simple program should have such an impact on Mysql. Is the problem lack of memory? Lack of cpu power? Are there any configuration changes I could do that would help? I'm guessing from how little it takes to screw things up that my application is on the brink of buckling under the load anyway, and will do so if the traffic increases any more. What should I concentrate on when I go through the queries to optimize them further? Should I go for execution speed only, or are temporary tables an issue? (Some of the queries use temporary tables, would eliminating those make a big difference?) Any
AW: compilation of MyODBC fails
Oops. Found lots of threads regarding this compile error with Geocrawler. I better update MySQL and see if MyODBC will compile then fine. I forward my question as I didn't get any response in the myODBC mailing list. Hope someone can help. Is this the best mailing list when experiencing problems when compiling MyODBC? While configure works make breaks. Problem is in connect.c, line 89: dbc-mysql.net.vio = 0. Compiler says: structure has no member named `vio'. I found structure NET in mysql_com.h - there is indeed no member vio. I have no idea what this member is good for so I don't want to mess up the source. What to do now? (mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686), MyODBC-2.50.36, Suse Linux) TIA, Boris - 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
join from two different databases
I am try to do a join with tables that are in two different databases. I thing I've got the actual SQL syntax down: my $q = "SELECT i.inv_no, i.inv_date, c.cust_name FROM receivables.invoice i, sales.customer c, WHERE i.paid_date IS NULL"; but I am confused on how to prepare and execute it, since my database handle ($dbh) specifies only 1 database. Any help would get me out of the office on St. Pats day and in fron tof a bar maid serving green beer. Please help make my day. - 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: join from two different databases
Sorry, No Green Beer, No can do that ;-) Richard Reina wrote: I am try to do a join with tables that are in two different databases. I thing I've got the actual SQL syntax down: my $q = "SELECT i.inv_no, i.inv_date, c.cust_name FROM receivables.invoice i, sales.customer c, WHERE i.paid_date IS NULL"; but I am confused on how to prepare and execute it, since my database handle ($dbh) specifies only 1 database. Any help would get me out of the office on St. Pats day and in fron tof a bar maid serving green beer. Please help make my day. - 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: 2 Tables
On Sat, 17 Mar 2001, Denis Mettler wrote: Hi there, Another problem. i have the following tables: table 1: id, primary key, auto increment name varchar(50) city varchar(50) phone varchar(25) table 2: categorie_id, primary key, auto_increment kategorie varchar(50) in table one i have the contacts and in table two the categories (Business, privat...) but how can i link these tables for a query. i ask because i know that mysql doesn't support foreign keys. thanks in advance denis Thinking of your ER diagram will help: your 1st table originates from entity 'contact' and your 2nd table from entity 'category'. In between you have a relationship linking them. So the relationship's table is what you need and it consists of (id,category_id). regards, thalis - 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
Newbie DISTINCT problem
I'm trying to populate a pulldown menu with distinct values from a found set using the following query. SELECT DISTINCT name FROM request WHERE id = '5' OR demo_id = '$demo_id' ORDER BY name Apparently I am doing something wrong. If I have a record with the same name that meets the WHERE parameters and one that doesn't, the name won't appear in my pulldown menu. What am I doing wrong? Thanks, Tom . Tom Beidler Orbit Tech Services 805.682.8972 (phone) 805.682.5833 (fax) [EMAIL PROTECTED] http://www.orbittechservices.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
Syntax check
Can someone look at this syntax and tell me what is wrong with it. Any and all help is appreciated. I worked with several databases and have never had any trouble writing CREATE statements in the past. I get the following error when I run this create statement. So what is wrong with my syntax. I found this same error when I searched the list but none of them referred to a similar create statement causing this error. Thank you very much for all your help. -- Rodney ERROR 1064 at line 1: You have an error in your SQL syntax near 'NOT NULL PRIMARY KEY, first_name CHAR(30), middle_name CHAR(30), last_name CH' at line 3 CREATE TABLE students ( student_id VARCHAR NOT NULL PRIMARY KEY, first_name CHAR(30), middle_name CHAR(30), last_name CHAR(30), email_address VARCHAR, website VARCHAR, phone_number VARCHAR, address1 VARCHAR, address2 VARCHAR, city VARCHAR, state VARCHAR, zip VARCHAR, country VARCHAR, INDEX (last_name, first_name) ) - 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.35 is released
On Sat, Mar 17, 2001 at 12:53:50PM -0800, Patrick Calkins wrote: Hello all; Sorry to sound a little naive, but what is this new GEMINI thing I have been reading about? Is there any FAQ/Docs on it or what is so neet about it?? It is a new table handler which is being developed by the folks at NuSphere (www.nusphere.com). Like the new Innobase table handler it offers row-level locking, transactions, and lots of other goodies. Very soon you'll be able to choose from 6 different table types in your MySQL applications: ISAM MyISAM HEAP BDB Innobase Gemini 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
Looking for only unique records
I want to know if it is possible to build a MySQL query which will only return the unique values of a specific column. Ie if I had this table: id | name |date___ 1 | Jon | 2001-01-03 2 | Bob | 2001-01-04 3 | Jon | 2001-01-05 Is there any SQL query that will only return 1 row for each value in the name column, or would I have to do that in PHP? Jon === And shepards we shall be For thee, my lord, for thee For thou hath descended forth from thy hands That our feats may swiftly carry out thy command We will flow a river forth unto thee And teaming with souls shall it ever be... === http://jcampbell.blacklightning.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
Looking only for uniqueness
I want to know if it is possible to build a MySQL query which will only return the unique values of a specific column. Ie if I had this table: id | name |date___ 1 | Jon | 2001-01-03 2 | Bob | 2001-01-04 3 | Jon | 2001-01-05 Is there any SQL query that will only return 1 row for each value in the name column, or would I have to do that in 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: Looking for only unique records
On 22-Dec-00 JCampbell wrote: (get ready for it, big 21st century party is coming up) I want to know if it is possible to build a MySQL query which will only return the unique values of a specific column. Ie if I had this table: id | name |date___ 1 | Jon | 2001-01-03 2 | Bob | 2001-01-04 3 | Jon | 2001-01-05 Is there any SQL query that will only return 1 row for each value in the name column, or would I have to do that in PHP? 'Jon' 'Bob' are distinct elements; and then Jon,2001-01-03 Bob,2001-01-04 Jon,2001-01-05 are also distinct elements. You might be looking for a "group by", "distinct", or "left join ... is null" What do you call 'unique' ? Regards, -- Don Read [EMAIL PROTECTED] -- If you are going to sin, sin against God, not the bureaucracy. God will forgive you but the bureaucrats won't. - 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
Install Help... re: RPM
I have recently installed MySQL-server-version-3.23.35.rpm on my cobalt raq4... The install documents state that the rpm will install into the /var/lib folder... I ran the install but can't seen to locate where the files were installed? Any help is appreciated. Thanks, Greg - 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: Syntax check
On 18-Mar-01 Rodney J. Woodruff wrote: Can someone look at this syntax and tell me what is wrong with it. Any and all help is appreciated. I worked with several databases and have never had any trouble writing CREATE statements in the past. I get the following error when I run this create statement. So what is wrong with my syntax. I found this same error when I searched the list but none of them referred to a similar create statement causing this error. Thank you very much for all your help. -- Rodney ERROR 1064 at line 1: You have an error in your SQL syntax near 'NOT NULL PRIMARY KEY, first_name CHAR(30), middle_name CHAR(30), last_name CH' at line 3 CREATE TABLE students ( student_id VARCHAR NOT NULL PRIMARY KEY, how big a varchar ? first_name CHAR(30), this is worthless (see *Note Silent column changes) email_address VARCHAR, as above. Before posting, please check: http://www.mysql.com/manual.php (the manual) Regards, -- Don Read [EMAIL PROTECTED] -- If you are going to sin, sin against God, not the bureaucracy. God will forgive you but the bureaucrats won't. - 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
Remote connection protocol
I'm trying to use a remote telnet connection to access a mysql server. Anyone know where I could find protocols to connect to a mysql server, with telnet? Thanks. Bob Feldbauer [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
RES: En:Fw: [BQ75] Fwd: Re: LER COM URGÊNCIA (fwd)
-Mensagem original- De: Vagno A.G. [mailto:[EMAIL PROTECTED]] Enviada em: Quinta-feira, 15 de Maro de 2001 16:08 Para: xeryus; WindowsMedia.com; Suede Vieira; RSNA 86TH SCIENTIFIC ASSEMBLY ANNUAL MEETING; [EMAIL PROTECTED]; Mark White; Marcelo Mendes; luiz augusto borba de oliveira; luiael; Lins Caio; Harpia Integracao e Tecnologia; grili.vvc; Elizabeth; [EMAIL PROTECTED]; Anthony Caprio; [EMAIL PROTECTED]; [EMAIL PROTECTED]; Adriano Borlini Assunto: En: En:Fw: [BQ75] Fwd: Re: LER COM URGNCIA (fwd) - Original Message - From: walkiriocosta To: Srgio floripa Cc: adrianovarig ; berg ; beto ; emilson ; fenix ; jacira ; junior ; marcelao ; vagno ; zeus Sent: Sunday, March 11, 2001 6:43 PM Subject: En:Fw: [BQ75] Fwd: Re: LER COM URGNCIA (fwd) E-mail grtis BOL com antivrus! Faa j o seu! http://www.bol.com.br __ E-mail grtis BOL com antivrus! Faa j o seu! http://www.bol.com.br -- - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, March 08, 2001 6:32 PM Subject: En: [BQ75] Fwd: Re: LER COM URGNCIA (fwd) -Mensagem Original- De: roberto salvucci Para: [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] Enviada em: quarta-feira, 7 de maro de 2001 09:19 Assunto: [BQ75] Fwd: Re: LER COM URGNCIA From: "Roberto Salvucci" Subject: Re: LER COM URGNCIA Date: Tue, 6 Mar 2001 20:49:24 -0300 ACABEI DE RECEBER. NO TEMOS NADA A PEDER. Prezados e queridos amigos, Leiam esta carta e ajam rapidamente. Estou enviando esta carta para vocs porque recebi informao por parte de um profissional e amigo. A MICROSOFT e a AOL (America On Line), atualmente as duas maiores empresas da Internet, para garantir ao Internet Explorer a posio de programa de navegao mais usado, esto testando uma verso beta do programa. Ao enviar esta carta aos seus amigos, ela ser conferida pela MICROSOFT ( preciso que os seus amigos usem o Microsoft Windows) ao longo de duas semanas. A MICROSOFT pagar U$ 245 para cada pessoa a qual vocs enviarem esta carta. A MICROSOFT pagar vocs U$ 243 para cada carta forwardada e pagar U$ 241 para cada terceira pessoa a qual vocs enviarem esta comunicao. Daqui a duas semanas a MICROSOFT entrar em contato com vocs via e-mail e lhes despachar o cheque. No incio eu duvidei... at que depois de duas semanas recebi via e-mail a comunicao e, poucos dias a seguir, o cheque de U$ 24.800. Vocs devem enviar esta comunicao imediatamente, antes que termine o prazo do teste da verso beta da Internet Explorer. Quem banca tudo isso o senhor Bill Gates. -- -- Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. --- UOL: o melhor da Internet. -- -Mensagem Original- De: roberto salvucci Para: [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] Enviada em: quarta-feira, 7 de maro de 2001 09:19 Assunto: [BQ75] Fwd: Re: LER COM URGNCIA From: "Roberto Salvucci" Subject: Re: LER COM URGNCIA Date: Tue, 6 Mar 2001 20:49:24 -0300 ACABEI DE RECEBER. NO TEMOS NADA A PEDER. Prezados e queridos amigos, Leiam esta carta e ajam rapidamente. Estou enviando esta carta para vocs porque recebi informao por parte de um profissional e amigo. A MICROSOFT e a AOL (America On Line), atualmente as duas maiores empresas da Internet, para garantir ao Internet Explorer a posio de programa de navegao mais usado, esto testando uma verso beta do programa. Ao enviar esta carta aos
Add password to a existing database/table
Hi, I am a newbie in Mysql and is confused about setting login/passwords. Just want a simple security measure as I am the only user. Here's the scenario: I managed to connect using PHP to mysql via the mysql_connect without using any hostname/password. What do I change to impose this security measure. The hostname and password will be keep in a *.inc file outside the web root directory. Thanks Nyon - 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: join from two different databases
I just started using MySQL, so I can't confirm this, but if it is really not possible, maybe someone could consider implementing something like Oracle's database links ? It might be a good thing for the beer industry ;-) Only a suggestion... Marc Op Sunday 18 March 2001 01:10 kon c.smart het niet nalaten op te merken: Sorry, No Green Beer, No can do that ;-) Richard Reina wrote: I am try to do a join with tables that are in two different databases. I thing I've got the actual SQL syntax down: my $q = "SELECT i.inv_no, i.inv_date, c.cust_name FROM receivables.invoice i, sales.customer c, WHERE i.paid_date IS NULL"; but I am confused on how to prepare and execute it, since my database handle ($dbh) specifies only 1 database. Any help would get me out of the office on St. Pats day and in fron tof a bar maid serving green beer. Please help make my day. - 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
Reverse of the string function --- SUBSTRING_INDEX
Hi there ! I wanna know if the reverse of the function SUBSTRING_INDEX exists or not. --DESCRIPTION--- == SUBSTRING_INDEX(str,delim,count) Returns the substring from string str before count occurrences of the delimiter delim. If count is positive, everything to the left of the final delimiter (counting from the left) is returned. If count is negative, everything to the right of the final delimiter (counting from the right) is returned: --MY NEED-- == Now if i have the "str" (string) and the "delim" (delimiter), how can i know the "count" (Number of occurences) ?!? Many thanks for your support. - 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