AW: Which Hardware do I need ?
Hi. Opens: ~4000 - 2 Queries p/s avg: 10 till 60 Thx for helping Greetz Daniel -Ursprüngliche Nachricht- Von: Egor Egorov [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 4. Februar 2002 18:38 An: [EMAIL PROTECTED] Betreff: Which Hardware do I need ? Daniel, Monday, February 04, 2002, 12:55:57 PM, you wrote: DB Does somebody know which server hardware I have DB to buy to realize my following problem ? DB I have 3 tables. They are all connected to each other DB with some queries. DB 1st table has momentary 10.000 and should be upgraded to DB 50.000 records. DB 2nd table has 120.000 records at moment and should be DB upgraded to 700.000 at time. DB 3rd table has 200.000 records and should be upgraded to DB 1.500.000 records. DB Does somebody have experience with such a huge amount of DB records in mySQL ? DB We have momentary a DUAL 1 GHz Server with 1 GB Ram, but DB he gets a load of 40 and restarts after some time. Tell us about the number of connections open and number of average simultaneous queries. Then we wil try to help. DB - Daniel Backhausen -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: Which Hardware do I need ?
Hi. Our queries seem well optimized, maybe there are some slow queries in there but sometimes you have no other choice and we are using indexes. Our Key Buffer size is about 16MB (standard). Thx for helping ... Greetz - Daniel -Ursprungliche Nachricht- Von: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 4. Februar 2002 23:53 An: Daniel Backhausen Cc: mySQL Mailingliste Betreff: Re: Which Hardware do I need ? On Mon, Feb 04, 2002 at 11:55:57AM +0100, Daniel Backhausen wrote: Hi. Does somebody know which server hardware I have to buy to realize my following problem ? I have 3 tables. They are all connected to each other with some queries. 1st table has momentary 10.000 and should be upgraded to 50.000 records. 2nd table has 120.000 records at moment and should be upgraded to 700.000 at time. 3rd table has 200.000 records and should be upgraded to 1.500.000 records. Does somebody have experience with such a huge amount of records in mySQL ? That's not huge. :-) We've got one table with over 267 million rows in it and it grows daily. We have momentary a DUAL 1 GHz Server with 1 GB Ram, but he gets a load of 40 and restarts after some time. That should be more than sufficient. Are your queries well optimized and using indexes? How large is your key buffer? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 0 days, processed 22,638,026 queries (388/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql and views
MYSQL sql,query is anybody know when suppost to be support to views ? |\_.._/| | o o | (=T=) ^'-^-'^. '. ; .' | | | | | ((_((|))_)) Best Regards from the Cat Noam Cassif([EMAIL PROTECTED]) Raz Systems LTD http://www.raz.co.il - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql and views
MYSQL sql,query is anybody know when suppost to be support to views ? |\_.._/| | o o | (=T=) ^'-^-'^. '. ; .' | | | | | ((_((|))_)) Best Regards from the Cat Noam Cassif([EMAIL PROTECTED]) Raz Systems LTD http://www.raz.co.il - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: BEGIN/COMMIT statements not written to the binary log : may it cause problems with replication ?
Guilhem, this is a known problem and mentioned in the Restrictions section of the InnoDB online manual. It is not the correct way to run SQL statements in the autocommit mode on the slave server, while the master has normal transaction processing on. I have asked Sasha to add COMMIT marks to the binlog, so that people would not see partial transactions on the slave server. I am sending a carbon copy of this message to Sasha. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB .. Description: As I have no test case, only strong presomptions, I sent this to [EMAIL PROTECTED] but got no feedback. I use MySQL-Max 4.0.1 with InnoDB tables with binary logging on. I see that the BEGIN and COMMIT statements that wrap my queries are not written to the binary log. I perfectly understand this if I have one server. But assume I have a master server, and a slave server that replicates the master. Let's say I distribute reads. Let's say I issue the following queries on the master (I use BEGIN and COMMIT for consistency) :BEGIN; UPDATE accounts set sum=sum-100 where num=10; UPDATE accounts set sum=sum+100 where num=12;# I don't work in a bank !!COMMIT; then onlyUPDATE accounts set sum=sum-100 where num=10; UPDATE accounts set sum=sum+100 where num=12; is written to the master's binary log, and then propagates to the slave. Assume that, while it is propagating I issue a reading query on the slave :SELECT sum from accounts where num in(10,12); Then, to my mind, this select might be treated AFTER the first update being processed by the slave, and BEFORE the second update being processed by the slave.Then I'll get not-consistent results. This would not happen if BEGIN and COMMIT had been written to the master's binary log.Am I misunderstanding something ? If this problem really exists, is it to be fixed ?Thanks anyway ! How-To-Repeat: This is not repeatable, it depends on the milliseconds I suppose Fix: Synopsis: BEGIN/COMMIT statements not written to the binary log Submitter-Id: submitter ID Originator: BICHOT Organization: your organization MySQL support: [none] Severity: [non-critical | serious | critical ] Priority: [low | medium | high ] Category: [mysqld]Class: [ sw-bug | doc-bug | change-request | support ] Release: mysql-4.0.1Exectutable: [mysqld-nt] Environment: machine descriptionSystem:Win2000 Compiler: VC++ 6.0Architecture: i586Guilhem BICHOTIPSN/DIR/SG/SI 01 46 54 92 31mailto:[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
Regarding Disk Accesses Main Memory ussage.
Dear members, 1) How can we know the no. of disk accesses main memory used to execute a particular query in mysql ? 2) Is any one familier with mysql source code for windows. Plz help me in this as I desparately need this information at the earliest. Plz reply asap. Thanx in advance.. Pravin Sirupa - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
fatal: libncurses.so.5
Hi, I just installed mysql in my Solaris (Sparc) box, but when I run mysql ( mysqld running ), I get the following err, ld.so.1: bin/mysql: fatal: libncurses.so.5: open failed: No such file or directory Killed Any help will be appreciated! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: AW: Which Hardware do I need ?
Hi, A 16MB key buffer seems very small; this is OK for a personal workstation with 64/128MB RAM not for a high performance 1GB server. If your queries are using indexes, you should check Key_read_requests and Key_reads values, if your query buffer is efficient, Key_read_requests should be MUCH greater than Key_reads. As an example, here are the values from our main MySQL server: | Key_blocks_used | 186985 | | Key_read_requests| 3214556494 | | Key_reads| 183458 | If you want to optimize Key_buffer parameter, you should evaluate the size of all your indexes (check *.MYI sizes) and use this value as a starting point. Regards -- Joseph Bueno NetClub/Trader.com Daniel Backhausen wrote : Hi. Our queries seem well optimized, maybe there are some slow queries in there but sometimes you have no other choice and we are using indexes. Our Key Buffer size is about 16MB (standard). Thx for helping ... Greetz - Daniel -Ursprungliche Nachricht- Von: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 4. Februar 2002 23:53 An: Daniel Backhausen Cc: mySQL Mailingliste Betreff: Re: Which Hardware do I need ? On Mon, Feb 04, 2002 at 11:55:57AM +0100, Daniel Backhausen wrote: Hi. Does somebody know which server hardware I have to buy to realize my following problem ? I have 3 tables. They are all connected to each other with some queries. 1st table has momentary 10.000 and should be upgraded to 50.000 records. 2nd table has 120.000 records at moment and should be upgraded to 700.000 at time. 3rd table has 200.000 records and should be upgraded to 1.500.000 records. Does somebody have experience with such a huge amount of records in mySQL ? That's not huge. :-) We've got one table with over 267 million rows in it and it grows daily. We have momentary a DUAL 1 GHz Server with 1 GB Ram, but he gets a load of 40 and restarts after some time. That should be more than sufficient. Are your queries well optimized and using indexes? How large is your key buffer? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 0 days, processed 22,638,026 queries (388/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Client/Server problem - AGAIN, sorry!!!
Hi all, I want to connect a MySQL client from Windows NT to SUN Solaris 2.6. How can I do this? I need some services running in the Server (in my case, SUN Solaris). What means the message: Host my_IP is not allowed to connect to this MySQL server ?? Thanks in advance, = --- Marcelo Muzilli Support Analyst Datacom/Access Ericsson Serviços de Telecomunicaçoes Ltda. +55 11 6224-8935 [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Client/Server problem - AGAIN, sorry!!!
06.02.02 11:42:26, Marcelo Muzilli [EMAIL PROTECTED] wrote: Hi all, I want to connect a MySQL client from Windows NT to SUN Solaris 2.6. How can I do this? I need some services running in the Server (in my case, SUN Solaris). What means the message: Host my_IP is not allowed to connect to this MySQL server ?? IMO this looks as if the sun can't resolve the IP number of your win box while trying to connect. I suppose you entered your win box's hostname into the user table? best regards Andreas sql,query,mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
visualizing my queries
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm planning a *very* simple DB to place tips on small biz websites on. I'm having a little trouble conceptualizing how it might work. My schema runs like this: 2 tables content TipId | AuthId | title | keywords | desc | section | text author AuthId | name | email | bio 'section' will be an enum field containing 3 values, the rest is self explanatory. My question is: If I enter a 'tip' and put myself as the author, when /I/ come to write another tip how do I make my query avoid putting another entry in author? I'll be using PHP for the front end. I don't need tecnical help (yet) just a hand seeing how I might plan the code. Many thanks in advance - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8YRHcHpvrrTa6L5oRAhqgAJ4gRJBvjf/bkAWVaP/3rGtNcEvzSgCfe43q eUYlWvn+VzfMQ8RqfjgkiuY= =OwBR -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: visualizing my queries
On Wed, 2002-02-06 at 11:22, Nick Wilson wrote: 2 tables content TipId | AuthId | title | keywords | desc | section | text author AuthId | name | email | bio My question is: If I enter a 'tip' and put myself as the author, when /I/ come to write another tip how do I make my query avoid putting another entry in author? I'll be using PHP for the front end. You can always use INSERT for the content table and REPLACE for the author table. -- Diana Soares (sql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Permissions Problem
Ben, Tuesday, February 05, 2002, 11:42:50 PM, you wrote: BO Hi; BO I get this error when I try to access a database as root: BO mysql use antigo; BO Can't read dir of './antigo/' (Errcode: 13) BO What does this mean and how do I fix it? That means your unix user doesn't have privileges on './antigo/' dir. BO TIA, BO BenO -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql.sock
Cindy, Tuesday, February 05, 2002, 11:58:45 PM, you wrote: C Sorry, I know this is documented somewhere, because I've seen it, C but I can't find it now, nor remember exactly what it said. C When I try to connect to the mysql server (mysql -u root -p table), C I get an error about /tmp/mysql.sock. C I've searched both http://lists.mysql.com/ and C http://www.mysql.com/manual.php using the available search functions, C and leafed through Paul's mysql book and can't find it, which drives C me bats because I KNOW I've seen it somewhere C Anyway, what is the problem here? Do I have to take it down and start C it up again? I'm pretty sure the problem is that the file has been C deleted, probably a cron job, but I can't remember the fix. Tried C touching it to make it exist again, but of course no go. C (And a pointer to the documentation would be welcomed, too...) Is your MySQL server really running? Check your /etc/my.cnf file for line 'socket=...'. Did you use configure option '--with-unix-socket-path=...' or you have installed a binary version? That will be useful to refer to: http://www.mysql.com/doc/P/r/Problems_with_mysql.sock.html and http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html C Thanks, C --Cindy -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem and question
admin, Wednesday, February 06, 2002, 4:40:30 AM, you wrote: a hello, a This is my problem and question: a I installed mysql-3.23.36 when I installed the RedHat7.1, but now I want to install mysql-3.23.47 to the platform and I hope the two versions are both useful. How should I configure the a parameters when I configure? You can find info about it in the manual, look at: http://www.mysql.com/doc/I/n/Installing_many_servers.html and http://www.mysql.com/doc/M/u/Multiple_servers.html a I want mysql supporting the BDB tables as well,is that using '--with-berkeley-db=./bdb' enough? Get some more info about BDB tables here: http://www.mysql.com/doc/B/D/BDB_install.html and http://www.mysql.com/doc/B/D/BDB_start.html a I'm waiting for your replying and thank you for that! a admin a [EMAIL PROTECTED] -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Client/Server problem - AGAIN, sorry!!!
Marcelo, Wednesday, February 06, 2002, 12:42:26 PM, you wrote: MM Hi all, MM I want to connect a MySQL client from Windows NT to SUN Solaris 2.6. MM How can I do this? I need some services running in the Server (in my case, SUN MM Solaris). What means the message: MM Host my_IP is not allowed to connect to this MySQL server ?? It means that you try to connect from other host than specified in table user in mysql db, see at: http://www.mysql.com/doc/A/c/Access_denied.html Check the following links too: http://www.mysql.com/doc/W/i/Windows_and_SSH.html http://www.mysql.com/doc/C/o/Connecting.html MM Thanks in advance, MM Marcelo Muzilli -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql and views
Noam, Wednesday, February 06, 2002, 11:37:13 AM, you wrote: NC MYSQL NC sql,query NC is anybody know when suppost to be support to views ? It will be sopported in MySQL around Version 4.1 See at: http://www.mysql.com/doc/A/N/ANSI_diff_Views.html NC Noam Cassif([EMAIL PROTECTED]) NC Raz Systems LTD -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: visualizing my queries
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Diana Soares declared On Wed, 2002-02-06 at 11:22, Nick Wilson wrote: 2 tables content TipId | AuthId | title | keywords | desc | section | text author AuthId | name | email | bio My question is: If I enter a 'tip' and put myself as the author, when /I/ come to write another tip how do I make my query avoid putting another entry in author? I'll be using PHP for the front end. You can always use INSERT for the content table and REPLACE for the author table. I don't think that would work as it will change the AuthId and effect any other 'tips' I've written. Each author should have one entry in 'author' and as many in 'content' as tips they have written. Am I talking rubbish? - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8YRkMHpvrrTa6L5oRAuIwAKCt3FSi5j7NYOAKvcUujYsKoDFJ3gCffbBS f/vX8OWqQGBa6EzVCdeDq8c= =fZBS -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fulltext problems 4.0.1 part two (fwd)
Hi! Alex == Alex Aulbach [EMAIL PROTECTED] writes: Alex I found out, that the fulltext engine is misbehaving with less than 5 Alex entries. Seems to me, that this is exactly the same case... Alex Perhaps a flush inside the engine or so isn't made with such less entries? Alex The bug is also in 3.23 gamma. Alex Workaround: Enter more rows to fix it. :) Alex I send this bug 1 month ago to the developer who has done the fulltext Alex engine (I just forgot the name and the adresses are in the company - a Alex russian name). Perhaps I should have sent it better to bugs... cut Alex Test case with table can be found at http://logo.nino.ru/fulltextbug.tar.gz Thanks! Sergei, the developer of the MySQL fulltext has been at a conference and should be back working tomorrow. He will take a look at this problem ASAP and come back to you about 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
log count
i have a log file in which i record every visit of my site, although some times a visitant came by the morning and by the night or something alike, so i am trying to create a select command which count the ip every since he came back a hour afther of his last visit, the command is just like this: SELECT id, ip, date_format(data,%d/%m/%Y %r) FROM log WHERE date_format(data,%d/%m/%Y)=05/02/2002 AND ip != 200.19.73.64 GROUP BY ip HAVING count(date_format(data,%d/%m/%Y %H))=2 but its not working well, can anyone help me build a correct select command? thanks advanced. sql,query idéias.ual.. Idéias Pontual Desenvolvimento de Software Ltda. Ricardo Striquer Soares CEO e-business Fone: +55 (41) 322-9373 Cel: +55 (41) 9908-3862 Fax: +55 (41) 223-7865 Mr. Lucro : www.mrlucro.com.br - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Arcserve
Hi guys, Has anyone successfully used MySQL as the backend database for tape/file cataloguing on ArcServe 2000/Brightstor ? I can get Arcserve to work fine with MS SQL (runs for cover) but it wont work with MySQL. To be honest I dont have much indepth knowledge of MySQL, so any help is gratefully appreciated. Cheers, J. ps - The internal database that Arcserve uses is crap! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: visualizing my queries
On Wed, 2002-02-06 at 11:52, Nick Wilson wrote: You can always use INSERT for the content table and REPLACE for the author table. I don't think that would work as it will change the AuthId and effect any other 'tips' I've written. Each author should have one entry in 'author' and as many in 'content' as tips they have written. Am I talking rubbish? No. You're right! Unless you generate your own AuthId (with date, not auto-incremented), i think you will have to do a SELECT in the author table to get his ID /you will need it to insert a new tip in the content table), and then you'll know if the author exists or not. Hope someone gives a better solution! -- Diana Soares (sql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: visualizing my queries
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Diana Soares declared No. You're right! Unless you generate your own AuthId (with date, not auto-incremented), i think you will have to do a SELECT in the author table to get his ID /you will need it to insert a new tip in the content table), and then you'll know if the author exists or not. Hope someone gives a better solution! No, I think you're right, Query the 'author' table first and eiter insert into both or just 'content' using the authors id. Cheers... - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8YSgqHpvrrTa6L5oRArpCAKCtiMCqjzvX/RzyYGHI47FdAU+bywCfVkuV T6+05Nf+cHGRDOtbJB77hfY= =g0fB -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: visualizing my queries
Nick, I don't think ... Am I talking rubbish? An admission and then an invitation??? Boy you must some masochist! You asked a question, it was answered (and there's usually more than one way to skin the proverbial cat); and then you appear to argue. Thinking is not as good as testing: did you test before 'arguing'? RTFM: 6.4.3 INSERT Syntax with a view to the author table handling. - either use the IGNORE facility, or if you want to know if the author already exists 'on file' then do a SELECT first - or if you are interfacing into MySQL from a programming/scripting language, use that facility to observe the INSERT post-fact. No you're not talking (total) rubbish: the structure looks good, and the question was sensible. Do a bit more reading about SQL techniques, and MySQL syntax; get into the habit of trying things out for yourself using a management tool or the MySQL command line, and it'll soon come together in your mind! Recommendation: treat the (possible) addition to the author tbl as one task, and the (required in both cases) addition to the content tbl as a separate task. Regards, =dn * and then Diana Soares declared On Wed, 2002-02-06 at 11:22, Nick Wilson wrote: 2 tables content TipId | AuthId | title | keywords | desc | section | text author AuthId | name | email | bio My question is: If I enter a 'tip' and put myself as the author, when /I/ come to write another tip how do I make my query avoid putting another entry in author? I'll be using PHP for the front end. You can always use INSERT for the content table and REPLACE for the author table. I don't think that would work as it will change the AuthId and effect any other 'tips' I've written. Each author should have one entry in 'author' and as many in 'content' as tips they have written. Am I talking rubbish? - -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Memory limit issue with 64 bit mysql.3.23.46
Franklin, Kevin writes: We are running an extremely large instance of mysql version 3.23.46 on Solaris 2.8. We are attempting to use a software version compiled 64 bit and have been experiencing memory related server crashes. The behavior suggests that we are still unable to use more than 4G of memory. If the server is started with the following settings: key_buffer=4608M max_allowed_packet=1M table_cache=1024 record_buffer=1M sort_buffer=1M thread_cache=12 thread_concurrency=12 myisam_sort_buffer_size=512M We observe the following symptoms / problems: (1) A mysqladmin variables call shows that the key_buffer is set to be 1 G, not 4.5G. (2) Under any sort of database load, the server crashes with the following error output: mysql got signal 10; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=4831834112 record_buffer=1044480 sort_buffer=1048568 max_used_connections=0 max_connections=512 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 5765112 K bytes of memory Hope that's okay, if not, decrease some variables in the equation. If the server is started with more modest settings (e.g., key_buffer_size=2G), mysql operates correctly. Additionally, mysqladmin variables shows a correct key_buffer value. System memory is not a constraint ( 6 G real memory and 14.5 G swap). Hi! This is a problem that we would like to take a look at !! Please provide us with details on how have you built MySQL. For the start ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: visualizing my queries
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then [EMAIL PROTECTED] declared Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then DL Neil declared Recommendation: treat the (possible) addition to the author tbl as one task, and the (required in both cases) addition to the content tbl as a separate task. Well I /hadn't/ tested as I wasn't sure that my DB design wasn't flawed, I was expecting someone to say 'well if you want to do that you need to design like this..' No matter. I'm not sure I understand you recommendation, would kindly explain a little more? Much thanks... - -- Nick Wilson Tel: +45 3325 0688 Fax: +45 3325 0677 Web: www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8YSrUHpvrrTa6L5oRAjPbAJ49v60120MPRfX8E+JU8fcUBDoLQwCfbXTK yeovHQHKDTL1YC9UJmFm3Io= =4dRK -END PGP SIGNATURE- - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8YSuQHpvrrTa6L5oRAtuTAKCNM8iACmK4AJwezAi9uab6L0icbACfSpcM 8v0NnIMtKsHCURK/Ji9qJqg= =KNhq -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Memory limit issue with 64 bit mysql.3.23.46
On Wed, Feb 06, 2002 at 02:57:51PM +0200, Sinisa Milivojevic wrote: Franklin, Kevin writes: We are running an extremely large instance of mysql version 3.23.46 on Solaris 2.8. We are attempting to use a software version compiled 64 bit and have been experiencing memory related server crashes. The behavior suggests that we are still unable to use more than 4G of memory. If the server is started with the following settings: key_buffer=4608M max_allowed_packet=1M table_cache=1024 record_buffer=1M sort_buffer=1M thread_cache=12 thread_concurrency=12 myisam_sort_buffer_size=512M We observe the following symptoms / problems: (1) A mysqladmin variables call shows that the key_buffer is set to be 1 G, not 4.5G. (2) Under any sort of database load, the server crashes with the following error output: mysql got signal 10; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=4831834112 record_buffer=1044480 sort_buffer=1048568 max_used_connections=0 max_connections=512 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 5765112 K bytes of memory Hope that's okay, if not, decrease some variables in the equation. If the server is started with more modest settings (e.g., key_buffer_size=2G), mysql operates correctly. Additionally, mysqladmin variables shows a correct key_buffer value. System memory is not a constraint ( 6 G real memory and 14.5 G swap). Hi! This is a problem that we would like to take a look at !! Please provide us with details on how have you built MySQL. For the start ... MySQL 3.23.46 was built with the Sun C++ compiler: $ CC -V CC: Sun WorkShop 6 update 2 C++ 5.3 Patch 111685-03 2001/10/19 It was built as follows: CC=cc CFLAGS=-mr -Qn -xstrconst -xO2 -xtarget=generic -xarch=v9 \ CXX=CC CXXFLAGS=-xO2 -xtarget=generic -xarch=v9 \ CPPFLAGS=-I/opt/TWWfsw/readline42a/include \ -I/opt/TWWfsw/zlib11/include -I/opt/TWWfsw/ncurses5/include \ -I/opt/TWWfsw/ncurses5/include/ncurses \ LDFLAGS=-L/opt/TWWfsw/readline42a/lib/sparcv9 \ -L/opt/TWWfsw/zlib11/lib/sparcv9 -L/opt/TWWfsw/ncurses5/lib/sparcv9 \ -L/opt/TWWfsw/readline42a/lib/sparcv9 \ -R/opt/TWWfsw/readline42a/lib/sparcv9:\ /opt/TWWfsw/zlib11/lib/sparcv9:/opt/TWWfsw/ncurses5/lib/sparcv9 \ -xarch=v9 ./configure --localstatedir=/var/opt/TWWfsw/mysql32346 \ --sysconfdir=/etc/opt/TWWfsw/mysql32346 --enable-shared \ --enable-static --without-debug --with-innodb --without-bench \ --without-readline --enable-strcoll --with-libwrap \ --with-berkeley-db --enable-thread-safe-client \ --prefix=/opt/TWWfsw/mysql32346 -- albert chin ([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
Macintosh
Hi Is it possible to connect to a MySQL Database running on a Linux server from an workstation running Mac OS 9.0 using ODBC ? i.e. does it exist any ODBC drivers for MySql to use from Mac ? Best Regards Jan Eskilsson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Tables keeps crashing...
hello, we are using mysql on a windows98 machine. But a lot of times the tables in the database keep crashing. When checking it says: 1 client did not close connection... table marked as crashed (not always this line) with different tables does anyone had this problem also? Willem - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Macintosh
Jan Eskilsson wrote: Hi Is it possible to connect to a MySQL Database running on a Linux server from an workstation running Mac OS 9.0 using ODBC ? i.e. does it exist any ODBC drivers for MySql to use from Mac ? I myself use and beta test MacSQL: http://www.rtlabs.com/macsql/ It is a carbon application so if you mac the move to Mac OS X you will not have a problem. There are several other application for OS 9 such as ProSQL: http://www.intellisw.com/prosql/ If you check out versiontracker.com and do a search for SQL or MySQL in the Mac OS or Mac OS X sections to get a better feel for what is available. -- David Steinbrunner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Get hash of MySQL row
Hi I want to retrieve a row of MySQL data using Perl and DBI, so I do it like this: [code] my $sqlquery = qq|SELECT * FROM ata_members WHERE id=$id|; $sth = $dbh-prepare($sqlquery); $sth-execute or die(Can't execute SQL query. [$DBI::err] $DBI::errstr); $ref = $sth-fetchrow_hashref(); $sth-finish; [/code] But what I want is to populate a %hash with all name/value pairs retruned from this query. I tried: [code] my %hash = %$ref; [/code] But that doesn't work. Anyone else got any ideas? Maybe there's a better way to retrieve the information from MySQL? -- Wiliam Stephens [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: visualizing my queries
Nick, Well I /hadn't/ tested as I wasn't sure that my DB design wasn't flawed, I was expecting someone to say 'well if you want to do that you need to design like this..' No matter. Again: if you use the native-MySQL/command line, or an administration/management package, you will be able to quickly create prototype tables and bounce queries off them. The best way to 'test' a design/approach, is to test it out! Recommendation: treat the (possible) addition to the author tbl as one task, and the (required in both cases) addition to the content tbl as a separate task. I'm not sure I understand you recommendation, would kindly explain a little more? 2 tables content TipId | AuthId | title | keywords | desc | section | text author AuthId | name | email | bio My question is: If I enter a 'tip' and put myself as the author, when /I/ come to write another tip how do I make my query avoid putting another entry in author? I'll be using PHP for the front end. This explanation describes the 'problem' as one task. The recommendation is that it be split into two - in so doing, the two 'problems' become quite simple and much more straight-forward. So looking at your question from a 'design' (cf a coding) point of view: There are two tables. There is a one-to-many relationship between author and content, ie one author may contribute multiple tips, but it is assumed that one tip is credited to only one author. When a new tip is to be entered into the database, there are two tasks: one related to author, the other related to the tip. The tip cannot be entered into content until the AuthId is known, so that puts it second in line. Starting with the author: either the author already exists in the table (SELECT=successful), in which case his/her AuthId needs to be ascertained and fed to 'part two'; or the author's details are not 'on file' and therefore must be INSERTed (and the AuthId noted...'part two'). Once the AuthId is known, 'part two' can take place, and the tip written to the content tbl. Thus two tasks: (1) deal with the author 'issue', and (2) save the tip. Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 / PHP Augmenting Variables For UPDATE
Hi,
I am making a form for editing the rows in a table. It displays each row
as a row in a table(structure id tinyiny,name varchar(30) ), with the
value inside a textbox so it can be changed. When doing the $submit to
MySQL, I need do this:
for($count=0;$count=$i;$count++)
{
$current_id = $$count.-id;
$current_name = $$count.-name;
$sql = UPDATE committee_names SET name ='$current_name' WHERE
committee_id = '$current_id'
$result = mysql_query($sql);
};
Each time a record is displayed in the HTML table the textbox is given a
name like $0-name then $1-name dynamically until all the records in the
table have been displayed. Does anyone know how I can accomplish this?
Many Thanks.
- Matt Rudderham
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: BEGIN/COMMIT statements not written to the binary log : may it cause problems with replication ?
Hi! Heikki == Heikki Tuuri [EMAIL PROTECTED] writes: Heikki Guilhem, Heikki this is a known problem and mentioned in the Restrictions section of the Heikki InnoDB online manual. Heikki It is not the correct way to run SQL statements in the autocommit mode on Heikki the slave server, while the master has normal transaction processing on. Heikki I have asked Sasha to add COMMIT marks to the binlog, so that people would Heikki not see partial transactions on the slave server. I am sending a carbon copy Heikki of this message to Sasha. Heikki Best regards, We have this in our todo and it will be fixed in MySQL 4.0 or 4.1. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PostgreSQL
Hey All! Anyone know the difference between MySQL and PostgreSQL? Are the both pretty much the same? So far I like MySQL, but find that MS SQL is far greater, but only because it has much more. Anyone have any comments on the matter? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
resetting a password
jeremy, Tuesday, February 05, 2002, 8:32:23 PM, you wrote: jr following the instructions for resetting a password ( jr http://www.mysql.com/doc/R/e/Resetting_permissions.html ), jr i was not able to find the .pid file. is it possible to continue the process jr without killing it? If you have running mysql server, you should take down mysqld. When you restart mysqld .pid file will be created. jr what would be the command to restart the daemon using the jr --skip-grant-tables option? i wasn't able to figure it out. safe_mysqld --skip-grant-tables jr any help would be appreciated ... jr thx jr jeremy -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Storing Binary data in MySQL
Hello, I'm new to Unix and MySQL. I would like to store binary data in MySQL, but cannot find any sample code on how to go about doing this in C. The binary data is variable size ranging from 3k to 10k. I want to store it in a row along with a User ID so I can retrieve it by doing a query on this ID. How do I store and retrive this binary data in MySQL? I see references to BLOB and mysql_real_escape_string(). Am I on the right track? or is there more to it? 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: PostgreSQL
Hi. No, Postgres has much more. The biggest point is, that it has Subselects ! But mySQL seems to be much faster in some points. That´s all I want to tell :) Greetz Daniel -Original Message- From: Vernon A Webb [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 3:59 PM To: MySQL Subject: PostgreSQL Hey All! Anyone know the difference between MySQL and PostgreSQL? Are the both pretty much the same? So far I like MySQL, but find that MS SQL is far greater, but only because it has much more. Anyone have any comments on the matter? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
fatal: libncurses.so.5
michael.s, Wednesday, February 06, 2002, 12:22:15 PM, you wrote: msÉ Hi, msÉ I just installed mysql in my Solaris (Sparc) box, but msÉ when I run mysql ( mysqld running ), I get the following msÉ err, ld.so.1: bin/mysql: fatal: libncurses.so.5: open msÉ failed: No such file or directory Killed Please, tell us more about the problem appeared. How did you install MySQL? Did you install a downloaded from the mysql site binary distributive or you have compiled the server on your own? msÉ Any help will be appreciated! -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL / PHP Augmenting Variables For UPDATE
On Wed, 2002-02-06 at 07:51, Matt Rudderham wrote:
Hi,
I am making a form for editing the rows in a table. It displays each row
as a row in a table(structure id tinyiny,name varchar(30) ), with the
value inside a textbox so it can be changed. When doing the $submit to
MySQL, I need do this:
for($count=0;$count=$i;$count++)
{
$current_id = $$count.-id;
$current_name = $$count.-name;
$sql = UPDATE committee_names SET name ='$current_name' WHERE
committee_id = '$current_id'
$result = mysql_query($sql);
};
Each time a record is displayed in the HTML table the textbox is given a
name like $0-name then $1-name dynamically until all the records in the
table have been displayed. Does anyone know how I can accomplish this?
Hi Matt,
This question is probably best answered by the PHP mailing lists. :)
However, before you go ask a question there, here are some tips:
Turn your error reporting up - there are several key errors in the
script that would be reported if error_reporting(E_ALL) were set.
There are PHP manual sections on strings and variable variables that
will help you out.
You may want to do this instead?
$sql = UPDATE committee_names
SET name ='${count}-id'
WHERE committee_id = '${count}-name';
Hrm. Any more and this would not be a MySQL mailing list. Please do
try the PHP lists. Visit http://php.net/support.php for more
information. You may wish to search the General mailing list archives
before posting - this is a fairly common question.
Good luck!
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Zak Greant [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Calgary, Canada
___/ www.mysql.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PostgreSQL
On Wed, 2002-02-06 at 07:59, Vernon A Webb wrote: Hey All! Anyone know the difference between MySQL and PostgreSQL? Are the both pretty much the same? So far I like MySQL, but find that MS SQL is far greater, but only because it has much more. Anyone have any comments on the matter? Hi Vernon, You may find this page (and its sub-pages) interesting. http://www.mysql.com/doc/C/o/Comparisons.html Additionally, for an overview of upcoming MySQL features, visit: http://www.mysql.com/doc/T/O/TODO.html Ciao! -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Zak Greant [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB Advocate /_/ /_/\_, /___/\___\_\___/ Calgary, Canada ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problems with SQLGetInfo and SQLColumnPrivileges
Dear all,
today I have switched from myodbc 2.50.39.00 to 3.51.01.00,
because I had a problem using SQLColumnPrivileges (see below)
After that I couldn't use my application because of the
ConnectionHandle was destroyed. After logging the application I
have found, that there is an problem inside of SQLGetInfo. I made a
call:
SQLHDBC hdbc=NULL;
SQLUSMALLINTMaxStatementHdls;
SQLSMALLINT len;
SQLGetInfo (hdbc, SQL_ACTIVE_STATEMENTS,
MaxStatementHdls, sizeof (MaxStatementHdls), len);
after that, the hdbc lost his low part. The reason for that seems
to be the variable MaxStatementHdls defined as
SQLUSMALLINT (like the description of ODBC in MSDN). len
says, that in MaxStatementHdls will be returned a value with a
lenght of 4 (instead of 2). As work around I have changed the
definition of MaxStatementHdls from SQLUSMALLINT to int.
And this is my original problem - but here I can't find a reason:
If I try to call
SQLColumnPrivileges (hstmt, NULL, 0, NULL, 0,
(SQLCHAR*)patdat, SQL_NTS, NULL, 0) ?
I get a error message [Microsoft][ODBC Driver Manager] Driver
does not support this function if I use myodbc V2.50. If I try to do
the same with myodbc V3.51 I will get [mysqld-3.23.43]Driver
doesn't support this yet. But the documentation says, this
functions is included in both versions.
Has anyone the same problems or is something wrong at my site ?
-
With best regards
Peter Klinge
---
Dipl.-Ing. Peter Klinge
AMEDTEC Medizintechnik Aue GmbH, Schneeberger Str. 5, 08280 Aue
Tel.: +049 3771 722133Fax: +049 3771 722106
Email: [EMAIL PROTECTED]
---
Der folgende Abschnitt dieser Nachricht enthält einen Dateianhang
im Internet MIME Format.
Wenn Sie Pegasus Mail oder ein anderes MIME-kompatibles Programm verwenden,
sollten Sie den Anhang speichern oder ansehen können.
Sollte das nicht funktionieren, fragen Sie Ihren Systembetreuer um Rat.
The following section of this message contains a file attachment
prepared for transmission using the Internet MIME message format.
If you are using Pegasus Mail, or any another MIME-compliant system,
you should be able to save it or view it from within your mailer.
If you cannot, please ask your system administrator for assistance.
Datei-Informationen / File information ---
Datei/File: SQL.LOG
Datum/Date: 6 Feb 2002, 14:18
Größe/Size: 930 bytes.
Typ/Type: Binary
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with database
I have a site using PHP Mysql. About a month ago to now one of the tables gets corrupted with the message Got Error 127... I fix it and everything works OK, except every time I loose 1 record. Today I could obtain mysql.err from the machine and I could see whenever an error is produced by date, previously I have the following line: 020205 9:57:46 Aborted connection 137 to db: 'Biblioteca' user: 'ODBC' host: `localhost' (Server shutdown in progress) 020205 9:57:46 Aborted connection 124 to db: 'Biblioteca' user: 'ODBC' host: `localhost' (Server shutdown in progress) or 020205 12:55:51 Aborted connection 377 to db: 'Biblioteca' user: 'ODBC' host: `localhost' (Unknown error) 020205 13:05:37 Aborted connection 504 to db: 'Biblioteca' user: 'ODBC' host: `localhost' (Unknown error) It doesn´t seems too clear for me because no ODBC client should be accessing to the database. Should I suppose that an unautorized ODBC client is breaking the table or could be another problem? Thanks a lot. Emiliano. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replicate-ignore-table
Hi everyone, When using replicate-ignore-table in mysql, does filtering happen before or after transmission from the master to the slave? 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: visualizing my queries
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then DL Neil declared My question is: If I enter a 'tip' and put myself as the author, when /I/ come to write another tip how do I make my query avoid putting another entry in author? I'll be using PHP for the front end. Starting with the author: either the author already exists in the table (SELECT=successful), in which case his/her AuthId needs to be ascertained and fed to 'part two'; or the author's details are not 'on file' and therefore must be INSERTed (and the AuthId noted...'part two'). Once the AuthId is known, 'part two' can take place, and the tip written to the content tbl. Thus two tasks: (1) deal with the author 'issue', and (2) save the tip. Fantastic, thanks for taking time out to help me, very much appreciated and you're right of course. - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8YVKSHpvrrTa6L5oRAowcAKCwDeTodQtamgUfuxXVpYtiJi4FQACghP9w Bl/cpWlrX0jVLET3HH+DHEM= =2z22 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql-3.23.47 Compile Error on Linux
-I/usr/include -I./../include -I./../regex-I. -I../include -I.. -I. snip mysqld.cc:1767: implicit declaration of function `int regex_init(...)' A carefull look reveals that the commandline above is seeing /usr/include/regex.h instead of /usr/src/mysql-3.23.47/regex/regex.h. The system header does not have regex_init(); A temporary symlink in /usr/include seemed to fix this, but I'm sure that's not the correct way. The closest explenation I could find was somthing about the @bdb_includes@ macro in sql/Makefile.am being resposible for this. oop, next error, guess db-4.0.11 will not work... Cheers, ~Jason -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problems with SQLGetInfo and SQLColumnPrivileges
Can you send exact message as this one to [EMAIL PROTECTED] ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
bug report: mysql_install_db hangs on execution.
SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: Subject: Mysqld hangs on initialization with mysql_install_db. Description: when running the databse installation script, it hangs after installing all prepared tables and does not create any tables nor sockets. How-To-Repeat: repeatable at will Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: alain Originator:[EMAIL PROTECTED] Organization: Natural Resource Canada MySQL support: none Synopsis: synopsis of the problem (one line) Severity: serious Priority: low Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-4.0.1-alpha (Official MySQL binary) Environment: PW500, unix, bash shell. System: OSF1 ip-leader.mets.nrcan.gc.ca V5.1 732 alpha Machine: alpha Some paths: /usr/bin/perl /sbin/make /usr/bin/cc Compilation info: CC='cc -pthread' CFLAGS='-O4 -ansi_alias -ansi_args -fast -inline speed -speculate all' CXX='cxx -pthread' CXXFLAGS='-O4 -ansi_alias -fast -inline speed -speculate all -noexceptions -nortti' LDFLAGS='' LIBC: lrwxrwxrwx 1 root system17 Nov 1 2000 /lib/libc.a - ../ccs/lib/libc.a lrwxrwxrwx 1 root system17 Nov 1 2000 /usr/lib/libc.a - ../ccs/lib/libc.a Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client --with-prefix=/usr/local/mysql --with-mysqld-ldflags=-all-static --disable-shared '--with-named-thread-libs=-lpthread -lmach -lexc -lc' --disable-shared Perl: This is perl, version 5.005_03 built for alpha-dec_osf - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql command dumps core.
Hello, I am relatively new to Mysql. I am have a strange problem that is preventing me from setting up my database to test out mysql as a backend to an IDS system. When I start the mysql command I get the following output. srsids01# ./mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.47-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. Segmentation fault (core dumped) srsids01# I am running mysql 3.23.47 on a Solaris 8 server. Please help. Thanks! vjl -- V.Jay LaRosa EMC Corporation Systems Administrator 171 South Street (508)435-1000 ext 14957Hopkinton, MA 01748 (508)497-8082 fax www.emc.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: Memory limit issue with 64 bit mysql.3.23.46
Albert Chin writes: MySQL 3.23.46 was built with the Sun C++ compiler: $ CC -V CC: Sun WorkShop 6 update 2 C++ 5.3 Patch 111685-03 2001/10/19 It was built as follows: CC=cc CFLAGS=-mr -Qn -xstrconst -xO2 -xtarget=generic -xarch=v9 \ CXX=CC CXXFLAGS=-xO2 -xtarget=generic -xarch=v9 \ CPPFLAGS=-I/opt/TWWfsw/readline42a/include \ -I/opt/TWWfsw/zlib11/include -I/opt/TWWfsw/ncurses5/include \ -I/opt/TWWfsw/ncurses5/include/ncurses \ LDFLAGS=-L/opt/TWWfsw/readline42a/lib/sparcv9 \ -L/opt/TWWfsw/zlib11/lib/sparcv9 -L/opt/TWWfsw/ncurses5/lib/sparcv9 \ -L/opt/TWWfsw/readline42a/lib/sparcv9 \ -R/opt/TWWfsw/readline42a/lib/sparcv9:\ /opt/TWWfsw/zlib11/lib/sparcv9:/opt/TWWfsw/ncurses5/lib/sparcv9 \ -xarch=v9 ./configure --localstatedir=/var/opt/TWWfsw/mysql32346 \ --sysconfdir=/etc/opt/TWWfsw/mysql32346 --enable-shared \ --enable-static --without-debug --with-innodb --without-bench \ --without-readline --enable-strcoll --with-libwrap \ --with-berkeley-db --enable-thread-safe-client \ --prefix=/opt/TWWfsw/mysql32346 -- albert chin ([EMAIL PROTECTED]) Please tell me a value for this #define in config.h and my_config.h : SIZEOF_LONG -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
log count
i have a log file in which i record every visit of my site, although some times a visitant came by the morning and by the night or something alike, so i am trying to create a select command which count the ip every since he came back a hour afther of his last visit, the command is just like this: SELECT id, ip, date_format(data,%d/%m/%Y %r) FROM log WHERE date_format(data,%d/%m/%Y)=05/02/2002 AND ip != 200.19.73.64 GROUP BY ip HAVING count(date_format(data,%d/%m/%Y %H))=2 but its not working well, can anyone help me build a correct select command? thanks advanced. sql,query idéias.ual.. Idéias Pontual Desenvolvimento de Software Ltda. Ricardo Striquer Soares CEO e-business Fone: +55 (41) 322-9373 Cel: +55 (41) 9908-3862 Fax: +55 (41) 223-7865 Mr. Lucro : www.mrlucro.com.br _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: bug report: mysql_install_db hangs on execution.
Legault, Alain writes: SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: Subject: Mysqld hangs on initialization with mysql_install_db. Hi! A usual cause for the above behaviour is a difference in the patch level between your OS and the one on which our binary was built. More info in our manual. -- Consider taking our support. Visit : https://order.mysql.com Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Win32 support
I am looking for a way to use MySQL on a Windows 98 platform with the gnu tool set. The binaries that came with the Win32 version of MySQL seem to be for Microsoft. The function names have an '@n' appended to them with the 'n' being the number of bytes for the arguments. Therefore, even though the function is in the library it's name has been 'mangled' so that the gnu linker can't find it. -- Steve Kelley Celerity Systems, Inc. Knoxville, TN [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: PostgreSQL
Vernon A Webb [EMAIL PROTECTED] writes: Anyone know the difference between MySQL and PostgreSQL? PostgreSQL has a lot of features MySQL don't have yet (transactions everywhere, foreign keys, subselects, stored procedures, triggers, etc), while MySQL is heavily optimized for handling big loads of simple SQL. -- Trond Eivind Glomsrød Red Hat, 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
Re: Memory limit issue with 64 bit mysql.3.23.46
On Wed, Feb 06, 2002 at 06:12:22PM +0200, Sinisa Milivojevic wrote: Albert Chin writes: MySQL 3.23.46 was built with the Sun C++ compiler: $ CC -V CC: Sun WorkShop 6 update 2 C++ 5.3 Patch 111685-03 2001/10/19 It was built as follows: CC=cc CFLAGS=-mr -Qn -xstrconst -xO2 -xtarget=generic -xarch=v9 \ CXX=CC CXXFLAGS=-xO2 -xtarget=generic -xarch=v9 \ CPPFLAGS=-I/opt/TWWfsw/readline42a/include \ -I/opt/TWWfsw/zlib11/include -I/opt/TWWfsw/ncurses5/include \ -I/opt/TWWfsw/ncurses5/include/ncurses \ LDFLAGS=-L/opt/TWWfsw/readline42a/lib/sparcv9 \ -L/opt/TWWfsw/zlib11/lib/sparcv9 -L/opt/TWWfsw/ncurses5/lib/sparcv9 \ -L/opt/TWWfsw/readline42a/lib/sparcv9 \ -R/opt/TWWfsw/readline42a/lib/sparcv9:\ /opt/TWWfsw/zlib11/lib/sparcv9:/opt/TWWfsw/ncurses5/lib/sparcv9 \ -xarch=v9 ./configure --localstatedir=/var/opt/TWWfsw/mysql32346 \ --sysconfdir=/etc/opt/TWWfsw/mysql32346 --enable-shared \ --enable-static --without-debug --with-innodb --without-bench \ --without-readline --enable-strcoll --with-libwrap \ --with-berkeley-db --enable-thread-safe-client \ --prefix=/opt/TWWfsw/mysql32346 -- albert chin ([EMAIL PROTECTED]) Please tell me a value for this #define in config.h and my_config.h : SIZEOF_LONG $ grep SIZEOF_LONG config.h #define SIZEOF_LONG 8 #define SIZEOF_LONG_LONG 8 $ grep SIZEOF_LONG incldue/my_config.h #define SIZEOF_LONG 8 #define SIZEOF_LONG_LONG 8 -- albert chin ([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
Slow Inner Join Help
I have a table with 2.9 mil records which represents 197k sentences stored
vertically. I do this because I need to know information about each word
and its relationship to other tables.
I want to know how many words have a particular word-group ID before and a
particular word-group ID after the word ID I am looking for. All of the
fields shown are indexed integer fields.
The examples below actually work fine but Word ID #8 happens to be a popular
word ('the' 216,000) and this query takes 1 min 15 sec to run. When the
Word ID I am looking for is not so popular it executes in 0.05 - 5.0
seconds. Basically, 90% of the time its OK but 10% of the time is taking
longer than the 90%.
One of the things I noticed with the server is that the CPU and disk access
is virtually nothing while these joins are running. Other parts of my
program can take the CPU near 100% when running multiple copies but when any
of those copies get to this Inner Join it is slow and is tagged as a MySQL
Slow query.
Are there settings I should be making on the Server?
Is there a better way or method to make a query like this go faster?
Thanks
Butch Bean
Table type is MyISAM
EXPLAIN returns the following:
+---+--+--+--+-+
-+--++
| table | type | possible_keys| key | key_len |
ref | rows | Extra |
+---+--+--+--+-+
-+--++
| tbl_SENT | ref | SENT_ID,Grp | Grp | 4 |
const | 4295 | where used |
| tbl_SENT_1| ref | SENT_ID,WORD_ID,WORD_POSITION| SENT_ID | 5 |
tbl_SENT.SENT_ID| 15 | where used |
| tbl_SENT_2| ref | SENT_ID,WORD_POSITION,Grp| SENT_ID | 5 |
tbl_SENT.SENT_ID| 15 | where used |
+---+--+--+--+-+
-+--++
SELECT count(*) FROM tbl_SENT
INNER JOIN tbl_SENT AS tbl_SENT_1
ON tbl_SENT.SENT_ID = tbl_SENT_1.SENT_ID
INNER JOIN tbl_SENT AS tbl_SENT_2
ON tbl_SENT.SENT_ID = tbl_SENT_2.SENT_ID
WHERE tbl_SENT_1.WORD_POSITION=tbl_SENT.WORD_POSITION + 1
AND tbl_SENT_2.WORD_POSITION=tbl_SENT.WORD_POSITION + 2
AND tbl_SENT.Grp=28744
AND tbl_SENT_1.WORD_ID=8
AND tbl_SENT_2.Grp=60072)
* OR *
SELECT count(*) FROM tbl_SENT
INNER JOIN tbl_SENT AS tbl_SENT_1
ON tbl_SENT.SENT_ID = tbl_SENT_1.SENT_ID
INNER JOIN tbl_SENT AS tbl_SENT_2
ON tbl_SENT.SENT_ID = tbl_SENT_2.SENT_ID
WHERE ((tbl_SENT.WORD_ID=8
AND (tbl_SENT_1.WORD_POSITION=tbl_SENT.WORD_POSITION - 1
AND tbl_SENT_1.Grp=28744))
AND (tbl_SENT_2.WORD_POSITION=tbl_SENT.WORD_POSITION + 1
AND tbl_SENT_2.Grp=60072))
* OR *
SELECT count(*) FROM tbl_SENT
INNER JOIN tbl_SENT AS tbl_SENT_1
ON (tbl_SENT.SENT_ID = tbl_SENT_1.SENT_ID) AND
(tbl_SENT_1.WORD_POSITION=tbl_SENT.WORD_POSITION - 1)
AND (tbl_SENT_1.Grp=28744)
INNER JOIN tbl_SENT AS tbl_SENT_2
ON (tbl_SENT.SENT_ID = tbl_SENT_2.SENT_ID) AND
(tbl_SENT_2.WORD_POSITION=tbl_SENT.WORD_POSITION + 1)
AND (tbl_SENT_2.Grp=60072)
WHERE tbl_SENT.WORD_ID=8
* OR *
SELECT count(*) FROM tbl_SENT AS tbl_SENT_0, tbl_SENT AS tbl_SENT_1,
tbl_SENT AS tbl_SENT_2
WHERE (tbl_SENT_0.SENT_ID = tbl_SENT_1.SENT_ID
AND tbl_SENT_0.SENT_ID = tbl_SENT_2.SENT_ID)
AND (tbl_SENT_1.WORD_POSITION=tbl_SENT_0.WORD_POSITION + 1
AND tbl_SENT_2.WORD_POSITION=tbl_SENT_0.WORD_POSITION + 2
AND tbl_SENT_0.Grp=28744
AND tbl_SENT_1.WORD_ID=8
AND tbl_SENT_2.Grp=60072)
Server:
Dual PIII 800 w/1gb RAM - Win2K
join_buffer_size = 100M (does not seem to effect this query)
set-variable= key_buffer=700M
set-variable= max_allowed_packet=2M
set-variable= join_buffer_size=100M
set-variable= table_cache=512M
set-variable= sort_buffer=20M
set-variable= record_buffer=20M
set-variable= thread_cache=30M
set-variable= thread_concurrency=4
set-variable= myisam_sort_buffer_size=64M
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: PostgreSQL
Trond Eivind Glomsrød writes: Vernon A Webb [EMAIL PROTECTED] writes: Anyone know the difference between MySQL and PostgreSQL? PostgreSQL has a lot of features MySQL don't have yet (transactions everywhere, foreign keys, subselects, stored procedures, triggers, etc), while MySQL is heavily optimized for handling big loads of simple SQL. -- Trond Eivind Glomsrød Red Hat, Inc. Sorry Trond, But MySQL has transactions and foreign keys. For the rest you are correct, unless you do not count myperl as stored procs. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to setup mysqlgui in Win2000
I have MySQL running on my FreeBSD server and I want to connect to it from my Windows 2000 workstation using mysqlgui. I put the ip address of the FreeBSD server in the my.cnf file under host, but it keeps trying to connect to the Win2000 machine instead of the FreeBSD box. Am I doing something wrong? 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: PostgreSQL
On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: Trond Eivind Glomsrød writes: Vernon A Webb [EMAIL PROTECTED] writes: Anyone know the difference between MySQL and PostgreSQL? PostgreSQL has a lot of features MySQL don't have yet (transactions everywhere, foreign keys, subselects, stored procedures, triggers, etc), while MySQL is heavily optimized for handling big loads of simple SQL. But MySQL has transactions and foreign keys. I said everywhere - you need to use Innobase to get foreign keys, and innobase/db3 to get transactions. -- Trond Eivind Glomsrød Red Hat, 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
compression
Sommai, Wednesday, February 06, 2002, 8:01:13 AM, you wrote: SF Hi, SF I need to know that MySQL has any compression method when it store SF data? If the answer is Yes, How the different compression between MySQL SF and other tools (zip, gzip)? I asked this question because I need to store SF some text file for future used (at least 1 Mbyte per day). I was used SF Winzip in Windows to compress and keep in file server. If MySQL could SF compress some byte of data I think it better than flat file. myisampack is used to compress MyISAM tables, after packing tables become read-only. See at : http://www.mysql.com/doc/m/y/myisampack.html You can also read about packed compressed table at: http://www.mysql.com/doc/C/o/Compressed_format.html SF Sommai -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PostgreSQL
On Wed, Feb 06, 2002 at 06:49:02PM +0200, Sinisa Milivojevic wrote: Trond Eivind Glomsrød writes: Vernon A Webb [EMAIL PROTECTED] writes: Anyone know the difference between MySQL and PostgreSQL? PostgreSQL has a lot of features MySQL don't have yet (transactions everywhere, foreign keys, subselects, stored procedures, triggers, etc), while MySQL is heavily optimized for handling big loads of simple SQL. Sorry Trond, But MySQL has transactions and foreign keys. For the rest you are correct, unless you do not count myperl as stored procs. To his credit, he said transactions everywhere. MySQL has transactions for specific table handlers, not everywhere. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 2 days, processed 100,359,170 queries (475/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Get hash of MySQL row
On Wed, Feb 06, 2002 at 01:57:21PM +, Wiliam Stephens wrote: Hi I want to retrieve a row of MySQL data using Perl and DBI, so I do it like this: [code] my $sqlquery = qq|SELECT * FROM ata_members WHERE id=$id|; $sth = $dbh-prepare($sqlquery); $sth-execute or die(Can't execute SQL query. [$DBI::err] $DBI::errstr); $ref = $sth-fetchrow_hashref(); $sth-finish; [/code] Seems reasonable. But what I want is to populate a %hash with all name/value pairs retruned from this query. Are you sure that there is data returned? I tried: [code] my %hash = %$ref; [/code] But that doesn't work. It should. I'm not sure why you'd want to do it, but it should work. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 2 days, processed 100,373,948 queries (475/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Memory limit issue with 64 bit mysql.3.23.46
Albert Chin writes: $ grep SIZEOF_LONG config.h #define SIZEOF_LONG 8 #define SIZEOF_LONG_LONG 8 $ grep SIZEOF_LONG incldue/my_config.h #define SIZEOF_LONG 8 #define SIZEOF_LONG_LONG 8 -- albert chin ([EMAIL PROTECTED]) If SIZEOF_INT is 4, then it could be our bug. Please let us know. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: PostgreSQL
The way I look at it, MySQL gives you a choice of table types, so you can pick the one best suited to the task at hand. For raw speed where you can do without transactions, you can go with MyISAM. Otherwise you have Innobase. I'm not sure where/why db3 fits in, haven't been bothered to look into it yet. On the other points, you are correct. Can't wait for subselects... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Trond Eivind Glomsrød Sent: Wednesday, February 06, 2002 12:10 PM To: Sinisa Milivojevic Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: PostgreSQL On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: Trond Eivind Glomsrød writes: Vernon A Webb [EMAIL PROTECTED] writes: Anyone know the difference between MySQL and PostgreSQL? PostgreSQL has a lot of features MySQL don't have yet (transactions everywhere, foreign keys, subselects, stored procedures, triggers, etc), while MySQL is heavily optimized for handling big loads of simple SQL. But MySQL has transactions and foreign keys. I said everywhere - you need to use Innobase to get foreign keys, and innobase/db3 to get transactions. -- Trond Eivind Glomsrød Red Hat, 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: blob field
[redirecting to mysql list because of general interest] Yoram Naim wrote: Can some one send me a code sample (C , CPP ) How can I copy file data to MYSQL BLOB field but not in one piece . Is this even possible? If so, I'm sure that the JDBC driver could use such a feature to stream large blobs to the database (currently, in 3.23, we're stuck with the 16MB single-packet limitation). -- Shankar. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: PostgreSQL
Trond Eivind Glomsrød writes: On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: I said everywhere - you need to use Innobase to get foreign keys, and innobase/db3 to get transactions. -- Trond Eivind Glomsrød Red Hat, Inc. As EVERY binary and source we distribute has InnoDB in it, then we have transactions and foreign keys everywhere. It is only up to the user to enable it. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to setup mysqlgui in Win2000
Jorge Guerra writes: I have MySQL running on my FreeBSD server and I want to connect to it from my Windows 2000 workstation using mysqlgui. I put the ip address of the FreeBSD server in the my.cnf file under host, but it keeps trying to connect to the Win2000 machine instead of the FreeBSD box. Am I doing something wrong? Thanks. No, you just have to read README that came with mysqlgui and follow instructions found in it. Click on Options button, fill up all entries and click on Save., Then re-connect. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Error in myodbc 3.51.01.00
Hi, -Original Message- From: Peter Klinge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 5:33 AM To: [EMAIL PROTECTED] Subject: Error in myodbc 3.51.01.00 Dear all, today I have switched from myodbc 2.50.39.00 to 3.51.01.00, because I had a problem using SQLColumnPrivileges (see below) After that I couldn't use my application because of the ConnectionHandle was destroyed. After logging the application I have found, that there is an problem inside of SQLGetInfo. I made a call: SQLHDBC hdbc=NULL; SQLUSMALLINT MaxStatementHdls; SQLSMALLINT len; SQLGetInfo (hdbc, SQL_ACTIVE_STATEMENTS, MaxStatementHdls, sizeof (MaxStatementHdls), len); SQLAllocHandle (SQL_HANDLE_STMT, hdbc, hstmt); after SQLGetInfo and before SQLAllocHandle, the hdbc lost his low part. The reason for that seems to be the variable MaxStatementHdls defined as SQLUSMALLINT (like the description of ODBC in MSDN). len says, that in MaxStatementHdls will be returned a value with a lenght of 4 (instead of 2). As work around I have changed the definition of MaxStatementHdls from SQLUSMALLINT to int. (see attached file sql.log) SQL_ACTIVE_STATEMENTS is deprecated/renamed in ODBC 3.x spec, and the new one is SQL_MAX_CONCURRENT_ACTIVITIES. You should try to use this with 3.x applications. SQL_MAX_CONCURRENT_ACTIVITIES returns SQLUINTEGER only, though it was a typo error as SQLUSMALLINT in ODBC spec. And this is my original problem - but here I can't find a reason: If I try to call SQLColumnPrivileges (hstmt, NULL, 0, NULL, 0, (SQLCHAR*)patdat, SQL_NTS, NULL, 0) ? I get a error message [Microsoft][ODBC Driver Manager] Driver does not support this function if I use myodbc V2.50. If I try to do the same with myodbc V3.51 I will get [mysqld-3.23.43]Driver doesn't support this yet. But the documentation says, this functions is included in both versions. We don't support yet. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PostgreSQL
On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: Trond Eivind Glomsrød writes: On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: I said everywhere - you need to use Innobase to get foreign keys, and innobase/db3 to get transactions. As EVERY binary and source we distribute has InnoDB in it, then we have transactions and foreign keys everywhere. It's enabled in the MySQL rpms we distribute as part of RHL as well, but it's not the default type for created tables. Thus, most people won't be using it. If memory serves, you need to set various options in order to use it as well. -- Trond Eivind Glomsrød Red Hat, 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
RE: blob field
Hi, -Original Message- From: Shankar Unni [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 9:29 AM To: Yoram Naim Cc: '[EMAIL PROTECTED]' Subject: Re: blob field [redirecting to mysql list because of general interest] Yoram Naim wrote: Can some one send me a code sample (C , CPP ) How can I copy file data to MYSQL BLOB field but not in one piece . Is this even possible? If so, I'm sure that the JDBC driver could use such a feature to stream large blobs to the database (currently, in 3.23, we're stuck with the 16MB single-packet limitation). -- Its possible with MyODBC Drivers to 'n' size. You can supply BLOB/CLOB data in pieces to desired size by making use of SQLParamData and SQLPutData APIs. Here is a simple examples using 'C-ODBC'. 1. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbc sending_long_data.asp 2. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbc sqlputdata.asp I think it should also be possible with MmDriver, but never tested. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Memory limit issue with 64 bit mysql.3.23.46
Albert Chin writes: On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote: Yes, SIZEOF_INT is 4: $ grep SIZEOF_INT config.h #define SIZEOF_INT 4 $ grep SIZEOF_INT include/my_config.h #define SIZEOF_INT 4 -- albert chin ([EMAIL PROTECTED]) We shall have to llok at it. An interim fix is to set key_buffer_size to 4G - 4096 bytes ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL and Arabic
Hello All I am new to MySQL 3.23.42 and I installed it on a Windows 2000 system. I need a database with both English and Arabic records (the fields name not necessarily in Arabic). I searched the archive of the list and the manual and although I found some messages about Arabic, I could not figure out the following: - Is there an Arabic character set for MySQL? if not how do we create one (I read in one message that it might be possible)? - I did not really understood how to install the character set if it exists. - Should the operating system support Arabic for MySQL to work in this language? (no problem with Win 2000, but I will host my site on a Linux or Unix server). Thank you very much in advance George - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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_insert_id error
Hi there,
I am really new at PHP MySQL, so please bear with me.
I am using the mysql_insert_id function but continually receive an error,
and hoping someone can point me in the right direction to resolve this.
My error:
Warning: Supplied argument is not a valid MySQL-Link resource on line 44
_
$result = mysql_query(insert into support (ref_number, date_time, name,
location, email, subject, problem, priority_1,
priority_2, priority_3, priority_4) values ('null', '$date', '$name',
'$email', '$location', '$subject', '$problem',
'$priority_1', '$priority_2', '$priority_3', '$priority_4'));
$ref_number = mysql_insert_id($link_id); This is line 44
Any suggestions? The auto_num field in the database is updating and
everything else is working fine
Thanks in advance for any help!
~Andrea
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: PostgreSQL
Trond Eivind Glomsrød writes: On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: It's enabled in the MySQL rpms we distribute as part of RHL as well, but it's not the default type for created tables. Thus, most people won't be using it. If memory serves, you need to set various options in order to use it as well. -- Trond Eivind Glomsrød Red Hat, Inc. I do not want to sound touchy, touchy, but that is as saying, that e.g. SyBase does not have replication everywhere, as you have to set it with various options. And SyBase has practically invented RDMBS replication, if my memory serves me well. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql 3.23.47 table
[EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Several of our users have reported random table corruption with Linux kernel 2.2.14 under heavy load. The table corruptions went away after an upgrade to a newer kernel. It appears that version 2.2.14 of the Linux kernel has a bug in the I/O implementation. Under some rather rare circumstances, the kernel will write incorrect data to the disk. I'm currently running Linux kernel version 2.2.14 , but i want to update with version 2.2.19. Have any one done that before? or does anyone has any idea how to do it or where can I find some helpful materials to resolve this problem. Thanks so much. --rahad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Memory limit issue with 64 bit mysql.3.23.46
On Wed, Feb 06, 2002 at 08:04:23PM +0200, Sinisa Milivojevic wrote: Albert Chin writes: On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote: Yes, SIZEOF_INT is 4: $ grep SIZEOF_INT config.h #define SIZEOF_INT 4 $ grep SIZEOF_INT include/my_config.h #define SIZEOF_INT 4 However, according to http://docs.sun.com/ab2/coll.45.13/SOL64TRANS/%40Ab2PageView/1865;td=5?Ab2Lang=CAb2Enc=iso-8859-1, in the LP64 (64-bit) environment, int is 32-bits and long is 64-bits so it would appear SIZEOF_INT == 4 is correct above. -- albert chin ([EMAIL PROTECTED]) It is correct. It is a smnall problem in our code. Ok. Guess we'll wait for a fix. Any idea when a fix for MySQL will be available? -- albert chin ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql_insert_id error
Hi Andrea,
I am really new at PHP MySQL, so please bear with me.
welcome to our happy band...
I am using the mysql_insert_id function but continually receive an error,
and hoping someone can point me in the right direction to resolve this.
My error:
Warning: Supplied argument is not a valid MySQL-Link resource on line 44
_
$result = mysql_query(insert into support (ref_number, date_time, name,
location, email, subject, problem, priority_1,
priority_2, priority_3, priority_4) values ('null', '$date', '$name',
'$email', '$location', '$subject', '$problem',
'$priority_1', '$priority_2', '$priority_3', '$priority_4'));
$ref_number = mysql_insert_id($link_id); This is line 44
Any suggestions? The auto_num field in the database is updating and
everything else is working fine
Either remove $link_id and go with the default, or make sure that $link_id is the same
variable as assigned in
the mysql_connect() or mysql_pconnect() call - these being the functions that
establish/name the link.
Regards,
=dn
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Cannot connect to MySQL server with a java application
hello,
i tried to connect my MySQL-Server with a short java application. The
application can't connect to the server, obviously the server is running on
localhost:3306. I append the SourceCode (roughly the same:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:80228:200107:popciohjmlbbolpak
) and the error-message.
SourceCode:
import java.sql.*;
class SQLtest2
{
public static void main(String[] args)
{
try
{
Class.forName(org.gjt.mm.mysql.Driver).newInstance();
System.out.println(register the Driver: OK);
}
catch (Exception e){}
try
{
Connection conn =
DriverManager.getConnection(jdbc:mysql://127.0.0.1:3306/test?user=testpass
word=teschd);
System.out.println(... ccnnected);
Statement s = conn.createStatement();
s.close();
conn.close();
}
catch(SQLException e)
{
System.out.println(SQLException: + e.getMessage());
System.out.println(SQLState: + e.getSQLState());
System.out.println(VendorError: + e.getErrorCode());
}
}
}
Error-Msg:
register the Driver: OK
java.io.IOException: Connection timed out
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:56)
(some EXCeptions more)
SQLException: Cannot connect to MySQL server on 127.0.0.1:3306. Is there a
MySQL server running on the machine/port you are trying to connect to?
(java.io.IOException)
SQLState: 08S01
VendorError: 0
is there somebody who can help me?
thnx bobby
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: Memory limit issue with 64 bit mysql.3.23.46
Albert Chin writes: Ok. Guess we'll wait for a fix. Any idea when a fix for MySQL will be available? -- albert chin ([EMAIL PROTECTED]) Just look into Changelog's of the versions that come out. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Cannot connect to MySQL server with a java application
Almost, but not exactly the same .
DriverManager.getConnection(dburl, dbuser, dbpasswd) -- note, 3 arguments
here
-Original Message-
From: debian [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 1:59 PM
To: [EMAIL PROTECTED]
Subject: Cannot connect to MySQL server with a java application
hello,
i tried to connect my MySQL-Server with a short java application. The
application can't connect to the server, obviously the server is running
on
localhost:3306. I append the SourceCode (roughly the same:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:80228:200107:popciohjmlbbolp
ak
) and the error-message.
SourceCode:
import java.sql.*;
class SQLtest2
{
public static void main(String[] args)
{
try
{
Class.forName(org.gjt.mm.mysql.Driver).newInstance();
System.out.println(register the Driver: OK);
}
catch (Exception e){}
try
{
Connection conn =
DriverManager.getConnection(jdbc:mysql://127.0.0.1:3306/test?user=testpa
ss
word=teschd);
System.out.println(... ccnnected);
Statement s = conn.createStatement();
s.close();
conn.close();
}
catch(SQLException e)
{
System.out.println(SQLException: + e.getMessage());
System.out.println(SQLState: + e.getSQLState());
System.out.println(VendorError: + e.getErrorCode());
}
}
}
Error-Msg:
register the Driver: OK
java.io.IOException: Connection timed out
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:56)
(some EXCeptions more)
SQLException: Cannot connect to MySQL server on 127.0.0.1:3306. Is there a
MySQL server running on the machine/port you are trying to connect to?
(java.io.IOException)
SQLState: 08S01
VendorError: 0
is there somebody who can help me?
thnx bobby
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: PostgreSQL
Sinisa Milivojevic [EMAIL PROTECTED] writes: Trond Eivind Glomsrød writes: On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: It's enabled in the MySQL rpms we distribute as part of RHL as well, but it's not the default type for created tables. Thus, most people won't be using it. If memory serves, you need to set various options in order to use it as well. I do not want to sound touchy, touchy, but that is as saying, that e.g. SyBase does not have replication everywhere, as you have to set it with various options. And SyBase has practically invented RDMBS replication, if my memory serves me well. There is a slight difference between advanced, non-standardized tuning/backup/load-balancing like that and core SQL functionality not being present. -- Trond Eivind Glomsrød Red Hat, 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
Re: PostgreSQL
Trond Eivind Glomsrød writes: Sinisa Milivojevic [EMAIL PROTECTED] writes: There is a slight difference between advanced, non-standardized tuning/backup/load-balancing like that and core SQL functionality not being present. -- Trond Eivind Glomsrød Red Hat, Inc. This depends on the definition. Where do you draw your definitions from ?? And core SQL functionlity that we speak about IS present. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: load data local ... security issue
But you could already read any file that the web server can read, if you can execute scripts which are run as the webserver. Only way to prevent that is suEXEC. How is this specific to MySQL? 1) Webserver must be able to read HTML files of every WebUsers 2) MySQL functions are called with uid, gid of Webserver 3) user1 gains access to /home/user2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: PostgreSQL
Sinisa Milivojevic [EMAIL PROTECTED] writes: Trond Eivind Glomsrød writes: Sinisa Milivojevic [EMAIL PROTECTED] writes: There is a slight difference between advanced, non-standardized tuning/backup/load-balancing like that and core SQL functionality not being present. This depends on the definition. Where do you draw your definitions from ?? And core SQL functionlity that we speak about IS present. Transactions are present, but not in the default table type (MyISAM). My understanding is that this will change in MySQL 4. -- Trond Eivind Glomsrød Red Hat, 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
Load_File issue
Hi, Now I am puzzled by the filepath,Load_file, I install MySQL in Windows98, the file which i want to insert to table is c:\P1.bmp when I run load_file in mysql command line,it succeeds mysql insert into blobtable (load_file(/P1.bmp)) but i don't know why i should use slash instead of backslash on windows. if i use the absolute path load_file(c:\P1.bmp), the blob field in table is NULL I also run insert into blobtable (load_file(/P1.bmp))in mysqlgui,it also insert null to table. i run this query in my Visual basic, same problem. _ Do You Yahoo!? µ½ÊÀ½ç±Ö÷Ì⹫԰ÍæÒ»Í棬ӮȡÊÀ½ç±ÃÅƱÀÖÒ»ÀÖ¡£ http://cn.worldcup.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB File Size
I'm using MySQL 4.0, trying to set up some innodb tables with several 20GB data files, but mysql is telling me that the files must be = 4096MB This is on a RedHat 7.2 box with redhat's 2.4.9-13 enterprise kernel on a reiserfs filesystem... I don't think there should be such a low limit...I accidentally made a 9GB log file the other day. Is this a limit of innodb? Is there somewhere I can adjust this limit? Thanks -Partap Davis Syncrasy, LLC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
having trouble killing mysqld to restart and change root password
Howdy, I'm trying to reset a forgotten password for a MySQL server, and I can't kill mysqld via the method mentioned in the documentation (or by any method for that matter). When I try using the command... kill 'cat /var/lib/mysql/mysqld.pid' ...I get a message saying that there is no such pid (although that's definitely the path specified for the pid when mysqld loads). I've also tried to kill it by running a ps -wax and killing these processes... 643 ?S 0:00 sh /usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/mysqld.pid 675 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - 709 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - 710 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - I'm not sure if all of these are processes that are actively running, but killing them apparently does nothing because I am unable to load mysqld again so that I can restart it using the --skip-grant-tables option. Can someone help me understand which of the pid's is the actual one, and how I can kill it? Thanks, JP - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Resolved: mysql_insert_id error
Though this is a PHP issue, for those that use PHP here's what was wrong: mysql_insert_id() requires your connection link identifier, which is what is returned from mysql_connect and mysql_pconnect. This is contrary to almost all other mysql_ functions, which want the result resource returned from your query. Hope this saves a few people some agony. # Nathan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Columns
Hey all, Is it possible to copy the contents of one column to another column using mySQL? I just changed my table structure by adding a few more columns and I need to be able to move the data from the original column to 4 new columns and then drop the orginial. I know that the proper query for sql is that I added with ALTER and remove with DROP. But I can't find anything that would allow me to move the data from one column to another. Anything I can do? Max - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: having trouble killing mysqld to restart and change root password
If you need to, use the kill -9 pid -9 is a definite kill and it will work -Original Message- From: JP Audette [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 2:52 PM To: [EMAIL PROTECTED] Subject: having trouble killing mysqld to restart and change root password Howdy, I'm trying to reset a forgotten password for a MySQL server, and I can't kill mysqld via the method mentioned in the documentation (or by any method for that matter). When I try using the command... kill 'cat /var/lib/mysql/mysqld.pid' ...I get a message saying that there is no such pid (although that's definitely the path specified for the pid when mysqld loads). I've also tried to kill it by running a ps -wax and killing these processes... 643 ?S 0:00 sh /usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/mysqld.pid 675 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - 709 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - 710 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - I'm not sure if all of these are processes that are actively running, but killing them apparently does nothing because I am unable to load mysqld again so that I can restart it using the --skip-grant-tables option. Can someone help me understand which of the pid's is the actual one, and how I can kill it? Thanks, JP - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Columns
On Wed, Feb 06, 2002 at 04:10:33PM -0500, Max Mouse wrote: Hey all, Is it possible to copy the contents of one column to another column using mySQL? I just changed my table structure by adding a few more columns and I need to be able to move the data from the original column to 4 new columns and then drop the orginial. I know that the proper query for sql is that I added with ALTER and remove with DROP. But I can't find anything that would allow me to move the data from one column to another. Anything I can do? Something like: UPDATE mytable SET col2 = col1, col3 = col1, col4 = col1, col5 = col1; perhaps? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 2 days, processed 105,996,493 queries (469/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: having trouble killing mysqld to restart and change root pass word
Ye, that did the trick. I was able to get the daemon restarted using the --skip-grant-tables option, however now I can't connect to the monitor. Typing in /usr/bin/mysql I just get a hung cursor. Same if I try using /usr/bin/mysql -h hostname mysql Anyone know why I can't get the monitor started? JP At 03:20 PM 2/6/2002 -0600, you wrote: If you need to, use the kill -9 pid -9 is a definite kill and it will work -Original Message- From: JP Audette [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 2:52 PM To: [EMAIL PROTECTED] Subject: having trouble killing mysqld to restart and change root password Howdy, I'm trying to reset a forgotten password for a MySQL server, and I can't kill mysqld via the method mentioned in the documentation (or by any method for that matter). When I try using the command... kill 'cat /var/lib/mysql/mysqld.pid' ...I get a message saying that there is no such pid (although that's definitely the path specified for the pid when mysqld loads). I've also tried to kill it by running a ps -wax and killing these processes... 643 ?S 0:00 sh /usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/mysqld.pid 675 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - 709 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - 710 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - I'm not sure if all of these are processes that are actively running, but killing them apparently does nothing because I am unable to load mysqld again so that I can restart it using the --skip-grant-tables option. Can someone help me understand which of the pid's is the actual one, and how I can kill it? Thanks, JP - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: having trouble killing mysqld to restart and change root pass word
Amendment to that last post I don't think the daemon is starting properly, because I can't run a mysqladmin version - I just get a hung cursor. Does anyone know if there's something that would be stopping mysqld from loading with the --skip-grant-tables option? When I do a ps I can see that it's definitely been started, but the fact that I can't do anything with mysqladmin makes me think that it hasn't loaded the way it needs to. JP Ye, that did the trick. I was able to get the daemon restarted using the --skip-grant-tables option, however now I can't connect to the monitor. Typing in /usr/bin/mysql I just get a hung cursor. Same if I try using /usr/bin/mysql -h hostname mysql Anyone know why I can't get the monitor started? JP At 03:20 PM 2/6/2002 -0600, you wrote: If you need to, use the kill -9 pid -9 is a definite kill and it will work -Original Message- From: JP Audette [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 2:52 PM To: [EMAIL PROTECTED] Subject: having trouble killing mysqld to restart and change root password Howdy, I'm trying to reset a forgotten password for a MySQL server, and I can't kill mysqld via the method mentioned in the documentation (or by any method for that matter). When I try using the command... kill 'cat /var/lib/mysql/mysqld.pid' ...I get a message saying that there is no such pid (although that's definitely the path specified for the pid when mysqld loads). I've also tried to kill it by running a ps -wax and killing these processes... 643 ?S 0:00 sh /usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/mysqld.pid 675 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - 709 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - 710 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - I'm not sure if all of these are processes that are actively running, but killing them apparently does nothing because I am unable to load mysqld again so that I can restart it using the --skip-grant-tables option. Can someone help me understand which of the pid's is the actual one, and how I can kill it? Thanks, JP - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: having trouble killing mysqld to restart and change root pass word
Ye, that did the trick. I was able to get the daemon restarted using the --skip-grant-tables option, however now I can't connect to the monitor. Typing in /usr/bin/mysql I just get a hung cursor. Same if I try using /usr/bin/mysql -h hostname mysql Anyone know why I can't get the monitor started? If you have to forcibly terminate mysql, you might want to run some integrity checks to make sure nothing's broken. This -might- be hanging your mysql client. Shut the server down, run myisamchk /var/lib/mysql/*.MYI and then restart it and try reconnecting. NOTE: The actual check command may vary depending on the MySQL version. If you need to, use the kill -9 pid -9 is a definite kill and it will work I'm trying to reset a forgotten password for a MySQL server, and I can't kill mysqld via the method mentioned in the documentation (or by any method for that matter). When I try using the command... kill 'cat /var/lib/mysql/mysqld.pid' ...I get a message saying that there is no such pid (although that's definitely the path specified for the pid when mysqld loads). I've also tried to kill it by running a ps -wax and killing these processes... 643 ?S 0:00 sh /usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/mysqld.pid 675 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - 709 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - 710 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - I'm not sure if all of these are processes that are actively running, but killing them apparently does nothing because I am unable to load mysqld again so that I can restart it using the --skip-grant-tables option. Can someone help me understand which of the pid's is the actual one, and how I can kill it? -- Michael Bacarella | 545 Eighth Ave #401 | New York, NY 10018 Systems Analysis Support | [EMAIL PROTECTED] Managed Services | 212 946-1038 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqld restarts automatically
On Wednesday 06 February 2002 12:15 am, you wrote: I am trying to find the problem but, error file shows stack trace ? which I could not understand. Bharat: Please follow the instructions in the manual section that the stack trace message is referring you to. This will tell you how to resolve the stack trace. ? I have upgraded mysql version to the latest one 2.23.47, thinking ? that might solve the problem. It might, if it does, do not worry about resolving the stack trace. ? ? ?Does any one know the reason why this is happens? ? ?please reply immediately. You can get the stack trace in two cases: a) there is something wrong with your system b) there is something wrong with MySQL But to be able to tell, we need to see the stack trace resolved according to the instructions. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
triming white space from a TEXT column
I am trying to trim both leading and trailing whitespace from a TEXT column in my SELECT query. I found the TRIM() command in the manual, however, I can't get it to act upon a column name instead of an actual string. Can anyone help? Thanks, Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: PostgreSQL
Whether or not the default table type is changed to InnoDB, in the spirit of the original poster's question, and what I think Sinisa is trying to get you to admit, transaction support is no longer one of the issues to consider when comparing MySQL to PostgreSQL. MySQL supports transactions *now*. Transactions everywhere is really a meanlingless comparison point. If anything, MySQL wins on this point. What if I don't want it everywhere? Point being, in MySQL you have a choice. That said, depending on your requirements, there are still compelling reasons to choose PostgreSQL - subselects, triggers, user defined types, etc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Trond Eivind Glomsrød Sent: Wednesday, February 06, 2002 3:15 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: PostgreSQL Sinisa Milivojevic [EMAIL PROTECTED] writes: Trond Eivind Glomsrød writes: Sinisa Milivojevic [EMAIL PROTECTED] writes: There is a slight difference between advanced, non-standardized tuning/backup/load-balancing like that and core SQL functionality not being present. This depends on the definition. Where do you draw your definitions from ?? And core SQL functionlity that we speak about IS present. Transactions are present, but not in the default table type (MyISAM). My understanding is that this will change in MySQL 4. -- Trond Eivind Glomsrød Red Hat, 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Extracting fields from a table
I want to select all entries in my table that in a column with given dates findes all dates inbetween $from_date - $to_date. (These are vars that the user supplies from the HTML-page). I don't know how to set up the SELECT query. I tried the following way but it didn't work: SELECT * FROM table WHERE (col=$from_date - col=$to_date) What is the correct way? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Extracting fields from a table
On Wednesday 06 February 2002 3:35 pm, Claire Forchheimer wrote: I want to select all entries in my table that in a column with given dates findes all dates inbetween $from_date - $to_date. (These are vars that the user supplies from the HTML-page). I don't know how to set up the SELECT query. I tried the following way but it didn't work: SELECT * FROM table WHERE (col=$from_date - col=$to_date) What is the correct way? This is, I believe, covered in the manual. However, try replacing (col=$from_date - col=$to_date) with (col=$from_date AND col=$to_date) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Starting Server
Greetings: I recently upgraded my MySQL server on a Linux box. When I try to start the server, it says started, then immediately it stops. The log file gumby.err reports: -- 020206 14:38:35 mysqld started /usr/local/libexec/mysqld: File './gumby-bin.1' not found (Errcode: 13) 020206 14:38:36 Could not use gumby-bin for logging (error 13) 020206 14:38:36 /usr/local/libexec/mysqld: Can't create/write to file '/usr/loc al/var/gumby.pid' (Errcode: 13) 020206 14:38:36 /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020206 14:38:36 /usr/local/libexec/mysqld: Error on delete of '/usr/local/var/g umby.pid' (Errcode: 13) 020206 14:38:36 mysqld ended --- Anyone have any ideas on how I should troubleshoot? Thanks Chris Mulcahy __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
