how to mysql database cluster! help!

Hi friends, I am a system administrator. I am from China:) We want to build a big system with Mysql for authortication,But we don't know how to establish cluster for Mysql, Could you help me please and tell me what we must to do! Waiting for your answer and thanks very much! WeiMing.Li -

Windows MySQL client

Hello I am trying to get a mysql client working in windows, and have a few questions I would like to ask. My environment is this: I am using the Borland command-line tools, version 5.5, and am currently running Windows 98, but would obviously like the client to work on all(!!) flavours of Windows

Re: Replication Server is missing rows

On Fri, Nov 02, 2001 at 03:07:42PM +0600, Ershad Shafi Chowdhury wrote: > > Hi! Has anyone experienced a replication server to miss updates? Our > master is running Mysql 3.23.33 on RH 6.1 Kernel 2.2.12-20 and the > slave is running 3.23.24 on Solaris 2.5.1 Normally Inserts and > updates occur on

Re: Design,Performance and Speed of MySQL

On Sat, Nov 03, 2001 at 12:07:03AM +, Manjeet Singh wrote: > Hi Group, > > I am new to mysql, and would like you all to give some time in > resolving my trouble. I am stuck up with a problem of designing > stores database for a big company.The company is located in > different places and want

Re: Need help with a query ...

Hi John Kelly, This is not a perfect solution but may be useful to you. But still with two queries! From Mysql prompt issue these two queries. SELECT @maxcat := max(Category) FROM table WHERE category = 'Sports:Football:Players' OR category = 'Sports:Football' OR category = 'Sports'; Select

Re: scaling/tuning problem

On Fri, Nov 02, 2001 at 03:37:53PM -0800, another oracle dba wrote: > Hi. > > I have a query which completes in about 9 sec when executed alone, > but the time grows dramatically when I execute several similar > queries at the same time. If I execute 3 queries the time grows to > 27-40sec, for 5

Re: performance of joins

On Sun, Nov 04, 2001 at 01:06:27AM +0100, florian wrote: > > im storing pretty big amounts of customer data in a mysql databases. > its about 2 million rows. what im wondering about now is, how does > mysql perform joins on such amounts of data? > > i was planning to split the info in at least 3

Re: Spawned process, locked table.

On Sun, Nov 04, 2001 at 09:06:02PM -0400, Corey Kaye wrote: > This is my Perl script. I though that adding $query->finish would > unlock the table but it didn't. It looks like the only way around > this is to connect/disconnect from the DB between each update. All > that connecting/disconnecti

Re: Problem mysql installation

On Mon, Oct 29, 2001 at 04:06:39PM -0300, Webmaster wrote: > Hi all; > > i have problem with mysql -3.23.42 installation on my freebsd 4.3-RELEASE, > when I execute a make > i get an error "make: no target to make". > > Thanks and have a great day! > I guess you haven't run the "configure" scri

Re: Addendum: DBI Handle Has No Magic

