Mysql with innodb support

I am setting up a web site with Linux (redhat 7.1), apache, php and mysql. I need the version of mysql with innodb support. Can anyone indicate to me what file or files I need to obtain to install thecorrect version of mysql and where I can down load them? Thanks in advance Regards Peter

error while make of 3.23.52

Hi All! mysql, sql, query I am trying to install mysql-3.23.52 . I configured with following command and then had run make. Make gives the following errors. Please help ./configure --with-low-memory --with-innodb --with-mysqld-ldflags=-rdynamic errors during make

Re: Processing the join

I am interested in the internal join algorithms, not the join types that can be found in the manual. My question is how the join types in the manual are processed internally? Or, what are the different join algorithms supported by MySQL? It depends on your database query structure and

Demande d'inscription à mysql-france

Bonjour, Vous avez récemment demandé à vous inscrire au groupe mysql-france. Comme vous êtes déjà membre de ce groupe, votre demande ne sera pas prise en compte. Pour toute question sur l'envoi de messages à ce groupe, veuillez envoyer un e-mail à [EMAIL PROTECTED] Cordialement, L'équipe

Problem with ALTER TABLE (err 1068)

Hello, I have a problem with the command ALTER TABLE. For example, this simple table test : +-+---+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+---+--+-+-++

Mysql eating up diskspace.

Hello everyone. I have had this very strange problem with Mysql, it seems to start eating diskspace untill the disk is full, restarting the mysql process seems to free all the used space again. Any idea what could be wrong? Kind regards Michael Wulff Nielsen

Re: Default Win install -- mySQL autostarts when booting?

I did the normal default install. It seems to start up the mySQL server automatically when I start up Windows. Hence my question: Is there a standard way to change that so the server only runs when explicitly invoked? I think the WinMySQLAdmin program automatically installs MySQL as a

RE: Mysql with innodb support

Hi Peter. You should download the max version of mysql binaries from www.mysql.com. It has innodb support. Also you could download the source files and compile mysql with innnodb support. Iago -Mensaje original- De: Peter Goggin [mailto:[EMAIL PROTECTED]] Enviado el: miércoles 11 de

Server's Ip number

Hi all. Anybody knows how to obtain the server's ip number in MySQL? Is there any variable or function? Thanks in advance. Iago - Before posting, please check: http://www.mysql.com/manual.php (the manual)

ResultSet.getDouble() not working with JDK 1.1.8

How-To-Repeat: 1. Use: JDK 1.1.8 2. Use: mysql-connector-java-2.0.14-bin.jar 3. Run testsuite file Transaction.java/class Problem in ResultSet.getDouble() when testing testsuite Transaction.java file: java Transaction java.lang.NoSuchMethodError: java.lang.Double: method

Re: Processing the join

That is why you need to use the EXPLAIN command. As I understand it, MySQL has a number of different ways of doing a JOIN, and it attempts to optimise those dynamically by inspecting not only which indexes it has available but the sizes of the tables involved (e.g. to try to use the brute-force

Re: Processing the join

Yes, this is correct. But the thing is that I don't want to find out how a certain query is processed but instead how the processing is done when the query type is determined by the join optimizer. When the optimizer has decided to do a full table scan, does it do it as a nested loop join, a

Innodb datafile usage map

Hi people, Is there any way I can see how much space each database is using from the innodb data file? Something showing how the space is divided among the databases. Thanks. sql,query Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax)

Can I use BerkerleyDB-4.0.14 for MySQL ??

Hello everybody !! I am a Chinese!! So my English is not very good. I hope someone can understand my question!! my question is : The MySQL-3.x.x and MySQL-4.x.x can use BerkeleyDB. But the version OF BerkeleyDB is V3.2.9, How can I use BerkeleyDB-4.0.14 in MySQL Thanks !!

installing

I have unzipped mysql-3.23.51-win-src.zip but cannot find the setup.exe file anywhere. What do I do next? Robert - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

R: installing

You have downoladed the source zip file, and so you have to compile it or download the binary version. Danilo -Messaggio originale- Da: Robert Barbaro [mailto:[EMAIL PROTECTED]] Inviato: venerdì 12 luglio 2002 11.52 A: [EMAIL PROTECTED] Oggetto: installing I have unzipped

