ORDER BY problems
Hi all, We are running into trouble with slow queries that use ORDER BY and would like some advice. The main question is: are we experiencing data-modelling/index issues or fundamental restrictions of MySQL. Help would be greatly appreciated - see description below. Patrick -- Say we have three tables: 1- contact (contact_id, name) with contact_id as the primary index and another index on name - name is a CHAR. 6717 records. 2- contact_address_index (index_id, contact_id, address_id ) with index_id as the primary index and two other indexes, one on contact_id, one on address_id. 7580 records. 3- address (address_id, city) with address_id as the primary index and another index on city - city is a CHAR. 7071 records. Note that we can have more than one address per contact and that the same address may be shared by several contacts. The following query takes at least 0.5 seconds using MySQL 3.22.30 (7200 results): SELECT contact.contact_id, last_name, city FROM contact, contact_address_index, address WHERE contact.contact_id = contact_address_index.contact_id AND contact_address_index.address_id = address.address_id ORDER BY last_name The same query without the ORDER BY take less than 0.01 second. explain gives: +---++-+-+-+--+--+-+ | table | type | possible_keys | key | key_len | |ref | rows | Extra | +---++-+-+-+--+--+-+ | contact_address_index | index | address_idx,contact_idx | contact_idx | 8 | |NULL | 7580 | Using index | | contact | eq_ref | PRIMARY | PRIMARY | 4 | |contact_address_index.contact_id |1 | | | address | eq_ref | PRIMARY | PRIMARY | 4 | |contact_address_index.address_id |1 | | +---++-+-+-+--+--+-+ on MySQL 3.23.39, a query like SELECT contact.contact_id, last_name, city FROM contact USE INDEX( name_idx ) , contact_address_index, address WHERE contact.contact_id = contact_address_index.contact_id AND contact_address_index.address_id = address.address_id ORDER BY last_name where name_idx is the index on name (contact table) helps but still take 0.16 seconds. It is not a good solution to force the index anyway as if the WHERE of the query is more complicated it may be better to use another index. Using inner join under MySQL 3.23 doesn't help. Any help/ideas would be gratefully received. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Howmany databases??
Hello, I would like to know that how many databases can i use for one site at max? Hopeing for kind help -PT - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: AW: MySQL is hogging my box
I assume you've done the slow-query-log review thing... making sure all your queries are fast, yes? Yes, you're right. After I did the myisamchk, the box has been more or less stable with loads from 10 to 15. Still seems a lot ot me. I've checked slow-query-log and only seemed to have one slow query every 4 or 5 minutes. -- Luis Calero Muñoz $email{luis} = '[EMAIL PROTECTED]' $who{luis} = 'sysadm at ociojoven dot 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: replication bug
On Tue, Sep 18, 2001 at 10:17:26PM -0700, Jeremy Zawodny wrote: On Tue, Sep 18, 2001 at 09:54:51PM -0700, Gabe E. Nydick wrote: I have a large set of tables that are 1-way replicating to an identical machine as the master db, and for some reason 1 table doesn't make it into the binary log. Why would updates to 1 specific table not make it into the binary log? What's the relvant section of your my.cnf file on the master look like? Just bin-log, or is there more there? Err, log-bin, not bin-log. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 13 days, processed 242,448,830 queries (213/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ORDER BY problems
Hi all, We are running into trouble with slow queries that use ORDER BY and would like some advice. The main question is: are we experiencing data-modelling/index issues or fundamental restrictions of MySQL. Help would be greatly appreciated - see description below. Patrick -- Say we have three tables: 1- contact (contact_id, name) with contact_id as the primary index and another index on name - name is a CHAR. 6717 records. 2- contact_address_index (index_id, contact_id, address_id ) with index_id as the primary index and two other indexes, one on contact_id, one on address_id. 7580 records. 3- address (address_id, city) with address_id as the primary index and another index on city - city is a CHAR. 7071 records. Note that we can have more than one address per contact and that the same address may be shared by several contacts. The following query takes at least 0.5 seconds using MySQL 3.22.30 (7200 results): SELECT contact.contact_id, last_name, city FROM contact, contact_address_index, address WHERE contact.contact_id = contact_address_index.contact_id AND contact_address_index.address_id = address.address_id ORDER BY last_name The same query without the ORDER BY take less than 0.01 second. explain gives: +---++-+-+-+--+--+-+ | table | type | possible_keys | key | key_len | |ref | rows | Extra | +---++-+-+-+--+--+-+ | contact_address_index | index | address_idx,contact_idx | contact_idx | 8 | |NULL | 7580 | Using index | | contact | eq_ref | PRIMARY | PRIMARY | 4 | |contact_address_index.contact_id |1 | | | address | eq_ref | PRIMARY | PRIMARY | 4 | |contact_address_index.address_id |1 | | +---++-+-+-+--+--+-+ on MySQL 3.23.39, a query like SELECT contact.contact_id, last_name, city FROM contact USE INDEX( name_idx ) , contact_address_index, address WHERE contact.contact_id = contact_address_index.contact_id AND contact_address_index.address_id = address.address_id ORDER BY last_name where name_idx is the index on name (contact table) helps but still take 0.16 seconds. It is not a good solution to force the index anyway as if the WHERE of the query is more complicated it may be better to use another index. Using inner join under MySQL 3.23 doesn't help. Any help/ideas would be gratefully received. -- #===# \ KAN International Ltd/ / T: +44 (0)1223 511134\ \ F: +44 (0)1223 571968/ / E: mailto:[EMAIL PROTECTED] \ \ W: http://www.kan.co.uk / #===# - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
BDB table : different results on adjacent queries
hi all we encountered the following: - altered table type to 'BDB' - did 2 identical queries - got different result sets ! after restart of MySQL the very next query gave the correct results, the next did NOT. any ideas? Thanx in advance Andreas Schoelver -- Andreas Schoelver (AS) mailto: [EMAIL PROTECTED] mailto: [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
Faliue: Write huge binary data to blob Field of mysql use jdbc
Hi all: We are making a project about document manage ,I use org.gjt.mm.mysql as jdbc to communicate with mysql. I can succeed in writing the binary data (the size about 14M) to database ,but when I write the binary data that's size exceed 20M I get a Exception. Please help me! Thanks! The Exception : Error:java.sql.SQLException: Communication link failure: java.net.SocketExceptio n java.sql.SQLException: Communication link failure: java.net.SocketException at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:459) at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:885) at org.gjt.mm.mysql.PreparedStatement.execute(PreparedStatement.java:109 3) at com.dextra.java.unijdbc.UniJdbc.exePrepareStatement(UniJdbc.java:312) at com.dextra.java.unijdbc.UniJdbc.main(UniJdbc.java:970) _ Äú¿ÉÒÔÔÚ MSN Hotmail Õ¾µã http://www.hotmail.com/cn Ãâ·ÑÊÕ·¢µç×ÓÓʼþ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Tabitha Ridwan writes: How to install MySQLGUI under redhat 6.2 ? What about it? Are you wondering how to do it? Have you tried and failed? If so, why don't you want to let anyone know what you did and what errors you got? Vague questions deserve vague answers. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL-String mit group by will nicht....
question textHallo, kann mir jemand sagen, was daran falsch ist ?/text description try sql select mobile_number, count(correct) anzahl from answers where correct = '1' and anzahl = 5 and DATE_FORMAT(date, '%Y%m%d%H%i') = DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 9 DAY), '%Y%m%d0700') AND DATE_FORMAT(date, '%Y%m%d%H%i') DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 4 DAY), '%Y%m%d0700') group by mobile_number /sql errorunknown column anzahl in where clause/error /try !-- anders: -- try sql select mobile_number, count(correct) from answers where correct = '1' and count(correct) = 5 and DATE_FORMAT(date, '%Y%m%d%H%i') = DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 9 DAY), '%Y%m%d0700') AND DATE_FORMAT(date, '%Y%m%d%H%i') DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 4 DAY), '%Y%m%d0700') group by mobile_number /sql errorFehlermeldung: Invalid use of group function/error /try !-- selbst bei diesem hier kommt die gleiche fehlermeldung: -- try sql select mobile_number, count(correct) from answers where correct = '1' and count(correct) = 5 group by mobile_number /sql errorFehlermeldung: Invalid use of group function/error /try /description /question !-- Sorry wegen den tags, aber als ich versucht habe die nachricht etwas übersichtlicher zu gestalten, hat mein XML geplagters hirn die kontrolle übernommen.. Allerdings bin ich mir der kommentare nicht sicher :) auch fehlen noch ein paar header sowie die dtd DAS PROBELM ist aber ernst gemeint! -- -- Florian Schmidt mailto:[EMAIL PROTECTED] http://www.f-24.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: rpm install error
kernel version 2.2 how do i find out my Red Hat version? its not installed through rpm...i think... MySQL-3.23.42-1.i386.rpm MySQL-client-3.23.42-1.i386.rpm MySQL-shared-3.23.42-1.i386.rpm installing shared : no problem when installing client i get : group man does not exist - using root (13 times) installing server : mysqld restarted Number of processes running now: 2 mysqld process hanging, pid 28666 - killed mysqld process hanging, pid 28665 - killed 010919 11:27:22 mysqld restarted /usr/bin/safe_mysqld: line 273: 28693 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 restart process number keeps changing, and message keeps repeating... please help!! thanks -paulo - Original Message - From: Sasha Pachev [EMAIL PROTECTED] To: powlow [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 18, 2001 2:14 PM Subject: Re: rpm install error On Tuesday 18 September 2001 03:16, powlow wrote: latest rpm on redhat MySQL-3.23.42-1.i386.rpm any ideas? i've installed and compile mysql on other machines before and never had any problems (appart from sock file which was easily solved). Provide the output of mysqlbug... Also, what version of RedHat? -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: MySQL is hogging my box
There are some others with a similar problem(including me). Hi guys. I'd be really interested in knowing things like how many requests, and of what type, are being made of your database(s). If you're making a couple of dozen SELECTs per day, then I'd say that you have a problem, but if you're doing 500,000,000 INSERTs and 1 Bil. SELECTs, then I could see some call for your systems to slow down. Here are my relevant data: Hardware: DualPentium 1GHz with 2GB RAM and a RAID5 HD-Array MySQL: 3.23.37 average of 20 queries/second peak about 40 or 50 Only small tables with a few thousand entries per table now the special: there is a merge table that merges 10 other tables sometimes i access the MyISAM tables, sometime the mergetable about 90% read operations. Sometimes 2-3 times per day the load average raises above 50 in a few seconds and fall back (a bit slower) below 1. During the time of the high LoadAverage i get too many connections errors. It's not traffic depended (well of course it's more often at high traffic times, but it occured in low traffic times, too) as far as i can see. My suspicion is that something is wrong with the mergetable... I set the log-slow-queries and after the describes behavior i can only find queries which accessing the merge table in the slow.log. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: rpm install error
oops. its suse...damn still...any ideas? -powlow - Original Message - From: powlow [EMAIL PROTECTED] To: Sasha Pachev [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 11:17 AM Subject: Re: rpm install error kernel version 2.2 how do i find out my Red Hat version? its not installed through rpm...i think... MySQL-3.23.42-1.i386.rpm MySQL-client-3.23.42-1.i386.rpm MySQL-shared-3.23.42-1.i386.rpm installing shared : no problem when installing client i get : group man does not exist - using root (13 times) installing server : mysqld restarted Number of processes running now: 2 mysqld process hanging, pid 28666 - killed mysqld process hanging, pid 28665 - killed 010919 11:27:22 mysqld restarted /usr/bin/safe_mysqld: line 273: 28693 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 restart process number keeps changing, and message keeps repeating... please help!! thanks -paulo - Original Message - From: Sasha Pachev [EMAIL PROTECTED] To: powlow [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 18, 2001 2:14 PM Subject: Re: rpm install error On Tuesday 18 September 2001 03:16, powlow wrote: latest rpm on redhat MySQL-3.23.42-1.i386.rpm any ideas? i've installed and compile mysql on other machines before and never had any problems (appart from sock file which was easily solved). Provide the output of mysqlbug... Also, what version of RedHat? -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: rpm install error
its actually not an installation problem. just starting the server. if i try to run mysqld (not safe-mysqld) i get this message : linux:/var/lib/mysql # mysqld Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 010919 12:35:58 Aborting 010919 12:35:58 mysqld: Shutdown Complete i'm looking at the manual now. any comments on this. some stuff seems to be owned by mysql, some by root... -powlow - Original Message - From: powlow [EMAIL PROTECTED] To: Sasha Pachev [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 11:48 AM Subject: Re: rpm install error oops. its suse...damn still...any ideas? -powlow - Original Message - From: powlow [EMAIL PROTECTED] To: Sasha Pachev [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 11:17 AM Subject: Re: rpm install error kernel version 2.2 how do i find out my Red Hat version? its not installed through rpm...i think... MySQL-3.23.42-1.i386.rpm MySQL-client-3.23.42-1.i386.rpm MySQL-shared-3.23.42-1.i386.rpm installing shared : no problem when installing client i get : group man does not exist - using root (13 times) installing server : mysqld restarted Number of processes running now: 2 mysqld process hanging, pid 28666 - killed mysqld process hanging, pid 28665 - killed 010919 11:27:22 mysqld restarted /usr/bin/safe_mysqld: line 273: 28693 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 restart process number keeps changing, and message keeps repeating... please help!! thanks -paulo - Original Message - From: Sasha Pachev [EMAIL PROTECTED] To: powlow [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 18, 2001 2:14 PM Subject: Re: rpm install error On Tuesday 18 September 2001 03:16, powlow wrote: latest rpm on redhat MySQL-3.23.42-1.i386.rpm any ideas? i've installed and compile mysql on other machines before and never had any problems (appart from sock file which was easily solved). Provide the output of mysqlbug... Also, what version of RedHat? -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
can't find my my.cnf or data directory
i can't find my my.cnf or data directory. i am going nuts here...these may seem like stupid questions but i'm not even thinking logically any more... any help is much appreciated. tahnks -powlow - Original Message - From: powlow [EMAIL PROTECTED] To: Sasha Pachev [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 12:25 PM Subject: Re: rpm install error its actually not an installation problem. just starting the server. if i try to run mysqld (not safe-mysqld) i get this message : linux:/var/lib/mysql # mysqld Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 010919 12:35:58 Aborting 010919 12:35:58 mysqld: Shutdown Complete i'm looking at the manual now. any comments on this. some stuff seems to be owned by mysql, some by root... -powlow - Original Message - From: powlow [EMAIL PROTECTED] To: Sasha Pachev [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 11:48 AM Subject: Re: rpm install error oops. its suse...damn still...any ideas? -powlow - Original Message - From: powlow [EMAIL PROTECTED] To: Sasha Pachev [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 11:17 AM Subject: Re: rpm install error kernel version 2.2 how do i find out my Red Hat version? its not installed through rpm...i think... MySQL-3.23.42-1.i386.rpm MySQL-client-3.23.42-1.i386.rpm MySQL-shared-3.23.42-1.i386.rpm installing shared : no problem when installing client i get : group man does not exist - using root (13 times) installing server : mysqld restarted Number of processes running now: 2 mysqld process hanging, pid 28666 - killed mysqld process hanging, pid 28665 - killed 010919 11:27:22 mysqld restarted /usr/bin/safe_mysqld: line 273: 28693 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 restart process number keeps changing, and message keeps repeating... please help!! thanks -paulo - Original Message - From: Sasha Pachev [EMAIL PROTECTED] To: powlow [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 18, 2001 2:14 PM Subject: Re: rpm install error On Tuesday 18 September 2001 03:16, powlow wrote: latest rpm on redhat MySQL-3.23.42-1.i386.rpm any ideas? i've installed and compile mysql on other machines before and never had any problems (appart from sock file which was easily solved). Provide the output of mysqlbug... Also, what version of RedHat? -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
From clause not allowed in update, delete
I am pretty new to mysql, and have been studying the feesibility of offering a mysql version of my product (currently uses ms sql server). Reading a post to this list yesterday, it came to my attention that there is no FROM clause allowed in either the UPDATE or DELETE statements (actually, the DELETE statement has a FROM clause but you can't, as I understand, JOIN tables there). This will pose significant design challenges for me as my app relies heavily on this functionality. So far, I have conceived 2 ways to work around this limitation. 1. Use CREATE TEMPORARY TABLE (...) SELECT (with my join); Then, REPLACE INTO ... SELECT. (Note, for deletes, it would be necessesary to carry a flag field which would be updated using the above process and then DELETE ... WHERE flag = set) 2. Build an app with the C API which will simulate the functionality in two steps. (Note, this would be a pain!) Getting to my question... Surely this gaping whole in the functionality spectrum has inspired the creativity of many in this group. Would anyone care to share the details of solutions they have invented to work around this limitation? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 message?
Hi, I am trying to use PHP and MySQL together on a script that I installed. I got an error message of the following on my browser when I try to execute the PHP file: Warning: Supplied argument is not a valid MySQL result resource in /usr/local/apache/htdocs/authen/authlib/backend.php on line 98 Warning: Supplied argument is not a valid MySQL result resource in /usr/local/apache/htdocs/authen/authlib/backend.php on line 109 Error : Unknown database failure, please try later. Then I get the following error in telnet mode when I try to type show tables on the databases : Ignoring query to other database mysql I would like to ask your opinions about what is happening in this case. I have never encountered the Ignoring query to other database error before. Thanks Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Daemon starts at boot then Terminates??
Since you failed to check the error log and post it here I can only guess. chown -R mysql /usr/local/mysql R Talbot wrote: I have deleted the Mysql 3.22.32 install and compiled source for and installed Mysql 3.23.40. The new installation resides at /usr/local/mysql. Make Test did fail onlymerge From the command line The daemon starts perfectly with either mysql.server startor safe mysqld but when started by /etc/rc.d/ini.d/mysql.server I see recorded during boot Starting mysqld daimon with databases from /usr/local/mysql/var Starting rstat services: rpc.rstatd010918 12:55 mysqld ended (what's that all about) and why does it shut down I used to start v. 3.22.32 by the same method.. any HELP!!! mysql.server directory references are PATH=/sbin:/usr/sbin:/bin:/usr/bin basedir=/usr/local/mysql bindir=/usr/local/mysql/bin datadir=/usr/local/mysql/var pid_file=/usr/local/mysql/var/mysqld.pid mysql_daemon_user=root # Run mysqld as this user. export PATH I copied and the mysql.server to /etc/rc.d/init.d/ and then linked ln -s /etc/rc.d/init.d/mysql.server /etc/rc.d/rc5.d/S35mysql ln -s /etc/rc.d/init.d/mysql.server /etc/rc.d/rc0.d/K01mysql Also the end of make install asked me to do the following something like mysqladmin -u root -p password = newpassword ('data') mysqladmin -h mymachine.peer -p password = newpassword ('data') ( I hope I remembered that correctly) I am baffled my next step will be entries to my.cnf BOb T - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: rpm install error
On Wednesday 19 September 2001 04:48, powlow wrote: oops. its suse...damn still...any ideas? -powlow uname -a Does it show kernel 2.2.14? If yes, upgrade the kernel. SuSE introduced a special safety feature into their 2.2.14 kernel that makes our binary coredump right away. They got rid of it it later versions. And while I am on the subject - we are aware of an I/O bug in 2.2.14 kernel ( even without the special safety patch from SuSE) that make MySQL corrupt tables under heavy load. Two of our users were running 2.2.14 kernel and were getting their tables randomly corrupted. The problems went away after upgrade to 2.2.10. So if you are running 2.2.14 SuSE kernel, you have two reasons to upgrade. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Managing MySQL /w large tables
Hello: I am runnin' a mysql DB with about 90mil entries. on a 1Ghz system with 1G ram, it takes forever to get anything out, i have even tryed selecting the data into a file. Is there any tricks/tips anyone can give me for managing large DB's? It also likes to crash tables every month or so to =) I was reading in the manual that u could up some of the cache sizes, /usr/local/mysql/bin/safe_mysqld --user=mysql -O key_buffer=64M -O table_cache=256 \ -O sort_buffer=4M -O record_buffer=1M would making any of these bigger help at all? _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.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
SV: Simple SELECT query (or so I thought)
If you change you order by to order by username, wucount desc, rank desc Won't this group it the way you want it ?? Terje K -Opprinnelig melding- Fra: Solsberry, Glendon [mailto:[EMAIL PROTECTED]] Sendt: 19. september 2001 15:29 Til: '[EMAIL PROTECTED]' Emne: Simple SELECT query (or so I thought) Can anybody help me out with this??? This would make life so much easier for my poor stats package. Anyone? -Original Message- From: Solsberry, Glendon Sent: Friday, September 14, 2001 10:17 AM To: MySQL Subject: Simple SELECT query (or so I thought) I am running a stats page for our Genome@Home team, and I'm trying to get a simple SELECT that will get the data that I need... Ok, I have a table setup like this: Genomestats --- username varchar(255) curDate datetime wucount bigint genecount bigint updates int rank int teamnumberbigint A sample record from the table may look like this: |DP | 2001-08-24 16:00:00 | 25786 | 1588 | 1 | 24 | 983928120| My SELECT looks like this (note that the dates are dynamically generated): SELECT * FROM genomestats WHERE curDate IN ('$curDate', '$lastUpdate', '$lastDay') order by wucount desc, rank desc; Where $curDate is the most recent data update, $lastUpdate is the update from 3 hours ago, and $lastDay is the update from 24 hours ago. When I execute the SQL, and print the resulting recordset to my log file, I get data like this: junior || 2001-09-14 06:30:00 || 51819 || 3019 || 156 || 11 || 983928120 junior || 2001-09-14 03:30:00 || 51743 || 3014 || 155 || 11 || 983928120 junior || 2001-09-13 06:30:00 || 51480 || 2997 || 149 || 11 || 983928120 IronBits || 2001-09-14 06:30:00 || 50787 || 3021 || 156 || 12 || 983928120 IronBits || 2001-09-14 03:30:00 || 50712 || 3016 || 155 || 12 || 983928120 Zoso || 2001-09-14 06:30:00 || 50549 || 2917 || 156 || 13 || 983928120 Zoso || 2001-09-14 03:30:00 || 50505 || 2914 || 155 || 13 || 983928120 Zoso || 2001-09-13 06:30:00 || 50188 || 2893 || 149 || 12 || 983928120 IronBits || 2001-09-13 06:30:00 || 50181 || 2982 || 149 || 13 || 983928120 Now, the problem is that the user IronBits had a wucount at somepoint (in the last 24 hours here) that was less than Zoso's wucount. Basically, this means that IronBits passed Zoso sometime in the past 24 hours. I need to have all of the data grouped by the username, but if I add in group by username, then I only get one set of records, not 3, as shown above. Here is what I want: junior || 2001-09-14 06:30:00 || 51819 || 3019 || 156 || 11 || 983928120 junior || 2001-09-14 03:30:00 || 51743 || 3014 || 155 || 11 || 983928120 junior || 2001-09-13 06:30:00 || 51480 || 2997 || 149 || 11 || 983928120 IronBits || 2001-09-14 06:30:00 || 50787 || 3021 || 156 || 12 || 983928120 IronBits || 2001-09-14 03:30:00 || 50712 || 3016 || 155 || 12 || 983928120 IronBits || 2001-09-13 06:30:00 || 50181 || 2982 || 149 || 13 || 983928120 Zoso || 2001-09-14 06:30:00 || 50549 || 2917 || 156 || 13 || 983928120 Zoso || 2001-09-14 03:30:00 || 50505 || 2914 || 155 || 13 || 983928120 Zoso || 2001-09-13 06:30:00 || 50188 || 2893 || 149 || 12 || 983928120 But I can't think of a good, simple way to do this. Anyone have any ideas? - Glendon Solsberry Internet Programmer Tricon Global Restaurants tel. (502) 874-6736 fax (502) 874-8818 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Simple SELECT query (or so I thought)
Three things to try One use distinct Two use temp table Three use oracle and unions Simon -Original Message- From: Terje Kristensen [mailto:[EMAIL PROTECTED]] Sent: 19 September 2001 14:39 To: Solsberry, Glendon; [EMAIL PROTECTED] Subject: SV: Simple SELECT query (or so I thought) If you change you order by to order by username, wucount desc, rank desc Won't this group it the way you want it ?? Terje K -Opprinnelig melding- Fra: Solsberry, Glendon [mailto:[EMAIL PROTECTED]] Sendt: 19. september 2001 15:29 Til: '[EMAIL PROTECTED]' Emne: Simple SELECT query (or so I thought) Can anybody help me out with this??? This would make life so much easier for my poor stats package. Anyone? -Original Message- From: Solsberry, Glendon Sent: Friday, September 14, 2001 10:17 AM To: MySQL Subject: Simple SELECT query (or so I thought) I am running a stats page for our Genome@Home team, and I'm trying to get a simple SELECT that will get the data that I need... Ok, I have a table setup like this: Genomestats --- username varchar(255) curDate datetime wucount bigint genecount bigint updates int rank int teamnumberbigint A sample record from the table may look like this: |DP | 2001-08-24 16:00:00 | 25786 | 1588 | 1 | 24 | 983928120| My SELECT looks like this (note that the dates are dynamically generated): SELECT * FROM genomestats WHERE curDate IN ('$curDate', '$lastUpdate', '$lastDay') order by wucount desc, rank desc; Where $curDate is the most recent data update, $lastUpdate is the update from 3 hours ago, and $lastDay is the update from 24 hours ago. When I execute the SQL, and print the resulting recordset to my log file, I get data like this: junior || 2001-09-14 06:30:00 || 51819 || 3019 || 156 || 11 || 983928120 junior || 2001-09-14 03:30:00 || 51743 || 3014 || 155 || 11 || 983928120 junior || 2001-09-13 06:30:00 || 51480 || 2997 || 149 || 11 || 983928120 IronBits || 2001-09-14 06:30:00 || 50787 || 3021 || 156 || 12 || 983928120 IronBits || 2001-09-14 03:30:00 || 50712 || 3016 || 155 || 12 || 983928120 Zoso || 2001-09-14 06:30:00 || 50549 || 2917 || 156 || 13 || 983928120 Zoso || 2001-09-14 03:30:00 || 50505 || 2914 || 155 || 13 || 983928120 Zoso || 2001-09-13 06:30:00 || 50188 || 2893 || 149 || 12 || 983928120 IronBits || 2001-09-13 06:30:00 || 50181 || 2982 || 149 || 13 || 983928120 Now, the problem is that the user IronBits had a wucount at somepoint (in the last 24 hours here) that was less than Zoso's wucount. Basically, this means that IronBits passed Zoso sometime in the past 24 hours. I need to have all of the data grouped by the username, but if I add in group by username, then I only get one set of records, not 3, as shown above. Here is what I want: junior || 2001-09-14 06:30:00 || 51819 || 3019 || 156 || 11 || 983928120 junior || 2001-09-14 03:30:00 || 51743 || 3014 || 155 || 11 || 983928120 junior || 2001-09-13 06:30:00 || 51480 || 2997 || 149 || 11 || 983928120 IronBits || 2001-09-14 06:30:00 || 50787 || 3021 || 156 || 12 || 983928120 IronBits || 2001-09-14 03:30:00 || 50712 || 3016 || 155 || 12 || 983928120 IronBits || 2001-09-13 06:30:00 || 50181 || 2982 || 149 || 13 || 983928120 Zoso || 2001-09-14 06:30:00 || 50549 || 2917 || 156 || 13 || 983928120 Zoso || 2001-09-14 03:30:00 || 50505 || 2914 || 155 || 13 || 983928120 Zoso || 2001-09-13 06:30:00 || 50188 || 2893 || 149 || 12 || 983928120 But I can't think of a good, simple way to do this. Anyone have any ideas? - Glendon Solsberry Internet Programmer Tricon Global Restaurants tel. (502) 874-6736 fax (502) 874-8818 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Simple SELECT query (or so I thought)
I am not possitive that I completely follow what you are trying to do... but, here goes: What if you create a temporary table first: CREATE TEMPORARY TABLE tu ( usernamevarchar(255), maxwucount bigint, maxrank int ) SELECT username, max(wucount) as maxwucount, max(rank) as maxrank FROM genomestats WHERE curDate IN ('$curDate', '$lastUpdate', '$lastDay') GROUP BY username; Then: SELECT genomestats.* FROMgenomestats INNER JOIN tu ON genomestats.username = tu.username WHERE genomestats.curDate IN ('$curDate', '$lastUpdate', '$lastDay') ORDER BY tu.maxwucount desc, tu.maxrank desc, tu.username, genomestats.wucount desc, genomestats.rank desc I've seen the other suggestions telling you to just add the username to your order by but if I understand your situation this would not work because it would not satisfy your wish to have the list sorted with the highest wucount/rank first... right? -Original Message- From: Solsberry, Glendon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 9:29 AM To: '[EMAIL PROTECTED]' Subject: Simple SELECT query (or so I thought) Can anybody help me out with this??? This would make life so much easier for my poor stats package. Anyone? -Original Message- From: Solsberry, Glendon Sent: Friday, September 14, 2001 10:17 AM To: MySQL Subject: Simple SELECT query (or so I thought) I am running a stats page for our Genome@Home team, and I'm trying to get a simple SELECT that will get the data that I need... Ok, I have a table setup like this: Genomestats --- usernamevarchar(255) curDate datetime wucount bigint genecount bigint updates int rankint teamnumber bigint A sample record from the table may look like this: |DP | 2001-08-24 16:00:00 | 25786 | 1588 | 1 | 24 | 983928120| My SELECT looks like this (note that the dates are dynamically generated): SELECT * FROM genomestats WHERE curDate IN ('$curDate', '$lastUpdate', '$lastDay') order by wucount desc, rank desc; Where $curDate is the most recent data update, $lastUpdate is the update from 3 hours ago, and $lastDay is the update from 24 hours ago. When I execute the SQL, and print the resulting recordset to my log file, I get data like this: junior || 2001-09-14 06:30:00 || 51819 || 3019 || 156 || 11 || 983928120 junior || 2001-09-14 03:30:00 || 51743 || 3014 || 155 || 11 || 983928120 junior || 2001-09-13 06:30:00 || 51480 || 2997 || 149 || 11 || 983928120 IronBits || 2001-09-14 06:30:00 || 50787 || 3021 || 156 || 12 || 983928120 IronBits || 2001-09-14 03:30:00 || 50712 || 3016 || 155 || 12 || 983928120 Zoso || 2001-09-14 06:30:00 || 50549 || 2917 || 156 || 13 || 983928120 Zoso || 2001-09-14 03:30:00 || 50505 || 2914 || 155 || 13 || 983928120 Zoso || 2001-09-13 06:30:00 || 50188 || 2893 || 149 || 12 || 983928120 IronBits || 2001-09-13 06:30:00 || 50181 || 2982 || 149 || 13 || 983928120 Now, the problem is that the user IronBits had a wucount at somepoint (in the last 24 hours here) that was less than Zoso's wucount. Basically, this means that IronBits passed Zoso sometime in the past 24 hours. I need to have all of the data grouped by the username, but if I add in group by username, then I only get one set of records, not 3, as shown above. Here is what I want: junior || 2001-09-14 06:30:00 || 51819 || 3019 || 156 || 11 || 983928120 junior || 2001-09-14 03:30:00 || 51743 || 3014 || 155 || 11 || 983928120 junior || 2001-09-13 06:30:00 || 51480 || 2997 || 149 || 11 || 983928120 IronBits || 2001-09-14 06:30:00 || 50787 || 3021 || 156 || 12 || 983928120 IronBits || 2001-09-14 03:30:00 || 50712 || 3016 || 155 || 12 || 983928120 IronBits || 2001-09-13 06:30:00 || 50181 || 2982 || 149 || 13 || 983928120 Zoso || 2001-09-14 06:30:00 || 50549 || 2917 || 156 || 13 || 983928120 Zoso || 2001-09-14 03:30:00 || 50505 || 2914 || 155 || 13 || 983928120 Zoso || 2001-09-13 06:30:00 || 50188 || 2893 || 149 || 12 || 983928120 But I can't think of a good, simple way to do this. Anyone have any ideas? - Glendon Solsberry Internet Programmer Tricon Global Restaurants tel. (502) 874-6736 fax (502) 874-8818 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Re: Managing MySQL /w large tables
Phillip Spademan writes: I am runnin' a mysql DB with about 90mil entries. on a 1Ghz system with 1G ram, it takes forever to get anything out, i have even tryed selecting the data into a file. Is there any tricks/tips anyone can give me for managing large DB's? Spend some time on rethinking your database design and your queries. It also likes to crash tables every month or so to =) I can't see why this would be a good thing, and as you don't say why I can't tell you what to do about it either. If you're using kill -9 on mysqld, stop it. If you're doing things to the table files while mysqld is running, don't. I was reading in the manual that u could up some of the cache sizes, /usr/local/mysql/bin/safe_mysqld --user=mysql -O key_buffer=64M -O table_cache=256 \ -O sort_buffer=4M -O record_buffer=1M Of course, otherwise there'd me no point in having them. If you have a gigabyte of RAM I see no point in not letting mysqld use at least a few hundred megabytes or so just for buffers. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Oops... I think I deleted mysql.sock - WHAT CAN I DO?
Oops... I think I deleted mysql.sock - WHAT CAN I DO? I'm not a linux guy... I don't fly trough this OS... Could you help me? I'm really hurried! Felipe Baytelman BayTex Producciones [EMAIL PROTECTED] http://www.baytex.net ICQ: 8188532 Chile: (09) 879 01 67World: (569) 879 01 67 Postal: Ernesto Hevia 5885 - La Reina - Santiago - Chile - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Oops... I think I deleted mysql.sock - WHAT CAN I DO?
Felipe Baytelman writes: Oops... I think I deleted mysql.sock - WHAT CAN I DO? Just restart mysqld and it'll be created. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Oops... I think I deleted mysql.sock - WHAT CAN I DO?
So sprach »Felipe Baytelman« am 2001-09-19 um 10:32:14 -0400 : Oops... I think I deleted mysql.sock - WHAT CAN I DO? Become root, and do: mksock /var/lib/mysql/mysql.sock chmod 777 /var/lib/mysql/mysql.sock chown user.group /var/lib/mysql/mysql.sock replace user and group by the user/group the mysql process runs under. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 2 hours 53 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bad table and mysql 3.23.42
Hi! Adams, == Adams, Bill TQO [EMAIL PROTECTED] writes: Adams, Peter Zaitsev wrote: I'm quite lucky with providing with bad tables which does not repear properly or having other strange behavior. Adams, Sometimes when myisamchk does not work (or it says it has repaired the table Adams, but it quickly become corrupted again), I find that dumping and reloading Adams, the table is the best, sure way to repair it. Any chance you could spend one hour next time this happens and try to create a testcase that crashes the table again? If there is a bug in MyISAM, we would REALLY like to find it! Doing myisamchk -r should provide you with the same index and datafile as if you use mysqldump, so I can't see how this could be relevant. Are you sure you didn't use myisamchk -r at the same time MySQL had open/was using the table ? Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Oops... I think I deleted mysql.sock - WHAT CAN I DO?
I think you should be safe to just restart MySQL On Wednesday 19 September 2001 08:32 am, Felipe Baytelman wrote: Oops... I think I deleted mysql.sock - WHAT CAN I DO? I'm not a linux guy... I don't fly trough this OS... Could you help me? I'm really hurried! Felipe Baytelman BayTex Producciones [EMAIL PROTECTED] http://www.baytex.net ICQ: 8188532 Chile: (09) 879 01 67World: (569) 879 01 67 Postal: Ernesto Hevia 5885 - La Reina - Santiago - Chile - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Dear MYSQL, I Received an Unexpected Error 1034 and am Reporting It
Description: Hello, I've been using MY-SQL with 3 tables, which all have the same primary key = CHAR(2), VARCHAR(50). Everything was fine for several months but yesterday I received an ERROR 1034 in mysql stating that the key file for one of the tables was incorrect. I was able to fix the index with MYISAMCHK but I am reporting this because I do not know why this error occurred. How-To-Repeat: I am not sure if this error can be easily reproduced. I have about 35,000 records in the main table and 7,000 records in the second table, and none in the third. Fix: Use MYISAMCHK as documented on the index files for the tables. Submitter-Id: Ateendra Balasingham Originator:root Organization: MySQL support: none Synopsis: Received Table Error 1034, Unknown to PERROR, Fixed W/MYISAMCHK Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.38 (Official MySQL binary) Environment: System: Linux 2.2.16-3 #2 SMP Mon Dec 18 14:27:09 PST 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3 -mpentium -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 13 Sep 7 17:25 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 4106956 Sep 1 2000 /lib/libc-2.1.3.so -rw-r--r--1 root root 20267724 Sep 1 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 1 2000 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqldump problem
Hi The following example gives me a problem. I create a new database by sending the following SQL commands: create database dummy create table `Dummy Table` (`Dummy Time` timestamp(14) NOT NULL) When i run mysqldump with the parameters shown below mysqldump -uroot -pxx -A -a -F -l --opt -rc:/mysql/data/dump.sql I will get a dump file which look like the following section: / # MySQL dump 8.16 # # Host: localhostDatabase: # # Server version3.23.42-log # # Current Database: dummy # CREATE DATABASE /*!32312 IF NOT EXISTS*/ dummy; USE dummy; # # Table structure for table 'dummy table' # DROP TABLE IF EXISTS `dummy table`; CREATE TABLE dummy table ( Dummy Time timestamp(14) NOT NULL ) TYPE=MyISAM; # # Dumping data for table 'dummy table' # LOCK TABLES `dummy table` WRITE; UNLOCK TABLES; / As you can see drop table uses the ` character around dummy table, but don't use it in the create CREATE TABLE statement. The `character is also missing around the colum name Dummy Time. These two things make it difficult for me to restore the database from the dump file so I hope you can give me some advise. Best regards, RTX Telecom A/S Benny B. Simonsen BB/Project Engineer System Development RTX Telecom A/S Stroemmen 6 DK-9400 Noerresundby. Phone.: +45 96 32 23 00 Fax.: +45 96 32 23 10 E-mail: [EMAIL PROTECTED] Web: www.rtx.dk PS: I am using the win32 version 3.23.42 (mysqld-opt.exe installed as a service on a Win2K platform). I have the following two lines in my.cnf which is at c:\ [mysqld] log-bin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Simple SELECT query (or so I thought)
Well, here is where the problem comes in... Taking the data that I posted: junior || 2001-09-14 06:30:00 || 51819 || 3019 || 156 || 11 || 983928120 junior || 2001-09-14 03:30:00 || 51743 || 3014 || 155 || 11 || 983928120 junior || 2001-09-13 06:30:00 || 51480 || 2997 || 149 || 11 || 983928120 IronBits || 2001-09-14 06:30:00 || 50787 || 3021 || 156 || 12 || 983928120 IronBits || 2001-09-14 03:30:00 || 50712 || 3016 || 155 || 12 || 983928120 Zoso || 2001-09-14 06:30:00 || 50549 || 2917 || 156 || 13 || 983928120 Zoso || 2001-09-14 03:30:00 || 50505 || 2914 || 155 || 13 || 983928120 Zoso || 2001-09-13 06:30:00 || 50188 || 2893 || 149 || 12 || 983928120 IronBits || 2001-09-13 06:30:00 || 50181 || 2982 || 149 || 13 || 983928120 The problem still exists that if someone has a wucount at any point that is higher than anothers. Take Zoso and IronBits for example. On the 13th at 6:30 am, IronBits had a wucount of 50181. But at some point, Zoso had a wucount higher than that of IronBits. So then, the order by fails to sort the data in a way that I'd like. Here's how it should look: junior || 2001-09-14 06:30:00 || 51819 || 3019 || 156 || 11 || 983928120 junior || 2001-09-14 03:30:00 || 51743 || 3014 || 155 || 11 || 983928120 junior || 2001-09-13 06:30:00 || 51480 || 2997 || 149 || 11 || 983928120 IronBits || 2001-09-14 06:30:00 || 50787 || 3021 || 156 || 12 || 983928120 IronBits || 2001-09-14 03:30:00 || 50712 || 3016 || 155 || 12 || 983928120 IronBits || 2001-09-13 06:30:00 || 50181 || 2982 || 149 || 13 || 983928120 Zoso || 2001-09-14 06:30:00 || 50549 || 2917 || 156 || 13 || 983928120 Zoso || 2001-09-14 03:30:00 || 50505 || 2914 || 155 || 13 || 983928120 Zoso || 2001-09-13 06:30:00 || 50188 || 2893 || 149 || 12 || 983928120 I need the usernames grouped together, but the data still sorted on wucount. Ideas? Glen -Original Message- From: Terje Kristensen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 9:39 AM To: Solsberry, Glendon; [EMAIL PROTECTED] Subject: SV: Simple SELECT query (or so I thought) If you change you order by to order by username, wucount desc, rank desc Won't this group it the way you want it ?? Terje K -Opprinnelig melding- Fra: Solsberry, Glendon [mailto:[EMAIL PROTECTED]] Sendt: 19. september 2001 15:29 Til: '[EMAIL PROTECTED]' Emne: Simple SELECT query (or so I thought) Can anybody help me out with this??? This would make life so much easier for my poor stats package. Anyone? -Original Message- From: Solsberry, Glendon Sent: Friday, September 14, 2001 10:17 AM To: MySQL Subject: Simple SELECT query (or so I thought) I am running a stats page for our Genome@Home team, and I'm trying to get a simple SELECT that will get the data that I need... Ok, I have a table setup like this: Genomestats --- username varchar(255) curDate datetime wucount bigint genecount bigint updates int rank int teamnumberbigint A sample record from the table may look like this: |DP | 2001-08-24 16:00:00 | 25786 | 1588 | 1 | 24 | 983928120| My SELECT looks like this (note that the dates are dynamically generated): SELECT * FROM genomestats WHERE curDate IN ('$curDate', '$lastUpdate', '$lastDay') order by wucount desc, rank desc; Where $curDate is the most recent data update, $lastUpdate is the update from 3 hours ago, and $lastDay is the update from 24 hours ago. When I execute the SQL, and print the resulting recordset to my log file, I get data like this: junior || 2001-09-14 06:30:00 || 51819 || 3019 || 156 || 11 || 983928120 junior || 2001-09-14 03:30:00 || 51743 || 3014 || 155 || 11 || 983928120 junior || 2001-09-13 06:30:00 || 51480 || 2997 || 149 || 11 || 983928120 IronBits || 2001-09-14 06:30:00 || 50787 || 3021 || 156 || 12 || 983928120 IronBits || 2001-09-14 03:30:00 || 50712 || 3016 || 155 || 12 || 983928120 Zoso || 2001-09-14 06:30:00 || 50549 || 2917 || 156 || 13 || 983928120 Zoso || 2001-09-14 03:30:00 || 50505 || 2914 || 155 || 13 || 983928120 Zoso || || 2001-09-13 06:30:00 || 50188 || 2893 || 149 || 12 || 983928120 IronBits || 2001-09-13 06:30:00 || 50181 || 2982 || 149 || 13 || 983928120 Now, the problem is that the user IronBits had a wucount at somepoint (in the last 24 hours here) that was less than Zoso's wucount. Basically, this means that IronBits passed Zoso sometime in the past 24 hours. I need to have all of the data grouped by the username, but if I add in group by username, then I only get one set of records, not 3, as shown above. Here is what I want: junior || 2001-09-14 06:30:00 || 51819 || 3019 || 156 || 11 || 983928120 junior || 2001-09-14 03:30:00 || 51743 || 3014 || 155 || 11 || 983928120 junior || 2001-09-13 06:30:00 || 51480 || 2997 || 149 || 11 || 983928120 IronBits || 2001-09-14
RE: Simple SELECT query (or so I thought)
Distinct what? I need all of the data presented. Oracle is not an option, but unions would not solve my problem, I don't think... -Original Message- From: Simon Green [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 9:47 AM To: Terje Kristensen; Solsberry, Glendon; [EMAIL PROTECTED] Subject: RE: Simple SELECT query (or so I thought) Three things to try One use distinct Two use temp table Three use oracle and unions Simon -Original Message- From: Terje Kristensen [mailto:[EMAIL PROTECTED]] Sent: 19 September 2001 14:39 To: Solsberry, Glendon; [EMAIL PROTECTED] Subject: SV: Simple SELECT query (or so I thought) If you change you order by to order by username, wucount desc, rank desc Won't this group it the way you want it ?? Terje K -Opprinnelig melding- Fra: Solsberry, Glendon [mailto:[EMAIL PROTECTED]] Sendt: 19. september 2001 15:29 Til: '[EMAIL PROTECTED]' Emne: Simple SELECT query (or so I thought) Can anybody help me out with this??? This would make life so much easier for my poor stats package. Anyone? -Original Message- From: Solsberry, Glendon Sent: Friday, September 14, 2001 10:17 AM To: MySQL Subject: Simple SELECT query (or so I thought) I am running a stats page for our Genome@Home team, and I'm trying to get a simple SELECT that will get the data that I need... Ok, I have a table setup like this: Genomestats --- username varchar(255) curDate datetime wucount bigint genecount bigint updates int rank int teamnumberbigint A sample record from the table may look like this: |DP | 2001-08-24 16:00:00 | 25786 | 1588 | 1 | 24 | 983928120| My SELECT looks like this (note that the dates are dynamically generated): SELECT * FROM genomestats WHERE curDate IN ('$curDate', '$lastUpdate', '$lastDay') order by wucount desc, rank desc; Where $curDate is the most recent data update, $lastUpdate is the update from 3 hours ago, and $lastDay is the update from 24 hours ago. When I execute the SQL, and print the resulting recordset to my log file, I get data like this: junior || 2001-09-14 06:30:00 || 51819 || 3019 || 156 || 11 || 983928120 junior || 2001-09-14 03:30:00 || 51743 || 3014 || 155 || 11 || 983928120 junior || 2001-09-13 06:30:00 || 51480 || 2997 || 149 || 11 || 983928120 IronBits || 2001-09-14 06:30:00 || 50787 || 3021 || 156 || 12 || 983928120 IronBits || 2001-09-14 03:30:00 || 50712 || 3016 || 155 || 12 || 983928120 Zoso || 2001-09-14 06:30:00 || 50549 || 2917 || 156 || 13 || 983928120 Zoso || 2001-09-14 03:30:00 || 50505 || 2914 || 155 || 13 || 983928120 Zoso || || 2001-09-13 06:30:00 || 50188 || 2893 || 149 || 12 || 983928120 IronBits || 2001-09-13 06:30:00 || 50181 || 2982 || 149 || 13 || 983928120 Now, the problem is that the user IronBits had a wucount at somepoint (in the last 24 hours here) that was less than Zoso's wucount. Basically, this means that IronBits passed Zoso sometime in the past 24 hours. I need to have all of the data grouped by the username, but if I add in group by username, then I only get one set of records, not 3, as shown above. Here is what I want: junior || 2001-09-14 06:30:00 || 51819 || 3019 || 156 || 11 || 983928120 junior || 2001-09-14 03:30:00 || 51743 || 3014 || 155 || 11 || 983928120 junior || 2001-09-13 06:30:00 || 51480 || 2997 || 149 || 11 || 983928120 IronBits || 2001-09-14 06:30:00 || 50787 || 3021 || 156 || 12 || 983928120 IronBits || 2001-09-14 03:30:00 || 50712 || 3016 || 155 || 12 || 983928120 IronBits || 2001-09-13 06:30:00 || 50181 || 2982 || 149 || 13 || 983928120 Zoso || 2001-09-14 06:30:00 || 50549 || 2917 || 156 || 13 || 983928120 Zoso || 2001-09-14 03:30:00 || 50505 || 2914 || 155 || 13 || 983928120 Zoso || || 2001-09-13 06:30:00 || 50188 || 2893 || 149 || 12 || 983928120 But I can't think of a good, simple way to do this. Anyone have any ideas? - Glendon Solsberry Internet Programmer Tricon Global Restaurants tel. (502) 874-6736 fax (502) 874-8818 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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:
RE: Simple SELECT query (or so I thought)
Correct. I need the data sorted by the wucount first, but still have the data grouped together by the username. I don't quite follow the reasoning behind a temp table. Won't I still have the problems of the sorting, or can you explain to me how this will solve that problem? Glen -Original Message- From: Will French [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 9:59 AM To: Solsberry, Glendon; [EMAIL PROTECTED] Subject: RE: Simple SELECT query (or so I thought) I am not possitive that I completely follow what you are trying to do... but, here goes: What if you create a temporary table first: CREATE TEMPORARY TABLE tu ( usernamevarchar(255), maxwucount bigint, maxrank int ) SELECT username, max(wucount) as maxwucount, max(rank) as maxrank FROM genomestats WHERE curDate IN ('$curDate', '$lastUpdate', '$lastDay') GROUP BY username; Then: SELECT genomestats.* FROMgenomestats INNER JOIN tu ON genomestats.username = tu.username WHERE genomestats.curDate IN ('$curDate', '$lastUpdate', '$lastDay') ORDER BY tu.maxwucount desc, tu.maxrank desc, tu.username, genomestats.wucount desc, genomestats.rank desc I've seen the other suggestions telling you to just add the username to your order by but if I understand your situation this would not work because it would not satisfy your wish to have the list sorted with the highest wucount/rank first... right? -Original Message- From: Solsberry, Glendon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 9:29 AM To: '[EMAIL PROTECTED]' Subject: Simple SELECT query (or so I thought) Can anybody help me out with this??? This would make life so much easier for my poor stats package. Anyone? -Original Message- From: Solsberry, Glendon Sent: Friday, September 14, 2001 10:17 AM To: MySQL Subject: Simple SELECT query (or so I thought) I am running a stats page for our Genome@Home team, and I'm trying to get a simple SELECT that will get the data that I need... Ok, I have a table setup like this: Genomestats --- usernamevarchar(255) curDate datetime wucount bigint genecount bigint updates int rankint teamnumber bigint A sample record from the table may look like this: |DP | 2001-08-24 16:00:00 | 25786 | 1588 | 1 | 24 | 983928120| My SELECT looks like this (note that the dates are dynamically generated): SELECT * FROM genomestats WHERE curDate IN ('$curDate', '$lastUpdate', '$lastDay') order by wucount desc, rank desc; Where $curDate is the most recent data update, $lastUpdate is the update from 3 hours ago, and $lastDay is the update from 24 hours ago. When I execute the SQL, and print the resulting recordset to my log file, I get data like this: junior || 2001-09-14 06:30:00 || 51819 || 3019 || 156 || 11 || 983928120 junior || 2001-09-14 03:30:00 || 51743 || 3014 || 155 || 11 || 983928120 junior || 2001-09-13 06:30:00 || 51480 || 2997 || 149 || 11 || 983928120 IronBits || 2001-09-14 06:30:00 || 50787 || 3021 || 156 || 12 || 983928120 IronBits || 2001-09-14 03:30:00 || 50712 || 3016 || 155 || 12 || 983928120 Zoso || 2001-09-14 06:30:00 || 50549 || 2917 || 156 || 13 || 983928120 Zoso || 2001-09-14 03:30:00 || 50505 || 2914 || 155 || 13 || 983928120 Zoso || || 2001-09-13 06:30:00 || 50188 || 2893 || 149 || 12 || 983928120 IronBits || 2001-09-13 06:30:00 || 50181 || 2982 || 149 || 13 || 983928120 Now, the problem is that the user IronBits had a wucount at somepoint (in the last 24 hours here) that was less than Zoso's wucount. Basically, this means that IronBits passed Zoso sometime in the past 24 hours. I need to have all of the data grouped by the username, but if I add in group by username, then I only get one set of records, not 3, as shown above. Here is what I want: junior || 2001-09-14 06:30:00 || 51819 || 3019 || 156 || 11 || 983928120 junior || 2001-09-14 03:30:00 || 51743 || 3014 || 155 || 11 || 983928120 junior || 2001-09-13 06:30:00 || 51480 || 2997 || 149 || 11 || 983928120 IronBits || 2001-09-14 06:30:00 || 50787 || 3021 || 156 || 12 || 983928120 IronBits || 2001-09-14 03:30:00 || 50712 || 3016 || 155 || 12 || 983928120 IronBits || 2001-09-13 06:30:00 || 50181 || 2982 || 149 || 13 || 983928120 Zoso || 2001-09-14 06:30:00 || 50549 || 2917 || 156 || 13 || 983928120 Zoso || 2001-09-14 03:30:00 || 50505 || 2914 || 155 || 13 || 983928120 Zoso || || 2001-09-13 06:30:00 || 50188 || 2893 || 149 || 12 || 983928120 But I can't think of a good, simple way to do this. Anyone have any ideas? - Glendon Solsberry Internet Programmer Tricon Global Restaurants tel. (502) 874-6736 fax (502) 874-8818 - Before posting, please check: http://www.mysql.com/manual.php (the manual)
Can't connect to local MySQL server through socket'/var/lib/mysql/mysql.sock' (111)
I'm getting ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Error Everything began when I deleted the mysql.sock I have restarted mysqld several times, but nothing. What should I try? Maybe you would like to ICQ: 8188532 Felipe Baytelman BayTex Producciones [EMAIL PROTECTED] http://www.baytex.net ICQ: 8188532 Chile: (09) 879 01 67World: (569) 879 01 67 Postal: Ernesto Hevia 5885 - La Reina - Santiago - Chile - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: rpm install error
i upgraded to 2.2.16. still same problem. can't seem to find a data directory. just installing from rpm all standard. this really bugs me... thanks for your words so far -powlow - Original Message - From: powlow [EMAIL PROTECTED] To: Sasha Pachev [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 3:29 PM Subject: Re: rpm install error do you mean upgrade to 2.2.16? -paulo - Original Message - From: Sasha Pachev [EMAIL PROTECTED] To: powlow [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 2:21 PM Subject: Re: rpm install error On Wednesday 19 September 2001 04:48, powlow wrote: oops. its suse...damn still...any ideas? -powlow uname -a Does it show kernel 2.2.14? If yes, upgrade the kernel. SuSE introduced a special safety feature into their 2.2.14 kernel that makes our binary coredump right away. They got rid of it it later versions. And while I am on the subject - we are aware of an I/O bug in 2.2.14 kernel even without the special safety patch from SuSE) that make MySQL corrupt tables under heavy load. Two of our users were running 2.2.14 kernel and were getting their tables randomly corrupted. The problems went away after upgrade to 2.2.10. So if you are running 2.2.14 SuSE kernel, you have two reasons to upgrade. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Getting data from Oracle to Mysql
Hi, Can anybody tell me how to get all the data and the table structures from Oracle to Mysql. Thanks, Kishore - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
So sprach »Felipe Baytelman« am 2001-09-19 um 11:37:36 -0400 : I'm getting ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Does the file actually exist? I know that you deleted it, but Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 4 hours 3 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is there a version of MySQL compiles with '-64' option on SGI?
Hi, I am making a program which reads information from the online system and logs them into the MySQL database. The libraries for the other part were compiled with '-64'. However I found that the lib of MySQL client was compiled with '-32'. Thus create linking problem! Is there a version of MySQL lib that is complied with '-64' option on SGI IRIX 6.5? I also tried to look for source code of MySQL but I could not find it in the 'download' area of http://www.mysql.com. Maybe I didn't look hard enough. Could some one tell me where I can find it? -- Best regards,Yen-Chu Chen [EMAIL PROTECTED] Office: (630) 840-5403, FAX: (630) 840-2968 (886)-(2)-2789-9681 (Inst. of Phys., Academia Sinica) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Simple SELECT query (or so I thought)
Try it and see. What I think you want is to rank your usernames according to who has the highest wucount and rank and then show the individual records in descending order of wucount/rank but grouping records by username. This differs from the suggestion of simply adding username at the front of your order by in that in that scenario, the records will be sorted alphabetically by username. If you want to group by username, then you must determine in what order usernames will print. The solution I have outlined will order the usernames according to who has the highest (max) wucount and rank. Within each username group, the individual records will follow your original order of wucount desc, and rank desc. The only potential problem with this is that the max(wucount) and the max(rank) for each username may not occur within the same individual record. You should think about the ramifications of this and decide if. Like I said, give it a try... what have you got to lose? -Original Message- From: Solsberry, Glendon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 11:35 AM To: [EMAIL PROTECTED] Subject: RE: Simple SELECT query (or so I thought) Correct. I need the data sorted by the wucount first, but still have the data grouped together by the username. I don't quite follow the reasoning behind a temp table. Won't I still have the problems of the sorting, or can you explain to me how this will solve that problem? Glen -Original Message- From: Will French [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 9:59 AM To: Solsberry, Glendon; [EMAIL PROTECTED] Subject: RE: Simple SELECT query (or so I thought) I am not possitive that I completely follow what you are trying to do... but, here goes: What if you create a temporary table first: CREATE TEMPORARY TABLE tu ( usernamevarchar(255), maxwucount bigint, maxrank int ) SELECT username, max(wucount) as maxwucount, max(rank) as maxrank FROM genomestats WHERE curDate IN ('$curDate', '$lastUpdate', '$lastDay') GROUP BY username; Then: SELECT genomestats.* FROMgenomestats INNER JOIN tu ON genomestats.username = tu.username WHERE genomestats.curDate IN ('$curDate', '$lastUpdate', '$lastDay') ORDER BY tu.maxwucount desc, tu.maxrank desc, tu.username, genomestats.wucount desc, genomestats.rank desc I've seen the other suggestions telling you to just add the username to your order by but if I understand your situation this would not work because it would not satisfy your wish to have the list sorted with the highest wucount/rank first... right? -Original Message- From: Solsberry, Glendon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 9:29 AM To: '[EMAIL PROTECTED]' Subject: Simple SELECT query (or so I thought) Can anybody help me out with this??? This would make life so much easier for my poor stats package. Anyone? -Original Message- From: Solsberry, Glendon Sent: Friday, September 14, 2001 10:17 AM To: MySQL Subject: Simple SELECT query (or so I thought) I am running a stats page for our Genome@Home team, and I'm trying to get a simple SELECT that will get the data that I need... Ok, I have a table setup like this: Genomestats --- usernamevarchar(255) curDate datetime wucount bigint genecount bigint updates int rankint teamnumber bigint A sample record from the table may look like this: |DP | 2001-08-24 16:00:00 | 25786 | 1588 | 1 | 24 | 983928120| My SELECT looks like this (note that the dates are dynamically generated): SELECT * FROM genomestats WHERE curDate IN ('$curDate', '$lastUpdate', '$lastDay') order by wucount desc, rank desc; Where $curDate is the most recent data update, $lastUpdate is the update from 3 hours ago, and $lastDay is the update from 24 hours ago. When I execute the SQL, and print the resulting recordset to my log file, I get data like this: junior || 2001-09-14 06:30:00 || 51819 || 3019 || 156 || 11 || 983928120 junior || 2001-09-14 03:30:00 || 51743 || 3014 || 155 || 11 || 983928120 junior || 2001-09-13 06:30:00 || 51480 || 2997 || 149 || 11 || 983928120 IronBits || 2001-09-14 06:30:00 || 50787 || 3021 || 156 || 12 || 983928120 IronBits || 2001-09-14 03:30:00 || 50712 || 3016 || 155 || 12 || 983928120 Zoso || 2001-09-14 06:30:00 || 50549 || 2917 || 156 || 13 || 983928120 Zoso || 2001-09-14 03:30:00 || 50505 || 2914 || 155 || 13 || 983928120 Zoso || || 2001-09-13 06:30:00 || 50188 || 2893 || 149 || 12 || 983928120 IronBits || 2001-09-13 06:30:00 || 50181 || 2982 || 149 || 13 || 983928120 Now, the problem is that the user IronBits had a wucount at somepoint (in the last 24 hours here) that was less than Zoso's wucount. Basically, this means that IronBits passed Zoso sometime in the past 24 hours. I need to have
Re: Getting data from Oracle to Mysql
Since I know Oracle, MySQL, and Java the fastest way I did it was: 1) I created scripts for creating the tables in both DBs (this is the way I usually do). They differ a bit on datatypes, and I had to remove all the foreign key when dealing with MYSQL. I have 2 scripts called makeOraDB.sql and makeMySQLDB.sql that will call others scripts and generate the dbs in both environments any time I run them. If I need to update or fix the schemas all I need to do is run the scripts again. 2) I created a class in java to deal with the migration and persistence. This class creates 2 connections one with Oracle and another with MySQL. I read the rows in Oracle into a resultset and then I navigate this result set and for every row I do an insert in the MySQL DB. Notice that this is a one shot process. The MySQL tables are completely empty in the beginning of this process. Notice also that the scripts for generating the DB are used in a development environment. In production it would make no sense dropping and generating the DBs again and again. I am in a development process. If you are in a production environment, with your Oracle DB completely populated with data, you can just work on the MYSQL scripts and the java migration class. In summary: I did everything from scratch, completeluy manually. No tools involved. If someone know a better way please let me know. Siomara From: Kishore Balasubramanya [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Getting data from Oracle to Mysql Date: Wed, 19 Sep 2001 11:50:27 -0400 Hi, Can anybody tell me how to get all the data and the table structures from Oracle to Mysql. Thanks, Kishore - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.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
RE: Getting data from Oracle to Mysql
I was thinking we could use copy-db utility. Can anybody tell me if that is a possibility and if there are any known issues. Thanks -Original Message- From: Siomara Pantarotto [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 12:27 PM To: Kishore Balasubramanya; [EMAIL PROTECTED] Subject: Re: Getting data from Oracle to Mysql Since I know Oracle, MySQL, and Java the fastest way I did it was: 1) I created scripts for creating the tables in both DBs (this is the way I usually do). They differ a bit on datatypes, and I had to remove all the foreign key when dealing with MYSQL. I have 2 scripts called makeOraDB.sql and makeMySQLDB.sql that will call others scripts and generate the dbs in both environments any time I run them. If I need to update or fix the schemas all I need to do is run the scripts again. 2) I created a class in java to deal with the migration and persistence. This class creates 2 connections one with Oracle and another with MySQL. I read the rows in Oracle into a resultset and then I navigate this result set and for every row I do an insert in the MySQL DB. Notice that this is a one shot process. The MySQL tables are completely empty in the beginning of this process. Notice also that the scripts for generating the DB are used in a development environment. In production it would make no sense dropping and generating the DBs again and again. I am in a development process. If you are in a production environment, with your Oracle DB completely populated with data, you can just work on the MYSQL scripts and the java migration class. In summary: I did everything from scratch, completeluy manually. No tools involved. If someone know a better way please let me know. Siomara From: Kishore Balasubramanya [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Getting data from Oracle to Mysql Date: Wed, 19 Sep 2001 11:50:27 -0400 Hi, Can anybody tell me how to get all the data and the table structures from Oracle to Mysql. Thanks, Kishore - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.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
view support
Gents, When version 4.1 of MySQL with view supporting will publish? Alex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
binary update log
Just a quick question regarding how (if at all) MySQL's binary update log consumes resrouces as it records modifications to various tables in the database. Are there any potential performance issues or limitations to be expected (other than excessive consumption of diskspace) if this log is not flushed/rotated periodically? Assuming diskspace isn't an issue what is the performance (RAM, CPU Usage) downside to not flushing this regularly? -csw - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: replication bug
server-id=1 log-bin=/usr/local/mysql-3.23.39/bin-log/db1-bin those are the only replication settings. Have you possibly heard of bad programming practices in Perl/DBI that would cause a query not to make it into the bin-log? - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Gabe E. Nydick [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 12:47 AM Subject: Re: replication bug On Tue, Sep 18, 2001 at 10:17:26PM -0700, Jeremy Zawodny wrote: On Tue, Sep 18, 2001 at 09:54:51PM -0700, Gabe E. Nydick wrote: I have a large set of tables that are 1-way replicating to an identical machine as the master db, and for some reason 1 table doesn't make it into the binary log. Why would updates to 1 specific table not make it into the binary log? What's the relvant section of your my.cnf file on the master look like? Just bin-log, or is there more there? Err, log-bin, not bin-log. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 13 days, processed 242,448,830 queries (213/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: replication bug
I have found that if I do manual changes to the table, it replicates. If the applications my company wrote make changes, they don't replicate. I am having the programmers find where they went sloppy. - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Gabe E. Nydick [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 12:47 AM Subject: Re: replication bug On Tue, Sep 18, 2001 at 10:17:26PM -0700, Jeremy Zawodny wrote: On Tue, Sep 18, 2001 at 09:54:51PM -0700, Gabe E. Nydick wrote: I have a large set of tables that are 1-way replicating to an identical machine as the master db, and for some reason 1 table doesn't make it into the binary log. Why would updates to 1 specific table not make it into the binary log? What's the relvant section of your my.cnf file on the master look like? Just bin-log, or is there more there? Err, log-bin, not bin-log. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 13 days, processed 242,448,830 queries (213/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 mysql 3.23.42 linux i386 install
Description: mysql couldn't find the lockfile, so i stopped and reinstalled it. since then i can't connect, error message: [root@primergy mysql-3.23.42]# /usr/local/mysql/current/bin/safe_mysqld Starting mysqld daemon with databases from /var/mysql/data 010919 18:55:04 mysqld ended [root@primergy mysql-3.23.42]# /usr/local/mysql/current/bin/mysqladmin -u root password 'geheim' /usr/local/mysql/current/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! file /tmp/mysql.sock doesn't exist, touch'ing it doesn't help. found out it had mode srwxrwxrwx and was empty. i have no idea how to fix that. did make (all install) several times but didn't help. system: p200, 32mb, linux from scratch 3.0-pre4 configure line: ./configure --prefix=/usr/local/mysql/3.23.42 --localstatedir=/var/mysql/data How-To-Repeat: no idea Submitter-Id: submitter ID Originator:SubWorx Organization: none MySQL support: email support? Synopsis: problem with socket Severity: critical Priority: high Category: mysql Class: support Release: mysql-3.23.42 (Source distribution) Environment: System: Linux primergy 2.4.8 #1 SMP Fri Sep 14 18:34:05 CEST 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-pc-linux-gnu/2.95.2.1/specs gcc version 2.95.2.1 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Sep 14 08:46 /lib/libc.so.6 - libc-2.2.1.so -rwxr-xr-x1 root root 4838865 Sep 14 08:45 /lib/libc-2.2.1.so -rw-r--r--1 root root 24160798 Sep 14 08:39 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 14 08:39 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql/3.23.42 --localstatedir=/var/mysql/data - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: replication bug
I assume that you have already scanned the MySQL manual section 4.10.4 Replication Features and Known Problems to see if anything listed there as a problem is relevant to your situation. I found a couple of gotchas there that caused me some problems. -Original Message- From: Gabe E. Nydick [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 12:44 PM To: [EMAIL PROTECTED] Subject: Re: replication bug I have found that if I do manual changes to the table, it replicates. If the applications my company wrote make changes, they don't replicate. I am having the programmers find where they went sloppy. - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Gabe E. Nydick [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 12:47 AM Subject: Re: replication bug On Tue, Sep 18, 2001 at 10:17:26PM -0700, Jeremy Zawodny wrote: On Tue, Sep 18, 2001 at 09:54:51PM -0700, Gabe E. Nydick wrote: I have a large set of tables that are 1-way replicating to an identical machine as the master db, and for some reason 1 table doesn't make it into the binary log. Why would updates to 1 specific table not make it into the binary log? What's the relvant section of your my.cnf file on the master look like? Just bin-log, or is there more there? Err, log-bin, not bin-log. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 13 days, processed 242,448,830 queries (213/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: BDB table : different results on adjacent queries
What is the query you are running + what version of mysql are you using? dpk - Original Message - From: [EMAIL PROTECTED] To: mysql mailing list (E-Mail) [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 2:12 AM Subject: BDB table : different results on adjacent queries hi all we encountered the following: - altered table type to 'BDB' - did 2 identical queries - got different result sets ! after restart of MySQL the very next query gave the correct results, the next did NOT. any ideas? Thanx in advance Andreas Schoelver -- Andreas Schoelver (AS) mailto: [EMAIL PROTECTED] mailto: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: rpm install error
On Wednesday 19 September 2001 09:38, powlow wrote: i upgraded to 2.2.16. still same problem. can't seem to find a data directory. just installing from rpm all standard. this really bugs me... No, that is not the same problem. You were getting a segfault. If it cannot find datadir, start debugging the start-up script - read the error log then go from there. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: rpm install error
On Wednesday 19 September 2001 09:59, Floyd Mann wrote: And while I am on the subject - we are aware of an I/O bug in 2.2.14 kernel even without the special safety patch from SuSE) that make MySQL corrupt tables under heavy load. Two of our users were running 2.2.14 kernel and were getting their tables randomly corrupted. The problems went away after upgrade to 2.2.10. Oops, I meant 2.2.19... Hey Sasha - Thanks for mentioning this. We started running MySQL 3.23.33 on a 2.2.14 kernel (RH 6.2) about six months ago. Almost immediately we started experiencing table corruption. We have consistently been having 2 or 3 tables get corrupted a month ever since. I've been scratching my head trying to figure out what the heck I've been doing wrong or what has been the cause, but I think you just answered my question. Looks like I'll be upgrading my kernel soon! Glad to hear the confirmation from another user. Thanks for reporting this. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: rpm install error
okay. the problem was still the same one. i was just adding that i couldn't find a data directory. i'll try upgrading to 2.2.19 but i'm not sure if i can cause i'm running suse 6.4 - that might be a completely stupid statement - i'm not sure yet! any pointers anyone? -powlow - Original Message - From: Sasha Pachev [EMAIL PROTECTED] To: powlow [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 6:52 PM Subject: Re: rpm install error On Wednesday 19 September 2001 09:38, powlow wrote: i upgraded to 2.2.16. still same problem. can't seem to find a data directory. just installing from rpm all standard. this really bugs me... No, that is not the same problem. You were getting a segfault. If it cannot find datadir, start debugging the start-up script - read the error log then go from there. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 123box.co.uk mail delivery system (from:MAILER-DAEMON@123box.co.uk)
Hi guys, From: Carl Troein [EMAIL PROTECTED] Sadly, the admin of this list doesn't give a shit. This is rather obvious from Sorry about that. Here's the answer: [EMAIL PROTECTED] --- Rodney Broom Programmer: Desert.Net sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Getting data from Oracle to Mysql
What is copy-db utility? Where can I find it? Does it come with MySQL or any other DB? Tell me and I will make use of it, and let you know if there are issues. Today I have 4 dbbases (LDAP, Oracle, SQL Server and MySQL) and I have to keep them with the closest table structure as possible. This means that I have the same tables in all of them. They differ in datatypes (required by the products) but the data is the same for all. Today I have been working with scripts for all relational dbs (it works fine and gives you the whole control of what you are doing). However I would love to try something else. Siomara From: Kishore Balasubramanya [EMAIL PROTECTED] To: Siomara Pantarotto [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: Getting data from Oracle to Mysql Date: Wed, 19 Sep 2001 12:29:54 -0400 I was thinking we could use copy-db utility. Can anybody tell me if that is a possibility and if there are any known issues. Thanks -Original Message- From: Siomara Pantarotto [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 12:27 PM To: Kishore Balasubramanya; [EMAIL PROTECTED] Subject: Re: Getting data from Oracle to Mysql Since I know Oracle, MySQL, and Java the fastest way I did it was: 1) I created scripts for creating the tables in both DBs (this is the way I usually do). They differ a bit on datatypes, and I had to remove all the foreign key when dealing with MYSQL. I have 2 scripts called makeOraDB.sql and makeMySQLDB.sql that will call others scripts and generate the dbs in both environments any time I run them. If I need to update or fix the schemas all I need to do is run the scripts again. 2) I created a class in java to deal with the migration and persistence. This class creates 2 connections one with Oracle and another with MySQL. I read the rows in Oracle into a resultset and then I navigate this result set and for every row I do an insert in the MySQL DB. Notice that this is a one shot process. The MySQL tables are completely empty in the beginning of this process. Notice also that the scripts for generating the DB are used in a development environment. In production it would make no sense dropping and generating the DBs again and again. I am in a development process. If you are in a production environment, with your Oracle DB completely populated with data, you can just work on the MYSQL scripts and the java migration class. In summary: I did everything from scratch, completeluy manually. No tools involved. If someone know a better way please let me know. Siomara From: Kishore Balasubramanya [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Getting data from Oracle to Mysql Date: Wed, 19 Sep 2001 11:50:27 -0400 Hi, Can anybody tell me how to get all the data and the table structures from Oracle to Mysql. Thanks, Kishore - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.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
RE: 123box.co.uk mail delivery system (from:MAILER-DAEMON@123box.co.uk)
database, sql, query, table Sorry about that. Here's the answer: [EMAIL PROTECTED] And this means what? A little less criptic, please, for use simpletons. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 123box.co.uk mail delivery system (from:MAILER-DAEMON@123box.co.uk)
From: Will French [EMAIL PROTECTED] Sorry about that. Here's the answer: [EMAIL PROTECTED] And this means what? A little less criptic, please, for use simpletons. Heh, it means that I typed too quickly and wasn't really watching. [EMAIL PROTECTED] As for why I wrote that... Alexander Skwar writes: Could this user please be removed? It's [EMAIL PROTECTED] --- Rodney Broom Programmer: Desert.Net sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
IDE-RAID QUESTION
Hi all, I realize IDE-RAID is relatively micky mouse to those SCSI-RAID but I would like to know if there is any beneficials running MySQL over IDE-RAID and is there any configuration I need to optimize MySQL to utilize the RAID?? All helps/suggestions are greatly appreciated. Regards, Michael - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
newbie nagging
anyone have any idea what this means? and why it comes up? mysql use mydatabase; Reading table information for compltion of table and coumn names You can turn off this feature to get a quicker startup with -A Database changed mysql this only comes up for _some_ databases not all any helpful hints? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: IDE-RAID QUESTION
On 19 Sep 2001 12:25:35 -0700, Michael Tam wrote: Hi all, I realize IDE-RAID is relatively micky mouse to those SCSI-RAID but I would like to know if there is any beneficials running MySQL over IDE-RAID and is there any configuration I need to optimize MySQL to utilize the RAID?? RAID by itself doesn't mean much. You prorably have to define which exact RAID level you mean. Raid0 (striping), raid1 (mirroring), other raids? Of course, RAID0 can give double speed on whatever disks, RAID1 gives redundancy, and so on. RAIDx is usually right thing to go. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Swapping
Hello All. I am working with a rather large MySQL DB, it seems that it likes to swap ALOT, even after the operations are done, i have bumped up my cache sizes, i have tones of .bin files in my var dir, any ideas? Thanx! _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.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
New Install Problems
I just compiled from scratch, and successfully installed v3.23.42 on an RH7.1 system. EVerything went fine, no errors anywhere, it started up fine and I was able to set passwords fine. Then I try to log in and execute 'show databases;' and it just sits there: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 to server version: 3.23.42-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases; And that's it. Nothing happens. I have to hit CTRL-C to get out. Looking in the log file, it doesn't tell me anything aside from logging the commands, no errors. If I use a database, I can display its tables just fine, so I know the 'show' command by itself works. But why can't I see databases now? -- W | I haven't lost my mind; it's backed up on tape somewhere. + Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130 IT Director / SysAdmin / WebSmith . 800.441.3873 x130 Photo Craft Laboratories, Inc.. 3550 Arapahoe Ave. #6 http://www.pcraft.com . . .. Boulder, CO 80303, U.S.A. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ODBC Drivers
Hows it going! I have created a mysql database on a windows 2000 platform and have been able to connect, start it as a service, performed all basic SQL statements(insert, update, select, delete) and use it from the command line. I obtained a copy of MySQL from sams teach yourself MySQL in 24 hours. I am a java programmer and I have written a program to access this program. Along with the MySql CD there is a Windows NT driver.zip file I belive I installed that correctly. To Install it I unziped it and followed the steps. After this I went into the controll panel\DataSources(ODBC) and checked the System DNS and added the MySQL database I created at that time I saw an option to choose MySQL as the driver and that is what I selected. What I am confused on is the driver part. Im not sure If I installed everything I needed? What the name of the driver would be??? Do I need to take a class file and add it to my classpath or was that done for me when I installed and ran the Windows NT driver.zip? One of the first things I need to do when running my java program is pass the name of the MySQL driver that Im using. When working with db2 I would add a zip file to the class path and within the zip file would be the ODBC class I need. If you could provide me with some information on MySQL driver setup on windows 2000 I would really appreciate it. Especially the name of the driver class. Thanks, Tom Meckna [EMAIL PROTECTED] _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.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
RE: ODBC Drivers
Hi -Original Message- From: Tom Meckna [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 1:46 PM To: [EMAIL PROTECTED] Subject: ODBC Drivers I obtained a copy of MySQL from sams teach yourself MySQL in 24 hours. I am a java programmer and I have written a program to access this program. Along with the MySql CD there is a Windows NT driver.zip file I belive I installed that correctly. To Install it I unziped it and followed the steps. After this I went into the controll panel\DataSources(ODBC) and checked the System DNS and added the MySQL database I created at that time I saw an option to choose MySQL as the driver and that is what I selected. What I am confused on is the driver part. Im not sure If I installed everything I needed? Please download the full setup of MyODBC for Windows NT/2000 from the following link, and try to install it: http://www.mysql.com/downloads/api-myodbc.html For more information about the setting up the ODBC DSN, please take a look at the following link: http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#ODBC Also, you can get the latest versions of server and MyODBC drivers from www.mysql.com itself without any cost. Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu mailto:[EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, 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: ODBC Drivers
On Wednesday 19 September 2001 14:32, Tom Meckna wrote: Hi Venu! Sorry for bothering you. I belive I have the driver installed correctly but I dont understand what name I use when calling it from a java program. A example would be Class.forName(driverName); Ex from book Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); I need the class name for the MySQL driver. I am fairly positive I have set up the DNS name correctly. Im just not sure what name I use. Do you any suggestions. Ok, if you want to use MyODBC through jdbc-odbc bridge then you need to specify the DSN name as the url in the getConnection method. Here is the simple procedure: -- Create MyODBC DSN name as 'mydsn' -- Load the jdbc-odbc bridge driver using Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); -- Attempt to connect to MySQL server by loading MyODBC String url = jdbc:odbc:mydsn; Connection con = DriverManager.getConnection(url,localhost,); Will do the work for you. If the getConnection method fails, catch the exception and based on the exception alter your DSN entries. Hope this helps you Regards, venu -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, 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: Howmany databases??
I'm currently hosting about 6700 MySQL databases. Regards, Gary SuperID Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org - Original Message - From: program tester [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 3:54 AM Subject: Howmany databases?? Hello, I would like to know that how many databases can i use for one site at max? Hopeing for kind help -PT - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
PHP and Mysql problem
I am having a little problem with a PHP 4 statement in one of my webpages. I am using a drop down box of selections that is built a table in a MySQL database. This is what I have so far (everything works well, the correct information is displayed for both the Category and ID column values. select name=Product optionPlease select a category.../option ?php // display entries in the selection box and // associate the column ID of each entry while ($row = mysql_fetch_array($result)) { echo(option value= . $row[ID] . . $row[Category] . /option); } ? /select Unfortunately this causes the HTML code to b OPTION value=1Product Category 1/OPTION when I need it to be OPTION value=1Product Category 1/OPTION Can anyone recommend another approach so that the quotation marks are generated around the ID value that is returned? TIA _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.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
Mzximum character count
Hello, I am working on a MySQL database that lists the current competitors of the company I work for as a part of a global intranet. At present I have a table that contains the corporate website of our competitors. I would like to find out what record in the table has the largest amount of characters. This way I could possibly decrease the varchar size (currently 100) to speed up the queries. My table is as below. CREATE TABLE competitor ( CompetitorsName varchar(35) not null, Website varchar(100), ID int auto_increment not null primary key ) TIA. Neil Silvester Systems Administrator / Webmaster. Heat and Control Inc. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.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
RE: PHP and Mysql problem
-Original Message- From: Neil Silvester [mailto:[EMAIL PROTECTED]] Sent: Thursday, 20 September 2001 08:12 To: [EMAIL PROTECTED] Subject: PHP and Mysql problem I am having a little problem with a PHP 4 statement in one of my webpages. I am using a drop down box of selections that is built a table in a MySQL database. This is what I have so far (everything works well, the correct information is displayed for both the Category and ID column values. select name=Product optionPlease select a category.../option ?php // display entries in the selection box and // associate the column ID of each entry while ($row = mysql_fetch_array($result)) { echo(option value= . $row[ID] . . $row[Category] . echo(option value=\ . $row[ID] . \ . $row[Category] . or echo(option value=' . $row[ID] . ' . $row[Category] . I'm not sure if using single quotes is to the HTML specs though. /option); } ? /select Unfortunately this causes the HTML code to b OPTION value=1Product Category 1/OPTION when I need it to be OPTION value=1Product Category 1/OPTION Can anyone recommend another approach so that the quotation marks are generated around the ID value that is returned? TIA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Mzximum character count
At 8:43 AM +1000 9/20/01, Neil Silvester wrote: Hello, I am working on a MySQL database that lists the current competitors of the company I work for as a part of a global intranet. At present I have a table that contains the corporate website of our competitors. I would like to find out what record in the table has the largest amount of characters. This way I could possibly decrease the varchar size (currently 100) to speed up the queries. My table is as below. CREATE TABLE competitor ( CompetitorsName varchar(35) not null, Website varchar(100), ID int auto_increment not null primary key ) TIA. SELECT MAX(LENGTH(Website)) FROM competitor You might also look up PROCEDURE ANALYSE() in the manual. Neil Silvester Systems Administrator / Webmaster. Heat and Control Inc. -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP and Mysql problem
echo ('option value=' . $row[ID] . '' . $row[Category] . '/option'); You might be able to escape the with / or the like but I'm not great at php, yet. ;) - Original Message - From: Neil Silvester [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 5:42 PM Subject: PHP and Mysql problem I am having a little problem with a PHP 4 statement in one of my webpages. I am using a drop down box of selections that is built a table in a MySQL database. This is what I have so far (everything works well, the correct information is displayed for both the Category and ID column values. select name=Product optionPlease select a category.../option ?php // display entries in the selection box and // associate the column ID of each entry while ($row = mysql_fetch_array($result)) { echo(option value= . $row[ID] . . $row[Category] . /option); } ? /select Unfortunately this causes the HTML code to b OPTION value=1Product Category 1/OPTION when I need it to be OPTION value=1Product Category 1/OPTION Can anyone recommend another approach so that the quotation marks are generated around the ID value that is returned? TIA _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.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
RE: Mzximum character count
I would like to find out what record in the table has the largest amount of characters. This way I could possibly decrease the varchar size (currently 100) to speed up the queries. My table is as below. CREATE TABLE competitor ( CompetitorsName varchar(35) not null, Website varchar(100), ID int auto_increment not null primary key ) SELECT MAX(LENGTH(Website)) FROM competitor; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 PLEASE - C API code help: UPDATE query using result from SELECT
Hi, I believe that the query below is correct, but I do not believe that it is possible in MySQL currently due to it not supporting sub-selects: UPDATE table1 SET ID=table2.ID, Company=table2.Company, Modified=table2.Modified FROM table1 INNER JOIN table2 ON table1.Company=table2.Company WHERE table1.Modified='9'; The error produced was: ERROR 1064: You have an error in your SQL syntax near 'FROM table1 INNER JOIN table2 ON table1.Company=table2.Company WHERE table1.Modi' at line 1 If you can't tell from the SQL query above...what I am trying to do is update data in table1 with data from table2...the two tables have pretty much identical information, although table2 has updated data and table1 can't just be overwritten because it may have something newer than table2 again (this is only part of the entire process which involves two MySQL servers and a MS SQL server :) I've read that the only way to do it at the moment is using code such as C or C++. Does anyone have any experience with this type of procedure? My code so far is below...my coding knowledge is very weak and this was obtained from a text: #include stdlib.h #include stdio.h #include /usr/local/mysql/include/mysql/mysql.h MYSQL my_connection; MYSQL_RES *res_ptr; MYSQL_ROW sqlrow; void display_row(); int main(int argc, char *argv[]) { int res; uint i = 0; query = 0; mysql_init(my_connection); if (mysql_real_connect(my_connection, localhost, username, password, database, 0, NULL, 0)) { printf(Connection success\n); res = mysql_query(my_connection, SELECT ID, Modified FROM table1 WHERE Modified = 9); if (res) { printf(SELECT error: %s\n, mysql_error(my_connection)); } else { res_ptr = mysql_store_result(my_connection); if (res_ptr) { while ((sqlrow = mysql_fetch_row(res_ptr))) { for (i=0; i mysql_num_fields(res_ptr); i++) printf(%s\n,sqlrow[i]); printf(Fetched data...\n); /*mysql_query(my_connection, Some UPDATE code );*/ /*display_row();*/ } if (mysql_errno(my_connection)) { fprintf(stderr, Retrieve error: %s\n, mysql_error(my_connection)); } } mysql_free_result(res_ptr); } mysql_close(my_connection); } else { fprintf(stderr, Connection failed\n); if (mysql_errno(my_connection)) { fprintf(stderr, Connection error %d: %s\n, mysql_errno(my_connection), mysql_error(my_connection)); } } return EXIT_SUCCESS; } void display_row() { unsigned int field_count; field_count = 0; while (field_count mysql_field_count(my_connection)) { printf(%s , sqlrow[field_count]); field_count++; } printf(\n); } This code works very well in obtaining the data from the tables, but I need to get a procedure that will perform the UPDATE once the necessary data has been obtained. In the section /*mysql_query(my_connection, Some UPDATE code );*/ I have been able to get a static update to work, such as UPDATE table1 SET Company = 'NewCompany' where Modified = 9, but I need it to input the values which were obtained from the initial SELECT statement. I've seen some incomplete code which defines a variable such as query[2048] and then I assume somehow assigns a query to it which can then be used similar to: mysql_query(my_connection, query); Can somebody please help me get this code completed, as it is going nowhere awfully fast at the moment. Thankyou, John Mravunac - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.42 (Source distribution) Environment: System: Linux yem.webmaster.com 2.2.17-8wl2 #1 Sun Jan 14 22:01:31 KST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 11 9¿ù 10 20:34 /lib/libc.so.6 - libc-2.2.so -rwxr-xr-x1 root root 4761074 12¿ù 15 2000 /lib/libc-2.2.so -rw-r--r--1 root root 22855536 12¿ù 15 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 12¿ù 15 2000 /usr/lib/libc.so lrwxrwxrwx1 root root 10 9¿ù 10 20:45 /usr/lib/libc-client.a - c-client.a Configure command: ./configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data --with-charset=euc_kr qq] qq!OB - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: HELP PLEASE - C API code help: UPDATE query using result from SELECT
I am struggling with this myself right now. I posted a similar question to this group earlier in the day and it must be a poser because no one has responded. I fear that the only way to do this with a single sql statement is using the replace command: Let's say you have 2 tables like this: MainTbl id int not null (primary key), fld1int, fld2int, fld3int UpdTbl id int not null (primary key), fld2int And let's say that you have 20,000 recs in MainTbl and only 100 recs in UpdTbl. You want to join the 2 tables and flag the value from UpdTbl.fld2 into MainTbl.fld2, right? The best approach I have thought of is REPLACE INTO MainTbl SELECT MainTbl.id, MainTbl.fld1, UpdTbl.fld2, MainTbl.fld3 FROMMainTbl INNER JOIN UpdTbl ON MainTbl.id = UpdTbl.id; I have not tried this yet but if I read the manual correctly, it should work. If anyone has a better solution, please fill us in. Additionally, I would like ideas on how to work around MySQL's inability to handle deletes like the following: DELETE MainTbl FROMMainTbl INNER JOIN DelTbl ON MainTbl.id = DelTbl.id; -Original Message- From: John Mravnuac [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 8:28 PM To: [EMAIL PROTECTED] Subject: HELP PLEASE - C API code help: UPDATE query using result from SELECT Hi, I believe that the query below is correct, but I do not believe that it is possible in MySQL currently due to it not supporting sub-selects: UPDATE table1 SET ID=table2.ID, Company=table2.Company, Modified=table2.Modified FROM table1 INNER JOIN table2 ON table1.Company=table2.Company WHERE table1.Modified='9'; The error produced was: ERROR 1064: You have an error in your SQL syntax near 'FROM table1 INNER JOIN table2 ON table1.Company=table2.Company WHERE table1.Modi' at line 1 If you can't tell from the SQL query above...what I am trying to do is update data in table1 with data from table2...the two tables have pretty much identical information, although table2 has updated data and table1 can't just be overwritten because it may have something newer than table2 again (this is only part of the entire process which involves two MySQL servers and a MS SQL server :) I've read that the only way to do it at the moment is using code such as C or C++. Does anyone have any experience with this type of procedure? My code so far is below...my coding knowledge is very weak and this was obtained from a text: #include stdlib.h #include stdio.h #include /usr/local/mysql/include/mysql/mysql.h MYSQL my_connection; MYSQL_RES *res_ptr; MYSQL_ROW sqlrow; void display_row(); int main(int argc, char *argv[]) { int res; uint i = 0; query = 0; mysql_init(my_connection); if (mysql_real_connect(my_connection, localhost, username, password, database, 0, NULL, 0)) { printf(Connection success\n); res = mysql_query(my_connection, SELECT ID, Modified FROM table1 WHERE Modified = 9); if (res) { printf(SELECT error: %s\n, mysql_error(my_connection)); } else { res_ptr = mysql_store_result(my_connection); if (res_ptr) { while ((sqlrow = mysql_fetch_row(res_ptr))) { for (i=0; i mysql_num_fields(res_ptr); i++) printf(%s\n,sqlrow[i]); printf(Fetched data...\n); /*mysql_query(my_connection, Some UPDATE code );*/ /*display_row();*/ } if (mysql_errno(my_connection)) { fprintf(stderr, Retrieve error: %s\n, mysql_error(my_connection)); } } mysql_free_result(res_ptr); } mysql_close(my_connection); } else { fprintf(stderr, Connection failed\n); if (mysql_errno(my_connection)) { fprintf(stderr, Connection error %d: %s\n, mysql_errno(my_connection), mysql_error(my_connection)); } } return EXIT_SUCCESS; } void display_row() { unsigned int field_count; field_count = 0; while (field_count mysql_field_count(my_connection)) { printf(%s , sqlrow[field_count]); field_count++; } printf(\n); } This code works very well in obtaining the data from the tables, but I need to get a procedure that will perform the
RE: PHP and Mysql problem
On 19-Sep-2001 Neil Silvester wrote: I am having a little problem with a PHP 4 statement in one of my webpages. I am using a drop down box of selections that is built a table in a MySQL database. This is what I have so far (everything works well, the correct information is displayed for both the Category and ID column values. select name=Product optionPlease select a category.../option ?php // display entries in the selection box and // associate the column ID of each entry while ($row = mysql_fetch_array($result)) { echo(option value= . $row[ID] . . $row[Category] . /option); printf('option value=%s%s/option', $row[ID], $row[Category]); Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: About the date
Dear Sir/Madam, I'd like to upload data into a table from a text file. Inside the file, there is a field about the date. It is in MM/DD/YY format. But inside the MySQL manual I can't find any information about it, so can you tell me what can I do? Thank you! Best Regrads, Ida --- [EMAIL PROTECTED] wrote: 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: database,sql,query,table 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: Dear Sir/Madam, I'd like to upload data from a text file. Inside the file, there is a field about the date. It is in MM/DD/YY format. But inside the manual I can't find any information about it, so can you tell me what can I do? Thank you! Best Regrads, Ida __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: About the date
On Wed, Sep 19, 2001 at 06:55:00PM -0700, Ida Sze wrote: Dear Sir/Madam, I'd like to upload data into a table from a text file. Inside the file, there is a field about the date. It is in MM/DD/YY format. But inside the MySQL manual I can't find any information about it, so can you tell me what can I do? Thank you! Best Regrads, Ida 1) Reformat your data into YY-MM-DD format before loading it into the table. 2) Load it into a character column, then bust it apart and put the pieces back in the right order. Here's an example. Suppose you want to load this data: name1 01/01/9938 name2 12/31/0040 name3 02/28/0142 name4 01/02/0344 And you want to load it into the following table: CREATE TABLE tmp ( nameCHAR(20), dateDATE, value INT ) Do something like this: ALTER TABLE tmp ADD cdate CHAR(8); LOAD DATA LOCAL INFILE 'newdata.txt' INTO TABLE tmp (name,cdate,value); UPDATE tmp SET date = CONCAT(RIGHT(cdate,2),'-',LEFT(cdate,2),'-',MID(cdate,4,2)); ALTER TABLE tmp DROP cdate; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Load_File
Load_File is used to read a picture (or any binary) file into table, but how to write it back to disk from a table? == Best Regards Jason Kwok == --- Virus Free Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.281 / Virus Database: 149 - Release Date: 2001/9/18 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 password
can mysql use the linux password /etc/passwd for the authentication - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Load_File
See MySQL Manual section 6.4.1 SELECT INTO OUTFILE database - to satisfy mailer-daemon -Original Message- From: Jason Kwok [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 10:21 PM To: [EMAIL PROTECTED] Subject: Load_File Load_File is used to read a picture (or any binary) file into table, but how to write it back to disk from a table? == Best Regards Jason Kwok == --- Virus Free Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.281 / Virus Database: 149 - Release Date: 2001/9/18 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Aborted connection XXX to db.... (Got an error reading communication packets)
Hi, I keep getting 500 Internal Server error when accessing my database, my application is a C++ development of my own. I used to suspect memory leaks but thats has been checked with LeakTracer, and passed! The problem I think is documented here at http://www.mysql.com/doc/C/o/Communication_errors.html But I have no idea how to fix it. Anyone? Luke - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Basic details...
Placed At : BOM Durga Prasad@SATYAM 09/20/2001 09:52 AM Hi, iam trying to use mysql as the back end of a web enabled application. My tables have fields numbering more than 50. Iam a newbie and so i would like to know if there are any limits on the number of fields i may have in any single table. Some other DB's have this problem. Rgds, Durga Prasad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Basic details...
I looked but could not find any reference in the docs regarding limits on the number of columns a table may have. I can say for certain that at 50 you are at no risk (I have tables with 140+). The only db that I know the limit on is MS Sql Server and it allows 255. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 20, 2001 12:22 AM To: [EMAIL PROTECTED] Subject: Basic details... Placed At : BOM Durga Prasad@SATYAM 09/20/2001 09:52 AM Hi, iam trying to use mysql as the back end of a web enabled application. My tables have fields numbering more than 50. Iam a newbie and so i would like to know if there are any limits on the number of fields i may have in any single table. Some other DB's have this problem. Rgds, Durga Prasad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Going blind? Plz hlp w/ parse error
Please help! There is a parse error in line10: ?php // file: root/reg/add_2.php, updated: 08/25/01 $connection=@mysql_connect(localhost,afrodriguez,xxx) or die (No connection!); $db=@mysql_select_db(sbwresearch,$connection) or die (No database!); $qry_1=select * from cust_info where username=\$username\; $result=@mysql_query($qry_1,$connection) or die (No query # 1!); $row_1=@mysql_affected_rows(); if ($row_1==0) { $qry_2=insert into cust_info (username,password,mother) values ($username,$password,$mother) or die (No query #2!); $result=@mysql_query($qry_2,$connection); @mysql_free_result($result); @mysql_close($connection); echo html etc. 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
Re: Basic details...
Just a point. The limit might be high, but accessing a table as such will not be as quick... if possible, should normalise your data. the whole idea behind RDMS. If this has been done, ignore me :) Luke - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Aborted connection XXX to db.... (Got an error reading communication packets)
Hi, I keep getting 500 Internal Server error when accessing my database, my application is a C++ development of my own. I used to suspect memory leaks but thats has been checked with LeakTracer, and passed! The problem I think is documented here at http://www.mysql.com/doc/C/o/Communication_errors.html But I have no idea how to fix it. Anyone? Luke - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Aborted connection XXX to db.... (Got an error reading communication packets)
On Thu, Sep 20, 2001 at 01:10:50PM +0800, Luke Chiam wrote: Hi, I keep getting 500 Internal Server error when accessing my database, my application is a C++ development of my own. Smells like Apache to me. I used to suspect memory leaks but thats has been checked with LeakTracer, and passed! What about your Apache error log? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 14 days, processed 255,363,165 queries (210/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Basic details...
On Thu, Sep 20, 2001 at 12:45:29AM -0400, Will French wrote: I looked but could not find any reference in the docs regarding limits on the number of columns a table may have. I can say for certain that at 50 you are at no risk (I have tables with 140+). The only db that I know the limit on is MS Sql Server and it allows 255. I have a vague memory of it being in the neighborhood of 1,400 or so. But I can't really substantiate that either. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 14 days, processed 255,372,444 queries (210/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Aborted connection XXX to db.... (Got an error reading communication packets)
Thanks for the reply Jeremy. I keep getting 500 Internal Server error when accessing my database, my application is a C++ development of my own. Smells like Apache to me. Thats what I thought, but on reading Apache docs faq, it mentioned that it is probably the cgi script failure to return proper set of header. So I start rereading my lines of code and check for memory leaks and point of failure, but found none. Then I take out all the MySQL access code and wowla! everything is ok. So I start reading up (and cursing MySQL) and found a possible cause at http://www.mysql.com/doc/C/o/Communication_errors.html I used to suspect memory leaks but thats has been checked with LeakTracer, and passed! What about your Apache error log? Premature end of script headers Luke - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Managing MySQL /w large tables
On Wed, Sep 19, 2001 at 09:37:57AM -0400, Phillip Spademan wrote: Hello: I am runnin' a mysql DB with about 90mil entries. on a 1Ghz system with 1G ram, it takes forever to get anything out, i have even tryed selecting the data into a file. Is there any tricks/tips anyone can give me for managing large DB's? It also likes to crash tables every month or so to =) Okay First, make sure you're running a recent MySQL version. And try to use the binary distributions available on the mysql.com web site. I was reading in the manual that u could up some of the cache sizes, /usr/local/mysql/bin/safe_mysqld --user=mysql -O key_buffer=64M -O table_cache=256 \ -O sort_buffer=4M -O record_buffer=1M would making any of these bigger help at all? They will help A LOT if your queries use indexes. Make sure your queries are using indexes. I have a 1GB machine and set the key buffer to either between 256MB and 384MB most of the time. And I often use a record_buffer of 16MB or so. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 14 days, processed 255,374,790 queries (210/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Swapping
On Wed, Sep 19, 2001 at 04:37:03PM -0400, Phillip Spademan wrote: Hello All. I am working with a rather large MySQL DB, it seems that it likes to swap ALOT, even after the operations are done, i have bumped up my cache sizes, i have tones of .bin files in my var dir, any ideas? What OS are you running on? If Linux 2.4.x, you might be running into some of the same problems I saw with the VM subsystem. I posted a note about a week ago describing the problems I've seen. It has since migrated to the linux-kernel mailing list where folks are still trying to tune things correctly. If not, tell us which OS, how much RAM you have, and send along your my.cnf file. Then we can make some informed suggestions. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 14 days, processed 255,376,155 queries (210/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Aborted connection XXX to db.... (Got an error reading communication packets)
On Thu, Sep 20, 2001 at 01:36:10PM +0800, Luke Chiam wrote: Thanks for the reply Jeremy. I keep getting 500 Internal Server error when accessing my database, my application is a C++ development of my own. Smells like Apache to me. Thats what I thought, but on reading Apache docs faq, it mentioned that it is probably the cgi script failure to return proper set of header. So I start rereading my lines of code and check for memory leaks and point of failure, but found none. Then I take out all the MySQL access code and wowla! everything is ok. If it's a CGI program, it should be trivial to find the problem--try running it outside of Apache. Does it work? Try running it as the same user as Apache runs under. Does it still work? If so, this really isn't a MySQL problem. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 14 days, processed 255,480,944 queries (210/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Load_File(2)
The manual said if you want to write a BLOB data into file, you should use INTO DUMPFILE, But that still doen't work. I got a Dumpfile with just 1 byte. There is a BLOB data in my table. What is the problem? best regards hxia See MySQL Manual section 6.4.1 SELECT INTO OUTFILE -- ___ Talk More, Pay Less with Net2Phone Direct(R), up to 1500 minutes free! http://www.net2phone.com/cgi-bin/link.cgi?143 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Howmany databases??
On Wed, Sep 19, 2001 at 07:54:12AM -, program tester wrote: Hello, I would like to know that how many databases can i use for one site at max? Hopeing for kind help Gee, you could probably easily use 100,000 or more if you have ReiserFS or another filesystem that can handle large directories. I'll be impressed if you have anywhere near that many! You see, the limit is not in MySQL, it's in the operating system. How many subdirectories can you have in one directory and still maintain decent performance? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 14 days, processed 255,489,296 queries (210/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problems with my.cnf
Hi, Could anyone tell my why from time to time, the file my.cnf (under Win2000 and MySql) is automatically renamed into my_cnf.bak? Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 password
On Thu, Sep 20, 2001 at 10:21:07AM +0800, victor wrote: can mysql use the linux password /etc/passwd for the authentication No. Because it cannot guarantee that users are who they say they are. If you think of authorization and authentication as two separate problems, the reasons are a little more clear. And if you check the mailing list archives, you'll see that this comes up all the time. Really. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 14 days, processed 255,651,006 queries (210/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problems with my.cnf
Hi, Adrian. AG Hi, AG Could anyone tell my why from time to time, the file my.cnf (under Win2000 AG and MySql) is automatically renamed into my_cnf.bak? AG Adrian Probably you use winmysqladmin.exe. AG - AG Before posting, please check: AGhttp://www.mysql.com/manual.php (the manual) AGhttp://lists.mysql.com/ (the list archive) AG To request this thread, e-mail [EMAIL PROTECTED] AG To unsubscribe, e-mail [EMAIL PROTECTED] AG Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Best regards, Pavel mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: view support
On Wed, Sep 19, 2001 at 12:37:04PM -0400, Alexander Pichtchikov wrote: Gents, When version 4.1 of MySQL with view supporting will publish? Sometime after 4.0. Seriously, though, I don't think anyone knows with much certainty. The 4.0 release has to hit alpha/beta/gamma testing and then be released. That should be starting soon, based on what we've heard here before. You can, of course, offer to sponsor the work on views and it might speed things up... The MySQL folks always like that. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 14 days, processed 255,706,181 queries (210/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php