ISAMCHK utility - MySQL server - 3.21.33b
Hello: Can anybody help me out to repair my database & tables using ISAMCHK utility. The MySQL server version is 3.21.33b installed on BSD server. Many thanks Sheni Details of the problem that we are facing now: We are facing a serious problem with the MySQL server installed on our web server (BSD/OS). The server was working fine till last week. Since then it started crashing. It crashes 2-3 times a day. Every time we have to kill the process and restart the server (UNIX). Not only the MySQL server the entire server crashes because of the load on the CPU. ###CPU STATE### load averages: 1.00, 1.00, 0.92 02:47:57 278 processes: 13 running, 265 sleeping CPU states: 0.0% user, 98.4% nice, 1.6% system, 0.0% interrupt, 0.0% idle Memory: Real: 40M/94M Virt: 217M/1481M Free: 342M PID PRI NICE SIZE RESSTATE TIME WCPU CPUCOMMAND 270 94 44420K 2024K run43:48 97.17% 97.17% mysqld ## The MySQL version is 3.21.33b . Since its an old version I couldn't find out any information regarding the issue from the MySQL web site. We have got 4-5 MySQL databases on this server. Could anybody help me out to solve this issue. Regards Sheni R Meledath [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Re: Insert dates with PHP
Hi ! You said anything about connecting to mysql. You need to go through 2 steps before mysql_query(). These are mysql_connect() mysql_select_db() please check the URL below, everything is explained very clearly. http://www.php.net/manual/en/function.mysql-query.php You could also tell us what mysql_error() said. --- =d0Mi= , DCS.net [EMAIL PROTECTED] >I am working with PHP for the first time and I need a form >To insert some details and a date. > >When I check the mysql database the date is displayed as -00-00 > >Here is my php script: > >$query = "Insert into >computers(id,itnumber,hdd,processor,ram,monitor,os,invoice,datebought) >values" . "(NULL,'$itnumber','$hdsize','$processor','$ram','$monitor','$os','$invoice' >,'$datebought')"; > >mysql_query($query) or die (mysql_error()); > >?> > >Everything else works fine. When I enter the date into mysql itself it works fine. > >Thanks > query,sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Systems of a high degree of availability
Hi, all -- Best regards, maxim mailto:[EMAIL PROTECTED] Hi, all Links to the information are necessary. Master/slave the architecture. Implementation of the system of a high degree of availability on a basis master/slave. Implementation of a control master/slave. Examples of the code of implementation of a monitoring system. Who realized this architecture on base WinNT/2000? How the problem of operation of two MySQL Max on one computer was solved? If for one MySQL Max a port 3306 what for the second to take? How to realize a control of availability master and availabilities slave? There will be a rad of any information and to links on the given subject It is beforehand grateful. Maxim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
invalid order when use 2 fields in ORDER BY
From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: invalid order when use 2 fields in ORDER BY Description: I try to show data by use "SELECT ... ORDER BY ...", but sometime! I get wrong order list when I try use 2 field in ORDER BY cause How-To-Repeat: I show 2 results, they use SAME QUERY and SAME DATA to execute. mysql> SELECT id, day, CONCAT(time_b, '-', time_e) AS time, IFNULL(room, room_cs) AS room, fg_color, bg_color, teacher, staff, comment FROM course_time WHERE code = 418112 AND section = 14 AND class = 'Lab' ORDER BY day ASC, time_b ASC ; ++---+-++--+--+-+---+-+ | id | day | time| room | fg_color | bg_color | teacher | staff | comment | ++---+-++--+--+-+---+-+ | 15 | Monday| 12:00-12:30 | SCL301 | 00 | 33 | | | | | 12 | Wednesday | 08:00-10:00 | SCL301 | 00 | 33 | | | | | 14 | Wednesday | 10:00-11:00 | SCL301 | 00 | 33 | | | | ++---+-++--+--+-+---+-+ 3 rows in set (0.00 sec) and sometime I got wrong order... ++---+-++--+--+-+---+-+ | id | day | time| room | fg_color | bg_color | teacher | staff | comment | ++---+-++--+--+-+---+-+ | 15 | Monday| 12:00-12:30 | SCL301 | 00 | 33 | | | | | 14 | Wednesday | 10:00-11:00 | SCL301 | 00 | 33 | | | | | 12 | Wednesday | 08:00-10:00 | SCL301 | 00 | 33 | | | | ++---+-++--+--+-+---+-+ 3 rows in set (0.00 sec) Fix: I think my query is correct and I don't know what going on about my query. Synopsis:Problem about ORDER BY Submitter-Id: Originator:Charin Nawaritloha Organization: Department of Computer Science, Kasetsart University, Bangkok Thailand. MySQL support: none Severity:non-critical Priority:medium Category:mysql client Class:sw-bug Release:mysql-3.23.38 Exectutable: mysqld Environment: SUN E250. System:Solaris 8. Compiler: I use binary to install Architecture: ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RENAME TABLE and locking
I'm using MySQL-3.23.49a I use MySQL to replace plain text log files. The logging happens in a table named "current". Every midnight, at 00:00:00, i perform a table rotation with this command from a cron job: CREATE TABLE new RENAME TABLE current TO $date, new TO current where $date is yesterday's date. The problem is, it's impossible to prevent today's messages from creeping into the old, rotated table. The reason is, there's always a very short delay before the rotation is performed, and some of today's messages always get into "current" before rotating it. I wonder if i can use locking to correct this problem. I mean: i create table "new", lock it, perform the rotation (so now "new" is "current", while the old "current" is "$date"), flush today's record from "$date" into "current", then unlock "current". Will it work this way? I'm not sure what happens to locking after RENAME; if i lock "new" and RENAME it to "current", will the lock be inherited by "current"? -- Florin Andrei You know you're in trouble when packet floods are competing to flood you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: UTF-8 national characters
I've been storing data in UTF8 Unicode (Vietnamese) format in mySQL database. I didn't see any problem of for doing any SELECT statement at all. Son Nguyen --- "John D. Stein" <[EMAIL PROTECTED]> wrote: > All, > > I can't seem to find anything about character code sets supported by > MySQL. The only thing I found was a note about adding support for > sorting > on Unicode at http://www.mysql.com/doc/T/O/TODO_MySQL_4.1.html. > > What character sets does MySQL support? Is Unicode the default for > national character fields? > > John > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Insert dates with PHP
I did forget to mention that I was using that format. So it must be something else?? Guy -Original Message- From: Uma Shankari T. [mailto:[EMAIL PROTECTED]] Sent: Thursday, 16 May 2002 4:09 p.m. To: Defryn, Guy Cc: [EMAIL PROTECTED] Subject: Re: Insert dates with PHP you have to enter ur date as in this format -MM-DD for example: 2002-04-04 Hope this will work Uma On Thu, 16 May 2002, Defryn, Guy wrote: DG> DG> DG>I am working with PHP for the first time and I need a form DG>To insert some details and a date. DG> DG>When I check the mysql database the date is displayed as -00-00 DG> DG>Here is my php script: DG> DG>$query = "Insert into computers(id,itnumber,hdd,processor,ram,monitor,os,invoice,datebought) values" . "(NULL,'$itnumber','$hdsize','$processor','$ram','$monitor','$os','$invoice' DG>,'$datebought')"; DG> DG>mysql_query($query) or die (mysql_error()); DG> DG>?> DG> DG>Everything else works fine. When I enter the date into mysql itself it works fine. DG> DG>Thanks DG> DG> DG>- DG>Before posting, please check: DG> http://www.mysql.com/manual.php (the manual) DG> http://lists.mysql.com/ (the list archive) DG> DG>To request this thread, e-mail <[EMAIL PROTECTED]> DG>To unsubscribe, e-mail <[EMAIL PROTECTED]> DG>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php DG> -- Love and you shall be loved by others - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Insert dates with PHP
you have to enter ur date as in this format -MM-DD for example: 2002-04-04 Hope this will work Uma On Thu, 16 May 2002, Defryn, Guy wrote: DG> DG> DG>I am working with PHP for the first time and I need a form DG>To insert some details and a date. DG> DG>When I check the mysql database the date is displayed as -00-00 DG> DG>Here is my php script: DG> DG>$query = "Insert into computers(id,itnumber,hdd,processor,ram,monitor,os,invoice,datebought) values" . "(NULL,'$itnumber','$hdsize','$processor','$ram','$monitor','$os','$invoice' DG>,'$datebought')"; DG> DG>mysql_query($query) or die (mysql_error()); DG> DG>?> DG> DG>Everything else works fine. When I enter the date into mysql itself it works fine. DG> DG>Thanks DG> DG> DG>- DG>Before posting, please check: DG> http://www.mysql.com/manual.php (the manual) DG> http://lists.mysql.com/ (the list archive) DG> DG>To request this thread, e-mail <[EMAIL PROTECTED]> DG>To unsubscribe, e-mail <[EMAIL PROTECTED]> DG>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php DG> -- Love and you shall be loved by others - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Insert dates with PHP
I am working with PHP for the first time and I need a form To insert some details and a date. When I check the mysql database the date is displayed as -00-00 Here is my php script: Everything else works fine. When I enter the date into mysql itself it works fine. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Age calculation
You probably need a computational module that calculates age with leap year calculation support. :-) Pae - Original Message - From: "Kittiphum Worachat" <[EMAIL PROTECTED]> To: "Nick Stuart" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 6:38 PM Subject: Re: Re: Age calculation > Hi, Nick Stuart,All > > >Please refer to http://mysql.com/doc/D/a/Date_calculations.html it covers > >datecalculations and has specifics on Age calcs. > > > >-Nick > > > >> Hello, mysql, > >> > >> How to get > > > >Age from field date-time that contain dateofbirth and then > >> display as xx year yy month zz > > > >days. > >> > > Yes I have ever seen it before but it not my answer. I really want to get result something like "your age are 30 years old 6 month and 15 days." is it possible with SQL. > > Best regards. > Kittiphum Worachat > [EMAIL PROTECTED] > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Databases with Tables approaching several million
Hi Erik, On Thu, 2002-05-16 at 07:50, Erik Fears wrote: > I'm looking for a solution to a database problem I'm having. The > current implementation is a file based database of roughly 57 > million entries. I'm wondering if anyone has had any experience running > a mysql based database with 50-100 million entries ? I was told that > mysql was optomized to be fast, and would not be able to handle databases > of large sizes and I'm just wondering if this is largely true or not. The latter is not correct. MySQL is indeed designed to be fast, but MySQL is also fully capable of handling large databases. One does not preclude the other. The issue is simply that for small databases, OS and server tuning, proper table and application design, are often regarded as less important since the system will be fast enough anyway. Naturally, as a database grows, these issues do become more important. Clearly, throwing more hardware (or different RDBMS software) at the problem is not the real solution. It merely evades the aforementioned issues of tuning and design. The MySQL manual (http://www.mysql.com/doc/) contains some good pointers on OS and server tuning, table design and query optimisation. There are also good books on the subject. Some design methods are relevant for all RDBMS, some are specific to MySQL and/or your particular application. In addition, MySQL AB provides services such as training (http://www.mysql.com/training/) where these things as well as other fundamentals are extensively covered, and of course consulting (http://www.mysql.com/consulting/). Generally speaking, nothing beats experience (backed up with training). In situations where you don't have enough time to gain the necessary experience yourself, consulting might be a better short-term option since it acquires the experience externally. Training is still recommended though, since it is always best if you are (in the future) able to help yourself. To return to your question, there are MySQL users that have many times more rows in their databases than the numbers you mention. Some of these you will find as Success Stories on the MySQL website (http://www.mysql.com/), and perhaps others will write their own reply here. In any case, running a database of this size with MySQL is not a problem. Regards, Arjen. -- MySQL Training in Australia: 9-13 Sep 2002, https://order.mysql.com/?marl __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to turn off query logging in mysql, redhat linux
it was started when machine was started check /etc/rc.d and in mysql manual 2.1.1 if u don't need it now, just stop the server and start it like "./bin/safe_mysqld &" but u have to modify rc.d anyway for next time your server start dont log anymore. Borus - Original Message - ±H¥óªÌ: "Tom Blumer" <[EMAIL PROTECTED]> ¦¬¥óªÌ: <[EMAIL PROTECTED]> ¶Ç°e¤é´Á: 2002¦~5¤ë16¤é AM 11:02 ¥D¦®: how to turn off query logging in mysql, redhat linux > > Hello > I am trying to turn off the query log in mysql on redhat linux. It generates > huge log files (in /var/lib/mysql/hostname.log) that I dont need, and > impacts performance. > > safe_mysqld was run with --log, and it seems like I want to turn that off > but I cant find any script or config file where the --log was specified, > perhaps it was compiled in? > I only have a binary distribution of mysql. Is there some way to override > the --log? > > I have looked at section 4.9 of the mysql manual and > /etc/my.cnf (see below) and these scripts > /etc/rc.d/rc[0-6].d/K12mysqld > /etc/rc.d/init.d/mysqld > /usr/share/mysql/mysql.server > > Does anyone know which of these scripts is really the one that starts > safe_mysql? > (note that the err-log setting in my.cnf refers to an error log (empty on my > machine) not > the query log that I am trying to get rid of. > > -thanks Tom > > > $ ps -ax |grep mysql > 6010 ?S 0:00 /bin/sh /usr/bin/safe_mysqld --log > 6036 ?S 0:45 /usr/libexec/mysqld --basedir=/usr > --datadir=/var/lib > > # uname -a > Linux {mydomain.com} 2.4.9-13 #1 Tue Oct 30 20:11:04 EST 2001 i686 unknown > > # mysqladmin --version > mysqladmin Ver 8.21 Distrib 3.23.41, for redhat-linux-gnu on i386 > > # cat my.cnf > [mysqld] > datadir=/var/lib/mysql > socket=/var/lib/mysql/mysql.sock > > [mysql.server] > user=mysql > basedir=/var/lib > > [safe_mysqld] > err-log=/var/log/mysqld.log > pid-file=/var/run/mysqld/mysqld.pid > > > > _ > Chat with friends online, try MSN Messenger: http://messenger.msn.com > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to turn off query logging in mysql, redhat linux
Hello I am trying to turn off the query log in mysql on redhat linux. It generates huge log files (in /var/lib/mysql/hostname.log) that I dont need, and impacts performance. safe_mysqld was run with --log, and it seems like I want to turn that off but I cant find any script or config file where the --log was specified, perhaps it was compiled in? I only have a binary distribution of mysql. Is there some way to override the --log? I have looked at section 4.9 of the mysql manual and /etc/my.cnf (see below) and these scripts /etc/rc.d/rc[0-6].d/K12mysqld /etc/rc.d/init.d/mysqld /usr/share/mysql/mysql.server Does anyone know which of these scripts is really the one that starts safe_mysql? (note that the err-log setting in my.cnf refers to an error log (empty on my machine) not the query log that I am trying to get rid of. -thanks Tom $ ps -ax |grep mysql 6010 ?S 0:00 /bin/sh /usr/bin/safe_mysqld --log 6036 ?S 0:45 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib # uname -a Linux {mydomain.com} 2.4.9-13 #1 Tue Oct 30 20:11:04 EST 2001 i686 unknown # mysqladmin --version mysqladmin Ver 8.21 Distrib 3.23.41, for redhat-linux-gnu on i386 # cat my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: INSERT INTO not working
1. delete any whitespaces between the column name and the "=" and the values. 2. try using columnname="value" That works for me. On Thursday, May 16, 2002, at 09:59 AM, Daniel Lim wrote: > > Hi there, > I have MySql version: 3.23.36 running on RedHat 7.1, it has been > working fine for sometimes until a day ago when the INSERT into for new > record appeared to return OK status but upon verifying the record isn't > there? > > This is an example; > > To insert new record: > > mysql> INSERT into userdata SET loginname = > 'test3',lastname='test3',firstname='Testing 3',middlename='Three'; > Query OK, 1 row affected (0.00 sec) > > verify inserted record: > > mysql> select loginname,firstname,middlename from userdata where > loginname = "test3" ; > Empty set (0.04 sec) > > mysql> > > Any suggestion is much appreciated. > Thanks in advance > > Regards, > Daniel Lim > UNIX Systems Administartor > NSW Dept. of Public Works > Sydney, Australia > This e-mail message (and attachments) is confidential, and / or > privileged and is intended for the use of the addressee only. If you are > not the intended recipient of this e-mail you must not copy, distribute, > take any action in reliance on it or disclose it to anyone. Any > confidentiality or privilege is not waived or lost by reason of mistaken > delivery to you. DPWS is not responsible for any information not related > to the business of DPWS. If you have received this e-mail in error > please destroy the original and notify the sender > > For information on services offered by DPWS, please visit our website > at www.dpws.nsw.gov.au > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Temp Table size?
Michael Grover wrote: > > This simple query: > > create temporary table mike select * from wy > union all > select * from ks; > > will cause the following error: > > "[root@localhost:3306] ERROR 1114: The table '#sqla08_3_1' is full" > > what's wierd is I only have a "#sqla08_3_0" table in my c:\winnt\temp > dir... > > The second table is being created in memory, If you increase > "max_heap_table_size" enough to cover the total result size, there is no > error. > > What Im worried about is that if you have alot of user's, Alot of memory > will get used fast for unions? > >mike > > Colin Faber wrote: > > > > Um.. by default the temp table should "spill" into a scratch disk like > > swap system.. normally this is handled in /tmp possibly you're > > allocating all available real memory all swap and filling /tmp. > > > > Look into that. > > > > Mike Grover wrote: > > > > > > It's memory, A query with a union apparently uses memory to do a union > > > Before it pushes the results into a temp table? > > > > > > Any way around this? > > > > > > mike > > > > > > -Original Message- > > > From: Colin Faber [mailto:[EMAIL PROTECTED]] > > > Sent: Wednesday, May 15, 2002 2:58 PM > > > To: Mike Grover > > > Cc: [EMAIL PROTECTED] > > > Subject: Re: Temp Table size? > > > > > > Hi Mike, > > > > > > Possibly out of available memory. (Or disk space assuming that's what > > > it's hitting) > > > > > > Mike Grover wrote: > > > > > > > > When I create a temp table, If I put to much in it, > > > > I get a "Temp Table [Table name] is Full" error. > > > > > > > > I changed my tmp_table_size to a ver large number. > > > > > > > > Still same error, Any Ideas? > > > > > > > > This is windows 2000 > > > > MySQL 4.01 > > > > Config Loaded Form my.ini in winnt dir. > > > > > > > > Show Variables for server shows new tmp_table_size set > > > > In ini file. > > > > > > > > mike > > > > > > > > - > > > > Before posting, please check: > > > >http://www.mysql.com/manual.php (the manual) > > > >http://lists.mysql.com/ (the list archive) > > > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > > To unsubscribe, e-mail > > > > <[EMAIL PROTECTED]> > > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > -- > > > Colin Faber > > > (303) 736-5160 > > > fpsn.net, Inc. > > > > > > - > > > Before posting, please check: > > >http://www.mysql.com/manual.php (the manual) > > >http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > -- > > Colin Faber > > (303) 736-5160 > > fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Age calculation
Hi, Nick Stuart,All >Please refer to http://mysql.com/doc/D/a/Date_calculations.html it covers >datecalculations and has specifics on Age calcs. > >-Nick > >> Hello, mysql, >> >> How to get > >Age from field date-time that contain dateofbirth and then >> display as xx year yy month zz > >days. >> Yes I have ever seen it before but it not my answer. I really want to get result something like "your age are 30 years old 6 month and 15 days." is it possible with SQL. Best regards. Kittiphum Worachat [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to turn off query logging for mysql on redhat linux
Hello I am trying to turn off the query log in mysql on redhat linux. It generates huge log files (in /var/lib/mysql/hostname.log) that I dont need, and impacts performance. safe_mysqld was run with --log, and it seems like I want to turn that off but I cant find any script or config file where the --log was specified, perhaps it was compiled in? I only have a binary distribution of mysql. Is there some way to override the --log? I have looked at section 4.9 of the mysql doc, and /etc/my.cnf (see below) and these scripts /etc/rc.d/rc[0-6].d/K12mysqld /etc/rc.d/init.d/mysqld /usr/share/mysql/mysql.server Does anyone know which of these scripts is really the one that starts safe_mysql? (note that the err-log setting in my.cnf refers to an error log (empty on my machine) not the query log that I am trying to get rid of. Please reply directly and to the list -thanks Tom $ ps -ax |grep mysql 6010 ?S 0:00 /bin/sh /usr/bin/safe_mysqld --log 6036 ?S 0:45 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib # uname -a Linux {mydomain.com} 2.4.9-13 #1 Tue Oct 30 20:11:04 EST 2001 i686 unknown # mysqladmin --version mysqladmin Ver 8.21 Distrib 3.23.41, for redhat-linux-gnu on i386 # cat my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: UTF-8 national characters
Sven Bentlage asked > Is there a way to get UTF-8 national characters sets working when you > only have user access to a database (it's my ISP's)? Whether you use the my.cnf/my.ini configuration file or the startup parameter, it's a startup option. You have to have access to one or the other. Maybe, if they are willing to provide mysql, they will also be willing to let you do some configuration. Only way to know is to ask your ISP. If they don't know, you might want to put a my.cnf in your home directory, just to see what happens. You'll need to check the manual. > (I know this is going to upset some people, but I do not have any time > left and RTFM won't help me right now..) Then check it later. > Can anyone of you send me a list/link to a list (or even better a > download location) of all available UTF-8 national character sets and a > small description on how to get them working as fast as possible? UTF-8 is not supported until 4.1 comes out. But if you don't need to sort or collate on those fields, just store it as blob and make your application remember that it's supposed to be UTF-8, and with a little work you should be okay. I think. > Thanks for your understanding and help, > > Sven > > On Thursday, May 16, 2002, at 08:40 AM, Roger Baklund wrote: > > > > > * John D. Stein > >> I can't seem to find anything about character code sets supported by > >> MySQL. The only thing I found was a note about adding support > >> for sorting > >> on Unicode at http://www.mysql.com/doc/T/O/TODO_MySQL_4.1.html. > >> > >> What character sets does MySQL support? Is Unicode the default for > >> national character fields? > > > > There is plenty about character sets in the manual: > > > > http://www.mysql.com/doc/manual.php?search_query=character+set > > > > > http://www.mysql.com/doc/C/h/Character_sets.html > > > http://www.mysql.com/doc/A/d/Adding_character_set.html > > > http://www.mysql.com/doc/P/r/Problems_with_character_sets.html > > > http://www.mysql.com/doc/M/u/Multi-byte_characters.html > > > > > -- > > Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Database size
I am new to MySQL to begin with. I am running syslog messages to a DB. It sends anywhere from 3500 to 5600 per minute. I then use PHP to look at the data. The DB machine is a Dual 1Ghz processor with 1Gb Ram. The problem is the speed of lookups. The DB has about 7 million rows and is continually growing. Should I break this up by the day to speed up searches? It takes about 2 minutes to do a search on the data. Just looking for pointers. Thanks Bennie -- ** Bennie Warren LemooreNet 320 West D Street Lemoore, CA 93245 Phone: 559.924.5909 Fax 559.924.9578 [EMAIL PROTECTED] http://www.lemoorenet.com ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
INSERT INTO not working
Hi there, I have MySql version: 3.23.36 running on RedHat 7.1, it has been working fine for sometimes until a day ago when the INSERT into for new record appeared to return OK status but upon verifying the record isn't there? This is an example; To insert new record: mysql> INSERT into userdata SET loginname = 'test3',lastname='test3',firstname='Testing 3',middlename='Three'; Query OK, 1 row affected (0.00 sec) verify inserted record: mysql> select loginname,firstname,middlename from userdata where loginname = "test3" ; Empty set (0.04 sec) mysql> Any suggestion is much appreciated. Thanks in advance Regards, Daniel Lim UNIX Systems Administartor NSW Dept. of Public Works Sydney, Australia This e-mail message (and attachments) is confidential, and / or privileged and is intended for the use of the addressee only. If you are not the intended recipient of this e-mail you must not copy, distribute, take any action in reliance on it or disclose it to anyone. Any confidentiality or privilege is not waived or lost by reason of mistaken delivery to you. DPWS is not responsible for any information not related to the business of DPWS. If you have received this e-mail in error please destroy the original and notify the sender For information on services offered by DPWS, please visit our website at www.dpws.nsw.gov.au - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Alter table
- Original Message - From: "Benjamin Pflugmann" <[EMAIL PROTECTED]> To: "Mark" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 1:24 AM Subject: Re: Alter table > Hi. > > Please start a new thread next time, instead of replying to a > completely unrelated topic. Thank you. > > It sounds as if you want > > ALTER TABLE your_table ADD INDEX( message_id ) > > It is probably enough to only index some part of that field and > save a lot of space: > > ALTER TABLE your_table ADD INDEX( message_id(15) ) Thank you!! The new index caused the search on message_id to be about hundred times as fast! :) Yay! :) - Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: UTF-8 national characters
Is there a way to get UTF-8 national characters sets working when you only have user access to a database (it's my ISP's)? (I know this is going to upset some people, but I do not have any time left and RTFM won't help me right now..) Can anyone of you send me a list/link to a list (or even better a download location) of all available UTF-8 national character sets and a small description on how to get them working as fast as possible? Thanks for your understanding and help, Sven On Thursday, May 16, 2002, at 08:40 AM, Roger Baklund wrote: > * John D. Stein >> I can't seem to find anything about character code sets supported by >> MySQL. The only thing I found was a note about adding support >> for sorting >> on Unicode at http://www.mysql.com/doc/T/O/TODO_MySQL_4.1.html. >> >> What character sets does MySQL support? Is Unicode the default for >> national character fields? > > There is plenty about character sets in the manual: > > http://www.mysql.com/doc/manual.php?search_query=character+set > > > http://www.mysql.com/doc/C/h/Character_sets.html > > http://www.mysql.com/doc/A/d/Adding_character_set.html > > http://www.mysql.com/doc/P/r/Problems_with_character_sets.html > > http://www.mysql.com/doc/M/u/Multi-byte_characters.html > > > -- > Roger > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: insert into multiple tables??
Guy No. Requires multiple inserts. David > -Original Message- > From: Defryn, Guy [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 15, 2002 4:55 PM > To: [EMAIL PROTECTED] > Subject: insert into multiple tables?? > > > > > Is it possible to insert data into different tables with one insert > statement. > > > For example , I have one form on my web page and the data needs to go > into different tables( first 5 entries to table A and the > rest to table > B)? > > Mysql > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
insert into multiple tables??
Is it possible to insert data into different tables with one insert statement. For example , I have one form on my web page and the data needs to go into different tables( first 5 entries to table A and the rest to table B)? Mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Column Header/ Column Description
- Original Message - From: "Orr, Steve" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 6:09 PM Subject: RE: Column Header/ Column Description > Metadata in the database is NOT a bad idea! It's a basic part of the > relational model, Codd's 4th rule. (E. F. Codd is the originator of the > relational model.) While no one has implemented all 12 of Codd's rules, this > is pretty basic/easy. > > Here's the 4th rule: "The database description is represented at the logical > level in the same way as ordinary data, so authorized users can apply the > same relational language to its interrogation as they apply to regular > data." > > I'm not a relational purist but metadata documentation about the database > should be maintained in the database and there's no reason for it to be > viewed as unnecessary overhead that would somehow slow down non-metadata > queries. In my opinion, I believe what Codd is describing here is the ability to get to the DDL via the relational model, which MySQL does support. His notion of metadata is table names, column names, column types, nullability, etc., not comments about the structure of the table. I don't consider documentation metadata, necessarily. -Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: UTF-8 national characters
* John D. Stein > I can't seem to find anything about character code sets supported by > MySQL. The only thing I found was a note about adding support > for sorting > on Unicode at http://www.mysql.com/doc/T/O/TODO_MySQL_4.1.html. > > What character sets does MySQL support? Is Unicode the default for > national character fields? There is plenty about character sets in the manual: http://www.mysql.com/doc/manual.php?search_query=character+set > http://www.mysql.com/doc/C/h/Character_sets.html > http://www.mysql.com/doc/A/d/Adding_character_set.html > http://www.mysql.com/doc/P/r/Problems_with_character_sets.html > http://www.mysql.com/doc/M/u/Multi-byte_characters.html > -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Alter table
- Original Message - From: "Benjamin Pflugmann" <[EMAIL PROTECTED]> To: "Mark" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 1:24 AM Subject: Re: Alter table > Hi. > > Please start a new thread next time, instead of replying to a > completely unrelated topic. Thank you. > > It sounds as if you want > > ALTER TABLE your_table ADD INDEX( message_id ) > > It is probably enough to only index some part of that field and > save a lot of space: > > ALTER TABLE your_table ADD INDEX( message_id(15) ) > > For more information about this, have a look in the manual about > ALTER TABLE and CREATE TABLE. Well, the FAQ is where I went first, of course. And then I came up with this, "ALTER ignore table $table MODIFY message_id varchar(255) \ not null secondary key" But MySQL said I had an error in my syntax. :( If I use the ADD INDEX() syntax, will that cause the message_id field to be indexed, also for new message-ids? Thanks. P.S. Yes, I know, I should have considered this when creating the table, that I might also want an index on message-id; but I can no longer drop the current table. - Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Load data command?
Hi Joshua, what exactly did you try? LOAD DATA INFILE seems to be working on my box ;-) Joshua Richards wrote: > > Hi, > Could anyone please tell me how I could load a text file into a specific > column in mysql. > I tried LOAD DATA INFILE but didn't work > > Thanks, > > J.Richards > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Alter table
* Mark > Can some please help me? > > I created a MySQL table with newsgroup articles in them, and > indexed them on > article_num, > > article_num int unsigned not null primary key > > But now, as I found out that searching on message_id, using a WHERE clause > tends to get very slow. So, I was wondering whether I can change the table > to have message_id be the secondary key. Now it is, > > message_id varchar(255) > > But I would like it to become, > > message_id varchar(255) not null secondary key > > Can I alter the table to this effect, or am I too late? :( No, it is not too late. :) There is no "secondary key", but an index will do what you want. http://www.mysql.com/doc/C/R/CREATE_INDEX.html > -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Alter table
Hi. Please start a new thread next time, instead of replying to a completely unrelated topic. Thank you. It sounds as if you want ALTER TABLE your_table ADD INDEX( message_id ) It is probably enough to only index some part of that field and save a lot of space: ALTER TABLE your_table ADD INDEX( message_id(15) ) For more information about this, have a look in the manual about ALTER TABLE and CREATE TABLE. Regards, Benjamin. On Thu, May 16, 2002 at 12:47:26AM +0200, [EMAIL PROTECTED] wrote: > Can some please help me? > > I created a MySQL table with newsgroup articles in them, and indexed them on > article_num, [...] > message_id varchar(255) not null secondary key > > Can I alter the table to this effect, or am I too late? :( > [...] -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
UTF-8 national characters
All, I can't seem to find anything about character code sets supported by MySQL. The only thing I found was a note about adding support for sorting on Unicode at http://www.mysql.com/doc/T/O/TODO_MySQL_4.1.html. What character sets does MySQL support? Is Unicode the default for national character fields? John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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.44 not using indexes
Michael Widenius wrote: >You can check if the index are ok with CHECK TABLE; If this says the >index is ok, they are not corrupted. > Apparently this doesn't work in all cases. "CHECK TABLE" told me everything was fine, but dumping the data to a dump file via mysqldump and then re-importing it into a new database fixed the problem, so there must have been some undetected corruption in the database. >The above shows that MySQL could use the index but decides to not use >this because it concludes that a table scan will be faster. > >To verify this can you send us the result for the following queries: > >SELECT count(*) FROM bugs WHERE bug_status IN ('NEW', 'ASSIGNED', 'REOPENED'); >SELECT count(*) FROM bugs; > The results were about 25,000 and 131,000, respectively. -myk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Column Header/ Column Description
Metadata in the database is NOT a bad idea! It's a basic part of the relational model, Codd's 4th rule. (E. F. Codd is the originator of the relational model.) While no one has implemented all 12 of Codd's rules, this is pretty basic/easy. Here's the 4th rule: "The database description is represented at the logical level in the same way as ordinary data, so authorized users can apply the same relational language to its interrogation as they apply to regular data." I'm not a relational purist but metadata documentation about the database should be maintained in the database and there's no reason for it to be viewed as unnecessary overhead that would somehow slow down non-metadata queries. IMHO, Steve Orr Bozeman, Montana -Original Message- From: Mark Matthews [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 4:28 PM To: Keith C. Ivey; [EMAIL PROTECTED] Subject: Re: Column Header/ Column Description - Original Message - From: "Keith C. Ivey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 4:54 PM Subject: Re: Column Header/ Column Description > On 15 May 2002, at 16:06, Mark Matthews wrote: > > > I'm interested in hearing what databases you have used that have this > > functionality? SQL server and Oracle do not, for example. > > MS Access does. Also, it seems a bit inconsistent that MySQL has > metadata (the comment) associated with each table, but has nothing > similar for databases or columns. It's certainly not essential, but > I've wondered about it before. I'm of the opinion that storing the sort of metadata you're talking about in the database is a bad idea. I don't even think that the table comment functionality that MySQL does have is absolutely necessary. Storing this sort of metadata in the database seems to be counterproductive to me, especially because it's only available if you know SQL and are working with the database. But that's another discussion. I would hope that developers create table and column names that are descriptive enough to get a general understanding of what's going on, and that anything that wasn't self-describing is documented in a set of "release notes" or a data dictionary. I'm also of the opinion that a picture is a much better tool for this sort of thing. Unfortunately, there aren't many open-source ERD editors out there. -Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Column Header/ Column Description
Haven't found any open source ERD editors out there. BUT, realized that Visio has ERD diagramming capability, out of the box. Visio seems pretty prevalent around enterprises. If you look, you might find it and can describe your data model using one of several de acto standard methofologies. - Original Message - From: "Mark Matthews" <[EMAIL PROTECTED]> To: "Keith C. Ivey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 6:27 PM Subject: Re: Column Header/ Column Description > > - Original Message - > From: "Keith C. Ivey" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, May 15, 2002 4:54 PM > Subject: Re: Column Header/ Column Description > > > > On 15 May 2002, at 16:06, Mark Matthews wrote: > > > > > I'm interested in hearing what databases you have used that have this > > > functionality? SQL server and Oracle do not, for example. > > > > MS Access does. Also, it seems a bit inconsistent that MySQL has > > metadata (the comment) associated with each table, but has nothing > > similar for databases or columns. It's certainly not essential, but > > I've wondered about it before. > > I'm of the opinion that storing the sort of metadata you're talking about in > the database is a bad idea. I don't even think that the table comment > functionality that MySQL does have is absolutely necessary. Storing this > sort of metadata in the database seems to be counterproductive to me, > especially because it's only available if you know SQL and are working with > the database. But that's another discussion. > > I would hope that developers create table and column names that are > descriptive enough to get a general understanding of what's going on, and > that anything that wasn't self-describing is documented in a set of "release > notes" or a data dictionary. > > I'm also of the opinion that a picture is a much better tool for this sort > of thing. Unfortunately, there aren't many open-source ERD editors out > there. > > -Mark > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Alter table
Can some please help me? I created a MySQL table with newsgroup articles in them, and indexed them on article_num, article_num int unsigned not null primary key But now, as I found out that searching on message_id, using a WHERE clause tends to get very slow. So, I was wondering whether I can change the table to have message_id be the secondary key. Now it is, message_id varchar(255) But I would like it to become, message_id varchar(255) not null secondary key Can I alter the table to this effect, or am I too late? :( Thanks, - Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Simple SQL
* Peter Sampson > Maybe it doesn't work because I'm using a SQL wizard in Ultradev, I'll try > your code in the HTML/ASP part of the webpage > > The table structure is > Month > Headline > Image > Caption > Content Peter, you say you're not a programmer, and I'll try to explain a little about the more technical sides to this database thingy, while keeping it understandable to normal people... sorry in advance if I don't succeed. :) The fields of a table has a type, in addition to the field name. The field types are actually a lot more important than the names... :) I don't know the tool you are using, so I can't advise on how you can find this information, but from how you describe your problem I am guessing all your fields are of type VARCHAR or TEXT. These are field types intended for storing text, and a natural choice in many cases. There is however no magic involved, mysql does not know that the words you store in the column actually are names for months, and consequently not what would be the correct calendar order of the months... :) Luckily there are more field types, specialized for numbers and dates. You could use a numeric field type, and store your months as the numbers 1,2,3...12, and your application could translate the number to a month name. "ORDER BY Month" would give the correct calendar order. You got an advise on the list to create a MonthNames table. I never do that, because it is so simple to do it programatically. However, if you can not translate the numbers to month names in your application, it may be the only way, and anyways the technique used is basic relational database theory, so if you are going to work with databases, you probably need to learn it. ;) btw, did you test the suggestion in my previous post? -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Column Header/ Column Description
- Original Message - From: "Keith C. Ivey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 4:54 PM Subject: Re: Column Header/ Column Description > On 15 May 2002, at 16:06, Mark Matthews wrote: > > > I'm interested in hearing what databases you have used that have this > > functionality? SQL server and Oracle do not, for example. > > MS Access does. Also, it seems a bit inconsistent that MySQL has > metadata (the comment) associated with each table, but has nothing > similar for databases or columns. It's certainly not essential, but > I've wondered about it before. I'm of the opinion that storing the sort of metadata you're talking about in the database is a bad idea. I don't even think that the table comment functionality that MySQL does have is absolutely necessary. Storing this sort of metadata in the database seems to be counterproductive to me, especially because it's only available if you know SQL and are working with the database. But that's another discussion. I would hope that developers create table and column names that are descriptive enough to get a general understanding of what's going on, and that anything that wasn't self-describing is documented in a set of "release notes" or a data dictionary. I'm also of the opinion that a picture is a much better tool for this sort of thing. Unfortunately, there aren't many open-source ERD editors out there. -Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Load data command?
Hi, Could anyone please tell me how I could load a text file into a specific column in mysql. I tried LOAD DATA INFILE but didn't work Thanks, J.Richards - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error writing file
Thanks very much. Bradley Gurhan Ozen wrote: > Hi Bradley, > Use perror program to see what the error code means.. > > # perror 28 > Error code 28: No space left on device > > Seems like you ran out of space.. > > Gurhan > > -Original Message- > From: Bradley Brown [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 15, 2002 5:01 PM > To: [EMAIL PROTECTED] > Subject: Error writing file > > Hey all, > I'm attempting to create a new table within a database. I have tried > from the mysql > client and also from dbtools. Here is the error message I am receiving: > > ERROR 3: Error writing file './path_to/file.frm' (Errorcode: 28) > > I am trying to add the table as root. I have checked the file permissions > within the > dbase directory and the permissions for all files is "mysql:mysql". > > Any suggestions or tips (maybe I'm just being stupid here) would be greatly > appreciated. Thanks very much. > Bradley Brown > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Max vs. InnoDB?
Vaclav, MySQL-Max and MySQL/InnoDB as referred to at www.innodb.com are the same product. Innobase Oy does not distribute or sell directly MySQL-Max. All distribution and sales are done through MySQL AB. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Original Message - From: <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, May 15, 2002 7:44 PM Subject: Max vs. InnoDB? > Hello list, > > what's the difference and relation between MySQL-Max and the stuff at > www.innodb.com? Both technically and license-wise... Thanks. > > Vaclav Dvorak [EMAIL PROTECTED] > IDAS, s.r.o.http://www.idas.cz > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Simple SQL
- Original Message - From: "Peter Sampson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 9:06 PM Subject: Simple SQL > SQL beginner using Macromedia Ultradev. Can you help? > > Please be gentle I'm not a programmer! > > I am using > > Select DISTINCT Month > FROM tblNews > > The problem is that the months are shown alphabetical not in > calendar order. > > How can I change this? Perhaps a bit clunky, but if you store dates as "datetime", or "date" type (recommended anyway), you can simply sort numericly on them by converting them to unix_timestamp in your query, "SELECT MONTH(mydate) FROM mydates ORDER BY unix_timestamp(mydate) ASC"; The unix_timestamp is not really necessary here, as you could simply suffice to say, ORDER BY MONTH(mydate) But that was just in illustration how to easily sort on dates. :) There may be cleverer way to sort on dates, but I find the unix_timestamp to be very useful for this purpose. - Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Column Header/ Column Description
On 15 May 2002, at 16:06, Mark Matthews wrote: > I'm interested in hearing what databases you have used that have this > functionality? SQL server and Oracle do not, for example. MS Access does. Also, it seems a bit inconsistent that MySQL has metadata (the comment) associated with each table, but has nothing similar for databases or columns. It's certainly not essential, but I've wondered about it before. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Assertion failure with mysql-3.23.49a/InnoDB
Michael, the assertion below looks like table corruption. Please check with CHECK TABLE your tables. If some is corrupt, dump, drop, and reimport it. The symbols file was forgotten from .49a and we cannot resolve the stack trace. You might want to try .50 in which the symbols file exists. I also added some diagnostic code to 3.23.52 which may help in future to track the problem. Regards, Heikki Copied message: . I've gotten this same assertion failure twice. I'm very confident in this machine's stability since it has survived 36 hours worth of CTCS, so I'm not going to look for a hardware problem just yet. At first I thought it may have been the glibc issue with threads overwriting each other's stacks but this time possible memory use is well under 2GB. I tried to resolve the symbols but the mysql binary doesn't appear to come with debugging symbols (or at least any that ``nm'' was able to find). Using the mysql-max-3.23.49a-pc-linux-gnu-i686 tarball binary Hopefully someone has seen this before?? /usr/local/mysql/bin/mysqld: ready for connections InnoDB: Assertion failure in thread 61456 in file ../include/page0page.ic line 515 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. InnoDB: Thread 446574 stopped in file os0sync.c line 395 We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key buffer size=67104768 InnoDB: Thread 266306 stopped in file sync0arr.c line 336 InnoDB: Thread 8195 stopped in file os0sync.c line 115 InnoDB: Thread 12292 stopped in file os0file.c line 1175 record buffer=131072 sort buffer=4194296 max used connections=121 max connections=300 threads connected=60 It is possible that mysqld could use up to key buffer size + (record buffer + sort buffer)*max connections = 1332729 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x806dc04 0x82ad1a8 0x81d19c7 0x81d3077 0x81ba8e0 0x8193681 0x80bf5aa 0x80c0ded 0x8093962 0x809372b 0x808b704 0x8074a4a 0x8078b48 0x8073c24 0x8072fd7 Some mysqlbug output: System: Linux fileserv 2.4.7-10smp #1 SMP Thu Sep 6 17:09:31 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 - fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-i nt -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wextern-inline -Wsign-p romo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-e xceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Feb 22 10:38 /lib/libc.so.6 -> libc-2.2.4.so -rwxr-xr-x1 root root 1282588 Sep 4 2001 /lib/libc-2.2.4.so -rw-r--r--1 root root 27304836 Sep 4 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 4 2001 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler --with-extra-charse ts=complex --enable-thread-safe-client --with-innodb --with-berkeley-db --enable-thread -safe-client --with-other-libc=/usr/local/mysql-glibc '--with-comment=Official MySQL Binary' --prefix=/usr/local/mysql --with-extra-charset=complex --enable-thread-safe- client --enable-local-infile --with-server-suffix=-max 'CFLAGS=-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat - Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=p entiumpro -O3 -fno-omit-frame-pointer' 'CXXFLAGS=-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wextern-i nline -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constr uctors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer'
Databases with Tables approaching several million
Hello, I'm looking for a solution to a database problem I'm having. The current implementation is a file based database of roughly 57 million entries. I'm wondering if anyone has had any experience running a mysql based database with 50-100 million entries ? I was told that mysql was optomized to be fast, and would not be able to handle databases of large sizes and I'm just wondering if this is largely true or not. Thanks, Erik Fears - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Column Header/ Column Description
Most of my database work has been on DB2/400. (This the native database for IBM's AS/400 series.) The reason this is important to me is because I'm transferring data from DB2/400 to MySQL. The MySQL database is optimized for reporting purposes. Most users will access the data via ODBC and, as much as possible, I want the database to be self documenting so that users can be confident they are using the correct data. I guess this is one of those situations where I'll just have to punt. Finally, Paul, your book has been a great help in getting me up to speed on MySQL and Mark I've used your JDBC driver for a couple of years now, it's wonderful. Thanks to both of you for all of your hard work. -Original Message- From: Mark Matthews [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 2:07 PM To: mike markovich; Paul DuBois; [EMAIL PROTECTED] Subject: Re: Column Header/ Column Description >- Original Message - > From: "mike markovich" <[EMAIL PROTECTED]> > To: "Paul DuBois" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Wednesday, May 15, 2002 3:54 PM > Subject: RE: Column Header/ Column Description > > Paul, > > Thanks for responding. The ability to document columns, tables, databases, etc. seems pretty important to me. Why is this > not an issue to others? Am I approaching this issue the wrong way? Your thoughts would be appreciated. This is usually documented in your data model, not the database itself. Whether or not that's an Erwin or Visio diagram, or a mysqldump that's annotated. I'm interested in hearing what databases you have used that have this functionality? SQL server and Oracle do not, for example. -Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fw: Simple SQL
This was addressed privately, but that's not a big deal. :) (I forgot to hit reply-all. :P) Peter Sampson wrote: > So i change the properties of Month to Integer in tblNews? Say you have two tables: mysql> show tables; ++ | Tables_in_test | ++ | MonthNames | | tblNews| ++ 2 rows in set (0.00 sec) MonthNames contains two fields: nMonth and mName. tblNews (for this example, anyway) contains three fields: nMonth, t1, and t2. tblNews is populated with whatever, and numbers in the nMonth field that coorespond to the nMonth in MonthNames. This can be obtained with a join: SELECT mn.mName, n.t1, n.t2 FROM tblNews n LEFT JOIN MonthNames mn ON n.nMonth = mn.nMonth ; > I can populate the MonthNames table with jan feb march etc > > Please can you clarify the next bit, I not familar with n JOIN ON n > Month? The "FROM tblNews n" and "JOIN MonthNames mn" parts alias those tables to aliased names (tblNews is aliased to n, and MonthNames is aliased to mn). This is wholy irrelevent, and is just helpful for typing less stuff. :) Say we populate MonthNames with these values: mysql> select * from MonthNames; ++---+ | nMonth | mName | ++---+ | 1 | Jan | | 2 | Feb | | 3 | Mar | | 4 | Apr | | 5 | May | | 6 | Jun | | 7 | Jul | | 8 | Aug | | 9 | Sep | | 10 | Oct | | 11 | Nov | | 12 | Dec | ++---+ 12 rows in set (0.00 sec) And tblNews with this: mysql> select * from tblNews; ++--+---+ | nMonth | t1 | t2| ++--+---+ | 2 | I am a line | This is one, too. | | 6 | These are other lines| foo lines | | 12 | All your lines are belong to us. | Are not. | ++--+---+ 3 rows in set (0.00 sec) And we can then perform a join on that to give us a query with month names that can be sorted by month name, or whatever. mysql> SELECT mn.mName, n.t1, n.t2 FROM tblNews n LEFT JOIN MonthNames mn ON n.nMonth = mn.nMonth ORDER BY n.nMonth ; +---+--+---+ | mName | t1 | t2| +---+--+---+ | Feb | I am a line | This is one, too. | | Jun | These are other lines| foo lines | | Dec | All your lines are belong to us. | Are not. | +---+--+---+ 3 rows in set (0.03 sec) Does this help? -- Gabriel Cain Unix Systems Administrator [EMAIL PROTECTED] Dialup USA, Inc. 888-460-2286 ext 208 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Simple SQL
This is the error: Microsoft][ODBC Microsoft Access Driver] ORDER BY clause (ID) conflicts with DISTINCT. This is the code used: "SELECT DISTINCT Month FROM tbl_LatestNews ORDER BY ID" Table Structure: Month, Headline, Image, Caption, Content I - Original Message - From: Gurhan Ozen <[EMAIL PROTECTED]> To: Peter Sampson <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 10:14 PM Subject: RE: Simple SQL > Peter, > Please give us more insight on this. Is the column where you store dates (or > months) is a date datatype column?? If yes you can just do > > SELECT ... FROM table_name ORDER BY MONTH(column_name); > > It'll help to see your table structure to help you. > Thanks. > > Gurhan > > -Original Message- > From: Peter Sampson [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 15, 2002 3:06 PM > To: [EMAIL PROTECTED] > Subject: Simple SQL > > > SQL beginner using Macromedia Ultradev. Can you help? > > Please be gentle I'm not a programmer! > > I am using > > Select DISTINCT Month > FROM tblNews > > The problem is that the months are shown alphabetical not in calendar order. > > How can I change this? > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Error writing file
Hi Bradley, Use perror program to see what the error code means.. # perror 28 Error code 28: No space left on device Seems like you ran out of space.. Gurhan -Original Message- From: Bradley Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 5:01 PM To: [EMAIL PROTECTED] Subject: Error writing file Hey all, I'm attempting to create a new table within a database. I have tried from the mysql client and also from dbtools. Here is the error message I am receiving: ERROR 3: Error writing file './path_to/file.frm' (Errorcode: 28) I am trying to add the table as root. I have checked the file permissions within the dbase directory and the permissions for all files is "mysql:mysql". Any suggestions or tips (maybe I'm just being stupid here) would be greatly appreciated. Thanks very much. Bradley Brown - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Simple SQL
Maybe it doesn't work because I'm using a SQL wizard in Ultradev, I'll try your code in the HTML/ASP part of the webpage The table structure is Month Headline Image Caption Content I can have many entries with the same month. Distinct makes a page with Click here for "MONTH" news. Clicking on "MONTH" takes you to all entries with that "MONTH" Currently the page that displays Click here for "MONTH" news is not in calendar order. Click here for "MONTH" Click here for "MONTH" - Original Message - From: Gurhan Ozen <[EMAIL PROTECTED]> To: Peter Sampson <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 10:14 PM Subject: RE: Simple SQL > Peter, > Please give us more insight on this. Is the column where you store dates (or > months) is a date datatype column?? If yes you can just do > > SELECT ... FROM table_name ORDER BY MONTH(column_name); > > It'll help to see your table structure to help you. > Thanks. > > Gurhan > > -Original Message- > From: Peter Sampson [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 15, 2002 3:06 PM > To: [EMAIL PROTECTED] > Subject: Simple SQL > > > SQL beginner using Macromedia Ultradev. Can you help? > > Please be gentle I'm not a programmer! > > I am using > > Select DISTINCT Month > FROM tblNews > > The problem is that the months are shown alphabetical not in calendar order. > > How can I change this? > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Simple SQL
Peter, Please give us more insight on this. Is the column where you store dates (or months) is a date datatype column?? If yes you can just do SELECT ... FROM table_name ORDER BY MONTH(column_name); It'll help to see your table structure to help you. Thanks. Gurhan -Original Message- From: Peter Sampson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 3:06 PM To: [EMAIL PROTECTED] Subject: Simple SQL SQL beginner using Macromedia Ultradev. Can you help? Please be gentle I'm not a programmer! I am using Select DISTINCT Month FROM tblNews The problem is that the months are shown alphabetical not in calendar order. How can I change this? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Column Header/ Column Description
That's why there is a seperate area called "documentation" . why let MySQL software run slower and/or eat up more memory space with a useless feature. You can always document your specifications in a document, it doesn't have to be stored on the tables themselves. If you really want that documentation to be in your database, you can create a table with table_name, field_name, field_description columns and enter the information there. Just my 2 cents on this.. Gurhan -Original Message- From: mike markovich [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 4:54 PM To: Paul DuBois; [EMAIL PROTECTED] Subject: RE: Column Header/ Column Description Paul, Thanks for responding. The ability to document columns, tables, databases, etc. seems pretty important to me. Why is this not an issue to others? Am I approaching this issue the wrong way? Your thoughts would be appreciated. Mike -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 1:02 PM To: mike markovich; [EMAIL PROTECTED] Subject: Re: Column Header/ Column Description At 11:48 -0700 5/15/02, mike markovich wrote: >Hi All, > >What is the convention for documenting the contents/purpose of a >column in MySql? There is none. > Most databases I have worked with had a way where text could be >entered for each column that described the purpose and or contents >of the column. It seems to me that this is something that should >happen at table creation time, but I've searched for a long time and >haven't found anything. A more general question might be how is >meta data entered or stored for tables and columns in MySql? > >Can somebody point me in the right direction? > >Many Thanks, >Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Column Header/ Column Description
At 13:54 -0700 5/15/02, mike markovich wrote: >Paul, > >Thanks for responding. The ability to document columns, tables, >databases, etc. seems pretty important to me. Why is this not an >issue to others? Am I approaching this issue the wrong way? Your >thoughts would be appreciated. > >Mike I guess I don't view the inability to store this information as database metadata as an impediment to documenting the database. > >-Original Message- >From: Paul DuBois [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, May 15, 2002 1:02 PM >To: mike markovich; [EMAIL PROTECTED] >Subject: Re: Column Header/ Column Description > > >At 11:48 -0700 5/15/02, mike markovich wrote: >>Hi All, >> >>What is the convention for documenting the contents/purpose of a >>column in MySql? > >There is none. > >>Most databases I have worked with had a way where text could be >>entered for each column that described the purpose and or contents >>of the column. It seems to me that this is something that should >>happen at table creation time, but I've searched for a long time and >>haven't found anything. A more general question might be how is >>meta data entered or stored for tables and columns in MySql? >> >>Can somebody point me in the right direction? >> >>Many Thanks, > >Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Column Header/ Column Description
>- Original Message - > From: "mike markovich" <[EMAIL PROTECTED]> > To: "Paul DuBois" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Wednesday, May 15, 2002 3:54 PM > Subject: RE: Column Header/ Column Description > > Paul, > > Thanks for responding. The ability to document columns, tables, databases, etc. seems pretty important to me. Why is this > not an issue to others? Am I approaching this issue the wrong way? Your thoughts would be appreciated. This is usually documented in your data model, not the database itself. Whether or not that's an Erwin or Visio diagram, or a mysqldump that's annotated. I'm interested in hearing what databases you have used that have this functionality? SQL server and Oracle do not, for example. -Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: Simple SQL
So i change the properties of Month to Integer in tblNews? Create another table called MonthNames? Now I'm lost a bit, please can you clarify? I can populate the MonthNames table with jan feb march etc Please can you clarify the next bit, I not familar with n JOIN ON n Month? > - Original Message - > From: Gabriel <[EMAIL PROTECTED]> > To: Peter Sampson <[EMAIL PROTECTED]> > Sent: Wednesday, May 15, 2002 8:32 PM > Subject: Re: Simple SQL > > > > Change the way you do your months. Instead of entering each month, you > > could do it this way: > > > > Change tblNews.Month to an integer, and add this table: > > > > CREATE TABLE MonthNames ( month int not null primary key, month_name > > char(32) ); > > > > Populate the MonthNames table, and then your query could become this: > > > > SELECT DISTINCT mn.month_name FROM tblNews n JOIN MonthNames > > ON n.Month = mn.month ORDER BY mn.Month ; > > > > Or something like that. > > > > Enjoy, > > Gabriel. > > > > > > Peter Sampson wrote: > > > SQL beginner using Macromedia Ultradev. Can you help? > > > > > > Please be gentle I'm not a programmer! > > > > > > I am using > > > > > > Select DISTINCT Month > > > FROM tblNews > > > > > > The problem is that the months are shown alphabetical not in calendar > order. > > > > > > How can I change this? > > > > > > > > > - > > > Before posting, please check: > > >http://www.mysql.com/manual.php (the manual) > > >http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > > > > -- > > Gabriel Cain > > Unix Systems Administrator [EMAIL PROTECTED] > > Dialup USA, Inc. 888-460-2286 ext 208 > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error writing file
Hey all, I'm attempting to create a new table within a database. I have tried from the mysql client and also from dbtools. Here is the error message I am receiving: ERROR 3: Error writing file './path_to/file.frm' (Errorcode: 28) I am trying to add the table as root. I have checked the file permissions within the dbase directory and the permissions for all files is "mysql:mysql". Any suggestions or tips (maybe I'm just being stupid here) would be greatly appreciated. Thanks very much. Bradley Brown - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Column Header/ Column Description
Paul, Thanks for responding. The ability to document columns, tables, databases, etc. seems pretty important to me. Why is this not an issue to others? Am I approaching this issue the wrong way? Your thoughts would be appreciated. Mike -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 1:02 PM To: mike markovich; [EMAIL PROTECTED] Subject: Re: Column Header/ Column Description At 11:48 -0700 5/15/02, mike markovich wrote: >Hi All, > >What is the convention for documenting the contents/purpose of a >column in MySql? There is none. > Most databases I have worked with had a way where text could be >entered for each column that described the purpose and or contents >of the column. It seems to me that this is something that should >happen at table creation time, but I've searched for a long time and >haven't found anything. A more general question might be how is >meta data entered or stored for tables and columns in MySql? > >Can somebody point me in the right direction? > >Many Thanks, >Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Newbie asks error 1036 table read only?
Hi, I recently inherited a Mysql 3.23.46 database, have some old ISAM tables on which I am unable to do updates or inserts. I get error message #1036 'Table is read only.' I am able to sign on to the database through the root, set myself up as a superuser in the user table, and have been able to set up test tables and make inserts etc. so it doesn't look like a permissions issue. I thought that converting the tables to myisam might help but of course I get the same error message. When I copied one of the smaller tables into a new table I was able to update it. (as a last resort I could do this on all the tables, but some are large and it doesn't really address why the problem occurred) Any suggestions would be very much appreciated. Thanks! - Bill Flanagan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is there MySQL version 4.0.2 ?
At 9:59 -0600 5/15/02, Colin Faber wrote: >Hi, > >as far as I know the only way that can be correct is to have one of the >committers rename the files them selves that have duplicate names. Since >windows isn't smart enough to realize that "ABC" doesn't mean "abc". > >Good luck getting it working under windows ;-) The same thing happens under Mac OS X, which also uses case-insensitive filenames. One way around this is to clone the tree onto a system that has case sensitive filenames, tar it up and move it to the system where you really want it, and unpack it. One of the "duplicate" files will replace the other, but in this case it doesn't really matter because they're supposed to be deleted files anyway. > > >Viliam Batka wrote: >> >> Hi , >> >> CFc> I've decided to provide a snapshot release system of the data on the >> CFc> work.mysql.com server for 4.0.x you can access the nightly builds here: >> CFc> >> CFc> http://www.mysqldeveloper.com/snapshots/ >> >> thank you very much for the option to download the snapshot. >> Just my Intention is to by involved more seriously and therefore >> I would like to use the BitKeeper. >> >> LBc> > You can get the latest source code >> LBc> > take a look at >> LBc> > http://www.mysql.com/doc/I/n/Installing_source_tree.html >> LBc> > to see how to proceed >> >> At the moment I am using Windows 2000 and >> BitKeeper 2.1 for Windows. After applying the : >> >> >bk clonebk://work.mysql.com:7001 mysql-4.0 >> >> I have got following message: >> >> == >> Sfio has detected a name conflict between >> "BitKeeper/deleted/SCCS/s..del-Makefil >> e.w32" and "BitKeeper/deleted/SCCS/s..del-makefile.w32"; >> This usually happens when you transfer file from a case-sensitive file >> system (e.g. Unix) to a case insensitive file system (e.g FAT, NTFS) >> Please rename one of the files and retry (see also "bk helptool mv") >> Note: You must do the rename in the sending repository. >> == >> >> In hope to fix it via "bk pull" and I have used the: >> >> >cd mysql-4.0 >> >bk pull bk://work.mysql.com:7001 >> Nothing to pull from bk://work.mysql.com:7001 >> >> when I have checked my local copy via: >> >> >bk -r check -a >> >> I have got plenty of files that was not resolved. >> >> Am I doing something wrong or I shall forget about BitKeeper as I am using >> the >> Windown 2000? Any suggestion? >> >> Thanks, >> >> Viliam Batka > >-- >Colin Faber >(303) 736-5160 >fpsn.net, Inc. > >- >Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Column Header/ Column Description
At 11:48 -0700 5/15/02, mike markovich wrote: >Hi All, > >What is the convention for documenting the contents/purpose of a >column in MySql? There is none. > Most databases I have worked with had a way where text could be >entered for each column that described the purpose and or contents >of the column. It seems to me that this is something that should >happen at table creation time, but I've searched for a long time and >haven't found anything. A more general question might be how is >meta data entered or stored for tables and columns in MySql? > >Can somebody point me in the right direction? > >Many Thanks, >Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Temp Table size?
Hi Mike, Possibly out of available memory. (Or disk space assuming that's what it's hitting) Mike Grover wrote: > > When I create a temp table, If I put to much in it, > I get a "Temp Table [Table name] is Full" error. > > I changed my tmp_table_size to a ver large number. > > Still same error, Any Ideas? > > This is windows 2000 > MySQL 4.01 > Config Loaded Form my.ini in winnt dir. > > Show Variables for server shows new tmp_table_size set > In ini file. > > mike > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: empty?
At 15:40 -0400 5/15/02, Amy Zediak wrote: >I have my MySQL database up and running, but its empty...did i miss a >step? > >Thanks >Amy Do you mean: - Your server is up and running, but there are no databases at all - Your server is up and running, and there is a database named "mysql" but it contains no tables - Your server is up and running, and there is a "mysql" database with user, host, db, etc. tables, but no other databases Or do you mean something else? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Simple SQL
* Rodney Broom > From: Peter Sampson <[EMAIL PROTECTED]> > > Select DISTINCT Month > > FROM tblNews > > > > The problem is that the months are shown alphabetical not in > > calendar order. > > I'm assuming that your months are stored as names like: > > January, February, March > > or > > Jan, Feb, Mar > > > If so, I think that sorting in SQL will be a bit clunky. I would > advise either storing your dates as dates, or using an outside > program to sort your month names. > > Of course, somebody else might know of something simple that I'm missing. I guess this would be pretty simple: Select DISTINCT Month FROM tblNews ORDER BY FIELD(Month, 'Jan','Feb','Mar','Apr','May','Jun', 'Jul','Aug','Sep','Oct','Nov','Dec') -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: empty?
Hi amy, No the database(s) them selves are empty until populated with tables, and data. Amy Zediak wrote: > > I have my MySQL database up and running, but its empty...did i miss a > step? > > Thanks > Amy > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL & SYBASE
Hi Chris, Dear Sir/Madam seems a little formal for a public mailing list! Anyway, we use perl scripts to transfer information from Microsoft SQL server (which was and is somewhat compatable with SyBASE) use the freeTDS sybase/mssql drivers to mysql. I modeled the databse with ErWIN first then used a perl script to SELECT the data and INSERT it into mySQL. so the short answer is yes, a routine can be written that does this. Hope this helps, Ken - Original Message - From: "Christopher E. Aston" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 1:05 PM Subject: MySQL & SYBASE > Dear Sir/Madam, > > An odd question. Can a SYBASE database and a MySQL database interact? That > is, can routines be written that, at a specified time or time intervals, > syncronize specified data between these two databases? An comments or > opinions would be appreciated. > > Thanks > > -chris > > Christopher E. Aston, Ph.D. > Director, Genetic Epidemiology Unit > Oklahoma Medical Research Foundation > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Temp Table size?
When I create a temp table, If I put to much in it, I get a "Temp Table [Table name] is Full" error. I changed my tmp_table_size to a ver large number. Still same error, Any Ideas? This is windows 2000 MySQL 4.01 Config Loaded Form my.ini in winnt dir. Show Variables for server shows new tmp_table_size set In ini file. mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
a date for 3.23.50 declared as stable ?
Hi list, i know that 3.23.50 is a pre-released version. But if someone can tell me when this version will be declared as stable so i will upgrade my linux production servers running redhat 7.2 and gcc 2.96 with the tar.gz build mysql. Thanks David filter : sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
empty?
I have my MySQL database up and running, but its empty...did i miss a step? Thanks Amy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Simple SQL
From: Peter Sampson <[EMAIL PROTECTED]> > Select DISTINCT Month > FROM tblNews > > The problem is that the months are shown alphabetical not in calendar order. I'm assuming that your months are stored as names like: January, February, March or Jan, Feb, Mar If so, I think that sorting in SQL will be a bit clunky. I would advise either storing your dates as dates, or using an outside program to sort your month names. Of course, somebody else might know of something simple that I'm missing. --- Rodney Broom President, R.Broom Consulting - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Best book on MySQL
Thanks for the insight. --jeff - Original Message - From: "Mike Grover" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 6:07 AM Subject: RE: Best book on MySQL > Mainly what hooked me on mySQL was the static record layout for MyISAM > tables. > > I have to import into new tables > about 120 million records every three months. > I wrote a Quick Delphi 6 app to do this(very fast). > Once I figured out how the byte header for deleted and null Fields work > at the beginning of each MyIsam row, I now Can also use null field > checking in my queries. ( I suck out important fields from a 1100 byte > fixed row record > text file into a 379 byte MyISAM row that goes directly into the > myd file. Run "myisamchk -r -q v:\data\experian\ca" and > my Indexes are rebuilt :-) ) > > > I then Optimize these tables, and mySQL speed is Awsome... > > > > > -Original Message- > From: Jeff Kilbride [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 14, 2002 4:33 PM > To: Michael Grover; [EMAIL PROTECTED] > Subject: Re: Best book on MySQL > > > Hi Mike, > > What did you think of Firebird vs. MySQL? I haven't seen any comparisons > by people who have used both. > > Thanks, > --jeff > > - Original Message - > From: "Michael Grover" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Saturday, May 11, 2002 7:25 PM > Subject: Re: Best book on MySQL > > > > > > I ported several applications from Firebird 1.0 to MySQL 4. The main > > things I ran into was little SQL Syntax differences, Stored > > procedures, and Triggers... > > > > > >mike > > > > Paul DuBois wrote: > > > > > > At 13:40 -0700 5/11/02, Jeff Kilbride wrote: > > > >MySQL > > > >Paul DuBois > > > >New Riders > > > > > > > >Plus, he's here on the list answering questions... :) > > > > > > That's true. > > > > > > However, I should mention that the book doesn't say anything about > > > InterBase. :-) > > > > > > >--jeff > > > > > > > >- Original Message - > > > >From: "Todd Cary" <[EMAIL PROTECTED]> > > > >To: <[EMAIL PROTECTED]> > > > >Sent: Saturday, May 11, 2002 8:43 AM > > > >Subject: Best book on MySQL > > > > > > > > > > > >> I need to convert a PHP app from using Interbase to using MySQL. > What is > > > >the > > > >> best book? > > > >> > > > >> Todd > > > >> > > > >> -- > > > >> Todd Cary > > > >> Ariste Software > > > >> 2200 D Street Extension > > > >> Petaluma, CA 94952 > > > >> 707-773-4523 > > > > > [EMAIL PROTECTED] > > > > > > > > > - > > > Before posting, please check: > > >http://www.mysql.com/manual.php (the manual) > > >http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: > > > http://lists.mysql.com/php/unsubscribe.php > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Simple SQL
SQL beginner using Macromedia Ultradev. Can you help? Please be gentle I'm not a programmer! I am using Select DISTINCT Month FROM tblNews The problem is that the months are shown alphabetical not in calendar order. How can I change this? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Column Header/ Column Description
Hi All, What is the convention for documenting the contents/purpose of a column in MySql? Most databases I have worked with had a way where text could be entered for each column that described the purpose and or contents of the column. It seems to me that this is something that should happen at table creation time, but I've searched for a long time and haven't found anything. A more general question might be how is meta data entered or stored for tables and columns in MySql? Can somebody point me in the right direction? Many Thanks, Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Best book on MySQL
Hi Mike, Thanks. I appreciate the insight. I think I remember the "sweeping" maintenance of the tables from the stuff I read at the Firebird sourceforge site -- called "vacuuming", right? That seemed like a serious pain in the butt. Also, I couldn't find any easy solutions for replication, which is why I finally chose MySQL. Thanks again, --jeff - Original Message - From: "mos" <[EMAIL PROTECTED]> To: "Jeff Kilbride" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 8:14 AM Subject: Re: Best book on MySQL > At 04:34 PM 5/14/2002, you wrote: > >I'd be interested in how both of you compared them. > > > >Thanks, > >--jeff > > > Jeff, > I'm using MySQL for a webserver and didn't really want to use > Firebird (Interbase) for that type of application. It is my feeling that IB > requires more maintenance than MySQL. It's peculiar transaction scheme > requires the database to be swept from time to time (daily if you do a lot > of updates) to get rid of the old records. If you update or delete a > record, the old record isn't really deleted. The new record has a higher > transaction number so it gets retrieved over an older one. This means > updated/deleted records stick around until it is swept (which is an > automatic process) and this may have an effect on performance. This type of > transactions is really fast if you are doing a lot of rollbacks because > rolling back thousands of records takes just milliseconds. IB is a feature > rich relational database. It has everything you could ever want in a > database. Triggers, stored procedures, calculated fields. You can also > write your own functions in a Delphi or CB dll and call them as if they > were another IB function. People normally don't recompile the IB source, at > least not as much as with MySQL. IB runs on Windows, Linux, and Solaris. > > BUT IB is much more CPU intensive for the same # of users than > MySQL. There used to be a limit of 254 concurrent users but I believe that > limit has been surpassed with the Linux version. I don't know how well IB > will run with that many users because the CPU may max out before then. > There is also a question of connection speed on a web server. Most people > would use persistent connections and employ middleware to connect more than > 254 users at a time. Middleware like Midas (Borland) of course costs money. > The price of Midas has dropped in the past few years from around $2500 per > server to around $250. I would also be a bit hesitant to put more than say > a million rows in an IB database. This is just me, mind you. Some people > have successfully put 100 million rows into IB tables. My hesitation comes > from the fact that IB will slow down if there are a lot of updates, even > with sweeping. You need to unload and reload the data occasionally. And IB > inserts data at a much slower rate than MySQL. So if it is run on a > webserver, it means more down time. It could take a couple of days to > reload 100 million rows in IB. > > My personal feeling is that IB is better suited to vertical market > applications or for corporate databases where they absolutely need > referential integrity. Here they can take the database down overnight, do > maintenance on it, and it won't affect anyone. This is difficult to do if > it us running on a webserver. If your webserver is readonly and has a low > number of concurrent users, then IB might be worth a look. IB (Firebird) > licensing is also much more liberal than MySQL because Firebird > applications can be distributed freely on all platforms, even for > commercial use. Sadly there aren't any books on Interbase. The last one was > printed in 1997 (Ken Henderson) and dealt with accessing IB from Delphi > applications. All of the documentation is in PDF files and IB is well > documented (but fragmented in a lot of PDF files). For more information, > see http://firebird.sourceforge.net/ and http://www.ibphoenix.com/ . > >Well, that's my 2 cents worth. IB (Firebird) is heavy duty > database and exceeds PostgreSQL in features. So if you're leaning towards > PostgreSQL, you may want to look at Firebird. It's not the fastest database > on the block, but it is feature-rich. (chubby?). > > Mike > > > > >- Original Message - > >From: "mos" <[EMAIL PROTECTED]> > >To: "Michael Grover" <[EMAIL PROTECTED]> > >Cc: <[EMAIL PROTECTED]> > >Sent: Monday, May 13, 2002 7:35 AM > >Subject: Re: Best book on MySQL > > > > > > > At 09:25 PM 5/11/2002, you wrote: > > > > > > >I ported several applications from Firebird 1.0 to MySQL 4. > > > >The main things I ran into was little SQL Syntax differences, Stored > > > >procedures, and > > > >Triggers... > > > > > > > > > > > >mike > > > > > > Mike, > > > Out of curiosity, why did you switch from Interbase to MySQL? > > > (I've used both) > > > > > > Mike > > > > - Before postin
Assertion failure with mysql-3.23.49a/InnoDB
I've gotten this same assertion failure twice. I'm very confident in this machine's stability since it has survived 36 hours worth of CTCS, so I'm not going to look for a hardware problem just yet. At first I thought it may have been the glibc issue with threads overwriting each other's stacks but this time possible memory use is well under 2GB. I tried to resolve the symbols but the mysql binary doesn't appear to come with debugging symbols (or at least any that ``nm'' was able to find). Using the mysql-max-3.23.49a-pc-linux-gnu-i686 tarball binary Hopefully someone has seen this before?? /usr/local/mysql/bin/mysqld: ready for connections InnoDB: Assertion failure in thread 61456 in file ../include/page0page.ic line 515 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. InnoDB: Thread 446574 stopped in file os0sync.c line 395 We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=67104768 InnoDB: Thread 266306 stopped in file sync0arr.c line 336 InnoDB: Thread 8195 stopped in file os0sync.c line 115 InnoDB: Thread 12292 stopped in file os0file.c line 1175 record_buffer=131072 sort_buffer=4194296 max_used_connections=121 max_connections=300 threads_connected=60 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 1332729 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x806dc04 0x82ad1a8 0x81d19c7 0x81d3077 0x81ba8e0 0x8193681 0x80bf5aa 0x80c0ded 0x8093962 0x809372b 0x808b704 0x8074a4a 0x8078b48 0x8073c24 0x8072fd7 Some mysqlbug output: System: Linux fileserv 2.4.7-10smp #1 SMP Thu Sep 6 17:09:31 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wextern-inline -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Feb 22 10:38 /lib/libc.so.6 -> libc-2.2.4.so -rwxr-xr-x1 root root 1282588 Sep 4 2001 /lib/libc-2.2.4.so -rw-r--r--1 root root 27304836 Sep 4 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 4 2001 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-innodb --with-berkeley-db --enable-thread-safe-client --with-other-libc=/usr/local/mysql-glibc '--with-comment=Official MySQL Binary' --prefix=/usr/local/mysql --with-extra-charset=complex --enable-thread-safe-client --enable-local-infile --with-server-suffix=-max 'CFLAGS=-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' 'CXXFLAGS=-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wextern-inline -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX=gcc -- Michael Bacarella | Netgraft Corporation | 545 Eighth Ave #401 Systems Analysis | New York, NY 10018 Technical Support | 212 946-1038 | 917 670-6982 Managed Services | [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar
Re: Pre-release of MySQL 3.23.50
Hi! Trying to catch up with some old emails... > "Ireneusz" == Ireneusz Piasecki <[EMAIL PROTECTED]> writes: Ireneusz> Hi. I'm running on linux box 6.2 with glibc 2.1 and i compiled from src.rpm Ireneusz> mysql. Ireneusz> The compiler is gcc 2.95.2. Ireneusz> So, the new version of mysql 3.23.50 can i complie with it (2.95.2) or i Ireneusz> must upgrade to gcc 3.0.4 ??? You can use either gcc 2.95.x or gcc 3.0.x to compile MySQL. We are just trying out gcc 3.0.4 ourselves as we have to switch compiler from egcs 2.91.66 on our build machine because we want to use a newer glibc library. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.44 not using indexes
Hi! > "Myk" == Myk Melez <[EMAIL PROTECTED]> writes: Myk> Steven Roussey wrote: >> Are the tables defined the same on both servers? >> Myk> Yes, the tables are defined exactly the same. >> Is the data the same? >> Myk> Just about. The data on the working server is a copy of the database on Myk> the broken server. For previous tests I used a several-weeks-old copy Myk> of the data, but for today's tests I re-copied the data over, so it Myk> represents almost the same exact data set. >> Is the query the same? Are both analyzed? >> Myk> Yes, I analyzed the tables on both databases before running the explain Myk> queries, and the explain queries are exactly the same. The only Myk> difference I can come up with is that the database on the working server Myk> was dumped from the broken server via mysqldump and then imported into Myk> the working server, while the database on the broken server was created Myk> via table creation statements years ago and has since been updated from Myk> the ISAM to the MyISAM table type and the database server from version Myk> 3.22.30 to 3.23.44. Myk> Is it possible that indexes were somehow corrupted in the process and Myk> need to be rebuilt from scratch? Does it make sense to dump the data on Myk> the broken server and re-import it into a different database on that server? You can check if the index are ok with CHECK TABLE; If this says the index is ok, they are not corrupted. You can optimize the index layout by using OPTIMIZE TABLE. But back to the original problem: mysql> EXPLAIN SELECT bug_id FROM bugs WHERE bug_status IN ('NEW', 'ASSIGNED', 'REOPENED'); +---+--+---+--+-+--+++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+--+---+--+-+--+++ | bugs | ALL | bug_status| NULL |NULL | NULL | 139425 | where used | +---+--+---+--+-+--+++ The above shows that MySQL could use the index but decides to not use this because it concludes that a table scan will be faster. To verify this can you send us the result for the following queries: SELECT count(*) FROM bugs WHERE bug_status IN ('NEW', 'ASSIGNED', 'REOPENED'); SELECT count(*) FROM bugs; If the first query returns more than 30 % of the second, then MySQL works as expected in this case. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql error
Hi Tristan, Both the client and the server must have that option enabled. You must also have the right setup in your grant tables to load files. Try loading it locally (with out the LOCAL flag) and see if that helps. Tristan Trio wrote: > > Hello, > Am new to mySQL. I had installed mySQL version 3.23.49 on my pc > running on windows 98. My problem is when I tried to populate a > database using the command: > load data local infile "uprhs.txt" into table uprhs; > i get an error message "ERROR 1148: The used command is not allowed > with this MySQL version" > Is that command not availbale in version 3.23.49 if yes what is the > alternate command for it. > Would appreciate any help you can give me. > > Tristan -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
bug in multi-table delete in MySQL-4.0.2 ?
Hi, I'm just testing the new multi-table delete in MySQL-4.0.2 and I wonder if I'm doing something wrong with this query : mysql> DELETE FROM searchmainhardwarefr2,searchjoinhardwarefr2 USING searchmainhardwarefr2 as a,searchjoinhardwarefr2 as b,forumconthardwarefr2 as c WHERE b.numreponse=a.numreponse AND b.topic=c.numeropost AND c.date<'2002-01-01'; Query OK, 21 rows affected (0.34 sec) (I want to delete rows from searchmainhardwarefr2 and searchjoinhardwarefr2 which match the join) As you can see, MySQL display 21 row affected, but I tried the following : mysql> SELECT COUNT(*) FROM searchmainhardwarefr2 as a,searchjoinhardwarefr2 as b,forumconthardwarefr2 as c WHERE b.numreponse=a.numreponse AND b.topic=c.numeropost AND c.date<'2002-01-01'; +--+ | COUNT(*) | +--+ | 1744709 | +--+ 1 row in set (1 min 19.34 sec) That's not 21 rows :) The delete seems to erase nothing since the select was issued AFTER the delete. Moreover, the returned number of rows seems to be random : mysql> DELETE FROM searchmainhardwarefr2,searchjoinhardwarefr2 USING searchmainhardwarefr2 as a,searchjoinhardwarefr2 as b,forumconthardwarefr2 as c WHERE b.numreponse=a.numreponse AND b.topic=c.numeropost AND c.date<'2002-01-01'; Query OK, 21 rows affected (0.34 sec) mysql> DELETE FROM searchmainhardwarefr2,searchjoinhardwarefr2 USING searchmainhardwarefr2 as a,searchjoinhardwarefr2 as b,forumconthardwarefr2 as c WHERE b.numreponse=a.numreponse AND b.topic=c.numeropost AND c.date<'2002-01-01'; Query OK, 24 rows affected (0.38 sec) mysql> DELETE FROM searchmainhardwarefr2,searchjoinhardwarefr2 USING searchmainhardwarefr2 as a,searchjoinhardwarefr2 as b,forumconthardwarefr2 as c WHERE b.numreponse=a.numreponse AND b.topic=c.numeropost AND c.date<'2002-01-01'; Query OK, 28 rows affected (0.31 sec) mysql> DELETE FROM searchmainhardwarefr2,searchjoinhardwarefr2 USING searchmainhardwarefr2 as a,searchjoinhardwarefr2 as b,forumconthardwarefr2 as c WHERE b.numreponse=a.numreponse AND b.topic=c.numeropost AND c.date<'2002-01-01'; Query OK, 19 rows affected (0.44 sec) Tell me if I'm doing something wrong, and if not I will try to send a testcase ASAP at bugs mailing list. Regards, Jocelyn Fournier - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Dateformat
On Wednesday, 15. May 2002 14:54, Mattias Persson wrote: > query above. The manual says > > %v Week (1..53), where Monday is the first day of the week. Used with '%x' > %u Week (0..53), where Monday is the first day of the week > > When is there a week 0? Hi, Week = 0 only is valid for %u. %v means January 1st is always in the 1st week, regardless which weekday it is. (1st Week: January 1st - until next sunday after January 1st %u means: The 1st week in January starts with first monday. So all before 1st monday is week 0. (Saturday Januar 1st = week 0, Monday January 3d is week 1) Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: checksum errors
Hi! > "Melvyn" == Melvyn Sopacua <[EMAIL PROTECTED]> writes: Melvyn> I don't get the checksum errors anymore - after I changed the table def. Melvyn> However - myisamchk is not doing a good job with the large keys (restored Melvyn> them by LOAD TABLE hardware FROM MASTER which produced the correct size), Melvyn> plus keys become corrupted when a replication packet is not received correctly, Melvyn> plus: mysql> SHOW VARIABLES LIKE '%ft%'; Melvyn> Empty set (0.07 sec) Can you create an example that shows that you how get a corrupted table when a replication packet fails ? This is something that should not be possible to happen. If failed packet doesn't have anything to do with a crashed table. On the other hand, you may got a crashed table on the slave and the replication stops because of this; This is however another issue. Melvyn> The myisamchck is certainly reproducable, as is the missing ft_ variables, Melvyn> resulting in no way to set ft_min_word_len. myisamchk in 4.0 supports the ft_min_word_len variable. If you change ft_min_word_len, you are probably better of with using REPAIR TABLE than myisamchk to repair a table. Melvyn> Should I re-report those bugs, so they are easier to process for you? Yes, if you can produce a full test case. Melvyn> Today I think I found something interesting: Melvyn> Some tables kept crashing, with incorrect keyfiles. Melvyn> Verifying the CREATE TABLE statement, there's was 1 correlation: Melvyn> The tables all had a second index on the primary key (for what reason? I don't Melvyn> know - legacy probably - I think the primary key, was dual-fielded at some Melvyn> point). I don't think this is the problem; There is no requirements inside MySQL to have the primary index as the first index. Melvyn> Combining that with the other table that kept crashing there seems to be a Melvyn> problem, Melvyn> with the situation, where one field is indexed more than one time. I would be really interested in having a test case that shows how to crash MySQL. Without a test case, I can't really give you any good advises of what could be the problem. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL & SYBASE
Perl is your friend. el In message <[EMAIL PROTECTED]>, "Ch ristopher E. Aston" writes: > Dear Sir/Madam, > > An odd question. Can a SYBASE database and a MySQL database interact? That > is, can routines be written that, at a specified time or time intervals, > syncronize specified data between these two databases? An comments or > opinions would be appreciated. > > Thanks > > -chris > > Christopher E. Aston, Ph.D. > Director, Genetic Epidemiology Unit > Oklahoma Medical Research Foundation > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DBI connect (help)
Hi all, I am trying to connect to my mysql database with a perl script... I can connect from commnad line both passing a password or at password prompt... I can connect successfully with the following line in my script.. my $dbh = DBI->connect("DBI:mysql:database=mysql;host=localhost", "root", "password", {'RaiseError' =>1}); But the following line fails.. with a Memory fault but no core dump my $dbh = DBI->connect("DBI:mysql:database=mysql;host=localhost" . ";mysql_read_default_file=$ENV{HOME}/.my.cnf", $user, $password); DBI->trace(9); outputs the following imp_dbh->mysql_dr_connect: host = localhost, port =0, uid = NULL, pwd = NULL .my.cnf file looks like... [client] user=root password=passwd Any ideas or anything blatenly obvious as to what is wrong? Thanks, Taylor Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 "Help Wanted. Seeking Telepath..." "You Know where to apply." Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql.sock difficulties
- Original Message - From: "Scott J. Pearson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 7:13 PM Subject: mysql.sock difficulties > I installed one version of MySQL but had to reinstall MySQL. > Thus, I manually deleted the first installation, > including /tmp/mysql.sock. > > The second installation mysteriously did not install another > copy of mysql.sock. Gerry-mandering the configuration > through the following line avails nothing: > ../configure --with-unix-socket-path=/tmp/mysql.sock > > Can someone inform me of how I might automatically > /manually install mysql.sock? You don't need to, Scott. :) "mysql.sock" is the name of the UNIX domain socket. Although visible in the filesystem, it is a socket nonetheless. When you start the daemon, it will be created for you; and if the daemon shuts down, it will be unlinked again by the daemon. - Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql.sock difficulties
I installed one version of MySQL but had to reinstall MySQL. Thus, I manually deleted the first installation, including /tmp/mysql.sock. The second installation mysteriously did not install another copy of mysql.sock. Gerry-mandering the configuration through the following line avails nothing: ./configure --with-unix-socket-path=/tmp/mysql.sock Can someone inform me of how I might automatically/manually install mysql.sock? Thanks, Scott --- Scott J. Pearson Clemson University Genome Institute [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL & SYBASE
Dear Sir/Madam, An odd question. Can a SYBASE database and a MySQL database interact? That is, can routines be written that, at a specified time or time intervals, syncronize specified data between these two databases? An comments or opinions would be appreciated. Thanks -chris Christopher E. Aston, Ph.D. Director, Genetic Epidemiology Unit Oklahoma Medical Research Foundation - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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, query
As an addendum to my last message: If you want to do db dev through the GUI, I would suggest the MyCC from MySQL AB over dbTools. MyCC provides more in the way of server process and variable exposure within the GUI itself. Mike - Original Message - From: "Anne Hall" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 12:29 PM Subject: Re: sql, query > Here is my message again: > > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query > > If you just reply to this message, and include the entire text of it in the > reply, your reply will go through. However, you should > first review the text of the message to make sure it has something to do > with MySQL. Just typing the word MySQL once will be sufficient, for example. > > You have written the following: > > Hi, > I just sent you a message, here is some addition information about my > question. I am using win98 at my desk, however, our server is Unix. Question > is if I would like to use GUI to help to develop a database in my computer, > can I just export it to the server or is there anyway I can load to the > server? > > Regards, > > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query > > If you just reply to this message, and include the entire text of it in the > reply, your reply will go through. However, you should > first review the text of the message to make sure it has something to do > with MySQL. Just typing the word MySQL once will be sufficient, for example. > > You have written the following: > > Hi, > I just sent you a message, here is some addition information about my > question. I am using win98 at my desk, however, our server is Unix. Question > is if I would like to use GUI to help to develop a database in my computer, > can I just export it to the server or is there anyway I can load to the > server? > > Regards, > > Anne Hall > IntelliSTAR(sm) > Providing High-Tech, High-Touch services for over 6 Years! > > http://www.intellistar.net > 407.206.0788 Ph > 407.206.0826 Fax > [EMAIL PROTECTED] > > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Max vs. InnoDB?
Hello list, what's the difference and relation between MySQL-Max and the stuff at www.innodb.com? Both technically and license-wise... Thanks. Vaclav Dvorak [EMAIL PROTECTED] IDAS, s.r.o.http://www.idas.cz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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, query
Here is my message again: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hi, I just sent you a message, here is some addition information about my question. I am using win98 at my desk, however, our server is Unix. Question is if I would like to use GUI to help to develop a database in my computer, can I just export it to the server or is there anyway I can load to the server? Regards, Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hi, I just sent you a message, here is some addition information about my question. I am using win98 at my desk, however, our server is Unix. Question is if I would like to use GUI to help to develop a database in my computer, can I just export it to the server or is there anyway I can load to the server? Regards, Anne Hall IntelliSTAR(sm) Providing High-Tech, High-Touch services for over 6 Years! http://www.intellistar.net 407.206.0788 Ph 407.206.0826 Fax [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: download mysql GUI
Without knowing what you need to be able to do in a MySQL GUI: I have MyCC 0.8.2 from MySQL AB and dbTools 1.0.13 from www.dbtools.com.br. I like both. MyCC is alpha and a little finicky at times...but easy to use. dbTools is interesting and has a lot of potential. HTH Mike - Original Message - From: "Anne Hall" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 11:56 AM Subject: download mysql GUI > Hi: > I am trying to download GUI for mysql server, however, there are several > choices at the site, would you please give some advise of which one I should > download please? > > > Regards, > > Anne Hall > IntelliSTAR(sm) > Providing High-Tech, High-Touch services for over 6 Years! > > http://www.intellistar.net > 407.206.0788 Ph > 407.206.0826 Fax > [EMAIL PROTECTED] > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is there MySQL version 4.0.2 ?
Hi, as far as I know the only way that can be correct is to have one of the committers rename the files them selves that have duplicate names. Since windows isn't smart enough to realize that "ABC" doesn't mean "abc". Good luck getting it working under windows ;-) Viliam Batka wrote: > > Hi , > > CFc> I've decided to provide a snapshot release system of the data on the > CFc> work.mysql.com server for 4.0.x you can access the nightly builds here: > CFc> > CFc> http://www.mysqldeveloper.com/snapshots/ > > thank you very much for the option to download the snapshot. > Just my Intention is to by involved more seriously and therefore > I would like to use the BitKeeper. > > LBc> > You can get the latest source code > LBc> > take a look at > LBc> > http://www.mysql.com/doc/I/n/Installing_source_tree.html > LBc> > to see how to proceed > > At the moment I am using Windows 2000 and > BitKeeper 2.1 for Windows. After applying the : > >>bk clonebk://work.mysql.com:7001 mysql-4.0 > > I have got following message: > > == > Sfio has detected a name conflict between > "BitKeeper/deleted/SCCS/s..del-Makefil > e.w32" and "BitKeeper/deleted/SCCS/s..del-makefile.w32"; > This usually happens when you transfer file from a case-sensitive file > system (e.g. Unix) to a case insensitive file system (e.g FAT, NTFS) > Please rename one of the files and retry (see also "bk helptool mv") > Note: You must do the rename in the sending repository. > == > > In hope to fix it via "bk pull" and I have used the: > > >cd mysql-4.0 > >bk pull bk://work.mysql.com:7001 > Nothing to pull from bk://work.mysql.com:7001 > > when I have checked my local copy via: > > >bk -r check -a > > I have got plenty of files that was not resolved. > > Am I doing something wrong or I shall forget about BitKeeper as I am using > the > Windown 2000? Any suggestion? > > Thanks, > > Viliam Batka -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
download mysql GUI
Hi: I am trying to download GUI for mysql server, however, there are several choices at the site, would you please give some advise of which one I should download please? Regards, Anne Hall IntelliSTAR(sm) Providing High-Tech, High-Touch services for over 6 Years! http://www.intellistar.net 407.206.0788 Ph 407.206.0826 Fax [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Very new to windows version - question about host and server
Group, I have been using (very happily) mysql on unix boxes. I am in a new job and there is not a unix box in sight!!! ouch! This is a windows 2000 shop. Here is the situation and I am looking for any and all suggestions: 1) I have mysql, apache, perl, etc running on my own box and I have just installed mysql on the main server ( also windows 2000). 2) How do I access my new mysql databases on the server? 3) Does it have to do with the -h parm? Any and all help would be appreciated. If I have not been clear enough - I will try to add more. Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: MySQL database files
Augey, Wednesday, May 15, 2002, 4:25:15 PM, you wrote: AM> Those files got so big that I had no more space on my hard drive and AM> queriess would stop returning without any message telling me what was AM> going on. All for the log files? Doesn't that seem like something that AM> should be changed (atleast for the default install) ? It seems to me AM> that there should be a way to set a limit. I didnt see one. You can turn off logging or you can delete old log files in regular intervals. AM> Augey -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: gcc for newer mysql versions - what's needed exactly ?
j.random.programmer, Wednesday, May 15, 2002, 3:00:26 AM, you wrote: jrp> Can someone (who knows this sort of thing) give a jrp> layman's introduction to the interplay between jrp> various gcc versions and various mysql versions jrp> (3.49, 3.50, 4.01 etc) ? I have some linux boxes jrp> and don't really want to have to install/use gcc 3.x jrp> (because then I have the hassle of multiple gcc's jrp> on my system, as I need 2.95.x for other purposes). jrp> I don't really know gcc too well so if I download jrp> the *binary* versions of the upcoming mysql 3.50 jrp> or even 4.x, what exactly would I have to jrp> install on my system, gcc-wise ? If you are going to install MySQL binary distribution it doesn't metter what gcc do you have. jrp> Thanks and best regards, -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Best book on MySQL
At 04:34 PM 5/14/2002, you wrote: >I'd be interested in how both of you compared them. > >Thanks, >--jeff Jeff, I'm using MySQL for a webserver and didn't really want to use Firebird (Interbase) for that type of application. It is my feeling that IB requires more maintenance than MySQL. It's peculiar transaction scheme requires the database to be swept from time to time (daily if you do a lot of updates) to get rid of the old records. If you update or delete a record, the old record isn't really deleted. The new record has a higher transaction number so it gets retrieved over an older one. This means updated/deleted records stick around until it is swept (which is an automatic process) and this may have an effect on performance. This type of transactions is really fast if you are doing a lot of rollbacks because rolling back thousands of records takes just milliseconds. IB is a feature rich relational database. It has everything you could ever want in a database. Triggers, stored procedures, calculated fields. You can also write your own functions in a Delphi or CB dll and call them as if they were another IB function. People normally don't recompile the IB source, at least not as much as with MySQL. IB runs on Windows, Linux, and Solaris. BUT IB is much more CPU intensive for the same # of users than MySQL. There used to be a limit of 254 concurrent users but I believe that limit has been surpassed with the Linux version. I don't know how well IB will run with that many users because the CPU may max out before then. There is also a question of connection speed on a web server. Most people would use persistent connections and employ middleware to connect more than 254 users at a time. Middleware like Midas (Borland) of course costs money. The price of Midas has dropped in the past few years from around $2500 per server to around $250. I would also be a bit hesitant to put more than say a million rows in an IB database. This is just me, mind you. Some people have successfully put 100 million rows into IB tables. My hesitation comes from the fact that IB will slow down if there are a lot of updates, even with sweeping. You need to unload and reload the data occasionally. And IB inserts data at a much slower rate than MySQL. So if it is run on a webserver, it means more down time. It could take a couple of days to reload 100 million rows in IB. My personal feeling is that IB is better suited to vertical market applications or for corporate databases where they absolutely need referential integrity. Here they can take the database down overnight, do maintenance on it, and it won't affect anyone. This is difficult to do if it us running on a webserver. If your webserver is readonly and has a low number of concurrent users, then IB might be worth a look. IB (Firebird) licensing is also much more liberal than MySQL because Firebird applications can be distributed freely on all platforms, even for commercial use. Sadly there aren't any books on Interbase. The last one was printed in 1997 (Ken Henderson) and dealt with accessing IB from Delphi applications. All of the documentation is in PDF files and IB is well documented (but fragmented in a lot of PDF files). For more information, see http://firebird.sourceforge.net/ and http://www.ibphoenix.com/ . Well, that's my 2 cents worth. IB (Firebird) is heavy duty database and exceeds PostgreSQL in features. So if you're leaning towards PostgreSQL, you may want to look at Firebird. It's not the fastest database on the block, but it is feature-rich. (chubby?). Mike >- Original Message - >From: "mos" <[EMAIL PROTECTED]> >To: "Michael Grover" <[EMAIL PROTECTED]> >Cc: <[EMAIL PROTECTED]> >Sent: Monday, May 13, 2002 7:35 AM >Subject: Re: Best book on MySQL > > > > At 09:25 PM 5/11/2002, you wrote: > > > > >I ported several applications from Firebird 1.0 to MySQL 4. > > >The main things I ran into was little SQL Syntax differences, Stored > > >procedures, and > > >Triggers... > > > > > > > > >mike > > > > Mike, > > Out of curiosity, why did you switch from Interbase to MySQL? > > (I've used both) > > > > Mike > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: building mysql-4.0.1 (libtool question)
Okay, I believe the problem I am having is make is having some problemsis in libmysql.c when the getenv fucntion is used. I commented out the following lines in libmysql.c and then the program errored in the next line with getenv. Anyone have a workaround for this code on HP-UX 11.00? if (!passwd) { passwd=mysql->options.password; #ifndef DONT_USE_MYSQL_PWD if (!passwd) passwd=getenv("MYSQL_PWD"); /* get it from environment (haenke) */ #endif } The next line that then errored was... if ((env = getenv("MYSQL_UNIX_PORT"))) Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 "Help Wanted. Seeking Telepath..." "You Know where to apply." Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Reset Master command ignores max_binlog_size variable
Hi all, Were running replication on our Prod. DB (3.23.42 on SuSE 7.0) since a half year. Our way to rotate the binlog files was to stop all software inserting data into the Prod. DB and then reset the master and the replication server. This works fine but produces a downtime of aprox. 10 minutes every time we rotate the files. In the last week were tryout a new procedure to rotate the binlog files. First we locked all tables for writing, wait until the replication server has executed all outstanding SQL Querys and then reseted the master and the replication server. This produces a downtime of less than 2 minutes only. But after we restarted the replication, the master writes all updates into one binlog file which grows up and up. If the binlog file reached the filesystem limit of 2GB (on ext2) all updates written to the file are lost and the replication stops without any error message. The strange thing is that we set the max_binlog_size variable in the my.cnf file to a limit of 30MB. The variable will be ignored if we use the new procedure to rotate the binlog files but works fine with the old one. The final result now is that the DBs are out of sync and we have to spend a downtime of aprox. 45 minutes to bring the DBs back in sync. Does anybody knows the reason for that problem and have a fix? Is this strange behavior a bug or a goodie? I searched through the mailinglist and the web but could not find any solution yet. Thanx... -- _ __| |_ Andre Stahl Texas Instruments Freising Wafer Fab \_ _) Probe Systems Haggertystrasse 1 85356 Freising-Germany \_( - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Reset Master ignores max_binlog_size variable
Hi all, Were running replication on our Prod. DB (3.23.42 on SuSE 7.0) since a half year. Our way to rotate the binlog files was to stop all software inserting data into the Prod. DB and then reset the master and the replication server. This works fine but produces a downtime of aprox. 10 minutes every time we rotate the files. In the last week were tryout a new procedure to rotate the binlog files. First we locked all tables for writing, wait until the replication server has executed all outstanding SQL Querys and then reseted the master and the replication server. This produces a downtime of less than 2 minutes only. But after we restarted the replication, the master writes all updates into one binlog file which grows up and up. If the binlog file reached the filesystem limit of 2GB (on ext2) all updates written to the file are lost and the replication stops without any error message. The strange thing is that we set the max_binlog_size variable in the my.cnf file to a limit of 30MB. The variable will be ignored if we use the new procedure to rotate the binlog files but works fine with the old one. The final result now is that the DBs are out of sync and we have to spend a downtime of aprox. 45 minutes to bring the DBs back in sync. Does anybody knows the reason for that problem and have a fix? Is this strange behavior a bug or a goodie? I searched through the mailinglist and the web but could not find any solution yet. Thanx... -- _ __| |_ Andre Stahl Texas Instruments Freising Wafer Fab \_ _) Probe Systems Haggertystrasse 1 85356 Freising-Germany \_( - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
make test]
after running "make test" i received 3 errors relating to rpl01, 4, and and 7. This error message is displayed: AT line 6: query 'slave stop' failed: 1199: This operation requires a running slave, configure slave and do SLAVE START At line 6: query 'load data infile '../../std_data/words.dat' into table t1' failed: 1085: The file '../../std_data/words.dat' must be in the database directory or be readable by all real 0.04 user 0.01 sys 0.01 Aborting any suggestions? Amy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Encrypting with PASSWORD() function
of course, the safe way is to always reset the password when such a thing happens. -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 10:48 AM To: [EMAIL PROTECTED] Subject: Re: Encrypting with PASSWORD() function Walter, Tuesday, May 14, 2002, 4:59:15 PM, you wrote: WDF> I am trying Mysql Password() function, to encrypt password in a a WDF> user/password WDF> table, WDF> it works fine both ways; it is to say, when I submit a login WDF> (user/password) WDF> combination it fetches the pair ok. WDF> My question is, as I read in the documentation, that the process is WDF> irreversible, how can I deal with the fact WDF> that a user can forget his password, if I will not be able to retrieve the WDF> original string, because what i can see is the encrypted data WDF> is there a workaround to deal with this, either than storing in a separeted WDF> table the original password string (not encrypted), or shall i simply not WDF> use this function ? What about using another functions for encrypting password and user name, f.e. ENCODE()/DECODE() or DES_ENCRYPT()/DES_DECRYPT()? Look at: http://www.mysql.com/doc/M/i/Miscellaneous_functions.html WDF> thanks in advance to any suggestion WDF> Walter -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
building mysql-4.0.1 (libtool question)
I am trying to build mysql-4.0.1 from the source... When it gets to libtool it is having problems finding gcc... How can I cahnge the path to the full path of the gcc compiler? Thanks, Taylor Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 "Help Wanted. Seeking Telepath..." "You Know where to apply." Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php