Error 1053 stalling replication

Mysql, sql, etc. Hi, I am using a slave to perform backups using mysqlhotcopy. This locks all tables in my database for 10 minutes. Sometimes the replication is aborted during the period that the tables are locked. The error message in the slave's log is: ERROR: 1053 Server shutdown in

RE: Problem with ALTER TABLE (err 1068)

Maybe it is because some of your id are bigger than 127 wich is the limit for the Tinyint and when it is converted to this type, 127 is replacing all your id bigger than 127. Then you have multiple id with 127. Regards, Stephan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

is table or row write locked during an update ?

Hello, I need to do an update on a table : * Something like this : * UPDATE my_table mt SET mt.field1 = mt.field1 + 1 WHERE mt.id = 100 * And there can have concurrent updates on this record. is there a risk of 2 (or more) updates done at the same time

Re: is table or row write locked during an update ?

BRACHET,STEPHAN (Non-HP-France,ex1) wrote: Hello, I need to do an update on a table : * Something like this : * UPDATE my_table mt SET mt.field1 = mt.field1 + 1 WHERE mt.id = 100 * And there can have concurrent updates on this record. is there

re: mysql install Q... error connecting /tmp/mysql.sock

anand, Wednesday, September 11, 2002, 8:05:48 AM, you wrote: av I have redhat linux 7.1 and I have downloaded mysql-3.23.52 av and followed all the instructions as to how to install and how av to bring up the database the scripts/mysql_install_db worked av fine and then I did

RE: Problem with ALTER TABLE (err 1068)

Thanks Stephan for your answer but the error message would be : ERROR 1062: Duplicate entry '255' for key 1. I tried to drop the key : ALTER TABLE test DROP PRIMARY KEY but I had this message : ERROR 1075: Incorrect table definition; There can only be one auto column and it must be one auto

re: installing

Robert, Friday, July 12, 2002, 12:51:41 PM, you wrote: RB I have unzipped mysql-3.23.51-win-src.zip but cannot find the setup.exe file RB anywhere. You downloaded the source distribution :-) RB What do I do next? Compile MySQL from source or download Win binary distribution. -- For

re: Mysql eating up diskspace.

m, Wednesday, September 11, 2002, 11:11:13 AM, you wrote: mdwdnatodd I have had this very strange problem with Mysql, it seems to start eating mdwdnatodd diskspace untill the disk is full, restarting the mysql process seems to free mdwdnatodd all the used space again. mdwdnatodd Any idea what

re: Problem with ALTER TABLE (err 1068)

fpaul, Wednesday, September 11, 2002, 11:00:56 AM, you wrote: faadn I have a problem with the command ALTER TABLE. faadn For example, this simple table test : faadn +-+---+--+-+-++ faadn | Field | Type | Null | Key | Default | Extra

Why are OR-Clauses handled so badly?

I am using mysql select version() as version; +-+ | version | +-+ | 3.23.48-log | +-+ 1 row in set (0.00 sec) on Suse Linux 8.0 and Solaris 8. The problem exists on both platforms. I have mysql select count(*) from auth_kn; +--+ | count(*) |

Re: can not connect or log into MySQL anymore.

Do not run myisamchk with the server running. Stephen Sokalski wrote: version: 3.23.37 running on an RAQ Problem: I can not log into MySql as root - it hangs after I give it a password. Background: MySql was running fine for a year and then just stopped running. Symptoms: 1) Mysqld

Re: Why are OR-Clauses handled so badly?

If you have proper indexes on alias, the optimizer should not make a table scan. You can try to add an index on pw too. Or you could combine the two queries with an UNION. But beside this point you have a possible problem with the basic design. It is possible that someone adds an alias that

Problems with client to sever access

I am using a win2000 server where mysql is installed under phptriad. I am trying to access the mysql databases from my machine by using the winmysqladmintool. This winmysqladmintool works on the server but on my machine the light is constantly red and it says the service is not installed or

Re: can not connect or log into MySQL anymore.

