INSERT query crashes MySQL
This morning our MySQL exited for no good reason! mysql.err: 021020 17:25:53 021020 17: 021022 18:20:16 mysqld ended mysql.log: 021022 18:20:09 243748 Connect mysql_user@localhost on 243748 Init DB mydb 243749 Connect [EMAIL PROTECTED] on 243749 Init DB mydb 243748 Quit 243749 Query INSERT INTO IDRefs VALUES('5136110c98b89de5d389df0754182ff2','','',NOW(),'Not available','','') When I logged into mysql manually, there was an error relating to the IDRefs table, (can't remember exactly but it was something like Cannot get data of table structure - I was in a rush to get things up and running!). I deleted the contents of this table and used OPTIMIZE and it has worked OK since then. However, a similar crash occured on Sunday, but I didn't investigate it fully. So, why is this INSERT query causing MySQL to crash? The table it uses is the one that keeps track of users and their shopping bag (online web ordering facility). There was plenty of disk space on the server, Solaris 2.7, using mysql 3.23.51. Thanks for any advice John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Commands out of sync using PHP
Hi, The problem comes from PHP : http://bugs.php.net/bug.php?id=19529 Regards, Jocelyn - Original Message - From: Willem Bison [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 11:06 AM Subject: Commands out of sync using PHP I'm getting lots of random Commands out of sync; You can't run this command now errors when calling mysql_query(). I'm pretty sure this has started after upgrading to PHP 4.2.3. The only way to stop it is restarting apache. I can't see any pattern in the errors: it happens on different tables, long/slow queries etc. Once the error starts occuring, it happens with about 1/3 of all queries. mysql client api: 3.23.39 mysql server: 3.23.44 apache 1.3.26 php: 4.2.3 red-hat 7.3 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Import from files
Is it possible to update a field using SQL with the contents of a text file previoously written to disk? I want to update a mediumtext field with the contents of c:\data\mytext.txt file. update mytable set mymediumtext= filecontents where id=number... ? Alan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
subselect solution
Hi everyone, Im a new user on this list as well as Mysql. I use it with coldfusion My first problem is the following : I have a table where I created a timestamp column named date_creation When I try to execute this sql syntax it doesnt work ! select fname, lname, date_creation from tb_person where date_creation = (select max(date_creation) from tb_person) I know subselect is limited but what are alternatives solutions ? Thanks Sorry for my English Eric - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 4.04 configure
Hello I have download the MySQL 4.04 When i want to run the configure script, configure dont find my openssl. You have static set the search Path for openssl, this is not good :-( Can you change the configure script that the user can, set the path ? Exapmle: ./configure --with-openssl=/opt/openssl-0.9.6g Another Problem is to uncompress the tar archiv under Solaris. The Solaris tar can not extract the archiv without errors, the gnu tar runs fine Greetings from Germany Frank Beckmann -- Frank Beckmann Abt. TOIU Tel: 0211 533-5758 Fax: 0211 533-1451 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
[Fwd: 3rd Attempt: Fwd: Access Denied (1045)]]
Any thoughts with regards to the problem outlined below would be appreciated! Thank You, Anthony Original Message Subject: 2nd Attempt: Fwd: Access Denied (1045)] Date: Fri, 18 Oct 2002 06:59:21 -0400 From: Anthony W. Marino [EMAIL PROTECTED] To: [EMAIL PROTECTED] I'm boxed in a corner and would appreciate some suggestions, please! Thank You, Anthony Original Message Subject: Access Denied (1045) Date: Tue, 15 Oct 2002 08:47:05 -0400 From: Anthony W. Marino To: [EMAIL PROTECTED] Ive searched about and still haven't been able to resolve my problem. Scenario: 1) OS is RH 7.3. 2) Installing MySQL 4.04-Pro binary tarball. 3) Ordinary user, userX.grpX, is installing tarball themselves on a shared server accessed via telnet. 4) This installation will be userX's instance only, however, there are other MySQL server's running at this site. 5) All directories/files for this installation/implementation are owned by userX.grpX who has non-root access. 6) Modified my.cnf with unique values including port, socket, bind-address, relevant paths and values so as not to step on other installations/implentations. 7) my.cnf is passed through mysqld_safe using --defaults-file= option. 8) mysql_installdb is run. 9) mysql.server is run. Results: 1) mysqld runs with the following log snippets: Error Log: Warning: One can only use the --user switch if running as root. mysqld Log: /unique-path-to-userX-installed-mysql/bin/mysqld, Version: 4.0.4-beta-log, started with: Tcp port: 3307 Unix socket: /unique-path-to-userX-area/temp/mysql.sock 2) When the user tries to run mysql, mysqladmin and etc the following error message is received: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO). Please note that no passwords have been setup as of yet because we can't get pass the access issue. Thank You In Advance! Anthony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail To unsubscribe, e-mail Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RedHat 8 and mysql-server-3.23.52-3
Hi Iikka, My opinion: Doesn't matter what type of client it is(whatever OS).TCP/IP it's the same for all.One property of the SERVER it to resolving hosts.And this is done by using KERNEL functions.By adding in hosts file(in the SERVER MACHINE) the IP address of the client machine which want to connect to the SERVER, help SERVER for resolving the hostname.KERNEL make a lookup to the hostnames which is associate with the IP address. For using this functions IS NEED TO HAVE the properly system call library which is(in this case) GLIBC.2.2.40.If some incompatibilities(BUGS) exists between this, a lot of problems can be raised after compilation.For this reason EGOR send a strongly message to all to make a downgrade to a version of glibc which is stable. Personally, i can't do that because i have installed and others applications which require this version(2.2.40) of glibc.For me was a compromised solution because i use Red Hat 8.0 and MySQL 4.0.4 for testing purpose.My applications run under Suse 7.x with MySQL 3.x (MyISAM). The problem was for who which make have installed MySQL from Source Distribution or Red Hat distribution. I hope you understand exactly what i try to say.Unfortunately (for me),my english is not so good . Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Iikka Meriläinen [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 9:25 AM Subject: Re: RedHat 8 and mysql-server-3.23.52-3 On Tue, 22 Oct 2002, Gelu Gogancea wrote: Hi, No.On the server machine.The hosts is the way for resolving hostnames.In other Unix system, like SCO, to put the IP address and the alias in hosts is indispensable. Well, I meant that the client machine in this case seems to be a *NIX, so the /etc/hosts of _that_ machine should be updated. Of course, depending on where the error comes from. In this case it seems to be on the client side - although the client computer seems to be running Unix. Iikka - Original Message - From: Iikka Meriläinen [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 3:01 PM Subject: Re: RedHat 8 and mysql-server-3.23.52-3 On Tue, 22 Oct 2002, Gelu Gogancea wrote: Hi, Try to put in the /etc/hosts the IP address of the machine which must connect to the server. Hi! I guess you mean the /etc/hosts on the client machine? Right? Also, updating your real DNS records might prove useful in the long run. Best regards, Iikka I have recently installed RedHat 8 and the following RPMs: [root@chimp etc]# rpm -q mysql mysql-3.23.52-3 [root@chimp etc]# rpm -q mysql-server mysql-server-3.23.52-3 I am having problems connecting to the server remotely through the TCP connection, the firewall is completely disabled: njc2@hilton njc2/mysql/bin mysqladmin -h chimp.battlemonkey.net -p version Enter password: mysqladmin: connect to server at 'chimp.battlemonkey.net' failed error: 'Lost connection to MySQL server during query' I can connect fine from the localhost to the socket: [root@chimp etc]# mysqladmin version -p Enter password: mysqladmin Ver 8.23 Distrib 3.23.52, 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.52-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 2 min 21 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.007 This is the first part of /etc/my.cnf. [client] #password = your_password port= 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port= 3306 socket = /var/lib/mysql/mysql.sock skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= table_cache=64 set-variable= sort_buffer=512K set-variable= net_buffer_length=8K set-variable= myisam_sort_buffer_size=8M log-bin server-id = 1 Could it be something to do with the startup/stop script because I noticed something else odd. The script works for starting the daemon: [root@chimp etc]# /sbin/service mysqld start Starting MySQL:[ OK ] But not for stopping it: [root@chimp etc]#
Remote Connectivity
Hi, I have MySQL 3.23.36 on my web server somewhere in Canada, while I live in Pakistan. I want to connetc to my database out there and use a query to download all the data from that mysql db to my own mysql db. I know myql uses 3306 as the port and when i try telnet on my own LAN it works fine, but out there it is not responding. Any help would be great, Schajee __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.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: subselect solution
Eric Guesdon wrote: Hi everyone, Im a new user on this list as well as Mysql. I use it with coldfusion My first problem is the following : I have a table where I created a timestamp column named date_creation When I try to execute this sql syntax it doesnt work ! select fname, lname, date_creation from tb_person where date_creation = (select max(date_creation) from tb_person) I know subselect is limited but what are alternatives solutions ? Thanks Sorry for my English Eric Hi, You should try: select fname, lname, date_creation from tb_person order by date_creation desc limit 1; and look at : http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html for other examples. Regards, Joseph Bueno - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: RedHat 8 and mysql-server-3.23.52-3
Hi! On Wed, 23 Oct 2002, Gelu Gogancea wrote: Hi Iikka, My opinion: Doesn't matter what type of client it is(whatever OS).TCP/IP it's the same for all.One property of the SERVER it to resolving hosts.And this is done by IP-hostname mapping/resolving is usually done by DNS servers, not the MySQL server, assuming that they're not running on the same box. :-) There are several ways for resolving addresses. using KERNEL functions.By adding in hosts file(in the SERVER MACHINE) the IP address of the client machine which want to connect to the SERVER, help SERVER for resolving the hostname.KERNEL make a lookup to the hostnames which is associate with the IP address. AFAIK, IP-to-hostname mapping isn't done by _kernel_ functions. At least the Linux kernel knows very little about hostnames. Some exotic Unixes may implement this differently, but no operating system I'm aware of has kernel interfaces for name resolution. Making the server recognize the client correctly with an updated /etc/hosts seems logical enough. It's strange, though, to have to make changes on the server for clients to be able to connect. For using this functions IS NEED TO HAVE the properly system call library which is(in this case) GLIBC.2.2.40.If some incompatibilities(BUGS) exists between this, a lot of problems can be raised after compilation.For this reason EGOR send a strongly message to all to make a downgrade to a version of glibc which is stable. Here you get it right. glibc is much more responsible for ip-hostname-mapping than the operating system kernel itself. Kernel implements the IP protocol with dotted-format addresses, and it expects user-mode libraries to do any necessary conversions. That is, when you do this: ping www.google.com the ping binary calls a couple of conversion functions in user-mode libraries so that it can pass a real IP address to the kernel/protocol interface. Personally, i can't do that because i have installed and others applications which require this version(2.2.40) of glibc.For me was a compromised solution because i use Red Hat 8.0 and MySQL 4.0.4 for testing purpose.My applications run under Suse 7.x with MySQL 3.x (MyISAM). The problem was for who which make have installed MySQL from Source Distribution or Red Hat distribution. I hope you understand exactly what i try to say.Unfortunately (for me),my english is not so good . Yep, I saw it. :-) But got your point anyway though. Best regards, Iikka - Original Message - From: Iikka Meriläinen [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 9:25 AM Subject: Re: RedHat 8 and mysql-server-3.23.52-3 On Tue, 22 Oct 2002, Gelu Gogancea wrote: Hi, No.On the server machine.The hosts is the way for resolving hostnames.In other Unix system, like SCO, to put the IP address and the alias in hosts is indispensable. Well, I meant that the client machine in this case seems to be a *NIX, so the /etc/hosts of _that_ machine should be updated. Of course, depending on where the error comes from. In this case it seems to be on the client side - although the client computer seems to be running Unix. Iikka - Original Message - From: Iikka Meriläinen [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 3:01 PM Subject: Re: RedHat 8 and mysql-server-3.23.52-3 On Tue, 22 Oct 2002, Gelu Gogancea wrote: Hi, Try to put in the /etc/hosts the IP address of the machine which must connect to the server. Hi! I guess you mean the /etc/hosts on the client machine? Right? Also, updating your real DNS records might prove useful in the long run. Best regards, Iikka I have recently installed RedHat 8 and the following RPMs: [root@chimp etc]# rpm -q mysql mysql-3.23.52-3 [root@chimp etc]# rpm -q mysql-server mysql-server-3.23.52-3 I am having problems connecting to the server remotely through the TCP connection, the firewall is completely disabled: njc2@hilton njc2/mysql/bin mysqladmin -h chimp.battlemonkey.net -p version Enter password: mysqladmin: connect to server at 'chimp.battlemonkey.net' failed error: 'Lost connection to MySQL server during query' I can connect fine from the localhost to the socket: [root@chimp etc]# mysqladmin version -p Enter password: mysqladmin Ver 8.23 Distrib 3.23.52, 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.52-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock
RE: Remote Connectivity
Well, you could have the Canadian admin add your pakistan IP address/host to the mysql database in the hosts table, along with the proper user and db I'm sure. Then you can use any 3rd party mySQL client to connect and do whatever you want. Something I just did recently is to install phpMyAdmin (http://www.phpmyadmin.net/) on the remote (canadian) server and use the built in export feature. This feature is incredibly slick, it even automatically .zip or .tgz the file for you and pushes it to you! The compressed version is significantly smaller than the full version of the .sql file. Then you simply login to your local mysql database (whichever you choose) using the 'mysql' command line client and use the \. option to create the tables and all the data in one go from the unarchived .sql file you just created. It worked flawlessly for me. The other option is to have your ISP send (email/ftp) all the /var/lib/mysql/mydatabase files (archived I assume), put them in the same dir on your server, and restart mysqld. I have MySQL 3.23.36 on my web server somewhere in Canada, while I live in Pakistan. I want to connetc to my database out there and use a query to download all the data from that mysql db to my own mysql db. I know myql uses 3306 as the port and when i try telnet on my own LAN it works fine, but out there it is not responding. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: bin files
James, Wednesday, October 23, 2002, 1:12:34 PM, you wrote: JT I've been using mysql for a while now, but haven't yet been able to figure JT out what the JT domainname-bin.001, .002, .003, etc. files are listed in the /var JT directory. They seem to get completely out of control sometimes (I usually JT go through and delete them daily - after deleting and re-creating about 4 JT million entries, there were 3 bin files totalling almost 3 gigs...) JT What are these files exactly (i always figured they were some sort of log), JT why do they get so out of control with disk space, and is there any way i JT can get rid of them. thanks! It's a binary log files: http://www.mysql.com/doc/en/Binary_log.html If you don't have binary update logs, you can just run MySQL server without --log-bin option. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Import from files
Alan, Wednesday, October 23, 2002, 2:06:05 PM, you wrote: AM Is it possible to update a field using SQL with the contents of a text file AM previoously written to disk? AM I want to update a mediumtext field with the contents of c:\data\mytext.txt AM file. AM update mytable set mymediumtext= filecontents where id=number... ? UPDATE mytable SET mymediumtext=LOAD_FILE('c:\data\mytext.txt') ... You can find desription of LOAD_FILE() function here: http://www.mysql.com/doc/en/String_functions.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: odbc connect problem
Liu, Wednesday, October 23, 2002, 11:03:16 AM, you wrote: LQq I installed myodbc on windows and want to connect mysql with odbc, but something is wrong. System indicated: MySQL ODBC 3.51 DRIVER :03.51.02 LQq [MySql][ODBC 3.51 Driver]Host ' ' is not allowed to connect to this MySQL server. LQq What do I to fix the issue? Thanks a lot. Set up needed permissions: http://www.mysql.com/doc/en/Access_denied.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: INSERT query crashes MySQL
John, Wednesday, October 23, 2002, 1:17:54 PM, you wrote: JP This morning our MySQL exited for no good reason! JP mysql.err: JP 021020 17:25:53 JP 021020 17: JP 021022 18:20:16 mysqld ended JP mysql.log: JP 021022 18:20:09 JP 243748 Connect mysql_user@localhost on JP 243748 Init DB mydb JP 243749 Connect [EMAIL PROTECTED] on JP 243749 Init DB mydb JP 243748 Quit JP 243749 Query INSERT INTO IDRefs JP VALUES('5136110c98b89de5d389df0754182ff2','','',NOW(),'Not available','','') JP When I logged into mysql manually, there was an error relating to the IDRefs JP table, (can't remember exactly but it was something like Cannot get data of JP table structure - I was in a rush to get things up and running!). I deleted JP the contents of this table and used OPTIMIZE and it has worked OK since JP then. JP However, a similar crash occured on Sunday, but I didn't investigate it JP fully. So, why is this INSERT query causing MySQL to crash? The table it JP uses is the one that keeps track of users and their shopping bag (online web JP ordering facility). JP There was plenty of disk space on the server, Solaris 2.7, using mysql JP 3.23.51. MySQL server always crashes on this query? What is the structure of the table IDRefs? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: my.cnf settings and running admin commands such as mysqldump or m
David, Wednesday, October 23, 2002, 12:23:36 AM, you wrote: DK I was wondering if someone could shed some light on setting parameters in DK my.cnf. When I set params such as user and password in my my.cnf file I DK dont need to then pass these parameters to commands such as mysqldump or DK mysqladmin? Is this True? Can someone please send me an example of their DK my.cnf file, Im just curious what a real example would look like. I have DK already read through the my.cnf documentation on the website, but if someone DK has a better place for online doc on the config file please let me know. DK Any other insight is more than welcome and appreciated. For mysqldump you create a section [mysqldump] in the my.cnf where you can specify mysqldump options like [mysqld] . [mysqldump] user=Victoria password=mypassword -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: beginner's question - cannot connect with database
Sistertech, Wednesday, October 23, 2002, 4:11:31 AM, you wrote: S I'm trying to host a discussion forum for my philosophy class...to make a long story short: S I've now got phpBB2 and MySQL on my virtual domain. S My host doesn't offer any MySQL support. I'm installing phpBB and S I receive an error critical error: cannot connect with database. S All the fields appear to be correct (DB name, server, passwords, phpBB__, etc.) S I've search archives and can't find anything that specifically addresses my issue S AND one that compensates for the fact that I've **never used MySQL or done S any programming**. S I've given full permissions to everything (the folder where phpBb is located, cgi-bin, config.php). S It appears that the database is working (status is OK) although I don't know how to run a test query S (or if such a thing is possible without *any* data or tables in the DB. S Question: I need internet access to a beginner's guide that can help me. S The MySQL FAQ and Manual assume far too much background in programming to be of much help. S An e-book or online tutorial (for pay is fine) is better now than a book, although I'll get one, too. There are some articles at: http://www.mysql.com/articles/index.html Hope that helps. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: subselect solution
Eric, Wednesday, October 23, 2002, 2:06:30 PM, you wrote: EG Im a new user on this list as well as Mysql. EG EG I use it with coldfusion EG EG My first problem is the following : EG EG I have a table where I created a timestamp column named EG date_creation EG EG When I try to execute this sql syntax it doesnt work ! EG EG select fname, lname, date_creation EGfrom tb_person EGwhere date_creation = (select max(date_creation) from tb_person) EG EG I know subselect is limited but what are alternatives EG solutions ? Manual is a very useful thing :-) Here is an exact example for you: http://www.mysql.com/doc/en/example-Maximum-row.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Re: problem upgrading
Lance, Wednesday, October 23, 2002, 3:23:10 AM, you wrote: LU I have /tmp symlinked to /var/tmp, and /var is a writable partition, while / LU is readonly. When / is readonly mysqld is not able to run. LU I've tracked down the problem to the safe_mysqld script. The problem is it LU does: LU USER_OPTION= LU if test -w / LU then LU if test $user != root -o $SET_USER = 1 LU then LU USER_OPTION=--user=$user LU fi LU So if / is not writable then my --user argument gets blown away. Yikes. LU I believe this is a bug. If anyone knows why it's like this please let me LU know. Until then I'll be patching my system so I can continue running... If I got you right, then /usr is readonly, too. In this case hardly you can run your FreeBSD box -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bug with Query in MySQL 4.0.4/RedHat 8.0
[EMAIL PROTECTED] wrote: Description: This query produces 16 results: SELECT * FROM table1 LEFT JOIN table2 ON (field1 = field2) WHERE field2 = 'something' ORDER BY field2,field3,field4 But this query produces 0 results: SELECT * FROM table1 LEFT JOIN table2 ON (field1 = field2) WHERE field2 = 'something' ORDER BY field2,field3,field4 LIMIT 400; I can also get the correct results set by removing the ORDER BY clause. One other note. This same query works fine with MySQL 3.23.48. -m -- ## Mark T. Dame, Vice President, Internet Operations ## MFM Communication Software: http://www.mfm.com/ ## E-mail: mailto:mdame;mfm.com WWW: http://www.mfm.com/~mdame/ ...Every morning is the dawn of a new error... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: INSERT query crashes MySQL
JP 021022 18:20:16 mysqld ended JP 243749 Query INSERT INTO IDRefs JP VALUES('5136110c98b89de5d389df0754182ff2','','',NOW(),'Not available','','') MySQL server always crashes on this query? What is the structure of the table IDRefs? Not always, just a few times in the last few days (but it is probably the most common query that MySQL does on this machine) +---+---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+---+--+-+-+---+ | ID| varchar(255) | YES | | NULL| | | UserID| varchar(50) | YES | | NULL| | | Password | varchar(50) | YES | | NULL| | | Time | timestamp(14) | YES | | NULL| | | Reference | varchar(50) | YES | | NULL| | | Other | varchar(50) | YES | | NULL| | | SplashRef | varchar(50) | YES | | NULL| | +---+---+--+-+-+---+ 7 rows in set (0.00 sec) Thanks John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 : millseconds
Hi, Thanks for all to help me solve my subselect problem. An other question about date / time type Is there any possibilitie to include milliseconds in a date / time column Thanks, Eric -Message d'origine- De : [EMAIL PROTECTED] [mailto:mysql;lists.mysql.com] Envoyé : mercredi 23 octobre 2002 16:35 À : Eric Guesdon Objet : Re: millseconds Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hi, =A0 Thanks for all help me to solve my subselect problem. =A0 An other question, always about date type. =A0 Is there a way to insert milliseconds in a date /=A0 time columns =A0 Thanks =A0 Eric - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: sql problem
It looks like you're missing a comma in your SQL statement in between placeOfBirth and civilStatus. Good Luck! Dennis - Original Message - From: Mylin Campos [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 2:13 AM Subject: sql problem Hi all, I just wanted to know if you guys can help me out with this error. It's actually an sql and jdbc error. I have a class called employeeDBUtil. In this class, it has a method called updateEmployee. I wanted to try if the code would work so I created a main portion in my class. java.sql.SQLException: Syntax error or access violation: You have an error in your SQL syntax near 'eMName='Fabio', bDay = '03-14-63', placeOfBirth='manila' civilStatus= 'married' at line 1 at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497) at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550) at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:882) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815) at org.gjt.mm.mysql.Statement.executeUpdate(Statement.java:227) at org.gjt.mm.mysql.jdbc2.Statement.executeUpdateStatement.java:97) at com.ccp.hrmdpayroll.employee.EmployeeDBUtil.updateEmployee(EmployeeDBUtil.ja va:161) at com.ccp.hrmdpayroll.employee.EmployeeDBUtil.main(EmployeeDBUtil.java:731) Would anyone know how to solve this? lyn _ Get faster connections -- switch to MSN Internet Access! http://resourcecenter.msn.com/access/plans/default.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 replication error
i get the following error in the connection slave-master while setting up a replication between two MySQLServer(slave and master both windows XP): .err file on slave: MySql: ready for connections 021023 14:08:34 InnoDB: Started 021023 14:08:35 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 021023 14:08:35 Error updating slave list: Query error 021023 14:08:35 Slave I/O thread exiting, read up to log 'FIRST', position 4 what does it mean? My.ini on Master: log-bin=C:\Programmi\MySQL\Logs\MySQL-bin server-id=1 My.ini on Slave: master-host=192.168.0.4 master-user=repl master-password=password master-port=3306 server-id=2 set-variable = slave_net_timeout=3600 set-variable = net_read_timeout=3600 Show master status: File : MySQL-bin.001 Position : 79 Binlog_do_db : Binlog_inogne_db : ERROR No query specified Show Slave status: Master_Host : 192.168.0.04 Master_User : repl Master_Port : 3306 Connect_retry: 60 Master_Log_File : Read_Master_Log_Pos : 4 Relay_Log_File : MySQL-relay-bin.002 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running : Yes Slave_SQL_Running: Yes Replicate_do_db : Replicate_ignore_db : Last_errno : 0 Last_error : Skip_counter : 0 Exec_master_log_pos : 0 Relay_log_space : 0 ERROR: No query specified What is wrong? Why do I get the error No query specified? Which type of query should I specify? Thanks in advance. Natale Babbo __ Mio Yahoo!: personalizza Yahoo! come piace a te http://it.yahoo.com/mail_it/foot/?http://it.my.yahoo.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: insert into CHAR() column using KOI8-R charset
Andrew, Tuesday, October 22, 2002, 11:27:06 PM, you wrote: AS I setup server (my.ini/my.cnf) with AS default-character-set = koi8_ru AS Than do 'myisamchk -r -q' AS It seems to use correct charset. AS i do: AS 1.it's ok: AS INSERT INTO allg AS (znum_allg,name) VALUES (20,À) AS 2.it's error with AS INSERT INTO allg (znum_allg,name) VALUES (20,Á) AS error: Duplicate entry 'À' for key 2 AS bug is presented on 3.23.37 (linux) and 3.23.51 (windows) throu AS webpage submit and direct insert. 1. Check that there are no duplicates :) 2. If no, could you provide some data for testing? I couldn't repeat it on my test data .. What was the previous default-character-set? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: RE : millseconds
Eric, Wednesday, October 23, 2002, 3:45:34 PM, you wrote: EG Thanks for all to help me solve my subselect problem. EG An other question about date / time type EG Is there any possibilitie to include milliseconds in a date / time EG column Nope. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Re: RedHat 8 and mysql-server-3.23.52-3
Terra, Wednesday, October 23, 2002, 1:08:34 AM, you wrote: TI Got it. It is --skip-name-resolve and that worked around the problem. TI What should I be on the lookout for to get a real fix? Will there be a TI patch/update/etc for glibc from RH or is there something that the mysql TI dev team is coming up with? Yes, RedHat knows about this problem and they investigate it. Please, check also the mailing list archive: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:122632 TI Egor Egorov wrote: Terra, Tuesday, October 22, 2002, 1:44:45 PM, you wrote: TI I have a RH 7.1 system that is fully patched and it happens to me as TI well. What is the fix? I am using RH provided binary RPMs so am at TI mysql-server-3.23.36-1 . Temporary solutions: - downgrade glibc; - run nscd; - run MySQL server with --skip-name-resolving option -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RedHat8.0 and MySQL
Hi, dont know if this is old information, but: RedHat 8.0, MySQL 3.23.52. It works like a charm from the local machine, but when you try to connect by TCP, the active thread seg-faults. (strace on mysqld) The solution was to place the host I connect from in /etc/hosts. Voila, no more seg-faults.. I guess this is due to some oddity in RedHat 8.0, but I could not find this documentet anywhere. So now everybody knows.. Best regards Rolf Nilsen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [Fwd: 3rd Attempt: Fwd: Access Denied (1045)]]
Anthony W. Marino wrote: Any thoughts with regards to the problem outlined below would be appreciated! Thank You, Anthony Original Message Subject: 2nd Attempt: Fwd: Access Denied (1045)] Date: Fri, 18 Oct 2002 06:59:21 -0400 From: Anthony W. Marino [EMAIL PROTECTED] To: [EMAIL PROTECTED] I'm boxed in a corner and would appreciate some suggestions, please! Thank You, Anthony Original Message Subject: Access Denied (1045) Date: Tue, 15 Oct 2002 08:47:05 -0400 From: Anthony W. Marino To: [EMAIL PROTECTED] Ive searched about and still haven't been able to resolve my problem. Scenario: 1) OS is RH 7.3. 2) Installing MySQL 4.04-Pro binary tarball. 3) Ordinary user, userX.grpX, is installing tarball themselves on a shared server accessed via telnet. 4) This installation will be userX's instance only, however, there are other MySQL server's running at this site. 5) All directories/files for this installation/implementation are owned by userX.grpX who has non-root access. 6) Modified my.cnf with unique values including port, socket, bind-address, relevant paths and values so as not to step on other installations/implentations. 7) my.cnf is passed through mysqld_safe using --defaults-file= option. 8) mysql_installdb is run. 9) mysql.server is run. Results: 1) mysqld runs with the following log snippets: Error Log: Warning: One can only use the --user switch if running as root. mysqld Log: /unique-path-to-userX-installed-mysql/bin/mysqld, Version: 4.0.4-beta-log, started with: Tcp port: 3307 Unix socket: /unique-path-to-userX-area/temp/mysql.sock 2) When the user tries to run mysql, mysqladmin and etc the following error message is received: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO). Please note that no passwords have been setup as of yet because we can't get pass the access issue. Thank You In Advance! Anthony Did you specify the proper socket when connecting? Perhaps you are trying to connect to a server that DOES have a password set for root. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: lost connection inquery : ODBC
Petre, Tuesday, October 22, 2002, 9:18:27 PM, you wrote: PA Any known issues with RH8.0 and ODBC? PA I keep getting lost connection messages when trying to connect from a PA windows box to mysql, it worked 100% on a 7.3RH box. PA There is no firewall. PA Any workarounds? Lost connection you got _only_ if you connect from Win via ODBC? Or you also got it if you connect to the MySQL server from Win not using ODBC or from any other remote box? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
CPU size
One we know how much data we are going to store we can calculate HDD size. Then we look at the types of question we are going to use on the DB and combined with the size of data we now know how mush memory we should need. But how do I know what CPU I will need to run this? I know we need to look at what type of CPU (P,PII,PIII,PIII,AMG,XEON..etc) but there must be some rule of thumb for MySQL ? Simon PS have looked on web and mail list and can not find this :-( - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: problem upgrading
At 03:29 PM 10/23/02 +0300, Egor Egorov wrote: Lance, Wednesday, October 23, 2002, 3:23:10 AM, you wrote: LU I have /tmp symlinked to /var/tmp, and /var is a writable partition, while / LU is readonly. When / is readonly mysqld is not able to run. LU I've tracked down the problem to the safe_mysqld script. The problem is it LU does: LU USER_OPTION= LU if test -w / LU then LU if test $user != root -o $SET_USER = 1 LU then LU USER_OPTION=--user=$user LU fi LU So if / is not writable then my --user argument gets blown away. Yikes. LU I believe this is a bug. If anyone knows why it's like this please let me LU know. Until then I'll be patching my system so I can continue running... If I got you right, then /usr is readonly, too. In this case hardly you can run your FreeBSD box Yes. /usr is readonly too. This box is being run as a webserver, so once I setup the world there's no need for it to be writable. All data I need written goes in /var. -Lance - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 query crashes MySQL
Another error! PHP starts to output the error Too many references: cannot splice - error 144 When logging into mysql, I get: Didn't find any fields in table IDRefs started with -A, I get: cannot open file: IDRefs.MYD (error: 144) optimize table IDRefs; Can't open file: 'IDRefs.MYD'. (errno: 13) explain IDRefs; ERROR 1016: Can't open file: 'IDRefs.MYD'. (errno: 13) delete from IDRefs; Query OK, 0 rows affected (0.02 sec) explain IDRefs; OK etc (nothing in mysql.err) I have changed the query to INSERT DELAYED in case too many clients are locking the table, should I change it back? Cheers John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to join two tables in different server
MySQL, I like to have a query like this, select * from tableA left join tableB on. But tableA is in hostA, and tableB is in hostB. What I should do? I can use either PHP or python. Any ideas? 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
Rounding floats
Kenneth Hylton wrote something about SQL or QUERYs: I NEVER use float or double to store values like you appear to be doing. I always used DECIMAL so that they are stored as strings and you do not have problems associated with what you see here. I then have complete control over what is stored and the precision associated with it. FWIW, all of our financial database software stores values in either pennies or tenths of a cent, not dollars, to avoid decimals altogether. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[ANN] LP6 on Linux
Last week during Lasso Summit 2002, in addition to unveiling the MySQL list archives on ListSearch.com, Blue World announced the immediate availability of a beta version of its new Lasso Professional 6 (LP6) Web Data Engine running on Red Hat Linux. For those of you looking for a robust Web application server with *very* tight integration with MySQL which now runs on Linux, we cordially invite you to download and try a free evaluation of LP6 on Linux. LP6 contains a comprehensive Web-based GUI which makes it easy to build (schema and indices), browse (search, insert, update, delete, etc.) and maintain (backup, restore, monitor, repair, check, etc.) MySQL databases. Details on the announcement and links to download the beta are available at http://www.blueworld.com/blueworld/news/10.15.02-Linux.html. Cheers Bill -- - Bill Doerrfeld[EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.com/ - Build and serve powerful data-driven Web sites with Lasso Studio and Lasso Professional. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 query crashes MySQL
John, Error 144 that the table is crashed and the last repair failed. You should run a check and optimize on this table if possible. Error 13 indicates that you do not have permission to access the file. If you are the System Administrator you may want to check the file permissions. Otherwise, you will want to get in touch with the System Administrator. I hope this has been helpful. Victor -Original Message- From: John P To: [EMAIL PROTECTED] Sent: 10/23/02 9:21 AM Subject: Re: INSERT query crashes MySQL Another error! PHP starts to output the error Too many references: cannot splice - error 144 When logging into mysql, I get: Didn't find any fields in table IDRefs started with -A, I get: cannot open file: IDRefs.MYD (error: 144) optimize table IDRefs; Can't open file: 'IDRefs.MYD'. (errno: 13) explain IDRefs; ERROR 1016: Can't open file: 'IDRefs.MYD'. (errno: 13) delete from IDRefs; Query OK, 0 rows affected (0.02 sec) explain IDRefs; OK etc (nothing in mysql.err) I have changed the query to INSERT DELAYED in case too many clients are locking the table, should I change it back? Cheers John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: INSERT query crashes MySQL
perror 144 144 = Table crashed and last repair failed perror 13 Error code 13: Permission denied It looks to me like mysql does not own all the files, and can't repair the table. John P wrote: Another error! PHP starts to output the error Too many references: cannot splice - error 144 When logging into mysql, I get: Didn't find any fields in table IDRefs started with -A, I get: cannot open file: IDRefs.MYD (error: 144) optimize table IDRefs; Can't open file: 'IDRefs.MYD'. (errno: 13) explain IDRefs; ERROR 1016: Can't open file: 'IDRefs.MYD'. (errno: 13) delete from IDRefs; Query OK, 0 rows affected (0.02 sec) explain IDRefs; OK etc (nothing in mysql.err) I have changed the query to INSERT DELAYED in case too many clients are locking the table, should I change it back? Cheers John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: INSERT query crashes MySQL
Error 144 that the table is crashed and the last repair failed. You should run a check and optimize on this table if possible. Error 13 indicates that you do not have permission to access the file. If you are the System Administrator you may want to check the file permissions. Otherwise, you will want to get in touch with the System Administrator. Thanks Victor I had moved the tables to IDRefsOLD.* so I could look at them later if necessary, and copied them back - with my user login instead of the mysql:* user. That explains the error 13. What could cause the error 144? This particular table keeps getting corrupted, and I have no reason why. Cheers, John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: RedHat8.0 and MySQL
Rolf Nilsen wrote: Hi, dont know if this is old information, but: RedHat 8.0, MySQL 3.23.52. It works like a charm from the local machine, but when you try to connect by TCP, the active thread seg-faults. (strace on mysqld) The solution was to place the host I connect from in /etc/hosts. Voila, no more seg-faults.. I guess this is due to some oddity in RedHat 8.0, but I could not find this documentet anywhere. So now everybody knows.. Best regards Rolf Nilsen Yes it is old news, search the archives :) The issue is with the GLIBC that ships with RedHat-8.0, and the one that is updated by 'up2date'. We recommend you only use the binaries provided by MySQL AB, as they are statically linked with a custom GLIBC that prevents this problem (among others as well). -Mark -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to join two tables in different server
You can't do that. You will have to open two connections, and do nested loops to build your result set. Vivian Wang wrote: MySQL, I like to have a query like this, select * from tableA left join tableB on. But tableA is in hostA, and tableB is in hostB. What I should do? I can use either PHP or python. Any ideas? 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
Problem with select.
HI, I don't know is it bad or not but I face queries the work quite long time. the sql is : select * from log_answers_index limit 0,10 and it takes too much time for me to receive the result. I got indexes on most of the fields, i got primary key which is auto_increment int(11). When I did explain on the query I got this : type : ALL rows : 123010 all other cells are empty. When I do : select * from log_answers_index where log_entry_index between 1 and 10 i got type : range For me it is strange that the primary key is not used when there is LIMIT clause without WHERE one. Best regards Andrey Hristov - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Another bit off-topic question
I'm planning on using Win2k Adv. server, IIS, MYSQL, PHP on a dual processor 2.4GHz processor with 1 or 2GB RAM, with either SCSI or ATA HDs. The webpage will be dynamic. 1)How many concurrent connections would something like this handle? 2) Will it make a big difference if I use SCSI or ATA? Example SCSI 1000 conncetions, ATA 100 connections. Just want a ball park figure if there is a difference. 3) How much RAM do I need for 1000 conncurrent connections? 4) Should I use RAID 1 or 5? Will it make a big difference if I want 1000 concurrent connections? 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
Bit off topic
I am looking for an external drive case that will be connected to a Xeon server with SCSI (Ultra-160) interface. I want something like 6-12 drives. Anyone have any suggestions? I do not want to go with Dell, IBM, etc. They cost way too much. I just want one I can build. Thank you 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
help displaying results from a mysql query with php
Can someone please tell me what's wrong with the following code? This info is inside a function that I defined. One of the arguments that I pass the function is the actual query. Based on the info that I know is loaded in the database (it's a development database...there are only 2 rows of info), the query I define only returns two answers. In case you're wondering...the query works fine from within mysql, no problems there. The problem seems to lie in the loop construct. It displays the first record fine. But the second record comes up as an invalid index reference. Someone help... How do you all display your results? I know there is another while() that I've seen used, but I can't remember the syntax. And I'm new to this by the way... $result = mysql_query($query); $num_results = mysql_num_rows($result); if($num_results) { echo I have located .$num_results. results that match the information you provided.; } $i = 0; while($num_results $i) { $row = mysql_fetch_row($result); echo p . ($i + 1) . Display the queried info: ; echo htmlspecialchars( stripslashes($row[$i])); echo /p; $i++; } - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 join two tables in different server
At 9:41 -0500 10/23/02, gerald_clark wrote: You can't do that. You will have to open two connections, and do nested loops to build your result set. Or copy one table to the other server temporarily. This can be useful if you need to run a lot of joins between the tables. Vivian Wang wrote: MySQL, I like to have a query like this, select * from tableA left join tableB on. But tableA is in hostA, and tableB is in hostB. What I should do? I can use either PHP or python. Any ideas? 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: Problem with select.
Andrey Hristov wrote: HI, I don't know is it bad or not but I face queries the work quite long time. the sql is : select * from log_answers_index limit 0,10 and it takes too much time for me to receive the result. I got indexes on most of the fields, i got primary key which is auto_increment int(11). When I did explain on the query I got this : type : ALL rows : 123010 all other cells are empty. When I do : select * from log_answers_index where log_entry_index between 1 and 10 i got type : range For me it is strange that the primary key is not used when there is LIMIT What would be the point? Without a WHERE or an ORDER BY, using an index would slow it down. clause without WHERE one. Best regards Andrey Hristov - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: INSERT query crashes MySQL
John, Wednesday, October 23, 2002, 5:21:38 PM, you wrote: JP PHP starts to output the error Too many references: cannot splice - error JP 144 JP When logging into mysql, I get: JP Didn't find any fields in table IDRefs JP started with -A, I get: JP cannot open file: IDRefs.MYD (error: 144) $ perror 144 144 = Table is crashed and last repair failed Your table is corrupted, try to repair it with REPAIR TABLE or myisamchk: http://www.mysql.com/doc/en/Repair.html JP optimize table IDRefs; JP Can't open file: 'IDRefs.MYD'. (errno: 13) JP explain IDRefs; JP ERROR 1016: Can't open file: 'IDRefs.MYD'. (errno: 13) JP delete from IDRefs; JP Query OK, 0 rows affected (0.02 sec) JP explain IDRefs; JP OK JP etc JP (nothing in mysql.err) MySQL server doesn't have permissions on that file ... JP I have changed the query to INSERT DELAYED in case too many clients are JP locking the table, should I change it back? Did you install MySQL server from binary or from source? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: RedHat8.0 and MySQL
Rolf, Wednesday, October 23, 2002, 4:42:24 PM, you wrote: RN dont know if this is old information, but: RN RedHat 8.0, MySQL 3.23.52. RN It works like a charm from the local machine, but when you try to RN connect by TCP, the active thread seg-faults. RN (strace on mysqld) RN The solution was to place the host I connect from in /etc/hosts. Voila, RN no more seg-faults.. RN I guess this is due to some oddity in RedHat 8.0, but I could not find RN this documentet anywhere. So now RN everybody knows.. Yes, it's a known issue :-) There was a lot of similar reports in the mailing list last several days: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:122632 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: how to join two tables in different server
Vivian, Wednesday, October 23, 2002, 5:24:13 PM, you wrote: VW I like to have a query like this, VW select * from tableA left join tableB on. VW But tableA is in hostA, and tableB is in hostB. VW What I should do? I can use either PHP or python. VW Any ideas? Vivian, if your tables are located on different servers, you can't do it with MySQL. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: using special chars in table names
Beuserie, Tuesday, October 22, 2002, 8:15:33 PM, you wrote: BF i'm in process of migrating from a commercial dbms to mysql and BF have legacy tables referenced everywhere with names like 'tbl1#c' -- '#' is not accepted for table names and must be escaped to create BF one (but dissapeared from the table name then) BF is there a way to use such table names ? '#' means the beginning of comments: http://www.mysql.com/doc/en/Comments.html So, all data after '#' will be interpreted as comment. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bit off topic
John Chang wrote: I am looking for an external drive case that will be connected to a Xeon server with SCSI (Ultra-160) interface. I want something like 6-12 drives. Anyone have any suggestions? I do not want to go with Dell, IBM, etc. They cost way too much. I just want one I can build. Thank you MySQL. Seagate sells one. Elan Vital sells the S30 case which will hold 10 SCA SCSI drives with good cooling too. SQL ... -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 not starting.
I recently installed MySQL-3.23.52 and ranthrough the config and installation without any trouble. The server was running just fine. Today I performed a reboot of the system and the server will not start up again. I also tried to start the server by hand and these are the error messages I'm receiving: from /usr/local/mysql/bin... [ed@home bin]$ ./safe_mysqld The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/safe_mysqld. [ed@home bin]$ ./mysqld 021023 7:03:11 Warning: setrlimit couldn't increase number of open files to mo re than 256 021023 7:03:11 Warning: Changed limits: max_connections: 100 table_cache: 73 ./mysqld: Can't change dir to '/usr/local/mysql-3.23.52-pc-linux-gnu-i686/var/' (Errcode: 2) 021023 7:03:11 Aborting 021023 7:03:11 ./mysqld: Shutdown Complete Can anyone gather from this info why it's not starting and what I need to do to make it work again. The main installation directory is /usr/local/mysql-3.23.52-pc-linux-gnu-i686 and /usr/local/mysql is a link. Like I said before the server started just fine after initial installation. TIA, Ed Curtis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: RedHat8.0 and MySQL
-Mensaje original- De: Mark Matthews [mailto:mark;mysql.com] Enviado el: miercoles, 23 de octubre de 2002 16:38 Para: Rolf Nilsen CC: [EMAIL PROTECTED] Asunto: Re: RedHat8.0 and MySQL Rolf Nilsen wrote: Hi, dont know if this is old information, but: RedHat 8.0, MySQL 3.23.52. It works like a charm from the local machine, but when you try to connect by TCP, the active thread seg-faults. (strace on mysqld) The solution was to place the host I connect from in /etc/hosts. Voila, no more seg-faults.. I guess this is due to some oddity in RedHat 8.0, but I could not find this documentet anywhere. So now everybody knows.. Best regards Rolf Nilsen Yes it is old news, search the archives :) The issue is with the GLIBC that ships with RedHat-8.0, and the one that is updated by 'up2date'. We recommend you only use the binaries provided by MySQL AB, as they are statically linked with a custom GLIBC that prevents this problem (among others as well). -Mark -- Hi Mark. How custom is the glibc used for compile the binaries provided by MySQL AB? Which version? Iago. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 query crashes MySQL
$ perror 144 144 = Table is crashed and last repair failed Your table is corrupted, try to repair it with REPAIR TABLE or myisamchk: http://www.mysql.com/doc/en/Repair.html Hmm. REPAIR TABLE gives | mydb.IDRefs | repair | error| Can't create new tempfile: './mydb/IDRefs.TMD' | | mydb.IDRefs | repair | status | Operation failed | However, myisamchk -r IDRefs worked OK. JP optimize table IDRefs; JP Can't open file: 'IDRefs.MYD'. (errno: 13) MySQL server doesn't have permissions on that file ... This I have fixed. JP I have changed the query to INSERT DELAYED in case too many clients are JP locking the table, should I change it back? Did you install MySQL server from binary or from source? From sources. 3.23.51 on Solaris. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: sql problem
On Wednesday, Oct 23, 2002, at 00:13 America/Phoenix, Mylin Campos wrote: Hi all, I just wanted to know if you guys can help me out with this error. It's actually an sql and jdbc error. I have a class called employeeDBUtil. In this class, it has a method called updateEmployee. I wanted to try if the code would work so I created a main portion in my class. java.sql.SQLException: Syntax error or access violation: You have an error in your SQL syntax near 'eMName='Fabio', bDay = '03-14- You need to show the entire query to know why it didn't work. This error usually means the query was written correctly. -- Clayburn W. Juniel, III Phone: (602) 326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with select.
- Original Message - From: gerald_clark [EMAIL PROTECTED] To: Andrey Hristov [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 6:23 PM Subject: Re: Problem with select. Andrey Hristov wrote: HI, I don't know is it bad or not but I face queries the work quite long time. the sql is : select * from log_answers_index limit 0,10 and it takes too much time for me to receive the result. I got indexes on most of the fields, i got primary key which is auto_increment int(11). When I did explain on the query I got this : type : ALL rows : 123010 all other cells are empty. When I do : select * from log_answers_index where log_entry_index between 1 and 10 i got type : range For me it is strange that the primary key is not used when there is LIMIT What would be the point? Without a WHERE or an ORDER BY, using an index would slow it down. I am not an expert but I think that when there is not order by the output is sorted on the primary key. So : select * from log_answers_index limit 0,10 and select * from log_ansers_index where log_entry_id between 1 and 10 are no different in the output. But yes as internal work (of mysql) it is quite different. I think that will be useful optimization done by the optimizer. Andrey - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 not starting
I recently installed 3.23.52 on a server and everything went fine throughout the configuration and install. The server started fine and has been running flawlessly for the past 3 months. However, I needed to reboot the system this morning and MySQL wouldn't start back up. I have tried using both ./safe_mysqld and ./mysqld without any reults. The installation directory is /usr/local/mysql-3.23.52-pc-linux-gnu-i686 and /usr/local/mysql is a link to the installation directory. Here's what I'm getting: from /usr/local/mysql/bin [ed@home bin]$ ./safe_mysqld --user=mysql The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/safe_mysqld. -or- [ed@home bin]$ ./mysqld 021023 7:27:08 Warning: setrlimit couldn't increase number of open files to mo re than 256 021023 7:27:08 Warning: Changed limits: max_connections: 100 table_cache: 73 ./mysqld: Can't change dir to '/usr/local/mysql-3.23.52-pc-linux-gnu-i686/var/' (Errcode: 2) 021023 7:27:08 Aborting 021023 7:27:08 ./mysqld: Shutdown Complete The ./safe_mysqld --user=mysql command is exactly the same command I used to start the server after initial installation as per the documentation. I can't understand why it's not starting up. I've tried running the command both as myself and root without any luck. Any ideas? TIA, Ed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: RedHat8.0 and MySQL
Iago Sineiro wrote: -Mensaje original- De: Mark Matthews [mailto:mark;mysql.com] Enviado el: miercoles, 23 de octubre de 2002 16:38 Para: Rolf Nilsen CC: [EMAIL PROTECTED] Asunto: Re: RedHat8.0 and MySQL Rolf Nilsen wrote: Hi, dont know if this is old information, but: RedHat 8.0, MySQL 3.23.52. It works like a charm from the local machine, but when you try to connect by TCP, the active thread seg-faults. (strace on mysqld) The solution was to place the host I connect from in /etc/hosts. Voila, no more seg-faults.. I guess this is due to some oddity in RedHat 8.0, but I could not find this documentet anywhere. So now everybody knows.. Best regards Rolf Nilsen Yes it is old news, search the archives :) The issue is with the GLIBC that ships with RedHat-8.0, and the one that is updated by 'up2date'. We recommend you only use the binaries provided by MySQL AB, as they are statically linked with a custom GLIBC that prevents this problem (among others as well). -Mark -- Hi Mark. How custom is the glibc used for compile the binaries provided by MySQL AB? Which version? Read the file 'linuxthreads.txt' that comes with your MySQL source distribution (in the Docs subdirectory) for the full story. -Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: RedHat8.0 and MySQL
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 23 October 2002 17:55, Iago Sineiro wrote: How custom is the glibc used for compile the binaries provided by MySQL AB? Not much - we apply one patch (see glibc-2.2.5.patch in our BK source tree) to the vanilla glibc sources and compile it with static-nss (see linuxthreads.txt in the BK tree for more info). Which version? glibc-2.2.5 Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE9ts7XSVDhKrJykfIRAq7SAKCB47ihP95A0zLx5IAYcaPdNA0IRACfUOkR n9dh7Ocg45tD/dOVgSpheC4= =U1co -END 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
RE: RedHat8.0 and MySQL
Thanks Mark. Iago. -Mensaje original- De: Mark Matthews [mailto:mark;thematthews.org] Enviado el: miercoles, 23 de octubre de 2002 18:30 Para: Iago Sineiro CC: [EMAIL PROTECTED] Asunto: Re: RedHat8.0 and MySQL Iago Sineiro wrote: -Mensaje original- De: Mark Matthews [mailto:mark;mysql.com] Enviado el: miercoles, 23 de octubre de 2002 16:38 Para: Rolf Nilsen CC: [EMAIL PROTECTED] Asunto: Re: RedHat8.0 and MySQL Rolf Nilsen wrote: Hi, dont know if this is old information, but: RedHat 8.0, MySQL 3.23.52. It works like a charm from the local machine, but when you try to connect by TCP, the active thread seg-faults. (strace on mysqld) The solution was to place the host I connect from in /etc/hosts. Voila, no more seg-faults.. I guess this is due to some oddity in RedHat 8.0, but I could not find this documentet anywhere. So now everybody knows.. Best regards Rolf Nilsen Yes it is old news, search the archives :) The issue is with the GLIBC that ships with RedHat-8.0, and the one that is updated by 'up2date'. We recommend you only use the binaries provided by MySQL AB, as they are statically linked with a custom GLIBC that prevents this problem (among others as well). -Mark -- Hi Mark. How custom is the glibc used for compile the binaries provided by MySQL AB? Which version? Read the file 'linuxthreads.txt' that comes with your MySQL source distribution (in the Docs subdirectory) for the full story. -Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 not starting.
You are not logged in as root. [EMAIL PROTECTED] wrote: I recently installed MySQL-3.23.52 and ranthrough the config and installation without any trouble. The server was running just fine. Today I performed a reboot of the system and the server will not start up again. I also tried to start the server by hand and these are the error messages I'm receiving: from /usr/local/mysql/bin... [ed@home bin]$ ./safe_mysqld The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/safe_mysqld. [ed@home bin]$ ./mysqld 021023 7:03:11 Warning: setrlimit couldn't increase number of open files to mo re than 256 021023 7:03:11 Warning: Changed limits: max_connections: 100 table_cache: 73 ./mysqld: Can't change dir to '/usr/local/mysql-3.23.52-pc-linux-gnu-i686/var/' (Errcode: 2) 021023 7:03:11 Aborting 021023 7:03:11 ./mysqld: Shutdown Complete Can anyone gather from this info why it's not starting and what I need to do to make it work again. The main installation directory is /usr/local/mysql-3.23.52-pc-linux-gnu-i686 and /usr/local/mysql is a link. Like I said before the server started just fine after initial installation. TIA, Ed Curtis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: my.cnf settings and running admin commands such as mysqldump or m
Is it a save assumption that I need to create a section for every admin command that I want to use? i.e., create another section for mysqladmin and so on??? Thx, dK -Original Message- From: Victoria Reznichenko [mailto:victoria.reznichenko;ensita.net] Sent: Wednesday, October 23, 2002 5:28 AM To: [EMAIL PROTECTED] Subject: re: my.cnf settings and running admin commands such as mysqldump or m David, Wednesday, October 23, 2002, 12:23:36 AM, you wrote: DK I was wondering if someone could shed some light on setting parameters in DK my.cnf. When I set params such as user and password in my my.cnf file I DK dont need to then pass these parameters to commands such as mysqldump or DK mysqladmin? Is this True? Can someone please send me an example of their DK my.cnf file, Im just curious what a real example would look like. I have DK already read through the my.cnf documentation on the website, but if someone DK has a better place for online doc on the config file please let me know. DK Any other insight is more than welcome and appreciated. For mysqldump you create a section [mysqldump] in the my.cnf where you can specify mysqldump options like [mysqld] . [mysqldump] user=Victoria password=mypassword -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with select.
Without an ORDER BY, there is no order. Any order you see is purely accidental. If no order is requested, how could it be quicker to read through the index, and jump madly about the table extracting small records from large buffers. A linear read from the table is much faster. Andrey Hristov wrote: - Original Message - From: gerald_clark [EMAIL PROTECTED] To: Andrey Hristov [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 6:23 PM Subject: Re: Problem with select. Andrey Hristov wrote: HI, I don't know is it bad or not but I face queries the work quite long time. the sql is : select * from log_answers_index limit 0,10 and it takes too much time for me to receive the result. I got indexes on most of the fields, i got primary key which is auto_increment int(11). When I did explain on the query I got this : type : ALL rows : 123010 all other cells are empty. When I do : select * from log_answers_index where log_entry_index between 1 and 10 i got type : range For me it is strange that the primary key is not used when there is LIMIT What would be the point? Without a WHERE or an ORDER BY, using an index would slow it down. I am not an expert but I think that when there is not order by the output is sorted on the primary key. So : select * from log_answers_index limit 0,10 and select * from log_ansers_index where log_entry_id between 1 and 10 are no different in the output. But yes as internal work (of mysql) it is quite different. I think that will be useful optimization done by the optimizer. Andrey - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bug with Query in MySQL 4.0.4/RedHat 8.0
[EMAIL PROTECTED] wrote: Description: This query produces 16 results: SELECT * FROM table1 LEFT JOIN table2 ON (field1 = field2) WHERE field2 = 'something' ORDER BY field2,field3,field4 But this query produces 0 results: SELECT * FROM table1 LEFT JOIN table2 ON (field1 = field2) WHERE field2 = 'something' ORDER BY field2,field3,field4 LIMIT 400; I can also get the correct results set by removing the ORDER BY clause. How-To-Repeat: Fix: Submitter-Id: submitter ID Originator: Organization: MySQL support: none Synopsis: Bug with Query in MySQL 4.0.0/RedHat 8.0 Severity: serious Priority: high Category: mysql Class: sw-bug Release: mysql-4.0.4-beta (Official MySQL RPM) Environment: System: Linux pliedes-1.mfm.com 2.4.18-17.8.0 #2 Fri Oct 18 07:43:20 EDT 2002 i686 i686 i386 GNU/Linux 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/i386-redhat-linux/3.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --host=i386-redhat-linux --with-system-zlib --enable-__cxa_atexit Thread model: posix gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Oct 17 10:23 /lib/libc.so.6 - libc-2.2.93.so -rwxr-xr-x1 root root 1235468 Sep 5 19:12 /lib/libc-2.2.93.so -rw-r--r--1 root root 2233342 Sep 5 18:59 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 5 18:50 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --with-innodb --without-vio --without-openssl --enable-assembler --enable-local-infile --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info --includedir=/usr/include --mandir=/usr/share/man --with-embedded-server --enable-thread-safe-client '--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' CXX=gcc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Additional information: 1. I've tried on RedHat 8.0 and 7.1/7.2. 2. I've tried compiling my own version from the sources (w/RedHat 7.x) and the binary RPM version (on RedHat 8.0). 3. I've uploaded the relevant tables in mfm-mysqlbug.tar.gz to ftp://support.mysql.com/pub/mysql/secret/. -m -- ## Mark T. Dame, Vice President, Internet Operations ## MFM Communication Software: http://www.mfm.com/ ## E-mail: mailto:mdame;mfm.com WWW: http://www.mfm.com/~mdame/ And that's all I have to say about that. -- Forrest Gump - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bug with Query in MySQL 4.0.4/RedHat 8.0
Mark T. Dame writes: [EMAIL PROTECTED] wrote: Description: This query produces 16 results: SELECT * FROM table1 LEFT JOIN table2 ON (field1 = field2) WHERE field2 = 'something' ORDER BY field2,field3,field4 But this query produces 0 results: SELECT * FROM table1 LEFT JOIN table2 ON (field1 = field2) WHERE field2 = 'something' ORDER BY field2,field3,field4 LIMIT 400; I can also get the correct results set by removing the ORDER BY clause. How-To-Repeat: Hi! Thank you for your bug report. This bug looks conspicuously like the bug we have fixed recently in 4.0.5 (still under development). This is the entry from the ChangeLog: * Fixed a newly introduced bug that caused `ORDER BY ... LIMIT #' to not return all rows. You can check a fix by either waiting for 4.0.5 or by using our BK 4.0 repository. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bit off topic
From: John Chang [EMAIL PROTECTED] I am looking for an external drive case that will be connected to a Xeon server with SCSI (Ultra-160) interface. I want something like 6-12 drives. I bought an older server computer from a dot-bomb. Trashed all electronics but the power supply. (I think it was a 100 MHz P1 :-) I think it cost me $25! (The SCSI cables cost three times as much!) It now houses three full-size 5 1/4 drives (my fast RAID) and a half-dozen odd 3 drives that I picked up here and there, all SCSI-UW. If you have a bit of time to trade for significant savings, please consider keeping something like this out of a landfill, rather than buying a new one. -- SQL SQL SQL SQL SQL SQL SQL SQL : Jan Steinman -- nature Transography(TM): http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Rounding floats
From: Michael T. Babcock [EMAIL PROTECTED] Kenneth Hylton wrote something about SQL or QUERYs: I NEVER use float or double to store values like you appear to be doing... FWIW, all of our financial database software stores values in either pennies or tenths of a cent, not dollars, to avoid decimals altogether. FLOAT + money = lawsuit :-) -- SQL SQL SQL SQL SQL SQL SQL SQL : Jan Steinman -- nature Transography(TM): http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 do you define a relationship?
Perhaps what is confusing you is that you never explicitly define a relationship as such: there are no relationship objects. Rather, at the table leve you define a foreign key that references the primary key of another table. Second, you must use the InnoDB or BDB table types to get foreign keys. Both tables have to be InnoDB type and there must be an index where the foreign key and the referenced key are listed as the first columns. InnoDB does not auto-create indexes on foreign keys or referenced keys: you have to create them explicitly. Finally, here is the (relevant part of the) syntax: [CONSTRAINT symbol] FOREIGN KEY (index_col_name, ...) REFERENCES table_name (index_col_name, ...) [ON DELETE CASCADE | ON DELETE SET NULL] Just tack a clause like this onto the end of your CREATE TABLE statement. If your tables are already built, then you can use ALTER TABLE instead. Look in the manual under CREATE TABLE and ALTER TABLE. hth, Arthur -Original Message- From: Hammons Randy G SSgt 612 ACOMS/SCXX [mailto:Randy.Hammons;dm.af.mil] Sent: Monday, October 21, 2002 3:48 PM To: [EMAIL PROTECTED] Subject: RE: how do you define a relationship? Unfortunately this goes well beyond the scope of my original question. Although the inputs that you all have provided thus far have been a very good read, I still don't grasp the concept of defining a relationship. Is it simply referring to a primary key in a field other than the one where the key was defined? Or is there some other way to define a key that I don't see? All I'm looking for is a simple example, syntax excerpt, etc...that shows me (only the slow learner level) exactly how to define a relationship. -Original Message- From: Jan Steinman [mailto:Jan;Bytesmiths.com] Sent: Monday, October 21, 2002 12:07 PM To: [EMAIL PROTECTED] Subject: RE: how do you define a relationship? From: Arthur Fuller [EMAIL PROTECTED] Unfortunately that oversimplifies the situation. A least a few movies have more than one director. My motto: Generalize for the norm; specialize for the exception. The vast majority of movies have but one director. And I suspect that movies with multiple directors have but one who is primary. Keep a single director field, with a second NULL FULLTEXT field for additional directors. The NULL test for the normal case is much cheaper than what you have to go through by assuming that ALL movies have multiple directors! This is how books are handled in large databases. Each has a primary author, and may contain secondary authors. There is no assumption that large numbers of books have multiple, equal authors. This way, you can easily and conveniently list multiples as Speilberg (et. al.) without doing joins. An interested browser can then go further to find out who the others are. In the other case, each request for a director requires a JOIN. Of course, your particular application may be director-centric, like if you're building a special database to support research on directors. But if it's just a general-purpose movies database, why bog the whole thing down just to suit a few exceptional cases? SQL SQL SQL SQL SQL SQL SQL SQL -- : Jan Steinman -- nature Transography(TM): http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Newsletters now on-line at http://www.Bytesmiths.com/Newsletter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Rounding floats
Oh, for BCD floating point. My first computer with a language (SWTP 6800) had BCD math. It had something like 6 byte mantissa and a 1 byte exponent. That would give 11 digits with e +-99 Maybe we should have BCD data types. Jan Steinman wrote: From: Michael T. Babcock [EMAIL PROTECTED] Kenneth Hylton wrote something about SQL or QUERYs: I NEVER use float or double to store values like you appear to be doing... FWIW, all of our financial database software stores values in either pennies or tenths of a cent, not dollars, to avoid decimals altogether. FLOAT + money = lawsuit :-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 when compiling mysql 3.23.53 on Solaris 9
Hi all, I am compiling mysql 3.23.53 on Solaris 9 using gcc 3.2. Any clue to the following errors: mkdir .libs g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_RWLOCK_T -o gen_lex_hash gen_lex_hash.o ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -lpthread -lthread -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread make[4]: Leaving directory `/pub/mysql-3.23.53/sql' ./gen_lex_hash lex_hash.h ld.so.1: ./gen_lex_hash: fatal: libstdc++.so.5: open failed: No such file or directory Killed make[3]: *** [lex_hash.h] Error 137 make[3]: Leaving directory `/pub/mysql-3.23.53/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/pub/mysql-3.23.53/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/pub/mysql-3.23.53' make: *** [all-recursive-am] Error 2 Thanks __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.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: Error when compiling mysql 3.23.53 on Solaris 9
At 11:13 -0700 10/23/02, Jeremy Lau wrote: Hi all, I am compiling mysql 3.23.53 on Solaris 9 using gcc 3.2. Any clue to the following errors: mkdir .libs g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_RWLOCK_T -o gen_lex_hash gen_lex_hash.o ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -lpthread -lthread -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread make[4]: Leaving directory `/pub/mysql-3.23.53/sql' ./gen_lex_hash lex_hash.h ld.so.1: ./gen_lex_hash: fatal: libstdc++.so.5: open failed: No such file or directory Set LD_LIBRARY_PATH to include the directory where libstdc++.so is located. Killed make[3]: *** [lex_hash.h] Error 137 make[3]: Leaving directory `/pub/mysql-3.23.53/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/pub/mysql-3.23.53/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/pub/mysql-3.23.53' make: *** [all-recursive-am] Error 2 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: How to index a large table?
Also, use myisamchk -dv tablename Pay attention to datafile pointer (bytes) and Keyfile pointer (bytes) and the Max keyfile/datafile length. The keyfile pointer must be at least 4 bytes for a large table, if it says 3 you have a problem! This is isn't clear from the CREATE TABLE section of the manual, but is in the 1.2.4 How Big Can MySQL Tables Be?. I don't know if there is any problem or change like this need for InnoDB, since Innodb is not mentioned I would suspect it is not needed. Ken - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Ken Menzel [EMAIL PROTECTED] Cc: Jocelyn Fournier [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 8:00 PM Subject: Re: How to index a large table? At 18:45 -0500 10/22/02, [EMAIL PROTECTED] wrote: Indeed, setting MAX_ROWS lets me create the index. Thanks for the tip. How would I find out what the MAX_ROWS setting on a table is? SHOW CREATE TABLE tbl_name; or SHOW TABLE STATUS LIKE 'tbl_name'; - Original Message - From: Ken Menzel [EMAIL PROTECTED] Date: Tuesday, October 22, 2002 4:05 pm Subject: Re: How to index a large table? Just curious Chris, did you set MAX_ROWS option during table create to a really large value? If not alter the the table with this and try again, it affects the size of pointers used to create the index. (See CREATE TABLE in the manual) Hope it helps, Ken - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Optimizing Query to use Index in ORDER BY
Hi, I'm having trouble getting the following query to use the indexes on the order by. SELECT vr.muzeid, vr.releaseformat, vr.releasestatus, vr.collectorsedition, pt.title FROM v_videorelease vr, v_producttitle pt, v_prodcategory pc WHERE pc.muzeid = vr.muzeid AND pt.muzeid = vr.muzeid AND vr.releaseformat = 'DVD' AND vr.releasestatus = 'In Print' AND pc.categorylevel = '1' AND pc.categoryid = '21' ORDER BY pt.title LIMIT 0, 21 The indexes are as follows: Table vr: muzeid prelrefnum releaseformat releasestatus Table pt: muzeid titleakanum title subtitle muzeid, title The explain on the query shows that it is using a temporary table with filesort. Can anyone help me get the ORDER BY to use the pt.title index? 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
Old installation on Solaris 7, can't admin...
I've inherited an existing system and am attempting to do some admin tasks. I can't get access as root, and no one seems to know anything about the system. I've just modified the /usr/local/mysql/data/my.cnf (that's what 'ps -aef' shows mysqld is using) with a password and I still get this: mysql -u root -p bonsai Enter password: ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Error when compiling mysql 3.23.53 on Solaris 9
Jeremy, May not be helpful to you - perhaps you are seeking some specific compiled-in function, but for what it's worth: The mysql-max-4.0.4-beta-sun-solaris2.8-sparc tarball also runs great on Solaris 9 SPARC. We are using it... Lou Essex Systems Hi all, I am compiling mysql 3.23.53 on Solaris 9 using gcc 3.2. Any clue to the following errors: mkdir .libs g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_RWLOCK_T -o gen_lex_hash gen_lex_hash.o ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -lpthread -lthread -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread make[4]: Leaving directory `/pub/mysql-3.23.53/sql' ./gen_lex_hash lex_hash.h ld.so.1: ./gen_lex_hash: fatal: libstdc++.so.5: open failed: No such file or directory Killed make[3]: *** [lex_hash.h] Error 137 make[3]: Leaving directory `/pub/mysql-3.23.53/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/pub/mysql-3.23.53/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/pub/mysql-3.23.53' make: *** [all-recursive-am] Error 2 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: Rounding floats
Another alternative for storage of currency values is to use the DECIMAL type, which allows you to explicitly specify scale and precision. You're still constrained to a maximum precision that matches that of DOUBLE, and you get the inefficiency of storing values as strings but you don't have to worry about rounding errors. (unless you're recording truly enormous sums of money...) -JF -Original Message- From: gerald_clark [mailto:gerald_clark;suppliersystems.com] Sent: Wednesday, October 23, 2002 10:10 AM To: Jan Steinman Cc: [EMAIL PROTECTED] Subject: Re: Rounding floats Oh, for BCD floating point. My first computer with a language (SWTP 6800) had BCD math. It had something like 6 byte mantissa and a 1 byte exponent. That would give 11 digits with e +-99 Maybe we should have BCD data types. Jan Steinman wrote: From: Michael T. Babcock [EMAIL PROTECTED] Kenneth Hylton wrote something about SQL or QUERYs: I NEVER use float or double to store values like you appear to be doing... FWIW, all of our financial database software stores values in either pennies or tenths of a cent, not dollars, to avoid decimals altogether. FLOAT + money = lawsuit :-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Vague error message...
A colleague asked me what was wrong with this query: mysql select user.id, email, count(click.id) as c from user, click where when_signup = '2002-11-10' and click.user_id = user.id group by c; ERROR 1056: Can't group on 'c' Of course, it's logically impossible to group by the result of an expression involving an aggregate function and my colleague certainly knows better -- he just spaced out a bit. That said, the error message here wasn't useful in helping him to diagnose the problem. It would have been far more useful for the error message to be more clear about *why* one cannot group on 'c'. -JF - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Optimizing Query to use Index in ORDER BY
Does explain say an index is used on pt for the join? Only one index per table is used in a query. It is probably more efficient to use the index for the where clause than the order by. Joseph Koenig wrote: Hi, I'm having trouble getting the following query to use the indexes on the order by. SELECT vr.muzeid, vr.releaseformat, vr.releasestatus, vr.collectorsedition, pt.title FROM v_videorelease vr, v_producttitle pt, v_prodcategory pc WHERE pc.muzeid = vr.muzeid AND pt.muzeid = vr.muzeid AND vr.releaseformat = 'DVD' AND vr.releasestatus = 'In Print' AND pc.categorylevel = '1' AND pc.categoryid = '21' ORDER BY pt.title LIMIT 0, 21 The indexes are as follows: Table vr: muzeid prelrefnum releaseformat releasestatus Table pt: muzeid titleakanum title subtitle muzeid, title The explain on the query shows that it is using a temporary table with filesort. Can anyone help me get the ORDER BY to use the pt.title index? 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: Old installation on Solaris 7, can't admin...
Mark Jaffe wrote: I've inherited an existing system and am attempting to do some admin tasks. I can't get access as root, and no one seems to know anything about the system. I've just modified the /usr/local/mysql/data/my.cnf (that's what 'ps -aef' shows mysqld is using) with a password and I still get this: mysql -u root -p bonsai Enter password: ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) Is bonsai the password? If so, there should be no space between the -p and the bonsai. If not, and you don't know the password, follow the directions in the manual for I forgot the password. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: RedHat 8 and mysql-server-3.23.52-3
My dear friend, TCP/IP is a protocol with KNOWLEDGE at ICMP level(see RFC792 ). The DNS server have a different purpose(see RFC 1034 or RFC 952 HostNames table). Ping work at ICMP level. The KERNEL is responsible about what is happened in the OS including the TCP/IP protocol. The TCP/IP IPV4/IPV6 and functions like socket(),accept(),listen(),bind()...etc are implemented on the KERNEL level...also the sockaddr structure type and many others. Functions like gethostbyname(),gethostbyaddr(),res_init,res_query()...etc and hostent structure type are implemented in glibc. Without all this, the TCP/IP communication CAN NOT EXIST. MySQL have the own way/functions for resolving hostnames but which is based on the glibc functions. The glibc defines the SYSTEM CALLS and others functions and it used by the C/C++ compiler. In fact by adding IP address in /etc/hosts, the glibc function gethostbyaddr() reserve the RIGHT MEMORY SIZE FOR IT(seems to be a recast to int type). If the IP address/Alias is not present in hosts, this function make an wrong allocation memory and for this MySQL daemon is crashed. That's it. In my previous e-mail i don't say nothing about Domain Class(A,B,C) or canonical name or reverse lookup or other things which is on DNS responsibility.I try to say about how it work and was my wish to not to be too technical. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Iikka Meriläinen [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 2:11 PM Subject: Re: RedHat 8 and mysql-server-3.23.52-3 Hi! On Wed, 23 Oct 2002, Gelu Gogancea wrote: Hi Iikka, My opinion: Doesn't matter what type of client it is(whatever OS).TCP/IP it's the same for all.One property of the SERVER it to resolving hosts.And this is done by IP-hostname mapping/resolving is usually done by DNS servers, not the MySQL server, assuming that they're not running on the same box. :-) There are several ways for resolving addresses. using KERNEL functions.By adding in hosts file(in the SERVER MACHINE) the IP address of the client machine which want to connect to the SERVER, help SERVER for resolving the hostname.KERNEL make a lookup to the hostnames which is associate with the IP address. AFAIK, IP-to-hostname mapping isn't done by _kernel_ functions. At least the Linux kernel knows very little about hostnames. Some exotic Unixes may implement this differently, but no operating system I'm aware of has kernel interfaces for name resolution. Making the server recognize the client correctly with an updated /etc/hosts seems logical enough. It's strange, though, to have to make changes on the server for clients to be able to connect. For using this functions IS NEED TO HAVE the properly system call library which is(in this case) GLIBC.2.2.40.If some incompatibilities(BUGS) exists between this, a lot of problems can be raised after compilation.For this reason EGOR send a strongly message to all to make a downgrade to a version of glibc which is stable. Here you get it right. glibc is much more responsible for ip-hostname-mapping than the operating system kernel itself. Kernel implements the IP protocol with dotted-format addresses, and it expects user-mode libraries to do any necessary conversions. That is, when you do this: ping www.google.com the ping binary calls a couple of conversion functions in user-mode libraries so that it can pass a real IP address to the kernel/protocol interface. Personally, i can't do that because i have installed and others applications which require this version(2.2.40) of glibc.For me was a compromised solution because i use Red Hat 8.0 and MySQL 4.0.4 for testing purpose.My applications run under Suse 7.x with MySQL 3.x (MyISAM). The problem was for who which make have installed MySQL from Source Distribution or Red Hat distribution. I hope you understand exactly what i try to say.Unfortunately (for me),my english is not so good . Yep, I saw it. :-) But got your point anyway though. Best regards, Iikka - Original Message - From: Iikka Meriläinen [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 9:25 AM Subject: Re: RedHat 8 and mysql-server-3.23.52-3 On Tue, 22 Oct 2002, Gelu Gogancea wrote: Hi, No.On the server machine.The hosts is the way for resolving hostnames.In other Unix system, like SCO, to put the IP address and the alias in hosts is indispensable. Well, I meant that the client machine in this case seems to be a *NIX, so the /etc/hosts of _that_ machine should be updated. Of course, depending on where the error comes from. In this case it seems to be on the client side - although the client computer seems to be running Unix.
full-text performance question
I have a table with a full-text index that spans four text columns. It seems that the more records a query matches, the longer it takes to execute. Is that normal? Examples: I have 15,376 records in this table: mysql select count(*) from NS_articles where match(artHeadline,artTagline,artByline,artText) against('foobar' IN BOOLEAN MODE); +--+ | count(*) | +--+ |0 | +--+ 1 row in set (0.00 sec) mysql select count(*) from NS_articles where match(artHeadline,artTagline,artByline,artText) against('trucks' IN BOOLEAN MODE); +--+ | count(*) | +--+ | 59 | +--+ 1 row in set (0.10 sec) mysql select count(*) from NS_articles where match(artHeadline,artTagline,artByline,artText) against('football' IN BOOLEAN MODE); +--+ | count(*) | +--+ | 1823 | +--+ 1 row in set (1.81 sec) mysql select count(*) from NS_articles where match(artHeadline,artTagline,artByline,artText) against('nebraska' IN BOOLEAN MODE); +--+ | count(*) | +--+ | 9673 | +--+ 1 row in set (3.29 sec) As you can see, as the number of matching records grows, the length of time for the query to execute gets longer (pretty much linearly.) Why is this? If I had 1,000,000 rows, I would presume the query would take a _very_ long time. TIA Monte - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: BOM (Bill of Material)
Hi, About what you are interested ? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Mike Westkamper [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 11:32 PM Subject: BOM (Bill of Material) Anybody know of a BOM processing system running on MySQL? Hosted on Linux or Windows? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Optimizing Query to use Index in ORDER BY
The explain shows that it is using the muzeid key for the pt table, so yes it is using it for the join. The query takes 1.46 seconds with the GROUP BY and 0.01 without. I was hoping to find a way to speed with query up. Thanks, Joe From: gerald_clark [EMAIL PROTECTED] Date: Wed, 23 Oct 2002 14:00:29 -0500 To: Joseph Koenig [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Optimizing Query to use Index in ORDER BY Does explain say an index is used on pt for the join? Only one index per table is used in a query. It is probably more efficient to use the index for the where clause than the order by. Joseph Koenig wrote: Hi, I'm having trouble getting the following query to use the indexes on the order by. SELECT vr.muzeid, vr.releaseformat, vr.releasestatus, vr.collectorsedition, pt.title FROM v_videorelease vr, v_producttitle pt, v_prodcategory pc WHERE pc.muzeid = vr.muzeid AND pt.muzeid = vr.muzeid AND vr.releaseformat = 'DVD' AND vr.releasestatus = 'In Print' AND pc.categorylevel = '1' AND pc.categoryid = '21' ORDER BY pt.title LIMIT 0, 21 The indexes are as follows: Table vr: muzeid prelrefnum releaseformat releasestatus Table pt: muzeid titleakanum title subtitle muzeid, title The explain on the query shows that it is using a temporary table with filesort. Can anyone help me get the ORDER BY to use the pt.title index? 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 v3.23.53 on Linux 2.2.19 with glibc 2.1.3
I'm trying to compile MySQL v3.23.53 on Linux 2.2.19 with glibc 2.1.3 and I'm getting an error: libmysql.c: In function `mysql_real_connect': libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1325: too few arguments to function `gethostbyname_r' libmysql.c:1325: warning: assignment makes pointer from integer without a cast It seems the detecting of the glibc2-style gethostbyname_r is broken; config.h has it undefined. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 query help
Hello, I have the following table structure and need assistance on a mysql query: Members MemberID (unique) Name Address Credits CreditID MemberID Project Title Credit_Images = ImageID CreditID Location Comments Showroom = ShowroomID MemberID Size Comments I need to do a full search on all the fields (except ID) and return a list of names from the members table. I am kind of stuck - any help will be appreciated. I am running on version 3.23 so full-text is not available Thanks. --Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Optimizing Query to use Index in ORDER BY
What version of MySQL are you currently running? There exist a feature in release 3.23.x where a filesort will be used to perform GROUP BY and ORDER BY's actions when the key part is not used in the where clause. If I am correct, the optimizer has been tweaked in version 4.x. Forgive me if I am off base with this information. I hope this helps. Victor Pendleton -Original Message- From: Joseph Koenig To: gerald_clark Cc: [EMAIL PROTECTED] Sent: 10/23/02 2:29 PM Subject: Re: Optimizing Query to use Index in ORDER BY The explain shows that it is using the muzeid key for the pt table, so yes it is using it for the join. The query takes 1.46 seconds with the GROUP BY and 0.01 without. I was hoping to find a way to speed with query up. Thanks, Joe From: gerald_clark [EMAIL PROTECTED] Date: Wed, 23 Oct 2002 14:00:29 -0500 To: Joseph Koenig [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Optimizing Query to use Index in ORDER BY Does explain say an index is used on pt for the join? Only one index per table is used in a query. It is probably more efficient to use the index for the where clause than the order by. Joseph Koenig wrote: Hi, I'm having trouble getting the following query to use the indexes on the order by. SELECT vr.muzeid, vr.releaseformat, vr.releasestatus, vr.collectorsedition, pt.title FROM v_videorelease vr, v_producttitle pt, v_prodcategory pc WHERE pc.muzeid = vr.muzeid AND pt.muzeid = vr.muzeid AND vr.releaseformat = 'DVD' AND vr.releasestatus = 'In Print' AND pc.categorylevel = '1' AND pc.categoryid = '21' ORDER BY pt.title LIMIT 0, 21 The indexes are as follows: Table vr: muzeid prelrefnum releaseformat releasestatus Table pt: muzeid titleakanum title subtitle muzeid, title The explain on the query shows that it is using a temporary table with filesort. Can anyone help me get the ORDER BY to use the pt.title index? 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
show version problem
hello, I'm running version 4.0.3-beta-max-log on SunOS 5.8 (Generic_108528-15 sun4u sparc SUNW,Sun-Fire-280R) output from mysqlshow -V: mysqlshow Ver 9.4 Distrib 4.0.3-beta, for sun-solaris2.8 (sparc) I'm finding that executing either 'show variables' from a mysql session or 'mysqladmin -variables' from a shell prompt crashes the database. the database then restarts. this appears to be 100% repeatable on my install. Also, I cannot execute 'show table status from [tablename]'. All of my tables happen to be InnoDB tables. However, executing only 'show table status' or 'mysqlshow --status' works fine. any help you all can give wold be appreciated. thanks jeff mathis -- Jeff Mathis, Ph.D. 505-995-1434 The Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste 6http://www.predict.com Santa Fe, NM 87505 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
match against ('best') bug?
Hi- I don't know if this is a bug (I'm pretty new at mysql), but I figured I would fill out the report anyway. I don't know how to answer some of the questions, but did my best. I have looked in the manual, searched the list archives, and am using 4.0.4-beta-max-nt on Win2000. Description: Whenever I perform a match against the word best [and, interestingly, only the word best by itself, because (+best +friends) and (friends best) both DO work] using match against, I get an empty set. If I use like '%best%'the correct records are found. How-To-Repeat: CREATE TABLE booleanbug ( id int(11) NOT NULL auto_increment, name char(40) NOT NULL, PRIMARY KEY (id) ); # # Dumping data for table 'booleanbug' # INSERT INTO booleanbug VALUES ( '1', 'Best in Show'); INSERT INTO booleanbug VALUES ( '2', 'Star Wars'); INSERT INTO booleanbug VALUES ( '3', 'Hannah and Her Sisters'); INSERT INTO booleanbug VALUES ( '4', 'Best Friends'); INSERT INTO booleanbug VALUES ( '5', 'Office Space'); INSERT INTO booleanbug VALUES ( '6', 'The Professional'); INSERT INTO booleanbug VALUES ( '7', 'Terms of Endearment'); INSERT INTO booleanbug VALUES ( '8', 'Father Knows Best'); INSERT INTO booleanbug VALUES ( '9', 'The Flamingo Kid'); INSERT INTO booleanbug VALUES ( '10', 'Repo Man'); CREATE FULLTEXT INDEX name on booleanbug(name); select id, name from booleanbug where match(name) against ('best'); select id, name from booleanbug where match(name) against ('+best IN BOOLEAN MODE'); #[BOTH OF THE ABOVE SELECTS RESULT IN EMPTY SETS] select id, name from booleanbug where match(name) against ('+best +friends IN BOOLEAN MODE'); select id, name from booleanbug where match(name) against ('wars'); select id, name from booleanbug where name like '%best%'; #[ALL 3 OF THE ABOVE SELECTS WORK] # NOTE - I called the test case table booleanbug, # but have since realized it's not just a boolean # problem. For some reason match against ('best') # doesn't work for me, boolean or not. Fix: no idea Synopsis: match against ('best') doesn't work Submitter-Id: ? Originator: Michael Nolan Organization: none MySQL support: none Severity: ? Priority: ? Category: mysqld (I think) Class: sw-bug (?) Release: mysqladmin Ver 8.37 Distrib 4.0.4-beta, for Win95/Win98 on i32 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 4.0.4-beta-max-nt Protocol version10 Connection localhost via TCP/IP TCP port3306 Uptime: 4 hours 37 min 16 sec Threads: 2 Questions: 1927 Slow queries: 0 Opens: 32 Flush tables: 1 Open t ables: 0 Queries per second avg: 0.116 Exectutable: mysqld-nt (?) Environment: Desktop with 256MB RAM System:Win2000 5.00.2195 Service Pack 2 Compiler: (?) Architecture: (?) Please let me know if I should post this to the bugs list. Thanks, Michael Michael Nolan [EMAIL PROTECTED] -- __ Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 not starting.
I have tried both as myself and as root and received the same results. Thanks, Ed On Wed, 23 Oct 2002, gerald_clark wrote: You are not logged in as root. [EMAIL PROTECTED] wrote: I recently installed MySQL-3.23.52 and ranthrough the config and installation without any trouble. The server was running just fine. Today I performed a reboot of the system and the server will not start up again. I also tried to start the server by hand and these are the error messages I'm receiving: from /usr/local/mysql/bin... [ed@home bin]$ ./safe_mysqld The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/safe_mysqld. [ed@home bin]$ ./mysqld 021023 7:03:11 Warning: setrlimit couldn't increase number of open files to mo re than 256 021023 7:03:11 Warning: Changed limits: max_connections: 100 table_cache: 73 ./mysqld: Can't change dir to '/usr/local/mysql-3.23.52-pc-linux-gnu-i686/var/' (Errcode: 2) 021023 7:03:11 Aborting 021023 7:03:11 ./mysqld: Shutdown Complete Can anyone gather from this info why it's not starting and what I need to do to make it work again. The main installation directory is /usr/local/mysql-3.23.52-pc-linux-gnu-i686 and /usr/local/mysql is a link. Like I said before the server started just fine after initial installation. TIA, Ed Curtis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compiling v3.23.53 on Linux 2.2.19 with glibc 2.1.3
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 23 October 2002 21:37, Michael T. Babcock wrote: I'm trying to compile MySQL v3.23.53 on Linux 2.2.19 with glibc 2.1.3 and I'm getting an error: libmysql.c: In function `mysql_real_connect': libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1325: too few arguments to function `gethostbyname_r' libmysql.c:1325: warning: assignment makes pointer from integer without a cast It seems the detecting of the glibc2-style gethostbyname_r is broken; config.h has it undefined. Make sure that g++ (Package gpp on SuSE Linux) is installed or export CXX=gcc before running configure - that should fix this. Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE9twA4SVDhKrJykfIRAq9eAJ96AmA5rvA+Q7ChktpIdkBaBysowwCfRYez CG2Ics2I/svfB8AtdWFUmNw= =9tkM -END 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
Re: full-text performance question
Hi! On Oct 23, Monte Ohrt wrote: I have a table with a full-text index that spans four text columns. It seems that the more records a query matches, the longer it takes to execute. Is that normal? To quote my two-days-ago reply on exactly the same issue: === Date: Mon, 21 Oct 2002 19:47:15 + From: Sergei Golubchik [EMAIL PROTECTED] To: Jakob Nielsen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Obscure FULLTEXT search problems Hi! On Oct 21, Jakob Nielsen wrote: In scenario 1 I'm using this SQL-statement: SELECT * FROM tArticles WHERE ( Title LIKE '%HYDRO%' OR Body LIKE '%HYDRO%' ) In scenario 2 I'm using this SQL-statement: SELECT * FROM tArticles WHERE ( MATCH( Title, Body ) AGAINST( 'HYDRO')) My problem is that if I'm searching for a word (For instance HYDRO) that are found in a lot of my articles, then scenario 1 is much faster than scenario 2. But if the search word is in just a few of the articles then scenario 2 is _much_ faster than scenario 1. Can someone explain this to me? What do I do? Yes, it's a well known issue. There're two reasons for this. The first one is that when you select too many rows, it's faster to do a table scan - reading the file in sequential order - than scan the index and read row data in some random - implied by the index - order. That's why MySQL doesn't use index if it's expected to select more that one third of the table. But fulltext search (in 3.23 at least) cannot work without an index. The second thing is that fulltext search - as implemented in 3.23.x - uses some complicated statistics to produce adequate relevance rating (optimized for natural language queries). To do it, it keeps a list of all matched rows. Actually, not a list but a binary tree, so lookup time is O(log(N)). So search time is O(N*log(N)), while search time for LIKE grows linearly. Second issue can be resolved by using fulltext search IN BOOLEAN MODE (available since MySQL-4.0.2), it's not optimized for natural language queries and doesn't need these complicated relevance calculations. So it's O(log(N)) times faster than fulltext search in natural language mode and almost always faster than LIKE. 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: MySQL not starting.
One line says : The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Does it exist? Is it executable? Is it owned my mysql? Does mysql own /usr/local/mysql and all its subdirectories and files? Another line says ./mysqld: Can't change dir to '/usr/local/mysql-3.23.52-pc-linux-gnu-i686/var/' (Errcode: 2) Error 2 means that the directory doesn't exist. Does it? Does mysql own it and all its subdirectories and files? Why is one directory /usr/local/mysql and the other /usr/local/mysql-3.23.52-pc-linux-gnu-i686 ? It looks to me like the log is telling you everything you need to know to find the problem. [EMAIL PROTECTED] wrote: I have tried both as myself and as root and received the same results. Thanks, Ed On Wed, 23 Oct 2002, gerald_clark wrote: You are not logged in as root. [EMAIL PROTECTED] wrote: I recently installed MySQL-3.23.52 and ranthrough the config and installation without any trouble. The server was running just fine. Today I performed a reboot of the system and the server will not start up again. I also tried to start the server by hand and these are the error messages I'm receiving: from /usr/local/mysql/bin... [ed@home bin]$ ./safe_mysqld The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/safe_mysqld. [ed@home bin]$ ./mysqld 021023 7:03:11 Warning: setrlimit couldn't increase number of open files to mo re than 256 021023 7:03:11 Warning: Changed limits: max_connections: 100 table_cache: 73 ./mysqld: Can't change dir to '/usr/local/mysql-3.23.52-pc-linux-gnu-i686/var/' (Errcode: 2) 021023 7:03:11 Aborting 021023 7:03:11 ./mysqld: Shutdown Complete Can anyone gather from this info why it's not starting and what I need to do to make it work again. The main installation directory is /usr/local/mysql-3.23.52-pc-linux-gnu-i686 and /usr/local/mysql is a link. Like I said before the server started just fine after initial installation. TIA, Ed Curtis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 not starting.
Are you sure your sym-links have not been deleted? - Mark System Administrator Asarian-host.org --- If you were supposed to understand it, we wouldn't call it code. - FedEx - Original Message - From: gerald_clark [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 10:14 PM Subject: Re: MySQL not starting. One line says : The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
relevance ranking with IN BOOLEAN MODE
Hi, How do I get a full-text relevance ranking when using IN BOOLEAN MODE? The manual shows how to get the relevance, but if I try to apply the same technique to a boolean search, I get a score of either 0 or 1 as the relevance. There are relevance parameters for boolean searches, so it must be possible? select match(artHeadline,artTagline,artByline,artText) against('trucks' IN BOOLEAN MODE) as score from NS_articles where match(artHeadline,artTagline,artByline,artText) against('trucks' IN BOOLEAN MODE) 0; query returns: +---+ | score | +---+ | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | +---+ TIA Monte - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Another bit off-topic question
Hello. On Wed 2002-10-23 at 10:47:28 -0400, [EMAIL PROTECTED] wrote: I'm planning on using Win2k Adv. server, IIS, MYSQL, PHP on a dual processor 2.4GHz processor with 1 or 2GB RAM, with either SCSI or ATA HDs. The webpage will be dynamic. 1)How many concurrent connections would something like this handle? The short answer is: it depends. The long answer: Since you mention both, IIS and MySQL, it is not clear what you refer to. Concurrent web connections or concurrent database connection. Either way, concurrent connections is not a meaningful measure, as performance also depends on time needed per request, i.e. 10 concurrent connection with a response time of 0.1 seconds is better than 50 concurrent connections with a response time of 10 seconds (the former can answer 100 requests/sec, the latter only 5). The performance of the setup depends on many factors, among other things: - CPU speed / number of CPUs - disk space + speed + latency - memory size + free mem for database buffers + free mem for OS file caching - database usage + whole size + size of regularly used parts - usage pattern (i.e. the queries) + read/write ratio + complexity of queries - operating system + quality of threading support - MySQL + required version + required table type That are only the most common of the factors. Even if all of them were known it would still be hard to make a reasonable guess. You provided less than half of them, so the answer must be: it depends. Btw, the simplest scaling possibility you have, if needed, is to install two servers, one for the web server part, one for the database server. A data point: A dual Pentium III 1133MHZ, several 18GB IBM SCSI disks, 2GB RAM (0.5GB used, 0.5GB used for caching, rest sparely used), only for MySQL. Linux 2.4, ext2 filesystem. Seperate app server. Database is 15GB, of which no more than 1GB is often used. About 40 Million records. 80% simple SELECTs, 10% SELECTs without perfect index, 10% writes. MyISAM tables on v3.23.49. Indexes and tables are optimized a lot. This setting is able to handle about 120 queries/s, where one web request triggers about 8 queries, i.e. 15 request/s with a CPU utilisation of 20% and disk throughput of 400MB/s. Experience tells that this system on this database manages to sustain 2GB/s, so CPU usage will become first bottleneck at about 75 req/sec resp. 600 queries/sec. For this application, RAID/SCSI/IDE is a non-issue for now, because the relevant database parts are cached (by the OS) in memory, and there is room for the database to about double the size before the cache ratio will get worse. The CPU requirement is unusually high due to certain shortcomings of the 3.23 optimizer, which are already fixed in the 4.x tree (so I do not care and plan to switch to 4.x when CPU becomes a problem). Additionally, the query cache of 4.x will benifit my kind of application *a lot*, so expect to get up to 4000-5000 queries regarding the CPU, but some other bottleneck will hit me first. When the database is 5 times the size, the situation will have changed completely (given the same hardware), because the relevant parts cannot be cached anymore - the disk throughput increases - the disks are too slow - the whole system bogs down. A RAID system may be able to partially compensate for this (or simply buying new mem, which will be cheapier by then). 2) Will it make a big difference if I use SCSI or ATA? Example SCSI 1000 conncetions, ATA 100 connections. Just want a ball park figure if there is a difference. It depends. ATA is about as fast as SCSI or faster for a single disk. For several disks, SCSI has less congestion and will be faster. (Only high usage disks count for this number, not a disk holding the system.) There are other advantages to SCSI which have nothing to do with speed. 3) How much RAM do I need for 1000 conncurrent connections? What kind of connections (see above)? MySQL's memory usage is quite configurable. According to my experience the web server will use more memory than the database per connection. But you want a key cache of a reasonable size for your database. 4) Should I use RAID 1 or 5? Will it make a big difference if I want 1000 concurrent connections? If you are concerned about disk speed, RAID 1 or RAID 10 is the way to go, if you can afford the needed system and disks. But be sure that you need a RAID system at all (regarding the speed issue). Btw, using a UNIX system like Solaris, FreeBSD or Linux will give a significant speed boost for MySQL (up to 30%, IIRC). Regards, Benjamin. -- [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:
Help Please ... PHP Problem - /libraries/grab_globals.lib.php
I still can't get get PHP working - Apache and MySQL work fine, but loading PHP pages continually show errors such as: Fatal error: Failed opening required './libraries/grab_globals.lib.php' Compiling from source presented a lot of dependency issues, so I reinstalled everything via deb files - phpmyadmin, apache, and php4, and uncommented appropriate httpd.conf lines: AddType application/x-httpd-php .php LoadModule php4_module /usr/lib/apache/1.3/libphp4.so Typing localhost in the browser loads docroot ok, and the phpinfo test page works fine, showing all the php config settings. I thought I was all set! http://localhost/test.php However, nothing else with .php, .php4, .php3 works at all. They fail with various errors, one of which is the following: Fatal error: Failed opening required './libraries/grab_globals.lib.php' (include_path='.:/usr/share/pear') in /var/www/index.php on line 8 I tried copying all the files from where I originally tried to compile php, into /var/www/, but it didn't work (dumb guess anyway): /usr/php-4.2.3/pear /usr/php-4.2.3/pear/scripts/pear Can someone give me a suggestion? I feel like I'm probably just a step away from finally getting it working. I tried searching Google for those error msgs, but couldn't find any resources or possibilities, other than some pages written in Russian. Thanks in advance, Chip [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
Looking for sample my.cnf
Im looking for an example of my.cnf. Just want to see what some of the basic parameters and admin tools(mysqldump, mysqlimport, mysqlshow,mysqladmin) settings should look like in my.cnf. I have searched all over the web and havent found much, if someone has a site they recommend outside of mysql.com I would greatly appreciate it. Other than that could someone just send me a copy of their my.cnf, please feel free to X out any secure info. Thanks, DK David Kramer Software Developer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Using the embedded mysql server - how do I create a database on the fly?
Hello. I'm just getting started with the embedded mysql server and I'm not trying to do anything fancy. I just want to initialize the server and call mysql_create_db and have the database get created and then start using it. I've modified the basic embedded server example as follows: mysql_server_init(sizeof(server_args) / sizeof(char *), server_args, server_groups); if(mysql_create_db(one, my_database)) { fprintf(stderr, Failed to create new database. Error: %s\n, mysql_error(one)); } one = db_connect(my_database); two = db_connect(NULL); db_do_query(one, SHOW TABLE STATUS); db_do_query(two, SHOW DATABASES); mysql_close(two); mysql_close(one); I get a test_mysqld.c:53: warning: implicit declaration of function `mysql_create_db' when compiling and then I get a Seg Fault when it is ran. What am I doing wrong? - Steve __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: large amount of aborted_connects
Do I need to post any further information to make this question easier to answer? I have snippets from SHOW STATUS and SHOW VARIABLES if needed. -Original Message- From: Jennifer Goodie [mailto:goodie;apollointeractive.com] Sent: Friday, October 18, 2002 5:19 PM To: [EMAIL PROTECTED] Subject: large amount of aborted_connects I'm having trouble with a an obscene amount of aborted_connects on my MySQL database servers. I have 3 dedicated database servers, one of them is a master database with 2 slaves, and the other 2 are stand-alone database servers. All connections are being made by PHP pages on Apache web servers. Most database connections come in through a private pocket network. Network 1 consists of 2 machines on a private LAN using a switch. The NICs on both servers are in full duplex mode. Both servers are running Linux; the web server is running VA Linux 2.2.18pre11-va2.0smp #1 SMP and the database server is running VA Linux 2.4.5-beta4va3.17smp-piii #1 SMP. The database server is a dual PIII with 2GB of RAM running the MySQL 3.23.52 binary. A snapshot shows that aborted_connects are at 149605 when total connections are 2094839. The aborted_connects grow so quickly, so fast, that the server requires a flush-hosts command to allow database connectivity. Network 2 consists of 2 database servers and 4 web servers that communicate on a private LAN using a hub. All 6 of these servers are running FreeBSD 4.6.2; NICs are in full duplex mode. Stand alone server #1 is a PII with 512MB of RAM. A snapshot shows that aborted_connects are at 17789 when total connections are 35490. Stand alone database server #2 is a PIII with 768MB of RAM. A snapshot shows that aborted_connects are at 113537 when total connections are 190162. Both servers are generally connected to through the private network. When the connections come in over the Internet the aborted_connects sky rocket very quickly. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php