Re: data types
On Sun, Apr 01, 2001 at 11:02:22AM +0100, Einav Lavi-Lapidot wrote: Hi all , Can I get a list of all data types at mySql 3.23 ? I'm starting to work with it, and it would be very helpful. Thanks, einav. Certainly. They're all documented in the manual: http://www.mysql.com/doc/ Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Dual Processor and MySQL !
On Sun, Apr 01, 2001 at 02:55:02AM +0330, Hamid Hashemi Golpayegani wrote: Therefore if I am using Linux for my MySQL server both of my CPU's will help to serv the MySQL queries if I am installing the SMP in my kernel right ?! Correct. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ---- Virus Detected ----
On Sun, Apr 01, 2001 at 07:58:19AM +0200, Benjamin Pflugmann wrote: I got the warning too, and also run Linux. So this doesn't seems to be connected to the operating system. And neither to a certain thread: I got it on mails to abitrary threads. Same here. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need examples of companies using mysql
On Fri, Mar 30, 2001 at 02:56:53PM -0500, Anthony R. J. Ball wrote: Hehe, yeah, I mentioned slashdot... for some reason, they just weren't impressed :) You know the type... unless they are a big money company, then they can't be doing anything mission critical :) We use MySQL quite a lot and even manage to generate money once in a while... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: safe_mysqld options
On Thu, Mar 29, 2001 at 02:09:02PM -0500, Thalis A. Kalfigopoulos wrote: Hello, A question about the -O option you can pass on command line to safe_mysqld. If for example I give -O record_buffer=64M does that mean that I'll get: exactly 64M, at the most 64M or at least 64M? At most. You're setting an uppper bound so that MySQL won't grow past what you think is reasonable. Also I have a batchfile with about 150 queries (all plain selects) which I feed into mysql. Are they all going to be executed by one thread sequentially or split amongst many threads? One thread. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: File size problem!
On Thu, Mar 29, 2001 at 01:46:28PM -0800, Guanglin Dong wrote: Hi, I have problem about the mysql database file. After I deleted a lot of table records, the database data and index file still have the same size as that before I deleted a lot of records. Anybody knows how to shink the database file size after I delete a lot of records? Thanks in advance. OPTIMIZE TABLE talble_name Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Synchronization
On Wed, Mar 28, 2001 at 05:22:56PM +0200, Martin Jeremic wrote: I have two mySQL servers, one is in office, and other at home. I need to synchronize then via DialUp TCP/IP connection (not Internet DialUp). Can somebody help me ? Does MySQL replication suit your needs? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL for Sun Intel
On Tue, Mar 27, 2001 at 01:45:16PM -0600, Brady Orand wrote: Go back to version 3.22. It works very well. The most current vertion hasn't been ported yet. I could build a Solaris Intel 2.6 binary if needed. It'll probably work on Solaris 7. Lemme know if there is interest... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL vs MS-SQL performance
On Tue, Mar 27, 2001 at 02:12:36PM -0800, Steve Quezadas wrote: Anyways, a period of time elapsed and we decided to move to MS-SQL server for feature reasons, and when we had the MS-SQL ODBC driver point to the newly created MS-SQL server (roughly same specs), it was like 50% faster! What gives? Is MySQL *really* that slow, MS-SQL *really* that fast, or maybe there was some weird setting in the ODBC driver or the MySQL server that I didn't switch right which made it go slow. I am not sure. Or maybe Microsoft, in their monopolistic ways, created special hooks between ASP and MS-SQL server to make the communication go somehow faster. Anyone had similar experiences to mine? Odds are that you didn't tune MySQL at all. Unlike most commercial database servers, MySQL "out of the box" isn't tuned for heavy usage. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication troubles
On Fri, Mar 23, 2001 at 10:45:00AM -0800, Bryan Coon wrote: I have two machines which I am trying to set up replication on. I followed the howto as describe in the manual, and everything seemed to be okay (i.e. no errors), but it simply doesn't work. Heres what I did on the master: 1. Copied /usr/share/my-large.cnf to /etc/my.cnf 2. my.cnf already had log-bin, server-id=1, so I didnt touch anything else 3. Granted file to user repl as in howto 4. Shut down master 5. Tarred data dir, copied it to slave 6. Restarted master Heres what I did on the slave: 1. Copied /usr/share/my-large.cnf to /etc/my.cnf 2. Added following info: master-host = 172.34.123.34 # IP of master master-user = repl master-password = repl master-port = 3306 server-id = 2 3. Untarred data directories to /var/lib/mysql 4. Verified permissions on directories/files untarred 5. Restarted slave The my.cnf file appears to be read okay, because on both machines began generating the binary log files immediately. Both machines report everything normal and happy, with no entries in the .err log files. Users can connect to each machine independently and its business as usual. There is no file 'master.info' generated on the slave (I even checked on the master too)... That's sort of strange... Does "SHOW SLAVE STATUS" on the slave say anything interesting? What if you do a "SLAVE START" on the slave? You're sure that there is literally nothing related in the *.err file on the slave? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Does repliation impact on performace?
On Sun, Mar 25, 2001 at 10:21:04AM -0700, Brendin wrote: Lets say you have to mysql servers one is going to be a master and one a replication slave. The master is a very fast dual CPU machine with a SCSI raid array. The Slave is a fast single cpu machine with a 7200RPM UDMA 100 hard drive. The slaves purpose is to act as a backup for the master. Will the slave slow down the master server? Is the performace of a master server in any way dependant upon the performace of its slaves? In my experience, the slave places a negligible load on the server. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL Market share
On Fri, Mar 23, 2001 at 10:42:10AM -0700, Dan Harrington wrote: Greetings everyone, Does anyone know if a reputable source has done market share studies with the various SQL servers out there in enterprise Web settings? I'm trying to convince a company to have support for more than Microsoft and Oracle servers so I am looking for some numbers to back me up :-) If anyone can help me with this, I would appreciate it. I don't care too much if it includes all of the open-source SQL servers out there, just something to open their eyes. The Marketing guy (forget his name) From Sleepy Cat Software (of Berkeley DB fame) had an interesting presentation at the Open Source Database Summit last year. It had some information in it that you might find useful. If I could remember his name, it'd be more helpful. But you can probably contact [EMAIL PROTECTED] (or something similar) and get in touch with him. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: size limitation
On Sat, Mar 24, 2001 at 05:30:52PM +0200, Heikki Tuuri wrote: MySQL/Innobase may be able to do what you need, but we should have a real-world test of using a big disk farm. I do not know if any MySQL user uses a disk farm. Maybe Jeremy Zawodny knows? I don't know of anyone doing that yet... But I'm sure they're out there somewhere. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Let me see
On Fri, Mar 23, 2001 at 11:05:09AM -0800, Mike Roberts wrote: My name is Mike Roberts, I have been working with php and MySQL since the end of December. I think I am doing pretty good. But what I really want is for you people out there to send me to a website that you have built. I'm interested in see all the different things people have created using the MySQL database system. If you can please send me the URL of the site you are building. http://biz.yahoo.com/ne.html Much of the Yahoo! Finance content you see on a host named "biz.yahoo.com" was produced with the help of MySQL. There's also some stuff on sports.yahoo.com and lots of other *.yahoo.com sites. Maybe a little description on how the DB works and all. If I had the spare time now, I'd do it... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL vs Microsoft SQL
On Fri, Mar 23, 2001 at 01:09:47PM -0500, Ciprian I. Acatrinei wrote: *This message was transferred with a trial version of CommuniGate(tm) Pro* Hi, I would need some reasons for choosing MySQL instead of Microsoft SQL. (beside the fact that MySQL is free). (not for me but for my boss). It may sound silly but trust me I really need these reasons. So please help me with this. If you're sure it will meet your needs and you already know that it costs less, the other big benefit is the support. MySQL support is very good (and inexpensive). I don't know of many MSSQL server users who have mailed bug reports directly to the core developers and received a response in less than 12 hours... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: speed of list
On Wed, Mar 21, 2001 at 10:01:23PM +0100, Ren Tegel wrote: the email list seems to be very slow now and them... wouldn't it be an option to make a web-based list ? In addition to the e-mail version, or instead of it? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: HELP!!!
On Fri, Mar 23, 2001 at 09:16:48PM +, Daniel Adams wrote: Can anyone tell me how to fix this error: ERROR 1016: Can't open file: 'message.MYD'. (errno: 126) Fix the file permissions so that mysql can read the file. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Multiple master replication
On Thu, Mar 22, 2001 at 12:47:06PM +1100, Wayne Parrott wrote: Is their any way to have multiple masters for one slave? The purpose of this is to backup multiple databases to one server easily, if their is no way to do this with replication are their any other methods of remote backup? Thanks Wayne A logical slave may only have one master. But there's nothing to prevent you from running multiple copies of MySQL on a physical machine. Each copy can be the slave of a different master. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: why 3 processes?
On Tue, Mar 20, 2001 at 10:51:14AM -0500, Nick Taylor wrote: Howdy: New guy to MySql and just installed 3.23 to my redhat 6.2 server. Was wondering why I get 3 processes started for mysqld. Because that's how the Linux kernel implements threads. (This seems to come up every week.) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Read/write table lock
On Tue, Mar 20, 2001 at 03:05:53PM -0300, Fabio Galarraga wrote: Hi to all: Somebody knows how to make a read/writa table lock? I'm trying with java source: stmt.execute("LOCK TABLES table-x READ, table-x WRITE"); stmt.execute("UNLOCK TABLES"); but it fails. And what is the error message? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: setting a new default nice value
On Tue, Mar 20, 2001 at 09:09:41AM -0700, Sasha Pachev wrote: On Tuesday 20 March 2001 07:58, Richard Ellerbrock wrote: Also, it would be REALLY cool to be able to specify a time limit for a select after which time it would die. I know this can be set globally, but this will not work for me as my server has many web apps (php driven) all using the same database - each app having different requirements. What grinds me is that some users enter crap searches on my apps and then hit the stop/cancel button when it takes too long. I know in upcoming versions of php they plan to somehow "fix" this - how I do not know. Oh yes, my databases are normalised. For now the workaround would be to write a daemon or a cron job that connects to MySQL once in a while, runs show full processlist, check the execution time and command type, and kills all threads that have exceeded the limit on select. The major downside of that is that it will kill the client's connection to the database (maybe casing to think the db server died). Will there be an enhancement to the MySQL protocol in 4.x to allow for a more graceful "query timed out" response to the client? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: suggestions for implementing heavily used log tables with nightly delete
On Mon, Mar 19, 2001 at 02:40:58PM -0600, Neulinger, Nathan R. wrote: Got any suggestions on how these could be implemented? particular table types/setups/etc? I basically have a situation where 300,000+ rows are being inserted into a log table daily, and also needing to be cleared out based on a tstamp. What I've found is that the inserts work fantastic, but when I got to do the delete, even if it doesn't do anything, it sits there and blocks everything on the server for 20-30 minutes. Is this because of the lack of row-level locking on MyISAM tables? Yes. Should I switch to a different table handler? Maybe. Right now, I'm using multiple merge tables, split up to divvy up the space used. Certain log entries are getting kept longer than others due to the decreased volume those hosts generate. I was just about to suggest MERGE tables. If you create a table for each interval (day, week, hour, whatever your requirements are) it may improve things quite a bit. If splitting the tables based on time constraints isn't easily doable, you might look at testing BDB or maybe Innobase tables (just added to MySQL). The BDB tables have page-level locking, so you'll probably get some relief there. And Innobase has row-level locking with a non-locking consistent read, so it could be even better. But it's fairly new to MySQL. The impression I have is that a lot of people are looking at Innobase tables now and pushing them to see what they're capable of. If you've got a bit of time to hack on it, that may help. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Will MySQL_Linux_Apache handle Yahoo level traffic data?
On Mon, Mar 19, 2001 at 06:05:47AM -0800, tmb wrote: I'm a newbie to the Linux-Apache+MySQL world. 1 - Will MySQL handle a data base as large as a Yahoo or Google or E-Bay ? Done properly, yes. 2 - Will MySQL running on a Linux/Apache system handle traffic that approaches that of a Yahoo, Google or E-Bay? Same answer. 3 - Does MySQL have an equilivant to "stored proceedures? Not today, no. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Traffic accounting
On Mon, Mar 19, 2001 at 05:06:28PM +0100, Gernot Hueber wrote: I want provide access to my MySQL Server to several customers. How can I count IO traffic per user, and any user accesses (I don't want a full log, only log ins)? There's not built in facility for doing that today. Are all the customers accessing the same data, or separate data? If separate, you could run a server for each (assuming there are few customers) and run them each on different TCP ports. Then you just need to measure traffic to/from those ports. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Alteon + forks
On Mon, Mar 19, 2001 at 04:13:25PM -, Pedro wrote: I have 2 servers and 1 alteon in HA. But the problem is that the alteon , when trying, to see if the servers are up or down , makes mysql to fork , till it dies.. I'm not sure I understand... Probably because I don't know what an aleton is. Can you provide a bit more detail? Thanks, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ARCHIVING UNDER HEAVY LOAD
On Mon, Mar 19, 2001 at 04:06:29PM +0300, Anatoly Chubais wrote: Hello! There's a need to design a system (something like online forum) that will be storing huge amount of small messages in database. There must be fast access only to messages for the last 3 days (guess this means that main table with indexes on it must be kept small?), while other messages can be stored in rarely accessed archive (different table?). What's the best practice for implementing archiving in MySQL? In Oracle there's an ability to "switch off" part of the table and then move it to archive in background mode. What about MySQL? See my message to Nathan with: Message-ID: [EMAIL PROTECTED] and the related thread for the discussion of a similar topic. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.35 is released
On Sun, Mar 18, 2001 at 11:51:39AM +, Peter Skipworth wrote: I'd love to see some benchmarks soonish if anyone has/is about to compare each of the table handlers for speed and stability. Personally I'd love to have row-level locking, but don't want to do it if it means lower stability and/or slower basic select/insert queries. There have been a varitety of Innobase vs. MyISAM benchmarks posted in the past few days. I'm sure more will follow. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.35 is released
On Sun, Mar 18, 2001 at 03:31:47PM -0500, [EMAIL PROTECTED] wrote: On 17-Mar-2001 Jeremy D. Zawodny wrote: Er. Is there any way you guys can actually form a stable branch, and a development branch? It would be nice to get a stable version of mysql with replication, and that's not going to happen with all of these new features being pumped into a supposedly "stable" branch. Don't enable innobase or gemini, and you'll have a stable server. Seriously, if you don't even compile in the new features, there's little danger of them affecting you. Little danger?! Correct. Look, let's approach this another way. 3.23.xx isn't stable, and hasn't been ever, because it _was_ a development branch, and you keep treating it as such, while at the same time you call it your stable branch. This is wrong. Not stable? Compared to what? I've had a server running several versions of 3.23.xx for about 6 months now. In that time it handled over a billion queries. Yes, a billion. The current one has been up for over two months running 3.23.29 (which was declared "gamma") without a hitch. Perhaps you haven't heard of such a thing as a development branch, and stable branch of code. Maybe you haven't heard the term "beta" and "alpha" ever before. 3.23.xx is BETA, and unusable in a production enviroment. I believe I (and many others) have evidence to the contrary. The MySQL team declared it "stable" for a reason. The development branch is 4.0.xx. Maybe I should say that again. 3.23.xx is BETA, and is unusable in a production enviroment. You need a stable branch, and a development branch, and you need them ASAP so that current MySQL code can be made stable enough for a production enviroment. Well, then I'll say again what I just said. The development branch is 4.0.xx. 3.23.xx (for the right versions of xx) is stable. Don't take this the wrong way. MySQL is a great product, but any great software product is a piece of crap if its crashing and causing problems because you keep it in a consitantly beta state. There are many, many, many folks running 3.23.xx without it constantly crashing. Is there some widespread problem that we're unaware of? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unique/Index/Primary
On Sun, Mar 18, 2001 at 03:58:46PM -0500, Ryan Shrout wrote: Could someone explain to me the difference between the Primary/Index/Unique attributes of MySQL? I am coming from using MS SQL where there is only the Primary key option. And INDEXed column may have duplicate values in it. A UNIQUE one may not. A PRIMARY KEY is simply another way to say "UNIQUE" with the side-effect that the PRIMARY KEY is stored first in the index file for the table. So UNIQUE is a special case of INDEX, and PRIMARY KEY is a special case of UNIQUE. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Updateing row contents
On Sun, Mar 18, 2001 at 06:40:36PM -0500, Travis Gant wrote: How do you update the contents of a specific field in a database? Say I have a column named Name in a table, and a row has the contents of that column set to "Jhon". Now, the user accidently spelled John wrong and would like to update it, how can I do that? Using the UPDATE command. See the manual for details. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql restarts at 100% CPU
On Mon, Mar 19, 2001 at 12:34:30AM +, vinod p wrote: my mysql server restarts automatically when the machine touches 100% CPU usage. any ideas why? What does the error log say? Anything? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.35 is released
On Mon, Mar 19, 2001 at 02:55:17PM +1200, Quentin Bennett wrote: Hi, To be fair to the anonymous writer, the main reason for introducing 3.23.25 was Changes in release 3.23.35 -- * Fixed newly introduce bug in `ORDER BY'. Nothing there about 'in Innobase and/or Gemini Tables', and for a release that is declared Stable to have a bug introduced is a bit of a no-no. If the bug only affected parts of the release that are still alpha, beta or gamma, as some of the new table types are, then the change notice should really reflect that, so that a new user is sure of what is affected, aiding the 'To upgrade or not upgrade' decision. Bugs (sometimes rather old) have been found and fixed in stable versions of MySQL before. The same is true of the Linux Kernel. That doesn't change the fact (in either case) that the developers are confident enough in their work to label the code "stable". I'd say their track record (and the thousands of satisfied users) says a lot about their judgment. Some may not agree with it, but that is how they've done things. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.35 is released
On Sat, Mar 17, 2001 at 06:56:34AM -0500, [EMAIL PROTECTED] wrote: On 17-Mar-2001 Greg Cope wrote: Michael Widenius wrote: Hi! Greg On the off chance any ideas when this (A Gemini THandler) 3.23.x release Greg may be and when we might see a public 4.x alpha. I know the answer will Greg probably be "When its ready" but a small clue would be nice :-) Lets guess a bit :) 3.23.36 with GEMINI should happen within 2 weeks. 4.0-alpha should happen within 2 months. Er. Is there any way you guys can actually form a stable branch, and a development branch? It would be nice to get a stable version of mysql with replication, and that's not going to happen with all of these new features being pumped into a supposedly "stable" branch. Don't enable innobase or gemini, and you'll have a stable server. Seriously, if you don't even compile in the new features, there's little danger of them affecting you. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.35 is released
On Sat, Mar 17, 2001 at 12:53:50PM -0800, Patrick Calkins wrote: Hello all; Sorry to sound a little naive, but what is this new GEMINI thing I have been reading about? Is there any FAQ/Docs on it or what is so neet about it?? It is a new table handler which is being developed by the folks at NuSphere (www.nusphere.com). Like the new Innobase table handler it offers row-level locking, transactions, and lots of other goodies. Very soon you'll be able to choose from 6 different table types in your MySQL applications: ISAM MyISAM HEAP BDB Innobase Gemini Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: forwarded message from Van
On Fri, Mar 16, 2001 at 07:39:01PM -0700, Sasha Pachev wrote: Here is what you can do: server1 - server2- server3 - server4 - server5 - ^ | | | --- Arrows indicate master-slave relationships I tested a setup like that recently (with 3 servers) as a proof of concept for a project we're thinking about and found that it didn't quite work. But I didn't spend a lot of time debugging it, either... Was there a bug related to this sort of a setup that was fixed in a VERY recent version of MySQL? I noted a change in the logs for .33 or .34 but it wasn't very specific. Thanks, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Regexp matching
On Thu, Mar 15, 2001 at 08:50:01AM -0800, Mike DeWolfe wrote: I'm having a problem with REGEXP : I have several rows that look like this : Health : health services : safety : physical abuse : women Health : health services : safety : rescue Health : health services : safety : sexual abuse Health : health services : safety : sexual abuse : children Health : health services : safety : sexual abuse : women Health : health services : safety : travel-general cautions Health : volunteer services : children I want to do a search that selects "Health : {words]" but ignores "Health : {words] : {words]". I've tried combinations of [\w] and[a-zA-Z] but they're all or nothing-- either I get all of the results with one or colons or none of the results. Any help would be appreciated. What about "Health : [^:]*$" ? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Database and NAS
On Thu, Mar 15, 2001 at 05:07:08PM -0700, Steve Ruby wrote: Patrick Calkins wrote: Hello all; Are there any known problems with storing the database files on a NAS (network attached storage) device?? also, can you run multiple MySQL daemons pointing to one common database, so you could have a "cluster" of database servers and one database?? Thanks! Patrick You can only have one data repository and multiple servers if you never write to your database.. Unfortunately unless you use replication mysql doesn't handle mutliple servers pointing at the same data, one server has no way of knowing that cached indexes are out of date based on updates by another server. Even with it's external locking support? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How many rows does a table can hold?
On Wed, Mar 14, 2001 at 07:19:24AM -0800, abdelhamid bettache wrote: I want to ask you : 1- How many rows does a mysql table can hold? Millions. Probably billions. I've heard of someone putting 2 billion rows in a table before (if memory serves). 2- I have to design a database for all universities of my country , Is it better to consider one database for each university or one database for all universities . Note that a query on a table "student" would be more quick if I use for every university its own student table . If the data structures are identical, there should be little need to split them out into their own tables. Speed shouldn't be an issue if it is indexed properly. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Failover and Replication
On Wed, Mar 14, 2001 at 09:10:42AM -0800, Bryan Coon wrote: We are implementing a linux cluster, and rather than get gouged by oracle (in performance and licensing) would much rather use MySQL. A common solution to a common problem, I suspect. If I understand correctly, replication creates a working copy of mysql on another server, but it looks like the algorithm to automatically change slave to master if the master dies will not be added until mysql 4.x (from 11.4 in the manual). Right. Is this still the case? Yes. Does anyone have any stories/suggestions/experiences in regards to rolling our own monitoring script? What about having a dual-master setup? It's a bit tricky to get right, but it certainly can work. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL takes too much memory
On Wed, Mar 14, 2001 at 03:44:34PM +0700, Mohamad Ilhami wrote: Hi, after a few days, mysql take too much memory and sometimes causing swap memory exhausts. I'm sure that only one client accessing mysql server, but I see too many threads. So I shutdown MySQL periodically. I use mysql-large.cnf configuration file. If the client was killed by KILL signal, or terminated unexpectly, does mySQL thread exit automatically? Any one have suggestion? Well, try decreasing some of the values in your my.cnf file so that they more closely match the amount of memory you're willing to let MySQL use. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Any ideas why this would happen....
On Wed, Mar 14, 2001 at 05:36:00PM +1100, Leonard Coonan wrote: Further to your comment, I have had considerable benefits by creating an index of both keys as well. So I define 3 indexes userid, usernum, useridusernum. One of those is redundant. If you index (userid, usernum) and then (usernum), your bases are covered. Creating a sinle index on (userid) is not necessary. The docs will explain why... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Innobase SHOW VARIABLES (Re: getting frequent signal 11 after upgrade from 3.23.28 to 3.23.34)
On Tue, Mar 13, 2001 at 09:48:22PM -0800, Jeremy D. Zawodny wrote: On Wed, Mar 14, 2001 at 02:42:30PM +0900, Tatsuhiko Miyagawa wrote: On Mon, 12 Mar 2001 10:02:51 -0500 [EMAIL PROTECTED] wrote: I just upgraded from Mysql 3.23.28 to 3.23.34 and I'm now seeing mysql errors from my scripts that say "mysqld has gone away". The /var/lib/mysql/host.err log says this repeatedly: same here. Compiling with Innobase, and doing "mysqladmin variables" command always leads to mysql crashing restarting. Similar here. Innobase appears to work well, but when I issue a "SHOW VARIABLES" on the server, it will crash. I can produce a core/backtrace if necessary, but it sounds like this easy to reproduce. Damn. Monty has already patched it. :-) -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Innobase SHOW VARIABLES (Re: getting frequent signal 11 after upgrade from 3.23.28 to 3.23.34)
On Wed, Mar 14, 2001 at 03:51:18PM +0900, Tatsuhiko Miyagawa wrote: Oops, really :-) Yes, he posted it in the message with Message-ID: [EMAIL PROTECTED] Jeremy On Tue, 13 Mar 2001 22:48:58 -0800 "Jeremy D. Zawodny" [EMAIL PROTECTED] wrote: I can produce a core/backtrace if necessary, but it sounds like this easy to reproduce. Damn. Monty has already patched it. :-) -- Tatsuhiko Miyagawa Livin' On The EDGE, Co.,Ltd. mailto:[EMAIL PROTECTED] http://www.edge.co.jp/ -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with replication
On Sun, Mar 11, 2001 at 06:16:22PM +0100, Rick Jansen - Tweakers.net wrote: Hi there, I'm trying to set up replication. But it's not working, for some strange reason. This is the error out of the slave log: 010311 18:11:25 Slave thread: error connecting to master:Access denied for user: 'repl@athena' (Using password: YES)(0), retry in 60 sec When i try to connect "manually", ie using the mysql tool, it works like it should. I get in with no problems. There are no errors in the master server logfile. Any idea what's going on here? What if you remove the "master.info" file on the slave and restart the replication? I've found something that I haven't reported as a bug, but I probably should. If you start replication, the slave stores the replication info in the master.info file. If you stop replication and the change the parameters in your my.cnf file, mysql reads the master.info file but never "sees" the changes you made in my.cnf. It just uses the old values in master.info. I've noted it in the on-line docs (in the comments at the end): http://www.mysql.com/doc/T/r/Troubleshooting_Replication.html but it should either be integrated into the docs or fixed. I'll find out if it is a bug or not first, I guess. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with replication
On Sun, Mar 11, 2001 at 09:02:57PM +0100, Rick Jansen - Tweakers.net wrote: Thanks for your time. I disabled replication (slave stop), removed the master.info file (it did contain a wrong/old password), stopped the mysqld (mysqladmin -p shutdown), and restarted it (safe_mysqld ). The information in master.info is correct now, but still it gets an access denied. The password is right, the user is right, the hostname is right.. sigh. Hmm... Anything relevant in the server's error log? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: am I alone? (scale)
On Sat, Mar 10, 2001 at 06:41:20PM -0500, Justin wrote: Today I was having more index corruption problems.. the fact that it typically happens on the *biggest* and *busiest* tables leads me to believe that the request rate on my database might be right off the scale compared to other users, who are not reporting corruptions nearly as often. My corruption issues on any given table seem to have risen as a function of average request ratio times table size. Please, if you can do a mysqladmin extended-status and report to me or the list what your questions/uptime is if it is = where I am, and whether or not you need to to use isamchk frequently, or if you have no issues. Today the ratio is currently 304 (3.7million questions and 12000 seconds of uptime), but weekdays it is over 500 / sec .. Hm... I've had numbers higher than that for several hours at a time without trouble. What OS are you on? Did you compile your own mysql, or are you using one of the provided binaraies? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: am I alone? (scale)
On Sun, Mar 11, 2001 at 01:16:20AM -0500, Justin wrote: Well thats good to know.. although this is sustained 24x7x365 My average rate over the last 67 days is about 52/second. In reality we have some periods of much higher load (several hundred per second) and some of much lower load. It is just about to hit the 300,000,000 query mark since it was last shut down (for the upgrade 67 days ago). I'd like to hit a billion queries before the next downtime, but who knows... I'm currently running 3.23.29-gamma using the staticly linked version from mysql.com. in an attempt to get stability, I've been running on the official 3.22.32 mysql binary for a month now .. it hasn't helped. I'd highly recommend upgrading to 3.23.xx. You should see better performance with MyISAM tables. I'd also highly recommend using a static binary from the mysql web site. Typically indexes get corrupted and cause selects to malfunction, OR, cause mysqld to crash, OR cause count(*) or distinct(*) queries to run in infinite loops, but not necessarily on the corrupt table. it seems to me index corruption can poison the server beyond the afflicted table. Certainly can. If a thread starts to suck cpu time, the whole system will suffer and start to spiral down into places you'd rather not look. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: key lengths
On Wed, Mar 07, 2001 at 07:49:22AM -0600, Mike Thompson wrote: Yes, I've tries that here is the error I get. Your MySQL connection id is 247 to server version: 3.23.33 mysql CREATE TABLE foo( - id INT NOT NULL AUTO_INCREMENT, - name BLOB NOT NULL, - PRIMARY KEY(id), - UNIQUE(name(500)) - ); ERROR 1089: Incorrect sub part key. The used key part isn't a string or the used length is longer than the key part No key part can be greater than 255 in lenght. But multi-part keys can be longer (in total) than 255. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: locking oddity
On Thu, Mar 08, 2001 at 10:30:18PM -0500, Justin wrote: Typically, in a database backed website with a very high percentage of selects to inserts, people do not "expect" update operations (posts and so on) to complete very fast. But they do "expect" page requests to be very fast.. the default behaviour does not seem to meet this objective? Correct. If you always blindly give selects priority, it is possible (on a busy site) for inserts to take a very long time to complete. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: BDB tables on Linux
On Mon, Mar 05, 2001 at 11:27:54AM -0600, Stephen Faustino wrote: I've installed 3.23.33 on both Solaris and Linux RH 6.2 using the tarball for Solaris and the RPM for Linux. The BDB tables work as expected on Solaris, but they did not not work under Linux. What I'm seeing is that I can create a BDB just fine. However, attempting a rollback results in: ERROR 1196: Warning: Some non-transactional changed tables couldn't be rolled back When I do a mysqldump, the ddl for the table shows a type of MyISAM. This suggestst that they weren't created as BDB tables. Can you verify that they're created properly? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: About licence
On Mon, Mar 05, 2001 at 10:34:38AM +0100, Piotr Szybiak wrote: I am a 5th year student of University of Technology in Poznan (Poland). I would like to use MySQL in commerce project (Internet Auction). I will develope my Auction in Linux. Have I buy a licence from you ??? How many it cost. Pleace answer me, it is very important for me. Thank you. Piotrek MySQL is now under the GPL. So if you want to spend the money, you can purchase a support contract from mysql.com. There are details on their site. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: BDB tables on Linux
On Mon, Mar 05, 2001 at 04:10:59PM -0600, Stephen Faustino wrote: show variables showed that have_bdb is no, and none of the bdb variables are there. So does this mean that BDB is NOT compiled into the binary included in the Linux RPM, or does it mean that I need to add the necesary BDB-related variables to /etc/my.cnf? You must compile the BDB support. It's currently not in the RPM. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: DBD::mysql
On Mon, Mar 05, 2001 at 04:36:27PM -0500, John Tsangaris wrote: I am trying to install DBD::mysql on a server which does not have mysql on it. ( The script will be accessing a mysql database on another server). The problem is, when I try to install dbd::mysql I am asked several questions.. one of which being: what is the path to mysql? I don't have a path to mysql as it is not installed and I don't want to install it. Is there a way to install DBD::mysql without having to install mysql? You at least need the MySQL client libraries on that machine. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Long deletes
On Wed, Feb 28, 2001 at 02:38:40PM -0500, Michael Villalba wrote: I have a rather large table (~130 million rows) running under MySQL 3.23.30 and have been very pleased with the performance of the database. However, occasionally I have to delete millions of rows from the table, and it appears that MySQL hangs on these jobs. To be specific, I am running a delete job now that will remove about 4 million rows. It has been running for 11 hours on a 4-processor Sun E450 with 4Gb. The OS is Solaris 2.7. For about the last 10 hours the state displayed by 'show processlist' has been 'end'. How big is your key_buffer? record_buffer? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Sample .cnf files
On Tue, Feb 27, 2001 at 02:04:24PM -0500, Mark Chalkley wrote: Can anyone tell me where I can download the sample .cnf configuration files mentioned in the documentation. I downloaded the Win32 source package (I paid for a license) and they're not in it. Are they only in the Unix source package or are they somewhere else? Really? Is there no "support-files" subdirectory (or something similar) as their is on the Unix side of things? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Security annoucement mailing-list ?
On Mon, Feb 26, 2001 at 04:34:20PM +0100, Nicolas GREGOIRE wrote: is it possible to create (I don't think it already exists) a mailing-list just for security problems about MySQL. I'm very concerned about the security of my web sites, and I rely on MySQL to provide dynamic content. So, for the moment, I must subscribe to the general list and receive tons of messages just to see sometimes a security annoucement (like the recent buffer-overflows) Does anybody share my point of view about this security-only list ? Not exactly. I'd rather see them sent to the MySQL announcements list. It is already VERY low-traffic, and that seems like appropriate content. No sense creating another list just for the VERY occasional announcements when we already have one [mostly] for that purpose. Thoughts? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: LIMIT usage
On Mon, Feb 26, 2001 at 06:19:46PM +0100, Joseph Bueno wrote: Hi, I currently use a SELECT that looks like: SELECT field FROM some_table WHERE some_condition ORDER BY some_date DESC LIMIT 2000 in order to get the most recent records from some_table. Since it is not possible (yet) to optimise an ORDER BY ... DESC by using an index; is it possible to rewrite SELECT statement: SELECT field FROM some_table WHERE some_condition ORDER BY some_date LIMIT ? so that results will be ordered in ascending order and return the 2000 *last* records ? Well, you could store an additional field which is like the opposite of the date. Since dates normally count forward from some time in the past, you just need something that counts backward from some time in the future. You might consider using a unixtime value. MySQL can convert from/to unixtime easily (check the manual), and there is currently a known upper bound on the date that a unixtime can represent. So you could store a field which you compute by taking the current unixtime (983213418) and subtracting it from the upper-bound. Think of it as field = max_unixtime - current_unixtime Then the numbers will be SMALLER as you go into the future, so you can sort them easily. But there are many cases in which this isn't a good idea. So it may work for you, or it may not. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: auto_increment
On Mon, Feb 26, 2001 at 04:23:23PM -0800, John Tsangaris wrote: If I turn on auto increment and let it do it's thing and then later on delete a few of the entries (let's say 1, 2, 3) and the current high entry has an id of 45.. why does mysql continue with 46 instead of using up 1, 2, and 3 first? Is there a way to bypass this? Logically, going from 45 to 1 or 2 or 3 isn't an "increment", it's a decrement. If you never want holes in the series, then auto_increment may not be the best option for you... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Temporary tables, BDB tables, and Innobase questions
On Mon, Feb 26, 2001 at 05:52:09PM -0600, Stephen Faustino wrote: 3. I've read several posts regarding the Innobase tables. Where can I download the source from to start trying to use Innobase rather than BDB tables? They'll be in 3.23.24 when it is released. Or you can pull them from the public bitkeeper repository. Instructions were posted on this list a while ago. Should be in the archives. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mod_auth_mysql
On Mon, Feb 26, 2001 at 06:23:29PM -0500, Peter R. Wood - Mailing Lists wrote: Hi all, Does anyone know if mod_auth_mysql is still under active development, and if so, where can I find current information on it? Which one? There appear to be two. Go here and search for "mysql" http://modules.apache.org/ I have searched the list archives here and indeed turned up 254 instances of people having problems with mod_auth_mysql. Yeah, it's been pretty common. If nobody *IS* maintaining it, you could always take it over. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Index Usage weirdness
On Sun, Feb 25, 2001 at 12:37:32AM -0500, Mark Chalkley wrote: At this point, there's only 1 row in companies, and 8 in contacts. MySQL won't use an index on tables with so few rows. It is simply faster to scan the whole table. As you tables grow, however, MySQL will begin to use the indexes. This is documented in the manual (though maybe not with hard numbers). Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Replication question.
On Sun, Feb 25, 2001 at 03:29:37PM +0900, wrote: It sounds like you are using a version of MySQL that had a replication bug in it. I suspect that if you upgrade to 3.23.33 the problem will go away. No, Master is 3.23.33, and slave is 3.23.32 3.23.32 was troublesome for slaves. Here http://www.mysql.com/doc/N/e/News-3.23.33.html you'll find an entry which says: Fixed bug in replication that broke slave server start with existing master.info. This fixes a bug introduced in 3.23.32. I'd suggest and upgrade to see if it solves your problem... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: create table
On Mon, Feb 26, 2001 at 01:26:55PM +0800, WANG_KING wrote: Anyone can give me an example of create a transactional table in V3.22.23? Thanks. Simply append "Type=BDB" to any CREATE TABLE statement. CREATE TABLE foo ( bar int not null, baz varchar(10) not null ) Type=BDB Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ?difference between Primary Key, Key, Index, Unique
On Sat, Feb 24, 2001 at 09:43:45AM -0700, Karl Stubsjoen wrote: I'm trying to understand MySQL indexing but am having trouble understanding the differnences (and when to use each) between Primary Key, Key, Unique, an Index. Can you help? Index and Key are the same. A Primary Key is a Unique Index. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Index Usage weirdness
On Sat, Feb 24, 2001 at 11:33:40PM -0500, Mark Chalkley wrote: I have a question about index usage. I've got a query that's showing up in the -slow log (it's taking less than long_query_time seconds, but I've got --log-long-format set), indicating that it's not using an index, and I don't understand why. Given two tables: CREATE TABLE c1 (id INT(8) NOT NULL UNIQUE, txt VARCHAR (10) NOT NULL UNIQUE, PRIMARY KEY (id) ); CREATE TABLE c2 (id INT(8) NOT NULL UNIQUE, PRIMARY KEY (id) ); CREATE UNIQUE INDEX c1_txt_idx ON c1 (txt); And the query: SELECT * FROM c1, c2 WHERE c1.id=c2.id ORDER BY c1.txt; How much data is there in those tables? What does the output of EXPLAIN on that query look like? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Redirection of SELECT with replicated databases
On Fri, Feb 23, 2001 at 10:16:55AM +0100, Guido Adam wrote: maybe a FAQ, but I didn't find it in the docs: We started to replicate our databases with the new features MySQL 3.23.33 offers. So far, so cool. The documentations says something about SQL commands (i.e. SELECT) that are redirected from the master servers to the slaves. How does that work? Is it an automatic redirection? SELECT queries are not redirected and I don't think there are plans to do so--at least I've not seen anyone mention it. There has been discussion of implementing a redirect feature on the SLAVE that will redirect non-read-only queries to the master. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ReisserFS
On Thu, Feb 22, 2001 at 03:22:13PM +, Simon Windsor wrote: Hi Has anyone user MySql on a ReisserFS file system ? Yes. Where any problems encountered ? and do you have any pearls of wisdom that you are willing to share ? It "just works". :-) -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: installing on linux
On Thu, Feb 22, 2001 at 06:29:47PM -0600, Mac Martine wrote: hello- i just ran gunzip on the binary distribution i got from mysql.com ( mysql-3.23.33.tar.gz ). The 'mysql_install_db' cannot be run because it has a '.sh' ending on it. Actually many of the files in that same folder have a '.sh' ending. (mysql_install_db.sh) Why is this, and what do I do!? It sounds like you picked up the SOURCE distribution instead of the BINARY distribution. The tarball filename should have been longer than that. Many of the MySQL scripts start life as foo.sh and are translated to foo during the build process. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: The security concerns about MySQL
On Wed, Feb 21, 2001 at 04:02:50PM -0800, Abby Jiang wrote: I am planning to install an application program that use MySQL as backend on our external server. There are other important database server running on the server too. Does anyone know how secure the MySQL is? I trust it. :-) Will it be safe to install it on the server host? Maybe. If you don't configure things securely, it could be a real problem. But the same is true of Apache, sendmail, bind, and many other services. Most people secure if they are configured properly. Have you looked at the security section of the manual? My program is using MySQL3.22. Are there advisories out on MySQL? I'd suggest moving up to 3.23.xx. If you find problems with 3.22, you'll likely need to upgrade anyway... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: indexing
On Fri, Feb 23, 2001 at 11:18:03AM +1300, Quentin Bennett wrote: Question: If you select and order by an indexed field, so that only the index file is used, does the server still do a sort, or does the data come out of the file pre-sorted? The index entries are sorted, so MySQL can simply read them in "index order" without having to re-sort them. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: XML support under mySQL
On Fri, Feb 23, 2001 at 08:26:08AM +0100, Gorjan Todorovski wrote: To Ed: Why be so negative about adding new features to the DB server? Why not make things easier and make the DB more flexible by supporting more standards for TRANSPORTING data. I'm not Ed, but... The answer is simple: it doesn't belong as a core service in the database server [in the opinions of several folks, including Ed]. As an add-on tool, sure. If someone writes a tool which turns MySQL data into some XML format on the fly, great. Or maybe the logic can be integrated into the client libraries. But I really don't think that the mysqld process show know how to do it. Then again, it wouldn't be HARD to do. I just hope then if it happens, it is a compile-time default so that I can disable it on my servers. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: XML support under mySQL
On Wed, Feb 21, 2001 at 11:18:49AM +0100, Gorjan Todorovski wrote: By support for XML I mean that u can insert XML documents directly in the database, of course u need to have the table properlu craeted first. Also it should be possible to retreive data in XML format from some table. This is supported in Oracle 8i for eaxmple You cannot do that with MySQL. But that's probably a philosophical difference. Many would argue that the database server has no business dealing with XML. That should be the job of the program which is putting the data into the database... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: So, just how long should it take the make install to run?
On Tue, Feb 20, 2001 at 04:41:25PM -0500, Matthew P. Marino wrote: Don't laugh, Intel PI 166MHZ, 32MB RAM,10GB HD FreeBSD4 MySQL3.23.33 from .tar.gz distribution The `make' or the `make install'? The `make install' shouldn't take more than a few minutes, but the initial `make' will take quite a while... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql and Labview?
On Mon, Feb 19, 2001 at 10:10:50AM +0100, Heinz Herren wrote: Hi, do you have any information or useful links to the subject "using LabView and MySQL"? Please do 60 seconds of research before you ask the list. This took me 10. http://www.google.com/search?q=labview+and+mysql Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: client -- server versions ?
On Mon, Feb 19, 2001 at 04:15:41AM -0500, Justin wrote: Hi - sorry one other question, Does the protocol between client (mysql command line, DBI::mysql and so on), and server, change from minor version to minor version, or from major version to major version ie, 3.22.x to 3.23.x ? My understanding is that they only make protocol changes between major version changes. I've found that older client machines can talk to an upgraded server without any apparent issue, but I'd like to know if this is: a) fine, b) ok but not really recommended c) a huge no-no, causing corruption and other weirdness. I suspect that it is (a) or maybe (b). The newer servers seem to have no trouble talking to older clients and I believe that is no accident. For example, on MYISAM, I have a data-set that hangs in 'Sending Data' phase using one particular select, using 3.22 mysql talking to 3.23 server, and am wondering if this is this cause. Have you tried it with a 3.23 client? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to 2 separate MySql databases
On Fri, Feb 16, 2001 at 11:45:10AM -0700, Bifano, Joe wrote: Hi, I know we can connect to 2 separate Mysql database's using Perl and the DBI module but can we connect to 2 different machines? One will be what we are using on our server and one our clients wants to be able to have on their servers. Yes. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Innobase + transactions row level locks will be released in a few days in MySQL 3.23.3x
On Fri, Feb 16, 2001 at 03:02:38PM +0200, Heikki Tuuri wrote: Monty will roll a new distribution of MySQL 3.23.3x this weekend. Innobase will be included there and it will provide transactions, rollback, recovery, row level locking, and Oracle-like consistent read. Monty will leave for a vacation in Rio on Wednesday, so the new distribution should be ready at the latest on that day. Currently, Intel NT and Intel Linux versions have been tested. We will compile and test Solaris 32-bit and Linux Alpha 64-bit versions this weekend. Very cool! I see the change log entries in the on-line manual already, but the source tarball isn't on SourceForge yet. :-( Anyone have one yet? I'm looking to test out the Innobase code on FreeBSD 4.1 this weekend. On a related note, how mature is the Innobase code? It is mostly new? Or like NuSphere's Gemini, it is older code which has been adapted to fit in with MySQL's table handler interface? Thanks! Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: DROP COLUMN
On Fri, Feb 16, 2001 at 11:20:58AM +0100, Wernher Korff wrote: hello list;) i have a SQL command to DROP a COLUMN from a mySQL database, the problem is that the syntax i am using doesnt seem to be the right syntax for mySQL, my statement currently read:"ALTER TABLE WorkGroups DROP COLUMN Personnel" and i get the error message: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'Personnel'. please help I think you've confused MySQL and Microsoft SQL Server. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help, Server error.
On Sun, Feb 18, 2001 at 04:35:29AM -0500, Mike Todd wrote: ? I am getting an error that I do not know how to resolve. I have looked though all the .docs, this is my last resort (it's 4:30AM). The system is running slackware with mysql 3.23.33. When I try and query, or just about do anything I get this error: 010218 4:02:54 Aborted connection 17 to db: 'mysql' user: 'root' host: `localhost' (Got an error writing communication packets) Is it causing problems, or simply filling your logs? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Performance of Heap table?!
On Fri, Feb 16, 2001 at 03:16:19PM +0800, chchen wrote: Hi all I find out that the performance of Heap table seems bad than MyIsam table. of course, MyIsam table usually on the H.D., so it will slow down because of I/O. but i do a test. I mount a memory disk on FreeBSD and update/inser a table. I find out that would faster than use Heap table with the same structure. and the speed almost double while the table grows up to 200K+ rows HEAP tables *can* be WAY faster then MyISAM tables for some tasks and quite slower for others. So this really isn't surprising. Many of the query optimizers' tricks don't apply to HEAP tables because the keys are based on hashing rather than B-tree structures. The manual describes some of benefits and drawbacks of HEAP tables. You may want to double-check what it says and compare it to what you're doing. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Index not used for order by when more than 1 field selected, no where clause
On Fri, Feb 16, 2001 at 10:56:57PM +0100, Benjamin Pflugmann wrote: When you set up your database server so that it has enough RAM to keep the whole database in main memory (buffer cache), random reads don't need to wait for physical disk seeks and can be very fast. [...] So my question is: Is it a way to tune this threshold ? AFAIK, currently the only way is to change it within the source and recompile MySQL. It shouldn't be hard to make that a tunable parameter via /etc/my.cnf. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help, Server error.
On Sun, Feb 18, 2001 at 05:09:17AM -0500, Mike Todd wrote: it is causing lots of problem. I cannot do anything really, queries create databases, drop databases - I get disconnected every time - and I have no idea why. It seems to be not docummented The only time I've seen that error message was when we had a bad Ethernet card in a machine. It would randomly drop network packets, close connections, etc. Can you rule out network problems? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQL Question
On Sun, Feb 18, 2001 at 08:24:47PM -0500, J Colleary wrote: Does MYSQL support the CREATE PROCEDURES command, or have stored procedures? If so, how do I access them? Nope. This is documented in the manual. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQl with SSH
On Fri, Feb 16, 2001 at 05:31:54AM -0800, Kuokai Shyu wrote: How can I configure MySQL to utilize the SSH package for encrypted TCP/IP connection between MySQL clients and server? Thanks in advance. What I do is setup port-forwarding. I forward a local port (say 12345) to port 3306 on the database server via an SSH connection: ssh -f -L 12345:server.foo.com:3306 sleep 9 (or something relatively similar) Then I just tell the client to connect to localhost on port 12345. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: taxes
On Wed, Feb 14, 2001 at 01:32:24PM -0700, LDL Enterprise wrote: does anyone know how to calculateg taxes for a shop cart that would set the tax depending on the state that they select when filling out their contact information? Thanks. Using MySQL? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Who is using BDB tables in critical environment?
I feel like the BDB tables have been around long enough to be reasonably stable and mature enough to have some confidence in them. But it always helps to hear people say things like: I've been using BDB tables in a high-volume environment with no problems since date. And the BDB page-level locking has improved the performance of my application, which was previous bound by MyISAM table locks. Is anyone ready to say such a thing? Or something close to it? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: DELETING CACHE
On Sat, Feb 10, 2001 at 03:24:42PM +0533, Jaya Thakar(ASI 2001) wrote: Can anybody tell me ,how to remove all the visited pages from the cache after logout that is after invalidating the session in java servlets and mysql, so that pressing the back button of the browser doesn't displays any page visited while a person was logged in. Someone on a mailing list that deals with Java servlets probably can. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql Stability
On Sat, Feb 10, 2001 at 11:32:25AM +, guru prasad wrote: I have a site with the database of size 90 MB on Mysql-3.22.25. It is performing quite well right now, Please let us know the maximum limit of the database size that Mysql can handle efficiently. It really depends on the hardware you are using. MySQL can easily handle multi-gigabyte databases on reasonably modern hardware with sufficient RAM. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Should I switch to SCSI HD for mysql?
On Wed, Feb 07, 2001 at 06:24:58PM -0800, mike thomas wrote: Hi all I am running mysql on linux (redhat 6.2) using a regular 18Gb EIDI hard drive. Does anyone know how much (ball park figure) a SCSI hard drive would speed up selects and inserts? That depends. Are your queryes CPU or disk bound now? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: blob and replication questions
On Mon, Feb 05, 2001 at 03:58:37PM +0100, Lukas Gruber wrote: chapter 11: "replication" doesnt mention any way of scheduling replication. it says after one configured and restarted the slave server it will connect to the master and then start replication. is there a way to schedule replication? can i start replication at specific times only? You can't schedule it, but you could schedule a process to issue "SLAVE STOP" and "SLAVE START" commands on your slave(s). in chapter 11: "replication" i cannot find any information about replicating blob data (ok: is doesnt say it is NOT possible). can this be done? does anybody have experience in replicatin blob-data (largeblobs)? BLOB fields replicate just fine in my experience. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Page Locking in 3.23
On Sun, Feb 04, 2001 at 01:03:47PM -, Phil Taylor wrote: Hi I can't find any documentation that explains how to activate page level locking on BDB tables - is page level locking the default when a CREATE TABLE is done? Yes. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sth-execute - screen/file output
On Mon, Feb 05, 2001 at 02:44:35PM +0800, [EMAIL PROTECTED] wrote: hi list, im trying to write a perl srcipt that will connect to a mysql database server, do some queries and print the output on the screen (or maybe append the output to a file), that would look something like this. +--+---+--+-+ | tnum | user | cust | area| +--+---+--+-+ | 22 | nivra | testing | isdn | | 23 | nivra | testing1 | ddu | | 24 | nivra | testing1 | ddu | +--+---+--+-+ below is my perl script. #!/usr/bin/perl use DBI; $dbname= "dbname"; $dbuser = "dbuser"; $dbpass = "dbpass"; $dbhost = "localhost"; $dbport = "3306"; $dsn = "DBI:mysql:database=$dbname;host=$dbhost;port=$dbport"; $condition = " where date = '2001/01/27' and petsa = '2001/01/31' and user = 'user'"; # Connect to the database $dbh = DBI-connect($dsn, $dbuser, $dbpass); # if needed and execute the SELECT $sth = $dbh-prepare("SELECT tnum, user, type, area, stat FROM tickets$where "); $output = $sth-execute; # clean up disconnect from the DB $sth-finish; $dbh-disconnect; print $output; but it doesn't give me any output at all. i'd like to know if there is any special parameter to use with sth-execute to do this. did i miss anything here? A couple of points: (1) You should really `use strict' in your Perl code. (2) The return value of $sth-execute is not what you expect. Check the DBI docs to learn what it really is. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: state: reading from net
On Fri, Feb 02, 2001 at 09:11:39AM +0100, Manfred Meier wrote: Who reads from the network? The client or the server? They both do, really. The server reads the request and the client reads the response. In this case, though, you are looking at the status of various connections from the server's point of view, right? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: wait_timeout?
On Tue, Jan 30, 2001 at 12:26:34PM -0600, Meyer, Patrick wrote: I am slowly gaining connections to the database that just sleep. I know these can arise from not closing the database. I am accessing it via MyODBC from Active Server Pages. However, I set wait_timeout to 3600... I have some that have been there for days... just sleeping. Why doesn't MySQL disconnect them from the timeout? Maybe I just don't understand wait_timeout. That's odd. I haven't had the need to use wait_timeout, so I can't say what you should expect. But I'd expect that it should work as documented. Do they appear to have anything particular in common? Same host/user/db? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Load Balancing.
On Tue, Jan 30, 2001 at 02:35:29PM -0700, Nathan Cook wrote: It seems like I have seen somewhere that load balancing and fail-over-services are available for MySQL, to share the load and mirror the data between two machines. Other than MySQL's built-in replication, which doesn't handle fail-over yet, I don't know of any which are MySQL-specific. There are various open source and commercial projects/products which do high-availability for various services on Linux, but I don't have any experience with them. I'd appreciate hearing back on the list about what you discover. I'm sure others would as well. Good luck, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: table history or tracabitity
On Wed, Jan 31, 2001 at 09:44:06AM +0100, Chappuis J.-Vincent wrote: Hi all ! I would like to know when the fields value has been changed and by wich user ? Does it exist a trace or an history of the tables in mysql database ? Maybe. If logging is enabled on the server, you can probably track down the change. If not (and you have no backups from earlier), you're mostly out of luck. You could check the timestamp on the .frm file for the table to see when it was last changed, but that won't tell you WHO changed it. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: number of tables in a db
On Tue, Jan 30, 2001 at 09:44:55AM -0600, johnny p. wrote: I have several tables in my db that can potentially become *very* large *very* quickly. I was thinking about creating a table for each user of my database to keep data separate and allow each table to be 4GB due to OS restrictions. How many tables can a database have in it? Lots. :-) How many files can you put in a directory on your OS and still have reasonable performance? Divide that number by 3 and you'll have the number you seek. or should i create a database for each user with an identical table? and... in that case... how many databases can MySQL successfully handle at any given time? Similar issue. Just don't divide by 3. Since MySQL stores databases as directories full of files, and each table is composed of 3 files, it boils down the the performance of your operating system and how its filesystem is implemented. Are you talking about a few hundred or a few million? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Please can this newsgroup be added to the demon newsgroups
On Thu, Feb 01, 2001 at 08:47:21AM -, Stephen Livesey wrote: I used to be subscribed to the ISP 'Globalnet'. I have now moved to the ISP 'Demon'. I can no longer obtain this newsgroup, I rang Demon and they informed me that the newsgroup had to be submitted to them! Please could someone who knows how, submit this newsgroup to Demon. Huh? This is a mailing list, not a newsgroup. Someone might be mirroring it to a newsgroup somewhere, but why don't you simply subscribe to the mailing list? Otherwise, your ISP is the best place to ask about getting them to add the group. They'd certainly know better than most of us (who don't use the same ISP that you do). Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql.server script
On Thu, Feb 01, 2001 at 02:12:03PM +1300, Quentin Bennett wrote: Hi, Each time I install mysql from a binary release that I have created, I have to modify safe_mysqld so that it can be called from mysql.server. This is because safe_mysqld checks to see if it knows what is going on before checking the command line args to see where things should be. Shouldn't this be fixed. so that mysql.server can call safe_mysqld 'out of the box'? I'm sure that if you produce a patch that makes the script a bit smarter, the MySQL maintainers would be glad to incorporate it (provided that it doesn't break anything, of course). Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: To thread or not to thread this is the question ..........
On Wed, Jan 31, 2001 at 09:14:23PM +0100, Marcello Giovagnoli wrote: Hi, I have a problem with mysql 3.23.30 (binary distribution) and Slackware 7. Runnining different programs that access to database, the numbers of mysqld grow up. But when a single program exit, the number of mysqld processes should decrease by one. This works on RedHat 7.0 with the same mySQL distribution, but on Slackware 7 the number of mysqld never goes down, and they keep the maximum memory used in the last big query. So I tried to compile the last source distribution 3.23.32 on Slackware 7, but I got the same thing. I know that the mysqld should be threads not processes, and the memory used should be shared with all running mysqld, but something does not work properly. Do you think that the version of libpthread-0.8.so on Slackware 7 could be the cause ? (RedHat 7.0 has the libpthread-0.9.so). I cannot upgrade the OS now, and I think that is not a nice idea moving on the fly libpthread-0.9.so from RedHat to Slackware (the system is up and there are 102 users connected !!!). Could someone help me ? I'd suggest using a statically linked binary from the MySQL web site. The fact that it's statically linked means that you don't have to worry about other libraries that may or may not be buggy on your system. It sounds like you've done that, but if that's the case you should see the same behavior on both systems. Are the MySQL configuration files the same on both machines? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php