Stephen, mysqlcheck works while the server is running. P. Gerald Clark wrote: Do not run myisamchk with the server running. Stephen Sokalski wrote: version: 3.23.37 running on an RAQ Problem: I can not log into MySql as root - it hangs after I give it a password.

Re: Error 1053 stalling replication

I do: slave stop mysqlhotcopy slave start Martin Waite wrote: Mysql, sql, etc. Hi, I am using a slave to perform backups using mysqlhotcopy. This locks all tables in my database for 10 minutes. Sometimes the replication is aborted during the period that the tables are locked. The error

Re: Why are OR-Clauses handled so badly?

Am Mittwoch, 11. September 2002 15:19 schrieb Toni Strandell: If you have proper indexes on alias, the optimizer should not make a table scan. You can try to add an index on pw too. Or you could combine the two queries with an UNION. Sorry, UNION is not available, as it is implemented only in

Re: Why are OR-Clauses handled so badly?

Put an index on password. That should speed it up for you. Kristian Koehntopp wrote: Am Mittwoch, 11. September 2002 15:19 schrieb Toni Strandell: If you have proper indexes on alias, the optimizer should not make a table scan. You can try to add an index on pw too. Or you could combine the

Which one, InnoDB or BerkeleyDB?

Which one would be the best with MySQL thinking in reliability and performance? Thanks a lot for your thoughts! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

group by clause

: i have one table with 4 fields (nik,name,child_name,child_number) i wan to query that the result will be like this +--+---++++ + | nik | name | child1 | child2 | child3 | child4 | +--+---++++ + | 1 | pai | mai |

Re: AW: SQL help, search with related record in 2nd table

Carsten Thank you very much for pointing me in that direction, that nearly solved the issue but I still get a duplicate for each record that is in the second table (if WishListItems has 5 records for a Visitor, I get 5 duplicates in the result). I tried using GROUP BY to eliminate the

A new Idea for FULLTEXT searchs

mysql, query speed up _ Sorry I may be bothering you but I was thinking (gosh! this is so bizarre on me) that may be we can make MySQL SGML compatible. I agree that MYSQL cannot be manipulated to handle jerarquical information because this is

Is compiler advisory at source download valid?

Hi all. Is the compiler advisory at mysql source donwload web page still valid? The web page is http://www.mysql.com/downloads/mysql-3.23.html I've seen it some monts ago and I want to know if I could compiler the source with an gcc 3.0 compiler. These are the notes: Compiler Advisory:

Re: do i must use mysql_free_result()?