On Sat, Nov 03, 2001 at 07:40:02PM +, Alex Kirk wrote: > > I forgot to mention one very important thing: this error cropped up > after I edited > /usr/local/libdata/perl5/site_perl/i386-openbsd/DBI.pm to use DBI > version 1.20 instead of 1.15 (apparently, this file was not updated > after I un

Re: XML export

On Sun, Nov 04, 2001 at 10:49:55PM -0600, Paul DuBois wrote: > At 10:16 PM -0800 11/4/01, Philip Hernandez wrote: > >Is there any support for XML export from MySQL databases? > > No, but you can do this relatively easily from within a program, > e.g., using the XML::Generator::DBI Perl module. T

Re: XML export

At 10:16 PM -0800 11/4/01, Philip Hernandez wrote: >Is there any support for XML export from MySQL databases? No, but you can do this relatively easily from within a program, e.g., using the XML::Generator::DBI Perl module. - Be

Re: Refresh table after deleting a row

At 4:26 PM -0500 11/4/01, duraid wrote: >i have a table with and ID column that auto_increment with that >following content > >++--+++ >| ID | JokeText | JokeDate | AuthorName | >++--+++ >| 1 | what's up? | 2

Re: MySQL to MS' Access '97

¿ÿ^˜:ˆô[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/

[NEWBIE] How to install MySql++1.7.9?

My deepest appologies folks. I posted this to the wrong mailing list. Sorry for the spam. *bows low* I will now post this to the correct mailing list [[EMAIL PROTECTED]] Terribly sorry. -PK- [Filter bypass keywords: database,sql,query,table ;) ] ---

[NEWBIE] How to install MySql++1.7.9?

Hello All. *disclaimer* I'm blond. I'm a linux newbie. I've searched the mailinglist/newsgroup archives. *end disclaimer* I'm trying / wanting to install mysql++ on my MANDRAKE 8.1 LINUX MACHINE. That means i'm running GCC/G++ VERSION 3.0.1 Could someone please be kind to explain IN DUMB SPEA

XML export

Is there any support for XML export from MySQL databases? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail

Re: A small patch for mysqlhotcopy

On Sun, Nov 04, 2001 at 08:07:36PM -0800, Matthew Clegg wrote: > > Hi there, > > I have been attempting to use mysqlhotcopy to make a backup copy of > all of the databases on a server. It wasn't completely self-evident > from the Mysql manual how best to do this, so I tried the following: [sni

MySQL Inquiry

Hello,     Can anyone help me?  I want to use MySQL locally.  My PC has no networkcard and no modem.   I want to access my database located in my PC what should I do? I am using Visual Basic and ODBC.   What should I set so that I would not need t

A small patch for mysqlhotcopy

Hi there, I have been attempting to use mysqlhotcopy to make a backup copy of all of the databases on a server. It wasn't completely self-evident from the Mysql manual how best to do this, so I tried the following: mysqlhotcopy -u blah -p blah "--regexp=.*" --flushlog /blah/blah/blah/destdir

Spawned process, locked table.

I'm writing a web application for a client in PHP. One function that a user can perform results in a very expensive update. To try and speed up this process (free up the user) i wrote a Perl script that performs the bulk of the work. When the user runs the PHP page, the PHP page updates one

RE: Setting a DEFAULT value

I suggest a few things. First, set it to NOT NULL DEFAULT 1, and then set the value explicitly to null, which will cause it to use the default value. The problem with inserting '' is that its casting to an integer and mysql decides that '' should be 0. Or try using : insert into table (column1,

RE: join dilemma

Thanks for your pointer. This SQL statement ended up working: Thanks for your pointer! This ended up working for me: SELECT * FROM profiles LEFT JOIN allposters ON (profiles.titlesid = allposters.titlesid) LEFT JOIN officialsites ON (profiles.titlesid = officialsites.titlesid) LEFT JOIN titles ON

Repair with keycache state while ALTERing TABLE

Hi, When doing an Alter Table, what does state Repair with keycache Mean, and should it take 27 hours (so far) on a 26,000,000 record table. And another issue: When searching the archives, I'll get something like 4. Re: Repair with keycache

Delphi MySQL w/InoDB

Is anyone using ZEOS and Delphi with MySQL w/InoDB? I am wondering how the transaction stuff runs or if it even works with this combination. Many Thanks M;) MySQL database sql - Before posting, please check: http://www.m

RE: join dilemma

> I have a SQL statement that I use to grab movie profiles. When I > constructed > the input form, I decided I didn't want to use blank entries for > tables that > didn't have a entry for that particular film e.g. a poster wasn't > available > for sale. > > This SQL statement in PHP works fine

join dilemma

I have a SQL statement that I use to grab movie profiles. When I constructed the input form, I decided I didn't want to use blank entries for tables that didn't have a entry for that particular film e.g. a poster wasn't available for sale. This SQL statement in PHP works fine when EVERY table has

Refresh table after deleting a row

i have a table with and ID column that auto_increment with that following content ++--+++ | ID | JokeText | JokeDate | AuthorName | ++--+++ | 1 | what's up? | 2001-11-04 | duraid | | 2 | duraid | 2

Re: Using UNION and UNION ALL on a database running 4.0

Oh! Ok. Thanx! Although I didn't really want to do all of that, I guess it's the only way. Unless someone has something better. - Deryck Henson - http://www.sourcecodecafe.com - Original Message - From: "Fournier Jocelyn [Presence-PC]" <[EMAIL PROTECTED]> To: "Deryck Henson" <[EMAIL P

Re: Setting a DEFAULT value

On Sun, 2001-11-04 at 13:52, Chris Williams wrote: > I'm trying to create at table that inserts a default value into a field if > nothing is supplied. If in interpret the documentation correctly this should > be accomplished by something like this: > > CREATE TABLE Location (LocationID VARCHAR(10

Setting a DEFAULT value

I'm trying to create at table that inserts a default value into a field if nothing is supplied. If in interpret the documentation correctly this should be accomplished by something like this: CREATE TABLE Location (LocationID VARCHAR(10) NOT NULL PRIMARY KEY, Name VARCHAR(50), Address1 VARCHAR(5

Installation of grant tables failed

>Description: I've tried to install MySQL-2.23.37 on LinuxPPC dr4 (not a recent distribution, I know that...), from the source code (mysql-3.23.37.tar.gz). unzip of the file was successfull, configuration and compilation seem to have worked fine, but the installation of the grant tables failed, an

grant permission

Hi all, Do anyone have this experience before?? I have granted the permission for a machine to access mysql databases several times and then flush privileges. I use perl DBI module to connect to databases through Web. But I found that after a day or even several hours later. I found that the apac

strange table corruption in 4.0

Hi, I am trying version 4 with myIsam tables. (I am almost ready to move to some other hopefully safer type ). The problem is I get table corruption. I have a large database(21000 tables, but the whole /var/lib/mysql/mydatabase directory is less than 800MB) database. I know this is stra

Re: Where UPDATE documentation?

Uriel Wittenberg writes: > Carl, I appreciate your response, but I did check both the table of > contents and the index. I did not do a string search on "update," if > that's what you had in mind. I admit that the search function is as good as one might wish. And I agree that finding things in

Re: performance of joins

well. for now it can only be one contact and one address per customer. the thing is though, that also other people can have addresses and contacts. so for example there will be a user table or something like that. and a user will also have address and contact information. would you still rec

How to modify safe_mysqld to email when mysql server missing?

NatureHi, How can I modify safe_mysqld to make it email me if the mysql server fails/shuts down for some reason please? regards, Graham Nichols. - Before posting, please check: http://www.mysql.com/manual.php (the manual

mysql_install_db error

>Description: After doing scripts/mysql_install_db I get errors /usr/bin/mysqdl_safe: line 278: 2759 Illegal instruction $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USEROPTION --pid-file=$pid_file --skip-locking >>$err_log 2&>1 01110

gui normalisation

Can anyone recommend any gui tools that would help during the normalisation proccess. kind regards Paul Thanks to paul DuBois for his excellent book MySQL - Before posting, please check: http://www.mysql.com/manual.php (t

RE: Where REGEX documentation?

> Under "Description of MySQL regular expression syntax", the manual says: > > > This is a simplistic reference that skips the details. To get more exact > information, see Henry Spencer's regex(7) manual page that is included > in the source distribution. > -

Re: mysql and cgi

I finally got the following few lines of code to work: $userdb=$feilds{'user'}; $rows=$dbh->do ("INSERT INTO bandbook (user, ect, ect, ...) VALUES(?,?,?,?,?,?,?)", undef, $userdb, 'ect', 'ect', ) || die "fucked up inserting data: $DBI::errstr"; print "$rows row(s) added to ba