Re: MySQL 3.23.31 configure fails with Berkeley DB 3.2.3h
Matt Wagner wrote: > > Greg Cope writes: > > Chris Johnson wrote: > > > > > > >Description: > > > I just downloaded MySQL 3.23.31 and the "patched version" of > > > Berkeley DB 3.2.3h from the www.mysql.com site. I ran configure > > > with the option to enable the Berkeley DB, but it fails, telling > > > me I don't have the proper version of the DB. Here are the last > > > few lines from the configure output: > > > > This sounds similar to a problem that I reported a few hours ago to this > > list. > > > > Monty, MySQL dev team, any ideas ? > > I've forwarded Chris's report to bugs@. > Thanks Greg > Regards, > > Matt > > -- >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ > /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA ><___/ Developer > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: copying table
Read the manual on INSERT statement. You can INSERT and SELECT at the same time. Alejandro Lujan Toro wrote: > > I have a calendar db, and in there a base table (with > holidays and such). I need to create a table, exactly the > same as the base (data included). Is there an easy way of > doing this?.. > > > Alejandro Lujan Toro > CAI: Centro de Aplicación de la Informática > Email: [EMAIL PROTECTED] > Universidad Catolica Andres Bello > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: PHP and MySQL combo
ps -ef|grep -c mysql Subtract 3 from this as this is the default number of daemons that start. One is spawned for each new child. Yes, if the php script terminates, the mysql child will also terminate. This is not the behaviour with persistant connections though. Please move this over to the php list as it does not have anything to do with mysql as such. Mike Yuen wrote: > > Is there anyway to tell how many connections are currently being served by > MySQL. I'm using this in combination with PHP. Also, does MySQL > automatically shut down when you leave the page? I'm not using > mysql_pconnect - just the regular mysql_connect. > > Thanks, > Mike > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP and MySQL combo
Mike Yuen writes: > Is there anyway to tell how many connections are currently being served by > MySQL. I'm using this in combination with PHP. Also, does MySQL > automatically shut down when you leave the page? I'm not using > mysql_pconnect - just the regular mysql_connect. Hi! You are probably looking for 'SHOW STATUS': http://www.mysql.com/doc/S/H/SHOW_STATUS.html And yes, if you are NOT using mysql_pconnect, the connection to your mysqld is closed each time. The 'p' in 'mysql_pconnect' is for "persistant" which avoids this problem. :) Regards, Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 me please !!
I use mysql-jdbc-java. I connect java with my database and I've this message : DBLocationHandler: Figuring out the locations and names! (This is a one-time operation!) *** ERROR *** DBLocationHandler:SQL Exception: Column Index out of range * java.sql.SQLException: Column Index out of range at org.gjt.mm.mysql.ResultSet.getString(ResultSet.java) at org.gjt.mm.mysql.ResultSet.getFloat(ResultSet.java) at com.bbn.openmap.layer.location.db.LocationData.(LocationData.java:70) at com.bbn.openmap.layer.location.db.DBLocationHandler.createData(DBLocationHandler.java:222) at com.bbn.openmap.layer.location.db.DBLocationHandler.get(DBLocationHandler.java:300) at com.bbn.openmap.layer.location.LocationLayer.prepare(LocationLayer.java:387) at com.bbn.openmap.layer.location.LocationLayer$LocationWorker.construct(LocationLayer.java:148) at com.bbn.openmap.util.SwingWorker$2.run(SwingWorker.java:105) at java.lang.Thread.run(Thread.java:484) Why ? Thanks for your assistance.
Re: socket problem in red hat.
[EMAIL PROTECTED] writes: > Hi there, > I am setting up a lab on MySQL and I am not able to. > Its a red hat 7.0 server and has PHP installed and working with apache. > I installed MySQL from the very RPMs Red Hat provided. > Whenever I try to start the server, I get the error message: > > Can't connect to local MySQL server through socket '/var/lib/mysql/m > ysql.sock' (111) > > Well the file /var/lib/mysql/mysql.sock exists on the computer. I can't > understand what this socket problem is and I went through all documentation > and couldn't find a solution to this. Can you please provide a solution to > this > at the earliest. I have students piling on my head and I have already > skipped my deadline of setting the server up. Hi! We have seen this problem (although I have not personally investigated) with many RH7+default_mysql. The quick and easy solution (until I figure out further) is to download the MySQL RPMs from: http://www.mysql.com/downloads/mysql-3.23.html Uninstall the standard RedHat 7.0 MySQL RPMs, then reinstall ours. Like I said, I'm not sure what RedHat is doing wrong with their MySQL RPMs... But I have seen this numerous times with regard to their supplied RPMs. Something is amiss. I will investigate more. Regards, Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: you can tell
john1 writes:
> dear Sir :
>
> MySQL 3.22 on my linux 486 PC seems work so good. when I compile
> a simple C API programe which catched from the MySQL tutorial, it
> chokes at the end of compile process . the programe is as follows:
>
> #include
> #include
>
> #define def_host_name NULL
> #define def_user_name NULL
> #define def_password NULL
> #define def_db_name NULL
>
> MYSQL *conn;
> int main(int argc,char *argv[])
> {
> conn=mysql_init(NULL);
> mysql_real_connect(
> conn,
> def_host_name,
> def_user_name,
> def_password,
> def_db_name,
> 0, /*port defaut*/
> NULL, /*socket default*/
> 0); /*flag*/
> mysql_close(conn);
> exit(0);
> }
>
> I compile as follows:
>
> gcc -o client my_simplest_prog -I/home/MySQL/MySQL/include \
>-L/home/MySQL/MySQL/lib \
> -lmysqlclient
>
> then I get :
>
> /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
> my_open.o(.text+0x14):undefined reference to 'open64'
> /home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format':
> mf_format.o(.text+0x201):undefined reference to '__lxstat64'
> /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
> my_open.o(.text+0x21):undefined reference to 'fopen64'
>
> nothing left to do with the situation, I beg your help. anyway I'm a
> newcomer. thank you very much.
>
> please send message to [EMAIL PROTECTED]
>
>
>
Hi!
Your glibc is too old !
Which version is it anyway ??
Also use our 3.23 client libs. It works just fine with 3.22 server.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
isamchk error
Hi
Can anybody tell me what this error means
user@server#isamckh -av {database}/*.ISM
isamchk: error: 22 when opening ISAM-table '{database}/tax.ISM'(all
tables)
System is RedHat 7.0 i386 SMP Standard Kernel
mysql-3.22.32 standard compile from source --prefix=/usr/local
Ive tried with/without large file support.
The database otherwise works fine. It was created from a mysqldump
from another server running exactly the same setup.
perror reports "Invalid Argument"
Any clues?
Stuart Fox
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 3.23.31 configure fails with Berkeley DB 3.2.3h
Hi! > "Chris" == Chris Johnson <[EMAIL PROTECTED]> writes: >> Description: Chris> I just downloaded MySQL 3.23.31 and the "patched version" of Chris> Berkeley DB 3.2.3h from the www.mysql.com site. I ran configure Chris> with the option to enable the Berkeley DB, but it fails, telling Chris> me I don't have the proper version of the DB. Here are the last Chris> few lines from the configure output: Chris> checking for pthread_attr_setscope... yes Chris> checking can netinet files be included... yes Chris> checking character sets... default: latin1; compiled in: latin1 Chris> checking for BerkeleyDB... supplied Chris> configure: error: didn't find valid BerkeleyDB: '/usr/local/BerkeleyDB.3.2' doesn't look like a BDB directory (invalid version 3.2.3 (must be at least version 3.2.3g)) >> How-To-Repeat: Chris> Install from above named source distributions. Build BDB and then Chris> try to configure MySQL with it. >> Fix: Chris> It can probably be hacked to make it work, but should not need to. The fix is to do the following command: replace 'DB_VERSION_STRING.*g' 'DB_VERSION_STRING.*h' -- configure This will be fixed in next MySQL version. (We will just wait a few days before doing this to ensure that there isn't any more similar bugs in 3.23.31) We are also just about to start build a binaries of MySQL with BDB tables... Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Select statement that will only take the last submitted entryof it's kind in a certain column.
>I have a table called CONTENT. Columns called ID (primarykey), DOCUMENT >(varchar(50)), DESCRIPTION (text). People submit files to our intranet and >we collect info. about them in this table. If people have made changes to >the doc. they just resubmit it to the intranet. So there can be many records >with the same DOCUMENT value. What I need help with is when I do a select >statement to view the docs submitted. I only want to select the last record >entered with the same name in the DOCUMENT column to my webpage. Can you >help me with this? > Sir, if you have a date field, end your SELECT with ORDER BY date_field DESC LIMIT 1; Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MAX record on GROUPS
>This gives me one instance of each file name in the DOCUMENTS column >submitted into the database. The only thing though is it gives me the >oldest of the file name in the DOCUMENTS column which are submitted. Any >ideas how to get the newest one? I've tried adding: , MAX(ID) after the >SELECT *. It still gives me the oldest ones submitted. > >NOTE: ID is my unique id column(primary key). > >SELECT * > FROM content > WHERE dtype ='Events' and Department ='Marketing' > GROUP BY Document > ORDER BY cdate DESC Sir, the problem is that MySQL doesn't get the other values from the same row it got Max(ID) from. It is returning values from the first row of each group. (ORDER BY has no effect, since it is applied after the GROUP BY.) I've got a description of this problem and two workarounds at http://users.starpower.net/rjhalljr. Click on MySQL on the sidebar, click on MySQL SQL, and look for the first topic in the Aggregate Function section of the Strictly SQL section. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 Question
>Hi. > >On Thu, Jan 18, 2001 at 05:39:25PM -0500, [EMAIL PROTECTED] wrote: > > > > How can I do the following: > > > > update location set location.city_id = location_city.city_id where > > location.city = location_city.name; > > > > I want to update one field in a table with values from another table. Is > > this possible within MySQL or do I need to write some code to do this. > >It is not yet possible (but planned for 4.0), so you have to write >some work-around for it. Sir, for a possible work-around, go to my website at http://users.starpower.net/rjhalljr. Click on MySQL on the side bar, and then click on MySQL SQL. Look for the Update using other tables topic in the Strictly SQL section. You will have to insert the data into a temp table, and then REPLACE from the temp table. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: What degree of concurrency does MySQL support?
>We are thinking of moving to MySQL. We have a table of several tens >of millions of rows, with two indices, which will be accessed by >roughly 100 different processes. At any one time, 5 or so of the >processes will be doing selects on the table, while 40 or so will be >doing updates. However, no two processes will ever try to update the >same row at once. > >Can MySQL handle this efficiently and without allowing the table or >indices to become corrupt? > >(The total throughput we need is on the order of 100 indexed updates >per second; currently we are running a single 900 MHz Athlon with generic >IDE disk but would buy more processors if it would help). MySQL has only table level locking, which means that each update will lock the entire table, which means that updates must be done one at a time. There are a couple of open source extensions of MySQL that are supposed to offer row level locking, but these aren't available yet. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.31 configure fails with Berkeley DB 3.2.3h
> >Description: > I just downloaded MySQL 3.23.31 and the "patched version" of > Berkeley DB 3.2.3h from the www.mysql.com site. I ran configure > with the option to enable the Berkeley DB, but it fails, telling > me I don't have the proper version of the DB. Here are the last > few lines from the configure output: > > checking for BerkeleyDB... supplied > configure: error: didn't find valid BerkeleyDB: '/usr/local/BerkeleyDB.3.2' >doesn't look like a BDB directory (invalid version 3.2.3 (must be at least version >3.2.3g)) Yes, this configure bug slipped through due to an international conspiracy. But the resistance is still powerful, as evidenced by this patch: --- acinclude.m4Thu Jan 18 22:26:20 2001+++ /tmp/acinclude.m4 Fri Jan 19 13:58:24 2001 @@ -823,12 +823,12 @@ bdb_version_ok=yes # This is ugly, but about as good as it can get elif test $db_major -eq 3 && test $db_minor -eq 2 && test $db_patch -eq 3 &&\ - grep 'DB_VERSION_STRING.*g: ' [$1] > /dev/null + grep 'DB_VERSION_STRING.*h: ' [$1] > /dev/null then bdb_version_ok=yes else bdb_version_ok="invalid version $db_major.$db_minor.$db_patch" -bdb_version_ok="$bdb_version_ok (must be at least version 3.2.3g)" +bdb_version_ok="$bdb_version_ok (must be least version 3.2.3h)" fi ]) Sorry about that. Tim -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Tim Smith <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Development Team /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland (for a few weeks) <___/ 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
forcing tcp/ip connect when connecting to localhost
Hi all, can I force the mysql clients to use a tcp/ip connect if connecting to 'localhost'? This need stems from the following situation: I have an ssh account and a mysql DB on one host at my isp. The db can only be accessed from 'localhost', not from any other. I use an ssh tunnel to forward the local port 3306 to my isp machine: ssh -L 3306:localhost:3306 [EMAIL PROTECTED] sleep 10m ssh binds only to the localhost interface (127.0.0.1). So now I need to connect to 127.0.0.1, but through TCP/IP instead of using sockets. Any idea? Thanks in advance, Ben -- Ben Peter ph. +49-(0)173-9262278 fax +49-(0)89-1488-216649 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
checking table "fullness"
I need to test the relative "fullness" of a given table relative to its maximum size on the OS. I am doing everything through the C API. What I would like is to be able to ask is, how full is table "bletch?", and get back something like 87%. The reason I am doing this is that I am dealing with huge amounts of data whereby a given table, if used in the traditional way, could easily exceed the maximum on the filesystem. I understand that other database management systems spread the table across files so this is not a problem. I am more than willing to manage "concatenated" tables myself through the C API, but I want to be able to detect that I am getting near the limit without just "hitting the wall" on an INSERT. Is there some way to do this? Thanks. Dean Hoover PS. By the way, what errno is returned when I do "hit the wall" on an INSERT? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: forcing tcp/ip connect when connecting to localhost
Normally connecting to the true DNS hostname or the ip address of the machine will do the trick. Connecting to localhost will connect via the loopback address of 127.0.0.1. -- Richard Ellerbrock [EMAIL PROTECTED] >>> Ben Peter <[EMAIL PROTECTED]> 2001/01/19 02:19:47 >>> Hi all, can I force the mysql clients to use a tcp/ip connect if connecting to 'localhost'? This need stems from the following situation: I have an ssh account and a mysql DB on one host at my isp. The db can only be accessed from 'localhost', not from any other. I use an ssh tunnel to forward the local port 3306 to my isp machine: ssh -L 3306:localhost:3306 [EMAIL PROTECTED] sleep 10m ssh binds only to the localhost interface (127.0.0.1). So now I need to connect to 127.0.0.1, but through TCP/IP instead of using sockets. Any idea? Thanks in advance, Ben -- Ben Peter ph. +49-(0)173-9262278 fax +49-(0)89-1488-216649 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: checking table "fullness"
I am not 100% sure I understand you but I presume you are talking about the 2Gig file size limit of some OS'es? If this is the case, just find out where MySQL stores its databases and have a look at the filesize - you are using the C API, so doing a call to get this info should be trivial. Databases are usually stored in /var/lib/mysql on Linux and each database is just a subdirectory in this directory. So check the filesize and just roll-over the database yourself when you reach a self imposed limit. Also, have you looked at LFS support for your OS. Redhat ships kernels with LFS support. You just need to know where to find them! Also what about RAID tables? -- Richard Ellerbrock [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 2001/01/19 02:22:18 >>> I need to test the relative "fullness" of a given table relative to its maximum size on the OS. I am doing everything through the C API. What I would like is to be able to ask is, how full is table "bletch?", and get back something like 87%. The reason I am doing this is that I am dealing with huge amounts of data whereby a given table, if used in the traditional way, could easily exceed the maximum on the filesystem. I understand that other database management systems spread the table across files so this is not a problem. I am more than willing to manage "concatenated" tables myself through the C API, but I want to be able to detect that I am getting near the limit without just "hitting the wall" on an INSERT. Is there some way to do this? Thanks. Dean Hoover PS. By the way, what errno is returned when I do "hit the wall" on an INSERT? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
locks, memory and threads
Hello, I have a problem with mysql 3.23.30-gamma. On the busy days with much traffic on t he website, it hapens that suddenly mysql is taking all the resources of the machine at very high speed. The swap increases quick, the threads increase from about 30 (which is average) to over 70 and if we don't stop mysql quickly, the computer stops responding. This happens allways in the busiest hours of the day. We are using mysql as database for a web site and use it in combination with Apache::Session, which has a mechanism for locking session info with GET_LOCK and RELEASE_LOCK. At the moment that mysql is taking all the resources, apache is sending many concurrent replies (about 45, relatively high), and after stopping mysql (which can take long), several GET_LOCK-query appear in the slow-query-logfile (about 20). I have studied the problem several days, but can't find any clues so far. I wonder whether the lock-mechanism could be the cause, or could it be the consequence of a very very very heave query that never appears in the slowlog I hope you can give me answers to the following: 1. is there any known problem with GET_LOCK and RELEASE_LOCK in version 3.23.30 ? 2. Is the GET_LOCK-mechanism the most suitable one to use with Apache::Session ? 3. Do you have any idea's what the problem could be or how to investigate or how to solve ? Thanks ! Herald van der Breggen P.S. I upgraded today to version 3.23.31, so far without problems, but the traffic very low at the moment. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.31 configure fails with Berkeley DB 3.2.3h
Thimble Smith wrote: > > > >Description: > > I just downloaded MySQL 3.23.31 and the "patched version" of > > Berkeley DB 3.2.3h from the www.mysql.com site. I ran configure > > with the option to enable the Berkeley DB, but it fails, telling > > me I don't have the proper version of the DB. Here are the last > > few lines from the configure output: > > > > checking for BerkeleyDB... supplied > > configure: error: didn't find valid BerkeleyDB: '/usr/local/BerkeleyDB.3.2' >doesn't look like a BDB directory (invalid version 3.2.3 (must be at least version >3.2.3g)) > > Yes, this configure bug slipped through due to an international > conspiracy. But the resistance is still powerful, as evidenced > by this patch: > > --- acinclude.m4Thu Jan 18 22:26:20 2001+++ >/tmp/acinclude.m4 Fri Jan 19 13:58:24 2001 > @@ -823,12 +823,12 @@ > bdb_version_ok=yes ># This is ugly, but about as good as it can get >elif test $db_major -eq 3 && test $db_minor -eq 2 && test $db_patch -eq 3 &&\ > - grep 'DB_VERSION_STRING.*g: ' [$1] > /dev/null > + grep 'DB_VERSION_STRING.*h: ' [$1] > /dev/null >then > bdb_version_ok=yes >else > bdb_version_ok="invalid version $db_major.$db_minor.$db_patch" > -bdb_version_ok="$bdb_version_ok (must be at least version 3.2.3g)" > +bdb_version_ok="$bdb_version_ok (must be least version 3.2.3h)" >fi > ]) > Thanks for that. But does the conspiricy not continue ? Do you not need to patch aclocal.m4 as this contains a referance to 3.2.3g, and do the replace 'DB_VERSION_STRING.*g' 'DB_VERSION_STRING.*h' -- configure that Monty suggest to fix the congfigure script ? Greg > > Sorry about that. > > Tim > > -- >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Tim Smith <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Development Team > /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland (for a few weeks) ><___/ 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: checking table "fullness"
Richard Ellerbrock wrote: > I am not 100% sure I understand you but I presume you are talking about the 2Gig >file size limit of some OS'es? If this is the case, just find out where MySQL stores >its databases and have a look at the filesize - you are using the C API, so doing a >call to get this info should be trivial. Yes I am talking about the 2gig(solaris) or 4gig(linux) limit, and I know how to check it myself if I am running on the same server that mysql server is running on. My question is regarding running from a client on an arbitrary machine, which may *not* be directly accessible except through the mysql server. > > > Databases are usually stored in /var/lib/mysql on Linux and each database is just a >subdirectory in this directory. So check the filesize and just roll-over the database >yourself when you reach a self imposed limit. > > Also, have you looked at LFS support for your OS. Redhat ships kernels with LFS >support. You just need to know where to find them! Also what about RAID tables? > > -- > Richard Ellerbrock > [EMAIL PROTECTED] > > >>> [EMAIL PROTECTED] 2001/01/19 02:22:18 >>> > I need to test the relative "fullness" of a given table > relative to its maximum size on the OS. I am doing > everything through the C API. What I would like is > to be able to ask is, how full is table "bletch?", and get back > something like 87%. > > The reason I am doing this is that I am dealing with > huge amounts of data whereby a given table, if used > in the traditional way, could easily exceed the maximum > on the filesystem. I understand that other database > management systems spread the table across files > so this is not a problem. I am more than willing to > manage "concatenated" tables myself through the > C API, but I want to be able to detect that I am getting > near the limit without just "hitting the wall" on an > INSERT. > > Is there some way to do this? > > Thanks. > > Dean Hoover > > PS. By the way, what errno is returned when I do "hit the > wall" on an INSERT? > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: checking table "fullness"
>Richard Ellerbrock wrote: > >> I am not 100% sure I understand you but I presume you are talking about the >2Gig file size limit of some OS'es? If this is the case, just find out where >MySQL stores its databases and have a look at the filesize - you are using the >C API, so doing a call to get this info should be trivial. > >Yes I am talking about the 2gig(solaris) or 4gig(linux) limit, and >I know how to check it myself if I am running on the same server >that mysql server is running on. My question is regarding running >from a client on an arbitrary machine, which may *not* be directly >accessible except through the mysql server. Ah, that changes things quiet a bit :-) Actually you don't even need to go to all those lengths described earlier. Just use SHOW TABLE STATUS. -- Richard Ellerbrock [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
Big trouble on W 98
Hi everybody, This my first message and I'm french so be patient with me. I have Apache, Mysql and PHP 4.0 unning on my P.C. with Windows 98. Untill soon I have no trouble. But this week mysql gone crazy. When I look with phpmyadmin to my mysql base it's seems thats mysql look on the wrong directories. But what is the most crazy is that this directory change every minutes or two minutes. Sometimes it's a directory of the windows directory some times an other !!! Do you no something about that ? Have you some suggestion to precise my problem or a solution ? Thanks for help... ... and patience ! Benoit Milgram -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
3.23.31 gives FULLTEXT problems on sparc64 Linux
Hello
After upgrading to 3.23.31, FULLTEXT selects give often "error -1 from
table handler" for me. The error log says "ft_read_first: Got error
-1 when reading table foo". I think I have not seen those for older
3.23.x versions (x=28 or so), at least not that frequently.
A small example to reproduce the error:
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (
id mediumint unsigned NOT NULL auto_increment,
tag char(6) NOT NULL default '',
value text NOT NULL default '',
PRIMARY KEY (id),
KEY kt(tag),
KEY kv(value(15)),
FULLTEXT KEY kvf(value)
) TYPE=MyISAM;
DROP TABLE IF EXISTS t2;
CREATE TABLE t2 (
id_t2 mediumint unsigned NOT NULL default '0',
id_t1 mediumint unsigned NOT NULL default '0',
field_number tinyint unsigned NOT NULL default '0',
PRIMARY KEY (id_t2,id_t1,field_number),
KEY id_t1(id_t1)
) TYPE=MyISAM;
INSERT INTO t1 (tag,value) VALUES ('foo123','bar1');
INSERT INTO t2 VALUES (2231626,64280,0);
INSERT INTO t1 (tag,value) VALUES ('foo123','bar2');
INSERT INTO t2 VALUES (2231626,64281,0);
SELECT DISTINCT t2.id_t2
FROM t2, t1
WHERE MATCH (t1.value) AGAINST ('baz')
AND t1.id = t2.id_t1;
The error occurs during final SELECT. I've seen it only for FULLTEXT
searches; if I use e.g. "WHERE t1.value LIKE 'baz%' in that statement,
everything works fine.
P.S. Self-compiled 3.23.31 on sparc64 Linux (Debian stable).
cheers
--
TS
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
bug in 3.23.22-beta
Hello list,
I am wondering if this bug I found in 3.23.22-beta is a known bug that has
been fixed in laater servers.
How to replicate:
create table test_bug (
text_field varchar(20) NOT NULL,
date_field timestamp(14)
);
insert into test_bug (text_field,date_field) values
('foo','2001010708');
update test_bug set text_field = 'bar' where text_field = 'foo';
select * from test_bug;
And the result:
+-+
| text field | date_field |
+-+
| bar| 20010119082332 |
+++
As you can see the date field has been updated to the current date/time even
though the update query was only supposed to modify the text field. For
claarity the date field started out with 2001-01-07 08:00:00 and ended up
with 2001-01-19 08:23:32 (the time I tested this bug).
Can somebody let me know if this bug exists in the newer 3.23 servers?
Thanks
-Marc-
#/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/#
#Marc Swanson | \|||/ #
#MSwanson Consulting | /o o\ #
#Phone: (603)868-1721|-oooOooo-#
#Fax:(603)868-1730| Solutions in: #
#[EMAIL PROTECTED] | 'PHP'Perl #
# | 'SQL'C++ #
# | 'HTML 'Sh/Csh#
# http://www.mswanson.com | 'Javascript#
#/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/#
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connection Refused
[EMAIL PROTECTED] wrote: > > The grant was done by: > > # echo "grant INSERT,SELECT on snort.* to > snortdb@'XXX.XXX.0.0/255.255.0.0';" | mysql -u root -p > > The system has TCP wrappers setup and the hosts.allow file is empty and > hosts.deny is set to ALL:ALL. next time I'm at work I'll try putting in > hosts.allow the ip address of the sensor and see what happens. Inetd and TCP wrappers have nothing to do with mysqld. Mysqld is a standalone server, and must be started separately. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: bug in 3.23.22-beta
That's no bug. That is what timestamp is, current date and current time no
matter whether you insert or update. Read the manual more carefully. What
I think you want is date column, not timestamp.
- Original Message -
From: "Marc Swanson" <[EMAIL PROTECTED]>
To: "mysql list" <[EMAIL PROTECTED]>
Sent: Friday, January 19, 2001 21:43
Subject: bug in 3.23.22-beta
> Hello list,
>
> I am wondering if this bug I found in 3.23.22-beta is a known bug that has
> been fixed in laater servers.
>
> How to replicate:
>
> create table test_bug (
> text_field varchar(20) NOT NULL,
> date_field timestamp(14)
> );
>
> insert into test_bug (text_field,date_field) values
> ('foo','2001010708');
> update test_bug set text_field = 'bar' where text_field = 'foo';
>
> select * from test_bug;
>
> And the result:
>
> +-+
> | text field | date_field |
> +-+
> | bar| 20010119082332 |
> +++
>
>
> As you can see the date field has been updated to the current date/time
even
> though the update query was only supposed to modify the text field. For
> claarity the date field started out with 2001-01-07 08:00:00 and ended up
> with 2001-01-19 08:23:32 (the time I tested this bug).
>
> Can somebody let me know if this bug exists in the newer 3.23 servers?
>
>
> Thanks
>
> -Marc-
>
>
> #/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/#
> #Marc Swanson | \|||/ #
> #MSwanson Consulting | /o o\ #
> #Phone: (603)868-1721|-oooOooo-#
> #Fax:(603)868-1730| Solutions in: #
> #[EMAIL PROTECTED] | 'PHP'Perl #
> # | 'SQL'C++ #
> # | 'HTML 'Sh/Csh#
> # http://www.mswanson.com | 'Javascript#
> #/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/#
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> 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: isamchk error
Stuart Fox wrote:
>
> Hi
>
> Can anybody tell me what this error means
>
> user@server#isamckh -av {database}/*.ISM
>
> isamchk: error: 22 when opening ISAM-table '{database}/tax.ISM'(all
> tables)
>
If this was part of a script, then database was a variable that
contained the full
path to the database, and ${database} would expand to its value.
The line would have been:
isamchk -av ${database}/*.ISM
There is no directory named {database}
Replace {database} with the full path to the database.
EX:
isamchk -av /usr/local/mysql/data/mydatabase/*.ISM
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: bug in 3.23.22-beta
Hi, > That's no bug. That is what timestamp is, current date and current time no > matter whether you insert or update. Read the manual more carefully. What > I think you want is date column, not timestamp. If you really do want to store an actual timestamp figure in your table without it being updated every time the record is modified, then you can use an INT column type. However, I agree with the above - you should use a DATE or DATETIME field instead. You can always easily output one of these column types as a timestamp value with the UNIX_TIMESTAMP() function. Regards, Basil Hussain ([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
Bug with Apache
>Description: when i compile apache and php4 with mysql and postgresql support i have this error for mysql This is the error # <=== src/modules gcc -c -I./os/unix -I./include -DLINUX=2 -I/usr/src/php-4.0.4pl1 -I/usr/src/php-4.0.4pl1/main -I/usr/src/php-4.0.4pl1/main\ -I/usr/src/php-4.0.4pl1/Zend -I/usr/src/php-4.0.4pl1/Zend -I/usr/src/php-4.0.4pl1/TSRM -I/usr/src/php-4.0.4pl1/TSRM -I/usr/s\ rc/php-4.0.4pl1 -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED `./apaci` modules.c gcc -c -I./os/unix -I./include -DLINUX=2 -I/usr/src/php-4.0.4pl1 -I/usr/src/php-4.0.4pl1/main -I/usr/src/php-4.0.4pl1/main\ -I/usr/src/php-4.0.4pl1/Zend -I/usr/src/php-4.0.4pl1/Zend -I/usr/src/php-4.0.4pl1/TSRM -I/usr/src/php-4.0.4pl1/TSRM -I/usr/s\ rc/php-4.0.4pl1 -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED `./apaci` buildmark.c gcc -DLINUX=2 -I/usr/src/php-4.0.4pl1 -I/usr/src/php-4.0.4pl1/main -I/usr/src/php-4.0.4pl1/main -I/usr/src/php-4.0.4pl1/Zend\ -I/usr/src/php-4.0.4pl1/Zend -I/usr/src/php-4.0.4pl1/TSRM -I/usr/src/php-4.0.4pl1/TSRM -I/usr/src/php-4.0.4pl1 -DUSE_EXPAT -\ I./lib/expat-lite -DNO_DL_NEEDED `./apaci`\ -o httpd buildmark.o modules.o modules/standard/libstandard.a modules/php4/libphp4.a main/libmain.a ./os/unix/libos.a a\ p/libap.a lib/expat-lite/libexpat.a -Wl,-rpath,/usr/local/mysql/lib -Wl,-rpath,/usr/local/pgsql/lib -rdynamic -L/usr/local\ /mysql/lib -L/usr/local/pgsql/lib -Lmodules/php4 -L../modules/php4 -L../../modules/php4 -lmodphp4 -lpam -ldl -lpq -lmysqlcl\ ient -lresolv -lm -ldl -lcrypt -lnsl -lresolv -lm -lcrypt /usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0x97): undefined reference to `uncompress' /usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x12b): undefined reference to `compress' collect2: ld returned 1 exit status make[2]: *** [target_static] Error 1 make[2]: Leaving directory `/usr/src/apache_1.3.14/src' make[1]: *** [build-std] Error 2 make[1]: Leaving directory `/usr/src/apache_1.3.14' make: *** [build] Error 2 ## Command compiler for Apache before compiled php4 ./configure --prefix=/usr/local/apache Command compiler for php4 ./configure --with-apache=/usr/src/apache_1.3.14 --enable-track-vars --with-mysql=/usr/local/mysql --with-pgsql=/usr/local/pgsql Command compiler for Apache after compiled php4 ./configure --activate-module=src/modules/php4/libphp4.a ## Release: mysql-3.23.30-gamma (Official MySQL binary) >Environment: System: Linux kenny 2.2.14-5.0 #1 Tue Mar 7 20:53:41 EST 2000 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O6 -mpentium -fomit-frame-pointer' CXX='gcc' CXXFLAGS='-O6 -mpentium -fomit-frame-poin\ ter -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 13 Nov 28 23:48 /lib/libc.so.6 -> libc-2.1.3.so -rwxr-xr-x1 root root 4101324 Feb 29 2000 /lib/libc-2.1.3.so -rw-r--r--1 root root 20272704 Feb 29 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Feb 29 2000 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=comple\ x --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared Perl: This is perl, version 5.005_03 built for i386-linux Thanks and regards *** Simone Gommaraschi I.NET S.p.A. e-mail: [EMAIL PROTECTED] - High Quality Access to the Internet Via Caldera, 21/D - 20153 Milano - Direzione Tecnica - Housing Group Tel. 02-409061 / Fax. 02-40906303 Home Page URL: http://www.inet.it *** I.NET e' associata ad AIIP (Associazione Italiana Internet Providers) *** PGP Key - http://www.programmi.to/key/public.asc *** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql@lists.mysql.com
>Description: when i compile apache and php4 with mysql and postgresql support i have this error for mysql # <=== src/modules gcc -c -I./os/unix -I./include -DLINUX=2 -I/usr/src/php-4.0.4pl1 -I/usr/src/php-4.0.4pl1/main -I/usr/src/php-4.0.4pl1/main -I/usr/src/php-4.0.4pl1/Zend -I/usr/src/php-4.0.4pl1/Zend -I/usr/src/php-4.0.4pl1/TSRM -I/usr/src/php-4.0.4pl1/TSRM -I/usr/src/php-4.0.4pl1 -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED `./apaci` modules.c gcc -c -I./os/unix -I./include -DLINUX=2 -I/usr/src/php-4.0.4pl1 -I/usr/src/php-4.0.4pl1/main -I/usr/src/php-4.0.4pl1/main -I/usr/src/php-4.0.4pl1/Zend -I/usr/src/php-4.0.4pl1/Zend -I/usr/src/php-4.0.4pl1/TSRM -I/usr/src/php-4.0.4pl1/TSRM -I/usr/src/php-4.0.4pl1 -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED `./apaci` buildmark.c gcc -DLINUX=2 -I/usr/src/php-4.0.4pl1 -I/usr/src/php-4.0.4pl1/main -I/usr/src/php-4.0.4pl1/main -I/usr/src/php-4.0.4pl1/Zend -I/usr/src/php-4.0.4pl1/Zend -I/usr/src/php-4.0.4pl1/TSRM -I/usr/src/php-4.0.4pl1/TSRM -I/usr/src/php-4.0.4pl1 -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED `./apaci`\ -o httpd buildmark.o modules.o modules/standard/libstandard.a modules/php4/libphp4.a main/libmain.a ./os/unix/libos.a ap/libap.a lib/expat-lite/libexpat.a -Wl,-rpath,/usr/local/mysql/lib -Wl,-rpath,/usr/local/pgsql/lib -rdynamic -L/usr/local/mysql/lib -L/usr/local/pgsql/lib -Lmodules/php4 -L../modules/php4 -L../../modules/php4 -lmodphp4 -lpam -ldl -lpq -lmysqlclient -lresolv -lm -ldl -lcrypt -lnsl -lresolv -lm -lcrypt /usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0x97): undefined reference to `uncompress' /usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x12b): undefined reference to `compress' collect2: ld returned 1 exit status make[2]: *** [target_static] Error 1 make[2]: Leaving directory `/usr/src/apache_1.3.14/src' make[1]: *** [build-std] Error 2 make[1]: Leaving directory `/usr/src/apache_1.3.14' make: *** [build] Error 2 ## >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release: mysql-3.23.30-gamma (Official MySQL binary) >Environment: System: Linux kenny 2.2.14-5.0 #1 Tue Mar 7 20:53:41 EST 2000 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O6 -mpentium -fomit-frame-pointer' CXX='gcc' CXXFLAGS='-O6 -mpentium -fomit-frame-pointer -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 13 Nov 28 23:48 /lib/libc.so.6 -> libc-2.1.3.so -rwxr-xr-x1 root root 4101324 Feb 29 2000 /lib/libc-2.1.3.so -rw-r--r--1 root root 20272704 Feb 29 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Feb 29 2000 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Crashing MySQL on FreeBSD4.2 with Apache/php4
Hi again Now i've tried running with the 3.23.26-beta from the ports tree for a couple of days, and the server has got a lot more stable, but stil we experience appox. 20 restarts a day. Furthermore we are getting a lot of these: Aborted connection 64 to db: 'username' user: 'testuser' host: `localhost' (Got an error reading communicatio n packets) Any other ideas? -Original Message- From: Danny [mailto:[EMAIL PROTECTED]] Sent: 16. januar 2001 02:15 To: Nicolai Gylling; '[EMAIL PROTECTED]' Subject: Re: Crashing MySQL on FreeBSD4.2 with Apache/php4 Hallo - Just out of interest . Did you install MySQL on FREEBSD using www.freebsd.org/ports if you didnt I highly recom,mend you should. Looking forward to your feedback. dannyh [EMAIL PROTECTED] On Tue, 16 Jan 2001, Nicolai Gylling wrote: > Hi > > I'm currently running a FreeBSD4.2-Stable server with > Apache1.3.14/PHP4.0.4pl1 and MySQL 3.23.27-Beta. > > The problem is that MySQL is crashing constantly, sometimes several times > each minute. I've been through all the "What to do if mysql keeps crashing" > steps in the MySQL-documentation, but nothing helped. My research has come > up with suggestions regarding the threads in FreeBSD4.2 and sessionhandling > in PHP. > > Is there anyone who has had similar problems, or might know what to do? > > Nicolai Gylling > > System Administrator | [EMAIL PROTECTED] | http://www.neoideo.com > Neo Ideo A/S | Galionsvej, Bygning 156 | DK-1437 Copenhagen K. > Phone: +45 7020 2414 | Direct: +45 7730 4300 | Telefax: +45 7020 2415 | > Mobile: +45 2098 5543 > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: A new engine under MySQL with trx & row-level locking
Hi! I hope that this message goes to the right 'thread' in the mailing list; not replied to a thread before. Monty recommended that we should wait still for a few weeks before releasing MySQL 4.0/Innobase-alpha, to keep source code versions in control. But I can now report here the current status of the work, and I will post an update on this list every week. The current status of MySQL/Innobase is that it runs on Intel Windows NT and Intel Linux. It runs a shortened version of the 'bench' test suite of MySQL without errors, and also can run my own multithreaded stress tests. The current TODO list I have is the following: 1. Optimize the MySQL/Innobase interface regarding to CPU time, and add support for small, less than 7.5 kB BLOBS. 2. Test correct handling of all MySQL data types and the SQL NULL value. 3. Give appropriate information to the MySQL query optimizer about table sizes, and also to users about the file space occupied by each table, index, and other data structures. 4. Tell the MySQL query optimizer if a secondary index contains all the required columns: no need then to search the clustered index (in Innobase every table has a clustered index where the data is stored, this is similar to Sybase clustered indexes). 5. Add a timeout to lock waiting: Innobase can detect and resolve deadlocks within its own lock table, but if a user uses also MySQL LOCK TABLES... or BDB locks, a deadlock can occur where Innobase does not know of all the locks: this is resolved by adding a timeout for a lock wait, say 100 s., after which the transaction is rolled back. 6. Make the (implicit) select in UPDATE TABLE ... SET ... an x-locking read, not a consistent read. 7. Interface SELECT ... FOR UPDATE and SELECT ... IN SHARE MODE to Innobase, (MySQL parser in 4.0 already knows these syntactic constructs). 8. Move the SQL NULL value as the first in the alphabetical order. 9. Prevent MySQL from using 'generate_table' in DELETE FROM ... . That is not good if we want a rollback. 10. Port to Solaris, HP-UX and all different Unix flavors. --- 11. Add support for > 7.5 kB BLOBS. 12. Writing a direct CREATE INDEX (currently MySQL internally uses ALTER TABLE if an index is created to a table already holding rows). 13. Writing a lock monitor. 14. Writing a disk i/o monitor. Items 1 - 10 mean mainly small changes in source code, and they are necessary to make the database useful. Items 11 - 14 are long-term projects. Lots of work :), but Innobase now contains 100 000 lines of C, so the above changes 1-10 might be small in proportion to the work already done. If you readers of the list have opinions, you have a chance to influence the TODO list above: I can try to mould the list according to what people feel is the most relevent thing to do. Best regards, Heikki Tuuri Innobase Oy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQL and ODBC
Firstly, you should respond to the list as you'll get a better response this way. I may not know the answer or I may not have time to answer. Did you install MyODBC? Try using that instead. That's it from, I'm on holidays for a week. Cheers Rolf - Original Message - From: "James "BUBBA" Carter" <[EMAIL PROTECTED]> To: "Rolf Hopkins" <[EMAIL PROTECTED]> Sent: Friday, January 19, 2001 22:29 Subject: Re: MYSQL and ODBC > I don't think I was clear. Let me try and start over. > > > I am an ISP. I have a Linux machine with MYSQL for my radius database. I > add and remove users my typing in a mysql statement when I log into my linux > server. > > I also have a Win2k PC at my desk for my personal computer. I am using a > billing program to bill my Internet customers each month. This program has > the ability to log into the MYSQL Linux server and add & delete users. > > However, the only way it will work is if I make my Win2k computer connect to > my linux server using ODBC. Then I can execute the mysql commands through > my billing computer. > > The reason I am wanting to do this is to save time. The billing software has > everything integrated in it. If someone new signs up, I can enter their > info one time and the billing software will add it to the necessary servers > for login, email, etc.. > > Thanks, > > James > > > > - Original Message - > From: "Rolf Hopkins" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Thursday, January 18, 2001 11:40 PM > Subject: Re: MYSQL and ODBC > > > > Sorry, I'm confused on what you have (machines? what is running on what?), > > what your ISP has and what you are trying to do. Do you know about > > phpmyadmin program? Maybe it is what you're looking for. > > > > Most importantly, why did your ISP recommend you use ODBC on a Win2k? Do > > they have some restrictions that stop you from using a linux machine, if > > that's what you want? If my ISP put restrictions like that on me, I'd be > > looking for a new ISP? > > > > I think, firstly, decide what you need/want, then find an ISP who is going > > to accomodate you and finally, if you still need assistance, ask the > list... > > > > Or, have I totally misunderstood you. > > > > Cheers > > > > Rolf > > > > - Original Message - > > From: <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Friday, January 19, 2001 13:13 > > Subject: MYSQL and ODBC > > > > > > > > > > I am running LInux and MYSQL. My billing program for my ISP has > > recommended > > > that I setup ODBC on my Win2k machine so I can execute commands to mysql > > to > > > add and remove users. The software has the commands built in, however I > > must > > > configure my server and ODBC to work for MYSQL. > > > > > > Is there any simple setup instructions that help me do this? > > > > > > Thanks, > > > > > > james > > > [EMAIL PROTECTED] > > > > > > - > > > Before posting, please check: > > >http://www.mysql.com/manual.php (the manual) > > >http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL 3.23.31 configure fails with Berkeley DB 3.2.3h
Hi ! I am trying to implement BDB tables on windows NT. I have installed mysql 3.23.31 and have downloaded Berkeley db file 3.2.3. I am new to mysql. I have tried to look for instructions but I have no luck. Thanks Irena -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 07:40 To: Chris Johnson Cc: [EMAIL PROTECTED] Subject: MySQL 3.23.31 configure fails with Berkeley DB 3.2.3h Hi! > "Chris" == Chris Johnson <[EMAIL PROTECTED]> writes: >> Description: Chris> I just downloaded MySQL 3.23.31 and the "patched version" of Chris> Berkeley DB 3.2.3h from the www.mysql.com site. I ran configure Chris> with the option to enable the Berkeley DB, but it fails, telling Chris> me I don't have the proper version of the DB. Here are the last Chris> few lines from the configure output: Chris> checking for pthread_attr_setscope... yes Chris> checking can netinet files be included... yes Chris> checking character sets... default: latin1; compiled in: latin1 Chris> checking for BerkeleyDB... supplied Chris> configure: error: didn't find valid BerkeleyDB: '/usr/local/BerkeleyDB.3.2' doesn't look like a BDB directory (invalid version 3.2.3 (must be at least version 3.2.3g)) >> How-To-Repeat: Chris> Install from above named source distributions. Build BDB and then Chris> try to configure MySQL with it. >> Fix: Chris> It can probably be hacked to make it work, but should not need to. The fix is to do the following command: replace 'DB_VERSION_STRING.*g' 'DB_VERSION_STRING.*h' -- configure This will be fixed in next MySQL version. (We will just wait a few days before doing this to ensure that there isn't any more similar bugs in 3.23.31) We are also just about to start build a binaries of MySQL with BDB tables... Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to MySQL with Visual Basic
You can also use MyVbQL.dll ... take a look at http://www.icarz.com/mysql/index.html Eric Rolf Hopkins wrote: > Someone sent me some samples of various connection type (ADO, DAO, etc) > about a month ago but I'll post off list. > > - Original Message - > From: "Dwight Mowbray" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, January 19, 2001 10:18 > Subject: Connecting to MySQL with Visual Basic > > Hi. > > Can anyone tell me how or refer me to any tutorials on how to connect to > mysql using Microsoft Visual Basic (v. 6)? > > Any help would be much appreciated. Thanks. > > Kind regards, > Dwight Mowbray. > E-commerce solutions provider. > 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.31 configure fails with Berkeley DB 3.2.3h
On Fri, Jan 19, 2001 at 12:48:44PM +, Greg Cope wrote: > > But does the conspiricy not continue ? Yes, I suppose it does. I guess my secret spy status as enemy of the state is now out in the open, plain as day. > Do you not need to patch aclocal.m4 as this contains a referance to > 3.2.3g, and do the > > replace 'DB_VERSION_STRING.*g' 'DB_VERSION_STRING.*h' -- configure > > that Monty suggest to fix the congfigure script ? If you don't have the auto* tools, then you need to fix configure. acinclude.m4 is the actual source file that is used to generate the 'configure' file. aclocal.m4 is an intermediate file that is of no consequence. Tim -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Tim Smith <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Development Team /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland (for a few weeks) <___/ 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: Crashing MySQL on FreeBSD4.2 with Apache/php4
Nicolai, As I sent you earlier, on the 17th, you MUST upgrade your FreeBSD to FreeBSD-stable of January 10th or later, or apply the patch I sent you and recompile, or use the contributed binary on the mysql web page: http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.30-gamma-unknown- freebsdelf4.2-i386.tar.gz You will keep getting seg faults unless you do one of these things. (check the output of dmesg). The FreeBSD 4.2 Release has multiple thread problems. The other message (aborted connections) is a problem with PHP, I think someone has a patch for that. Maybe they could post it here. Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "Nicolai Gylling" <[EMAIL PROTECTED]> To: "'Danny'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, January 19, 2001 9:20 AM Subject: RE: Crashing MySQL on FreeBSD4.2 with Apache/php4 > Hi again > > Now i've tried running with the 3.23.26-beta from the ports tree for a > couple of days, and the server has got a lot more stable, but stil we > experience appox. 20 restarts a day. Furthermore we are getting a lot of > these: > > Aborted connection 64 to db: 'username' user: 'testuser' host: `localhost' > (Got an error reading communicatio > n packets) > > Any other ideas? > > -Original Message- > From: Danny [mailto:[EMAIL PROTECTED]] > Sent: 16. januar 2001 02:15 > To: Nicolai Gylling; '[EMAIL PROTECTED]' > Subject: Re: Crashing MySQL on FreeBSD4.2 with Apache/php4 > > > Hallo > > - Just out of interest . > > Did you install MySQL on FREEBSD using www.freebsd.org/ports > if you didnt I highly recom,mend you should. > > Looking forward to your feedback. > > dannyh > > [EMAIL PROTECTED] > > > > > On Tue, 16 Jan 2001, Nicolai Gylling wrote: > > Hi > > > > I'm currently running a FreeBSD4.2-Stable server with > > Apache1.3.14/PHP4.0.4pl1 and MySQL 3.23.27-Beta. > > > > The problem is that MySQL is crashing constantly, sometimes several times > > each minute. I've been through all the "What to do if mysql keeps > crashing" > > steps in the MySQL-documentation, but nothing helped. My research has come > > up with suggestions regarding the threads in FreeBSD4.2 and > sessionhandling > > in PHP. > > > > Is there anyone who has had similar problems, or might know what to do? > > > > Nicolai Gylling > > > > System Administrator | [EMAIL PROTECTED] | http://www.neoideo.com > > Neo Ideo A/S | Galionsvej, Bygning 156 | DK-1437 Copenhagen K. > > Phone: +45 7020 2414 | Direct: +45 7730 4300 | Telefax: +45 7020 2415 | > > Mobile: +45 2098 5543 > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
HELP with SQL statement
I have a table called RATING and two fields one called POSITIVE and the other called NEGATIVE. I need to write an SQL statement for my mySQL database that will return the value of the total of POSITIVEs minues the total of the NEGATIVEs. Any ideas? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to use count to compare number?
dear all: I need some help from you. The dataset is as following maker pc.id a1 a2 a3 b4 b5 I need to retrieve the maker which include at least 2 pc.id. I try to write in this form, but it is error! select maker from table1 where count(pc.id) > 2 group by maker. thank you Danyu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: HELP with SQL statement
* Mike Podlesny <[EMAIL PROTECTED]> wrote on 19.01.01 17:25: > I have a table called RATING and two fields one called POSITIVE and the > other called NEGATIVE. I need to write an SQL statement for my mySQL > database that will return the value of the total of POSITIVEs minues the > total of the NEGATIVEs. Err, how about select sum(positive-negative) from rating; ? -- Tomi Junnila <[EMAIL PROTECTED]> http://www.badzilla.net/~topeju/ Electronics and Information Technology, University of Turku, Finland - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
myisampack - segmentation fault
Hy! i have some trouples to compress one table (http://www.notz.ro/table.tar.gz) with myisamcheck. myisampack always terminate with a segementation fault. here an example: istanbul:/var/mysql/sms_plus # /usr/local/mysql/bin/myisampack -vf message_archiv_25 Compressing message_archiv_25.MYD: (2135 records) - Calculating statistics normal: 5 empty-space: 0 empty-zero: 0 empty-fill: 4 pre-space: 0 end-space: 1 intervall-fields: 0 zero: 1 Original trees: 10 After join: 8 - Compressing file Segmentation fault if i change the column "part_of_message" from MEDIUMTEXT to CHAR, all works fine. so there still must be a problem in compressing of TEXT columns. i have tried to compress the table on version 3.23.27, 3.23.29 and 3.23.31 (the latest). but the segmentation fault occurs on every version. pherhaps this is an known problem, but already searched on the web, and only find one time the same problem, but this was in 1999 and on version 3.23.20. I hope anyone has an idea, how i can use the column type "TEXT" on my compressed table, because realy need it in future. Thanks, Gernot Pansy ..Gernot Pansy, Research & Development .SMS Internet-Dienstleistungs GmbH ...Sporgasse 25/2, A-8010 Graz .Tel.: +43 316 813380 DW 34, Fax: - 50 .http://www.sms.at - [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
HELP with SQL statement
Actually let me reword this because Tomi's answer won't quite work. The table has a field called Rating. A number 1 is stored to represent positive a 2 is stored for neutral and a 3 is stored for negative. I need to query that will query up all the number 1's (positives) and subtract all the number 3's (negatives) to give me a true rating. Any ideas? - Original Message - From: "Tomi Junnila" <[EMAIL PROTECTED]> To: "mySQL Mailing List" <[EMAIL PROTECTED]> Sent: Friday, January 19, 2001 10:32 AM Subject: Re: HELP with SQL statement > * Mike Podlesny <[EMAIL PROTECTED]> wrote on 19.01.01 17:25: > > I have a table called RATING and two fields one called POSITIVE and the > > other called NEGATIVE. I need to write an SQL statement for my mySQL > > database that will return the value of the total of POSITIVEs minues the > > total of the NEGATIVEs. > > Err, how about > > select sum(positive-negative) from rating; > > ? > > > -- > Tomi Junnila <[EMAIL PROTECTED]> > http://www.badzilla.net/~topeju/ > Electronics and Information Technology, > University of Turku, Finland > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: Please remove me
You have to remove yourself Jenny Lie wrote: > Hi, Please remove my name from the list. Thanks! > > Jenny Lie > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: Front End Needed
Hello, > I need to find a web front end that I can use to update a table in MySQL. > What I'm looking for is a program that will display an entire table with > records as a web page for editing. Something like a submit button at the > bottom to send in the updates to the server. Does something like this > exist? If not, is there a front end that I can use to first search for a > specific record(s), and then edit that record(s) If you are using php, phpMyAdmin works great. If you are using perl, I just received an e-mail last night about a new perl web interface that is available. I haven't checked it out yet, but here is a link to it: http://dajoba.com/projects/mysqltool Regards, Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is there any probleme with datatype DATE ??
I have just install the source distrib. 3.23.30g of MySQL. I have this (while I am testing ) : mysql> CREATE TABLE t1 ( datum DATE ); Query OK, 0 rows affected (0.00 sec) mysql> INSERT INTO t1 VALUES ( "2000-1-1" ); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO t1 VALUES ( "2000-1-2" ); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO t1 VALUES ( "2000-1-3" ); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO t1 VALUES ( "2000-1-4" ); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO t1 VALUES ( "2000-1-5" ); Query OK, 1 row affected (0.00 sec) mysql> SELECT * FROM t1 WHERE datum BETWEEN "2000-1-2" AND "2000-1-4"; ERROR 2013: Lost connection to MySQL server during query mysql> 010119 16:17:41 mysqld restarted When I repalce DATE by DATETIME, I have OK: mysql> drop table t1; Query OK, 0 rows affected (0.00 sec) mysql> CREATE TABLE t1 ( datum DATETIME ); ERROR 1050: Table 't1' already exists mysql> INSERT INTO t1 VALUES ( "2000-1-1" ); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO t1 VALUES ( "2000-1-2" ); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO t1 VALUES ( "2000-1-3" ); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO t1 VALUES ( "2000-1-4" ); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO t1 VALUES ( "2000-1-5" ); Query OK, 1 row affected (0.00 sec) mysql> SELECT * FROM t1 WHERE datum BETWEEN "2000-1-2" AND "2000-1-4"; +-+ | datum | +-+ | 2000-01-02 00:00:00 | | 2000-01-03 00:00:00 | | 2000-01-04 00:00:00 | | 2000-01-02 00:00:00 | | 2000-01-03 00:00:00 | | 2000-01-04 00:00:00 | +-+ 6 rows in set (0.00 sec) Can somebody tell me the reason ? Michel TIGNYEMB FTeB 01 46 12 69 45
Feature Request:
I am BEGGING you to please make the describe command OPTIONALLY display the Privileges column. Before 3.23, I was able to see the describes properly. Now the command is almost totally useless to me! Aaron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL 3.23.31 configure fails with Berkeley DB 3.2.3h
Ivanisevic, Irena writes:
> Hi !
>
> I am trying to implement BDB tables on windows NT.
> I have installed mysql 3.23.31 and have downloaded Berkeley db file 3.2.3.
> I am new to mysql. I have tried to look for instructions but I have no luck.
>
> Thanks
> Irena
>
Hi!
Support for BDB tables for Win32 is still in the works ...
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
temp tables lock unrelated tables
Using SHOW PROCESSLIST or mysqladmin proc Every time a table reports status of 'copying to tmp table' all other UPDATE queries are locked, even in unrelated tables. For example: Query #1: SELECT * FROM a JOIN B WHERE Status: copying to tmp table Query #2: UPDATE C SET x=x+1 WHERE..Status: locked Even though table C is not used is query #2 it is locked until query #1 completed. This can cause huge problems when hundreds of quick updates are locked for more than a few seconds Why does a tmp table on one table lock another? How can I prevent this from happening?
Re: HELP with SQL statement
* Mike Podlesny <[EMAIL PROTECTED]> wrote on 19.01.01 17:52:
> Actually let me reword this because Tomi's answer won't quite work. The
> table has a field called Rating. A number 1 is stored to represent positive
> a 2 is stored for neutral and a 3 is stored for negative. I need to query
> that will query up all the number 1's (positives) and subtract all the
> number 3's (negatives) to give me a true rating. Any ideas?
Well, the most straightforward solution would be to first:
select @positives:=count(*) from {whatever-the-table-name-was-again} where rating=1;
then:
select @negatives:=count(*) from {table-name-here-again} where rating=3;
and finally, if you need to do the whole thing in SQL:
select @positives-@negatives;
This not very effective as you need two queries to do this (three if you
actually do need to do it in SQL). If you don't need to do it all in SQL,
you can just drop the "@positives:=" and "@negatives:=" parts from the
queries.
However, with your table structure it is still possible to do:
select sum(rating) from {table-name};
You only need to subtract 2 times the number of rows you received to get the
result you want.
Probably the most efficient way would be to rethink your table format to
have positive ratings as +1, neutrals as 0, and negatives as -1. Then you
could simply sum them all up without needing to subtract anything.
--
Tomi Junnila <[EMAIL PROTECTED]>
http://www.badzilla.net/~topeju/
Electronics and Information Technology,
University of Turku, Finland
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: HELP with SQL statement
I think that this will do SELECT -(Sum(Rating-2)) AS Total FROM Rating GROUP BY 1; - Original Message - From: "Mike Podlesny" <[EMAIL PROTECTED]> To: "Tomi Junnila" <[EMAIL PROTECTED]>; "mySQL Mailing List" <[EMAIL PROTECTED]> Sent: Friday, January 19, 2001 4:50 PM Subject: HELP with SQL statement > Actually let me reword this because Tomi's answer won't quite work. The > table has a field called Rating. A number 1 is stored to represent positive > a 2 is stored for neutral and a 3 is stored for negative. I need to query > that will query up all the number 1's (positives) and subtract all the > number 3's (negatives) to give me a true rating. Any ideas? > > > - Original Message - > From: "Tomi Junnila" <[EMAIL PROTECTED]> > To: "mySQL Mailing List" <[EMAIL PROTECTED]> > Sent: Friday, January 19, 2001 10:32 AM > Subject: Re: HELP with SQL statement > > > > * Mike Podlesny <[EMAIL PROTECTED]> wrote on 19.01.01 17:25: > > > I have a table called RATING and two fields one called POSITIVE and the > > > other called NEGATIVE. I need to write an SQL statement for my mySQL > > > database that will return the value of the total of POSITIVEs minues the > > > total of the NEGATIVEs. > > > > Err, how about > > > > select sum(positive-negative) from rating; > > > > ? > > > > > > -- > > Tomi Junnila <[EMAIL PROTECTED]> > > http://www.badzilla.net/~topeju/ > > Electronics and Information Technology, > > University of Turku, Finland > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Ver 11.11 Distrib 3.23.31 & JDBC
Hello, I am having an error while trying to connect through JDBC to mysql using the "mm.mysql-2.0.2-bin.jar" driver. The error occurs whether I run my Java program locally or remotely. SQLException: Server configuration denies access to data source SQLState: 08001 VendorError: 0 java.lang.NullPointerException at MySql.init(MySql.java:43) at MySql.main(MySql.java:13) Exception in thread "main" Process Exit... The version of the database is: mysql Ver 11.11 Distrib 3.23.31, for pc-linux-gnu (i686) The users table is as follows: +--+--+-+ | User | Password | Host| +--+--+-+ | root | 066d439558d95532 | % | | root | 066d439558d95532 | server1 | +--+--+-+ If I run the same java program, with the same JDBC driver, but accessing a database that is installed on a Windows machine: mysql Ver 11.9 Distrib 3.23.29a-gamma, for Win95/Win98 (i32) everything works fine. The user's tables are equal in both installations. Can any one help me, please. Thank you in advance, Victor Batista - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to count rows in JDBC ResultSet ?
Hello, I want to know the number of rows in a JDBC-ResulSet just by calling a function like it's done in PHP with mysql_num_rows($result) There seems to be no such function in the ResultSet interface as defined in Java 2. cheers Oliver Doepner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 3.23.31 gives FULLTEXT problems on sparc64 Linux
Hi!
On Jan 19, Tibor Simko wrote:
> Hello
>
> After upgrading to 3.23.31, FULLTEXT selects give often "error -1 from
> table handler" for me. The error log says "ft_read_first: Got error
> -1 when reading table foo". I think I have not seen those for older
> 3.23.x versions (x=28 or so), at least not that frequently.
>
> A small example to reproduce the error:
>
>DROP TABLE IF EXISTS t1;
>CREATE TABLE t1 (
> id mediumint unsigned NOT NULL auto_increment,
> tag char(6) NOT NULL default '',
> value text NOT NULL default '',
> PRIMARY KEY (id),
> KEY kt(tag),
> KEY kv(value(15)),
> FULLTEXT KEY kvf(value)
>) TYPE=MyISAM;
>DROP TABLE IF EXISTS t2;
>CREATE TABLE t2 (
> id_t2 mediumint unsigned NOT NULL default '0',
> id_t1 mediumint unsigned NOT NULL default '0',
> field_number tinyint unsigned NOT NULL default '0',
> PRIMARY KEY (id_t2,id_t1,field_number),
> KEY id_t1(id_t1)
>) TYPE=MyISAM;
>INSERT INTO t1 (tag,value) VALUES ('foo123','bar1');
>INSERT INTO t2 VALUES (2231626,64280,0);
>INSERT INTO t1 (tag,value) VALUES ('foo123','bar2');
>INSERT INTO t2 VALUES (2231626,64281,0);
>SELECT DISTINCT t2.id_t2
> FROM t2, t1
> WHERE MATCH (t1.value) AGAINST ('baz')
> AND t1.id = t2.id_t1;
>
> The error occurs during final SELECT. I've seen it only for FULLTEXT
> searches; if I use e.g. "WHERE t1.value LIKE 'baz%' in that statement,
> everything works fine.
>
> P.S. Self-compiled 3.23.31 on sparc64 Linux (Debian stable).
>
> cheers
> --
> TS
>
Thanks for a bug report!
This would be fixed in a nex release.
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland (till Sunday)
<___/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: temp tables lock unrelated tables
Michael Griffith writes:
> Using SHOW PROCESSLIST or mysqladmin proc
>
> Every time a table reports status of 'copying to tmp table' all other UPDATE queries
>are locked, even in unrelated tables.
>
> For example:
>
> Query #1: SELECT * FROM a JOIN B WHERE Status: copying to tmp table
> Query #2: UPDATE C SET x=x+1 WHERE..Status: locked
>
> Even though table C is not used is query #2 it is locked until query #1 completed.
>This can cause huge problems when hundreds of quick updates are locked for more than
>a few seconds
>
> Why does a tmp table on one table lock another?
> How can I prevent this from happening?
>
Hi!
The above should not happen.
You should look at entire processlist.
And check the size of your TMPDIR partition.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Feature Request:
Hi, > I am BEGGING you to please make the describe command OPTIONALLY display the > Privileges column. Before 3.23, I was able to see the describes properly. Now > the command is almost totally useless to me! I agree! On any table you care to describe the output is usually always wider than even a 120 character display because of the privileges column. It would indeed be much better if this column was optional. After all, you don't always want to know what privileges you have on columns in a table. I have a suggestion for an addition to the syntax to solve this problem. By default DESCRIBE or SHOW COLUMNS would not show privilege information, but if you did want to see privileges too, you would enter something like this: DESCRIBE tablename WITH PRIVILEGES SHOW COLUMNS FROM tablename WITH PRIVILEGES Anyway, in the meantime, you can always show the query output in vertical mode by terminating with '\G', rather than ';' or '\g'. But then again, this poses it's own problems with scrolling (but you could probably use the new pager command in the most recent 3.23 clients). Regards, Basil Hussain ([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: temp tables lock unrelated tables
My TMPDIR is actually not separate from the data. There is plently of disk space. In fact, thinking it was some sort of RAM problem I reduced the size of the database by almost 30% with no change in performace. You say this should not happen, yet as I've been searching the mailing list there's at least 2-3 threads in the last year talking about this problem. Most posts have gone unanswered. I acutally have over 250 unrelated threads that get locked during a 1 minute long query. Since my web server is set for 256 MAX processes, the website that links to the DB dies until the offending query ends. This happens with many queries. All are tuned and have worked for months until recently. In fact no code has changed in our scripts. Unrelated table just started locking all of a sudden. Also we have run isamchk 100% of the tables are in RAM. The only disk access should be updates. This may be useful. This is the mysqladmin ext output when NO query is locked: +--++ | Variable_name| Value | +--++ | Aborted_clients | 1 | | Aborted_connects | 1 | | Created_tmp_tables | 7809 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delayed_errors | 0 | | Flush_commands | 1 | | Handler_delete | 69600 | | Handler_read_first | 251| | Handler_read_key | 6190764| | Handler_read_next| 19966429 | | Handler_read_rnd | 1085708844 | | Handler_update | 940141 | | Handler_write| 593065 | | Key_blocks_used | 59010 | | Key_read_requests| 18022185 | | Key_reads| 57325 | | Key_write_requests | 600364 | | Key_writes | 277250 | | Max_used_connections | 256| | Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 | | Open_tables | 511| | Open_files | 106| | Open_streams | 0 | | Opened_tables| 1173 | | Questions| 675496 | | Running_threads | 5 | | Slow_queries | 20005 | | Uptime | 23360 | +--++ > Michael Griffith writes: > > Using SHOW PROCESSLIST or mysqladmin proc > > > > Every time a table reports status of 'copying to tmp table' all other UPDATE queries are locked, even in unrelated tables. > > > > For example: > > > > Query #1: SELECT * FROM a JOIN B WHERE Status: copying to tmp table > > Query #2: UPDATE C SET x=x+1 WHERE..Status: locked > > > > Even though table C is not used is query #2 it is locked until query #1 completed. This can cause huge problems when hundreds of quick updates are locked for more than a few seconds > > > > Why does a tmp table on one table lock another? > > How can I prevent this from happening? > > > > Hi! > > The above should not happen. > > You should look at entire processlist. > > And check the size of your TMPDIR partition. > > > Regards, > > Sinisa > > __ _ _ ___ == MySQL AB > /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic > /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] >/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus > /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| > /*/^^^\*\^^^ > /*/ \*\Developers Team > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 use index files?
Hi,
I have installedMySQL 3.23.31
I have read many docs.
I have successfully crated a database with tables and index files.
Several of my tables have two index files. One is the PRIMARY field
that I specified. The other is a seperate index I created on other
fields, using the "alter table and Index..." command.
Now, I am writing a Perl script which will connect and update this
Table. Mission accomplished regarding the connection. Here is my
question:
Prior to updating, I want to search the table to see if my Key exists.
That way, I can add it or just update the associated fields. How do I
tell my script which Index file to use? I can't seem to find the
equivalent of the dBase style "Set Order to".
Can someone also give me or point me to a code example of searching with
an index. I found th ecommand "$searchField{$key_field} = $val;" but
I'm stilllooking for documentation to see what this code does and if it
does what I want.
Thanks,
Don
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connection Refused
Doing that was just a test, and I didn't think it would work since Inetd is not running on the box at all. In fact the only way to get to these boxen (aside from walking over) is via SSH. I find it interesting that on the box that I want to actually do the logging to I can telnet to port 3306 if I use either the external name or external ip address I can "connect", but can't telnet to the lo interface (telnet localhost 3306 or telnet 127.0.0.1 3306). Anyways, I'll keep trying to find the solution in the docs, but so far not luck. > > The grant was done by: > > > > # echo "grant INSERT,SELECT on snort.* to > > snortdb@'XXX.XXX.0.0/255.255.0.0';" | mysql -u root -p > > > > The system has TCP wrappers setup and the hosts.allow file is empty and > > hosts.deny is set to ALL:ALL. next time I'm at work I'll try putting in > > hosts.allow the ip address of the sensor and see what happens. > > Inetd and TCP wrappers have nothing to do with mysqld. > Mysqld is a standalone server, and must be started separately. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
The function of auto_increment and Premier Key?
Hi I'm relatively new to MySQL though I familiar to other simple databases. I have been reading the manual but not doing well understanding the function of auto_increment and Premier Key. Lets say I have a table with a few columns. One of them is an ID with auto_increment. It has 1000 rows. If I delete row #500 to #599 (total of 100), will the MySQL update the ID value for row #600 to #1000, or will it stay as it was? If it stays as it was, and afterwards when I add a row (or record), will it continue from row #1001 or will it use the value from #500 to #599? What is the Primary Key used for and how does it work? Do I need it if I have a row ID like mentioned above? Regards, Sumarlidi Einar Dadason SED - Graphic Design -- Phone: (+354) 4615501 Mobile: (+354) 8960376 Fax: (+354) 4615503 E-mail: [EMAIL PROTECTED] Homepage:www.sed.is <- New Homepage! -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Simple DoS scenario against mysql slaves
Referring to my post "instant slave crash (signal 11) on 'set password'" to [EMAIL PROTECTED]: The scenario is still valid for 3.23.31. This means that any valid mysql user can cause the replicating slaves to crash using the 'set password' command. So any valid user can even unintendedly cause a denial of service condition for the mysql slaves, as any valid user is allowed to use the 'set password' command to change his or her password. This is a real bad problem. Could somebody of the mysql team please look into this? Andreas Steinmetz D.O.M. Datenverarbeitung GmbH - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 3.22.32 shutting down
We use MySQL 3.22.32 on a high-volume web server with Apache 1.3.14/PHP 4.0.3pl1 on a Compaq RS6000. Randomly, MySQL shuts down mysteriously with no reason in any of the log files. The .err log shows: mysqld ended on Fri Jan 19 09:50:49 EST 2001 mysqld started on Fri Jan 19 10:04:12 EST 2001 /www/mysql/libexec/mysqld: ready for connections Other than that, nothing. Has anyone ever come across this particular problem before and maybe knows a way to fix it? Regards, Michael L. Smeby Jr. [EMAIL PROTECTED]
RE: How do I use index files?
> Hi, > > I have installedMySQL 3.23.31 Good. > I have read many docs. Even better! > ... [cut] > Prior to updating, I want to search the table to see if my Key exists. > That way, I can add it or just update the associated fields. How do I > tell my script which Index file to use? I can't seem to find the > equivalent of the dBase style "Set Order to". Errr... If I understand your question correctly, you want to specify which index MySQL should use for looking up the values you need. You don't need to do that. MySQL takes care of using the correct indexes all by itself. You should probably also have a look at the REPLACE INTO command to see if this does what you need. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Connection Freeze (new feature proposal)
Hi! I've been thinking here about databases and their use in WEB developemnt and have come to a conclusion that transactions are very often useless in real web applications, because creating one logical object in database (sorry for OO notatitions, but I often use RDBMSes for mapping object oriented structures in them, so they whole thing works faster) envolves several web pages, so, between pages a script must disconnect and connect again, which implies that there should be commit or roll-back. So, you cannot start a transaction on page one and commit it on the last page. The soultion would be a feature that allows a connection freeze with a timeout. Let me give you and example: PAGE1: Scripts connects, starts transaction, does some queries, issues a connection freeze with timeout of 20 seconds and gets a frozen connection id. Script finishes, however, sql server does not destroy the session, instead, it locks the session and considers that a client went to take a nap. PAGE2: Script starts and issue a thaw to the connection suppling user credetials and frozen connection id. Does more data manipulation and commits the transaction which was started on the first page. Disconnect. Finish. Ain't it nice? Current workaround would be (generic description) 1) In each table create a field called sys_commit 2) When executing any query set sys_commit to 0 3) Remember in some persistent manner the list of records changed 4) On the last page set for all remembered recods sys_commit to 1 Sure, all SQL queries must manipulate only records with sys_commit to 1, and all other must be considered non-existing and cleaned up periodically. What do you think? (And Yes, i am aware of persistant database handlers which live in the web server space). Artem Koutchine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: The function of auto_increment and Premier Key?
> Hi I'm relatively new to MySQL though I familiar to other simple > databases. Ahem... [takes Sumarlidi aside and explains very carefully how the MySQL developers feel about hearing MySQL being called a "simple database" ;-) ] > I have been reading the manual but not doing well understanding > the function > of auto_increment and Premier Key. > > Lets say I have a table with a few columns. One of them is an ID with > auto_increment. It has 1000 rows. If I delete row #500 to #599 (total of > 100), will the MySQL update the ID value for row #600 to #1000, No. > or will it stay as it was? Yes. The whole point of having such a column is to create and maintain a unique identifier for the record for as long as it lives. > If it stays as it was, and afterwards when I add a row (or > record), will it > continue from row #1001 or will it use the value from #500 to #599? #1001 (same argument -- you don't want something you thought was dead and gone to seemingly reappearing all of a sudden) > > What is the Primary Key used for and how does it work? Do I need it if I > have a row ID like mentioned above? In most cases, this is the primary function of the primary key. The primary key is unique in a couple of respects: 1) it is always declared as NOT NULL UNIQUE, meaning that you're ensured that for any record there is always a well-defined, distinct ID as you must always declare it (or have MySQL do it for you through auto_increment) and you can never assign the same value to two different rows; You may have other UNIQUE indexes; however, there are some subtle differences between these and a primary key. e... h... I'm sure there are. Though for the life of me, I can't think of any off the top of my head right now. I'll go get some coffee while someone else explains this to you. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.22.32 shutting down
What OS and version? Is it patched to current patch levels? - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "Michael L. Smeby, Jr." <[EMAIL PROTECTED]> To: "Mysql Mailing List" <[EMAIL PROTECTED]> Sent: Friday, January 19, 2001 1:20 PM Subject: MySQL 3.22.32 shutting down We use MySQL 3.22.32 on a high-volume web server with Apache 1.3.14/PHP 4.0.3pl1 on a Compaq RS6000. Randomly, MySQL shuts down mysteriously with no reason in any of the log files. The .err log shows: mysqld ended on Fri Jan 19 09:50:49 EST 2001 mysqld started on Fri Jan 19 10:04:12 EST 2001 /www/mysql/libexec/mysqld: ready for connections Other than that, nothing. Has anyone ever come across this particular problem before and maybe knows a way to fix it? Regards, Michael L. Smeby Jr. [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: bug in 3.23.22-beta
> "MS" == Marc Swanson <[EMAIL PROTECTED]> writes: MS> As you can see the date field has been updated to the current date/time even MS> though the update query was only supposed to modify the text field. For MS> claarity the date field started out with 2001-01-07 08:00:00 and ended up MS> with 2001-01-19 08:23:32 (the time I tested this bug). It is not a date field. It is a timestamp field. Read the manual on what the difference is. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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-DB] Date function.
mysql> select name from tableName -> where month(birthDate) = 7; -Original Message- From: Sharif Islam [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 8:56 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Date function. This is a simple mysql question i am having problme with. I have a table with name and birth date; Joe | 1964-07-21 Mary | 1978-05-22 -- I want to get the name with birthdays in the month of July. thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
installing and configuring Mysql on red hat linux 6.2
Hi, I would like to know where i can find information how to: Install and configure My sql on red hat linux 6.2 Create,manage and backup database, several client. Where can i find professional and not expensive support to learn how to manage my sql. Thank.. Stephen T.
Replicating MySQL
Hello, How could we replicate our MySQL DB from one server to another? As a back up measure, incase our pages fail to connect to ServerA, it'll then try to connect to ServerB? Thanks! Karl ...and what is the word I am looking for, it isn't replicate but something else? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Simple DoS scenario against mysql slaves
On Friday 19 January 2001 11:16, Andreas Steinmetz wrote:
>Referring to my post "instant slave crash (signal 11) on 'set password'" to
>[EMAIL PROTECTED]:
>
>The scenario is still valid for 3.23.31. This means that any valid mysql user
>can cause the replicating slaves to crash using the 'set password' command.
>
>So any valid user can even unintendedly cause a denial of service condition
for
>the mysql slaves, as any valid user is allowed to use the 'set password'
>command to change his or her password.
>
>This is a real bad problem. Could somebody of the mysql team please look into
>this?
Fix:
= sql_acl.cc 1.23 vs edited =
--- 1.23/sql/sql_acl.cc Fri Oct 6 12:14:45 2000
+++ edited/sql_acl.cc Fri Jan 19 12:04:58 2001
@@ -781,8 +781,8 @@
length=(uint) strlen(new_password);
new_password[length & 16]=0;
- if (!thd || strcmp(thd->user,user) ||
- my_strcasecmp(host,thd->host ? thd->host : thd->ip))
+ if (!thd || (!thd->slave_thread && ( strcmp(thd->user,user) ||
+ my_strcasecmp(host,thd->host ? thd->host : thd->ip
{
if (check_access(thd, UPDATE_ACL, "mysql",0,1))
return 1;
I have now extended rpl01 test case to test this also.
--
MySQL Development Team
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / 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
RE: The function of auto_increment and Premier Key? - Thanks!
Thanks you for your good explain of this all - now I have a good idea of how it works. Ps. I meant that I'm familiar to simple databases like MS Access etc. but not of course MySQL witch I think is great! :) Sumarlidi -Original Message- From: Carsten H. Pedersen [mailto:[EMAIL PROTECTED]] Sent: 19. janúar 2001 18:37 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: The function of auto_increment and Premier Key? > Hi I'm relatively new to MySQL though I familiar to other simple > databases. Ahem... [takes Sumarlidi aside and explains very carefully how the MySQL developers feel about hearing MySQL being called a "simple database" ;-) ] > I have been reading the manual but not doing well understanding > the function > of auto_increment and Premier Key. > > Lets say I have a table with a few columns. One of them is an ID with > auto_increment. It has 1000 rows. If I delete row #500 to #599 (total of > 100), will the MySQL update the ID value for row #600 to #1000, No. > or will it stay as it was? Yes. The whole point of having such a column is to create and maintain a unique identifier for the record for as long as it lives. > If it stays as it was, and afterwards when I add a row (or > record), will it > continue from row #1001 or will it use the value from #500 to #599? #1001 (same argument -- you don't want something you thought was dead and gone to seemingly reappearing all of a sudden) > > What is the Primary Key used for and how does it work? Do I need it if I > have a row ID like mentioned above? In most cases, this is the primary function of the primary key. The primary key is unique in a couple of respects: 1) it is always declared as NOT NULL UNIQUE, meaning that you're ensured that for any record there is always a well-defined, distinct ID as you must always declare it (or have MySQL do it for you through auto_increment) and you can never assign the same value to two different rows; You may have other UNIQUE indexes; however, there are some subtle differences between these and a primary key. e... h... I'm sure there are. Though for the life of me, I can't think of any off the top of my head right now. I'll go get some coffee while someone else explains this to you. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: TRUNCATE causes corrupted tables
Hi! No, I can't repeat it on command, sorry. However, I can give a little more info. When inserting, the index file got bigger. It was the data file that was set to 0 bytes, but did not get bigger on inserts. Doing a repair fixed it. I have some tables truncated via scripts, so I turned on mysql's auto repair feature so it can deal with it rather than me. Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Replicating MySQL
"Mirror" is the word you're looking for. -Original Message- From: Karl J. Stubsjoen [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 11:55 AM To: MySql list Subject: Replicating MySQL Hello, How could we replicate our MySQL DB from one server to another? As a back up measure, incase our pages fail to connect to ServerA, it'll then try to connect to ServerB? Thanks! Karl ...and what is the word I am looking for, it isn't replicate but something else? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 do I use index files?
> > Prior to updating, I want to search the table to see if my Key exists. > > That way, I can add it or just update the associated fields. How do I > > tell my script which Index file to use? I can't seem to find the > > equivalent of the dBase style "Set Order to". > > Errr... If I understand your question correctly, you want to specify > which index MySQL should use for looking up the values you need. You > don't need to do that. MySQL takes care of using the correct indexes > all by itself. This is what I suspected but I wanted to make sure. However, I'm curious as to how MySQL does this in an efficient manner. The Docs state that I can create, I believe, up to 16 indexes on a given table. Say I create 16 indexes on my table. One is a field I tagged as Primary while the others are additional Indexes I created. Let's say that they are all based on different Fields that happen to be all VARCHAR(10). Now I do a search on a string,"12345678980". How does MySQL know which index I am looking up? My question seems to odd so I have to assume that I am missing something important. > You should probably also have a look at the REPLACE INTO command > to see if this does what you need. Yes, I believe it will but as I am used to programming with Non-SQL databases, I am also used to replacing only those fields that I specify within a record meaning everything but the index fields. I suppose I will have to alter my mode of thinking...? Thanks, Don - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Need MYSQL for COBALT Rack3
Need some help. I need the RPM files for the Cobalt Rack 3. Any ideas. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connection Refused
Do you hae the line 127.0.0.1 localhost.mydomain localhost in your /etc/hosts file? It sounds like your resolver is not working. [EMAIL PROTECTED] wrote: > > Doing that was just a test, and I didn't think it would work since Inetd is > not running on the box at all. In fact the only way to get to these boxen > (aside from walking over) is via SSH. I find it interesting that on the box > that I want to actually do the logging to I can telnet to port 3306 if I use > either the external name or external ip address I can "connect", but can't > telnet to the lo interface (telnet localhost 3306 or telnet 127.0.0.1 > 3306). Anyways, I'll keep trying to find the solution in the docs, but so far > not luck. > > > > The grant was done by: > > > > > > # echo "grant INSERT,SELECT on snort.* to > > > snortdb@'XXX.XXX.0.0/255.255.0.0';" | mysql -u root -p > > > > > > The system has TCP wrappers setup and the hosts.allow file is empty and > > > hosts.deny is set to ALL:ALL. next time I'm at work I'll try putting in > > > hosts.allow the ip address of the sensor and see what happens. > > > > Inetd and TCP wrappers have nothing to do with mysqld. > > Mysqld is a standalone server, and must be started separately. > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: forcing tcp/ip connect when connecting to localhost
>> can I force the mysql clients to use a tcp/ip connect if connecting to >> 'localhost'? > Normally connecting to the true DNS hostname or the ip address of > the machine will do the trick. Connecting to localhost will connect > via the loopback address of 127.0.0.1. If you connect to the true DNS hostname or the external IP address, the connection will go through that external interface, which will be slower than using the loopback interface (I believe). As long as you use any other name for the loopback interface than 'localhost' you're okay. The most natural is to use '127.0.0.1' as the hostname. I've got a patch that will make mysql use a --port argument if there is no --socket argument specified, even for localhost, but it's not popular and it's not getting into the official sources. Let me know if you want it. (I posted two versions to this list, but the current patch is better than those.) (The patch is undesirable because it doesn't totally solve the problem when used with many my.cnf configurations, including the default ones.) Monty has pointed out that if you tunnel through ssh using port-forwarding like that: > ssh -L 3306:localhost:3306 [EMAIL PROTECTED] sleep 10m then other machines can follow the tunnel if they connect to your port 3306. If you don't wish for that to happen, you should block that port from outside access with firewalling. (He also pointed out that ssh could be patched to forward a socket connection through the tunnel, which would be faster than using a port as well as more naturally secure.) Hope this helps, --Pete - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Could anyone help me with locked table?
My set-up: MySQL server 3.23.30 with MSAccess97 via MyODBC 2.50.36 (all latest patches to everything) I have no trouble running this set up, BUT... Even when I am the only person connected (after flush and restart of server) and I open my Access database and go directly to edit one particular table (MySQL linked table), I keep on getting write conflict. It would not allow me to edit anything in that table. Anyone have a solution to this? Or may at least a lead from where I need to start to figure out the problem? Apollo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: installing and configuring Mysql on red hat linux 6.2
To install will you be using a tarball or RPM? -Original Message- From: Stephen Lambert,CSI [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 11:18 AM To: [EMAIL PROTECTED] Subject: installing and configuring Mysql on red hat linux 6.2 Hi, I would like to know where i can find information how to: Install and configure My sql on red hat linux 6.2 Create,manage and backup database, several client. Where can i find professional and not expensive support to learn how to manage my sql. Thank.. Stephen T. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
3.22.23 table problem
I'm not sure exactly what happened, but mysql was freezing everytime I tried to access a particular table...everytime I tried to select anything from it, alter it, drop it, whateverjust nothing worked and mysql crashed. I ended up having to temporarily remove the table files, kill mysql and restart it, then create a new table from scratch. I have the old corrupt tables backed up and I need tro recover that data very badly! Remember that this is mysql 3.22 not 3.23, therefore the tables are ISAM and not MyISAMwould anyone know how to recover the lost data? I'll even send the files over if someone wants to take a look. Thanks, Mike Goodman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Simple DoS scenario against mysql slaves
Fix confirmed.
Thanks for the fast response!
On 19-Jan-2001 Sasha Pachev wrote:
> On Friday 19 January 2001 11:16, Andreas Steinmetz wrote:
>>Referring to my post "instant slave crash (signal 11) on 'set password'" to
>>[EMAIL PROTECTED]:
>>
>>The scenario is still valid for 3.23.31. This means that any valid mysql user
>>can cause the replicating slaves to crash using the 'set password' command.
>>
>>So any valid user can even unintendedly cause a denial of service condition
> for
>>the mysql slaves, as any valid user is allowed to use the 'set password'
>>command to change his or her password.
>>
>>This is a real bad problem. Could somebody of the mysql team please look into
>>this?
>
> Fix:
>
> = sql_acl.cc 1.23 vs edited =
> --- 1.23/sql/sql_acl.cc Fri Oct 6 12:14:45 2000
> +++ edited/sql_acl.cc Fri Jan 19 12:04:58 2001
> @@ -781,8 +781,8 @@
>length=(uint) strlen(new_password);
>new_password[length & 16]=0;
>
> - if (!thd || strcmp(thd->user,user) ||
> - my_strcasecmp(host,thd->host ? thd->host : thd->ip))
> + if (!thd || (!thd->slave_thread && ( strcmp(thd->user,user) ||
> + my_strcasecmp(host,thd->host ? thd->host : thd->ip
>{
> if (check_access(thd, UPDATE_ACL, "mysql",0,1))
>return 1;
>
>
> I have now extended rpl01 test case to test this also.
>
> --
> MySQL Development Team
>__ ___ ___ __
> / |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
> /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
><___/
>
Andreas Steinmetz
D.O.M. Datenverarbeitung GmbH
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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 access Logging
Hi, I want my mysql to track user login information and commands they run at mysql client? Any one can help me to do this please? bye! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connection Refused
The line is 127.0.0.1 localhost.localdomain localhost > Do you hae the line > > 127.0.0.1 localhost.mydomain localhost > > in your /etc/hosts file? > It sounds like your resolver is not working. > > [EMAIL PROTECTED] wrote: > > > > Doing that was just a test, and I didn't think it would work since Inetd is > > not running on the box at all. In fact the only way to get to these boxen > > (aside from walking over) is via SSH. I find it interesting that on the box > > that I want to actually do the logging to I can telnet to port 3306 if I use > > either the external name or external ip address I can "connect", but can't > > telnet to the lo interface (telnet localhost 3306 or telnet 127.0.0.1 > > 3306). Anyways, I'll keep trying to find the solution in the docs, but so far > > not luck. > > > > > > The grant was done by: > > > > > > > > # echo "grant INSERT,SELECT on snort.* to > > > > snortdb@'XXX.XXX.0.0/255.255.0.0';" | mysql -u root -p > > > > > > > > The system has TCP wrappers setup and the hosts.allow file is empty and > > > > hosts.deny is set to ALL:ALL. next time I'm at work I'll try putting in > > > > hosts.allow the ip address of the sensor and see what happens. > > > > > > Inetd and TCP wrappers have nothing to do with mysqld. > > > Mysqld is a standalone server, and must be started separately. > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: forcing tcp/ip connect when connecting to localhost
Pete, thanks for your exhaustive answer. I didn't try using '127.0.0.1' instead of 'localhost', as I though that anything that points to the lo interface would be using a socket. luckily, speed is no concern to me, as this connection is only used to make php development while being able to connect to the live database. Thanks again for your help, Ben -- Ben Peter ph. +49-(0)173-9262278 fax +49-(0)89-1488-216649 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 do I use index files?
Don wrote: > > > > Prior to updating, I want to search the table to see if my Key exists. > > > That way, I can add it or just update the associated fields. How do I > > > tell my script which Index file to use? I can't seem to find the > > > equivalent of the dBase style "Set Order to". > > > > Errr... If I understand your question correctly, you want to specify > > which index MySQL should use for looking up the values you need. You > > don't need to do that. MySQL takes care of using the correct indexes > > all by itself. > > This is what I suspected but I wanted to make sure. However, I'm curious as > to how MySQL does this in an efficient manner. The Docs state that I can > create, I believe, up to 16 indexes on a given table. > > Say I create 16 indexes on my table. One is a field I tagged as Primary > while the others are additional Indexes I created. Let's say that they are > all based on different Fields that happen to be all VARCHAR(10). Now I do a > search on a string,"12345678980". Search what? select * from customers where lastname="1234567890"; will use an index that starts with lastname, if one exists. > > How does MySQL know which index I am looking up? My question seems to odd > so I have to assume that I am missing something important. > > > You should probably also have a look at the REPLACE INTO command > > to see if this does what you need. > > Yes, I believe it will but as I am used to programming with Non-SQL > databases, I am also used to replacing only those fields that I specify > within a record meaning everything but the index fields. I suppose I will > have to alter my mode of thinking...? > > Thanks, > Don > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
4Gb tables problem
I have MySQL Server "Ver 3.23.27-beta for Win95/Win98 on i32" installed on Windows 2K machine and NTFS filesystem. As soon as one of my tables reaches 4Gb size every attempt to insert new records into it leads to 'ERROR 1114: The table 'table_name' is full'. >From MySQL manual I know that "MyISAM tables support for big files (63-bit) on filesystems/operating systems that support big files." What's wrong? Thanks in advance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 do I use index files?
> Don wrote: > > > > > > Prior to updating, I want to search the table to see if my Key exists. > > > > That way, I can add it or just update the associated fields. How do I > > > > tell my script which Index file to use? I can't seem to find the > > > > equivalent of the dBase style "Set Order to". > > > > > > Errr... If I understand your question correctly, you want to specify > > > which index MySQL should use for looking up the values you need. You > > > don't need to do that. MySQL takes care of using the correct indexes > > > all by itself. > > > > This is what I suspected but I wanted to make sure. However, I'm curious as > > to how MySQL does this in an efficient manner. The Docs state that I can > > create, I believe, up to 16 indexes on a given table. > > > > Say I create 16 indexes on my table. One is a field I tagged as Primary > > while the others are additional Indexes I created. Let's say that they are > > all based on different Fields that happen to be all VARCHAR(10). Now I do a > > search on a string,"12345678980". > > Search what? > > select * from customers where lastname="1234567890"; > will use an index that starts with lastname, if one exists. The "light bulb" just went off in my head -) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
encode() question
Hello All, I have noticed that the Encrypt() is a oneway function that will also give different resulting messages for the same message being encrypted multiple times. I have also noticed that the Encode() will result in a message that is a binary type. What I need to do is to find a way to change the results of an Encode() message such that the message will be only displaying characters that are A-Z, a-z, 0-9 I am not concerned about recovery of the message, but just that all the characters are within the range above and that the same encoding will produce the same message. Any ideas? Cheers, Lonnie Cumberland __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: isamchk error
"Gerald L. Clark" wrote:
>
> Stuart Fox wrote:
> >
> > Hi
> >
> > Can anybody tell me what this error means
> >
> > user@server#isamckh -av {database}/*.ISM
> >
> > isamchk: error: 22 when opening ISAM-table '{database}/tax.ISM'(all
> > tables)
> >
> If this was part of a script, then database was a variable that
> contained the full
> path to the database, and ${database} would expand to its value.
> The line would have been:
>
> isamchk -av ${database}/*.ISM
>
> There is no directory named {database}
> Replace {database} with the full path to the database.
> EX:
>
> isamchk -av /usr/local/mysql/data/mydatabase/*.ISM
No, I was hiding the database name. The command was run
from the command line. Any isamchk access to the ISM file
results in the same error.
Any clues?
Stuart Fox
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
temp tables lock unrelated tables
Earlier I posted a message about SHOW PROCESSLIST reporting queries "locked" whenever another thread is "Copying to tmp table" After many more hours of diagnosis, the actual problem is somewhat different: MySQL does report other processes as locked. But they do not wait until the temp table is completely written to execute. For example: Query #1: SELECT * FROM a JOIN B WHERE Status: copying to tmp table Query #2: UPDATE C SET x=x+1 WHERE..Status: locked Query #3: UPDATE C SET x=x+1 WHERE..Status: locked With these queries, Query #2 does eventually finish even if #1 does not. The problem is that as soon as query #1 is issued and starts copying to temp table, everything else slows down to almost a crawl. It appears as if #3,#4,#5 are permanently locked because it is so slow. For practical purposes they are locked until query #1 is done. I have hundreds more locked queries identical to #2 & #3. Although mysqladmin reports all as locked, it is most likely one of them that is locking the others and not #1. The problem is that it is extremely slow. MySQL acts as if Query#1 gets some kind of priority. As if the thread scheduling gives almost no time to any other thread. At least no disk time. What would cause writing to a temp table to preempt other disk operations? Can it be stopped?
Weird update where something != otherthing
Maybe this the correct behavior, but I am confused about
the statments below:
CREATE TABLE testing ( fmsg CHAR(1) DEFAULT 'N' );
INSERT INTO testing VALUES (NULL);
INSERT INTO testing VALUES ('Y');
INSERT INTO testing VALUES ('X');
INSERT INTO testing VALUES ('Y');
INSERT INTO testing VALUES (NULL);
INSERT INTO testing VALUES ('Y');
UPDATE testing SET fmsg = 'N' WHERE fmsg != 'Y';
> Query OK, 1 row affected (0.00 sec)
> Rows matched: 1 Changed: 1 Warnings: 0
Isn't NULL != 'Y' ?
- Diogo Zulli
--[ www.sphynx.com.br ]---
"And once you have tasted flight, you will walk the earth with your
eyes turned skyward, for there you have been and there you long to
return" - Leonardo DaVinci
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
inserts with now() resulting in replication-problems
My Replication-Slave crashed a few days ago with an error in the error-log saying something like "duplicate primary key processing query "INSERT INTO testtable (time,name,number) VALUES (NOW(),'Hello',10)" testtable's primary key was (time,name) time: datetime name: varchar number: int What I was wondering after that: I do a "INSERT INTO testtable (time,name,number) VALUES (NOW(),'Hello',10) on the master. Then I do the *same* query again 1 Minute later. No Problem, since time has passed and NOW() is now different, so i do not have a duplictae key. If the Slave gets out of sync (loses the connection to the server), connects again and tries to catch up, it processes those two queries *within one second* which would result in an duplicate primary key on the slave. The Slave would abort with an error and the replication would stop. Is that right or did I misunderstand the concept? I changed the query to REPLACE instead of INSERT which is, in this case, fine with me, but is it possible to tell mysql to ignore such problems and keep the Replication up? I'd like to make the server send be a mail or SMS on my mobile phone if that happens. So if I could make the slave keep on replicating but write a line into a logfile like "serious-errors.log". I could then make some shell-script send me a mail... i'm running mysql 3.23.28-gamma on debian linux on Athlon-PCs. thanks for any explaination! Jan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: encode() question
Lonnie Cumberland wrote: > > Hello All, > > I have noticed that the Encrypt() is a oneway function that will also give > different resulting messages for the same message being encrypted multiple > times. > > I have also noticed that the Encode() will result in a message that is a binary > type. > > What I need to do is to find a way to change the results of an Encode() message > such that the message will be only displaying characters that are A-Z, a-z, 0-9 > I am not concerned about recovery of the message, but just that all the > characters are within the range above and that the same encoding will produce > the same message. > > Any ideas? > > Cheers, > Lonnie Cumberland > What is wrong with ENCRYPT(str,salt) ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: temp tables lock unrelated tables
Michael Griffith wrote: > > Earlier I posted a message about SHOW PROCESSLIST reporting queries "locked" >whenever another thread is "Copying to tmp table" > > After many more hours of diagnosis, the actual problem is somewhat different: > > MySQL does report other processes as locked. But they do not wait until the temp >table is completely written to execute. For example: > > Query #1: SELECT * FROM a JOIN B WHERE Status: copying to tmp table > Query #2: UPDATE C SET x=x+1 WHERE..Status: locked > Query #3: UPDATE C SET x=x+1 WHERE..Status: locked > > With these queries, Query #2 does eventually finish even if #1 does not. The problem >is that as soon as query #1 is issued and starts copying to temp table, everything >else slows down to almost a crawl. It appears as if #3,#4,#5 are permanently >locked because it is so slow. For practical purposes they are locked until query #1 >is done. > > I have hundreds more locked queries identical to #2 & #3. Although mysqladmin >reports all as locked, it is most likely one of them that is locking the others and >not #1. The problem is that it is extremely slow. > > MySQL acts as if Query#1 gets some kind of priority. As if the thread scheduling >gives almost no time to any other thread. At least no disk time. > > What would cause writing to a temp table to preempt other disk operations? > Can it be stopped? Can your tmpdir be set to a different physical drive? You can't expect to write and sort temporary files without severly impacting read access to other files on the same drive. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Weird update where something != otherthing
Diogo Zulli wrote:
>
> Maybe this the correct behavior, but I am confused about
> the statments below:
>
> CREATE TABLE testing ( fmsg CHAR(1) DEFAULT 'N' );
> INSERT INTO testing VALUES (NULL);
> INSERT INTO testing VALUES ('Y');
> INSERT INTO testing VALUES ('X');
> INSERT INTO testing VALUES ('Y');
> INSERT INTO testing VALUES (NULL);
> INSERT INTO testing VALUES ('Y');
>
> UPDATE testing SET fmsg = 'N' WHERE fmsg != 'Y';
> > Query OK, 1 row affected (0.00 sec)
> > Rows matched: 1 Changed: 1 Warnings: 0
>
> Isn't NULL != 'Y' ?
>
> - Diogo Zulli
No, it is unknown.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replicating MySQL
On Fri, Jan 19, 2001 at 11:54:34AM -0700, Karl J. Stubsjoen wrote: > How could we replicate our MySQL DB from one server to another? Yes. And it's documented in the fine manual: http://www.mysql.com/doc/R/e/Replication.html > As a back up measure, incase our pages fail to connect to ServerA, > it'll then try to connect to ServerB? Currently it's up to your applications to deal with database outages. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql++: How to save a row[i] as a char*
How can I get a row[i] in a char* or a qstring variable? thank for helping! juergen leeb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ANNOUNCE: myrepl - automate inital mysql replication setup on master server without down-time
> > * It'd be handy to create a compressed tar file (.tar.gz). I'll > probably add that. great ;) but i'll transfer it compressed with scp, so it's no big problem for me. But a "-z"-switch would probably be useful for lots of people. > * It'd be nice to specify which databases/tables not to snapshot > (or to say "only snapshot these databases/tables"). If folks > need that, it can be added also. yes, just like mysqldump...? ;) > > Comments and feedback welcome. Half the reason I wrote this was to see > if it would work. The other half is that I figured it'd be useful if > it did. :-) It surely is useful. i'll write two or three shell-scripts around, so it automatically transfers the tar-file to the slave ans starts another script there that puts the data in the right directory and restarts the replication... So in case the replication crashes, it's just a "click" and everythings fine again. ;) that'll save me a lot of time! but i need to be able to select *one* database and exclude *one* table from that database... if there's nobody else needing that, i'll just make some changes in your script and customize it for my system, otherwise I (or you?) could add that feature ,although i won't find much time for that before february. i'll see what the response is by then. > > Thanks, > > Jeremy thanks to you for the script! (i thought about programming something like that, too, but just didn't come any further than thinking about it... i just didn't have more time. :( ) Jan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: inserts with now() resulting in replication-problems
> "JK" == Jan Kirchhoff <[EMAIL PROTECTED]> writes: JK> If the Slave gets out of sync (loses the connection to the server), connects JK> again and tries to catch up, it processes those two queries *within one JK> second* which would result in an duplicate primary key on the slave. The JK> Slave would abort with an error and the replication would stop. But then the slave is still not in sync since the data is different. That doesn't seem to make sense for a replication scheme... Just seems wrong to me, but what do I know ;-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
