RE: Distributed MySQL : How to synchronize ?

Hi I have built and am testing a php module that is capable of this. I have an ultra high availability project where it must survive a server or network failure and switch seamlessly to the backup server. All queries are executed through a db abstraction class. It basically does the same as

Re: Distributed MySQL : How to synchronize ?

Hi, I wonder (i don't tested) if is possible to start two session of mysqld on each machine which work on the same database : one for master and one for slave. MACHINE1MACHINE2 1.Master Session - 1.Slave Session 2.Slave Session - 2.Master Session

Something is blocking a table in our db

Hi, Something is blocking our table (BOOKS) in a database that we don't have administrative rights to. (we rent from Hurricane Electric, www.he.net). Everytime we query the table it gets in the processlist with the state Waiting for table. We've killed every process in the processlist but we

Re: Something is blocking a table in our db

Hi again, This is our MySQL version: maple:~$ mysql --version mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) / Jacob From: Jacob Nordgren [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Something is blocking a table in our db Date: Sat, 11 May 2002 08:40:18 + Hi, Something

search character by character

Hi I would like a person to search for a surname. If for example you have the surnames Clark, Williams and Wilcox in the database. e.g. If the person search just for Wil the surnames Williams and Wilcox must be displayed. If the person search just for C the surname Clark must be displayed. I

Re: search character by character

G'day Nic Just by typing part of the word ,how can I make a search in databse possible by using something like SELECT in SQL? Seems like you just need the % wildcard character SELECT LASTNAME, FIRSTNAME, DEPARTMENT FROM EMPLOYEES WHERE LASTNAME LIKE %searchdata%; cheers kim

Re: search character by character

Replace your sql select query with these lines: SELECT LASTNAME, FIRSTNAME, DEPARTMENT FROM EMPLOYEES WHERE LASTNAME LIKE '%varLastName%' It makes caseinsensitive search, so when varLastName is 'C' it will find Clark and Wilcox ,because they contain letter 'C'. Also you can use 'varLastName%'

Re: search character by character

impala, Saturday, May 11, 2002, 12:53:20 PM, you wrote: i I would like a person to search for a surname. If for i example you have the surnames Clark, Williams and i Wilcox in the database. i e.g. If the person search just for Wil the surnames i Williams and Wilcox must be displayed. If the i

Re: columns no more

John, Saturday, May 11, 2002, 3:13:33 AM, you wrote: JD is there a way to delete a column from a table, without droping the whole JD table? Sure, you can use ALTER TABLE: http://www.mysql.com/doc/A/L/ALTER_TABLE.html JD If not is can I get sql to replicate the command to re create the

Re: shutdown of MySQL fails during system reboot or halt

Danny, Saturday, May 11, 2002, 7:15:31 AM, you wrote: DM I have an issue where upon system (YellowDogLinux v2.2) reboot or halt, DM if the mysqld is running i get the message that shutting down mysql: DM FAILED DM Has anyone experienced this? Or can someone perhaps help me understand DM what is

Re: Re: adding a new mysql user with rights to add other users

Jim, Thursday, May 09, 2002, 9:43:18 PM, you wrote: What rights do I need to give a new admin user so I can delegate the creation of new regular users BUT not allow this same admin user the ability to delete user he/she did not create in the first place. In short I want to create

Re: Help! Error building 4.0.2 under RH Linux 7.2

Hi Vadim, My mistake, sorry. :) I'm with the same problem in conectiva 7.0 (last week 4.0.2 compiles fine, but, after a bk pull, it gives me the same error). CL 7.0 uses gcc 2.95.3 I tested in CL 8 (gcc 2.95.3) and still don't compile. Vadim P. wrote: Hi Luciano, Could you please

MySQL Database Questions

Dear Mr. Jeremy D. Zawodny, I am subscriber of the mysql.com MailingList and have received some of your mails. From the mails I get the idea that you have quite some experience with mysql. We are planning to migrate our database (currently oracle) to mysql. Our database consists of about 150

Re: Something is blocking a table in our db