At 8:46 -0500 9/11/02, Dizzy Myope wrote: hi all:) int main(void) { . rs=mysql_store_result(connection);//get result to rs .. mysql_free_result(rs);// it is necessary ??? rs=mysql_store_result(connection);// get result

Error when executing mysql_install_db

Description: I have downloaded the binary mysql-3.23.52-hp-hpux10.20-hppa1.1.tar.gz grom mysql.com. After unzipping it and create the symbolic link in /usr/local/, I executed the script mysql_install_db. I receive the following message : Preparing db table Preparing host table Preparing user

re: Found a bug with... CREATE SELECT IF?

ant, Tuesday, September 10, 2002, 10:28:13 PM, you wrote: aasdn Apparently in 4.0.3 does not like if statements in it's aasdn SELECT query... A query that once worked now returns 0 when I use aasdn an IF, rather than the proper value How-To-Repeat: aasdn This is a simple example of

testfretf

Toni, Wednesday, September 11, 2002, 10:06:14 AM, you wrote: TS REALFROM: Toni Strandell [EMAIL PROTECTED] TS I am interested in the internal join algorithms, not the join types that TS can be found in the manual. My question is how the join types in the TS manual are processed internally?

First question: a howto.

I can't add a new user or I don't know the proper way to log into the server. I added a user; call him webley. Ran my sql statement to insert into the user and db tables. Granted all rights because I was unsure how many rights my cgi script would need. It does need to create new tables and

ANN: EMS MySQL Manager 1.9 released

EMS HiTech company is announcing the next version (1.9) of MySQL Manager -- A Powerful MySQL Administration and Development Tool for Windows95/98/ME/NT/2000/XP. You can download the latest version from http://www.mysqlmanager.com/download.phtml EMS HiTech is announcing the special offer as we

RE: Windows XP Installation Problems

Well, I finally figured out the problem, it was a corrupt installation package. Funny thing is I downloaded three different times from different sites. Working now, thanks. -=Bryan=- -Original Message- From: Miguel Angel Solórzano [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September

Re: First question: a howto.

At 10:12 -0600 9/11/02, [EMAIL PROTECTED] wrote: I can't add a new user or I don't know the proper way to log into the server. I added a user; call him webley. Ran my sql statement to insert into the user and db tables. Granted all rights because I was unsure how many rights my cgi script would

Q: How to determine size(s) of db files?

Is there a MySQL command that will return the amount of disk space used by a particular database? I find lots of references to size limits on tables / databases etc. but nothing on the actual 'disk usage'. This would be nice to have I think, since without access to the data directory on the

MySQL bug?

Folks, I'm experiencing some strange behavior with our mysql server and I'm curious to see if anybody else has had this problem. Over about a 3 month period, I noticed that the /var partition of our linux server claims to fill up. The server is well into it's 3 month cycle now and I have a

Re: MySQL bug?

Jeremy, What would I do without the internet??? I restarted mysql by hand and the discrepency immediately went away. I should have thought about that. Thanks! Mark On Wed, Sep 11, 2002 at 12:01:29PM -0500, Jeremy Tinley wrote: Are you deleting any logs and not restarting the server after

mysql on OS X PROBLEM!

hi all, i am running OS X 10.2 and this version of mysql: mysql status -- ./bin/mysql Ver 11.18 Distrib 3.23.51, for apple-darwin6.0 (powerpc) Connection id: 117 Current database: mysql Current user: root@localhost Current pager: stdout Using

Re: MySQL bug?

Maybe a simple mysqladmin flush-logs would have done it. Mark Dieterich wrote: Jeremy, What would I do without the internet??? I restarted mysql by hand and the discrepency immediately went away. I should have thought about that. Thanks! Mark On Wed, Sep 11, 2002 at 12:01:29PM -0500,

MySQL-DBI-perl-bin ... problems

hi list, have got an error in trying to install MySQL-bench-3.23.52-1 rpm says, that the file MySQL-DBI-perl-bin is reqired, but MySQL-DBI-perl-bin-1.1825-1 is installed. and so I could see in rpmfind.org, this file is the last one. would it be possible, that there should be another version

Re: Which one, InnoDB or BerkeleyDB?

On Wed, 11 Sep 2002, Guilherme Orcutt wrote: Which one would be the best with MySQL thinking in reliability and performance? Thanks a lot for your thoughts! InnoDB scales *MUCH* better than BerkeleyDB. While it did fine in our benchmarks consisting of a small number of records, in some

4.0.3 datadir mangle bug

From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: 4.0.3 datadir mangle bug Description: mysqld is mangling the datadir. Fed in /mysql and it produces . ysql How-To-Repeat: Upgrade from 3.23.52 to 4.0.3 Fix: Unknown at this time. Tried to feed parameters to

Re: mysql on OS X PROBLEM!

Have you done a 'mysqladmin reload' to reload the new grant tables into the server process? Any modifications you make to the permissions table won't take until until after a 'reload'. Rene philipp ringli wrote: hi all, i am running OS X 10.2 and this version of mysql: mysql

Re: 4.0.3 datadir mangle bug

At 13:02 -0500 9/11/02, Mike Gohlke wrote: From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: 4.0.3 datadir mangle bug Description: mysqld is mangling the datadir. Fed in /mysql and it produces . ysql It's only changing the command line parameters viewable with ps. If you issue a

ld flag cause make error

SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with END-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in ' and '). SEND-PR: From: root To: [EMAIL PROTECTED] Subject: ld flag cause make error Description: After running CC=gcc CFLAGS=-O3 \

Re: 4.0.3 datadir mangle bug

Paul DuBois wrote: At 13:02 -0500 9/11/02, Mike Gohlke wrote: From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: 4.0.3 datadir mangle bug Description: mysqld is mangling the datadir. Fed in /mysql and it produces . ysql It's only changing the command line parameters

error updating table

Hi, we have an application that connect to MySQL via MyODBC. Sometimes, we have this error: [TCX][MyODBC] Got error 5 from table handler and MySQL drops. When it comes back up, it first gives an error with BDB tables (the type we use): 020911 15:10:17 bdb: page 0: illegal page type or format

installation woes (4.0.3)

A problem on installation of 4.0.3. First, I tried with rpm -U and when I try to uninstall it says not installed when I try to install or upgrade it says already installed I looked at the rpm package files and try to erase them manually and they are not there So I tried the tarball

Re: Which one, InnoDB or BerkeleyDB?

I have done some small tests here and indeed InnoDB seems to be faster than BerkeleyDB. Thanks guys for your help! ;) ==MySQL List - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Rapid-fire connections causing MySQL grief

