Re: Help somehow turn this into a single query
Ken writes: Query question: Can anyone think of a way to accomplish this in a single query?: I have a table with elements that each have a date. For a given record, I want to get, in one query, the record just earlier than this record's date, and the record just later than this record's date. Do it in two queries or be prepared to take a performance hit. Honestly I can't even think of a way to do it with just one query, but looking into using SQL variables might help. I'm not sure, though. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RPM or SourceCode ???
Hi all I was just getting thru the documentation of MySQL at the mysql.com site and there it is specified that The recommended way to install MySQL on Linux is by using an RPM file Can anyone tell me in what way it is different installing mysql from the rpm's and from the source code ?? except that if we install from the source code it is a bit tedious where as with the rpm it is convineint. Are there any reasons other than this ?? i for one feel that installing from the source gives us a lot of options and flexibility thanx in advance. cheers !! Nilesh Parmar [EMAIL PROTECTED] Wrox Press - Programmer to Programmer((tm)) http://www.wrox.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
admin password
Hi all, How can I retrieve mysql admin password if I forget it?? Rgds, unplug - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 deadlock situation - possible bug
On Thu, Sep 06, 2001 at 04:35:57PM -0700, Aaron Brick wrote: good day - i have found cases in which the daemon blocks waiting on a select() and just plain refuses to process certain queries. since i am reading in a 60 meg file, meaning about 3.5 million queries, this consistently happens somewhere in the middle. i am using 3.23.41. restarting the server or rebooting the machine don't seem to affect the problem. i don't know what the daemon is waiting for - can i do some useful analysis with strace and lsof? if this is a bug, i would love to contribute a report of it. any suggestion is welcome; i'm really puzzled! Report the bug using the instructions in the manual: http://www.mysql.com/doc/B/u/Bug_reports.html and it'll get fixed if it's a repeatable bug. 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 1 days, processed 16,673,032 queries (176/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: stability of replication?
On Thu, Sep 06, 2001 at 12:36:12PM -0700, Duc Chau wrote: I just wanted to know how stable is mysql databse replication is? What we have in mind is a tiered system. $master (california)-(internet ssh tunnel) \$slave (texas) 10 other slave machines on the same network (running 5 separate db per machine) \$slave (san fransisco) 10 other slave machines on the same network (running 5 separate db per machine) \$slave (new york) 10 other slave machines on the same network (running 5 separate db per machine) How fesible would this be? From an architectural standpoint, it will work. I'm not sure what you mean by running 5 separate db per machine, though. and has anyone worked with replication on a large scale? In terms of the number of slaves, or the distance between them? We have some West Coast (USA) -- East Cost replication happening, and it works rather well. The number of slaves won't be a problem. I've not run 10 at a time yet, but slaves really aren't much of a drain on the master. We're dealing with 2500 tables about 65k total records Read/Write to the master will be like 50 per second How many of those 50 are writes? Any input or links to documentation is much appreciated. Other than the replication docs in the manual, I can't suggest much else. But if you find stuff that needs to be added, speak up. :-) 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 1 days, processed 17,193,429 queries (179/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: Expiring Binary Logs
On Wed, Sep 05, 2001 at 01:33:03PM -0700, A. Clausen wrote: I've been running a master/slave MySQL database system for about four months now and I've got nearly 360mb of binary logs. I want to archive anything over about a month old, but I've heard that there is a procedure that you have to go through to do that. PURGE LOGS: http://www.mysql.com/doc/R/e/Replication_SQL.html 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 1 days, processed 17,549,424 queries (181/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: Slow replication question/problem
On Wed, Sep 05, 2001 at 03:43:00PM -0500, Jeff Adams wrote: Greetings, This morning we sucessfully inserted a new record on our master MySQL machine. 4 1/2 hours later, the change showed up on the slaves. I was under the impression that MySQl replication would occur in a more timely fashion. Well, that's a bit slower than what I'm used to. :-( I'm not really sure where to start looking, so please let me know if there's anything I can provide that would shed some light on this. Are subsequent inserts just as slow to replicate? Can you show us the output of SHOW SLAVE STATUS and maybe the my.cnf files of the master and a slow slave? 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 1 days, processed 17,678,406 queries (182/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: mysqlbug
On Thu, Sep 06, 2001 at 06:08:00PM +0800, Chun-Hung Chen wrote: When configuring mysql, some errors happened.The report of config.log and error messages are listed below.The environment I use is Sun Solaris 8(SunOS 5.8) with gcc 2.95.3. [snip] configure:2376: checking return type of sprintf == error message: checking return type of sprintf... configure: error: can not run test program while cross compiling Where is GCC installed? Try using LD_LIBRARY_PATH=/usr/local/lib in your environment (or whatever path is appropriate). It fixed it for me on Solaris 2.8 with GCC 2.95.3. There was a thread about 1-2 weeks ago on the mailling list about it. 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 1 days, processed 17,353,292 queries (180/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
CRM system using MySQL?
I'm looking for a simple CRM (adresses / contacts / orders) system using MySQL as a back-end. If anyone on this list has developed (or have knowledge of) a system with the following requirements, please drop me a message. - MySQL *must* be the backend (for integration w/ other company data) - Preferably web-based using PHP or Perl, but a Win 9x / NT client capable of connecting to a remote host is also acceptable - Open source (not necessarily GPL, but we must be able to fiddle with the code and/or database layout) - Very small learning curve (will be used by people with next to no computer experience). Thanks for any input you may have. Carsten H. Pedersen -- Natural selection saw to it that professional heroes who at a crucial moment tended to ask themselves questions like What is my purpose in life? very quickly lacked both. -- (Terry Pratchett, Interesting Times) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Corrupted tables -- for 'no apparent' reason
Hello, We are using mySQL on over 6 servers here, we have been doing so for over 2 years, and we are constaly facing problems with corrupted tables, especially on two of our busiest servers. Tables seem to corrupt out of the blue and we have to shut them down ( the servers ) occassionaly to fix all tables and then bring them up again. This is really not something we want to do, bringing down a server that is, so we were wondering if we are doing something wrong. There must be other users of mySQL using it for far most difficult tasks who maybe faced the same problems once but managed to solve them. We are using mySQL 3.23.41. Tables corruptions occur regardless the server's configuration ( even on a system with PIII@1MhzX2 with 1.5G RAM we get those problems ) so maybe there is something wrong with the startup options we are using for mySQLd. This is how we start mySQLd. --skip-locking -O back_log=1024 -O table_cache=280 -O max_connections=2048 -O wait_timeout=30 -O interactive_timeout=30 -O long_query_time=2 --log-slow-queries=slow.log --big-tables Please reply to [EMAIL PROTECTED] Thank you in advance, Mark Papadakis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: List of aggregate functions? (aggregate concat?)
On Thu, Sep 06, 2001 at 12:40:16PM -0700, xris wrote: I was just browsing through the searchable online MySQL manual, trying to find a list of the aggregate functions (as I don't trust the list in the O'Reilly book, considering the number of typos and missing information in other sections), and couldn't find anything.. Yeah, that book is pretty bad. And the folks at O'Reilly know it. They're finally working on a book to replace it. (Amusingly, they weren't interested a year or so ago when I talked to them about it.) Is there a list in the manual? If not, someone should really think of adding a section to the Functions area to list out all of the aggregate ones. Probably a good idea if they aren't already clearly labeled in the manual. On that note, I'm curious if there is an aggregate version of CONCAT or CONCAT_WS (and if there isn't, make a suggestion for the creation of them). Something like join() in Perl, maybe? I'm not sure quite what you're looking for. Can you give an example of where/how you'd use it? It might also be nice for whoever writes the manual to include the minimum MySQL version supporting the function (my ISP is still using 3.22 and it's annoying to learn of a cool function only to find out that it doesn't work when I try it)... That's in the manual sometimes, and sometimes not. What you really need is the manual that comes with the 3.22 distribution. Then you won't have that problem. What you really need to do is get your ISP to jump into the year 2001 and upgrade. But you already knew that. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 1 days, processed 18,181,878 queries (186/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: Corrupted tables -- for 'no apparent' reason
On Fri, Sep 07, 2001 at 10:29:31AM +0300, Mark Papadakis wrote: Hello, We are using mySQL on over 6 servers here, we have been doing so for over 2 years, and we are constaly facing problems with corrupted tables, especially on two of our busiest servers. Tables seem to corrupt out of the blue and we have to shut them down ( the servers ) occassionaly to fix all tables and then bring them up again. What Operating System? We are using mySQL 3.23.41. Tables corruptions occur regardless the server's configuration ( even on a system with PIII@1MhzX2 with 1.5G RAM we get those problems ) so maybe there is something wrong with the startup options we are using for mySQLd. This clearly shouldn't be happening. What table formats are you using? ISAM? MyISA? InnoDB? 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 1 days, processed 18,317,521 queries (186/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem with count (*) max (*) min (*)
I'm trying to do select count (*) from table. but it doesn't work ERROR 1064: You have an error in your SQL syntax near '(*) from pendientes' at line 1 Same happens with max (column) and min (column). Do I have to install anything else or is something wrong. I'm using redhat 7.0 with the mysql that comes with this distribution - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with count (*) max (*) min (*)
On Fri, Sep 07, 2001 at 09:28:28AM +0200, Antonio Ortega Sancho wrote: I'm trying to do select count (*) from table. but it doesn't work ERROR 1064: You have an error in your SQL syntax near '(*) from pendientes' at line 1 Same happens with max (column) and min (column). Do I have to install anything else or is something wrong. I'm using redhat 7.0 with the mysql that comes with this distribution Try count(*), max(column) and min(column). It probably doesn't accept the space you put in between there. Greetz, Peter -- Monopolyhttp://www.dataloss.nl/monopoly.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with count (*) max (*) min (*)
Antonio Ortega Sancho writes: I'm trying to do select count (*) from table. but it doesn't work Try count(*) instead. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with count (*) max (*) min (*)
On Fri, Sep 07, 2001 at 09:28:28AM +0200, Antonio Ortega Sancho wrote: I'm trying to do select count (*) from table. but it doesn't work ERROR 1064: You have an error in your SQL syntax near '(*) from pendientes' at line 1 Same happens with max (column) and min (column). No space allowed after the function and the parens: Bad Good --- MIN (foo)MIN(foo) MAX (foo)MAX(foo) COUNT (*)COUNT(*) 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 1 days, processed 18,902,837 queries (190/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: index not incrementating
On Thu, Sep 06, 2001 at 10:44:28AM -0700, Duc Chau wrote: Hi, can someone tell me how the index number on the bin logs are incremented? They are incremented by adding one to the extension. 001 - 002 - 003 - 004 and so on. When i update my master machine the changes are still going to $machine-name-bin.001 update in what way? on my slave its looking for Log_file $machine-name-bin.002 The slave is expecting .002 on the master? Or is the slave also logging to a binary log of its own, but with a different name? can someone tell me how these number are incremented? the .00# how often, what causes them to increment? Causes: * Server Restart * FLUSH LOGS * The current log hits the max log size (in my.cnf) There may be others, but those jump to mind. also another question is: what happends when the slave machine is rebooted? when it (slave) comes back up does the slave update the database with all the inserts, deletes that happended in the time it took to boot up? Yes, it catches up. I tried rebooting the slave and updating the master and when the slave came back up it was just in a state of waiting for new changes...it did not populate the missing data. Did i do something wrong? Maybe you did something wrong, yes. It normally works. Did you check the error log on the slave to see what (if anything) happened? 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 1 days, processed 18,969,193 queries (191/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
MySQLGUI question
I have a couple questions regarding MySQLGUI: 1. Where is the documentation located? Help only offers 'about', and I am unable to find any docs on the mysql.com website. 2. How does one execute multiple commands at the same time? I know in Microsoft SQL Enterprise manager, you seperate the lines with a ; and a go, and it goes. this isn't working for me here. Thanks for your time, Edward Beheler __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.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
A question about load / queries pr second
I have a HP-UX server with Perl 5.005_03, MySQL 3.23.39 for hp-hpux11.00 (hppa2.0w), Apache/1.3.20. The load are rather high, and Queries per second avg: 94.859 This is an local B2B installation som we are really not getting any traffic between 4PM and 7AM We have peeks where there is more than 1000 Queries per second. Does anyone have any experience with a higher number of queries pr second than this ? Regards Terje K - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: A question about load / queries pr second
On Fri, Sep 07, 2001 at 10:11:30AM +0200, Terje Kristensen wrote: We have peeks where there is more than 1000 Queries per second. Does anyone have any experience with a higher number of queries pr second than this ? About a year ago, I used mysql-super-smack and was able to hit 8,000 per second on our [then new] server. The highest I've recorded on an actual production application was around 5,000. But I don't watch the numbers closely very often... 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 1 days, processed 19,864,213 queries (196/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
Running_Threads problems
Hi, I have a big problem, the Running_Threads are very often too high (max_connections is 100) and of course mysql crash with too much connections ! All php3 requests begin with mysql_connect and finish by mysql_close, our ASP said max_conection is enough high and problem is elsewhere. We verify our request and don't find anything, ditto in mysql logs... Threads seem to live too long...How see their details and what resquest can be responsable ? Processlist show us number of thread but not details Help please !!! Ludovic - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[ccs@voice.co.za: ]
Hi, a snippet from a session on a linux box running standard mysql client (2.23.33): mysql update members_p set newscode='1' where ID='640103502408'; Query OK, 0 rows affected (0.00 sec) mysql update members_p set newscode='1' where ID='640103502408'; Query OK, 1 row affected (0.01 sec) All I did for the second update command, was press up, enter. Why did the first command return 0 rows affected? Anyone seen this before/know if it is the client or the server causing it? thanks, -- Campbell - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: A question about load / queries pr second
About a year ago, I used mysql-super-smack and was able to hit 8,000 per second on our [then new] server. The highest I've recorded on an actual production application was around 5,000. But I don't watch the numbers closely very often... Just out of curiosity, on what hardware? My needs are much lower than this, but my management may get worried about what we might, just possibly, need in the future. If I can explain that MySQL will stretch far beyond our conceivable needs, it would help pacify a hardware-oritented management who tend to favour software suppliers they hear about on the financial pages (i.e. M$ or Oracle, in this case). Alec - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with count (*) max (*) min (*)
It would appear that you are putting spaces between Count and the bracket which as far as I can tell will not work hence try count(*) etc... Chris Thorpe - Original Message - From: Antonio Ortega Sancho [EMAIL PROTECTED] To: Mysql (E-mail) [EMAIL PROTECTED] Sent: Friday, September 07, 2001 8:28 AM Subject: problem with count (*) max (*) min (*) I'm trying to do select count (*) from table. but it doesn't work ERROR 1064: You have an error in your SQL syntax near '(*) from pendientes' at line 1 Same happens with max (column) and min (column). Do I have to install anything else or is something wrong. I'm using redhat 7.0 with the mysql that comes with this distribution - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql SQL
hi all, i have a question. i would like to know if mysql has a sql'x' standard. my problem is that i would like to use UNION or MINUS or... but it seems not to work, another problem is that i would like to make some nested query. by thanks in advance. Giovanni - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: A question about load / queries pr second
On Fri, Sep 07, 2001 at 09:54:35AM +0100, [EMAIL PROTECTED] wrote: About a year ago, I used mysql-super-smack and was able to hit 8,000 per second on our [then new] server. The highest I've recorded on an actual production application was around 5,000. But I don't watch the numbers closely very often... Just out of curiosity, on what hardware? My needs are much lower than this, but my management may get worried about what we might, just possibly, need in the future. If I can explain that MySQL will stretch far beyond our conceivable needs, it would help pacify a hardware-oritented management who tend to favour software suppliers they hear about on the financial pages (i.e. M$ or Oracle, in this case). This was Linux 2.2.x on a dual-cpu P3-850 with 1GB of RAM and 5 36GB SCSI disks. Most of the time, our busy hours run around 300-600 queries per second, with non-peak times being in the 50 queries per second ball-park. But as each month goes by, the numbers keep increasing. Luckily, we've got a lot of room to grow. 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 1 days, processed 20,918,186 queries (202/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: command line open source ARRRGGGGGG!!!!!!
Chadrick Mahaffey wrote: what does all this mean? I tried to type this in my command console changin / to \ and I don't understand what is happening. I get all kinds of errors. It looks to me that you're trying to use the Unix install notes - don't! Refer to section 2.1.2 in the excellent manual, (worth downloading so you've a local copy). Open source would go much farther if they had self explanatory GUIs and had basic pre-setup apps that were ready for the average user to use. Why? Maybe I'm really offbeam, but I'd suggest that MySQL is more of a server product than one which should reside on the desktop. Further, why then saddle the server admin with a GUI. In my experience even the best GUI is not as flexible as a half-decent command line installer. A GUI is fine if you've to install on just your PC, but there's no way I'd be happy if I was doing multiple installs - at least with the command line you can make a small (one-line?) batch file to do the job on however many systems you have. I could be mean and turn this on it's head - if you want a GUI, do it yourself and then contribute it back! Most open source apps I have attempted to use have some of the worse documentation around. The writers assume so much about the users. You've been very unlucky then. Nearly all the major apps, (and most of the smaller ones), have excellent docs, simply because the vocal user community wouldn't let them away with anything else! (If you don't like a bit in the manual rewrite it and submit it back ?) That said, I will agree slightly in that some of the app docs are very Unix-centric (not MySQL's), and I personally find the Apache manual a bit hard to use. For your core apps it's probably worth getting one of the 3rd party books, (the MySQL one is very good indeed). OK - call me inept, stupid, or whatever but I had to say it. Fair enough - you're stupid! ;-) Quote for you real stupidity is quite rare, (except in politicians where it seems to be a qualification), and what is generally perceived as 'stupidity' is nothing more than inexperience, can't remember who to attribute this to, but it seems pretty apposite. As to MySQL I'm just past the caveman stage myself. Keep in there and it'll all fall into place, (with a bit of help from this mailing list), and then who knows? Regards Bob Cross - writing for myself in this instance * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: A question about load / queries pr second
Hello Terje, Friday, September 07, 2001, 12:11:30 PM, you wrote: TK I have a HP-UX server with Perl 5.005_03, MySQL 3.23.39 for hp-hpux11.00 TK (hppa2.0w), TK Apache/1.3.20. TK The load are rather high, and Queries per second avg: 94.859 TK This is an local B2B installation som we are really not getting any traffic TK between 4PM and 7AM TK We have peeks where there is more than 1000 Queries per second. TK Does anyone have any experience with a higher number of queries pr second TK than this ? There can be lot of queries such as 'SELECT 1' which won't actually make high CPU load on server and there can be few queries with several joins without using keys which can almost kill the server. It depends. I have server which handles about 300-400 queries per second and serves for ~30 websites. TK Regards TK Terje K TK - TK Before posting, please check: TKhttp://www.mysql.com/manual.php (the manual) TKhttp://lists.mysql.com/ (the list archive) TK To request this thread, e-mail [EMAIL PROTECTED] TK To unsubscribe, e-mail [EMAIL PROTECTED] TK Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Best regards, Vinchemailto:[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
information about deiferences oracle/mysql
Hi guys, I'm just a student, working on a project. We have to migrate a oracle database to MySQL. In order to do that we must search for diferences between the two and for other information that can help us. (of course we're not allowed to just download software and convert) Now, I've allreaddy searched for 1,5 days but I only find, or to technical, or to extended or whatever, I can't vind what I'm seraching for. I hope that you could help me verther with links, or some critical information. Regards Johannes _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: A question about load / queries pr second
Hello, I saw your message on the list, could you tell me which scripting language you are using (php, perl, java ?) and if you have the time could you show me your my.cnf and the result of a show variable request ? I am experiencing problem with 100% CPU load and can't figure what it is ? Thanks in advance, Jerome -Message d'origine- De : Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Envoye : vendredi 7 septembre 2001 11:05 A : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; [EMAIL PROTECTED] Objet : Re: A question about load / queries pr second On Fri, Sep 07, 2001 at 09:54:35AM +0100, [EMAIL PROTECTED] wrote: About a year ago, I used mysql-super-smack and was able to hit 8,000 per second on our [then new] server. The highest I've recorded on an actual production application was around 5,000. But I don't watch the numbers closely very often... Just out of curiosity, on what hardware? My needs are much lower than this, but my management may get worried about what we might, just possibly, need in the future. If I can explain that MySQL will stretch far beyond our conceivable needs, it would help pacify a hardware-oritented management who tend to favour software suppliers they hear about on the financial pages (i.e. M$ or Oracle, in this case). This was Linux 2.2.x on a dual-cpu P3-850 with 1GB of RAM and 5 36GB SCSI disks. Most of the time, our busy hours run around 300-600 queries per second, with non-peak times being in the 50 queries per second ball-park. But as each month goes by, the numbers keep increasing. Luckily, we've got a lot of room to grow. 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 1 days, processed 20,918,186 queries (202/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Optimization question and possible bug
Hi, i'm using MySQL 3.23.37 on a Linux system with an average of about 20 queries/second. First of all i have a little question how i can optimize a query. The query is like that: select * from tbl where key_field1 constant1 and key_field2 constant2 Examine that query with explain select... show that the indexes are not used. The keyfields are unsigned tiny int where every bit has a different meaning. Any clue how i can rewrite this query in a way where the indexes are used? In the database i have a merge-table that merges 10 myisam tables. Sometimes the loadaverage of the system raise above 50 and the long-query-log is filled with some query accessing the merge table. This happens 2-3 times a day. Only a minute later everthing is okay again without doing anything. I can't believe that it is a performance problem because there is a summary of only 10,000 entries in the merge table and 50,000 entries in other tables. Does anybody experienced this strange problem, too? The last thing i found is a possible bug in merge-table implementation of 2.23.41. After an update from 2.23.37 to 2.23.41 i got only the first row of the result set again and again. Maybe it's a communication problem between php (with included mysql interface) and the new MySQL version. (Haven't determined it yet). Thanks St. Pinkert - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: A question about load / queries pr second
Hi, About a year ago, I used mysql-super-smack and was able to hit 8,000 per second on our [then new] server. The highest I've recorded on an actual production application was around 5,000. But I don't watch the numbers closely very often... Just out of curiosity, on what hardware? This was Linux 2.2.x on a dual-cpu P3-850 with 1GB of RAM and 5 36GB SCSI disks. I'm quite surprised that this level of performance is available from such standard (well, not standard as in 'common', but y'know what I mean...) hardware. The last I heard, 1K+ queries/sec was only being done on extremely high-end Sun enterprise-level machines. On the other hand though, it gives me some comfort that the hardware being used in my operation will meet any future needs. We have similar spec servers (P3-1Ghz dual-cpu, 512Mb RAM, 3x36Gb SCSI RAID5). Maybe I should try out mysql-super-smack and see what kind of numbers it turns up. :-) Regards, Basil Hussain --- Internet Developer, Kodak Weddings E-Mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: A question about load / queries pr second
On Fri, Sep 07, 2001 at 12:07:07PM +0100, Basil Hussain wrote: I'm quite surprised that this level of performance is available from such standard (well, not standard as in 'common', but y'know what I mean...) hardware. The last I heard, 1K+ queries/sec was only being done on extremely high-end Sun enterprise-level machines. Yeah, they *were* almost all read queries... On the other hand though, it gives me some comfort that the hardware being used in my operation will meet any future needs. We have similar spec servers (P3-1Ghz dual-cpu, 512Mb RAM, 3x36Gb SCSI RAID5). Maybe I should try out mysql-super-smack and see what kind of numbers it turns up. :-) It would be interesting. We've just finished some upgrades here (thus the recent low uptimes in my signature). Brought out Linux boxes up to 2.4.9 and 2GB of RAM. Had a lot of problems with 2.4.9's brain-dead VM subsystem, so I disabled swap and things are A LOT better now. We're on ReiserFS now and have software RAID running on one box to test it out. 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 1 days, processed 25,090,103 queries (225/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: Problem with paswords
Any ideas? /Mattias Hi! I've just installed (a couple of days ago) mysql. I will use mysql for using with hlstats. That is a stats-program for HalfLife Counter Strike. (game) But I got errors... I guess it's a problem with mysql or me not knowing how to do it. Here is some printouts what I'm trying to do: mysql select host,user,password from user; +---+-+--+ | host | user| password | +---+-+--+ | localhost | root| 378b243e220ca493 | | h21n1fls21o70 | root| 378b243e220ca493 | | % | hlstats | 71e5e1e45222b9c4 | +---+-+--+ 3 rows in set (0.01 sec) mysql SET PASSWORD FOR 'hlstats'@'%' = PASSWORD('test'); Query OK, 0 rows affected (0.00 sec) (nothing changed but look att password below) mysql select host,user,password from user; +---+-+--+ | host | user| password | +---+-+--+ | localhost | root| 378b243e220ca493 | | h21n1fls21o70 | root| 378b243e220ca493 | | % | hlstats | 378b243e220ca493 | +---+-+--+ 3 rows in set (0.00 sec) mysql quit Bye bash-2.05# mysql --user=hlstats --password=test mysql ERROR 1045: Access denied for user: 'hlstats@localhost' (Using password: YES) (This below look strange) bash-2.05# mysql --user=hlstats mysql ERROR 1044: Access denied for user: '@localhost' to database 'mysql' The same on db hlstats: (which is the one I want to access) bash-2.05# mysql --user=hlstats --password=test hlstats ERROR 1045: Access denied for user: 'hlstats@localhost' (Using password: YES) The error from the browser: (php accessing mysql) - Warning: MySQL Connection Failed: Access denied for user: 'hlstats@localhost' (Using password: YES) in /usr/local/cs/stats/hlstats/hlstatsinc/db.inc on line 65 ERROR Database Error Server Address: localhost Server Username: hlstats Error Diagnostic: Could not connect to database server. Check that the values of DB_ADDR, DB_USER and DB_PASS in hlstats.php are set correctly. Server Error: () Last SQL Query: - I've asked in the hlstats-forum with no luck. Any help is welcome! If you want more info, I'll give it to you! Thanks! :o) /Mattias - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
There is no function INDEX used in example
Description: There is in manual_Problems.html: That means that if you search with col_name LIKE 'a%', you will get all column values that start with A or a. If you want to make this search case-sensitive, use something like INDEX(col_name, A)=0 to check a prefix. Or use STRCMP(col_name, A) = 0 if the column value must be exactly A. But there is no function INDEX in mysql. How-To-Repeat: See manual_Problems.html Fix: There should be something like LOCATE(A, col_name)=1. Submitter-Id: submitter ID Originator:Hans Ginzel Organization: MFF UK http://www.matfyz.cz/hans/ MySQL support: none Synopsis: There is no function INDEX used in example in manual Severity: non-critical Priority: low Category: mysql Class: doc-bug Release: mysql-3.23.36 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.18 Distrib 3.23.36, for pc-linux-gnu on i586 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.36 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 1 hour 11 min 0 sec Threads: 2 Questions: 86 Slow queries: 2 Opens: 18 Flush tables: 1 Open tables: 12 Queries per second avg: 0.020 Environment: Debian Linux Woody System: Linux geze 2.2.19-iiide #2 SMP Mon May 21 09:31:10 CEST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20010319 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer -g' CXX='g++' CXXFLAGS='-O2 -fomit-frame-pointer -g -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 kvì 27 19:46 /lib/libc.so.5 - libc.so.5.4.46 -rw-r--r--1 root root 589460 bøe 19 14:47 /lib/libc.so.5.4.46 lrwxrwxrwx1 root root 13 srp 20 22:36 /lib/libc.so.6 - libc-2.2.3.so -rwxr-xr-x1 root root 1155720 èec 27 22:42 /lib/libc-2.2.3.so -rw-r--r--1 root root 2579358 èec 25 17:15 /usr/lib/libc.a -rw-r--r--1 root root 178 èec 25 17:15 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innobase --enable-static --enable-shared --with-raid --without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --with-extra-charsets=all - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql-doc.thml, duplication in INSERT syntax
Description: There is duplication in the syntax of INSERT. Last version is special case of the second. INSERT [LOW_PRIORITY | DELAYED] [IGNORE] [INTO] tbl_name [(col_name,...)] VALUES (expression,...),(...),... or INSERT [LOW_PRIORITY | DELAYED] [IGNORE] [INTO] tbl_name [(col_name,...)] SELECT ... or INSERT [LOW_PRIORITY | DELAYED] [IGNORE] [INTO] tbl_name SET col_name=expression, col_name=expression, ... or INSERT [LOW_PRIORITY] [IGNORE] [INTO] tbl_name SELECT ... How-To-Repeat: See manual_Reference.html#INSERT Fix: Remove the last version Submitter-Id: submitter ID Originator:Hans Ginzel Organization: MFF UK http://www.matfyz.cz/hans/ MySQL support: none Synopsis: mysql-doc.thml, duplication in INSERT syntax Severity: non-critical Priority: low Category: mysql Class: doc-bug Release: mysql-3.23.36 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.18 Distrib 3.23.36, for pc-linux-gnu on i586 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.36 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 59 min 3 sec Threads: 2 Questions: 84 Slow queries: 2 Opens: 18 Flush tables: 1 Open tables: 12 Queries per second avg: 0.024 Environment: Debian Linux Woody System: Linux geze 2.2.19-iiide #2 SMP Mon May 21 09:31:10 CEST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20010319 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer -g' CXX='g++' CXXFLAGS='-O2 -fomit-frame-pointer -g -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 kvì 27 19:46 /lib/libc.so.5 - libc.so.5.4.46 -rw-r--r--1 root root 589460 bøe 19 14:47 /lib/libc.so.5.4.46 lrwxrwxrwx1 root root 13 srp 20 22:36 /lib/libc.so.6 - libc-2.2.3.so -rwxr-xr-x1 root root 1155720 èec 27 22:42 /lib/libc-2.2.3.so -rw-r--r--1 root root 2579358 èec 25 17:15 /usr/lib/libc.a -rw-r--r--1 root root 178 èec 25 17:15 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innobase --enable-static --enable-shared --with-raid --without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --with-extra-charsets=all - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql installation on NT problem
hi all ! i am new to mysql and trying to install it onto my win NT 4.0 workstation. but the winzip is not able to install it ! is anybody else facing the same prob? does anybody know the cure? sumit - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 installation on NT problem
Hi, Try to extract the files before running setup.exe. If this does not work you zip archive may be corrupt. Regards, Antonie -- S C I B I T -- Antonie Neethling ([EMAIL PROTECTED]) http://www.scibit.com/mysql - MySQL related products -- S C I B I T -- -Original Message- From: Sumit Ranjan [mailto:[EMAIL PROTECTED]] Sent: Friday, September 07, 2001 1:40 PM To: [EMAIL PROTECTED] Subject: mysql installation on NT problem hi all ! i am new to mysql and trying to install it onto my win NT 4.0 workstation. but the winzip is not able to install it ! is anybody else facing the same prob? does anybody know the cure? sumit - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Mac 10.0.4 3.23.41 Grief
Jeshua Lacock writes: Hello all, I have searched the archives and found various suggestions and tired them (and variations of them) and I cannot get mysqld running on Mac OS 10.0.4 (Darwin 1.3.7). I had previously built and run 3.23.39 on the same machine, but I cannot get 3.23.41 running - it built and installed apparently okay. This is what I did: make install mysql_install_db chown -R mysql.70 /usr/local/var cd /usr/local; ./bin/safe_mysqld And mysqld quits without any fuss. So I read the 'localhost.err' logs and it says: 010906 18:42:12 mysqld started /usr/local/libexec/mysqld: File './localhost-bin.1' not found (Errcode: 13) 010906 18:42:12 Could not use localhost-bin for logging (error 13) 010906 18:42:12 bdb: architecture lacks fast mutexes: applications cannot be threaded 010906 18:42:12 Can't init databases 010906 18:42:12 mysqld ended So I looked and I looked in '/usr/local/var' and I have a file called localhost-bin.001 not localhost-bin.1 . I tried making a symbolic link from localhost-bin.001 - localhost- bin.1, and I still get the same error. I also tried: /usr/local/libexec/mysqld -u mysql --skip-grant-tables And I get the same error that is in the log file. I am sure it must be something really simple, but I have been trying everything I can think of for an embarrassing amount of time, and I do not no what to try next. Any help or advice would be greatly appreciated! Thanks, Jeshua Lacockhttp://OpenOSX.com Programmer/Owner http://SierraMaps.com Phone: (760) 935-4736http://3dTopoMaps.com BDB will not yet run on your OS, so you should start mysql with --skip-bdb. -- 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
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
Hello, I am running version 3.23.41 on windows '98. When I run winipcfg I show that my hostname is siren.goldengate.net and my ip address is 10.0.0.1. When I type c:\mysql\bin mysql I get an error message: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) I tried several versions of -h switch: mysql -h siren.goldenget.net mysql -h localhost mysql -h siren but no luck. After much playing around with the scripts located in c:\mysql\bin I noticed that c:\mysql\bin mysqld-opt starts the daemon and then allows me to run c:\mysql\bin mysql to get in. I then need to run c:\mysql\bin winmysqladmin to shut down the server. This works for me now but I'm not sure if it will cause problems later. I can't tweak any of the scripts in c:\mysql\bin so not sure what other options I have. Is there a better approach than this kind of work around? 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
Trying to build MySQL super-smack - failing...
Hi all, I'm trying to build the MySQL super-smack benchmarking tools. I'm getting the following errors on make: make all-recursive make[1]: Entering directory `/root/rpms/super-smack-1.0' Making all in src make[2]: Entering directory `/root/rpms/super-smack-1.0/src' c++ -DHAVE_CONFIG_H -I. -I. -I.. -g -O2 -c client.cc c++ -DHAVE_CONFIG_H -I. -I. -I.. -g -O2 -c die.cc die.cc: In function `void die (int, char *, ...)': die.cc:25: `exit' undeclared (first use this function) die.cc:25: (Each undeclared identifier is reported only once for each function it appears in.) make[2]: *** [die.o] Error 1 make[2]: Leaving directory `/root/rpms/super-smack-1.0/src' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/root/rpms/super-smack-1.0' make: *** [all-recursive-am] Error 2 This is on a standard Red Hat 7.0 install and I have read the comment about gcc in the INSTALL file, but I thought making sure that I have the latest version of gcc (gcc-2.96-85), rather than downgrading to 2.95, would suffice. Is this the problem, or something else? Regards, Basil Hussain --- Internet Developer, Kodak Weddings E-Mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQLGUI question
Edward Beheler writes: I have a couple questions regarding MySQLGUI: 1. Where is the documentation located? Help only offers 'about', and I am unable to find any docs on the mysql.com website. 2. How does one execute multiple commands at the same time? I know in Microsoft SQL Enterprise manager, you seperate the lines with a ; and a go, and it goes. this isn't working for me here. Thanks for your time, Edward Beheler 1. With any of our distro's comes a bunch of text files which can be read. Read a file MySQL.help and all readme's. 2. No, MySQLGUI executes one command at a time. You could, however, open as many spreadsheets with result sets as you wish. You can also run multiple admin commands if you open 1 or more administration panels. -- 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
Make new tables on top of old ones
I need to make about 15 tables that use the same template as the first one. Please help. - Deryck H - http://www.comp-u-exchange.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: A question about load / queries pr second
Basil Hussain writes: Hi, I'm quite surprised that this level of performance is available from such standard (well, not standard as in 'common', but y'know what I mean...) hardware. The last I heard, 1K+ queries/sec was only being done on extremely high-end Sun enterprise-level machines. On the other hand though, it gives me some comfort that the hardware being used in my operation will meet any future needs. We have similar spec servers (P3-1Ghz dual-cpu, 512Mb RAM, 3x36Gb SCSI RAID5). Maybe I should try out mysql-super-smack and see what kind of numbers it turns up. :-) Regards, Basil Hussain --- Internet Developer, Kodak Weddings E-Mail: [EMAIL PROTECTED] On one of our registered customer computers we obtained over 4000 queries per second, sustained over several weeks. Hardware : Sun with 4 CPU @ 400 MHz, 4 G RAM, RAID 1+0. -- 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: About MYSQL APIs
Ai2s, Proyecto writes: Hi, I'm making an application on C++Builder5, which will be comunicated with MYSQL server , What do you MYSQL API recomend : MYSQL++ or MYODBC, I know that the MySQL C++ API is the official API, but can I connect to other SQL server whit this API? Thank you, Vilmara No, you can't. If you wish to make your application transparent, you should use ODBC. But MySQL++, is much, much more powerfull. -- 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: About MYSQL APIs
Hi, on freshmeat.net you can find some libraries which provide same comfort as mysql++, so try check... S pozdravem Michal Dvoracek [EMAIL PROTECTED] Capitol Internet Publisher, Korunovacni 6, 170 00 Prague 7, Czech Republic tel.: ++420 602 210 900, ++420 2 3337 1117, fax: ++420 2 3337 1112 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: About MYSQL APIs
Sinisa Milivojevic ([EMAIL PROTECTED]) writes: If you wish to make your application transparent, you should use ODBC. ODBC, or MyODBC? -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MYSQLGUI
Hello we would like to use MYSQLGUI is it allowed ? Id not not have any user and password to enter for download Best regards Franck Lepretre - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: About MYSQL APIs
Ed Carp writes: Sinisa Milivojevic ([EMAIL PROTECTED]) writes: ODBC, or MyODBC? -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London ODBC as an API. Then you install ODBC driver for RDBMS of your choice and configure ODBC likewise. But ODBC as a programming model is independent of RDBMS make. -- 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: MYSQLGUI
[EMAIL PROTECTED] writes: Hello we would like to use MYSQLGUI is it allowed ? Id not not have any user and password to enter for download Best regards Franck Lepretre It is completely free to use as much as you wish on as many computers as you wish. Just download binary or binaries for your OS's. -- 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 installation on NT problem
hi ! thanx for your reply. now i could install mysql on my NT. nut now when i give the command mysql-nt --install it says unable to install. moreover as it is in the installaton doci tried to look for the my-example.cnf file but i cud get only a link of this name in whole of my hard disk and that too is a speedDial file (clicking on it opens the MS-netmeeting configuration dialogue). please help. sumit - Original Message - From: Antonie Neethling [EMAIL PROTECTED] To: Sumit Ranjan [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, September 07, 2001 5:34 PM Subject: RE: mysql installation on NT problem Hi, Try to extract the files before running setup.exe. If this does not work you zip archive may be corrupt. Regards, Antonie -- S C I B I T -- Antonie Neethling ([EMAIL PROTECTED]) http://www.scibit.com/mysql - MySQL related products -- S C I B I T -- -Original Message- From: Sumit Ranjan [mailto:[EMAIL PROTECTED]] Sent: Friday, September 07, 2001 1:40 PM To: [EMAIL PROTECTED] Subject: mysql installation on NT problem hi all ! i am new to mysql and trying to install it onto my win NT 4.0 workstation. but the winzip is not able to install it ! is anybody else facing the same prob? does anybody know the cure? sumit - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: About MYSQL APIs
Ed Carp writes: So, is MyODBC just for MySQL, or can one use it for talking to other databases via ODBC also? Sorry, I'm just confused today, I guess ;) -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London Ed, You are making jokes on me ;o) You know the answer. You can't be that confused. -- 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
COUNT elements in a LIMIT query
Hello! Is it possible to get the total number of records when doing a select with LIMIT? For example, if I do: SELECT * FROM tbl LIMIT 0,10 I would like to get the total number of records in tbl along with the 10 first ones.. I need this to display showing 0 - 10 of 354, and my query is much more complex so I dont wan't to make two queries: SELECT COUNT(*) FROM tbl SELECT * FROM tbl LIMIT 0,10 Thanks in advance! /torgil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 retrieving tables
-Original Message- From: Jean Paterson [mailto:[EMAIL PROTECTED]] Sent: 07 September 2001 14:34 To: '[EMAIL PROTECTED]' Subject: Problems retrieving tables Can anyone help- I am new to MySQL. I am using Ultradev. I have installed MyODBC on my PC and set it up connect to my ISPs MySQL server. The connection works OK. I have successfully exported and imported tables from an MS Access database on my PC. When I set up the connection through the site on my PC, all works fine. However, when I use the connection string Driver={MySQL};Server=localhost;Database=dbname;UID=uidname;PWD=passwor d and upload the site to the web I get problems. The connection seems to be OK, but when I try to get to the tables I get the error message 'Unable to retrieve tables from this connection'. Has anyone else encountered this? Jean Paterson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: command line open source ARRRGGGGGG!!!!!!
%% Chadrick Mahaffey [EMAIL PROTECTED] writes: cm How do I start the server and create a database in plain English. I'm not cm familiar with: cm SECTION 4.16 - Documentation shell ./scripts/mysql_install_db shell cd mysql_installation_directory shell ./bin/safe_mysqld --user=mysql shell cd mysql_installation_directory shell ./bin/mysql_install_db shell ./bin/safe_mysqld --user=mysql cm what does all this mean? These are the commands and instructions for installing MySQL on a UNIX box. They are UNIX shell commands, not Windows DOS commands. You need to find the commands and instructions for installing MySQL on a Windows box, if that's what you are using. cm Open source would go much farther if they had self explanatory cm GUIs and had basic pre-setup apps that were ready for the average cm user to use. I program in Java and I feel the same about the JDK cm Sun produces. I use JCreator because it has an easy to follow GUI cm interface. Most open source apps I have attempted to use have some cm of the worse documentation around. The writers assume so much cm about the users. OK - call me inept, stupid, or whatever but I had cm to say it. Open source software is written by technical people. They do it because they enjoy it. Most of them don't get paid for it. Many technical people don't enjoy writing documentation at all, and _very_ few enjoy writing documentation at the complete newbie level. If they don't enjoy it, they aren't going to do it for fun. If someone who _did_ enjoy it were to volunteer to help, well, that would be great. Further, you are working on a Windows platform. Microsoft has, at almost every turn, expressed its deep-seated hostility for Open Source software of all kinds, and even the very idea of OS software. Also, many developers, esp. those doing OS software which has a very UNIX-based ancestry, don't _like_ working on Windows, as they don't think it's a good platform either to use or develop on. So, naturally enough you won't find all that many Open Source developers who are very interested in expending a lot of effort to keep people who use Windows happy. They don't want to _encourage_ people to use an environment that is so hostile to the things they like to do, and they don't like using Windows themselves. So, I doubt you'll see a big effort expended on the part of OS developers to make the Windows-specific parts of their software simpler. There are, obviously, some well-known exceptions like the StarOffice/OpenOffice folks, Emacs, Apache, etc. who do spend a lot of effort trying to get Windows versions easier to use and install. If you wanted to buy a support license for MySQL, I'm sure they'd help you get it installed properly. If you want to use the free version and you want to use it on Windows, then, for better or for worse, you're going to have to get used to life on a second-tier platform :(. -- --- Paul D. Smith [EMAIL PROTECTED] HASMAT--HA Software Mthds Tools Please remain calm...I may be mad, but I am a professional. --Mad Scientist --- These are my opinions---Nortel Networks takes no responsibility for them. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
sysdate() query and note to Mysql admin
Hi, I my name is ryan and I own a small site which has a mysql database and servlet support. I have a simple query to all you mysql gurus... my table is very simple, i created a table with the following create table datee(int today); now,what statement do I use to put the sysdate into the column today? this is NOT working insert into datee values(select DAYOFMONTH(sysdate())); the reason why I am doing this is coz I need to get the current date into my java app and this is not working Statement statement; Resultset rs=statement.executeQuery(select DAYOFMONTH(sysdate())); if(rs.next()) {rs.getString(sysdate());} ... does anyone know how to get the current date,month from the database into your java program? Please reply to [EMAIL PROTECTED] as I am unable to get into the mysql list. Any help appreciated. -Ryan. NOTE TO MySql admins Why in the world am I not able to get into the MySql list? my email is [EMAIL PROTECTED] and everytime I subscribe I get an error telling me that this is a perminant error and that its given up on it. Kindly help or manually include me into the list please. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Make new tables on top of old ones
Deryck Henson ([EMAIL PROTECTED]) writes: I need to make about 15 tables that use the same template as the first one. Please help. gripe Please post more information. Platform, software, etc. This is like saying, I want to get from point A to point B. Please help. /gripe OK, I've got that out of my system. Now, if you're on a UNIX/Linux/*BSD box, you can do: # assume name1...nameN is the names of your clone tables # assume origtable is the name of your original table # from the shell prompt: $ for i in name1 name2 name3 name4 ... name15 do mysqldump -d databasename origtable|sed -e s/CREATE TABLE origtable/CREATE TABLE $i/g|mysql databasename done Tada! -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ODP: sysdate() query and note to Mysql admin
Hi First of all try to use datetime column for datetime storage porpouses. create table datee(datetime today); And then: insert into datee(today) values(now()); After all of this, please RTFM :)). It's all written there. Regards Daniel a e-direct Polska sp. z o.o. WWW: http://www.e-direct.pl E-mail: [EMAIL PROTECTED] 45-072 Opole ul. Reymonta 45 tel. +48 77 44 26 073 fax. +48 77 44 26 074 -Oryginalna wiadomo- Od: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Wysano: 7 wrzenia 2001 15:51 Do: [EMAIL PROTECTED] Temat: sysdate() query and note to Mysql admin Hi, I my name is ryan and I own a small site which has a mysql database and servlet support. I have a simple query to all you mysql gurus... my table is very simple, i created a table with the following create table datee(int today); now,what statement do I use to put the sysdate into the column today? this is NOT working insert into datee values(select DAYOFMONTH(sysdate())); the reason why I am doing this is coz I need to get the current date into my java app and this is not working Statement statement; Resultset rs=statement.executeQuery("select DAYOFMONTH(sysdate())"); if(rs.next()) {rs.getString(sysdate());} ... does anyone know how to get the current date,month from the database into your java program? Please reply to [EMAIL PROTECTED] as I am unable to get into the mysql list. Any help appreciated. -Ryan. NOTE TO MySql admins Why in the world am I not able to get into the MySql list? my email is [EMAIL PROTECTED] and everytime I subscribe I get an error telling me that this is a perminant error and that its given up on it. Kindly help or manually include me into the list please. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: A question about load / queries pr second
Terje Kristensen wrote: I have a HP-UX server with Perl 5.005_03, MySQL 3.23.39 for hp-hpux11.00 (hppa2.0w), Apache/1.3.20. The load are rather high, and Queries per second avg: 94.859 This is an local B2B installation som we are really not getting any traffic between 4PM and 7AM We have peeks where there is more than 1000 Queries per second. Does anyone have any experience with a higher number of queries pr second than this ? Our queries per sec over the last 2 days has averaged 164/sec. And we hit peaks over 1000. During the busy parts of the day we average about 300/sec. Regards Terje K - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: A question about load / queries pr second
Jeremy Zawodny wrote: On Fri, Sep 07, 2001 at 12:07:07PM +0100, Basil Hussain wrote: I'm quite surprised that this level of performance is available from such standard (well, not standard as in 'common', but y'know what I mean...) hardware. The last I heard, 1K+ queries/sec was only being done on extremely high-end Sun enterprise-level machines. Yeah, they *were* almost all read queries... On the other hand though, it gives me some comfort that the hardware being used in my operation will meet any future needs. We have similar spec servers (P3-1Ghz dual-cpu, 512Mb RAM, 3x36Gb SCSI RAID5). Maybe I should try out mysql-super-smack and see what kind of numbers it turns up. :-) It would be interesting. We've just finished some upgrades here (thus the recent low uptimes in my signature). Brought out Linux boxes up to 2.4.9 and 2GB of RAM. Had a lot of problems with 2.4.9's brain-dead VM subsystem, so I disabled swap and things are A LOT better now. Could you provide more details about the problems with 2.4.9's VM and how and why you disabled swap? We're on ReiserFS now and have software RAID running on one box to test it out. 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 1 days, processed 25,090,103 queries (225/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sysdate() query and note to Mysql admin
[EMAIL PROTECTED] ([EMAIL PROTECTED]) writes: now,what statement do I use to put the sysdate into the column today? this is NOT working insert into datee values(select DAYOFMONTH(sysdate())); Of course not. insert into datee values (Now()) will, though. Just feed it to mysql ... ;) Here's the JavaScript euqivalent, if that helps: function GetTheDate() { now = new Date; ty = now.getYear(); if(ty 1900) { ty = ty + 1900; } mo = now.getMonth(); mo = mo + 1; return(ty+'-'+ShowZeroFilled(mo)+'-'+ShowZeroFilled(now.getD ate())+' '+ShowZeroFilled(now.getHours())+':'+ShowZeroFilled(now.getMinutes())); } -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Floats
Hi List, I'm a little bit confused. I do the following: Create a table with 1 int and two floats. mysql create table testfloat(z int, ll float, ul float); Query OK, 0 rows affected (0.00 sec) inserting one row into the table mysql insert into testfloat values(1,-0.1,0.1); Query OK, 1 row affected (0.00 sec) check if values where inside mysql select * from testfloat; +--+--+--+ | z| ll | ul | +--+--+--+ |1 | -0.1 | 0.1 | +--+--+--+ 1 row in set (0.01 sec) and now I wants to take a look on special rows.. mysql select * from testfloat where ul=0.1; Empty set (0.00 sec) I didn't understand why I didn't get what I expect. Best regards Thorsten Guddack - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Select Highest ID query
On Thu, Sep 06, at 11:05pm, Chris Bolt ([EMAIL PROTECTED]) wrote: SELECT * FROM yourtable WHERE id = LAST_INSERT_ID(); But that will only work if it was the same thread that inserted the last record in the table. If this is running from say .. a script that just wants the last inserted record (highest ID) then it will not work because LAST_INSERT_ID() will return 0. -- Ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Select Highest ID query
Why not just: SELECT MAX(id) AS max_id FROM yourtable; Then run another select to get the record? Or, if you want the last record: SELECT * FROM yourtable ORDER BY id DESC LIMIT 1; maybe. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: Ian Moore [mailto:[EMAIL PROTECTED]] Sent: Friday, September 07, 2001 9:28 AM To: Chris Bolt Cc: [EMAIL PROTECTED] Subject: Re: Select Highest ID query On Thu, Sep 06, at 11:05pm, Chris Bolt ([EMAIL PROTECTED]) wrote: SELECT * FROM yourtable WHERE id = LAST_INSERT_ID(); But that will only work if it was the same thread that inserted the last record in the table. If this is running from say .. a script that just wants the last inserted record (highest ID) then it will not work because LAST_INSERT_ID() will return 0. -- Ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Corrupted tables -- for 'no apparent' reason
Mark Papadakis wrote: We are using mySQL on over 6 servers here, we have been doing so for over 2 years, and we are constaly facing problems with corrupted tables, especially on two of our busiest servers. Tables seem to corrupt out of the blue and we have to shut them down ( the servers ) occassionaly to fix all tables and then bring them up again. I have found that sometimes (esp. with older versions of MySQL which is not the case for you) that the only way to either repair or permanently repair a table is to dump/drop/reload the table and data. I had some instances a number of years back where the table would repair and be okay with isamchk but would, at a random time, be corrupted again. Doing the dump, etc. fixed the problem. --Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: COUNT elements in a LIMIT query
On Friday 07 September 2001 15:37, Torgil Zechel wrote: Is it possible to get the total number of records when doing a select with LIMIT? No. As least, not in MySQL, unless I am missing something. For example, if I do: SELECT * FROM tbl LIMIT 0,10 I would like to get the total number of records in tbl along with the 10 first ones.. I need this to display showing 0 - 10 of 354, and my query is much more complex so I dont wan't to make two queries: SELECT COUNT(*) FROM tbl SELECT * FROM tbl LIMIT 0,10 COUNT is an aggregate function which works on the result set returned. You can therefore select a number of rows to be displayed and count these, or select all rows in the table and count these, but not both at once. (You can't have both your cake and eat it ;-) If UNION was supported, you could do something like SELECT field1, field2, ... fieldx LIMIT 0,10 FROM tbl UNION SELECT count(*), '', ... ''- provide x - 1 blank fields of the same datatype as 'fieldn' in the first SELECT which would provide you with the first 10 results as well as the total number of rows. This is however a pretty messy way of doing things and I would stick with two SELECT statements. BTW a simple COUNT(*) without a WHERE clause is optimized in MySQL. HTH Ian Barwick -- Ian Barwick - Developer - [EMAIL PROTECTED] akademie.de asp GmbH - http://www.akademie.de To query tables in a MySQL database is more fun than eating spam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: command line open source ARRRGGGGGG!!!!!!
I wanted to put in my 2 cents. Access is not an RDBMS.. It is a single user - small user, and frequent fix type system. I have never worked on a real database system that does not have a command line interface. It seems fearsome at first, but it's actually easy. SQL Server do doubt has very nice GUI tools, but having used that DB a bit, [as a user] I am not very impressed. I know these are pathetic questions to most of you so please have patience with a Windows user... what is shell? what is the ./? is mysql_installation_directory supposed to be replaced with my installation dir? On of the afore mentioned e-mails already answered most of this, but IU wanted to add some significance about the './' and why you need it and you DON'T need '.\' on a dos/windows systems. Any file in a unix environment can be marked executable. That does not mean it will run but any file can. Unix/Posix shells [you could related cmd.exe, or command.com to a shell] rely on the PATH variable to tell them where to run programs from. No Unix has './' [or the local directory] in the path, because it would present a small security risk when running programs, especially for the root user. Hence, if you want to run a program from a specific location that is _not_ in the PATH, you need to type in the relative, or the full path to the program. In this case, change to the directory where you find the program, and type: './progname' I realize that I'm going to be in the minority here but I have to say it. Open source would go much farther if they had self explanatory GUIs and had basic pre-setup apps that were ready for the average user to use. I program in Java and I feel the same about the JDK Sun produces. I use JCreator because it has an easy to follow GUI interface. Most open source apps I have attempted to use have some of the worse documentation around. The writers assume so much about the users. OK - call me inept, stupid, or whatever but I had to say it. I don't know what you've been using, but I have used a TON of open source, and most of it has good documentation. Partly because most opensource programmers think that you might want to understand the underlying process that the computer is going through in order to complete your requests, run the program, etc. Windows silently teaches you something else - using the pretty eye candy. You are gently brought in and taught one way of thinking and relating to your computer. But if you could step back and look at the skills necessary to run a GUI vs. use a command prompt , one is not actually more complicated than the other. [And you lose a lot of flexibility with a GUI]. Save one problem, people tend towards visual things, it's natural, and so they seem to fear CLI more than GUI. Oh, and on a more personal note, most people who have huge issues with open-source apps don't completly RTFM. They are impatient, frustrated and want all this stuff to work in 30 seconds otherwords is MUST be crap. However, 15 minutes of patient reading will often alleviate those issues. =P. Hope you get this figured out to your comfort. MySQL may take a little bit of extra effort to administrate, [esp. at first] but it is vastly superior to Access, and MUCH MUCH cheaper than SQL Server 7, or whatever. Also, it boasts one HUGE advantage over SQL server: You are not tied to a single proprietary platform =). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Fulltextsearch
Hello, Actually I am programming an web directory (like yahoo). But my sql queries need ernormous cpu resources. So it is quiet slow. I can't use indexing because my serach works with LIKE '%$serchstring%'. (apparently then it dosen't help). Now I was wondering if it would get faster by using FULLTEXTSEARCH on my tables. As it is quiet some work, I first want to ask you guys if this is really going to make my queries faster (much faster ?) Or perhaps you know any better solution ? Lorang Jacques - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Let's approach stored procedures
I think this is a little OT here, so after reading please indicate me where to talk about this subject. I'm a skilled programmer in C, C++ and others progr. lang. I have also a solid background in SQL and some RDMS (DB2, Oracle, SQLServer, and of course, Mysql). I'm going to attend a long period of holidays (finally) so, I thought: why don't try to implement stored procedures in mysql ? Now, on with the questions: I think that MySQL programmers had yet thinked on some way to implement sp, and I'd wish that someone say me: - No, dude it's impossible/too hard - No, dude, we are in the way to finish that by ourselves - No, dude, we never insert big patches in our official distribution branch, that does not belong to us Or, better, something more optimistic... I don't want to loose my time, in something that you know is impossible or too hard to get. Another question: At a first glance, I think Oracle PL/SQL is the best (afaik) programming language for sp, but, in the case we implement that language, should we go against some Oracle copytight infringment ? That's all, for now. database, 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
Re: Optimization question and possible bug
Stefan Pinkert wrote: Examine that query with explain select... show that the indexes are not used. The keyfields are unsigned tiny int where every bit has a different meaning. Any clue how i can rewrite this query in a way where the indexes are used? If MySQL thinks it will be faster to scan, it will. Make sure you analyze the tables with [my]isamchk -a. If that does not help, please send the output from SHOW INDEX FROM table and the EXPLAIN. In the database i have a merge-table that merges 10 myisam tables. Sometimes the loadaverage of the system raise above 50 and the long-query-log is filled with some query accessing the merge table. This happens 2-3 times a day. Only a minute later everthing is okay again without doing anything. I can't believe that it is a performance problem because there is a summary of only 10,000 entries in the merge table and 50,000 entries in other tables. Does anybody experienced this strange problem, too? Is the long query different than the other queries? Have you done an expain on it? The last thing i found is a possible bug in merge-table implementation of 2.23.41. After an update from 2.23.37 to 2.23.41 i got only the first row of the result set again and again. Maybe it's a communication problem between php (with included mysql interface) and the new MySQL version. (Haven't determined it yet). Don't know. But read this thread just to be sure: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:84077:200108:ilgknliamhblokdjmmhb --Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 SQL
On Friday 07 September 2001 06:11 am, you wrote: Giovanni Borri writes: hi all, i have a question. i would like to know if mysql has a sql'x' standard. my problem is that i would like to use UNION or MINUS or... but it seems not to work, another problem is that i would like to make some nested query. by thanks in advance. Giovanni UNION's will come in 4.0, which will come this or next month. MINUS will come next year. What about the nested queries? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Fulltextsearch
Lorang Jacques ([EMAIL PROTECTED]) writes: Now I was wondering if it would get faster by using FULLTEXTSEARCH on my tables. As it is quiet some work, I first want to ask you guys if this is really going to make my queries faster (much faster ?) Yup. I've got the entire set of laws for the State of Texas online. My query time went down from 120 seconds to less than a second. So, yes, it's really worth it. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Let's approach stored procedures
Claudio Cicali wrote: I'm going to attend a long period of holidays (finally) so, I thought: why don't try to implement stored procedures in mysql ? Someone did it with perl. http://software.tangent.org/article.pl?sid=01/08/23/0817244mode=threadthreshold= At a first glance, I think Oracle PL/SQL is the best (afaik) programming language for sp, but, in the case we implement sarcasm You should implement it in Python so the Perl vs. Python flame wars can rage from within MySQL too. /sarcasm --Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: command line open source ARRRGGGGGG!!!!!!
- Original Message - From: Colm Brazel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 07, 2001 4:33 PM Subject: Re: command line open source ARRRGG!! Open source software is written by technical people. They do it because they enjoy it. Most of them don't get paid for it. Many technical people don't enjoy writing documentation at all, and _very_ few enjoy writing documentation at the complete newbie level. Hi, The maxim should be that no one should mind a difficult concept well explained. But everybody should mind a simple concept made difficult because it is poorly explained. A poor explanation is one that is not intelligible by a newbie not because it is difficult, but because it is poorly explained in terms easily understood by a newbie. Colm Colm Brazel (MA) CB Publications www.cbweb.net [EMAIL PROTECTED] - Original Message - From: Paul D. Smith [EMAIL PROTECTED] To: Chadrick Mahaffey [EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED] Sent: Friday, September 07, 2001 2:50 PM Subject: Re: command line open source ARRRGG!! %% Chadrick Mahaffey [EMAIL PROTECTED] writes: cm How do I start the server and create a database in plain English. I'm not cm familiar with: cm SECTION 4.16 - Documentation shell ./scripts/mysql_install_db shell cd mysql_installation_directory shell ./bin/safe_mysqld --user=mysql shell cd mysql_installation_directory shell ./bin/mysql_install_db shell ./bin/safe_mysqld --user=mysql cm what does all this mean? These are the commands and instructions for installing MySQL on a UNIX box. They are UNIX shell commands, not Windows DOS commands. You need to find the commands and instructions for installing MySQL on a Windows box, if that's what you are using. cm Open source would go much farther if they had self explanatory cm GUIs and had basic pre-setup apps that were ready for the average cm user to use. I program in Java and I feel the same about the JDK cm Sun produces. I use JCreator because it has an easy to follow GUI cm interface. Most open source apps I have attempted to use have some cm of the worse documentation around. The writers assume so much cm about the users. OK - call me inept, stupid, or whatever but I had cm to say it. Open source software is written by technical people. They do it because they enjoy it. Most of them don't get paid for it. Many technical people don't enjoy writing documentation at all, and _very_ few enjoy writing documentation at the complete newbie level. If they don't enjoy it, they aren't going to do it for fun. If someone who _did_ enjoy it were to volunteer to help, well, that would be great. Further, you are working on a Windows platform. Microsoft has, at almost every turn, expressed its deep-seated hostility for Open Source software of all kinds, and even the very idea of OS software. Also, many developers, esp. those doing OS software which has a very UNIX-based ancestry, don't _like_ working on Windows, as they don't think it's a good platform either to use or develop on. So, naturally enough you won't find all that many Open Source developers who are very interested in expending a lot of effort to keep people who use Windows happy. They don't want to _encourage_ people to use an environment that is so hostile to the things they like to do, and they don't like using Windows themselves. So, I doubt you'll see a big effort expended on the part of OS developers to make the Windows-specific parts of their software simpler. There are, obviously, some well-known exceptions like the StarOffice/OpenOffice folks, Emacs, Apache, etc. who do spend a lot of effort trying to get Windows versions easier to use and install. If you wanted to buy a support license for MySQL, I'm sure they'd help you get it installed properly. If you want to use the free version and you want to use it on Windows, then, for better or for worse, you're going to have to get used to life on a second-tier platform :(. -- -- - Paul D. Smith [EMAIL PROTECTED] HASMAT--HA Software Mthds Tools Please remain calm...I may be mad, but I am a professional. --Mad Scientist -- - These are my opinions---Nortel Networks takes no responsibility for them. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Let's approach stored procedures
Claudio Cicali ([EMAIL PROTECTED]) writes: At a first glance, I think Oracle PL/SQL is the best (afaik) programming language for sp, but, in the case we implement that language, should we go against some Oracle copytight infringment ? Why would you want to do such a thing? Isn't SQL good enough? I'm just trying to figure out your reasoning here, besides the same argument used by the XML crowd of it's the latest/greatest do-all-be-all-end-all, so everyone should be using it type of nonsense. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
In the table Properties... What is Row_Format???
What´s the diference between The row storage format (Fixed, Dynamic, or Compressed) . I'am experiencing problems with update statements which goes against a table with the row_format property set to Fixed. Thanks. Pablo Fraga (MIS). e-mail: [EMAIL PROTECTED] - [EMAIL PROTECTED] icq: 113466029 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Let's approach stored procedures
At 10.44 07/09/2001 -0500, Ed Carp wrote: Claudio Cicali ([EMAIL PROTECTED]) writes: At a first glance, I think Oracle PL/SQL is the best (afaik) programming language for sp, but, in the case we implement that language, should we go against some Oracle copytight infringment ? Why would you want to do such a thing? Isn't SQL good enough? I'm just trying to figure out your reasoning here, besides the same argument used by the XML crowd of it's the latest/greatest do-all-be-all-end-all, so everyone should be using it type of nonsense. Nice question, overall. Answers (partial list): - it's cool - where I work, we have a HUGE database-driven web-application. A lot of our businness logic is implemented via stored procedures, that act as black boxes for the web-designers. Think of enterprise java beans. They are not nonsense or such. They are usefull. (I know, you can use ejb with JDBS and mysql..., but if you want to have some logic incapsualted, you should use some kind of component) - sp extends the RDBMS itself in its functionality. Think about some stupid check_fiscal_code() or insert_new_customer(). Web designers use the insert_new_customer, instead of using SQL directly. I think that there are others examples, but this is my point. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Fulltextsearch
On Fri, Sep 07, 2001 at 10:41:33AM -0500, Ed Carp wrote: Lorang Jacques ([EMAIL PROTECTED]) writes: Now I was wondering if it would get faster by using FULLTEXTSEARCH on my tables. As it is quiet some work, I first want to ask you guys if this is really going to make my queries faster (much faster ?) Yup. I've got the entire set of laws for the State of Texas online. My query time went down from 120 seconds to less than a second. So, yes, it's really worth it. Do the current limitations of 500 characters per index and limited (?) number of columns per index pose problems? I want to use fulltext on a database with 7 varchar(255) columns and several smaller varchar columns but can't build a fulltext index. Is there documentation on the limitations of fulltext? -- Regards, Doug - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Slow replication question/problem
Jeremy Zawodny wrote: snip Are subsequent inserts just as slow to replicate? Can you show us the output of SHOW SLAVE STATUS and maybe the my.cnf files of the master and a slow slave? Jeremy Thanks for the response. Below is the info you requested. If there's anything else that might be of help, please let me know and I'll do my best to provide it. I'm pretty sure most, if not all subsequent inserts are slow, although it might be true that if we did a number of inserts at the same time that they may inserted on the slaves together. We have not tried this at this point in time. The slave status looks like: --- | Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos| Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | | p23.hoovers.com | repl | 3306 | 60 | p23-bin.004 | 931831 | Yes | portlets | hoovers | 0 | | 0 | --- The Master status gives: --- | File| Position | Binlog_do_db | Binlog_ignore_db | +-+--+--+--+ | p23-bin.004 | 1004808 | portlets | hoovers | --- The Master my.cnf (comments removed): ---[mysqld] skip-locking set-variable= key_buffer=384M set-variable= max_allowed_packet=16M set-variable= table_cache=512 set-variable= sort_buffer=6M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=128M set-variable= thread_cache_size=4 set-variable= thread_concurrency=4 # Try number of CPU's*2 set-variable= tmp_table_size=4M set-variable= net_read_timeout=300 set-variable= net_write_timeout=300 # Replication log-bin server-id=1 binlog-do-db=portlets binlog-ignore-db=hoovers [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=128M set-variable= sort_buffer=128M set-variable= read_buffer=2M set-variable= write_buffer=2M [myisamchk] set-variable= key_buffer=128M set-variable= sort_buffer=128M set-variable= read_buffer=2M set-variable= write_buffer=2M --- Slave my.cnf (comments removed): --- [mysqld] skip-locking set-variable= key_buffer=384M set-variable= max_allowed_packet=16M set-variable= table_cache=512 set-variable= sort_buffer=5M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=128M set-variable= thread_cache_size=4 set-variable= thread_concurrency=4 # Try number of CPU's*2 set-variable= tmp_table_size=3M set-variable= net_read_timeout=300 set-variable= net_write_timeout=300 set-variable= max_connections=500 log-update # Replication master-host=p23.hoovers.com master-user=repl master-password=removed, but correct master-port=3306 server-id=2 replicate-do-db=portlets replicate-ignore-db=hoovers log-slave-updates log-bin [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=128M set-variable= sort_buffer=128M set-variable= read_buffer=2M set-variable= write_buffer=2M [myisamchk] set-variable= key_buffer=128M set-variable= sort_buffer=128M set-variable= read_buffer=2M set-variable= write_buffer=2M --- Thanks again, - Jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
newbie:
Hi All, where do I specify the remote hosts that are allowed to access port 3306? I have made entries in the user table of the mysql db, but still cannot conect from a remote machine. Thanks, Ric. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Let's approach stored procedures
My $.02, Stick with the ANSI standard. (ANSI99?) Do not try to implement either PL/SQL or T/SQL. Please do not implement PERL (or Python) , Java, PHP or any other procedural or OO language in stored procedures. Speaking form experience, all this does is blur the lines of that the database should do and what the middle tier should do. Whatever you do, do not adversely impact the speed at which MySQL runs. Happy to Alpha/Beta test any patches you may create, IMHO, Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: Claudio Cicali [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 07, 2001 10:30 Subject: Let's approach stored procedures I think this is a little OT here, so after reading please indicate me where to talk about this subject. I'm a skilled programmer in C, C++ and others progr. lang. I have also a solid background in SQL and some RDMS (DB2, Oracle, SQLServer, and of course, Mysql). I'm going to attend a long period of holidays (finally) so, I thought: why don't try to implement stored procedures in mysql ? Now, on with the questions: I think that MySQL programmers had yet thinked on some way to implement sp, and I'd wish that someone say me: - No, dude it's impossible/too hard - No, dude, we are in the way to finish that by ourselves - No, dude, we never insert big patches in our official distribution branch, that does not belong to us Or, better, something more optimistic... I don't want to loose my time, in something that you know is impossible or too hard to get. Another question: At a first glance, I think Oracle PL/SQL is the best (afaik) programming language for sp, but, in the case we implement that language, should we go against some Oracle copytight infringment ? That's all, for now. database, 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RPM or SourceCode ???
If you read thru more about the reasons for recommendation for installing thru RPM, you'll understand. Since the folks who built RPMs have definitely spent lot of time building the RPMs which is optimized for performance. I do trust them and commend their efforts. The source definitely gives you more options and flexibility. It's entirely your choice. cheers -alok Nilesh Parmar wrote: Hi all I was just getting thru the documentation of MySQL at the mysql.com site and there it is specified that The recommended way to install MySQL on Linux is by using an RPM file Can anyone tell me in what way it is different installing mysql from the rpm's and from the source code ?? except that if we install from the source code it is a bit tedious where as with the rpm it is convineint. Are there any reasons other than this ?? i for one feel that installing from the source gives us a lot of options and flexibility thanx in advance. cheers !! Nilesh Parmar [EMAIL PROTECTED] Wrox Press - Programmer to Programmer((tm)) http://www.wrox.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Floats
This is a standard 1st quarter computer science topic. You can't reliably test floating point numbers for equality. 0.1 has no exact floating point binary representation. Perhaps you should use the DECIMAL type which is stored internally as a string. Guddack Thorsten ICM MP SCM SCCM PI wrote: Hi List, I'm a little bit confused. I do the following: Create a table with 1 int and two floats. mysql create table testfloat(z int, ll float, ul float); Query OK, 0 rows affected (0.00 sec) inserting one row into the table mysql insert into testfloat values(1,-0.1,0.1); Query OK, 1 row affected (0.00 sec) check if values where inside mysql select * from testfloat; +--+--+--+ | z| ll | ul | +--+--+--+ |1 | -0.1 | 0.1 | +--+--+--+ 1 row in set (0.01 sec) and now I wants to take a look on special rows.. mysql select * from testfloat where ul=0.1; Empty set (0.00 sec) I didn't understand why I didn't get what I expect. Best regards Thorsten Guddack - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
In the table Properties... What is Row_Format???
What´s the diference between The row storage format (Fixed, Dynamic, or Compressed) . I'am experiencing problems with update statements which goes against a table with the row_format property set to Fixed. Thanks. Pablo Fraga (MIS). e-mail: [EMAIL PROTECTED] - [EMAIL PROTECTED] icq: 113466029 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Let's approach stored procedures
- it's cool Not a valid business reason. - where I work, we have a HUGE database-driven web-application. A lot of our business logic is implemented via stored procedures, that act as black boxes for the web-designers. Think of enterprise java beans. They are not nonsense or such. They are usefull. Stored procedures aren't nonsense, but using or re-implementing a particular vendor's implementation is. (I know, you can use ejb with JDBS and mysql..., but if you want to have some logic incapsualted, you should use some kind of component) - sp extends the RDBMS itself in its functionality. Think about some stupid check_fiscal_code() or insert_new_customer(). Web designers use the insert_new_customer, instead of using SQL directly. These are all great reasons to implement stored procedures, not Oracle PL/SQL. I think I'm missing your point here... -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Let's approach stored procedures
Ed, Stored procedures allow you to pre-compile and re-use code easily. They also make transactions easier. (At least from one point of view) It's not like the XML argument. SPs are also part of the ANSI spec so to be compliant, MySQL will have to have them. XML is not part of the ANSI-SQL spec. IMHO, Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: Ed Carp [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, September 07, 2001 10:44 Subject: Re: Let's approach stored procedures Claudio Cicali ([EMAIL PROTECTED]) writes: At a first glance, I think Oracle PL/SQL is the best (afaik) programming language for sp, but, in the case we implement that language, should we go against some Oracle copytight infringment ? Why would you want to do such a thing? Isn't SQL good enough? I'm just trying to figure out your reasoning here, besides the same argument used by the XML crowd of it's the latest/greatest do-all-be-all-end-all, so everyone should be using it type of nonsense. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Mysql Fulltextsearch
Do the current limitations of 500 characters per index and limited (?) number of columns per index pose problems? I want to use fulltext on a database with 7 varchar(255) columns and several smaller varchar columns but can't build a fulltext index. Is there documentation on the limitations of fulltext? I've had no problems, but I also haven't seen any documentation on limitations. The FULLTEXT page is at http://www.mysql.com/doc/F/u/Fulltext_Search.html if you can see something I've missed... -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development, Database/SQL Research Directorate Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Let's approach stored procedures
Cal Evans ([EMAIL PROTECTED]) writes: Stick with the ANSI standard. (ANSI99?) Do not try to implement either PL/SQL or T/SQL. Please do not implement PERL (or Python) , Java, PHP or any other procedural or OO language in stored procedures. Speaking form experience, all this does is blur the lines of that the database should do and what the middle tier should do. BRAVO! At last, the voice of common sense is heard :) -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: In the table Properties... What is Row_Format???
Pablo Fraga ([EMAIL PROTECTED]) writes: What´s the diference between The row storage format (Fixed, Dynamic, or Compressed) . RTFM! http://www.mysql.com/doc/C/R/CREATE_TABLE.html http://www.mysql.com/doc/D/y/Dynamic_format.html -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Let's approach stored procedures
At 11.03 07/09/2001 -0500, Ed Carp wrote: - it's cool Not a valid business reason. - where I work, we have a HUGE database-driven web-application. A lot of our business logic is implemented via stored procedures, that act as black boxes for the web-designers. Think of enterprise java beans. They are not nonsense or such. They are usefull. Stored procedures aren't nonsense, but using or re-implementing a particular vendor's implementation is. (I know, you can use ejb with JDBS and mysql..., but if you want to have some logic incapsualted, you should use some kind of component) - sp extends the RDBMS itself in its functionality. Think about some stupid check_fiscal_code() or insert_new_customer(). Web designers use the insert_new_customer, instead of using SQL directly. These are all great reasons to implement stored procedures, not Oracle PL/SQL. I think I'm missing your point here... No, sorry, it's me :) I haven't got your point. All, clear, now. bye - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: About MYSQL APIs
Ed Carp wrote: Sinisa Milivojevic ([EMAIL PROTECTED]) writes: Ed Carp writes: Sinisa Milivojevic ([EMAIL PROTECTED]) writes: ODBC, or MyODBC? ODBC as an API. Then you install ODBC driver for RDBMS of your choice and configure ODBC likewise. But ODBC as a programming model is independent of RDBMS make. So, is MyODBC just for MySQL, or can one use it for talking to other databases via ODBC also? Sorry, I'm just confused today, I guess ;) -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Check out... http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcodbc_function_summary.asp ...for more information on ODBC. Also check out http://www.unixodbc.org ...for ODBC on UNIX/Linux. Peter -- +--- | Data Architect | your data; how you want it | http://www.codebydesign.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: Query question.
Not quite. We're not looking for a left join or natural left join. I'm not sure MySQL or any database can even do this, it may have to be done (rather unattractively) on the API side. The data in the two tables aren't tied by ID, and shouldn't mix w/ each other at all. To do this, all we've been able to come up with is to use the API (PHP in our case) to make 2 queries, copy them into the same array, and sort the array by timestamp. However the API's array sort isn't the quickest thing ever coded, and the SQL level is where we'd like to do the sorting. To clarify, I'll give an example of what we are trying to do: daily_notes: note_iduser_numtimestampnote 111Hello 212Goodbye 3231 Blah project_notes: note_iduser_numtimestampnote 121Working hard 215Watching others work hard We'd like a query that would return daily_notes #1 and #2 and project_notes #2. However, like I said earlier, I'm not sure SQL can do this. This list is kind of a last resort before defaulting on letting the API sort it out after the 2 queries. Ken wrote: Sounds like a left join, maybe even a natural join, which I haven't tried yet. select message from project left join daily on project.uid = daily.uid order by timestamp Check manual for syntax. Or am I missing something? - Ken [EMAIL PROTECTED] At 05:47 PM 9/6/01 -0700, Michael Garvin wrote: Ok, we just can't seem to find a solution for this problem. Thought I'd post it up to see if anyone has any input. Say you have 2 tables project_notes and daily_notes. Each table has a timestamp, and a user_id. Is there any way, in one query, to select all messages from both tables that were entered by a given user_id and sort by timestamp? This isn't the first time this problem has come up here where I work, another application of this solution (if it exists) would be to query different tables representing different realms on our radius servers to get a total usage summary across our network for a given user. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Optimization question and possible bug
No, they do not differ from the rest. The only thing is that they need longer time to process (between 1 and 4 seconds, normally the SAME query is processed in a few miliseconds). The only correlation i found is that all queries in that log query the merge table. How does mysql handle locks on merge-tables? Maybe it has do to with some locking problembut it's just another suspicion. -Ursprungliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Im Auftrag von Adams, Bill TQO Gesendet: Freitag, 7. September 2001 17:37 An: Stefan Pinkert Cc: [EMAIL PROTECTED] Betreff: Re: Optimization question and possible bug . In the database i have a merge-table that merges 10 myisam tables. Sometimes the loadaverage of the system raise above 50 and the long-query-log is filled with some query accessing the merge table. This happens 2-3 times a day. Only a minute later everthing is okay again without doing anything. I can't believe that it is a performance problem because there is a summary of only 10,000 entries in the merge table and 50,000 entries in other tables. Does anybody experienced this strange problem, too? Is the long query different than the other queries? Have you done an expain on it? . - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Let's approach stored procedures
Let me clarify. I'm in great favor of stored procedures in MySQL. It is my HO that all interaction with the database should take place within stored procedures. But the ANSI standard is sufficient for most interaction with the database. My call to arms was to resist the urge that Oracle could not, implementing a full-blown language within the context of SPs. (Oracle used Java, rumor has it that MS will implement C#, Java's moronic cousin, in a future release) Again, IMHO, take it for what it's worth. Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: Ed Carp [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, September 07, 2001 11:14 Subject: Re: Let's approach stored procedures Cal Evans ([EMAIL PROTECTED]) writes: Stick with the ANSI standard. (ANSI99?) Do not try to implement either PL/SQL or T/SQL. Please do not implement PERL (or Python) , Java, PHP or any other procedural or OO language in stored procedures. Speaking form experience, all this does is blur the lines of that the database should do and what the middle tier should do. BRAVO! At last, the voice of common sense is heard :) -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: COUNT elements in a LIMIT query
Torgil Zechel writes: I would like to get the total number of records in tbl along with the 10 first ones.. As far as I recall this is one of the things that will be added in version 4. The question is just when that version will be stable enough to be fully trusted (it might already be for all I know), and when there will be a function to access the count in PHP (which is the only thing I've used to access a MySQL db). //C - who once again curses the list manager for not doing something about reply-to and the dead email addresses on the list. Oh, and for not responding to emails as well. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql Fulltextsearch
On Fri, Sep 07, 2001 at 11:10:46AM -0500, Ed Carp wrote: Do the current limitations of 500 characters per index and limited (?) number of columns per index pose problems? I want to use fulltext on a database with 7 varchar(255) columns and several smaller varchar columns but can't build a fulltext index. Is there documentation on the limitations of fulltext? I've had no problems, but I also haven't seen any documentation on limitations. The FULLTEXT page is at http://www.mysql.com/doc/F/u/Fulltext_Search.html if you can see something I've missed... Thanks for the URL, the limitiations I mentioned were discovered when I was attempting to build fulltext indexes on said tables. -- Regards, Doug - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: newbie:
ricardo bravo writes: Hi All, where do I specify the remote hosts that are allowed to access port 3306? I have made entries in the user table of the mysql db, but still cannot conect from a remote machine. Thanks, Do the entries match the host you're connecting from? Did you add them with GRANT, and if not did you FLUSH PRIVILEGES? And first and foremost excaclty what error message do you get, and when? Did you disable TCP/IP with --skip-networking? Are you connecting to the right host and port? Is MySQL running? Is there a firewall blocking the way? Did you try connecting with telnet like the manual suggests? -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Let's approach stored procedures
On Fri, 7 Sep 2001, Cal Evans wrote: Date: Fri, 7 Sep 2001 11:05:27 -0500 From: Cal Evans [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED], Ed Carp [EMAIL PROTECTED] Subject: Re: Let's approach stored procedures Ed, Stored procedures allow you to pre-compile and re-use code easily. They also make transactions easier. (At least from one point of view) It's not like the XML argument. SPs are also part of the ANSI spec so to be compliant, MySQL will have to have them. XML is not part of the ANSI-SQL spec. IMHO, Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * Since the current version of MySQL is open source you could write stored procedures in the same language used in (until recently) DB2, i.e., C. I don't think that would be useful for those of us who are C challanged... I think the real question is, can it be done w/o impacting performance. Related question, what language or psuedo language would be used to code them. - Original Message - From: Ed Carp [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, September 07, 2001 10:44 Subject: Re: Let's approach stored procedures Claudio Cicali ([EMAIL PROTECTED]) writes: At a first glance, I think Oracle PL/SQL is the best (afaik) programming language for sp, but, in the case we implement that language, should we go against some Oracle copytight infringment ? Why would you want to do such a thing? Isn't SQL good enough? I'm just trying to figure out your reasoning here, besides the same argument used by the XML crowd of it's the latest/greatest do-all-be-all-end-all, so everyone should be using it type of nonsense. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Let's approach stored procedures
Cal Evans wrote: Stored procedures allow you to pre-compile and re-use code easily. They also make transactions easier. (At least from one point of view) It's not like the XML argument. SPs are also part of the ANSI spec so to be compliant, MySQL will have to have them. XML is not part of the ANSI-SQL spec. The other thing about all of this is that MySQL is feature rich so most people might not have a use for stored procedures. Unlike, say, Informix which has not build in MIN or MAX function. Again, if having stored procedures built in does not slow down queries that do not use stored procedures, I do not see what the harm is. --Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Let's approach stored procedures
SQL. Stored procedures are loosely analogous to shell scripts. No additional language constructs, outside of what is defined in the ANSI-SQL standard are necessary for them. IMHO, C would be a bad thing. My $.02 worth, (which is worth less, each time I post) Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: William R. Mussatto [EMAIL PROTECTED] To: Cal Evans [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Ed Carp [EMAIL PROTECTED] Sent: Friday, September 07, 2001 11:27 Subject: Re: Let's approach stored procedures On Fri, 7 Sep 2001, Cal Evans wrote: Date: Fri, 7 Sep 2001 11:05:27 -0500 From: Cal Evans [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED], Ed Carp [EMAIL PROTECTED] Subject: Re: Let's approach stored procedures Ed, Stored procedures allow you to pre-compile and re-use code easily. They also make transactions easier. (At least from one point of view) It's not like the XML argument. SPs are also part of the ANSI spec so to be compliant, MySQL will have to have them. XML is not part of the ANSI-SQL spec. IMHO, Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * Since the current version of MySQL is open source you could write stored procedures in the same language used in (until recently) DB2, i.e., C. I don't think that would be useful for those of us who are C challanged... I think the real question is, can it be done w/o impacting performance. Related question, what language or psuedo language would be used to code them. - Original Message - From: Ed Carp [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, September 07, 2001 10:44 Subject: Re: Let's approach stored procedures Claudio Cicali ([EMAIL PROTECTED]) writes: At a first glance, I think Oracle PL/SQL is the best (afaik) programming language for sp, but, in the case we implement that language, should we go against some Oracle copytight infringment ? Why would you want to do such a thing? Isn't SQL good enough? I'm just trying to figure out your reasoning here, besides the same argument used by the XML crowd of it's the latest/greatest do-all-be-all-end-all, so everyone should be using it type of nonsense. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php