How can I check if there are any other query that locks my table? / Jacob From: Jacob Nordgren [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Something is blocking a table in our db Date: Sat, 11 May 2002 08:40:18 + Hi, Something is blocking our table (BOOKS) in a database that we

RE: geometric mean aggregate function

Interesting idea, Andrew. I don't know how to do what you're asking for, but I'd be interested to see it added too. I'd never heard of geometric means, but I can already think of several areas where they might be useful. Thanks for sharing the information on how they're calculated! Matthew

Re: Something is blocking a table in our db

One of our table is locked and there is not a process in the processlist. How can I find out why? I want to start use the table again. Our website is down! I've tried to flush the table but I don't have enough priveliges to execute that command... Any ideas are appreciated!!! Please help!

RE: MySQL Database Questions

* [EMAIL PROTECTED] 1. Is it a good idea to have all the columns in one big table ? This will depend on the nature of your data. You say you have many varchar columns. If many of them contains the same value, you could get substantial speed/space improvements by splitting (normalizing) the

Repair with key cache

When loading large amounts of data into MySQL there is a period oh high server activity followed by a long period of little activity. While on the little activity period, the process list reads Repair with key cache... How can I make the server work harder in this period and get done with

Best book on MySQL

I need to convert a PHP app from using Interbase to using MySQL. What is the best book? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please

DDL and MySQL

Coming from an Interbase background, I am use to using the Interbase Data Definition language to create the DB then use PHP to access it. From my brief reading, it appears that I should create a PHP script that creates the DB. Is that correct? What is the preferred extension for a MySQL DB?

Re: Best book on MySQL

Todd, I think the best book is PHP and MySQL Web Development by Luke Welling and Laura Thomson. ISBN: 0672317842 Publisher: Sams Pub Date: March 2001 I hope this helps. Regards, John Eacrett Principal Consultant Eacrett Consulting Lowell, MA. USA [EMAIL PROTECTED] - Original Message

What does this message mean

I am receiving this message from MySQL: +++ Sorry. Your message could not be delivered to: w3d3demo (Mailbox or Conference is full.) +++ What am I missing? Todd -- Dr. Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED]

Re: newbie question - what does test\_% mean

At 20:55 -0700 5/10/02, Frederick Shaul wrote: I understand what test% might mean, but don't know what test\_% means. It's a SQL pattern string that matches a literal test followed by a literal _ followed by anything. _ in SQL patterns normally matches any single character. \_ escapes it to

Re: search character by character

At 2:53 -0700 5/11/02, impala wrote: Hi I would like a person to search for a surname. If for example you have the surnames Clark, Williams and Wilcox in the database. e.g. If the person search just for Wil the surnames Williams and Wilcox must be displayed. If the person search just for C the

Re: What does this message mean

At 8:58 -0700 5/11/02, Todd Cary wrote: I am receiving this message from MySQL: +++ Sorry. Your message could not be delivered to: w3d3demo (Mailbox or Conference is full.) +++ What am I missing? It means there is a bad address on the subscriber list. Just delete all such messages. Todd --

Re: What does this message mean

I have been receiving this same error message every time I post. ?? anybody? Todd Cary wrote: I am receiving this message from MySQL: +++ Sorry. Your message could not be delivered to: w3d3demo (Mailbox or Conference is full.) +++ What am I missing? Todd -- Dr. Todd Cary Ariste Software

How do i add an attachment

I have a mailing list in Mysql database working very well; How do I add an ATTACHMENT(files of any type) to emails going to the addresses in the mailing list stored in the database? Thanks __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience

How do i add an attachment

I have a mailing list in Mysql database working very well; How do I add an ATTACHMENT(files of any type) to emails going to the addresses in the mailing list stored in the database? Thanks __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience

Re: What does this message mean