On Wed, Sep 11, 2002 at 02:55:01PM -0400, Kent Hoover wrote: Version: MySQL.3.22.32-log Does this problem ring a bell with anyone? I'm seeing two undesired behaviors, both, *I think* seem to be because I'm pounding a lot of connections against the same server/table, all from the same

Re: Re: Rapid-fire connections causing MySQL grief

On Wed, 11 Sep 2002, Jeremy Zawodny ([EMAIL PROTECTED]) wrote: On Wed, Sep 11, 2002 at 02:55:01PM -0400, Kent Hoover wrote: Version: MySQL.3.22.32-log Does this problem ring a bell with anyone? I'm seeing two undesired behaviors, both, *I think* seem to be because I'm

Rapid-fire connections causing MySQL grief

Version: MySQL.3.22.32-log Does this problem ring a bell with anyone? I'm seeing two undesired behaviors, both, *I think* seem to be because I'm pounding a lot of connections against the same server/table, all from the same remote host. The workload that reaches MySQL is a succession of

PD: The win admin for Mysql

Hi I'm looking for some software (under windows) that will connect to a sql - mysql base and make some drop of structure and data of a database Do you know any small free program like this ? TeQ - Before

Re: PD: The win admin for Mysql

I've used dbtools http://www.dbtools.com.br/ However I'm using 1.0.12 rather than 1.0.15 since the newer version appears to have a few bugs. there is of cours mysqlgui from mysql (see their site). On Wed, 11 Sep 2002, =?iso-8859-2?Q?J=EAdrzej_Kolesi=F1ski?= wrote: Date: Wed, 11 Sep 2002

Lost connection upon connect from w2k client to rh7.3 server

hi all, I have a strange behaviour of a mysql 3.23.51 installation on a rh7.3 box in connection with connects from windows 2000 clients (no idea, if the windows version matters). Everytime I try to connect to the server (odbc, mysqlc-commandline-tool) I receive ERROR 2013: Lost connection

Re: Q: How to determine size(s) of db files? - Resolved

Eric Lamendola wrote: If you are using PHP, Then download phpMyAdmin from the website of the same name. It is the best PHP/Web based utility for connecting to a MySQL database. At 12:48 PM 9/11/02 -0400, Amer Neely wrote: Is there a MySQL command that will return the amount of disk

Re: Rapid-fire connections causing MySQL grief

At 01:55 PM 9/11/2002, you wrote: Version: MySQL.3.22.32-log Does this problem ring a bell with anyone? I'm seeing two undesired behaviors, both, *I think* seem to be because I'm pounding a lot of connections against the same server/table, all from the same remote host. The workload that reaches

mediumint(6) problem

Hi all, I have a small problem - I have the following table with numetic type. In my table is mediumint(6), but I can to insert value 11223344. I thougth the maximum value for mediumint(6) is 99. Do you have some idea what I should to do to be able insert value 99 as a maximum for my

Re: MySql/InnoDB crashes after a Select...order by DESC... LIMIT...

