libc6 binary same as i686?
I noticed the MySQL Intel 3.23 stable binary has changed its name on the download page from pc-i686 to libc6. Is this just different terminology or is something else different? Helpful souls cautioned me against running the i686 binary on a i586 machine--would this be the same deal? I'm trying to pick the best path, but between this older K62 and the warning about gcc 2.96, I'm having trouble :) (I'll be using a K62 with RH7.1) Thanks in advance, Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Basilix and MySQLhelp
I need a little help getting Basilix to run. The one part I can't get is the db connection. Somehow username and password are placed in the basilix.sql file with the command >mysql -u "username" -p "password" < /usr/local/basilix/db/mysql/basilix.sql This command (I assume) works fine IF both servers are running on the same machine. I, however, run MySQL on a seperate machine. Could someone please help me and tell me how I could modify this command to fit my situation? Thanks, David. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 can I create InnoDB table
Hi All, How can I create InnoDB table. If I tried create a InnoDB Table on my RedHat Linux MySQL 3.23.26 . Can any body give details that how can I create InnoDB table. Thanks in advance, sreedhar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Obtaining GMT time in mySQL
Using Perl: my $GMTdate = gmtime(time); this will give you the GMT time. >>On Tue, 05 Feb 2002 15:27:18 +1100, Oliver Mannion <[EMAIL PROTECTED]> wrote: >>Right. >> >>Perl seems to work with daylight savings, how is this? >> >>At 08:03 PM 4/02/2002 -0800, James Montebello wrote: >>> >>>UTC doesn't do daylight savings. One reason is that different places >>>do daylight savings at different times. We here in the Western US, for >>>example, are in standard time right now. In Arizona, they don't do >>>daylight savings at all. >>> >>>james montebello >>> >>>On Tue, 5 Feb 2002, Oliver Mannion wrote: >>> I am close to a solution: select FROM_UNIXTIME(UNIX_TIMESTAMP(), '%Y %D %M %h:%i:%s %x'); UNIX_TIMESTAMP() returns the number of seconds since '1970-01-01 >>00:00:00' GMT Convert this to a date format and you have a GMT date. Thanks to Chris Land for pointing the UNIX_TIMESTAMP() function out to me. The only prob is daylight savings. We in NSW, Australia are currently in daylight savings and the date returned doesn't accomodate for that. Any one have any ideas why? [mysql] Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Obtaining GMT time in mySQL
Right. Perl seems to work with daylight savings, how is this? At 08:03 PM 4/02/2002 -0800, James Montebello wrote: > >UTC doesn't do daylight savings. One reason is that different places >do daylight savings at different times. We here in the Western US, for >example, are in standard time right now. In Arizona, they don't do >daylight savings at all. > >james montebello > >On Tue, 5 Feb 2002, Oliver Mannion wrote: > >> I am close to a solution: >> >> select FROM_UNIXTIME(UNIX_TIMESTAMP(), >> '%Y %D %M %h:%i:%s %x'); >> >> >> UNIX_TIMESTAMP() returns the number of seconds since '1970-01-01 00:00:00' GMT >> Convert this to a date format and you have a GMT date. >> >> Thanks to Chris Land for pointing the UNIX_TIMESTAMP() function >> out to me. >> >> The only prob is daylight savings. We in NSW, Australia are currently >> in daylight savings and the date returned doesn't accomodate for that. >> Any one have any ideas why? >> >> [mysql] >> >> - >> Before posting, please check: >>http://www.mysql.com/manual.php (the manual) >>http://lists.mysql.com/ (the list archive) >> >> To request this thread, e-mail <[EMAIL PROTECTED]> >> To unsubscribe, e-mail <[EMAIL PROTECTED]> >> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >> > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: OT: *nix text editor?
I ended up using head and tail to split it into 2 files, so that I didn't have to edit it. See, it was the output of a mysqldump from two databases, and I needed to make sure each part went where it needed to go. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Terrence W. Zellers [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 8:35 PM To: Matthew Walker Cc: [EMAIL PROTECTED] Subject: Re: OT: *nix text editor? On Mon, 4 Feb 2002, Matthew Walker wrote: > I need to find a text editor for Linux that doesnt load the whole file > into memory. I need to edit a 1.5 gig text flatfile to add two lines. > But I dont have enough ram to open it in most programs. Can anyone > recommend something? cat? (No not being "wise" --> wc -l currentfile; #tells you number-of-lines vi/emacs newlinesfile; head -number-of-leading-lines currentfile > newfile; cat newlinesfile >> newfile; tail -(number-of-lines - number-of-leading-lines) currentfile >> newfile; ) +--- --+ | Copyright 2001 by Terrence W. Zellers. All rights explicitly reserved. | | email: [EMAIL PROTECTED] www.voicenet.com/~zellert/pub.key | |--- --| | A means of adding pith or humor to email: patent pending | +--- --+ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.317 / Virus Database: 176 - Release Date: 1/21/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.317 / Virus Database: 176 - Release Date: 1/21/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: INSERTing duplicate values to a UNIQUE-indexed table
If you need to update an old record in unique key, try to use REPLACE function. REPLACE could add if there has not existing record and update when it found a same unique key. Sommai, At 19:01 5/2/2002 +, DL Neil wrote: >HelloErik, > > > I have a slight dilemma, and was wondering what the standard workaround > > is. I have three tables: owners (auto_increment primary key is > > "owners_id"), objects (auto_increment primary key is "objects_id"), and > > owners_objects (which is a foreign key table that I created, under > > advice from someone on this list a while back whose email address has > > changed -- there are two columns in owners_objects: "owners_id" and > > "objects_id", and there are two unique indexes on the table, > > "owners_id / objects_id" and "objects_id / owners_id" -- this is to keep > > duplicates combinations in this table, since they would only take up > > extra disk space). > > > > I am designing an application in PHP which stores the relationship > > between an Owner and an Object using the owners_objects table in a > > many-to-many relationship. When someone adds a new owner, they can > > choose from an HTML listbox any number of objects to associate with that > > owner. The PHP code creates an INSERT statement that inserts the data > > into "owners", and then takes the auto_incremented primary key of the > > last insert (which is the insert into "owners") and uses that as the > > value for the second INSERT statemetn: to insert into > > "owners_objects.owner_id". In this second INSERT statement, the > > "objects_id" of the Object(s) selected from the listbox go into the > > second column of "owners_objects". > > > > I am sure that many people have done this sort of setup. But what do > > you do to get around the problem of INSERTing a pair of values that > > already exist? Because the combinations in "owners_objects" are UNIQUE > > (the UNIQUE indexes), MySQL won't accept a pair that is already > > present. I see two possible options: > > > > 1) Check to see if the combination is already present, and if so, do not > > run the INSERT query > > 2) run the INSERT query regardless and suppress the error message > > > > The disadvantage of the first one is that it adds an extra SQL query to > > the process. The disadvantage of the second one is that I think it is > > somewhat tasteless to execute code that will knowingly error -- or > > should I just stop trying to be such a perfectionist? > > > > I would post code but this is all pseudocode right now b/c I haven't > > solved this dilemma yet -- all experimentation with this has been done > > from the mysql client. > >=option 2: whilst native-MySQL will give an errmsg in response to an >attempt to INSERT duplicates, PHP doesn't >have to pay attention! Check out MySQL_affected_rows(). > >=dn > > > >- >Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Crash bug
On Monday 04 February 2002 07:33 pm, [EMAIL PROTECTED] wrote:
> Version: 4.0.1 binary distro(I have gcc 2.96, so I'm using your prebuilt
one)
> Synopsis: Upon executing a query using the MATCH() clause with FULLTEXT
indicies,
> it will crash the mysqld daemon.
Thanks for the bug report. I am forwarding this to Sergei, our developer
responsbile for full-text.
>
> The query that does this is a "multi table" query, as such..
>
> MATCH(table1.col1, table2.col2) AGAINST ('foo')
>
> This will happen with or without the IN BOOLEAN MODE clause.
> mysqld_safe will crash, and restart.
> I understand that cross-table MATCHes are a limitation of FULLTEXT
searches, which
> is referenced in the manual if the "IN BOOLEAN MODE" is left out. However,
it
> will blow either way.
>
> Using single table queries with/without the IN BOOLEAN MODE clause work
fine, the
> problem only seems to appear when doing multi-table MATCHes.
>
> It (the database) was previously 3.23 and all I've done was replace the
binaries. "normal"
> queries work okay thus far, but I've only had it a couple of hours.
>
> Hope the logs help. email me if I can be of more use.
> This appears fairly easy to reproduce, but if you REALLY want a testcase,
let me know
> and I'll post one to [EMAIL PROTECTED]
>
> -Mike
> [EMAIL PROTECTED]
>
>
>
-
> 0x807db7f handle_segfault__Fi + 383
> 0x823d64a pthread_sighandler + 154
> 0x8053a24 val__15Item_func_match + 72
> 0x80555bc val_str__14Item_real_funcP6String + 20
> 0x804a979 send__4ItemP3THDP6String + 73
> 0x8075afe send_data__11select_sendRt4List1Z4Item + 98
> 0x80a6e5c end_send__FP4JOINP13st_join_tableb + 112
> 0x80a6337 do_select__FP4JOINPt4List1Z4ItemP8st_tableP9Procedure + 327
> 0x809f5e4
mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4P4ItemT4UlP13select_result
+ 6548
> 0x80ac1c0 handle_select__FP3THDP6st_lexP13select_result + 96
> 0x8085b4b mysql_execute_command__Fv + 959
> 0x808a262 mysql_parse__FP3THDPcUi + 270
> 0x8084e57 dispatch_command__F19enum_server_commandP3THDPcUi + 1319
> 0x808a694 do_command__FP3THD + 88
> 0x8084296 handle_one_connection__FPv + 546
>
-
> [root@dev init.d]# my
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 1 to server version: 4.0.1-alpha
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> SELECT (MATCH(Merchants.MerchantName, ContactInfos.Address) AGAINST
('ferguson' IN BOOLEAN MODE)) AS RANKING
> -> FROM Merchants,ContactInfos, MerchantLocations
> -> WHERE MerchantLocations.LocationID = 20083 AND
> ->Merchants.MerchantID = MerchantLocations.MerchantID AND
> ->ContactInfos.ContactInfoID = MerchantLocations.LocationID AND
> ->(MATCH(Merchants.MerchantName, ContactInfos.Address) AGAINST
('ferguson' IN BOOLEAN MODE))
> -> ORDER BY Ranking DESC
> -> ;
> ERROR 2013: Lost connection to MySQL server during query
> mysql>
> Number of processes running now: 0
> 020204 18:26:21 mysqld restarted
>
> mysql> quit
>
-
> 020204 18:26:01 mysqld started
> 020204 18:26:01 InnoDB: Started
> /usr/local/mysql/bin/mysqld: ready for connections
> 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 against is corrupt, improperly built,
> or misconfigured. This error can also be caused by malfunctioning hardware.
> We will try our best to scrape up some info that will hopefully help
diagnose
> the problem, but since we have already crashed, something is definitely
wrong
> and this may fail.
>
> key_buffer_size=8388600
> record_buffer=131072
> sort_buffer=2097144
> max_used_connections=0
> max_connections=100
> threads_connected=1
> It is possible that mysqld could use up to
> key_buffer_size + (record_buffer + sort_buffer)*max_connections = 225791 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:
> 0x807db7f
> 0x823d64a
> 0x8053a24
> 0x80555bc
> 0x804a979
> 0x8075afe
> 0x80a6e5c
> 0x80a6337
> 0x809f5e4
> 0x80ac1c0
> 0x8085b4b
> 0x808a262
> 0x8084e57
> 0x808a694
> 0x8084296
> Stack trace seems successful - bottom reached
> Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow
instructions on how to resolve the stack trace. Resolved
> stack trace is
RE: Obtaining GMT time in mySQL
UTC doesn't do daylight savings. One reason is that different places do daylight savings at different times. We here in the Western US, for example, are in standard time right now. In Arizona, they don't do daylight savings at all. james montebello On Tue, 5 Feb 2002, Oliver Mannion wrote: > I am close to a solution: > > select FROM_UNIXTIME(UNIX_TIMESTAMP(), > '%Y %D %M %h:%i:%s %x'); > > > UNIX_TIMESTAMP() returns the number of seconds since '1970-01-01 00:00:00' GMT > Convert this to a date format and you have a GMT date. > > Thanks to Chris Land for pointing the UNIX_TIMESTAMP() function > out to me. > > The only prob is daylight savings. We in NSW, Australia are currently > in daylight savings and the date returned doesn't accomodate for that. > Any one have any ideas why? > > [mysql] > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Obtaining GMT time in mySQL
I am close to a solution: select FROM_UNIXTIME(UNIX_TIMESTAMP(), '%Y %D %M %h:%i:%s %x'); UNIX_TIMESTAMP() returns the number of seconds since '1970-01-01 00:00:00' GMT Convert this to a date format and you have a GMT date. Thanks to Chris Land for pointing the UNIX_TIMESTAMP() function out to me. The only prob is daylight savings. We in NSW, Australia are currently in daylight savings and the date returned doesn't accomodate for that. Any one have any ideas why? [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: update failing when statement includes "\"
Hi Kinney, On Mon, 2002-02-04 at 12:06, Kinney Baughman wrote: > Hi, > > I'm playing with PHP/MySQL for the first time having used Perl and MySQL > for years. > > In one of my first update scripts, PHP is automatically escaping quotes and > such, which I assumed was a good thing. PHP has a group of configuration settings that control if this behavior is invoked automatically. See http://php.net/configuration. The directives that control this are all named /magic_quotes_\w+/ > However, I'm noticing that MySQL is rejecting statements like: > > Update faqs SET subject='Adding FAQ\'s' WHERE id=110 ; > > It also rejects: > > Update faqs SET subject="Adding FAQ\'s" WHERE id=110 ; By reject, do you mean that the call to mysql_query() returns FALSE or that the query does not affect the table? > I've tested these out on the MySql command line and find the same thing. > > Rows matched: 1 Changed: 0 Warnings: 0 > > It finds the row but doesn't make the change If the UPDATE query does not need to modify the fields referenced, it will have this result. Change the value for subject to a different value - your query should change the row the first time the query is run, but not the second and subsequent times. > Anyone have a suggestion for what I need to do to get the record updated? > I don't find anything in the archives or the manual that addresses this > problem. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Zak Greant <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB /_/ /_/\_, /___/\___\_\___/ Calgary, Canada <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: BLOB Help Please (Loading into table)
At 0:35 + 2/5/02, David Ayliffe wrote: >Hello, > >Thanks for your time. I'm having some problems loading images into a >table. I'm using the statement: > >INSERT INTO BLOBTEST set b1=load_file<'c:\1.jpg'); You'll probably need to double the '\' character. Or perhaps use a '/' instead. (That's what you have to do for Windows filenames with LOAD DATA, and the same rules may apply here, too.) > >The table (blobtest) is made up of 2 columns : id1 (auto counter) and b1 >(BLOB) > >When I try and run this statement (above) I get a record inserted with a >value for the counter, but for the binary file - I get the value NULL. > >I have checked Pauls' book and it states about the load_file that NULL >will be returned if: > >* the file doesn't exist on the server (it does - at c:\) >* is not world-readable (I'm running xp so no unix ACL's but I'm running >with admin rights) >* user must have FILE privilages in mysql (I've dropped my old user and >created a new one with "grant all on test.* to orange@'%' identified by >'orange';") > > >Any ideas why this is not working? - I just need to load an image to >test things. > >ALSO can images be loaded without using the set statement? - IMPORTANT > >Thank you. > > >Thanks lots >David Ayliffe > >ICQ# 125646758 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
OT: *nix text editor?
I need to find a text editor for Linux that doesnt load the whole file into memory. I need to edit a 1.5 gig text flatfile to add two lines. But I dont have enough ram to open it in most programs. Can anyone recommend something? Filter: sql,query Matthew Walker Ecommerce Project Manager Mountain Top Herbs --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.317 / Virus Database: 176 - Release Date: 1/21/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 index Optimization on 20 million record
many thanks brothers Now, my query fastest again with limit 1, because query count(*) just result 1 row =-hery-= - Original Message - From: "BD" <[EMAIL PROTECTED]> To: "Hery Yulianto" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, February 04, 2002 10:34 PM Subject: Re: How to index Optimization on 20 million record > Hery, > You need to get some idea of how many records are being counted. > What I suggest is to put a Limit on your select statement and gradually > increase it. > > For example > select count(*) from TABLE_1 where FIELD_1 = "XXX_CC" limit 10; > > If this takes too long, then you know right away there is something wrong > with the index. > If it is fast enough, then increase it to "Limit 1000" and test the time. > Then bump it up to 5000, 1 etc. until you get an idea of how many rows > it is trying to count. Perhaps it there are 1 million rows with FIELD_1 = > "XXX_CC"? > > Brent > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help with MySQL: Bind on unix socket error
I'm hoping I can get some help here, I'm trying to get MySQL running on YellowDog Linux 2.4.17 kernel. I've installed the mysql, mysql-server and mysql-devel-3.23.32-1.7a rpms from my install CD. Ran mysql_install_db then changed the group and owner on /var/lib/mysql to root. This is what shows up in my mysqld.log after trying to run mysql_safed 020204 16:19:56 mysqld started 020204 16:19:56 Can't start server: Bind on unix socket: Permission denied 020204 16:19:56 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock? 020204 16:19:56 Aborting 020204 16:19:56 mysqld ended There is no mysql.sock on the machine nor is there a mysqld server running. Any Ideas? Thanks Joe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Crash bug
Version: 4.0.1 binary distro(I have gcc 2.96, so I'm using your prebuilt one)
Synopsis: Upon executing a query using the MATCH() clause with FULLTEXT indicies,
it will crash the mysqld daemon.
The query that does this is a "multi table" query, as such..
MATCH(table1.col1, table2.col2) AGAINST ('foo')
This will happen with or without the IN BOOLEAN MODE clause.
mysqld_safe will crash, and restart.
I understand that cross-table MATCHes are a limitation of FULLTEXT searches, which
is referenced in the manual if the "IN BOOLEAN MODE" is left out. However, it
will blow either way.
Using single table queries with/without the IN BOOLEAN MODE clause work fine, the
problem only seems to appear when doing multi-table MATCHes.
It (the database) was previously 3.23 and all I've done was replace the binaries.
"normal"
queries work okay thus far, but I've only had it a couple of hours.
Hope the logs help. email me if I can be of more use.
This appears fairly easy to reproduce, but if you REALLY want a testcase, let me know
and I'll post one to [EMAIL PROTECTED]
-Mike
[EMAIL PROTECTED]
-
0x807db7f handle_segfault__Fi + 383
0x823d64a pthread_sighandler + 154
0x8053a24 val__15Item_func_match + 72
0x80555bc val_str__14Item_real_funcP6String + 20
0x804a979 send__4ItemP3THDP6String + 73
0x8075afe send_data__11select_sendRt4List1Z4Item + 98
0x80a6e5c end_send__FP4JOINP13st_join_tableb + 112
0x80a6337 do_select__FP4JOINPt4List1Z4ItemP8st_tableP9Procedure + 327
0x809f5e4
mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4P4ItemT4UlP13select_result
+ 6548
0x80ac1c0 handle_select__FP3THDP6st_lexP13select_result + 96
0x8085b4b mysql_execute_command__Fv + 959
0x808a262 mysql_parse__FP3THDPcUi + 270
0x8084e57 dispatch_command__F19enum_server_commandP3THDPcUi + 1319
0x808a694 do_command__FP3THD + 88
0x8084296 handle_one_connection__FPv + 546
-
[root@dev init.d]# my
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.1-alpha
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> SELECT (MATCH(Merchants.MerchantName, ContactInfos.Address) AGAINST ('ferguson'
IN BOOLEAN MODE)) AS RANKING
-> FROM Merchants,ContactInfos, MerchantLocations
-> WHERE MerchantLocations.LocationID = 20083 AND
->Merchants.MerchantID = MerchantLocations.MerchantID AND
->ContactInfos.ContactInfoID = MerchantLocations.LocationID AND
->(MATCH(Merchants.MerchantName, ContactInfos.Address) AGAINST ('ferguson'
IN BOOLEAN MODE))
-> ORDER BY Ranking DESC
-> ;
ERROR 2013: Lost connection to MySQL server during query
mysql>
Number of processes running now: 0
020204 18:26:21 mysqld restarted
mysql> quit
-
020204 18:26:01 mysqld started
020204 18:26:01 InnoDB: Started
/usr/local/mysql/bin/mysqld: ready for connections
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 against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.
key_buffer_size=8388600
record_buffer=131072
sort_buffer=2097144
max_used_connections=0
max_connections=100
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (record_buffer + sort_buffer)*max_connections = 225791 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:
0x807db7f
0x823d64a
0x8053a24
0x80555bc
0x804a979
0x8075afe
0x80a6e5c
0x80a6337
0x809f5e4
0x80ac1c0
0x8085b4b
0x808a262
0x8084e57
0x808a694
0x8084296
Stack trace seems successful - bottom reached
Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow
instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x841c478 = SELECT (MATCH(Merchants.MerchantName, ContactInfos.Address)
AGAINST ('ferguson' IN BOOLEAN MODE)) AS
RANKING
FROM Merchants,ContactInfos, MerchantLocations
WHERE MerchantLocations.LocationID = 20083 AND
Merch
Tweaking MySQL on a RaQ
Hi all, A couple of weeks back you may remember that I was asking about setting up a new client on our server that ran around 35GB in bandwidth per month mostly from MySQL queries. Well, we have put them on our server and have good and bad news. The good news is that they are now pulling around 45GB in bandwidth per month. Overall the performance is acceptable and the machine is happy. Now, the bad news, which is why I am emailing the list for I am out of ideas. During peak assaults on our server, which is noon eastern time and noon pacific time, or there-abouts, our server does not do so well. Apart from getting CPU warning from the server about high load averages going up to 15 for a 15 minute period, we also had the sendmail server shutdown for a couple of minutes from lack of resources. A few specs: MySQL extended-status shows some of the following | Aborted_clients | 1315 | | Aborted_connects | 20 | | Bytes_received | 568116057 | | Bytes_sent | 113998812 | <---this should be several Gig by now, is there a rollover? | Connections | 166586 | | Created_tmp_disk_tables | 25944 | | Created_tmp_tables | 96834 | | Created_tmp_files| 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delayed_errors | 0 | | Flush_commands | 1 | | Handler_delete | 37034 | | Handler_read_first | 360285 | | Handler_read_key | 17394405 | | Handler_read_next| 28441290 | | Handler_read_prev| 4808 | | Handler_read_rnd | 21530499 | | Handler_read_rnd_next| 1185471281 | | Handler_update | 690269 | | Handler_write| 1808922| | Key_blocks_used | 46376 | | Key_read_requests| 81926178 | | Key_reads| 17962 | | Key_write_requests | 712426 | | Key_writes | 234236 | | Max_used_connections | 49 | | Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 | | Open_tables | 256| | Open_files | 420| | Open_streams | 0 | | Opened_tables| 5745 | | Questions| 5080399| | Select_full_join | 102| | Select_full_range_join | 1 | | Select_range | 370613 | | Select_range_check | 0 | | Select_scan | 952200 | | Slave_running| OFF| | Slave_open_temp_tables | 0 | | Slow_launch_threads | 84 | <---This is not good is it? | Slow_queries | 0 | | Sort_merge_passes| 0 | | Sort_range | 381972 | | Sort_rows| 36789069 | | Sort_scan| 659404 | | Table_locks_immediate| 4181394| | Table_locks_waited | 2958 | | Threads_cached | 7 | | Threads_created | 1678 | | Threads_connected| 1 | | Threads_running | 1 | | Uptime | 1141490| +--++ I have basically used the large-my.cnf configuration with modifications to allow up to 150 simultanous connections. Though I am wondering what else I can modify, or perhaps I should not have use that configuration. System specs: Cobalt RaQ4i 450MHz 512MB of RAM <--Which is why I am thinking that large-my.cnf is too big Apache, PHP and MySQL Application is GeekLog 1.2.5 which albeit is not very efficient in its queries. Hmm, I think I have included most of my information. Now, can anyone give some suggestions on how to enhance MySQL? The other processes are definitely not causing the problems. From random 'top' viewings, I see that I have on average 5-10 mysqld running around 50-75% CPU usage (total) and about 56MB of RAM each. Here is a typical view of the top of my 'top', so to speak: 8754 mysql 11 0 62456 60M 1684 R 0 23.3 12.0 0:09 mysqld 8453 mysql 19 0 62456 60M 1684 R 0 18.3 12.0 0:35 mysqld 7618 mysql 10 0 62456 60M 1684 R 0 6.7 12.0 1:32 mysqld 7619 mysql 12 0 62456 60M 1684 R 0 6.3 12.0 1:25 mysqld 8299 mysql 1 0 62456 60M 1684 S 0 4.3 12.0 0:42 mysqld 8298 mysql 0 0 62456 60M 1684 S 0 4.1 12.0 0:29 mysqld 12991 httpd 2 0 15284 14M 11680 S 0 2.7 2.8 1:14 httpd 12987 httpd 0 0 15544 14M 11660 S 0 2.0 2.9 1:14 httpd 7833 mysql 0 0 62456 60M 1684 S 0 1.8 12.0 1:17 mysqld 12853 httpd 0 0 14780 14M 11624 S 0 1.6 2.7 1:20 httpd 13042 httpd 0 0 14804 14M 11672 S 0 1.6 2.7 1:20 httpd 12665 httpd 0 0 14716 14M 11668 S 0 1.5
Re: Obtaining GMT time in mySQL
You *could* use UNIX_TIMESTAMP(NOW()), which will return an integer timestamp from the server in standard Unix time, which is the number of seconds since 00h00 1 Jan 1970 UTC. However, there is no easy way to get this to display in -MM-DD HH:MM:SS format w/o the conversion to local time taking place. I also have no idea if this will work correctly on a non-Unix platform, as I've never used MySQL on anything but Linux and Solaris. Setting the TZ variable on the server will the right thing, but all times on the box will be in UTC, not just some of them, which is probably not what you want. james montebello On Tue, 5 Feb 2002, Oliver Mannion wrote: > Hi dn, > > Right. Having said that tho, is there a function > in mysql that will return the GMT time from the operating > system, that I can subsequently use in a query. > I could use the GMT time from the db client but I > would prefer to use the GMT time from the operating > system mySQL is running on. > > Thanks > Oliver > > At 12:35 AM 5/02/2002 +, DL Neil wrote: > >Hi Oliver, > > > >> I would like to obtain the time in GMT in mySQL. > >> > >> CURRENT_TIMESTAMP returns the local time > >> SHOW VARIABLES returns a list of variables, one being TZ which is "EST" on > >> my system > >> > >> But how can I get the time in GMT??? > > > > > >MySQL is time-neutral, that is to say, if you ask it the time, it will ask > the server OpSys. > > > >As my mother used to say, "you only get out of something, what you put > into it"! If you declare a date/time > >column, any data you INSERT will have the same value when you subsequently > SELECT it. It's up to you to > >determine which time zone to use when representing your data. > > > >Are you accessing MySQL from some other facility, eg PHP? Can you use that > tool to acquire/restate the temporal > >data? > > > >Regards, > >=dn > > > > > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Speed difference
The boxes running the MySQL were isolated from other users so there was no activity on them while I was performing the benchmark tests. There was no tuning - I just installed the MySQL from their binary packages, that is I was using the default config files (hoping that they are the same - I will check that now). One of the tests was done locally on the Solaris box (Ultra 5) giving almost the same result - around 1 min 25 secs. Just a small improvement over the TCP/IP connection. I suppose that the next step is to get the config file to something that will give me better performance on the Solaris box, but as I said there was nothing changed in the configuration of the MySQL. I just used the default configuration setup. _ Nesh, > With all of the benchmark test I have used the same DB structure, > same TABLE structure, and finally same iterations. > > This probably means that Solaris I/O is really poor, or there is some > other explanation (like changing some kernel parameters to get Solaris > working well with DB kind of stuff). > > At the moment I am trying to find out exactly what is the problem. It > should not be MySQL itself because the first 2 boxes have different > results from the last 2 boxes. This leads me to the conclusion that > Solaris is doing something weird with the I/O. Unfortunately, I do not > have Solaris 8 to test MySQL in that environment. > > Note that all the boxes are running the same MySQL version so that > could not be the problem (3.23.47). Interesting statistics! What else were the m/user, m/tasking OpSys doing at the time? How much 'tuning' of the configs/dbs had taken place in each case? Can you compare the results without the 'I/O', by using native-MySQL on each server, locally? Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Speed difference
Nesh, > With all of the benchmark test I have used the same DB structure, same > TABLE structure, and finally same iterations. > > This probably means that Solaris I/O is really poor, or there is some other > explanation (like changing some kernel parameters to get Solaris working > well with DB kind of stuff). > > At the moment I am trying to find out exactly what is the problem. It > should not be MySQL itself because the first 2 boxes have different results > from the last 2 boxes. This leads me to the conclusion that Solaris is doing > something weird with the I/O. Unfortunately, I do not have Solaris 8 to test > MySQL in that environment. > > Note that all the boxes are running the same MySQL version so that could > not be the problem (3.23.47). Interesting statistics! What else were the m/user, m/tasking OpSys doing at the time? How much 'tuning' of the configs/dbs had taken place in each case? Can you compare the results without the 'I/O', by using native-MySQL on each server, locally? Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
2 (Easy?) Timezone (TZ) Questions
Hi folks - I am having 2 related problems with the timezone setting for mysqld & was hoping to get some help. Basically my squestions are as follows: a) the documentation says to set timezone by simply using --timezone=# when starting mysqld - but WHAT are the valid number values & which time zones do the map to? b) I have tried to set the timezone using "safe_mysqld --timezone=XX" where I have tried various values for XX such as o1, 1, 13, 05,08 BUT near as I can tell ANY value I put in gives me GMT/UTC time (I think that's what it is) rather than giving me time offset by the given amount i entered. This is not what the documentation seems to suggest will happen - or am I being obtuse? Any help or suggestions would be appreciated. 'deep -- Amandeep Jawa Worker Bee Software -- deep AT worker DASH bee DOT com 225A Dolores St. San Francisco, CA 94103-2202 Home: 415 255 6257 (ALL MALP) professional: http://www.worker-bee.com personal: http://www.deeptrouble.com political: http://www.sflcv.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: Obtaining GMT time in mySQL
Hi dn, Right. Having said that tho, is there a function in mysql that will return the GMT time from the operating system, that I can subsequently use in a query. I could use the GMT time from the db client but I would prefer to use the GMT time from the operating system mySQL is running on. Thanks Oliver At 12:35 AM 5/02/2002 +, DL Neil wrote: >Hi Oliver, > >> I would like to obtain the time in GMT in mySQL. >> >> CURRENT_TIMESTAMP returns the local time >> SHOW VARIABLES returns a list of variables, one being TZ which is "EST" on >> my system >> >> But how can I get the time in GMT??? > > >MySQL is time-neutral, that is to say, if you ask it the time, it will ask the server OpSys. > >As my mother used to say, "you only get out of something, what you put into it"! If you declare a date/time >column, any data you INSERT will have the same value when you subsequently SELECT it. It's up to you to >determine which time zone to use when representing your data. > >Are you accessing MySQL from some other facility, eg PHP? Can you use that tool to acquire/restate the temporal >data? > >Regards, >=dn > > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Obtaining GMT time in mySQL
Hmmm - pardon me for jumping in in a conversation in progress - but according to the manual* you should be able to set the TZ variable to your timezone - which sounds like what has happened on your machine. If you can figure out how to put the right code in, your SQL queries will purportedly be in GMT. I would try safe_mysqld --timezone=0 Or safe_mysqld --timezone=GMT I'm trying to figure out something similar (see my post below) - so let me know if you find anything 'deep *http://www.mysql.com/doc/s/a/safe_mysqld.html & http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html -my post Hi folks - I am having 2 related problems with the timezone setting for mysqld & was hoping to get some help. Basically my squestions are as follows: a) the documentation says to set timezone by simply using --timezone=# when starting mysqld - but WHAT are the valid number values & which time zones do the map to? b) I have tried to set the timezone using "safe_mysqld --timezone=XX" where I have tried various values for XX such as o1, 1, 13, 05,08 BUT near as I can tell ANY value I put in gives me GMT/UTC time (I think that's what it is) rather than giving me time offset by the given amount i entered. This is not what the documentation seems to suggest will happen - or am I being obtuse? Any help or suggestions would be appreciated. -- Amandeep Jawa Worker Bee Software -- [EMAIL PROTECTED] 225A Dolores St. San Francisco, CA 94103-2202 Home: 415 255 6257 (ALL MALP) professional: http://www.worker-bee.com personal: http://www.deeptrouble.com political: http://www.sflcv.org > From: "DL Neil" <[EMAIL PROTECTED]> > Reply-To: "DL Neil" <[EMAIL PROTECTED]> > Date: Tue, 5 Feb 2002 00:35:28 - > To: <[EMAIL PROTECTED]>, "Oliver Mannion" <[EMAIL PROTECTED]> > Subject: Re: Obtaining GMT time in mySQL > > Hi Oliver, > >> I would like to obtain the time in GMT in mySQL. >> >> CURRENT_TIMESTAMP returns the local time >> SHOW VARIABLES returns a list of variables, one being TZ which is "EST" on >> my system >> >> But how can I get the time in GMT??? > > > MySQL is time-neutral, that is to say, if you ask it the time, it will ask the > server OpSys. > > As my mother used to say, "you only get out of something, what you put into > it"! If you declare a date/time > column, any data you INSERT will have the same value when you subsequently > SELECT it. It's up to you to > determine which time zone to use when representing your data. > > Are you accessing MySQL from some other facility, eg PHP? Can you use that > tool to acquire/restate the temporal > data? > > Regards, > =dn > > > > - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Speed difference
With all of the benchmark test I have used the same DB structure, same TABLE structure, and finally same iterations. This probably means that Solaris I/O is really poor, or there is some other explanation (like changing some kernel parameters to get Solaris working well with DB kind of stuff). At the moment I am trying to find out exactly what is the problem. It should not be MySQL itself because the first 2 boxes have different results from the last 2 boxes. This leads me to the conclusion that Solaris is doing something weird with the I/O. Unfortunately, I do not have Solaris 8 to test MySQL in that environment. Note that all the boxes are running the same MySQL version so that could not be the problem (3.23.47). Regards, Nesh Nenad Mijailovic Software Engineer IVSTEL Telecommunications Solutions _ -Original Message- From: Sherzod Ruzmetov aka sherzodR [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 5 February 2002 11:14 AM To: Nesh Nenad Mijailovic Cc: '[EMAIL PROTECTED]' Subject: Re: Speed difference : after timing the program that was targeting MySQL on different platforms : the results are (client program running always from the same box that is not : hosting MySQL): : : Windows NT - 25 sec (Intel P-III) : Linux - 27 sec (Intel P-III) : Solaris 2.7 - 1 min 40 sec (Ultra 5) : Solaris 2.7 - 1 min 32 sec (Ultra 10) : : Is there a reasonable explanation why is this happening. : Well, even though you run the same benchmark on the same machine several times, you'll get different results. So we also need to know if adequate iterations have been performed. So the time difference in the first two results aren't that much different at all. The same conclusion is true about the last two, But the slowness of Solaris boxes does impress me. So I believe (i'm not a solaris dude) Ultra is the processor, right? Then we could conclude that pentiums are much more faster then Ultras. Do you aggree? -- Sherzod Ruzmetov <[EMAIL PROTECTED]> http://www.UltraCgis.com, Consultant 989.774.6265 010010100101010101001100 ++ | There is nothing wrong with your tools.| | But we can make a better one. | ++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Obtaining GMT time in mySQL
Hi Oliver, > I would like to obtain the time in GMT in mySQL. > > CURRENT_TIMESTAMP returns the local time > SHOW VARIABLES returns a list of variables, one being TZ which is "EST" on > my system > > But how can I get the time in GMT??? MySQL is time-neutral, that is to say, if you ask it the time, it will ask the server OpSys. As my mother used to say, "you only get out of something, what you put into it"! If you declare a date/time column, any data you INSERT will have the same value when you subsequently SELECT it. It's up to you to determine which time zone to use when representing your data. Are you accessing MySQL from some other facility, eg PHP? Can you use that tool to acquire/restate the temporal data? Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
BLOB Help Please (Loading into table)
Hello, Thanks for your time. I'm having some problems loading images into a table. I'm using the statement: INSERT INTO BLOBTEST set b1=load_file<'c:\1.jpg'); The table (blobtest) is made up of 2 columns : id1 (auto counter) and b1 (BLOB) When I try and run this statement (above) I get a record inserted with a value for the counter, but for the binary file - I get the value NULL. I have checked Pauls' book and it states about the load_file that NULL will be returned if: * the file doesn't exist on the server (it does - at c:\) * is not world-readable (I'm running xp so no unix ACL's but I'm running with admin rights) * user must have FILE privilages in mysql (I've dropped my old user and created a new one with "grant all on test.* to orange@'%' identified by 'orange';") Any ideas why this is not working? - I just need to load an image to test things. ALSO can images be loaded without using the set statement? - IMPORTANT Thank you. Thanks lots David Ayliffe ICQ# 125646758 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: CAST fails
* Christopher Bell
> Hello everyone, Im running MySQL version 11.15 Distribution 3.23.47 on
> Windows 2000. I'm having issues with the CAST command, for example, if
> I execute:
>
> CREATE TABLE new_table SELECT CAST('2000-01-01' AS DATE);
>
> I receive the error:
>
> ERROR 1064: You have an error in your SQL syntax near '('2000-01-01' AS
> DATE)' at line 1
CAST() is a brand new function in mysql, according to http://www.mysql.com/doc/C/a/Cast_Functions.html > it was added in MySQL
4.0.2.
--
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: Speed difference
: after timing the program that was targeting MySQL on different platforms : the results are (client program running always from the same box that is not : hosting MySQL): : : Windows NT - 25 sec (Intel P-III) : Linux - 27 sec (Intel P-III) : Solaris 2.7 - 1 min 40 sec (Ultra 5) : Solaris 2.7 - 1 min 32 sec (Ultra 10) : : Is there a reasonable explanation why is this happening. : Well, even though you run the same benchmark on the same machine several times, you'll get different results. So we also need to know if adequate iterations have been performed. So the time difference in the first two results aren't that much different at all. The same conclusion is true about the last two, But the slowness of Solaris boxes does impress me. So I believe (i'm not a solaris dude) Ultra is the processor, right? Then we could conclude that pentiums are much more faster then Ultras. Do you aggree? -- Sherzod Ruzmetov <[EMAIL PROTECTED]> http://www.UltraCgis.com, Consultant 989.774.6265 010010100101010101001100 ++ | There is nothing wrong with your tools.| | But we can make a better one. | ++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqladmin password
From
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
inistration.html#Default_privileges
The MySQL root user is created as a superuser who can do anything.
Connections must be made from the local host. Note: The initial root
password is empty, so anyone can connect as root without a password and be
granted all privileges.
From
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
inistration.html#Passwords
when you store a non-empty password using INSERT or UPDATE statements, you
must use the PASSWORD() function to encrypt it. This is because the user
table stores passwords in encrypted form, not as plaintext. If you forget
that fact, you are likely to attempt to set passwords like this:
shell> mysql -u root mysql
mysql> INSERT INTO user (Host,User,Password)
VALUES('%','jeffrey','biscuit');
mysql> FLUSH PRIVILEGES;
- Original Message -
From: "Oladejo, Tokunboh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 05, 2002 07:06
Subject: mysqladmin password
> Hi All,
>
> Does anyone knows how to change my mysqladmin password or how to find out
> what the password it, I installed the rpm package, didn't setup any
> password, however when I setup a tool to use it with, the tool is asking
me
> to produce the mysqladmin password.
>
>
> Thanx
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> 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!?
Get your free @yahoo.com address at http://mail.yahoo.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Obtaining GMT time in mySQL
Hi, I would like to obtain the time in GMT in mySQL. CURRENT_TIMESTAMP returns the local time SHOW VARIABLES returns a list of variables, one being TZ which is "EST" on my system But how can I get the time in GMT??? Thanks for your time, Oliver - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: performance help required. (2G -> 4G Ram upgrade)
Hi, Your problem is that your query uses all of the rows in the table. That means that the indexes on the table are incorrect. You should try putting a single index on prev_e3_id and a single index on the other table. It'll probably improve your performance a lot. BTW. Schedule some time for maintenance periodically to optimize these heavy tables. Regards, Almar van Pel -Oorspronkelijk bericht- Van: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 5 februari 2002 0:04 Aan: Robin Keech CC: '[EMAIL PROTECTED]' Onderwerp: Re: performance help required. (2G -> 4G Ram upgrade) On Mon, Feb 04, 2002 at 05:41:46PM -, Robin Keech wrote: > (Please reply directly, I am only on the digest list, thanks) > > I have an SQL statement that is taking far too long to run, around > 11 minutes (while locking inserts/updates). > > We have installed some more RAM, and I need help with my.cnf and the > troublesome SQL. > > Can anyone suggest some config values to best utilise the extra RAM > I have just fitted? We have gone from 2G to 4G On what operating system? > The table in question is very large, > ie > e3_id_chain.MYD = 3.7G ~ 53 million records > e3_id_chain.MYI = 3.2G > > These are my current settings > > # The MySQL server > [mysqld] > port= 3306 > socket = /tmp/mysql.sock > skip-locking > set-variable= key_buffer=512M > set-variable= max_allowed_packet=2M > set-variable= max_connections=500 > set-variable= table_cache=512 > set-variable= sort_buffer=2M > set-variable= record_buffer=2M > set-variable= thread_cache=8 > set-variable= wait_timeout=1800 > # Try number of CPU's*2 for thread_concurrency > set-variable= thread_concurrency=4 > set-variable= myisam_sort_buffer_size=64M > log-bin > low-priority-update > > When doing an SQL select it takes 11 minutes > > mysql> explain SELECT e3_id, prev_e3_id, log_id FROM e3_id_chain WHERE > prev_e3_id IS NOT NULL AND log_id IS NOT NULL; > +-+--+---+--+-+--+-- > ++ > | table | type | possible_keys | key | key_len | ref | > rows | Extra | > +-+--+---+--+-+--+-- > ++ > | e3_id_chain | ALL | prev_e3_id_idx,log_id_idx | NULL |NULL | NULL | > 58179805 | where used | > +-+--+---+--+-+--+-- > ++ > 1 row in set (0.00 sec) > > But its not using the index??? Correct. And that key_buffer won't help much. How many of the rows actually match your query? > Can anyone explain this behaviour, and suggest a solution? MySQL will decide not to use an index in cases when it believes there is a faster way, such as a full table scan. This is often the case when a significant percentage of the rows are likely to match. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 0 days, processed 22,771,714 queries (385/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sysctl & process limitations
On Mon, 4 Feb 2002, Manuel Bouyer wrote: > What a minute ... you're loading the tables to a 'mysqld' process, using > the 'mysql' command, rigth ? > Maybe it's just the mysql command which runs out of files descriptors ? > Did you try to raise the limit of the shell before starting it ? Right. Like this: mysql -u someuser -p -D somedatabase < ./data.sql No. I didn't raise the shell limits, I rose the kernel maxfiles and the mysqld process proc.pid.rlimit.descriptors.soft limit. I'll try the shell tonight. -- Cheers! Randy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Database connections
>From time to time I seem to see error messages in my database.err log file
for MySQL.
020130 11:19:10 Aborted connection 40437 to db: 'xyz' user: 'abc' host:
`localhost' (Got an error reading communication packets)
I've been reading about the Morning Bug and here's what I extracted about it:
The error was caused by Apache::DBI returning a handle of the invalid
connection (the server closed it because of a timeout), and the script was
dying on that error. The ping() method was introduced to solve this problem.
Here's an example of what is essentially a database ping:
unless ($self->{dbh} and $self->{dbh}->do("SELECT 1")) {
$self->{dbh} = DBI->connect("dbi:mysql:$self->{database}:$self->{server}",
$self->{user},$self->{password});
}
Here's an example of Apache::DBI ping:
sub Apache::DBI::db::ping {
my $dbh = shift;
return $dbh->do(`select 1`);
}
Another solution was found - to increase the timeout parameter when starting
the database server, the default is set to 8 hours.
172800 seconds is equal to 48 hours. This change solves the problem, but the
ping() method works properly in DBD::mysql as well.
Currently, I've added the following code to my scripts:
$dbh = DBI->connect("DBI:mysql:$database_name:$host:3306", "User", "Password",
{RaiseError => 1, PrintError => 1});
if (! $dbh) {
$dbh = DBI->connect
("DBI:mysql:$database_name:$host:3306", "User", "Password",
{RaisError => 1, PrintError => 1});
}
So, I create a database handle but if the database handle doesn't exist on
the first try, I try to create it again.
I'd like to know, which is best method for handling this situation?
I've also created a wrapper for my DBI usage and I trap and present error
messages of my own in my log. However, sometimes I may have an entry
that says "No database connection" and I'd expect to see an "Aborted..."
message in my database.err log file but I don't. Can you shed some light
on this?
Lastly, I have a CGI-BIN script that produces dynamic webpages and people
sometimes click stop, then start (especially when doing searches)
multiple times. So, as the httpd processes eventually die off I'll still
have some MySQL threads lying around, how do I run down those useless
threads and keep by max_connections down?
Thanks in advance, cheers.
Ozette
--
Email: [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Speed difference
Hi All, I have tried out some performance testing with some heavy SELECT and UPDATES. The database in question has only 500 records but there are lots of SELECTs and UPDATEs and the results are: after timing the program that was targeting MySQL on different platforms the results are (client program running always from the same box that is not hosting MySQL): Windows NT - 25 sec (Intel P-III) Linux - 27 sec (Intel P-III) Solaris 2.7 - 1 min 40 sec (Ultra 5) Solaris 2.7 - 1 min 32 sec (Ultra 10) Is there a reasonable explanation why is this happening. Thanks, Nesh Nenad Mijailovic Software Engineer IVSTEL Telecommunications Solutions - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Joining tables using "IN (...)" clause returns duplicate rows
On Monday 04 February 2002 01:12 pm, Greg Bailey wrote: > What is the real "production" version? ?If 4.0.2 can be called a > production version, I'd gladly use it on my web site; however, it > doesn't seem to indicate that on the MySQL home page. ?So if I find a > bug in 3.23.47 that was fixed a "long time ago" as Mr. Milivojevic > states, wouldn't I expect it to find its way into the 3.23.X series as > the production series? Greg - you are absolutely right. Sinisa should have tested it on a 3.23 version instead. 4.0.2 is not even out. However, your test case worked as expected on 3.23.43-max, our binary. I noticed that your MySQL binary was from source using gcc 2.96, which is very likely the cause of the problem. I will add your test case to our gcc296 test in our test suite - hopefully it will help us find the bug and create a test case for RedHat. In the meantime, I strongly recommend that you switch to our binary. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA <___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqladmin password
Hi All, Does anyone knows how to change my mysqladmin password or how to find out what the password it, I installed the rpm package, didn't setup any password, however when I setup a tool to use it with, the tool is asking me to produce the mysqladmin password. Thanx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: performance help required. (2G -> 4G Ram upgrade)
On Mon, Feb 04, 2002 at 05:41:46PM -, Robin Keech wrote: > (Please reply directly, I am only on the digest list, thanks) > > I have an SQL statement that is taking far too long to run, around > 11 minutes (while locking inserts/updates). > > We have installed some more RAM, and I need help with my.cnf and the > troublesome SQL. > > Can anyone suggest some config values to best utilise the extra RAM > I have just fitted? We have gone from 2G to 4G On what operating system? > The table in question is very large, > ie > e3_id_chain.MYD = 3.7G ~ 53 million records > e3_id_chain.MYI = 3.2G > > These are my current settings > > # The MySQL server > [mysqld] > port= 3306 > socket = /tmp/mysql.sock > skip-locking > set-variable= key_buffer=512M > set-variable= max_allowed_packet=2M > set-variable= max_connections=500 > set-variable= table_cache=512 > set-variable= sort_buffer=2M > set-variable= record_buffer=2M > set-variable= thread_cache=8 > set-variable= wait_timeout=1800 > # Try number of CPU's*2 for thread_concurrency > set-variable= thread_concurrency=4 > set-variable= myisam_sort_buffer_size=64M > log-bin > low-priority-update > > When doing an SQL select it takes 11 minutes > > mysql> explain SELECT e3_id, prev_e3_id, log_id FROM e3_id_chain WHERE > prev_e3_id IS NOT NULL AND log_id IS NOT NULL; > +-+--+---+--+-+--+-- > ++ > | table | type | possible_keys | key | key_len | ref | > rows | Extra | > +-+--+---+--+-+--+-- > ++ > | e3_id_chain | ALL | prev_e3_id_idx,log_id_idx | NULL |NULL | NULL | > 58179805 | where used | > +-+--+---+--+-+--+-- > ++ > 1 row in set (0.00 sec) > > But its not using the index??? Correct. And that key_buffer won't help much. How many of the rows actually match your query? > Can anyone explain this behaviour, and suggest a solution? MySQL will decide not to use an index in cases when it believes there is a faster way, such as a full table scan. This is often the case when a significant percentage of the rows are likely to match. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 0 days, processed 22,771,714 queries (385/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql create table error
Oganes, > I have the following create table, and I get the following error when I create it. > It used to work before. Can anyone help? > > CREATE TABLE PROTOCOL_GROUPING( > PROTOCOL_GROUPING_ID MEDIUMINT(20), > GROUP_NAMEVARCHAR(50)NOT NULL, > PROTOCOL_ID MEDIUMINT(20) NOT NULL, > PROTOCOL_STEP_NO MEDIUMINT(10) NOT NULL, > foreign key (PROTOCOL_ID, PROTOCOL_STEP_NO) REFERENCES PROTOCOL_STEP(PROTOCOL_ID, >PROTOCOL_STEP_NO), UNIQUE INDEX PROTOCOL_GROUPING_PK (PROTOCOL_GROUPING_ID))Type=InnoDB; > > I get the following error: can't create table .\test\protocol_grouping.frm (errno >150) =it works perfectly for me... =did you remove the existing tbl before attempting to re-run the CREATE? (I try to remember to put: DROP TABLE IF EXISTS tblNm; in every create .sql) =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
increasing InnoDB search performance
I have an application that stores a large (up to 6gb) database in an InnoDB table. I'm using an InnoDB table to have concurrent inserts and selects and to get beyond the 2gb limitation. I have to allow read-only remote database connections and cannot enforce that users use any kind of special query to access the database (e.g., implementing my own fulltext-like index and using the index at an application layer). The content consists of log entries which are each under 255 characters long. I'd like to know what I can do to improve the response time of the database under these restrictions. So I have a few questions: Would adding ram help? I can't imagine that an operation that requires searching 6gb (a disk bandwidth or processing bottleneck problem) would be improved much by adding ram.. ? Can I do anything (short of hardware changes) to increase performance? And long term question: I've noticed that a fulltext index feature doesn't appear on the InnoDB todo list. From my (limited) research, it looks like this is a feature a lot of people would find very useful. Is this a long term goal, or has it been excluded for some reason? Thanks Eric Mayers Software Engineer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Which Hardware do I need ?
On Mon, Feb 04, 2002 at 11:55:57AM +0100, Daniel Backhausen wrote: > > Hi. > > Does somebody know which server hardware I have to buy to realize my following >problem ? > > I have 3 tables. They are all connected to each other with some queries. > > 1st table has momentary 10.000 and should be upgraded to 50.000 records. > 2nd table has 120.000 records at moment and should be upgraded to 700.000 at time. > 3rd table has 200.000 records and should be upgraded to 1.500.000 records. > > Does somebody have experience with such a huge amount of records in > mySQL ? That's not huge. :-) We've got one table with over 267 million rows in it and it grows daily. > We have momentary a DUAL 1 GHz Server with 1 GB Ram, but he gets a > load of 40 and restarts after some time. That should be more than sufficient. Are your queries well optimized and using indexes? How large is your key buffer? Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 0 days, processed 22,638,026 queries (388/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqld crash & stack trace from 3.23.47-max (with InnoDB)
On Mon, Feb 04, 2002 at 02:33:40PM -0700, Sasha Pachev wrote: > On Monday 04 February 2002 11:59 am, Jeremy Zawodny wrote: > > >?This does look like a libc bug. How did you build either one of the > binaries? > > > > They're your binaries. ?I don't buld my own binaries on Linux to save > > the hassle of using libraries that are different from what you folks > > use. :-) > > > > Strangely, it's working now--after a reboot. ?I'm gonna keep an eye on > > that machine. > > If it is working after reboot, I would name the disk cache > corruption as the primary suspect. My hypothesis is that you were > unlucky to have libnss.so cached in the buggy part of the disk > cache. Although our binaries are statically linked, on Linux calls > to name resolving functions allways require loading a shared > library, even if you are doing it from a statically linked binary. Could be. I sure hope that's not the case, but who knows at this point. > What kernel version are you running, and is this a virgin kernel > from kernel.org or a patched one from some Linux distribution? The box is currently running a 2.4.12 that I don't *think* is patched. I've gotta talk to the guy who builds our linux kernels and get an upgrade on that machine anyway. > P.S. "It works after reboot" is an ominous phrase that I hope will > be chased out of the Linux world quickly. Yeah, it really surprised me. > We need to track down this problem ASAP and send a full bug report > to the kernel developers. Agreed. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 0 days, processed 22,591,842 queries (388/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sysctl & process limitations
On Mon, Feb 04, 2002 at 03:43:40PM -0700, Randy Arabie wrote: > On Mon, 4 Feb 2002, William R. Mussatto wrote: > > > Have you checked on the ulimit for the user that is mysql? > > I did, but had only set it "dynamically". I did raise it quite high, > 5000 I believe. After that I initiated the load, but from a "normal" > user shell which had the default proc.[shell_pid].rlimit.descriptors.soft=64 > limitation. Hence my question, from where does the load inherit its limit. What a minute ... you're loading the tables to a 'mysqld' process, using the 'mysql' command, rigth ? Maybe it's just the mysql command which runs out of files descriptors ? Did you try to raise the limit of the shell before starting it ? -- Manuel Bouyer <[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: sysctl & process limitations
On Mon, 4 Feb 2002, William R. Mussatto wrote: > Have you checked on the ulimit for the user that is mysql? I did, but had only set it "dynamically". I did raise it quite high, 5000 I believe. After that I initiated the load, but from a "normal" user shell which had the default proc.[shell_pid].rlimit.descriptors.soft=64 limitation. Hence my question, from where does the load inherit its limit. I'm stepping back and looking at where I should set it at the kernel level, and then where I can set it for specific users and/or processes. -- Cheers! Randy Randy Arabie GnuPG Key Info -- Fingerprint: 7E25 DFA2 EF72 9551 9C6C 8AA6 6E8C A0F5 7E33 D981 Key ID: 7C603AEF http://www.arabie.org/keys/rrarabie.gnupg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Hi, Help!
On Mon, Feb 04, 2002 at 04:37:33PM -0600, Erin Lilly wrote: > Hi, this is Erin Lilly, I've used support before with you all for > bodyconsultant.com and you were extremely helpful. I'm installing mysql on > erinlilly.net and have run into that common /tmp/mysql.sock (111) error > Hi, you just mailed your root password to an open mailing list. Take care. You might want to change your password now. Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hi, Help!
Hi, this is Erin Lilly, I've used support before with you all for bodyconsultant.com and you were extremely helpful. I'm installing mysql on erinlilly.net and have run into that common /tmp/mysql.sock (111) error version: 3.23.45-pc-linux To telnet in as root: erinlilly.net log-admin pw-paws you then need to type in /usr/local to see where I've installed the mysql-3.23.45 Please take a look where I had installed it in /usr/local/mysql-3.23.45-pc-linux-i686 I've created a ln -s from tmp to /usr/local/mysql-3.23 have created a ln -s from mysql-3.23.45 and mysql What's the problem?? When I go to do the ./bin/safe_mysql & command it turns server on then logs off. Also when I do bin/mysqladmin -u root -p password it gives me the /tmp/mysql.sock (111) not found - even though I have ln -s that tmp directory to the mysql-3.23.45 ... Have tested the telnet erinlilly.net 3306 - and no connection. MY QUESTIONS: 1. What do I need to do to get the connection going. 2. How can I be sure the tables were created. I ran install_db and it appeared to do everything. 3. What do I need to do to make things right here? 4. Have all my ln -s created some inherent problems? HERE's the MYSQL registration info: erin6817 fevnodfi order number 6755 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: renumbering auto-increment?
At 01:19 PM 2/4/2002 , you wrote: >2) I use MySQLfront just for a couple of days. I find it very usefull (has >to be written in Delphi) Is this the best freeware for this job or is there >a better one ? Makis, MySQLFront is pretty good considering the price. :) There is also MySQLMgr from EMS which is slightly better, but it costs $99. You can get a 30 day eval from http://www.ems-hitech.com/mymanager/. It has much better reporting and is MDI which means you display more than 1 table definition at a time. It also has a lot of tools like a Grant Manager, SQL monitor, the ability to repair/optimize tables etc.. It runs under Windows. If you plan on using MySQL a lot, it is worth a look. Brent - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
CAST fails
Hello everyone, Im running MySQL version 11.15 Distribution 3.23.47 on
Windows 2000. I'm having issues with the CAST command, for example, if
I execute:
CREATE TABLE new_table SELECT CAST('2000-01-01' AS DATE);
I receive the error:
ERROR 1064: You have an error in your SQL syntax near '('2000-01-01' AS
DATE)' at line 1
This create command is the exact example used in the MySQL
documentation. It doesn't matter if I execute these commands through
ODBC or directly on the console, I get this error. I've tried different
variations of the cast command with different variable types, I've also
tried the convert command, and I always get the same message. I've also
tried it on a MySQL database on Linux with the same result (I don't have
the versions, sorry).
Has anyone seen this before?
Thanks in advance...
Chris.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: know what this means?
In my experience, this happens when the version of mysql you're running is newer then the version of libraries that something on your system was compiled with, typically, installing the new libs on your system and recompiling php or whatever you're using to connect to the mysql server through, be it perl, php, etc etc etc will fix this problem. Garrett Marone Systems Administration Hostcentric.com In the last episode (Monday 04 February 2002 04:18 pm), Lazor, Ed wrote: Anyone know what this means? I'm getting A LOT of them in my MySQL server log. Thanks, -Ed ps... any idea on how to troubleshoot something like this? Error Message: 020204 8:20:54 Aborted connection 22 to db: 'AtFantasy2' user: 'apache' host: `localhost' (Got an error reading communication packets) This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete the message. Thank you very much. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Things equal to nothing else are equal to each other. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqld crash & stack trace from 3.23.47-max (with InnoDB)
On Monday 04 February 2002 11:59 am, Jeremy Zawodny wrote: > >?This does look like a libc bug. How did you build either one of the binaries? > > They're your binaries. ?I don't buld my own binaries on Linux to save > the hassle of using libraries that are different from what you folks > use. :-) > > Strangely, it's working now--after a reboot. ?I'm gonna keep an eye on > that machine. If it is working after reboot, I would name the disk cache corruption as the primary suspect. My hypothesis is that you were unlucky to have libnss.so cached in the buggy part of the disk cache. Although our binaries are statically linked, on Linux calls to name resolving functions allways require loading a shared library, even if you are doing it from a statically linked binary. What kernel version are you running, and is this a virgin kernel from kernel.org or a patched one from some Linux distribution? P.S. "It works after reboot" is an ominous phrase that I hope will be chased out of the Linux world quickly. We need to track down this problem ASAP and send a full bug report to the kernel developers. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA <___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
know what this means?
Anyone know what this means? I'm getting A LOT of them in my MySQL server log. Thanks, -Ed ps... any idea on how to troubleshoot something like this? Error Message: 020204 8:20:54 Aborted connection 22 to db: 'AtFantasy2' user: 'apache' host: `localhost' (Got an error reading communication packets) This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete the message. Thank you very much. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Memory Leaks ?
Thanks, I think that maybe the cause, I was using a single MYSQL structure for mutiple calls with diffrent MYSQL_RES pointers. - Original Message - From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, February 04, 2002 7:51 PM Subject: Re: Memory Leaks ? > iain furneaux writes: > > yes after every call, that was the first thing I tried, it made the > > situation better but not cured it. Are there any circumstances where > > mysql_free_result() will not free the result ? does it have to be called > > before any further mysql_real_query() calls are made even on a diffrent > > MYSQL_RES pointer ? > > > > I think I am heading for a code re-write by the looks of things so any > > suggestions on common traps that I may have fallen into would be helpful > > > > thanks > > > > > No, mysql_free_result() will always free memory allocated by > mysql_use_result, mysql_store_result, fetch_row() etc ... > > If you wish to have several MYSQL_RES, you may, but each should be > tied to a separate MYSQL structure. > > -- > Regards, >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer > /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ><___/ www.mysql.com > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: renumbering auto-increment?
If you are using tables of the MyISAM type, the auto-increment goes up every time you insert, regardless of any deletes. The only way to reset it is to drop and re-create the table or do a "delete from table" command with no where clause. ISAM tables do not do this. Read up in the manual on table types and decide which is best for you. AFAIK there is no "pack" option for MyISAM. # Nathan - Original Message - From: "savaidis" <[EMAIL PROTECTED]> To: "MySQL list (E-mail)" <[EMAIL PROTECTED]> Sent: Monday, February 04, 2002 12:19 PM Subject: renumbering auto-increment? Hello all ! I see it's a very busy list so I will try to by short to my first question: 1) Is there a way to put the REAL numbers of rec in the ID=auto-increment? I made some tests so this number is higher than total recs of the table.(export/import to text doesn't help) The Rec_num is stored somewhere? Or is there a "pack" command? 2) I use MySQLfront just for a couple of days. I find it very usefull (has to be written in Delphi) Is this the best freeware for this job or is there a better one ? Thanks Makis Thessaloniki Makedonia Greece - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MyODBC leaking handles...
Hi, > -Original Message- > From: Jens Collin [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 04, 2002 5:42 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: RE: MyODBC leaking handles... > > > Hi again Venu, > > I tried the latest one. I'm sorry to say that the error persists... > Still leaking handles at terrible speeds. One handle for each > select even if we close the set. > You mentioned something regarding a new version of the server > engine as well... Is this going to be released soon? Does this > affect this issue? Perhaps this fix just works with ODBC & server > of later versions and not only the ODBC one. > Hmmm, am sorry. Actually the 8k leak fix(charset and initialization) was there in .47 version of server and 3.51.01, together should be able to work out. If it happens with the above configure, could you please able to trace back the call sequence of leaks ? Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Joining tables using "IN (...)" clause returns duplicate rows
I guess I'm a little confused about the MySQL versions. What is the real "production" version? If 4.0.2 can be called a production version, I'd gladly use it on my web site; however, it doesn't seem to indicate that on the MySQL home page. So if I find a bug in 3.23.47 that was fixed a "long time ago" as Mr. Milivojevic states, wouldn't I expect it to find its way into the 3.23.X series as the production series? I really like MySQL and don't mean this as any type of a flame, just wondering what the versions mean. Thanks for any insight anyone can shed on this for me Greg Bailey Sinisa Milivojevic wrote: > > Greg Bailey writes: > > >Description: > > > > Joining multiple tables together in a select statement with where > > clauses > > using the "IN (...)" construct generate duplicated output rows. > > > > Hi! > > I tested your case with 4.0.2 and got identical results from both > queries. > > This was some bug probably fixed long time ago. > > -- > Regards, >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer > /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ><___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sysctl & process limitations
On Mon, Feb 04, 2002 at 12:01:11PM -0700, Randy Arabie wrote: > On Mon, 4 Feb 2002, William R. Mussatto wrote: > > > Have you checked on the ulimit for the user that is mysql? > > I've checked a lot of things. > > Which would apply: > > kern.maxfiles > proc.[mysqld_pid].rlimit.descriptors.soft > proc.[shell_pid].rlimit.descriptors.soft > > Obviously, the process rlimits cannot exceed the limits set in the kernel. > > But, between the other two, which one takes precedence...the shell from > which the command was invoked or the actual mysqld process? The mysqld process When mysqld is started the values are herited from the shell, but once it's started you can change both values independantly with systctl. -- Manuel Bouyer <[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
(WWOT) Re: PHP with TTF fonts
What does this have to do with mysql? Please try a PHP mailing list ps: database, sql, mysql savaidis wrote: > > Hello again! > > I see many people works here with php and that's natural, as php is > connected with MySQL. > In php graphics, I found that printing with a TTF font has no possibility > to set the font high. Is this true? > Also is not possible to open only once one font file and not as many times > as text stings are displayed on the image? This is to slow and consumes to > much of server's memory. > > Thanks > Makis > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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) 859-1491 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: PHP with TTF fonts
Hi Makis, There are separate PHP mailing lists - you can find them at www.php.net - Jonathan -Original Message- From: savaidis [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 11:29 AM To: MySQL list (E-mail) Subject: PHP with TTF fonts Hello again! I see many people works here with php and that's natural, as php is connected with MySQL. In php graphics, I found that printing with a TTF font has no possibility to set the font high. Is this true? Also is not possible to open only once one font file and not as many times as text stings are displayed on the image? This is to slow and consumes to much of server's memory. Thanks Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Installing MySQL in Home Directory
I'm currently trying to install MySQL in my home directory on a server which I do have root access to. I follow the steps outlined in O'Reilly's 'MySQL&mSQL' book and I get through the first several steps before problems occure. To set the stage, I'm using mysql-3.23.47. I'm able to 'configure', 'make', and 'make install' without any issues, but when I go to run 'mysql_install_db', it gives me permission errors trying to access '/var/lib/mysql'. When I ran the 'configure', I added the '--prefix' and '--localstatedir' flags with directories which my login would be able to access, including one which I thought would override '/var/lib/mysql'. Does anyone have any suggestions on what I can try or a different method to my installation? Also, I've never worked with MySQL when it's on a system with other users running their owns. I noticed there's a flag specifying ports. Is that something I'm required to set as well? It makes sense that I'd have to, but I can't find any documents on running MySQL under home directories to confirm it. Thanks, Dave Mittner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re:update failing when statement includes "\"
Kinney, I did the following and it worked. $text="Adding FAQ\'s"; $query="Update faqs SET subject='$text' WHERE id='110'"; mysql_query($query); Good luck. -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Memory Leaks ?
iain furneaux writes: > yes after every call, that was the first thing I tried, it made the > situation better but not cured it. Are there any circumstances where > mysql_free_result() will not free the result ? does it have to be called > before any further mysql_real_query() calls are made even on a diffrent > MYSQL_RES pointer ? > > I think I am heading for a code re-write by the looks of things so any > suggestions on common traps that I may have fallen into would be helpful > > thanks > No, mysql_free_result() will always free memory allocated by mysql_use_result, mysql_store_result, fetch_row() etc ... If you wish to have several MYSQL_RES, you may, but each should be tied to a separate MYSQL structure. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL INSERT based on SELECT CRITERIA
hello list, I'm having trouble with an INSERT command based on a select Is what I want is in my contacts table I'm selected certain criteria and then inserting a note into my contactnotes table certain values Here's what I have so far contactnotes mysql table headers: | | || code + contactno + note + source + date _|___|__||__ INSERT INTO contactnotes SELECT code, country, show_qty, completed FROM contacts WHERE country = US AND show_qty = 1 AND completed != 1 The bulk values that I want to insert into contactnotes are: code = AUTO_INCREMENT contactno = code.contacts <---from the select statement note = Show catalog sent to user source = catalogs date = %Y%M%d All based on the select statement Any help would be appreciated J. Scott Andreas :) IS/Programmer/WebDevelopement Learning Services, Inc. e-mail: [EMAIL PROTECTED] phone: 1-800-877-9378 ext. 146 fax: (541) 744-2056 ---__o --- _-\<,_ --- (_)/ (_) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sysctl & process limitations
On Mon, 4 Feb 2002, Randy Arabie wrote: > Date: Mon, 4 Feb 2002 12:01:11 -0700 (MST) > From: Randy Arabie <[EMAIL PROTECTED]> > To: "William R. Mussatto" <[EMAIL PROTECTED]> > Cc: Dan Nelson <[EMAIL PROTECTED]>, > Manuel Bouyer <[EMAIL PROTECTED]>, [EMAIL PROTECTED], > [EMAIL PROTECTED] > Subject: Re: sysctl & process limitations > > On Mon, 4 Feb 2002, William R. Mussatto wrote: > > > Have you checked on the ulimit for the user that is mysql? > > I've checked a lot of things. > > Which would apply: > > kern.maxfiles > proc.[mysqld_pid].rlimit.descriptors.soft > proc.[shell_pid].rlimit.descriptors.soft > > Obviously, the process rlimits cannot exceed the limits set in the kernel. > > But, between the other two, which one takes precedence...the shell from > which the command was invoked or the actual mysqld process? > > -- > > Cheers! > > Randy > Someone in the netbsd.org will have to answer since we are a linux shop and I'm not sure its the same. The only reason I mentioned this is we ran into a problem w/apache durring the code red worm attacks (its not vulnerable, but you do get a bunch of children started. Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: TCP/IP Security for Remote Access of MySQL DBs...for newbie
Marcus Collins chortled: > (sorry; missed the original post) > > If you have admin access to both machines, then how about using stunnel > http://www.stunnel.org/> to set up an SSL-encrypted connection > between both machines on the ports on which mysqld communicates? > > There's an example for MySQL at > http://www.stunnel.org/examples/mysql.html> > > Cheers! > > -- Marcus Ah, very good. I'll take a look. I won't have admin on the far machine, but will be in touch with their admin there. Cheers. @@@ Rich Fortnum / Viaduct Productions / Toronto (EST) @@@ Web Design / Databases / Internet Video / Wireless Data @@@ [EMAIL PROTECTED] / http://www.viaduct-productions.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Memory Leaks ?
yes after every call, that was the first thing I tried, it made the situation better but not cured it. Are there any circumstances where mysql_free_result() will not free the result ? does it have to be called before any further mysql_real_query() calls are made even on a diffrent MYSQL_RES pointer ? I think I am heading for a code re-write by the looks of things so any suggestions on common traps that I may have fallen into would be helpful thanks - Original Message - From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, February 04, 2002 7:38 PM Subject: Re: Memory Leaks ? > iain furneaux writes: > > Im afraid I do not know where the possible leaks are as I only have the > > mtrace dump which I included a section of in my first posting, I have > > included the whole dump. As the current code runs into several hundred lines > > I do not think it would be helpful > > > > mtrace dump > > > > I am afraid that we can not conclude mush from your output. > > Most likely it is an error in your code. > > Have you called mysql_free_result() after fetching rows ?? > > -- > Regards, >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer > /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ><___/ www.mysql.com > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: TCP/IP Security for Remote Access of MySQL DBs...for newbie
Andreas Schoelver chortled: > How about using a VPN (virtual private network) ? > > regards > Andreas > > sql,select,mysql I want to minimize the network structure on their part because they will have a minimal DSL system as they are on the outskirts of town. As well, I don't want the bulk of the cost for them going to infastructure. There's got to be a way of throwing SQL records around without creating a whole new layer. Cheers. @@@ Rich Fortnum / Viaduct Productions / Toronto (EST) @@@ Web Design / Databases / Internet Video / Wireless Data @@@ [EMAIL PROTECTED] / http://www.viaduct-productions.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Memory Leaks ?
iain furneaux writes: > Im afraid I do not know where the possible leaks are as I only have the > mtrace dump which I included a section of in my first posting, I have > included the whole dump. As the current code runs into several hundred lines > I do not think it would be helpful > > mtrace dump > I am afraid that we can not conclude mush from your output. Most likely it is an error in your code. Have you called mysql_free_result() after fetching rows ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Memory Leaks ?
Im afraid I do not know where the possible leaks are as I only have the mtrace dump which I included a section of in my first posting, I have included the whole dump. As the current code runs into several hundred lines I do not think it would be helpful mtrace dump Memory not freed: - Address Size Caller 0x08051a70 0x41 at /home/iain/sarosd/jobs/schedule2/sql.c:100 0x08051b30 0x58 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08081940 0x1fe4 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08083928 0x28 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08083958 0x1fe4 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08085940 0x28 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08085970 0x1fe4 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08087958 0x1fe4 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08089940 0x1fe4 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x0808b928 0x1fe4 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x0808d910 0x1fe4 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x0808f8f8 0x1fe4 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08272218 0x1fe4 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415558 0x5c at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x084155b8 0x5c at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415618 0x28 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415648 0x5c at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x084156a8 0x28 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x084156d8 0x5c at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415738 0x28 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415768 0x5c at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x084157c8 0x28 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x084157f8 0x5c at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415858 0x28 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415888 0x5c at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x084158e8 0x28 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415918 0x5c at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415978 0x28 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x084159a8 0x5c at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415a08 0x28 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415a38 0x5c at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415a98 0x28 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415ac8 0x5c at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415b28 0x28 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415b58 0x5c at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415bb8 0x28 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415be8 0x5c at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415c48 0x28 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415c78 0x5c at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415cd8 0x28 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415d08 0x5c at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415d68 0x28 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415d98 0x5c at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415df8 0x28 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415e28 0x5c at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415e88 0x28 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415eb8 0x5c at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415f18 0x28 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415f48 0x5c at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415fa8 0x28 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08415fd8 0x5c at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08416038 0x28 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08416068 0x5c at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x084160c8 0x28 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x084160f8 0x5c at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08416158 0x28 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08416188 0x5c at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x084161e8 0x28 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08416218 0x5c at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x08416278
PHP with TTF fonts
Hello again! I see many people works here with php and that's natural, as php is connected with MySQL. In php graphics, I found that printing with a TTF font has no possibility to set the font high. Is this true? Also is not possible to open only once one font file and not as many times as text stings are displayed on the image? This is to slow and consumes to much of server's memory. Thanks Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Memory Leaks ?
iain furneaux writes: > I have just tried the 3.23.47 release and the same problem seems to be > occuring, is there anything I could be doing in my code that would make it > look like the problem is coming from libmysqlclient.so.10 ? > Post your code to the list and pinpoint where is memory leak reported. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
renumbering auto-increment?
Hello all ! I see it's a very busy list so I will try to by short to my first question: 1) Is there a way to put the REAL numbers of rec in the ID=auto-increment? I made some tests so this number is higher than total recs of the table.(export/import to text doesn't help) The Rec_num is stored somewhere? Or is there a "pack" command? 2) I use MySQLfront just for a couple of days. I find it very usefull (has to be written in Delphi) Is this the best freeware for this job or is there a better one ? Thanks Makis Thessaloniki Makedonia Greece - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: INSERTing duplicate values to a UNIQUE-indexed table
On Tuesday, February 5, 2002, at 02:01 PM, DL Neil wrote: > =option 2: whilst native-MySQL will give an errmsg in response to an > attempt to INSERT duplicates, PHP doesn't > have to pay attention! Check out MySQL_affected_rows(). David, I see... that's a good debugging tool, mysql_affected_rows(). Thank you for pointing me to that one. Still, I am glad that this sort of situation has been anticipated by the MySQL developers (or perhaps I should say the ANSI SQL spec drafters), and have decided to use INSERT IGNORE to handle my situation, if only to be forward compatible with a version of PHP that -might- pay attention. Hope all is well with you, Erik Erik Price Web Developer Temp Media Lab, H.H. Brown [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: Memory Leaks ?
I have just tried the 3.23.47 release and the same problem seems to be occuring, is there anything I could be doing in my code that would make it look like the problem is coming from libmysqlclient.so.10 ? - Original Message - From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, February 04, 2002 6:47 PM Subject: Re: Memory Leaks ? > iain furneaux writes: > > appologies the MySQL version is 3.22.32 (sorry fat fingers! :-) ) > > > > Just try our latest 3.23 C API > > -- > Regards, >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer > /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ><___/ www.mysql.com > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql create table error
I have the following create table, and I get the following error when I create it. It used to work before. Can anyone help? CREATE TABLE PROTOCOL_GROUPING( PROTOCOL_GROUPING_ID MEDIUMINT(20), GROUP_NAMEVARCHAR(50)NOT NULL, PROTOCOL_ID MEDIUMINT(20) NOT NULL, PROTOCOL_STEP_NO MEDIUMINT(10) NOT NULL, foreign key (PROTOCOL_ID, PROTOCOL_STEP_NO) REFERENCES PROTOCOL_STEP(PROTOCOL_ID, PROTOCOL_STEP_NO), UNIQUE INDEX PROTOCOL_GROUPING_PK (PROTOCOL_GROUPING_ID))Type=InnoDB; I get the following error: can't create table .\test\protocol_grouping.frm (errno 150) Oganes Demirchyan Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 11:02 AM To: Demirchyan Oganes-AOD098 Subject: Re: mysql create table error 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: I have the following create table, and I get the following error when I create it. It used to work before. Can anyone help? CREATE TABLE PROTOCOL_GROUPING( PROTOCOL_GROUPING_ID MEDIUMINT(20), GROUP_NAMEVARCHAR(50)NOT NULL, PROTOCOL_ID MEDIUMINT(20) NOT NULL, PROTOCOL_STEP_NO MEDIUMINT(10) NOT NULL, foreign key (PROTOCOL_ID, PROTOCOL_STEP_NO) REFERENCES PROTOCOL_STEP(PROTOCOL_ID, PROTOCOL_STEP_NO), UNIQUE INDEX PROTOCOL_GROUPING_PK (PROTOCOL_GROUPING_ID))Type=InnoDB; I get the following error: can't create table .\test\protocol_grouping.frm (errno 150) Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sysctl & process limitations
On Mon, 4 Feb 2002, William R. Mussatto wrote: > Have you checked on the ulimit for the user that is mysql? I've checked a lot of things. Which would apply: kern.maxfiles proc.[mysqld_pid].rlimit.descriptors.soft proc.[shell_pid].rlimit.descriptors.soft Obviously, the process rlimits cannot exceed the limits set in the kernel. But, between the other two, which one takes precedence...the shell from which the command was invoked or the actual mysqld process? -- Cheers! Randy Randy Arabie GnuPG Key Info -- Fingerprint: 7E25 DFA2 EF72 9551 9C6C 8AA6 6E8C A0F5 7E33 D981 Key ID: 7C603AEF http://www.arabie.org/keys/rrarabie.gnupg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
update failing when statement includes "\"
Hi, I'm playing with PHP/MySQL for the first time having used Perl and MySQL for years. In one of my first update scripts, PHP is automatically escaping quotes and such, which I assumed was a good thing. However, I'm noticing that MySQL is rejecting statements like: Update faqs SET subject='Adding FAQ\'s' WHERE id=110 ; It also rejects: Update faqs SET subject="Adding FAQ\'s" WHERE id=110 ; I've tested these out on the MySql command line and find the same thing. Rows matched: 1 Changed: 0 Warnings: 0 It finds the row but doesn't make the change. Anyone have a suggestion for what I need to do to get the record updated? I don't find anything in the archives or the manual that addresses this problem. Thanks. +---+ | Kinney Baughman Appalachian State University | | Appalachian Regional Development InstituteBoone, NC 28608 | | Email: [EMAIL PROTECTED] Phone: (828) 262-6523 | +---+ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqld crash & stack trace from 3.23.47-max (with InnoDB)
On Mon, Feb 04, 2002 at 10:08:37AM -0700, Sasha Pachev wrote: > On Monday 04 February 2002 02:30 am, Jeremy Zawodny wrote: > > 0x807bb5f handle_segfault__Fi + 383 > > 0x82a94aa pthread_sighandler + 154 > > 0x7cb80076 __evoke_link_warning_llseek + 1954074198 > > 0x7cb7fe19 __evoke_link_warning_llseek + 1954073593 > > 0x7cb713e6 __evoke_link_warning_llseek + 1954013638 > > 0x7c97db8b __evoke_link_warning_llseek + 1951967595 > > 0x7c980668 __evoke_link_warning_llseek + 1951978568 > > 0x7c981200 __evoke_link_warning_llseek + 1951981536 > > 0x7c96dee4 __evoke_link_warning_llseek + 1951902916 > > 0x82ddd0a gethostbyaddr_r + 346 > > 0x82ddb44 gethostbyaddr + 196 > > 0x807ff98 ip_to_hostname__FP7in_addrPUi + 232 > > 0x808082c check_connections__FP3THD + 152 > > 0x8080c79 handle_one_connection__FPv + 321 > > This does look like a libc bug. How did you build either one of the binaries? They're your binaries. I don't buld my own binaries on Linux to save the hassle of using libraries that are different from what you folks use. :-) Strangely, it's working now--after a reboot. I'm gonna keep an eye on that machine. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 0 days, processed 18,324,732 queries (409/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: INSERTing duplicate values to a UNIQUE-indexed table
HelloErik, > I have a slight dilemma, and was wondering what the standard workaround > is. I have three tables: owners (auto_increment primary key is > "owners_id"), objects (auto_increment primary key is "objects_id"), and > owners_objects (which is a foreign key table that I created, under > advice from someone on this list a while back whose email address has > changed -- there are two columns in owners_objects: "owners_id" and > "objects_id", and there are two unique indexes on the table, > "owners_id / objects_id" and "objects_id / owners_id" -- this is to keep > duplicates combinations in this table, since they would only take up > extra disk space). > > I am designing an application in PHP which stores the relationship > between an Owner and an Object using the owners_objects table in a > many-to-many relationship. When someone adds a new owner, they can > choose from an HTML listbox any number of objects to associate with that > owner. The PHP code creates an INSERT statement that inserts the data > into "owners", and then takes the auto_incremented primary key of the > last insert (which is the insert into "owners") and uses that as the > value for the second INSERT statemetn: to insert into > "owners_objects.owner_id". In this second INSERT statement, the > "objects_id" of the Object(s) selected from the listbox go into the > second column of "owners_objects". > > I am sure that many people have done this sort of setup. But what do > you do to get around the problem of INSERTing a pair of values that > already exist? Because the combinations in "owners_objects" are UNIQUE > (the UNIQUE indexes), MySQL won't accept a pair that is already > present. I see two possible options: > > 1) Check to see if the combination is already present, and if so, do not > run the INSERT query > 2) run the INSERT query regardless and suppress the error message > > The disadvantage of the first one is that it adds an extra SQL query to > the process. The disadvantage of the second one is that I think it is > somewhat tasteless to execute code that will knowingly error -- or > should I just stop trying to be such a perfectionist? > > I would post code but this is all pseudocode right now b/c I haven't > solved this dilemma yet -- all experimentation with this has been done > from the mysql client. =option 2: whilst native-MySQL will give an errmsg in response to an attempt to INSERT duplicates, PHP doesn't have to pay attention! Check out MySQL_affected_rows(). =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: INSERTing duplicate values to a UNIQUE-indexed table
On Monday, February 4, 2002, at 01:48 PM, Marcus Collins wrote: > You can use REPLACE instead of INSERT -- see the manual entry: > > > http://www.mysql.com/documentation/mysql/bychapter/manual_Reference. > html#REPLACE> > Thanks Marcus! My knowledge of MySQL is pretty basic. It has also been suggested that I use INSERT IGNORE (...) VALUES (...) -- my primitive powers of deduction tell me that this would create a tiny bit less load on the database, so I assume that this is probably the best course of action, unless I'm making a mistake about the way MySQL processes data. But now I know about both options! Much appreciated, Erik Erik Price Web Developer Temp Media Lab, H.H. Brown [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: Memory Leaks ?
iain furneaux writes: > appologies the MySQL version is 3.22.32 (sorry fat fingers! :-) ) > Just try our latest 3.23 C API -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: INSERTing duplicate values to a UNIQUE-indexed table
On Mon, 4 Feb 2002 at 13:10:29 -0500, Erik Price wrote: [ snip background ] > I am sure that many people have done this sort of setup. But what do > you do to get around the problem of INSERTing a pair of values that > already exist? Because the combinations in "owners_objects" are UNIQUE > (the UNIQUE indexes), MySQL won't accept a pair that is already > present. I see two possible options: > > 1) Check to see if the combination is already present, and if so, do not > run the INSERT query > 2) run the INSERT query regardless and suppress the error message > > The disadvantage of the first one is that it adds an extra SQL query to > the process. The disadvantage of the second one is that I think it is > somewhat tasteless to execute code that will knowingly error -- or > should I just stop trying to be such a perfectionist? You can use REPLACE instead of INSERT -- see the manual entry: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#REPLACE> Cheers! -- Marcus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: INSERTing duplicate values to a UNIQUE-indexed table
At 13:10 -0500 2/4/02, Erik Price wrote: >Hello, everyone. > >I have a slight dilemma, and was wondering what the standard >workaround is. I have three tables: owners (auto_increment primary >key is "owners_id"), objects (auto_increment primary key is >"objects_id"), and owners_objects (which is a foreign key table that >I created, under advice from someone on this list a while back whose >email address has changed -- there are two columns in >owners_objects: "owners_id" and "objects_id", and there are two >unique indexes on the table, "owners_id / objects_id" and >"objects_id / owners_id" -- this is to keep duplicates combinations >in this table, since they would only take up extra disk space). > >I am designing an application in PHP which stores the relationship >between an Owner and an Object using the owners_objects table in a >many-to-many relationship. When someone adds a new owner, they can >choose from an HTML listbox any number of objects to associate with >that owner. The PHP code creates an INSERT statement that inserts >the data into "owners", and then takes the auto_incremented primary >key of the last insert (which is the insert into "owners") and uses >that as the value for the second INSERT statemetn: to insert into >"owners_objects.owner_id". In this second INSERT statement, the >"objects_id" of the Object(s) selected from the listbox go into the >second column of "owners_objects". > >I am sure that many people have done this sort of setup. But what >do you do to get around the problem of INSERTing a pair of values >that already exist? Because the combinations in "owners_objects" >are UNIQUE (the UNIQUE indexes), MySQL won't accept a pair that is >already present. I see two possible options: > >1) Check to see if the combination is already present, and if so, do >not run the INSERT query >2) run the INSERT query regardless and suppress the error message Use INSERT IGNORE, or REPLACE. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
BUSCA POPULAR
S TO MAKE TO ADD SITES FOR ORDER ALFABETICA. USING MYSQL 3,23 www.buscapopular.com.br - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sysctl & process limitations
Have you checked on the ulimit for the user that is mysql? On Sat, 2 Feb 2002, Dan Nelson wrote: > Date: Sat, 2 Feb 2002 20:58:07 -0600 > From: Dan Nelson <[EMAIL PROTECTED]> > To: Randy Arabie <[EMAIL PROTECTED]> > Cc: Manuel Bouyer <[EMAIL PROTECTED]>, [EMAIL PROTECTED], > [EMAIL PROTECTED] > Subject: Re: sysctl & process limitations > > In the last episode (Feb 02), Randy Arabie said: > > On Sat, 2 Feb 2002, Dan Nelson wrote: > > mysql. > > > > kern.maxfiles = 1772 > > > > > > Raise that to (say) 5000. I assume netbsd has an /etc/sysctl.conf you > > > can use, or you can do it manually via "sysctl -w kern.maxfiles=5000" . > > > > How high can I go?? > > > > Tried 5000, and it still bombs at the same point. I set that at the > > kernel level and the descriptors at the process level. > > The error might not actually be the kernel limit being reached. It > might just be the per-process rlimit. What does "ulimit -n" print? > > -- > Dan Nelson > [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 > Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
I have a problem with make.
Please help me. I'm installing mysql-3.23.45 on Sparc 20 with Solaris 2.5 and when i give the comand make...i have this problem. .. make[2]: Nothing to be done for `install-data-am'. make[2]: Leaving directory `/usr/local/mysql-3.23.45/libmysql' make[1]: Leaving directory `/usr/local/mysql-3.23.45/libmysql' Making install in client make[1]: Entering directory `/usr/local/mysql-3.23.45/client' gcc -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I..-I..-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti - DHAVE_RWLOCK_T -c mysql.cc cc1plus: Invalid option `-fno-exceptions' In file included from client_priv.h:19, from mysql.cc:28: ../include/global.h:680: warning: abstract declarator used as declaration make[1]: *** [mysql.o] Error 1 make[1]: Leaving directory `/usr/local/mysql-3.23.45/client' make: *** [install-recursive] Error 1 Pleas...help me. Thanks Rodrigo Canales R. Administrador de Laboratorios Instituto Profesional CIISA Fono : 697-2121 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: TCP/IP Security for Remote Access of MySQL DBs...for newbie
On Mon, 4 Feb 2002 at 18:06:34 +0100, Andreas Schoelver wrote: > > 04.02.02 15:11:30, Rich Fortnum <[EMAIL PROTECTED]> wrote: > > >Hi there. I have a need to reach into a remote database and write to their > >tables from my tables. Or have them reach into my tables and read from > >mine. Either way, data will travel over the net. I need that data secure > >and I don't know how I can make that secure. It's not a permissions thing, > >because that's straight forward...it's the communications I'm worried about. > > > >Can anybody comment on how remote security can be established between SQL > >databases? > > How about using a VPN (virtual private network) ? (sorry; missed the original post) If you have admin access to both machines, then how about using stunnel http://www.stunnel.org/> to set up an SSL-encrypted connection between both machines on the ports on which mysqld communicates? There's an example for MySQL at http://www.stunnel.org/examples/mysql.html> Cheers! -- Marcus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: question about myisamchk
On Sat, 2002-02-02 at 20:22, Egor Egorov wrote: > Get some more info at: http://www.mysql.com/doc/I/n/Insert_speed.html Hi, Would the REPLACE .. SELECT be faster if i use LOCK TABLES as it says in the manual for the INSERT command ? It's a REPLACE .. SELECT for thousands of rows. Thanx, -- Diana Soares (sql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Memory Leaks ?
appologies the MySQL version is 3.22.32 (sorry fat fingers! :-) ) - Original Message - From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, February 04, 2002 12:15 PM Subject: Re: Memory Leaks ? > iain furneaux writes: > > HI, > > > > Firstly I hope this is the right list as the enquiry I have I do not class > > as a bug due to my uncertainty about where the problem lies. > > > > I have been using the C API for MySQL 2.22.32 on Linux 2.2.14 and I have > > noticed that my program was getting to an unmanageable size in memory, there > > is a steady increase in size. Admitedly I am playing with reasonable amounts > > of data ( repeated calls retreiving 2000+ rows) however I am using the > > mysql_free_result on every MYSQL_RES that I am using and I am still seeing > > the program incerase in size. > > > > Usually I would blame this on myself for forgeting to free some malloc'ed > > memory however after running an mtrace on the program it returns rather a > > lot of the following lines: > > > > 0x084ac688 0x1fe4 at > > /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] > > 0x084ae670 0x1fe4 at > > /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] > > 0x084b0658 0x1fe4 at > > /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] > > 0x084b2640 0x1fe4 at > > /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] > > > > which leads me to beleive that there maybe an issue with the my_malloc > > function in the client lib. > > > > Am I completely incorrect ? has anyone seen this before and if so how is it > > cured as my program is running out of memory within 5 mins of starting. > > > > thanks > > Iain > > > > Machine Spec: > > > > Athlon 800 (over clocked to 1Ghz) > > 300Mb RAM (ish) > > SuSE Linux 2.2.14 > > gcc V2.95.2 > > ld V2.9.5 > > > > > > Hi! > > First of all, there is no such version of MySQL as 2.22.32. > > There is a possibility, very small, that there was a leak in some > previous version of our C API. > > Use our latest client library and see if the problem reccurs. > > > -- > Regards, >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer > /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ><___/ www.mysql.com > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Table planning
Hi, I have posted a question here previously regarding the query of talbles that contain duplicate entries in rows with only the id being different. My question was how to display or abtain ONLY the row with the highest id value in the result set along with all the other destinct rows in the table. For a little more background: The table hold data on properties, name, address,owner,property_code etc. What happens is that from time to time the data for a specific property is updated or changed or simply re-entered (on purpose or by mistake). The table needs to hold a record of each of these updates, erroneous or not, so I can't simply do an "update" when someone enters data. Now I need to pull a list of all the properties with some details like the address etc. So, obviously only the last entry for each property in the table will be of any value. I do have a date field, but sometimes the next update happens on the same day as the previous, so it won't work to test for the maximum date. Anyway, most of the replies I had all say I must create a new table and do joins etc, in my sql. Now, my real question. How are you supposed to construct a db for reading data like this. ie, it sounded to me like I was never supposed to read the data into one table but rather relational tables; making the selects possible without having to create a new table. So, I need some help in showing me how to create tables for such a system, plus some explanations on why etc. I know I can and should find these things in books, but my MySQL book is en-route from amazon, and I need some help on this rather urgently! Your help is really appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
INSERTing duplicate values to a UNIQUE-indexed table
Hello, everyone. I have a slight dilemma, and was wondering what the standard workaround is. I have three tables: owners (auto_increment primary key is "owners_id"), objects (auto_increment primary key is "objects_id"), and owners_objects (which is a foreign key table that I created, under advice from someone on this list a while back whose email address has changed -- there are two columns in owners_objects: "owners_id" and "objects_id", and there are two unique indexes on the table, "owners_id / objects_id" and "objects_id / owners_id" -- this is to keep duplicates combinations in this table, since they would only take up extra disk space). I am designing an application in PHP which stores the relationship between an Owner and an Object using the owners_objects table in a many-to-many relationship. When someone adds a new owner, they can choose from an HTML listbox any number of objects to associate with that owner. The PHP code creates an INSERT statement that inserts the data into "owners", and then takes the auto_incremented primary key of the last insert (which is the insert into "owners") and uses that as the value for the second INSERT statemetn: to insert into "owners_objects.owner_id". In this second INSERT statement, the "objects_id" of the Object(s) selected from the listbox go into the second column of "owners_objects". I am sure that many people have done this sort of setup. But what do you do to get around the problem of INSERTing a pair of values that already exist? Because the combinations in "owners_objects" are UNIQUE (the UNIQUE indexes), MySQL won't accept a pair that is already present. I see two possible options: 1) Check to see if the combination is already present, and if so, do not run the INSERT query 2) run the INSERT query regardless and suppress the error message The disadvantage of the first one is that it adds an extra SQL query to the process. The disadvantage of the second one is that I think it is somewhat tasteless to execute code that will knowingly error -- or should I just stop trying to be such a perfectionist? I would post code but this is all pseudocode right now b/c I haven't solved this dilemma yet -- all experimentation with this has been done from the mysql client. Thanks for your advice! Erik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 do I get a new working mysql.sock?
hi there, some stupid fool has deleted the mysql.sock file from our redhat server system. (me!) How do I regenerate one? thanks a mil StuartO - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
performance help required. (2G -> 4G Ram upgrade)
(Please reply directly, I am only on the digest list, thanks) I have an SQL statement that is taking far too long to run, around 11 minutes (while locking inserts/updates). We have installed some more RAM, and I need help with my.cnf and the troublesome SQL. Can anyone suggest some config values to best utilise the extra RAM I have just fitted? We have gone from 2G to 4G The table in question is very large, ie e3_id_chain.MYD = 3.7G ~ 53 million records e3_id_chain.MYI = 3.2G These are my current settings # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=512M set-variable= max_allowed_packet=2M set-variable= max_connections=500 set-variable= table_cache=512 set-variable= sort_buffer=2M set-variable= record_buffer=2M set-variable= thread_cache=8 set-variable= wait_timeout=1800 # Try number of CPU's*2 for thread_concurrency set-variable= thread_concurrency=4 set-variable= myisam_sort_buffer_size=64M log-bin low-priority-update When doing an SQL select it takes 11 minutes mysql> explain SELECT e3_id, prev_e3_id, log_id FROM e3_id_chain WHERE prev_e3_id IS NOT NULL AND log_id IS NOT NULL; +-+--+---+--+-+--+-- ++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+--+---+--+-+--+-- ++ | e3_id_chain | ALL | prev_e3_id_idx,log_id_idx | NULL |NULL | NULL | 58179805 | where used | +-+--+---+--+-+--+-- ++ 1 row in set (0.00 sec) But its not using the index??? mysql> desc e3_id_chain; ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | e3_id | varchar(80) | | MUL | | | | prev_e3_id | varchar(80) | YES | MUL | NULL| | | log_id | int(10) unsigned | YES | MUL | NULL| | ++--+--+-+-+---+ 3 rows in set (0.00 sec) even when trying to force it to use an index, it still looks like it doesn't mysql> explain SELECT e3_id, prev_e3_id, log_id FROM e3_id_chain USE INDEX (log_id_idx) WHERE prev_e3_id IS NOT NULL AND log_id IS NOT NULL; +-+--+---+--+-+--+-- ++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+--+---+--+-+--+-- ++ | e3_id_chain | ALL | prev_e3_id_idx,log_id_idx | NULL |NULL | NULL | 58179810 | where used | +-+--+---+--+-+--+-- ++ 1 row in set (0.00 sec) Can anyone explain this behaviour, and suggest a solution? Thanks Robin --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.313 / Virus Database: 174 - Release Date: 02/01/02 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Remote APIs
Rich, Sunday, February 03, 2002, 3:03:23 PM, you wrote: RF> Hey there. Wanted to know what security is built RF> into MySQL with respect to writing SQL to remote RF> tables. I have clients that want reads and writes to RF> their tables, but I don't want to share their information. RF> Any idea what I can do? Any SSL type implementation RF> from rdbms to rdbms? You can set privileges on databases, tables and columns using GRANT and REVOKE. See at: http://www.mysql.com/doc/G/R/GRANT.html You can also find more information about ssl at: http://www.mysql.com/doc/S/e/Secure_basics.html RF> Cheers. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Network drive for datadir
Neil, Monday, February 04, 2002, 6:00:18 PM, you wrote: NF> Hi, NF> Ideally I wish to keep all of my database files on a network drive NF> (X:\). Using WinMySQLAdmin.exe I have created a my.ini file which NF> resides in my WINNT directory. NF> my.ini contents... NF> [mysqld] NF> basedir=C:/mysql NF> #bind-address=127.0.0.1 NF> datadir=X:/Shared/MyData/data NF> #language=C:/mysql/share/your language directory NF> #slow query log#= NF> #tmpdir#= NF> #port=3306 NF> #set-variable=key_buffer=16M NF> [WinMySQLadmin] NF> Server=C:/mysql/bin/mysqld-nt.exe NF> user=guest NF> password=guest NF> Upon starting the MySQL service though I receive the error message NF> "Could not start the Mysql service on \\DELL02. Error 1067: The process NF> terminated unexpectedly". I have copied the databases to a local drive NF> (D:\) and altered the my.ini file and all works well. NF> Does anyone know why I cannot use MySQL to access databases on a NF> networked drive??? MySQL doesnt support loading files from Windows/samba shares. NF> Neil -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Which Hardware do I need ?
Daniel, Monday, February 04, 2002, 12:55:57 PM, you wrote: DB> Does somebody know which server hardware I have DB> to buy to realize my following problem ? DB> I have 3 tables. They are all connected to each other DB> with some queries. DB> 1st table has momentary 10.000 and should be upgraded to DB> 50.000 records. DB> 2nd table has 120.000 records at moment and should be DB> upgraded to 700.000 at time. DB> 3rd table has 200.000 records and should be upgraded to DB> 1.500.000 records. DB> Does somebody have experience with such a huge amount of DB> records in mySQL ? DB> We have momentary a DUAL 1 GHz Server with 1 GB Ram, but DB> he gets a load of 40 and restarts after some time. Tell us about the number of connections open and number of average simultaneous queries. Then we wil try to help. DB> - Daniel Backhausen -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Upgrade MySQL
Joey, Saturday, February 02, 2002, 8:16:21 PM, you wrote: JF> Dear all, JF> I am running MySQL 3.22.xx at Mandrake 8.1, how can I JF> grade my MySQL?? Please, find your answers at: http://www.mysql.com/doc/U/p/Upgrade.html JF> Thanks -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DBI + mysql
Neeraj, Monday, February 04, 2002, 7:55:15 AM, you wrote: NA> Just a simple question. I am using perl DBI to connect to NA> mysql. Its like a daemon, so its always running. But NA> whenever i get a signal it connects to a database NA> (different database each time). So there are 2 ways NA> to do it NA> 1. I disconnect and connect each time NA> 2. I connect and keep the database handle and use 'use NA> $database' NA> each time to change database. NA> Can anybody throw some light as to which one is better and NA> are there any problems involved? The second way is right. But beware: the first way permits you to reboot mysql server without a need to shutdown your perl software. So I'd better run both methods - "use database" and "disconnect/connect" handlers on different signals. Anyway, thit advise is too general. NA> thanks -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqld crash & stack trace from 3.23.47-max (with InnoDB)
On Mon, Feb 04, 2002 at 07:15:33PM +0200, Sinisa Milivojevic wrote: > > Yes, this is troubling ... > > It could be hardware, though ... > > Can you find anything in MySQL log and especially in /var/log/dmesg > or /var/log/messages. Nope. > Sometimes, not often, Linux kernel is capable of noticing potential > hardware problems. > > If mysql server crashes after number of connections has increased, it > could be hardware, e.g. RAM or cache ... Yeah, it's hard to say. The machine has been stabe and running MySQL for a long time. I'll have to tinker some more and see. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 0 days, processed 14,716,450 queries (376/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqld crash & stack trace from 3.23.47-max (with InnoDB)
Jeremy Zawodny writes: > On Mon, Feb 04, 2002 at 02:27:01PM +0200, Sinisa Milivojevic wrote: > > That was your binary on Linux. > > Strangely, I just started up that exact same copy of 3.23.47-max and > it worked fine after a machine reboot. > > That's most unusual (and troubling). > > Thanks, > > Jeremy > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 > > MySQL 3.23.41-max: up 0 days, processed 13,981,507 queries (369/sec. avg) > Yes, this is troubling ... It could be hardware, though ... Can you find anything in MySQL log and especially in /var/log/dmesg or /var/log/messages. Sometimes, not often, Linux kernel is capable of noticing potential hardware problems. If mysql server crashes after number of connections has increased, it could be hardware, e.g. RAM or cache ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 2013 at line 13: Lost connection during query
Hello all, i am experiencing the odd problem of 'lost connection to MySQL server during query'. This is happening because my mysqld server (for some reason) restarts while i am accesing it. I am using 2 SQL queries to reproduce the problem i have and decouple it from my C++ application. I have the queries in ascii files and try to upload them using the mysql client. I think one important hint is that i can upload queries 1 and 2 (or 2 and 1) if i have them in separate files and issue the commands mysql -u uploader -p < query1.sql mysql -u uploader -p < query2.sql but it fails if i have both queries in a single file and issue mysql -u uploader -p < query1and2.sql !!! Please also notice that in the hostname.err file (listed below) the SQL query that causes the problem is half-written (I do not know that it means, if anything. I do know however that my original query is correct). - I am using a RehHat LINUX 7.2, kernel 2.4.7-10. I have installed MySQL 3.23.47 RPMs from MySQL site Below, you can find : -- the output of the mysqladmin variables command -- an example of my *.err file Also, -- the ascii file with the 2 queries i use to upload some data can be found at http://www.cc.uoa.gr/~candreop/SQLmin2.sql *** Any help will be very deeply appreciated ***, Costas Andreopoulos <[EMAIL PROTECTED]> PS. I hope i supplied enough input / i am not a dbase expert. - The output of mysqladmin variables: - +-+-+ | Variable_name | Value | | | +-+-+ | back_log| 50 | basedir | / | binlog_cache_size | 32768 | character_set | latin1 | character_sets | latin1 big5 czech euc_kr gb2312 gbk sjis tis620 |ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 |estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 | concurrent_insert | ON | connect_timeout | 5 | datadir | /var/lib/mysql/ | delay_key_write | ON | delayed_insert_limit| 100 | delayed_insert_timeout | 300 | delayed_queue_size | 1000 | flush | OFF | flush_time | 0 | have_bdb| NO | have_gemini | NO | have_innodb | NO | have_isam | YES | have_raid | NO | have_openssl| NO | init_file | | interactive_timeout | 28800 | join_buffer_size| 131072 | key_buffer_size | 8388600 | language| /usr/share/mysql/english/ | large_files_support | ON | locked_in_memory| OFF | log | OFF | log_update | OFF | log_bin | OFF | log_slave_updates | OFF | log_long_queries| OFF | long_query_time | 10 | low_priority_updates| OFF | lower_case_table_names | 0 | max_allowed_packet | 1048576 | max_binlog_cache_size | 4294967295 | max_binlog_size | 1073741824 | max_connections | 100 | max_connect_errors | 10 | max_delayed_threads | 20 | max_heap_table_size | 16777216 | max_join_size | 4294967295 | max_sort_length | 1024 | max_user_connections| 0 | max_tmp_tables | 32 | max_write_lock_count| 4294967295 | myisam_max_extra_sort_file_size | 256 | myisam_max_sort_file_size | 2047 | myisam_recover_options | 0 | myisam_sort_buffer_size | 8388608 | net_buffer_length | 16384 | net_read_timeout| 30 | net_retry_count | 10 | net_write_timeout | 60 | open_files_limit| 0 | pid_file| /var/lib/mysql/daedalus.phys.uoa.gr.pid | port
Re: mysqld crash & stack trace from 3.23.47-max (with InnoDB)
On Monday 04 February 2002 02:30 am, Jeremy Zawodny wrote: > 0x807bb5f handle_segfault__Fi + 383 > 0x82a94aa pthread_sighandler + 154 > 0x7cb80076 __evoke_link_warning_llseek + 1954074198 > 0x7cb7fe19 __evoke_link_warning_llseek + 1954073593 > 0x7cb713e6 __evoke_link_warning_llseek + 1954013638 > 0x7c97db8b __evoke_link_warning_llseek + 1951967595 > 0x7c980668 __evoke_link_warning_llseek + 1951978568 > 0x7c981200 __evoke_link_warning_llseek + 1951981536 > 0x7c96dee4 __evoke_link_warning_llseek + 1951902916 > 0x82ddd0a gethostbyaddr_r + 346 > 0x82ddb44 gethostbyaddr + 196 > 0x807ff98 ip_to_hostname__FP7in_addrPUi + 232 > 0x808082c check_connections__FP3THD + 152 > 0x8080c79 handle_one_connection__FPv + 321 This does look like a libc bug. How did you build either one of the binaries? -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA <___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
