Sub selects working around
Hi, I am guessing this is the kind of problem that would be easier to solve with a sub select SELECT simpleparts.category,simpleparts.partnumber,simpleparts.manufacturer,simplep arts.descrp,ABS(packagesParts.pri) as abPRI,categories.sortorder FROM ((packagenames LEFT JOIN packagesParts ON packagenames.packageID = packagesParts.packageID) LEFT JOIN simpleparts ON packagesParts.partnumber = simpleparts.partnumber) LEFT JOIN categories ON simpleparts.category = categories.category WHERE simpleparts.configurator 0 AND categories.onconfig 0 AND packagenames.packagename = $system_name AND simpleparts.category = ? ORDER BY abPRI DESC This in one case returns --++--+-+--+ ---+ | category | partnumber | manufacturer | descrp | pri | sortorder | +--++--+-+-- +---+ | Game Controllers | 234232 | Jumbo Video | Video card |1 | 24 | | Hard Drives| 78544 | HTH | a Drive controller |1 |12 | | Floppy Drives | HP-4p | HP | 4P - 48bit |1 |13 | | CPUs | int-550c | Intel| Celeron 500MHZ 128K | 1 | 1 | | Memory | mem-102| who knows| 256M 120pin |1 | 3 | | Scanners | 9955 | Acer | 10 ISA |0 |22 | | Game Controllers | game-01| Atari| Simple stick| 0 |24 | | CPUs | INT550 | INTEL| PIII 550 CPU |0 | 1 | | Memory | mem-101| who knows| 128M |0 | 3 | | Modems | mod-124| USR | sportster 28.8 |0 | 9 | +--++--+-+-- +---+ But I have one more constraint that I would like to be able to include in the query and not deal with in code. I want to not return anything in the case where none of the packagesParts.pri are = 0 this is hard because I do what those packagesParts.pri =0 where there is a packagesParts.pri = 1 in the result set. Is there a way to cram this into my query with mysql as it stands? I saw some people here do some pretty fancy stuff, so I thought it was worth asking. Thanks, Eric Frazier Consulting http://www.kwinternet.com/eric (250) 655 - 9513 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Would you please tell me....
±i®p»Ê wrote:
Hi, happy new year!!
Yesterday morning, I operated MySQL (3.23.28) insert some data into a table ,
I found a error and could not find any one can help with:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 117 to server version: 3.23.28-gamma
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql use gon;
Database changed
mysql insert into mymp3 (myclass)values('class_four');
ERROR 1062: Duplicate entry '127' for key 1
mysql
Could you please tell me what's wrong with and how to deal wiht it ? Thanks!!
fongming from Taiwan ,2001/1/15
Like you can see, duplicate entry 127, yo create a primary key, but then
you can insert the same value twice...
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
keeping MySQL on a SEPARATE SERVER - lag time?
Has anyone done testing to show the difference between: #1 - having MySQL on the same server as Apache/PHP vs. #2 - having MySQL on its own dedicated computer, TCP/IP connected to the main Apache box NOTE: We use lots of little MySQL lookups in our PHP scripts. Nothing that intensive. But our site is getting pretty MySQL-intensive and often MySQL takes up 30% of the CPU power. Advice? Opinion? URLs to read? Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Crashing MySQL on FreeBSD4.2 with Apache/php4
Nope, i didn't, but i compiled using the same options as the ports-version. But i'll give it a try right away. How about someone using both mysql/php/FreeBSD4.2 ? Aren't there any with that configuration, who has has the problems as i have? I strongly believe the problem is related to something interconnecting with mysql, and not mysql itself, since the benchmark-tests run perfectly on my mysql-installation. -Original Message- From: Danny [mailto:[EMAIL PROTECTED]] Sent: 16. januar 2001 02:15 To: Nicolai Gylling; '[EMAIL PROTECTED]' Subject: Re: Crashing MySQL on FreeBSD4.2 with Apache/php4 Hallo - Just out of interest . Did you install MySQL on FREEBSD using www.freebsd.org/ports if you didnt I highly recom,mend you should. Looking forward to your feedback. dannyh [EMAIL PROTECTED] On Tue, 16 Jan 2001, Nicolai Gylling wrote: Hi I'm currently running a FreeBSD4.2-Stable server with Apache1.3.14/PHP4.0.4pl1 and MySQL 3.23.27-Beta. The problem is that MySQL is crashing constantly, sometimes several times each minute. I've been through all the "What to do if mysql keeps crashing" steps in the MySQL-documentation, but nothing helped. My research has come up with suggestions regarding the threads in FreeBSD4.2 and sessionhandling in PHP. Is there anyone who has had similar problems, or might know what to do? Nicolai Gylling System Administrator | [EMAIL PROTECTED] | http://www.neoideo.com Neo Ideo A/S | Galionsvej, Bygning 156 | DK-1437 Copenhagen K. Phone: +45 7020 2414 | Direct: +45 7730 4300 | Telefax: +45 7020 2415 | Mobile: +45 2098 5543 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
fast index corruption... Workaround
Hello, Problem description: I have posted several emails to this list during the last few days because of mysqld crashes and index corruptions. After upgrading from 3.22.32 to 3.23.30 server crashes have disappeared but with still had index corruptions (between one and two tables corrupted every two hours). Workaround: I have rebooted the server in single-processor mode and there was NO index corruption in the last 24 hours (although the server was even more loaded than during previous days: between 300 and 350 queries/s). Hardware platform : Dell PowerEdge 2450 bipro PIII/733, 2Gb RAM, integrated hardware RAID crontroller (PERC3) with 2x18Gb disks configured in RAID1 (mirroring) mode. Operating system: Linux RedHat 6.2 (kernel 2.2.14 SMP) MySQL version: 3.23.32 from binary RPM (MySQL-3.23.30-1.i386.rpm) Thanks a lot to all of you that have replied to my posts, you helped me a lot. -- Joseph Bueno NetClub/Trader.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Sub-querys supported?
Hi. On Tue, Jan 16, 2001 at 12:20:50AM -0800, [EMAIL PROTECTED] wrote: On Tue, Jan 16, 2001 at 08:01:26AM +, John Dean wrote: At 23:38 15/01/2001 -0800, you wrote: Probably in version 4.1 or so. Is that a fact. Well that's news to me :o) I could probably dig up the e-mail in which someone from MySQL said that. (Or I'm mis-remembering...) You are remembering correctly. There was an email quoting a web page, namely http://www.mysql.com/development/todo.html, which suggest that sub-queries probably come early in 4.1. Bye, Philemon. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
select from HEAP table failing with error 124
Hi!
"David" == David Mechner [EMAIL PROTECTED] writes:
David Hi,
David My license number is 7697. I don't know what the expiration date is. I'm
running 3.23.28-gamma msqld-opt under w2k.
David I'm trying to use a HEAP table to speed up data access, but every select I do
which references an indexed column gives me:
David ERROR 1030: Got error 124 from table handler
David Other select statements work. I don't know what this means, and can't find any
documentation on it in the manual. perror says 124 is "wrong index given to function",
which isn't much more helpful.
David The heap table is created like this:
David DROP TABLE IF EXISTS data_series_heap;
David CREATE TABLE data_series_heap TYPE=HEAP select * from data_series;
David CREATE INDEX stock_id_index ON data_series_heap(stock_id);
David where the original table was created as:
David DROP TABLE IF EXISTS data_series;
David CREATE TABLE data_series (
David id INTEGER PRIMARY KEY AUTO_INCREMENT,
David stock_idINTEGER NOT NULL REFERENCES stocks,
David data_type ENUM('LTG', 'EPS', 'REC', 'PRC') NOT NULL,
David periodicity ENUM('NONE', 'ANN', 'SEM', 'QTR') NOT NULL,
David period_yINTEGER,
David period_mINTEGER,
David unique index(stock_id,data_type,periodicity,period_y,period_m)
David );
The above means that somehow the usage of the heap table doesn't work
as expected.
I tried to repeat this but I didn't succeed on doing this.
--
mysql create table t1 (id int not null primary key auto_increment, stock_id int not
null);
Query OK, 0 rows affected (0.05 sec)
mysql insert into t1 (stock_id) values (1),(2),(5),(10),(15),(10),(21),(55);
Query OK, 8 rows affected (0.01 sec)
Records: 8 Duplicates: 0 Warnings: 0
mysql CREATE TABLE t2 TYPE=HEAP select * from t1;
Query OK, 8 rows affected (0.04 sec)
Records: 8 Duplicates: 0 Warnings: 0
mysql CREATE INDEX stock_id_index ON t2(stock_id);
Query OK, 8 rows affected (0.03 sec)
Records: 8 Duplicates: 0 Warnings: 0
mysql select * from t2 where stock_id=5;
++--+
| id | stock_id |
++--+
| 3 |5 |
++--+
1 row in set (0.00 sec)
If you can ftp a full workable example that crashes to:
ftp://support.mysql.com/pub/mysql/secret
we will fix this!
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
Result set , updateRow method
Hi ,
I'm using mysql driver for JDBC ("org.gjt.mm.mysql.Driver").
I am using result set and i want to update a record that exists in the set.
In order to do so i used the following code:
rs.updateString(4,"");
rs.updateRow();
and i got "java.lang.AbstractMethodError" when updateRow() was called.
Does anybody know why this driver doesn't implement this method ?
How can i update my database instead ?
TIA ,
Yuval Katz
configuration
Bonjour, Je suis novice en configuration de bases de données. J'ai installé php3, apache, mysql et phpMyAdmin sous NT4. Comme indiqué, j'ai installé mysql sur le disque C, puis je l'ai transferré à un autre emplacement en modifiant my.cnf. J'ai pu me connecter sous Dos, mais je n'arrive pas à me connecter à phpMyAmdmin à partir d'un lien vers index.php3. J'ai donc créé un fichier de test que voici ? $host="127.0.0.2"; $user=""; $password=""; $database="mysql"; Mysql_connect($host, $user, $password); echo "connection réussie"; ? Lorsque je le lance, j'obtiens le message : Fatal error: Call to unsupported or undefined function mysql_connect() in f:\apache\httdocs\essai_connect.php3 on line 6 et, dans error.log : [Mon Oct 09 15:46:19 2000] [error] Failed to resolve server name for 127.0.0.2 (check DNS) -- or specify an explicit ServerName J'ai essayé de modifier de toutes les façons le DNS utilisateur, rien ne change. Pourriez-vous me donner un coup de main. Merci. Orthophptere __ Boîte aux lettres - Caramail - http://www.caramail.com Emanuel.exe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: raid tables doesnt seem to split files.
Hi Firdaus! On Thu, 12 Oct 2000, Firdaus Mah wrote: Hi Jerome, Heh... I'm already doomed. I'ved just inserted 32 million records and its stopped at 2GB even using on reiserfs. I'ved not checked the detail or experience in Postgress development. Does it do stripping as well ie breaking up tables and index file. It is not reiserfs which is limiting you to 2GB (reiserfs is unsigned and should limit you to 4GB), however the VFS layer is only signed so it will not communicate the extra bit to reiserfs so that it will access 2GB. I suspect that if you were to apply the LFS patches it will start working, but I've never done it on a reiserfs partition. My conclusion is that until this moment, MySQL is suitable for small to medium databases. Not true, I have MySQL running on a Alpha and have none of these limitations =) -Myron firdaus Jerome Abela wrote: On Wed, Oct 11, 2000 at 12:51:50PM +0800, Firdaus Mah wrote: this is how i'ved created create table test (field char(70) not null primary key) RAID_TYPE=STRIPED RAID_CHUNKS=1024 RAID_CHUNKSIZE=1024; This only works if mysqld was compiled with the --with-raid option. You can check this by grepping 'CONFIGURE_LINE=' from mysqlbug script. Otherwise, the RAID option to CREATE is silently ignored. Note that only the data file (MYD) is stripped. If your index becomes too big, you are doomed. Jerome. -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: [EMAIL PROTECTED] If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php Emanuel.exe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
escape character for # sign?
How can I escape the mysql comment # character in sql statements? Thanks, Doug Sherman Emanuel.exe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Install Mysql3.22.32 in Solaris7
Dear Sir, I try to install Mysql3.22.32 in the Solaris7 OS. But I can finish the ./configure. Could you tell me why?Attach file is config.log. Best Regard, Ginger Lin Emanuel.exe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Install Mysql3.22.32 in Solaris7
Dear Sir, I try to install Mysql3.22.32 in the Solaris7 OS. But I can finish the ./configure. Could you tell me why?Attach file is config.log. Best Regard, Ginger Lin Emanuel.exe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Antigen found Navidad.16896.Worm virus
Antigen for Exchange found Emanuel.exe infected with Navidad.16896.Worm virus. The file is currently Deleted. The message, "mysql Digest 16 Jan 2001 11:48:16 - Issue 1078", was sent from [EMAIL PROTECTED] and was discovered in Grimes, Shawn (NIA/IRP)\Inbox located at NIH/NIAGRC/C30. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Antigen found Navidad.16896.Worm virus
Antigen for Exchange found Emanuel.exe infected with Navidad.16896.Worm virus. The file is currently Deleted. The message, "mysql Digest 16 Jan 2001 12:06:37 - Issue 1079", was sent from [EMAIL PROTECTED] and was discovered in Grimes, Shawn (NIA/IRP)\Inbox located at NIH/NIAGRC/C30. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Antigen found Navidad.16896.Worm virus
Antigen for Exchange found Emanuel.exe infected with Navidad.16896.Worm virus. The file is currently Deleted. The message, "mysql Digest 16 Jan 2001 12:06:37 - Issue 1079", was sent from [EMAIL PROTECTED] and was discovered in Grimes, Shawn (NIA/IRP)\Inbox located at NIH/NIAGRC/C30. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ALERTE: VIRUS DETECTE DANS UN MESSAGE ENVOYE PAR mysql-digest-return-61915-oh=nordnet.fr@lists.mysql.com
A L E R T E V I R U S Notre système de détection automatique anti-virus a détecté un virus dans un message qui vous a été envoyé par [EMAIL PROTECTED] La distribution de ce message a été stoppée. Veuillez vous rapprocher de l'émetteur [EMAIL PROTECTED] pour régler avec lui le problème. *** V I R U S A L E R T Our anti-virus system has detected a virus in an email sent by [EMAIL PROTECTED] We have stopped the delivery of this email. We invite you to contact [EMAIL PROTECTED] to solve the problem. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ALERTE: VIRUS DETECTE DANS UN MESSAGE ENVOYE PAR mysql-digest-return-61892-oh=nordnet.fr@lists.mysql.com
A L E R T E V I R U S Notre système de détection automatique anti-virus a détecté un virus dans un message qui vous a été envoyé par [EMAIL PROTECTED] La distribution de ce message a été stoppée. Veuillez vous rapprocher de l'émetteur [EMAIL PROTECTED] pour régler avec lui le problème. *** V I R U S A L E R T Our anti-virus system has detected a virus in an email sent by [EMAIL PROTECTED] We have stopped the delivery of this email. We invite you to contact [EMAIL PROTECTED] to solve the problem. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Why does 1st query take so long?
I've noticed that when developing queries involving complex joins on
tables I sometimes seem to get appallingly long times the first time I run
a query, but the second and subsequent time I run it - even substituting
a different value for a field value I'm matching on - the query runs
quickly.
Does mySQL do some behind-the-scenes reindexing the first time,
resulting in the speed differences I see? If so is there some way I can
force it to re-build indices periodically so I can ensure that queries are
generally fast? Is this the point I should be going out and buying a book
about mySQL? ;-)
Here'a an example query:
SELECT d.ifIndex, d.MAC, a.IPadd, d.nMACs, d.mtime, x.deviceID, x.ifIndex
FROM dot1d as d
LEFT JOIN MAC_connections as x
ON d.MAC = x.MAC
LEFT JOIN IP_MAC as a
ON a.MAC = d.MAC
WHERE x.deviceID=d.deviceID AND x.ifIndex=d.ifIndex AND
d.deviceID= {some value}
My MAC_Connections table is indexed on MAC, and IP_MAC is indexed on MAC.
mySQL Version is 3.22.32
regards,
--
John Stumbles [EMAIL PROTECTED]
I.T. Services Centre, University of Reading http://www.rdg.ac.uk/~visstmbl
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
never generalise
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [DOCS COMMENT] Section 'TODO_MySQL_4.0'
-Original Message- From: Mr.Y.SHIVAKANT [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED]; Sasha Pachev [EMAIL PROTECTED] Date: Thursday, January 04, 2001 8:48 PM Subject: Re: [DOCS COMMENT] Section 'TODO_MySQL_4.0' -Original Message- From: Sasha Pachev [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday, January 03, 2001 7:37 AM Subject: [DOCS COMMENT] Section 'TODO_MySQL_4.0' The following comment was submitted to the MySQL Manual. From: Sasha Pachev [EMAIL PROTECTED] Regarding: http://www.mysql.com/manual.php?section=TODO_MySQL_4.0 I want 4.0 now! -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: [EMAIL PROTECTED] If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php sounds good YOURS SINCERELY SHIVAKANTH -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: [EMAIL PROTECTED] If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php hey i am online and got a lot of time to waste comming - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 on unixware 7.1
Hello, Is there someone who has experience on installing mysql-3.22.32 on Unixware 7.1. I tried the binaryversion but complains about the libz.so.1 file witch is there. I also compiled the source serveral times. The deamon runs but the client gives only segmentation faults when putting some statements on the prompt. Please help me. John Kuiper - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
lockup in test suite
Hi, I have download the latest binary distribution for SGI Irix: mysql-3.23.30-gamma-sgi-irix6.5-mips and it lock when I try the test suite: Here is the test output: thingol 117# ./mysql-test-run Installing Test Databases Removing Stale Files Installing Master Databases Installing Slave Databases Starting MySQL daemon Loading Standard Test Databases Starting Tests TEST USER SYSTEM ELAPSEDRESULT alter_table 0,0160,0601,050 [ pass ] analyse 0,0120,0340,242 [ pass ] auto_increment 0,0210,0741,049 [ pass ] bdb [ skipped ] bigint 0,0120,0340,140 [ pass ] binary 0,0150,0490,327 [ pass ] case 0,0150,0440,138 [ pass ] comments 0,0120,0360,090 [ pass ] compare 0,0120,0350,152 [ pass ] count_distinct 0,0160,0510,494 [ pass ] create 0,0170,0540,422 [ pass ] After that nothing happens. Here is what mysqladmin have to say: ../../../bin/mysqladmin -S mysql-master.sock processlist ++--+---+--+-+--+--+--+ | Id | User | Host | db | Command | Time | State| Info | ++--+---+--+-+--+--+--+ | 1 | root | localhost | | Binlog Dump | 653 | Waiting for update | | | 13 | test | localhost | test | Query | 641 | waiting for handler open | insert delayed into t1 set a = 2 | | 14 | | | test | Killed | | Waiting on cond | t1 | | 17 | root | localhost | | Query | 0| | show processlist | ++--+---+--+-+--+--+--+ thingol 126# !! ../../../bin/mysqladmin -S mysql-master.sock processlist ++--+---+--+-+--+--+--+ | Id | User | Host | db | Command | Time | State| Info | ++--+---+--+-+--+--+--+ | 1 | root | localhost | | Binlog Dump | 691 | Waiting for update | | | 13 | test | localhost | test | Query | 679 | waiting for handler open | insert delayed into t1 set a = 2 | | 14 | | | test | Killed | | Waiting on cond | t1 | | 18 | root | localhost | | Query | 0| | show processlist | ++--+---+--+-+--+--+--+ I'm testing this on an SGI O2 workstation running Irix 6.5.8f. I have also try the source distribution. It compile OK but has the same problem (at the same place). I have also try the source distribution on other SGI box and it locks but on other places at random (in the tests). I have also a dead lock problem with our production mysqld for which I have posted here a while ago (all processes have the 'locked' state). Do others run mysqld on SGI with success? I would like to know. The notes on SGI in the manual are somewhat 'vague' and outdated to me. I would be ready to investigate further but I don't know where to search. Thanks. - Robert Marchand DGTIC/SIT poste 5210 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Sub selects working around
Hi Eric, I'll second Bob Hall's opinion. One could extend a query so that it checks also your additional condition. You haven't gotten to the 'group by' and 'having' goodies, that's the hint. But this would make it over-complicated, and MySQL could run into problems when attempting to evaluate that query (the join would actually produce a cross product, which you'd only afterwards collapse to a linear list by the 'group by'). BTW, what is packagesParts.pri supposed to mean? Perhaps the fact that none of packagesParts.pri = 0 for a given package is significant enough that you want to record it with packenames? OTOH this, as a derived piece of information, would go against the "Normalize!" imperative. You'd have to be more careful when updating the records, as MySQL won't look for that part of info for you. Just a suggestion. Jan Dvorak Bob Hall wrote: Sir, here's a guess in return. The best way to deal with this is to have your client app run a query that counts the rows where packagesParts.pri 0. Then run the query below only if the count is greater than 0. Bob Hall Hi, I am guessing this is the kind of problem that would be easier to solve with a sub select SELECT simpleparts.category,simpleparts.partnumber,simpleparts.manufacturer,simplep arts.descrp,ABS(packagesParts.pri) as abPRI,categories.sortorder FROM ((packagenames LEFT JOIN packagesParts ON packagenames.packageID = packagesParts.packageID) LEFT JOIN simpleparts ON packagesParts.partnumber = simpleparts.partnumber) LEFT JOIN categories ON simpleparts.category = categories.category WHERE simpleparts.configurator 0 AND categories.onconfig 0 AND packagenames.packagename = $system_name AND simpleparts.category = ? ORDER BY abPRI DESC This in one case returns --++--+-+--+ ---+ | category | partnumber | manufacturer | descrp | pri | sortorder | +--++--+-+-- +---+ | Game Controllers | 234232 | Jumbo Video | Video card |1 | 24 | | Hard Drives| 78544 | HTH | a Drive controller |1 |12 | | Floppy Drives | HP-4p | HP | 4P - 48bit |1 |13 | | CPUs | int-550c | Intel| Celeron 500MHZ 128K | 1 | 1 | | Memory | mem-102| who knows| 256M 120pin |1 | 3 | | Scanners | 9955 | Acer | 10 ISA |0 |22 | | Game Controllers | game-01| Atari| Simple stick| 0 |24 | | CPUs | INT550 | INTEL| PIII 550 CPU |0 | 1 | | Memory | mem-101| who knows| 128M |0 | 3 | | Modems | mod-124| USR | sportster 28.8 |0 | 9 | +--++--+-+-- +---+ But I have one more constraint that I would like to be able to include in the query and not deal with in code. I want to not return anything in the case where none of the packagesParts.pri are = 0 this is hard because I do what those packagesParts.pri =0 where there is a packagesParts.pri = 1 in the result set. Is there a way to cram this into my query with mysql as it stands? I saw some people here do some pretty fancy stuff, so I thought it was worth asking. Thanks, Eric Frazier Consulting http://www.kwinternet.com/eric (250) 655 - 9513 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: raid tables doesnt seem to split files.
RAID tables works fine for me. I don't know which OS you are running, i got it to work with a linux box like this: 1. Upgrade to the 2.4 linux kernel(Or patch an older kernel with the LFS patch) 2. Recompile mysql 3.23 with the --with-raid configure option (the precompiled binaries doesn't seem to have this feature compiled in). 3. Create a RAID table like the manual describes. Sincerely, Christian. btw: I am using ext2, but it should work the same with reiserfs. -Original Message- From: funky gao [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 12:41 PM To: Firdaus Mah Cc: Jerome Abela; [EMAIL PROTECTED] Subject: Re: raid tables doesnt seem to split files. Hi Firdaus! On Thu, 12 Oct 2000, Firdaus Mah wrote: Hi Jerome, Heh... I'm already doomed. I'ved just inserted 32 million records and its stopped at 2GB even using on reiserfs. I'ved not checked the detail or experience in Postgress development. Does it do stripping as well ie breaking up tables and index file. It is not reiserfs which is limiting you to 2GB (reiserfs is unsigned and should limit you to 4GB), however the VFS layer is only signed so it will not communicate the extra bit to reiserfs so that it will access 2GB. I suspect that if you were to apply the LFS patches it will start working, but I've never done it on a reiserfs partition. My conclusion is that until this moment, MySQL is suitable for small to medium databases. Not true, I have MySQL running on a Alpha and have none of these limitations =) -Myron firdaus Jerome Abela wrote: On Wed, Oct 11, 2000 at 12:51:50PM +0800, Firdaus Mah wrote: this is how i'ved created create table test (field char(70) not null primary key) RAID_TYPE=STRIPED RAID_CHUNKS=1024 RAID_CHUNKSIZE=1024; This only works if mysqld was compiled with the --with-raid option. You can check this by grepping 'CONFIGURE_LINE=' from mysqlbug script. Otherwise, the RAID option to CREATE is silently ignored. Note that only the data file (MYD) is stripped. If your index becomes too big, you are doomed. Jerome. -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: [EMAIL PROTECTED] If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php VIGILANTe.com NOTICE - AUTOMATICALLY INSERTED The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Any opinions expressed in this email are those of the individual and not necessarily the Company. If you receive this transmission in error, please email to [EMAIL PROTECTED], including a copy of this message. Please then delete this email and destroy any copies of it. DISCLAIMER END - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Availability of stable version for 3.23
I tried mailing this "funky gao" person directly, but it turns out that our viral-spreading friend didn't bother to include a real return address. I'm forwarding this to the group to shame him into fixing his mailer and his computer... funky gao wrote: Hi all, I am building a Java based application and want to use MySQL as my database. I would be using JDBC to access the MySQL database. My target platform is Solaris 2.7. I downloaded and installed MySQL version 3.22.32 which is the stable version available. Alas... this versoin does not support transactions and commit/rollback. Also this version does not foreign keys and referential integrity. I dont want to use workarounds like table locking and unlocking to achieve transactions. Foreign keys and referential integrity is not supported in any current release, save for window dressing. It seems that the support for transactions and commit/rollback is available in releases 3.23.15 and higher. Does this release support for foreign keys and referential integrity as well? Also 3.23 is a beta release. How stable is 3.23 beta and when can we expect the stable version for 3.23? The current 3.23 release is no longer beta, but gamma. We have been using it for a good while and think it as stable as previous "stable" releases. -- http://www.pricegrabber.com | Dog is my co-pilot. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
VIRUS FOUND Re: escape character for # sign?
Attention, the original message of Funky Gao and following replies contain the virus W32.Navidad.16896 Antonio
SQL coloring in BBEdit 6.0?
Hello, I'm using BBEdit 6.0.2 to do some PHP. I love the way it colors the PHP commands differently. I also do mySQL. I usually write up a whole list of SQL statements in a text editor and then feed them into the server. Is there a way to have BBEdit color code the mySQL commands that same way it does HTML and PHP? Thanks Mike -- Mike Zornek, Web Development Seybold Publications 428 East Baltimore Avenue P.O. Box 644 Media, PA 19063, USA http://www.seyboldreports.com Phone: (610) 565-2480 x131 Fax: (610) 565-4659 Email: [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: Why does 1st query take so long?
- Original Message - From: [EMAIL PROTECTED] To: "mySQL list" [EMAIL PROTECTED] Sent: Tuesday, January 16, 2001 3:57 PM Subject: Why does 1st query take so long? I've noticed that when developing queries involving complex joins on tables I sometimes seem to get appallingly long times the first time I run a query, but the second and subsequent time I run it - even substituting a different value for a field value I'm matching on - the query runs quickly. Does mySQL do some behind-the-scenes reindexing the first time, resulting in the speed differences I see? If so is there some way I can force it to re-build indices periodically so I can ensure that queries are generally fast? Is this the point I should be going out and buying a book about mySQL? ;-) I think its because the Operating System is caching the data the query are run on - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: need advice about security
Run a program behind a password protected area on the secure server. Have the program dump the data as a delimited text file and import it. Your using SSL to protect both the access (username and passsword) and the data this way. If you want to use pgp, dump to file and encrypt and then pick up with ftp. On Fri, 12 Jan 2001, Robyn Renwick wrote: Date: Fri, 12 Jan 2001 21:21:17 -0800 From: Robyn Renwick [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: need advice about security Hi everyone, I use a MySQL database for the back end of our e-commerce site. We take credit as one method of payment and the last 8 digits of the card number are stored in the database. There is a web interface to the database from which I can get order information, but not the card number. I also can access the database through a MyODBC connection and MyAccess. In order to proceed with invoicing, I need to retrieve the card number (all 16 digits). I can think of a couple of ways to do this: 1. Change the web interface to include the card number. 2. Bring the information into Access through the ODBC connection. 3. Have the card number encrypted and sent through email, using PGP (this is the way we did it on our old system). There may be others which I am not thinking of also. Which method would be the most secure, or is there a better and more secure method which I haven't mentioned? Any suggestions would be greatly appreciated. take care, robynr Robyn Renwick, CPST (NIC 1998) Programmer, Buckingham Stencils, Inc. Robyn Renwick, CPST (NIC 1998) Programmer, Buckingham Stencils, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: choose a free databse management
On Sat, 13 Jan 2001, John Hinsley wrote: Date: Sat, 13 Jan 2001 17:12:05 + From: John Hinsley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: choose a free databse management Danny [EMAIL PROTECTED] wrote: There are mnay free RDBMS around besides MySQL This includes: Postgresql mSQL (mini SQL) *** I believe that development work on this is stopped. there also is a slight fee for using it if you can find the developer to pay him. Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
...
... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem when I want to set password to root user
From: "Michel Tignyemb" [EMAIL PROTECTED] Sent: Tuesday, January 16, 2001 4:33 PM Here is the command : mysqladmin -u root -p password 'mysql' Remove the space between -p and password: mysqladmin -u root -ppassword mysql - Carsten - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to put database into RAM?
I appreciate everyone's responces. It's really great to be on this list :) I'll try to answer some your questions. Donal McMullan wrote: but what are you running this on? Is the DB server only serving the database? The machine have not been set up yet. We want to test the whole idea before spending big bucks on hardware. Our IT guy is investigating how to set up a machine tha would have as much RAM as possible with the motherboards we already have. I am going to produce a smaller database specifically for testing, and then pray that the results scale. The server will be dedicated to serving the database over web interface, so it will likely run MySQL + Apache. Neil Davis wrote: Can we see the code and queries in question? It may be a better solution to clean up the queries(and code), perhaps change multiple queries into one query ... Indexing the tables would undoubtedly help as well. If they already are indexed, when is the last time they were re-indexed and cleaned up?(this needs to be part of your maintenance plan, preferably automated) The actual code is rather large, so I won't post it here. But I can explain the general idea. There are 4 databases: a, b, c, d. Each database has a set of tables: table a_entries (autoincrement autoid, char id, char field1, text field2, ...) table a_dimension1 (autoincrement autoid, char entry_id, char field1, text field2, ...) table a_dimension2 (autoincrement autoid, char entry_id, char field1, text field2, ...) ... Each database contains a set of objects, or entries. Each entry has a unique id. There is one row in the "entries" table for each entry. There can be more than one row per entry in each "dimension" table. For example, a person's name would be listed in table person_entries, while his/her bank accounts would be listed in table person_accounts and cross-referenced back to him like so: person_entry.id = person_accounts.entry_id. The entries from the 4 databases are cross-referenced to each other. The cross-references are listed in special tables: table xref_a_b(char a_id, char b_id) The goal is to search all 4 databases and retrieve entries in database "d" either directly or using cross-references from the other databases. For example, if an entry in database "a" has been found, use the cross-reference table to retrieve the corresponding entry in "d". So, each table needs to be searched, and then the cross-reference tables need to be searched as well. While some parts of my code can undoubtedly be optimized, I can't possibly get away from multiple queries and/or joins. Besides, the program being large, it's not too easy to tweak it without introducing bugs. So we thought that throwing some hardware at it might just solve the problem without having to rewrite things. As for indexes, most of my data fields are text, so I use a derivative of perl module DBIx::TextIndex to search them. All "id" fields are indexed, of course; and the entire database is re-built on a weekly basis. Yury "Yury V. Bukhman" wrote: Hi! Background: I have a moderately-sized (0.9G) database which serves as a backend to a search engine. The search engine is kind of slow, because it has to run multiple database queries for each user request (don't ask me why). In order to speed things up, I am thinking of copying the entire database into RAM. The users do not update it, they only search, so if the server goes down, I can just copy the database from hard drive into RAM again on startup. Question: what is the best way to put an entire database into RAM? I thought of using HEAP tables, but they seem to have some limitations, e.g. not allowing text column type. Is it possible to just copy an entire data directory into RAM? Are there operating systems that allow this? I currently run Linux, but could switch easily to another UNIX-like system. Have anyone done something like this? Any RTFMs or other pointers to literature will be appreciated. Cheers! Yury - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Windows ME under MySQL?
Actually he was quite wrong. Though it seems they've fooled the masses by simply moving the icon ::snicker joke snicker:: Just kidding guys :) Aaron -Original Message- From: Pickup, Jordan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 11:16 AM To: [EMAIL PROTECTED] Subject: RE: Windows ME under MySQL? Your pupil is right. Microsoft has done a good job of hiding DOS in Windows ME. Microsoft would like you to believe that ME is not based on DOS anymore but it must be since it is based on the Windows 9X kernel. The plan for the next version of Windows is apparently to have DOS removed completely. For now, on Windows ME, this causes lots of problems. Windows is no longer capable of 'Booting to DOS' without a floppy. And, as if that weren't bad enough, many DOS programs no longer run from the Windows DOS console. Not even many of the DOS apps that come with Windows. Ping being a prime example. It no longer runs under Windows. However, I think this is an intentional annoyance on Microsofts part. It is still possible to run all the DOS programs in ME that you could run in 98. You just can't run them from the DOS console. If you run them from the 'Start-Run...' menu or make a bat file that calls them and then run the bat file (Double-click it - it likely won't run from the console), then the programs run fine. To me that means that the console has had it's features reduced. Windows ME is still capable of running the DOS programs. The Windows Console just doesn't want to. On Tuesday, January 16, 2001 12:14 AM, John Dean [SMTP:[EMAIL PROTECTED]] wrote: At 07:49 16/01/2001 +0100, Gustav Wiberg wrote: Hello there I'm a teacher who has MySQL as base for learning basics of databases. I just got a question about how you install MySQL under Windows Millenium. I don't have a clue. I haven't used Windows Millenium. Forget about ME. MySQL runs exactly the same way under 95, 98, 98SE and ME. Only the NT/W2K versions are slightly different. Installation is simple. Zip to a temp directory, then run the setup program The pupil says that DOS "nearly" doesn't exist under Windows Millenium. Is that true? If so, how do you install MySQL under Windows ME? (HOW do you download MySQL for Windows ME? (A link would be very, very appreciated) Does MySQL support Windows ME?) You pupil is wrong. Select Command prompt from the Accessories Menu to bring up the DOS terminal and enter the command ver. This will tell exactly which DOS version runs ME /Gustav Wiberg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Regards John MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Windows ME under MySQL?
"Pickup, Jordan" wrote: Your pupil is right. Microsoft has done a good job of hiding DOS in Windows ME. Microsoft would like you to believe that ME is not based on DOS anymore but it must be since it is based on the Windows 9X kernel. The plan for the next version of Windows is apparently to have DOS removed completely. For now, on Windows ME, this causes lots of problems. Windows is no longer capable of 'Booting to DOS' without a floppy. And, as if that weren't bad enough, many DOS programs no longer run from the Windows DOS console. Not even many of the DOS apps that come with Windows. Ping being a prime example. It no longer runs under Windows. However, I think this is an intentional annoyance on Microsofts part. It is still possible to run all the DOS programs in ME that you could run in 98. You just can't run them from the DOS console. If you run them from the 'Start-Run...' menu or make a bat file that calls them and then run the bat file (Double-click it - it likely won't run from the console), then the programs run fine. To me that means that the console has had it's features reduced. Windows ME is still capable of running the DOS programs. The Windows Console just doesn't want to. On Tuesday, January 16, 2001 12:14 AM, John Dean [SMTP:[EMAIL PROTECTED]] wrote: At 07:49 16/01/2001 +0100, Gustav Wiberg wrote: Hello there I'm a teacher who has MySQL as base for learning basics of databases. I just got a question about how you install MySQL under Windows Millenium. I don't have a clue. I haven't used Windows Millenium. Forget about ME. MySQL runs exactly the same way under 95, 98, 98SE and ME. Only the NT/W2K versions are slightly different. Installation is simple. Zip to a temp directory, then run the setup program The pupil says that DOS "nearly" doesn't exist under Windows Millenium. Is that true? If so, how do you install MySQL under Windows ME? (HOW do you download MySQL for Windows ME? (A link would be very, very appreciated) Does MySQL support Windows ME?) You pupil is wrong. Select Command prompt from the Accessories Menu to bring up the DOS terminal and enter the command ver. This will tell exactly which DOS version runs ME /Gustav Wiberg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Regards John MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, 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 just go to start -- run type in command hit enter and you will see the dos console appear. trust me their always a way to skin a cat. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Please remove me
Jenny Lie wrote: Hi, Please remove my name from the list. Thanks! Jenny Lie Read the unsubscribe note at the end of this email. No really...it works. AMK4 -- W | | I haven't lost my mind; it's backed up on tape somewhere. | ~ Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130 SysAdmin / Websmith . 800.441.3873 x130 Photo Craft Laboratories, Inc. .eFax 248.671.0909 http://www.pcraft.com . 3550 Arapahoe Ave #6 .. . . . . Boulder, CO 80303, 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
Winblows ME and MYODBC
Sorry, folks, if these seems off topic. I know it's a Winblows problem rather than MYODBC. After having "upgraded" to Windows ME from Windows 98, and am unable to run a query (select * from table -- in Visual BASIC) on only one table in my databases. I get a runtime error that the Microsoft ODBC Driver Manager doesn't support the resultant recordset. I know the permissions are correct for mysql, and the operation used to work perfectly on Windows 98. In fact, I tried the same thing on a different machine (Window 98 still), and it worked perfectly. Does anyone know of any problems with MYODBC on Winblows ME or is there (more likely) some bug in the ODBC Manager supplied with Winblows. Thank you, everyone, Laszlo Szijarto - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Removal of emanuel virus
See: http://service1.symantec.com/sarc/sarc.nsf/html/W32.Navidad.html and http://www.sophos.com/virusinfo/analyses/w32navidadb.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
fast index corruption... Workaround
Hi! "Joseph" == Joseph Bueno [EMAIL PROTECTED] writes: Joseph Hello, Joseph Problem description: Joseph I have posted several emails to this list during the last few Joseph days because of mysqld crashes and index corruptions. After Joseph upgrading from 3.22.32 to 3.23.30 server crashes have Joseph disappeared but with still had index corruptions (between one Joseph and two tables corrupted every two hours). Joseph Workaround: Joseph I have rebooted the server in single-processor mode and there Joseph was NO index corruption in the last 24 hours (although the server Joseph was even more loaded than during previous days: between 300 Joseph and 350 queries/s). Joseph Hardware platform : Joseph Dell PowerEdge 2450 bipro PIII/733, Joseph 2Gb RAM, Joseph integrated hardware RAID crontroller (PERC3) Joseph with 2x18Gb disks configured Joseph in RAID1 (mirroring) mode. Joseph Operating system: Joseph Linux RedHat 6.2 (kernel 2.2.14 SMP) Joseph MySQL version: Joseph 3.23.32 from binary RPM (MySQL-3.23.30-1.i386.rpm) Can you give us access to a corrupted table so that we can get some idea of what's happening? To also get some idea of the queries you use on this table should help a lot. I know that you have mentioned to Sinisa that you can't run with logging enabled, but just using --log-bin would only degrade performance about 1 %, so this shouldn't be a problem. Just by having a some not corrupted tables + a binary log that causes corruption would go a long way in fixing this! We have many persons that are using multi CPU systems on Linux and it's not a common problem to get index corruption the whole time. It's probably something unique with your setup that causes some bug to show up. To find out what this is, we would need a little help from you! 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
ORDER BY command
Hello. I am trying to get the results from a query to be ORDERED by ASCENDING instead of the default DESCENDING. Is this possible, and if so how? Robert - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: What type of a Column for True or False?
Why not use ENUM?
create table test
bool ENUM('t', 'f') default 't' not null,
val1 char(15),
val2 int
...
...
It will "map" T to a 0 and F to 1. It's nearly identical to what
you're doing, but it may seem more intuitive to some.
Cheers,
Chris Oson
-Original Message-
From: Scott Baker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 11:05 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: What type of a Column for "True" or "False"?
I wish MySQL had a boolean datatype for this exact reason. Unfortunately
it doesn't, so for all the times I've needed on I've just used a "Tinyint"
and set 0 to false, and -1 (or 1) to true.
At 05:41 PM 1/16/2001 +, SED wrote:
Hi, I'm new to MySQL and I want to create a column which only needs to
include "True" or "False" statement, but I'm not sure what type of a column
I should use. Can you give me a hint? I have read the manual but it was not
enough to convince me.
Regards,
Sumarlidi Einar Dadason
SED - Graphic Design
--
Phone: (+354) 4615501
Mobile: (+354) 8960376
Fax: (+354) 4615503
E-mail: [EMAIL PROTECTED]
Homepage:www.sed.is - New Homepage!
--
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]
"Always bear in mind that your own resolution to success is more important
than any other one thing." - Abraham Lincoln
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql on unixware 7.1
I created the binaries. A versions need the LD_LIBRARY_PATH. This is what I use. PATH=$PATH:$HOME/bin:.:/bin:/usr/bin:/usr/bin/X11:/usr/local/bin:/usr/ccs/bin:/usr/local/ubin:/usr/zenez/bin:/etc: export PATH LD_LIBRARY_PATH=/usr/lib:/lib:/usr/local/lib:/usr/ccs/lib:/usr/local/mysql/lib/mysql:/usr/local/BerkeleyDB.3.2/lib LIBPATH=/usr/lib:/lib:/usr/local/lib:/usr/ccs/lib: MANPATH=scohelp:/usr/man:/usr/local1/man:/usr/local/man: export LD_LIBRARY_PATH LIBPATH MANPATH Good Luck, -- Boyd Gerber [EMAIL PROTECTED] ZENEZ 3748 Valley Forge Road, Magna Utah 84044 Office 801-250-0795 FAX 801-250-7975 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
sub queries
Hi all, Is there any kind of schedule that says when the next MySQL version will be available? I'd like to utilize MySQL here, but I can't really start to seriously work on it until sub-queries are possible. Thanks! Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: CHMOD CHOWN broke MySQL operations
GATOR-root wrote: Description: We had an NFS incident and used CHMOD and CHOWN to repair it. Shortly there after, we noticed that our MySql under WebRT did not work. We presume that we corrupted the ownership and permissions of files and programs within MySQL. How-To-Repeat: use command CHOWN and CHMOD in a global way Fix: We expected to find a script that would repair this sort of thing. Alternatively, we expected "make fix_perms" or similar. Either would read the current environment and ferret out all of the files and folders, settings ownership and permissions appropriately. They could also report what they found in a way that instructs the operator about how things ought to be configured. We expected to find something about this in the 500+ page PDF manual but we did not. This is more of a unix administration issue than a myslq bug, isn't it? The user mysql is running under must have permission to read write (and list for directories under the datadir.. Simple as that. what could a script do for you that chmod and chown can't? There is no variation on a per table or per file basis, all database user permisions are handled internally. if your mysql user is 'mysql' and you don't want any body but the database messing with the files you can do chown -R mysql datadir chgrp -R root datadir chmod 770 `find datadir -type d` chmod 660 `find datadir -type f` This assumes you dont' have permission problems on any of your mysql executeables, and that you didn't mess up the permissions on the socket file or anything but the datafiles. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fw: SQL HELP
select *,DATE_FORMAT(datecolumn,'%M %D %Y'); On Tue, 16 Jan 2001, Mike Podlesny wrote: Thanks for your help but that unfortunately doesn't answer the question, unless I am looking at it wrong. I want the sql statement to read something to the affect: SELECT * FROM Table * is about 40 fields, which I do not want to type all of them out so do i do the following? SELECT DATE_FORMAT(*,'%M %D %Y') - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to configure MySQL for Unix
Hello, We have loaded MySQL on an Apache Linux machine, I have recently tried to connect and am getting the following error: C:\mysql\binmysql -hdaffy -uroot -p Enter password: ERROR 1130: Host 'workstation01.fenzer' is not allowed to connect to this MySQL server Any ideas what we need to do? Thanks, Karl - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL HELP
"j.urban" writes: select field1,field2,DATE_FORMAT(datefield,"%M %d, %Y"),field4,fieldn from table; He didn't want to have to explicitly list all 40 other fields, though. Can't he do something like SELECT *.DATE_FORMAT(datefield, "%M %d, %Y") FROM table; ? That gives him one extra field, and he can just ignore the first datefield. --Cindy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ORDER BY command
Hmmm, you seem to have things a little backwards as ASCENDING should be the default order. However, as per the manual, the following will do it SELECT * FROM tbl_name ORDER BY col_name ASC To sort in the opposite order SELECT * FROM tbl_name ORDER BY col_name DESC Regards, Greg -Original Message- From: Robert [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 17 January 2001 7:10 To: [EMAIL PROTECTED] Subject: ORDER BY command Hello. I am trying to get the results from a query to be ORDERED by ASCENDING instead of the default DESCENDING. Is this possible, and if so how? Robert - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
SELECT WHERE fieldtype
Is there a way to SELECT FROM table WHERE field_type IS (NOT) 'something'. For example, 'something' could be TIMESTAMP, INT, FLOAT, AUTO_INCREMENT, etc...I looked through the manual and archives to no avail. Regards, Brian Kaney - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Char vs. Integer indexes for memory based databases
From: "Yury V. Bukhman" [EMAIL PROTECTED] Organization: Danforth Plant Science Center Date: Tue, 16 Jan 2001 16:49:09 -0800 To: Anthony Cooke [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Char comparisons vs. Integer. Do you mean, putting primary entry identifiers of all 4 databases into each table instead of using the cross-reference tables? That won't work because in general there is a many-to-many relationship between entries in my databases. For many-to-many relationships, one has to have the cross-reference tables. Hi, Multiplying the keys by cross mixing them in every table in every database is not what I had in mind. From what what I understood you would pull mostly from the attributes or dimensions within one collection based on a key on the main "entries". Therefore I believe that keying within a database is a correct approach. I do not doubt the relationships and constraints have been well thought out on your end and cross reference tables are necessary. I have but a limited view of the situation. IMHO The benefit of having the ID key as an integer is the reduced space required to store it with regards to a char equivalent. This of course goes for both the data and index files. If all the database is to be stored in memory then space must be a premium and repeating the char value of the key for each record in every table seemed expensive. Saludos, Anthony Cooke - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
select from HEAP table failing with error 124
Hi! "David" == David Mechner [EMAIL PROTECTED] writes: David Hi, David My license number is 7697. I don't know what the expiration date is. I'm running 3.23.28-gamma msqld-opt under w2k. David I'm trying to use a HEAP table to speed up data access, but every select I do which references an indexed column gives me: David ERROR 1030: Got error 124 from table handler cut I have now been able to reproduce this. It looks like this is a windows only bug. This will be fixed in 3.23.31, which will be released shortly. 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: How to configure MySQL for Unix
"Karl J. Stubsjoen" wrote: Hello, We have loaded MySQL on an Apache Linux machine, I have recently tried to connect and am getting the following error: C:\mysql\binmysql -hdaffy -uroot -p Enter password: ERROR 1130: Host 'workstation01.fenzer' is not allowed to connect to this MySQL server Any ideas what we need to do? Thanks, Karl - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php In your subject your have "How to configure mysql for unix" it seems that your asking a windows question. I wished i new, I would be happy to help you out. but i run mysql on linux. Today I received a new software that will help you understand mysql . hope that you find your answer. Luis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ORDER BY command
On Tue, Jan 16, 2001 at 02:40:22PM -0600, Robert wrote: Hello. I am trying to get the results from a query to be ORDERED by ASCENDING instead of the default DESCENDING. Is this possible, and if so how? I mis-wrote in my reply (which hasn't come thru the list yet). You can use "ASC" but now "ASCENDING". Sorry for any confusion. Must have some other database syntax in my head. See http://www.mysql.com/doc/S/E/SELECT.html for details. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
nested Select's WHEN?
What future version of MySQL will have nested SELECTs in the WHERE clause? [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: SELECT WHERE fieldtype
You have to select a certain row, there is no way to say all rows that are NOT an int. At 04:33 PM 1/16/2001 -0500, Brian Kaney wrote: Is there a way to SELECT FROM table WHERE field_type IS (NOT) 'something'. For example, 'something' could be TIMESTAMP, INT, FLOAT, AUTO_INCREMENT, etc...I looked through the manual and archives to no avail. - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] "Always bear in mind that your own resolution to success is more important than any other one thing." - Abraham Lincoln - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Question on password
I have a simpel questions, I forgot the password to mysql server. How do i change it ? THank you Luis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 join problem.
I'm using mysql 3.23 on red hat 6.1 I want to select * from tablea and tableb where columna in tablea is the same as columnb in tableb, but columna1 in tablea DOESN'T appear in columnb in tableb. I tried select a.* from tablea as a,tableb as b where a.cid b.uid limit 30; it gave me the first line of tablea 30 times and the cid of that table EXISTS in tableb. Please help Tomer Grassyani. Internet Driver. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: sub queries
You can get around subqueries by using JOIN's. mySQL may not have all the bells and whistles that some other db applications may have, but more often than not, there is a way to get around it. Paul DuBois covers this in his mySQL book very well. -Original Message- From: Mark Marshall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 1:00 PM To: [EMAIL PROTECTED] Subject: sub queries Hi all, Is there any kind of schedule that says when the next MySQL version will be available? I'd like to utilize MySQL here, but I can't really start to seriously work on it until sub-queries are possible. Thanks! Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: date_format
Try the manual contents, linked from the documentation page http://www.mysql.com/documentation/mysql/bychapter OK. I went to the documentation at www.mysql.com and typed in DATE_FORMAT in the search box, hopefully find a list of the %M's, etc rules that may be used (I'd like December to become Dec, etc). No dice. Randomly looking through sections that came up under "DATE" search didn't yield any other info on DATE_FORMAT. 20 minutes later, I surrender. Where would I find out the info on DATE_FORMAT I'm looking for? --Cindy -- [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
Trouble With MySQL Auto-Increment
Hello All,
I have been using mysql-3.23.29a-gamma-dec-osf4.0f-alphaev6
running on a machine running Digital UNIX V4.0F. Since upgrading the
database from 3.22 to 3.23, auto-increment fields have been acting
strangely.
A brief description of the table looks like:
++---+--+-+++-+
| Field | Type | Null | Key |Default | Extra
++---+--+-+++-+
| scientist_pk | mediumint(8) unsigned | | PRI | NULL | auto_increment
.
.
.
At the moment, the largest scientist_pk in the database is 254:
mysql select login,passwd,scientist_pk from users order by scientist_pk desc limit 1;
+--+--+--+
| login| passwd | scientist_pk |
+--+--+--+
| jimbo| 18ac6f1d2a33923d | 254 |
However, if I do an insert, the next scientist_pk should be 255, but is
instead BIG (i.e. 65548).
mysql INSERT INTO users (login,passwd) VALUES ("fred" , PASSWORD("bob"));
mysql select login,passwd,scientist_pk from users order by scientist_pk desc limit 1;
+--+--+--+
| login| passwd | scientist_pk |
+--+--+--+
| fred | 7d67547927a4589e |65548 |
I don't know if this helps, but if I insert one more time:
mysql select login,passwd,scientist_pk from users order by scientist_pk desc limit 10;
+--+--+--+
| login| passwd | scientist_pk |
+--+--+--+
| fred | 7d67547927a4589e |65549 |
| fred | 7d67547927a4589e |65548 |
Strange, huh? It just seems to like jumping to 65548, which makes zippo
sense since the unsigned range is 0 to 16777215 for a mediumint.
Has anyone seen this before and know how to fix it?!
Thanks much,
Parag M
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Why does query hang? [was: Why does 1st query take so long?
On Tue, 16 Jan 2001, Jeremy D. Zawodny wrote: On Tue, Jan 16, 2001 at 08:21:19PM +, John Stumbles wrote: I can't readily reproduce the first-time big difference scenario. OK, I can now: I have a table - MAC_connections:Data records:6689 +--+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+---+ | MAC | char(12) | | PRI | | | | deviceID | int(10) unsigned | YES | | NULL| | | ifIndex | int(10) unsigned | YES | | NULL| | | nMACs| int(10) unsigned | YES | | NULL| | | mtime| timestamp(14)| YES | | NULL| | +--+--+--+-+-+---+ SELECT * from MAC_connections or even SELECT count(*) from MAC_connections hangs! (it's been sitting there for the last 10 minutes and hasn't produced anything!) I guess it was working OK a few hours ago as I was working on a query involving a LEFT JOIN to this table: suddently it stopped working and (after hours of hair-tearing and head-banging :-) I eventually got right back to simple queries like the one above and found where the problem was. I can get data from other tables OK. isamchk -e MAC_connections doesn't complain: Checking ISAM file: MAC_connections Data records:6689 Deleted blocks: 0 - check file-size - check delete-chain - check index reference - check records and index references What's going on? Any ideas? show status shows: +--++ | Variable_name| Value | +--++ | Aborted_clients | 79 | | Aborted_connects | 3 | | Created_tmp_tables | 289| | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delayed_errors | 0 | | Flush_commands | 1 | | Handler_delete | 56663884 | | Handler_read_first | 199| | Handler_read_key | 645684988 | | Handler_read_next| 581963979 | | Handler_read_rnd | 624846288 | | Handler_update | 321370818 | | Handler_write| 287600901 | | Key_blocks_used | 7822 | | Key_read_requests| 1654937380 | | Key_reads| 157365 | | Key_write_requests | 255616015 | | Key_writes | 137012352 | | Max_used_connections | 31 | | Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 | | Open_tables | 118| | Open_files | 101| | Open_streams | 0 | | Opened_tables| 1302 | | Questions| 540752383 | | Running_threads | 32 | | Slow_queries | 229871 | | Uptime | 7891238| +--++ show variables: ++-+ | Variable_name | Value | ++-+ | back_log | 5 | | connect_timeout| 5 | | basedir| /opt/local/ | | datadir| /DATA/mySQLdata/| | delayed_insert_limit | 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000| | join_buffer| 131072 | | flush_time | 0 | | key_buffer | 8388600 | | language | /opt/local/share/mysql/english/ | | log| OFF | | log_update | OFF | | long_query_time| 10 | | low_priority_updates | OFF | | max_allowed_packet | 1048576 | | max_connections| 100 | | max_connect_errors | 10 | | max_delayed_insert_threads | 20 | | max_join_size | 4294967295 | | max_sort_length| 1024| | max_write_lock_count | 4294967295 | | net_buffer_length | 16384 | | pid_file | /usr/local/var/mysqld.pid | | port | 3306| | protocol_version | 10 | | record_buffer | 131072
Re: Why does query hang? [was: Why does 1st query take so long?
what does a 'show processlist' reveal? On 17 Jan 2001 00:08:23 +, John Stumbles wrote: On Tue, 16 Jan 2001, Jeremy D. Zawodny wrote: On Tue, Jan 16, 2001 at 08:21:19PM +, John Stumbles wrote: I can't readily reproduce the first-time big difference scenario. OK, I can now: I have a table - MAC_connections: Data records:6689 +--+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+---+ | MAC | char(12) | | PRI | | | | deviceID | int(10) unsigned | YES | | NULL| | | ifIndex | int(10) unsigned | YES | | NULL| | | nMACs| int(10) unsigned | YES | | NULL| | | mtime| timestamp(14)| YES | | NULL| | +--+--+--+-+-+---+ SELECT * from MAC_connections or even SELECT count(*) from MAC_connections hangs! (it's been sitting there for the last 10 minutes and hasn't produced anything!) I guess it was working OK a few hours ago as I was working on a query involving a LEFT JOIN to this table: suddently it stopped working and (after hours of hair-tearing and head-banging :-) I eventually got right back to simple queries like the one above and found where the problem was. I can get data from other tables OK. isamchk -e MAC_connections doesn't complain: Checking ISAM file: MAC_connections Data records:6689 Deleted blocks: 0 - check file-size - check delete-chain - check index reference - check records and index references What's going on? Any ideas? show status shows: +--++ | Variable_name| Value | +--++ | Aborted_clients | 79 | | Aborted_connects | 3 | | Created_tmp_tables | 289| | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delayed_errors | 0 | | Flush_commands | 1 | | Handler_delete | 56663884 | | Handler_read_first | 199| | Handler_read_key | 645684988 | | Handler_read_next| 581963979 | | Handler_read_rnd | 624846288 | | Handler_update | 321370818 | | Handler_write| 287600901 | | Key_blocks_used | 7822 | | Key_read_requests| 1654937380 | | Key_reads| 157365 | | Key_write_requests | 255616015 | | Key_writes | 137012352 | | Max_used_connections | 31 | | Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 | | Open_tables | 118| | Open_files | 101| | Open_streams | 0 | | Opened_tables| 1302 | | Questions| 540752383 | | Running_threads | 32 | | Slow_queries | 229871 | | Uptime | 7891238| +--++ show variables: ++-+ | Variable_name | Value | ++-+ | back_log | 5 | | connect_timeout| 5 | | basedir| /opt/local/ | | datadir| /DATA/mySQLdata/| | delayed_insert_limit | 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000| | join_buffer| 131072 | | flush_time | 0 | | key_buffer | 8388600 | | language | /opt/local/share/mysql/english/ | | log| OFF | | log_update | OFF | | long_query_time| 10 | | low_priority_updates | OFF | | max_allowed_packet | 1048576 | | max_connections| 100 | | max_connect_errors | 10 | | max_delayed_insert_threads | 20 | | max_join_size | 4294967295 | | max_sort_length| 1024| | max_write_lock_count | 4294967295 | | net_buffer_length | 16384 | | pid_file |
Re: Crashing MySQL on FreeBSD4.2 with Apache/php4
There were some very recent fixed to FreeBSD-stable surrounding C++ and threads, that directly mysql, I'd strongly recommend updating freebsd. On Mon, 15 Jan 2001, Nicolai Gylling wrote: Hi I'm currently running a FreeBSD4.2-Stable server with Apache1.3.14/PHP4.0.4pl1 and MySQL 3.23.27-Beta. The problem is that MySQL is crashing constantly, sometimes several times each minute. I've been through all the "What to do if mysql keeps crashing" steps in the MySQL-documentation, but nothing helped. My research has come up with suggestions regarding the threads in FreeBSD4.2 and sessionhandling in PHP. Is there anyone who has had similar problems, or might know what to do? Nicolai Gylling System Administrator | [EMAIL PROTECTED] | http://www.neoideo.com Neo Ideo A/S | Galionsvej, Bygning 156 | DK-1437 Copenhagen K. Phone: +45 7020 2414 | Direct: +45 7730 4300 | Telefax: +45 7020 2415 | Mobile: +45 2098 5543 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Multithreaded mysql client dumps core
I'm using mysql-3.23.29-gamma on Solaris 2.6 sparc. I have a multithreaded mysql client that is linked to libmysqlclient_r. On startup, it dumps core after mysql_init() is called. More specifically, the fault is during the getservbyname() call in mysql_once_init(), which is part of libmysql.c. The core dump only happens if /etc/nsswitch.conf specifies: services: files nis and /etc/inet/services does not contain: mysql 3306/tcp It happens during the search of the NIS services map for the mysql service. I can't tell if it's due to a bug in the /usr/lib/nss_nis.so.1 library or something wrong with the way that the function is invoked. If anyone else is running into this problem, the workaround is either to fix /etc/nsswitch.conf or /etc/inet/services. Has anyone seen this problem? I haven't seen the mysql service name documented anywhere. Should it be? -- -Gary Mills--Unix Support--U of M Academic Computing and Networking- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Query Not working got me stumped
The variables are set using php and are all set correctly. how do I do the where and order by statement SELECT * FROM $table_name LIMIT $indst,$inded where sec_id = $sec order by PG_date DESC
Re: Query Not working got me stumped
Thanks That worked - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
nested query alternative?
Hi, I just realized that mysql does not have nested queries, and I need to do something like this: update table1 set A="blah" where B=(select B from table1, table2 where table1.B=table2.B) Is it possible? Thanks, Jeff Pavel [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
Foreign Key Info error in manual
I was reading the information on foreign keys in the manual http://www.mysql.com/doc/e/x/example-Foreign_keys.html and noticed that there is no mention of locking the tables. It seems to me that using the example verbatim could lead to loss of referencial integrity if INSERTS did not occur in sequence (i.e. another person was inserted before shirts). Using "LAST_INSERT_ID()" can only be guranteed to work if the tables are locked. Am I correct or did I miss something? ___ Scott A. Gerhardt P.Geo. Gerhardt Information Technologies [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
off-topic (was: Re: Testing for WAP/WML or HTML browser?)
Hi. Sorry, but I cannot see how this relates to MySQL. Please ask in the appropriate forum. Here, it is off-topic. Try http://www.php4.org Bye, Benjamin. On Tue, Jan 16, 2001 at 11:53:00AM -0300, [EMAIL PROTECTED] wrote: Using PHP+Apache+Linux, how can I find out from the browser whether it is a WAP device or a PC? The solution I've tried so far doesn't know about all the possible browsers, so it won't handle any new browsers properly, except the default, which is HTML. Ken Whitmore E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: putting an mark in the subject.
The from field is the original sender, not the list. Try to: and cc: jason What's wrong with creating a filter? Most e-mail programs of today allow for filters!! Just create a filter based on the from field where it equals [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: Foreign Key Info error in manual
Thanks for your responses Jeremy, I'm just trying to clarify any misunderstandings I may have. So, as far as the example goes, the relationships between shirts and people is maintained by using the LAST_INSERT_ID (in one connection) but referential integrity is not maintained in terms of foriegn keys for subsequent deletes and updates since MySQL does not support them. Thus all subsequent deletes and updates etc. must use explicit joins or reference by primary key. ___ Scott A. Gerhardt P.Geo. Gerhardt Information Technologies [EMAIL PROTECTED] ___ So referential integrity is maintained but AUTO_INCREMENT values may not be chronological? Nope. Referential integrity is not maintained. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: putting an mark in the subject.
Sorry, my mistake. Yes, you're right, the to: cc: - Original Message - From: "Jason Brooke" [EMAIL PROTECTED] To: "Rolf Hopkins" [EMAIL PROTECTED]; "John en Daphne Kuiper" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 17, 2001 9:50 Subject: Re: putting an mark in the subject. The from field is the original sender, not the list. Try to: and cc: jason What's wrong with creating a filter? Most e-mail programs of today allow for filters!! Just create a filter based on the from field where it equals [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
linking ms access to mysql db
question: Can i link to a mysql database using ms access 97 or ms access 2000 using an odbc driver. i recall doing it before, but can't seem to get it work again. i would appreciate any help you could give me on this subject. thanks charlie scott - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Foreign Key Info error in manual
On Tue, Jan 16, 2001 at 08:00:09PM -0600, Scott Gerhardt wrote: Thanks for your responses Jeremy, I'm just trying to clarify any misunderstandings I may have. So, as far as the example goes, the relationships between shirts and people is maintained by using the LAST_INSERT_ID (in one connection) but referential integrity is not maintained in terms of foriegn keys for subsequent deletes and updates since MySQL does not support them Exactly. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 2 character sets at the same time
Even if you could, there is no need to set up 2 different charsets. Just use English. When entering Japanese, just ensure you have an OS/program/web browser that can display Japanese correctly. Sorting should be fine. Also, have a for JIS in the manual, if you haven't already done so. - Original Message - From: "WCBaker" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 16, 2001 19:22 Subject: 2 character sets at the same time Hi! I would like to be able to use BOTH Japanese characters and English in mySQL. I am wondering if this is possible. I know that one can use the Japanese charset, and of course one can set the English charset, but I require BOTH Japanese and English. . . Is there any way to do this? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error Code?
Hi, The problem you ran into is because you didn't start mysqld the right way! There are 3 options on how to start mysqld! a) cd mysql-distribution-directory ./bin/safe_mysqld b) Make a symlink from the mysql distribution to /usr/local/mysql so that you can start safe_mysqld from anywhere on the system c) provide full paths to safe_mysqld and mysqld. Regards Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: "Marcus Ouimet" [EMAIL PROTECTED] To: "MySQL" [EMAIL PROTECTED] Sent: Tuesday, January 16, 2001 8:25 PM Subject: Error Code? MySQL was working fine but now it seems to be giving me an error: user:/usr/local/apache/bin# mysql -uusername -pmypassword Can't read dir of '.' (Errcode: 2) or user:/usr/local/apache/bin# mysqladmin -uusername -pmypassword create catalog mysqladmin: create of 'catalog' failed error: 'Can't create database 'catalog'. (errno: 2)' Any ideas? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: newbie question on replication and load balancing...
On Tue, Jan 16, 2001 at 03:41:14PM +0800, Ganen Ganeswaran wrote: I'm a relative newbie in mySQL. I have 10 mySQL databases. At the moment I'm only using 1 of the databases. I was wondering if it's possible (and how) to setup some sort of replication/load balancing between all 10 dbs. Basically I want the information in one db replicated across the other 9. I also read some documentation that said that there can only be 100 simultaneous connections at any one time to a single databse, so I would like some sort of load balancing across these 10dbs (would I need to implement this myself, or is this inherent with mySQL?). Thanks in advance... Oh, let's see... (1) Do you have 10 databases or 10 database servers? I'm a bit unclear based on your description? (2) The limit of 100 clients per server is default which can be changed. Some folks have had many, many more than that on a reasonably configured server. You can use MySQL replication to do some load balancing. You can have a master database server (db0) and then configured db[1-9] as slaves which get all their updates from db0. Then code your software to send all updates to db0 and the bulk of your read-only queries to one of the slaves. Which slave? It's up to you. Does that help a bit? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: keeping MySQL on a SEPARATE SERVER - lag time?
On Tue, Jan 16, 2001 at 01:43:26AM -0800, Derek Sivers wrote: Has anyone done testing to show the difference between: #1 - having MySQL on the same server as Apache/PHP vs. #2 - having MySQL on its own dedicated computer, TCP/IP connected to the main Apache box NOTE: We use lots of little MySQL lookups in our PHP scripts. Nothing that intensive. But our site is getting pretty MySQL-intensive and often MySQL takes up 30% of the CPU power. The first option simply won't scale beyond a certain point (assuming limited hardware resources). You *could* go get an E-1 from Sun and spend a quarter of a million dollars, but you can probably get by with splitting things up a bit. Assuming your machines are "close" to each other (network-wise), you probably won't see much of a difference. All of my hard-core database stuff is done over TCP/IP to a dedicated server and the performance is quite good (they're on 100Mbit switched ethernet). But your mileage may vary. You'd need to test that. We're in the midst of some testing involving a replicated database running on the same machine as some hard-core number crunching where the latency of fetching the data is fairly important. So far things look good, but we really haven't stressed it yet. I'm anxious to see how our testing turns out. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication: Please help!!
On Wed, Jan 17, 2001 at 02:15:26PM +0800, Victor Alamo wrote: Hi guys, I am looking some tutorial step by step using replication. I had a look the documentation about replication but I am not so clear where to find some of files and some other points. I've suffered thru the replication setup a few times recently. I am (tonight) attempting to update the MySQL manual to be more clear on some of the lessons I learned along the way. (I finally found a bit of the spare time I'd been hoping for...) If the MySQL team approves of the changes, they should get into the manual. If not, I'll fix what they don't like and try again. I can send you a copy of what I come up with if you'd like... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: What does this mean ?
This patch will make it into 4.0.5, I believe. 4.0.4pl1 fixes only two bugs (one security issue, and one that make the PDF plugin work again). My patches could have side effects, since it will run code that has never been run before (like actually closing those persistent connections). They are in CVS. If you are using Apache (most of us are with PHP), note that persistent connections are per process, not per machine. Mod_ssl can use an Apache extension to keep shared memory across processes, but PHP does not. Read the docs (or the PHP list) to find out more. Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e That is what I suspected. I suffer the same. The problem is buggy PHP persistent connection code. The "almost good" solution was presented to PHP people by Steven Roussey (http://marc.theaimsgroup.com/?l=php-devm=97562841130973w=2) and (http://marc.theaimsgroup.com/?l=php-devm=97858730928909w=2) and according to Andi Gutmans (http://marc.theaimsgroup.com/?l=php-devm=97858932431876w=2) the patch was committed to PHP CVS. However the patch is absent even from PHP 4.0.4pl1 (its zend_list.c is dated 2000-10-20). You might try to patch your PHP by yourself. Or try the latest snapshot from http://snaps.php.net (though I don't know if the patch is there). Sincerely speaking I don't know why Steven's patches haven't been incorporated into PHP 4.0.4pl1. Maybe Andi (Cc:ed) could explain this? Maciek -Original Message- From: Denis Gasparin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 8:50 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: What does this mean ? I use php 4.0.3 with persistent connections. MySQL is installed on Linux RedHat 7.0. The problem is that the Mysql exists and I don't know exactly what appends to the php process Denis At 19.21 15/01/01, Maciek Uhlig wrote: Could you describe what exactly software connects to MySQL in your case? Maciek -Original Message- From: Denis Gasparin [mailto:[EMAIL PROTECTED]] Sent: Monday, January 15, 2001 6:00 PM To: [EMAIL PROTECTED] Subject: What does this mean ? From when I installed the mysql 3.23.30gamma I have mysql reporting these warnings: 10115 17:51:22 Aborted connection 2886 to db: 'db_name' user: 'user' host: `www.host' (Got an error reading communication packets) 010115 17:51:36 Aborted connection 3754 to db: 'db_name' user: 'user' host: `www.host' (Got an error reading communication packets) We have 700-800 contemporary connections to mysql and these warnings are given periodically every 5-10 minutes... Why does Mysql generate these logs? Denis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql_pconnect still broken (was: RE: What does this mean ?)
OK. Look at a quick report. I've just installed php4-200101152345. It runs with mysql-3.23.27-beta. Apache 1.3.12, Solaris 2.6 (local host) and 2.4 (remote connection). What I can see is: the offending messages didn't vanish at all (both hosts are involved): 010116 20:52:30 Aborted connection 36021 to db: '***' user: '***' host: `***' (Got an error reading communication packets) So, I think it's not fixed yet. Steven, you wrote about 99,8. I suppose every Apache process here makes this error while ending. I just see it. Steven, thank you for your efforts. Hope you can fix even that. Please let me know about patches: I'll happily test them. I'm not able to fix it by myself, but I'd like at least be helpful. Maciek [stuff deleted] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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-DEV] RE: mysql_pconnect still broken (was: RE: What does this mean ?)
Yep, you're right. Fixed.
Thanks,
Zeev
At 23:24 16/1/2001, Steven Roussey wrote:
OK. Look at a quick report. I've just installed php4-200101152345. It runs
with mysql-3.23.27-beta. Apache 1.3.12, Solaris 2.6 (local host) and 2.4
(remote connection).
What I can see is: the offending messages didn't vanish at all (both hosts
are involved):
So, I think it's not fixed yet. Steven, you wrote about 99,8. I suppose
every Apache process here makes this error while ending. I just see it.
:)
Andi, I hope you are reading this.
I looked at the CVS, and my patch was not properly applied. Andi has it
looking through the non-persistant destructors, rather than the persistent
ones (meaning that plist_entry_destructor is identical to
list_entry_destructor).
In file zend_list.c replace the plist_entry_destructor definition with:
void plist_entry_destructor(void *ptr)
{
zend_rsrc_list_entry *le = (zend_rsrc_list_entry *) ptr;
zend_rsrc_list_dtors_entry *ld;
if (zend_hash_index_find(list_destructors, le-type,(void **)
ld)==SUCCESS) {
switch (ld-type) {
case ZEND_RESOURCE_LIST_TYPE_STD:
if (ld-plist_dtor) {
(ld-plist_dtor)(le-ptr);
}
break;
case ZEND_RESOURCE_LIST_TYPE_EX:
if (ld-plist_dtor_ex) {
ld-plist_dtor_ex(le);
}
break;
EMPTY_SWITCH_DEFAULT_CASE()
}
} else {
zend_error(E_WARNING,"Unknown persistent list entry type in
module shutdown (%d)",le-type);
}
}
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
--
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
Zeev Suraski [EMAIL PROTECTED]
CTO co-founder, Zend Technologies Ltd. http://www.zend.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: [PHP] Database Connections - permanent or something else?
PHP handles persistent connections by leaving them open for some other identical connection request. The next request will check for a free connection. see http://www.php.net/manual/en/features.persistent-connections.php In other words, you don't need to worry about when they are closed php will handle that for you mOrP wrote: There's one thing, that I don't understand about permanent connections. When will they be closed? I could use a logout-page, but there is no garanty for the use of it. Any explanation would be appreciated. mOrP -Original Message- From: Ignacio Vazquez-Abrams [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 6:17 PM To: Sam Cc: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: Re: [PHP] Database Connections - permanent or something else? On Tue, 16 Jan 2001, Sam wrote: Hi, I have several web pages that are built with php and mySQL. I use a new connection for each script. Should I be using a permanent connection? Or is there a better way around this? Regards, Sam Rose Persistent connections are more efficient in that they don't need to open the connection each time. Unless you have an overwhelming need to limit concurrent connections to your MySQL server, you should probably be using persistent connections. -- Ignacio Vazquez-Abrams [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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] Database Connections - permanent or something else?
On Tue, 16 Jan 2001, Sam wrote: Hi, I have several web pages that are built with php and mySQL. I use a new connection for each script. Should I be using a permanent connection? Or is there a better way around this? Regards, Sam Rose Persistent connections are more efficient in that they don't need to open the connection each time. Unless you have an overwhelming need to limit concurrent connections to your MySQL server, you should probably be using persistent connections. -- Ignacio Vazquez-Abrams [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
Database Connections - permanent or something else?
Hi, I have several web pages that are built with php and mySQL. I use a new connection for each script. Should I be using a permanent connection? Or is there a better way around this? Regards, Sam Rose - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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] Database Connections - permanent or something else?
There's one thing, that I don't understand about permanent connections. When will they be closed? I could use a logout-page, but there is no garanty for the use of it. Any explanation would be appreciated. mOrP -Original Message- From: Ignacio Vazquez-Abrams [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 6:17 PM To: Sam Cc: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: Re: [PHP] Database Connections - permanent or something else? On Tue, 16 Jan 2001, Sam wrote: Hi, I have several web pages that are built with php and mySQL. I use a new connection for each script. Should I be using a permanent connection? Or is there a better way around this? Regards, Sam Rose Persistent connections are more efficient in that they don't need to open the connection each time. Unless you have an overwhelming need to limit concurrent connections to your MySQL server, you should probably be using persistent connections. -- Ignacio Vazquez-Abrams [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