Rafa, - Original Message - From: [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, September 10, 2002 1:46 PM Subject: MySql/InnoDB crashes after a Select...order by DESC... LIMIT... Hello, I am working with mysqld-max-nt under windows 2000 and unsing

Re: mediumint(6) problem

At 23:05 +0200 9/11/02, Jan Kudrman wrote: Hi all, I have a small problem - I have the following table with numetic type. In my table is mediumint(6), but I can to insert value 11223344. I thougth the maximum value for mediumint(6) is 99. Why? Do you have some idea what I should to do to

MySQL-Front Discontinued

I went to http://www.anse.de/mysqlfront/ today ... the notice posted on the site says MySQL-Front - This project has been discontinued. Too bad ... Ansgar Becker developed a truly useful, powerful MySQL database management tool for us Windoze users.

RE: MySQL-Front Discontinued

I second that opinion. -Original Message- From: Gerald Jensen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 3:02 PM To: [EMAIL PROTECTED] Subject: MySQL-Front Discontinued I went to http://www.anse.de/mysqlfront/ today ... the notice posted on the site says MySQL-Front

RE: mediumint(6) problem

Mediumint refers to the fact that it is three bytes long rather than a regular 4 byte, 32 bit integer. It's range is like +/- 8,000,000 or so (look it up for sure) The 6 just has to do with how many digits will be displayed when you invoke the MySQL client for the row - spacing will be a

Re: MySQL-Front Discontinued

Hi. Too bad ... Ansgar Becker developed a truly useful, powerful MySQL database management tool for us Windoze users. The support forum is still active: http://mysqlfront.venturemedia.de/ According to the moderator, Ansgar is neither going to make it commercial nor willing to make it open

Should I downgrade my client libraries?

Hi all! I want to try out the demo version of Rekall ( http://www.thekompany.com/products/rekall/ ) but it is linked against libmysqlclient.so.10. I have libmysqlclient.so.11 from MySQL-4.0.2, and for some reason I don't even have any libmysqlclient.so.x from MySQL-4.0.3, but anyway I need

Re: Schema changes affect regular select?

Yuri, ADD COLUMN should not affect a SELECT concurrently running on the table. I tested this with a 3 million row InnoDB table. Can you repeat that unexpected behavior? Regards, Heikki Innobase Oy Copied message: ... Subject: Schema changes affect regular select? From: Yuri Date:

Re: MySQL-Front Discontinued

I share in that, Ansgar developed a very commercially sound product that he shared with the community. Thank-you Ansgar, [EMAIL PROTECTED] Patrick Sherrill And avid MySQLFront fan and user. CocoNet Corporation - Original Message - From: Manuel Villasante [EMAIL PROTECTED] To: 'Gerald

RE: MySQL-Front Discontinued

Maybe the code is horrendous. -mike -Original Message- From: Gabriele Carioli [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 3:22 PM To: MySQL Subject: Re: MySQL-Front Discontinued Hi. Too bad ... Ansgar Becker developed a truly useful, powerful

Re: mysql on OS X PROBLEM!

hi rene, thanks for your reply. yes, i do it being root: mysql -u root -p and in phpMyAdmin i see that the grant option for root is enabled. and i am loged into phpMyAdmin as root also. i really wonder what's going on... i mean, am i missing the point in some way or another? cheers, phil

my.ini in RH Linux 7,2

In win98 mysql keep configuration in my.ini. Which is the same file in RH Linux 7.2? Thanx Do You Yahoo!? @yahoo.grhttp://www.otenet.gr - Before posting,

Re: PD: The win admin for Mysql

Have a look at urSQL - http://www.urbanresearch.com/ursql On Wed, 11 Sep 2002, [iso-8859-2] Jêdrzej Kolesiñski wrote: Hi I'm looking for some software (under windows) that will connect to a sql - mysql base and make some drop of structure and data of a database Do you know any

Re: my.ini in RH Linux 7,2

At 23:51 +0100 9/11/02, nick gatsis wrote: In win98 mysql keep configuration in my.ini. Which is the same file in RH Linux 7.2? /etc/my.cnf, or the my.cnf file in the server's data directory. - Before posting, please check:

Data Type Advice

Hello mysql users: Would appreciate some advice on data types for a column. The value for the field would be a number that would never exceed 1000 but would have two decimal points limited to .25 increments e.g 5.25 or 7.75 There may be some simple calculations such as totals etc. What would be

Re: MySql/InnoDB crashes after a Select...order by DESC... LIMIT...

Heikki, does this bug affect all versions or just the -max windows versions... we just installed 4.0.3-beta (unix-freebsd) to do some benchmarking/testing tonite on innodb and this would impact us. Thx. Rafa, - Original Message - From: [EMAIL PROTECTED] Newsgroups:

Re: MySql/InnoDB crashes after a Select...order by DESC... LIMIT...

Hi, AFAIK, all versions are affected since I reproduced the bug with 4.0.4-beta under linux. Regards, Jocelyn - Original Message - From: PR [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 1:53 AM Subject: Re: MySql/InnoDB crashes after a Select...order by

Need help shutting down Mysql for upgrade

I'm running this on a RAQ. Here is the problem. Something very strange has happened to my older version of mysql (3.23.37). Not only can I not get it to shut down with /usr/share/mysql/mysql.server stop but even if I do a ps -ef | grep mysql and do a kill -9 on the pid, if I try to

Need help shutting down Mysql for upgrade

Stephen Sokalski wrote: I'm running this on a RAQ. Here is the problem. Something very strange has happened to my older version of mysql (3.23.37). Not only can I not get it to shut down with /usr/share/mysql/mysql.server stop but even if I do a ps -ef | grep mysql and do a kill -9

Re: Setting up a web server wit Redhat 7.3

So far as I can tell the mysql files included in the CD set are: mysql-3.23.49-3.i386.rpm mysqlclient9-3.23.22-6.i386.rpm mysql-devil-3.23.49-3.i386.rpm mysql-server-3.23.49-3.i386.rpm Do these files include Innodb support? Are they sufficient to install mysql? I would be grateful for any

Strange Problem: Need help shutting down Mysql for upgrade

Stephen Sokalski wrote: Stephen Sokalski wrote: I'm running this on a RAQ. Here is the problem. Something very strange has happened to my older version of mysql (3.23.37). Not only can I not get it to shut down with /usr/share/mysql/mysql.server stop but even if I do a ps -ef |

Re: Should I downgrade my client libraries?

Dan, I've got 4.0.3, and I compiled it from the source rpm. Seems that (at least with 4.0.3) mysql is statically linked, hence the lack of libmysqlclient. What you might want to do is make a soft line from libmysqlclient.so.11 to libmysqlclient.so.10 and see if that works. Ed Quoting

Re: my.ini in RH Linux 7,2

In the last episode (Sep 11), Paul DuBois said: At 23:51 +0100 9/11/02, nick gatsis wrote: In win98 mysql keep configuration in my.ini. Which is the same file in RH Linux 7.2? /etc/my.cnf, or the my.cnf file in the server's data directory. A quick way to find out is to run mysqld --help |

3G³¬´óÈÝÁ¿Êý¾Ý¿â¿Õ¼ä£¬ÔùËÍ2Gµç×ÓÓʾ֣¡

×𾴵Ŀͻ§£º ÄúºÃ£¡Ê±´´ÍøÂçÇ¿Á¦ÍƳöASP.NET¸ß¼¶ÐéÄâÖ÷»ú£¬ÊÊÓÃÓÚ´óÐ͵ÄÆóÒµ¡¢´óÐÍ µç×ÓÉÌÎñÍøÕ¾¡¢´óÐ͸öÈËÍøÕ¾£¨´øÂÛ̳ ÉçÇøµÈ£©¡£ ÒÔÏÂΪÐéÄâרÓÃÐÍCµÄÏêϸÅäÖÃ×ÊÁÏ£º ½Å±¾Ö§³Ö£ºASP ASP.NET CGI Active Perl Front Page 2000 À©Õ¹ Êý¾Ý¿âÖ§³Ö£ºACCESS SQLSERVER 2000£¨MS SQL£©Êý¾Ý¿â

Good MySQL Webhosting Company

Hello All, Can any one suggest a good company to host a MySQL+PHP website ? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

Re: Good MySQL Webhosting Company

This get asked every couple of days. Check the archives. FWIW, I host with Experhost.com Justin on 12/09/02 3:34 PM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: Hello All, Can any one suggest a good company to host a MySQL+PHP website ? Thanks