Mutable mysql servers accessing the same data dir

I would like to know how feasible it would be to have more than one mysql server accessing the same data dir. e.g. having two different computers accessing the data dir over a nfs mount my logic tells me that it will work correctly seeing that mysql spans a new process for each query dose

Re: Newbye speed question - which setup to use for indexing

Hi, No, MySQL never uses multiple CPUs for the same query at the same time (the OS could switch the thread between CPUs over time, but that doesn't count :-)). Each connection gets one thread and one thread can only run on one CPU at a time. It would be pretty hard (if not impossible) to have

RE: Installing

Make all gives me this libmysql.c: In function `mysql_real_connect': libmysql.c:2177: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:2177: too few arguments to function `gethostbyname_r' libmysql.c:2177: warning: assignment makes pointer from integer without

Convert Foxpro database to Mysql

Hello, i need some help, i want to convert the existing foxpro database into mysql database. Any idea? == Dwi Suharto [EMAIL PROTECTED] System and Network Administrator

Re: Tomcat, Connection Pooling, and MySQL

you need to put mysql-connector-javax in tomcat/common/lib and then specify parameter namedriverClassName/name valuecom.mysql.jdbc.Driver/value /parameter in your server.xml Adam On 10/03/2003 04:35 PM Dan Greene wrote: I got it working... unfournately it's on

MySQL, Second Edition, now available in French

MySQL, Second Edition, is now available in French. Information is available at: http://www.kitebird.com/mysql-book/ http://www.pearsoneducation.fr/espace/livre.asp?idEspace=73idLivre=1771 -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL

MySQL Cookbook now available in German

MySQL Cookbook (O'Reilly Associates) is now available in German (translated by Lars Schulten, Stefan Hinz Peter Klicman). Information is available at: http://www.kitebird.com/mysql-cookbook/ http://www.oreilly.de/catalog/mysqlckbkger/ -- Paul DuBois, Senior Technical Writer Madison, Wisconsin,

MySQL w/dual-master replication?

Hi there, I realize it's not supported, but nonetheless, I need to investigate how possible it is. The primary goal is high-availability, not performance scaling. It sounds like if I'm careful, it might work out ok. Careful means: - No auto_increment columns... handle unique key assignment

mysql account

Hi, folks. I use WinXP + MySQL. I deleted all the rows from the 'user' table of the 'mysql' database except my own account (host: localhost, user: alan, password:alan). --- I was hoping only I have the access to the MySQL databases. The problem is that I still can login to MySQL by the DOS

RE: mysql account

do u have a .my.cnf in c:\ dir or c:\windows dir ? from DOS when u issue a mysql command it usually picks up the username and password from the .my.cnf file. - Shanta -Original Message- From: Wang Feng To: [EMAIL PROTECTED] Sent: 10/4/2003 2:35 PM Subject: mysql account Hi, folks.

remote connection 4

when i try to connect to my mysql database from another machine i get a error like this %mysql -h domain.com -u tellus ERROR 2003: Can't connect to MySQL server on 'domain.com' (61) The port don't listen and this is disabled in my.cfg # #skip-networking whats wrong and how do i allow remote

Re: mysql account

At 4:35 +1000 10/5/03, Wang Feng wrote: Hi, folks. I use WinXP + MySQL. I deleted all the rows from the 'user' table of the 'mysql' database except my own account (host: localhost, user: alan, password:alan). --- I was hoping only I have the access to the MySQL databases. The problem is that I

Re: remote connection 4

At 22:55 +0200 10/4/03, Ms Carlsson wrote: when i try to connect to my mysql database from another machine i get a error like this %mysql -h domain.com -u tellus ERROR 2003: Can't connect to MySQL server on 'domain.com' (61) The port don't listen Apparently the MySQL server on domain.com is not

Re: changing TMPDIR for tempory file location

At 13:20 -0500 10/3/03, dan orlic wrote: Hello all, My query is about changing the tmpdir on mysql. As stated in on the mysql.com site it states that if it is not set it uses the default, in my case, the default was /tmp. It also states that to change it you can do so in the mysqld_safe

Re: Mutable mysql servers accessing the same data dir

At 2:45 -0400 10/4/03, Kenneth Lichtenberger wrote: I would like to know how feasible it would be to have more than one mysql server accessing the same data dir. Not recommended. e.g. having two different computers accessing the data dir over a nfs mount And *especially* not recommended over

Re: mysql 4.0.15 and latest redhat enterprise AS Beta - segmention fault

At 12:01 +0200 10/3/03, Thomas Gusenleitner wrote: HI List! mysql 4.0.15 won't start on the latest beta of the redhat enterpise AS. (will be released this month) i used the std. rpms for linux x86. i get the following error: Starting mysqld daemon with databases from /var/lib/mysql

Re: GROUP BY/ORDER BY Problem

At 5:52 -0700 10/3/03, Ed Smith wrote: Why doesn't the following work: mysql CREATE TABLE dog(id integer, breed char(20), age integer, weight integer) ; mysql SELECT breed, MIN(age) - FROM dog - GROUP BY breed - ORDER BY MIN(age); ERROR : Invalid use of group function I don't

Re: Multiple-Column Unique Index Redundancy

At 18:06 -0400 10/3/03, John Kornet wrote: I've been over a few books, the site, and the archives... Can someone please confirm that if I create a unique index over 2 columns, it will be redundant to create a regular index for the first? In other words, does the left-prefix rule apply to

ip range lookup

I have a table that maps ip-ranges to countries: each record consists of 2 ip numbers (unsigned int's) and the country in which all ip's between those two are located. How should I setup the table to have fast ip lookups ? Making a primary key of the 2 ip's and doing a 'select .. between ip1 and

Re: ip range lookup

Hi Willem, I don't *think* MySQL optimizes BETWEEN like that to use an index. Have you tried this?: SELECT * FROM ipcountry WHERE ip1 = 123456789 AND ip2 = 123456789; Matt - Original Message - From: Willem Bison Sent: Saturday, October 04, 2003 6:08 PM Subject: ip range lookup I

Re: ip range lookup

Hi Willem: I have the same database and the only thing different is that I included the country iso name into the primary key: mysql describe ip_country_database; +-+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra |

Re: mysql account

Hi, Shanta I do have a 'my.cnf' in 'c:\windows' dir, and it's called 'my.ini' in WinMySQLadmin. As I mentioned early, the ONLY user and password in 'my.cnf' is: user=alan, password=alan. Wait, this is amazing! (I just gave it another try) After about 6hrs, it works now!!! Now only 'alan' can

Re: Convert Foxpro database to Mysql

On Saturday, October 4, 2003, at 11:05 AM, Dwi Suharto Panese wrote: i want to convert the existing foxpro database into mysql database. Any idea? Sure, I've done it a lot. What exactly do you need to know? ___/ / __/ / / Ed Leafe http://leafe.com/

Re: mysql account

Paul, I am assuming that the 'alan' account that you're planning to use has all privileges. Otherwise, you will find after flushing the privileges that you'll no longer be able to administer your server without starting it with the --skip-grant-tables option... The *alan* account does have

slow performance with large or list in where

If I do a query such as: SELECT * from foo where fooid = 10 or fooid = 20 or fooid = 03 ... with a total of around 1900 or fooid = parts on a given table with 500k rows, it takes about four times longer than doing 1900 separate queries in the form: SELECT * from foo where fooid = 10 fooid is

Re: Blob fields

Hi, I have the question related to this topic, hopefully you could help me on this. Is that possible that we insert an encrypted image into blob fields where the encryption is done by using mysql existing function (AES_Encrypt) from the client side? If yes, how is the procedure ? Thanks in