Me too :( I think everybody posting on this list is receiving it. I have added '[EMAIL PROTECTED]' to my mail filter blacklist so that these messages go directly to Trash. Regards -- Joseph Bueno NetClub/Trader.com Ryan Hatch wrote : I have been receiving this same error message every time

Re: How dangerous is OPTIMIZE TABLE?

Hi. This is more intended to be an second answer to the original post, but I don't have it anymore. On Fri, May 10, 2002 at 11:00:56AM -0700, [EMAIL PROTECTED] wrote: On Fri, May 10, 2002 at 12:55:39PM +0200, Mark wrote: How dangerous is OPTIMIZE TABLE? I have been reading through the

[Newbie] Connecting for the first time

I have never opened or done anything with MySQL, so I am completely in the dark. All I know is that phpinfo() tells me that MySQL is implemented on my Linux/Apache server. What is my first step to getting connected? This does not work: ? $link = mysql_connect(http://209.204.172.137;, root,

Re: How dangerous is OPTIMIZE TABLE?

Hi, AFAIK, it may cause problem if used on table for which you are using INSERT DELAYED. http://www.mysql.com/doc/B/u/Bugs.html Regards, Jocelyn Fournier - Original Message - From: Benjamin Pflugmann [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Mark [EMAIL PROTECTED] Sent: Saturday,

How do i add an attachment

I have a mailing list in Mysql database working very well; How do I add an ATTACHMENT(files of any type) to emails going to the addresses in the mailing list stored in the database? Regards, Francis __ Do You Yahoo!? LAUNCH -

RE: geometric mean aggregate function

This is probably not the most elegent solution, but here is something that works in 3 SQL statements using user variables. mysql select @gmean := 1, @ct := count(*) from g_mean; mysql select @gmean := @gmean * test_val from g_mean; mysql select power(@gmean, (1/@ct)) as Geo_Mean; See details

Repair with key cache ???

Hello, I wonder whether someone has and idea of what Repair with key cache means. When loading large amounts of data into MySQL there is a period of high server activity followed by a long period of little activity. While on the little activity period, the process state in the process list

Re: How dangerous is OPTIMIZE TABLE?

- Original Message - From: Benjamin Pflugmann [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Mark [EMAIL PROTECTED] Sent: Saturday, May 11, 2002 7:24 PM Subject: Re: How dangerous is OPTIMIZE TABLE? Hi. This is more intended to be an second answer to the original post, but I don't have

Re: [Newbie] Connecting for the first time

- Original Message - From: Todd Cary [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, May 11, 2002 7:27 PM Subject: [Newbie] Connecting for the first time What is my first step to getting connected? This does not work: ? $link = mysql_connect(http://209.204.172.137;, root,

Re: [Newbie] Connecting for the first time

Mark - First, I found out that MySQL was not installed on my RH Linux 7.2 server. Now I have it installed, but I am not sure where the admin is located. Not only is MySQL completely new, I just know enough about Linux to get it up and running with Apache/PHP/Interbase. So, please understand

NOW()

Hi, I have a table with a timestamp field called dtins. When i insert a row to the table, the value of this field is setted to NOW() just for the inserted the record. My problem is when i update some record, its dtinst value is change again, without a ask to :( How can i avoid this? Is

Re: Repair with key cache

Hi. How do you define/determine activity? The operation is probably I/O bound. From the message you get I assume increasing the key cache matter. Regards, Benjamin. On Sat, May 11, 2002 at 11:00:11AM -0400, [EMAIL PROTECTED] wrote: When loading large amounts of data into MySQL there

Re: table handler error 27 (cont'd)

Hi. Hm. Maybe you have too few free space in your tmp directory? Regards, Benjamin. On Fri, May 10, 2002 at 06:38:19PM -0400, [EMAIL PROTECTED] wrote: I have checked my file size in my data dir and can't find any files close to 2GB even looking in subdirs. Does this mean that

Re: NOW()

I'm not sure whether your question is about column types or the NOW() function. TIMESTAMP fields are defined as being automatically updated every time the row is modified. If you want a field which simply holds a timestamp which does *not* get automatically updated, use a DATETIME or similar

Re: Something is blocking a table in our db

Hello. Posting in 2 hour intervals is a perfect way of getting ignored on the list. This is a list of volunteers. If you require a quick answer, consider buying support. That said, waiting for table does not indicate normal table locks. That would be locked. So something different is going on.

Re: [Newbie] Connecting for the first time

- Original Message - From: Todd Cary [EMAIL PROTECTED] To: Mark [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, May 11, 2002 8:31 PM Subject: Re: [Newbie] Connecting for the first time Mark - First, I found out that MySQL was not installed on my RH Linux 7.2 server. Now I

Re: Repair with key cache

Benjamin... I get a feel for the amount of activity by looking at the processes running and the amount of cpu time they are using.. (on linux: ps xu) Correct me if I am wrong. I understand that the sort_buffer is the most important when creating keys... I set the sort buffer to

Re: Best book on MySQL

On Saturday, 11. May 2002 17:43, Todd Cary wrote: I need to convert a PHP app from using Interbase to using MySQL. What is the best book? Hello Todd, I prefer two books 1st: the PHP online-manual (http://www.php.net/docs.php) 2nd: MySQL from Paul DuBois, also known as the bible Newriders

Re: Best book on MySQL

MySQL Paul DuBois New Riders Plus, he's here on the list answering questions... :) --jeff - Original Message - From: Todd Cary [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, May 11, 2002 8:43 AM Subject: Best book on MySQL I need to convert a PHP app from using Interbase

SQL Pattern Matching

Thanks for answering search character by character 11 May 2002 Making use of a HTML textfield which sends text to variable 'varLastName'. How do I concatenate the variable part('varLastName') with the % part is it something like: SELECT LASTNAME, FIRSTNAME, DEPARTMENT FROM EMPLOYEES WHERE

Re: How do i add an attachment

On Saturday, 11. May 2002 19:38, yimdjo francis wrote: I have a mailing list in Mysql database working very well; How do I add an ATTACHMENT(files of any type) to emails going to the addresses in the mailing list stored in the database? Hello Francis, I guess this not the right mailing list

Installing mysql on Linux

Hello, I'm trying to install mysql on RedHat Linux 7.0. I've downloaded the rpm. And I've install it using the command rpm -i rpm name. Now my question is. What directory is the program located in? Any help is greatly appreciated. Hoa

Re: Installing mysql on Linux

Hoa Doan wrote : Hello, I'm trying to install mysql on RedHat Linux 7.0. I've downloaded the rpm. And I've install it using the command rpm -i rpm name. Now my question is. What directory is the program located in? Any help is greatly appreciated. Hoa

Re: Installing mysql on Linux

I am not really sure where it gets installed... nor that wether it is all installed on a single location. Try searching for it.. find / -name mysql Good Luck Ramon On Sat, 11 May 2002, Hoa Doan wrote: Hello, I'm trying to install mysql on RedHat Linux 7.0. I've downloaded the rpm.

Re: SQL Pattern Matching

At 13:43 -0700 5/11/02, impala wrote: Thanks for answering search character by character 11 May 2002 Making use of a HTML textfield which sends text to variable 'varLastName'. How do I concatenate the variable part('varLastName') with the % part is it something like: SELECT LASTNAME, FIRSTNAME,

Re: Best book on MySQL

At 13:40 -0700 5/11/02, Jeff Kilbride wrote: MySQL Paul DuBois New Riders Plus, he's here on the list answering questions... :) That's true. However, I should mention that the book doesn't say anything about InterBase. :-) --jeff - Original Message - From: Todd Cary [EMAIL

Re: [Newbie] Connecting for the first time

At 10:27 -0700 5/11/02, Todd Cary wrote: I have never opened or done anything with MySQL, so I am completely in the dark. All I know is that phpinfo() tells me that MySQL is implemented on my Linux/Apache server. All that it's really telling you is that MySQL *client* support is enabled in your

Re: Repair with key cache

At 15:44 -0400 5/11/02, [EMAIL PROTECTED] wrote: Benjamin... I get a feel for the amount of activity by looking at the processes running and the amount of cpu time they are using.. (on linux: ps xu) Correct me if I am wrong. I understand that the sort_buffer is the most important

Massive tables - 2 Queries better than join?

Hello, I am trying to understand a fundamental concept here. Lets say we have two tables: CREATE TABLE codewords (id INT UNSIGNED not null AUTO_INCREMENT, word VARCHAR (60) not null , fkey_humanword INT UNSIGNED not null , PRIMARY KEY (id), INDEX (id), UNIQUE (id)) CREATE TABLE humanword (id

Re: Repair with key cache

Paul I have 1536MB of RAM and have turned off disk swap. Ramon On Sat, 11 May 2002, Paul DuBois wrote: At 15:44 -0400 5/11/02, [EMAIL PROTECTED] wrote: Benjamin... I get a feel for the amount of activity by looking at the processes running and the amount of cpu time they are

AUTOCOMMIT and FLUSH?

Hello folks, Could somebody please tell me what the effectual difference is between AUTOCOMMIT and FLUSH? The manual says, By default, MySQL runs in autocommit mode. This means that as soon as you execute an update, MySQL will store the update on disk. Good. But what is left to flush then?

Re: Repair with key cache

Paul, I dont quite understand what you mean when you say I guess you want your machine to thrash, then. Ramon On Sat, 11 May 2002, Paul DuBois wrote: At 15:44 -0400 5/11/02, [EMAIL PROTECTED] wrote: Benjamin... I get a feel for the amount of activity by looking at the

Re: AUTOCOMMIT and FLUSH?

At 2:16 +0200 5/12/02, Mark wrote: Hello folks, Could somebody please tell me what the effectual difference is between AUTOCOMMIT and FLUSH? The manual says, By default, MySQL runs in autocommit mode. This means that as soon as you execute an update, MySQL will store the update on disk. Good.

Re: Repair with key cache

At 20:20 -0400 5/11/02, [EMAIL PROTECTED] wrote: Paul, I dont quite understand what you mean when you say I guess you want your machine to thrash, then. Most people don't have over a gig of physical memory. Setting the buffer sizes to such huge amounts in such cases will cause a lot of

Re: Repair with key cache

Ah! ok, I get your point. I am working with a pretty big database so I had to add a lot of horse power to that machine. Paul, do you have any idea what this Repair with keycache state, is all about. I am looking at the processes and basically mysql is doing nothing while on this stage, however

nested join syntax error

Hello All, I have a LEFT JOIN nested inside an INNER JOIN that generates a mySQL syntax error. I'm new to mySQL so I wonder if anyone could help me understand the problem. The query runs fine under PostgreSQL, MS SQL, and MS Access. SELECT Recording.Entry, InstCode.InstType,

Nested query

I need to run a query that selects the usernames of all the members a particular member has referred on the second level. So member 5 refers 10, 11, and 12, I need the usernames of everyone referred by 10, 11, or 12. Currently I run one query to get 10, 11, 12, make that a string, then do another

Re: Best book on MySQL

I ported several applications from Firebird 1.0 to MySQL 4. The main things I ran into was little SQL Syntax differences, Stored procedures, and Triggers... mike Paul DuBois wrote: At 13:40 -0700 5/11/02, Jeff Kilbride wrote: MySQL Paul DuBois New Riders Plus, he's here on

Multiple indexes

Hi, A field can belongs to 2 or more indexes? Edilson Vasconcelos de Melo Junior www.jrsoftwares.com.br [EMAIL PROTECTED] Fone: (19) 3256-3577 sql, query --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.361 / Virus

Nested query

I need to run a query that selects the usernames of all the members a particular member has referred on the second level. So member 5 refers 10, 11, and 12, I need the usernames of everyone referred by 10, 11, or 12. Currently I run one query to get 10, 11, 12, make that a string, then do another

Error with libmysqlclient.a when compiling

Hello, I am experiencing a problem when compiling QT 3.0 (trolltech.com) (OS: OS X 10.1.2) with their mysql/libmysqlclient.a (ver: 3.23.49) SQL driver support module, and based on trolltech's responses and other people experiencing this same problem with other development environments (cocoa,

RE: Nested query

* Daren Cotter I need to run a query that selects the usernames of all the members a particular member has referred on the second level. So member 5 refers 10, 11, and 12, I need the usernames of everyone referred by 10, 11, or 12. Currently I run one query to get 10, 11, 12, make that a

delay_key_write

Hello there, Does anyone know what the MySQL delay_key_write variable do? Ramon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Re: delay_key_write

On Sat, May 11, 2002 at 11:30:07PM -0400, [EMAIL PROTECTED] wrote: Hello there, Does anyone know what the MySQL delay_key_write variable do? Ramon http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html And I simply found that as second hit by typing delay_key_write it in the search field...