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 anyon

Installing

I'm attempting to install using INSTALL-BINARIES and get this message while executing mysql_install_db: [cuppjr mysql]$ scripts/mysql_install_db scripts/mysql_install_db: ./bin/my_print_defaults: cannot execute binary file WARNING: The host 'raq2.homeunix.org' could not be looked up with resolveip.

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

Jeremy Zawodny wrote: >On Fri, Oct 03, 2003 at 06:23:24PM -0400, Ware Adams wrote: >>Peer Reiser wrote: >> >>>Next week I will have access to a new PomerMac G5 with Dual 2GHZ >>>processors, and i want to do some indexing. Does anyone know if >>>MySQL will take advantage of dual processors if the o

Re: just messed up my index on my table....ugh

Its weird, I dropped the indexes off that table, and re-added them but the queries used to take 5 sections but now take much much longer. I did a little reading on the EXPLAIN command and it looks like my query without an index has 9427^15 rows to query. So thats where I am seeing the huge timeout

(USING PASSWORD: NO) UGH 2nd try

I just reinstalled because of this same issue. Now root has no priviledges or functions within MySQL. Does anyone know how to fix this? My data isn't important -- i just started (and I am a hopeless newbie!) It doesn't let root do squat. I was trying to give 'root' a password. Entered the fo

Re: just messed up my index on my table....ugh

On Fri, Oct 03, 2003 at 04:23:56PM -0400, Matt Babineau wrote: > now the query isn't finishing executing and its killing my cpu... > > any idea how to rebuild the index on a table? > > or how to get out of this mess? Drop and re-add the index? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQ

(USING PASSWORD: NO) UGH!

I just reinstalled because of this same issue. Now root has no priviledges or functions within MySQL. Does anyone know how to fix this? My data isn't important -- i just started (and I am a hopeless newbie!) It doesn't let root do squat. I was trying to give 'root' a password. Entered the fo

just messed up my index on my table....ugh

now the query isn't finishing executing and its killing my cpu... any idea how to rebuild the index on a table? or how to get out of this mess? :-) Thanks, Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PRO

just messed up my index on my table....ugh

now the query isn't finishing executing and its killing my cpu... any idea how to rebuild the index on a table? or how to get out of this mess? :-) Thanks, Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PRO

Re: thread problem

I'm using linux, Red Hat 7.3 Linux version 2.4.22, and 3.23.55-Max-log. does This information is ok?, or I'm missing something. Greetings From: Jeremy Zawodny <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Mikel - <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: thread problem Date:

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

On Fri, Oct 03, 2003 at 06:23:24PM -0400, Ware Adams wrote: > Peer Reiser wrote: > > >Next week I will have access to a new PomerMac G5 with Dual 2GHZ > >processors, and i want to do some indexing. Does anyone know if MySQL > >will take advantage of dual processors if the only process running is >

RE: Multiple-Column Unique Index Redundancy

- Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 -->-Original Message- -->From: John Kornet [mailto:[EMAIL PROTECTED] -->Sent: Friday, October 03, 2003 3:06 PM -->To: [EMAIL PROTECTED] -->Subject: Multiple-Column Uniq

Re: Newbye speed question

I wonder why you have 19 fields in a single table. I don't think there is really any way to predict it, since it depends on so many different factors. On Fri, 3 Oct 2003 11:19:56 +0200, Peer Reiser <[EMAIL PROTECTED]> wrote: | Fortunately the database is not in production :-) but it should go

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

Andy Eastham wrote: >How big are the table and index files? Can your OS handle files >bigger than 2/4Gb? Yes, OS X can deal with files larger than 4 GB. --Ware -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTEC

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

Peer Reiser wrote: >Next week I will have access to a new PomerMac G5 with Dual 2GHZ >processors, and i want to do some indexing. Does anyone know if MySQL >will take advantage of dual processors if the only process running is >the indexing process?? No, it won't directly. However, other process

Re: Multiple-Column Unique Index Redundancy

On Fri, Oct 03, 2003 at 06:06:10PM -0400, 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? It is redudndant, yes. > In other

Multiple-Column Unique Index Redundancy

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 unique indexes that specify uniqueness over multi

Re: thread problem

On Fri, Oct 03, 2003 at 02:37:27PM -0500, Mikel - wrote: > > Hi list, > > I have the following problem and here is the message that displays the > console when I try to connect > > "Warning: Can't create a new thread (errno 11). If you are not out of > available memory, you can consult the man

RE: changing TMPDIR for tempory file location

In my.cnf its called tmpdir change that location tmpdir= - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 -->-Original Message- -->From: dan orlic [mailto:[EMAIL PROTECTED] -->Sent: Friday, October 03, 2003 11:20 AM --

FW: changing TMPDIR for tempory file location

-Original Message- From: dan orlic [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 1:20 PM To: '[EMAIL PROTECTED]' Subject: changing TMPDIR for tempory file location Hello all, My query is about changing the tmpdir on mysql. As stated in on the mysql.com site it states

thread problem

Hi list, I have the following problem and here is the message that displays the console when I try to connect "Warning: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent" Greetings Mikel __

Re: Getting MySQL activity as a per database value

On Fri, Oct 03, 2003 at 08:29:17AM -0400, John Murtari wrote: > Folks, > > I've done a lot of searches, tried out the tools I could > find (like phpMyAdmin/mtop). We have a server with about 30 DB's > and we would LOVE to get a report that gives us queries/hour, cpu, > etc.. against each

configure string for solaris?

Where can I find the configure string MySQL AB uses to compile their solaris binaries? -James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

changing TMPDIR for tempory file location

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 startup file. It makes no mention of changin

RE: Replication

-->-Original Message- -->From: Luc Foisy [mailto:[EMAIL PROTECTED] -->Sent: Friday, October 03, 2003 8:45 AM -->To: MYSQL-List (E-mail) -->Subject: Replication --> --> -->If I have replication already active for a single database ( already -->active between master and slave ) and I want to

Re: How to show locks on a table?

On Fri, Oct 03, 2003 at 03:28:31PM +0400, [EMAIL PROTECTED] wrote: > Subject Body: There isn't a way. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 19 days, processed 714,889,039 queries (419/sec

Re: mysqld crash

Richard, looks like a clean case of memory corruption. Your log sequence number is only 29 MB. You got problems very quickly. I regularly run tests where gigabytes of log are generated, and no crash. Linux-2.4.20 has the reputation of being stable. This might even be a hardware problem. Best re

Replication MASTER-SLAVE

Hi everbody! I' m trying to do a replication, and this is the first time!! My MySQL is running in Windows XP (master and slave). Where are my errors? Can I configure a Master in Linux and a Slave in Windows? #Master Configuration ##

Getting MySQL activity as a per database value

Folks, I've done a lot of searches, tried out the tools I could find (like phpMyAdmin/mtop). We have a server with about 30 DB's and we would LOVE to get a report that gives us queries/hour, cpu, etc.. against each DB so that we can measure activity. We are running 4.0.13 on Red

RE: Why does mySQL violate NOT precedence?

I think the difference between mysql's precedence operation is significant to point out. Looking at the behavior of other databases, SQL Server and Oracle both respond to the query you gave with Recordss about users with names != 'Bob'. Jane returned. Significantly, this is inversion does not incl

Re: How to write this query

Sean, Slight rewriting of Kevin's query--I assume you want to do the joins on A_ID. SELECT A_data, B_data, C_data FROM A LEFT JOIN B ON A.A_ID = B.A_ID LEFT JOIN C ON A.A_ID = C.A_ID WHERE A.A_ID = 4; This should work. For your example, the first left join gives a table with A.* and nulls for B

Re: Relationships - Foreign Key

* Paulo > Hi, sorry for my english, but, how can I do relationships between > tables? Is possible? This is done using different types of JOIN: http://www.mysql.com/doc/en/JOIN.html > -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:ht

Replication

If I have replication already active for a single database ( already active between master and slave ) and I want to start replicating a new database on the master, what would the correct procedure be? I have a dump of the database I want to replicate. Below is the current setup for replication

Re: General error: Incorrect key file for table: 'RoleM'. Try to repair it

i googled your error and the first link looks like it may help google -> General error: Incorrect key file for table www.vbulletin.com/forum/ showthread.php?t=5387&goto=nextoldest hth Jeff

Off-line DB Re-synchronizing?

Greetings, We have 10 people that need to use MySQL on notebooks/tablets off-line, entering data, doing searches. When they reconnect to the Internet, the database needs to upload the new data to a server and retrieve a fresh copy of some common tables. I was thinking about the LOAD DATA feature

General error: Incorrect key file for table: 'RoleM'. Try to repair it

Hello, I am facing a very strange problem, my application says "General error: Incorrect key file for table: 'RoleM'. Try to repair it " but when i trying myisamchk then it doesn't give any corruption error. I have tried many things but nothing seems to be of any help, i would really appreciate anh

RE: Tomcat, Connection Pooling, and MySQL

I got it working... unfournately it's on my laptop at home, not here at work with me I think that the issues was that the class names given in the documentation for the jdbc driver for MySQL were wrong look at the listing of the contents of the jar file, and see if you can find the right

Re: Why does mySQL violate NOT precedence?

Your point does not seem relevant to my question on mySQL compliance with the specification. In fact, your response doesn't even mention the specification. Perhaps I'm misunderstanding your question. You are wondering why I would ask a query like SELECT * FROM Person WHERE NOT name = 'Bob'? Mi

Relationships - Foreign Key

Hi, sorry for my english, but, how can I do relationships between tables? Is possible? Thanks, Paulo Daniel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Locked connection doesn't disconnect

Hi. I've developed a program in Delphi 5 that uses ZeosLib components for connect to a MySQL database that uses MyISAM tables and inserts some records. If I finalize the program with Ctrl-Alt-Supr when it's inserting the records the programs disconnects from MySQL (a Disconnect method is called i

Tomcat, Connection Pooling, and MySQL

Has anyone managed to setup Tomcat to use MySQL for database connection pooling? I've found this document which gives information on it: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html However, when I try and run it I get messages about not being able to fi

Re: Why does mySQL violate NOT precedence?

I'm not sure why you would use the syntax you are trying to use. I think you are making a few assumptions that may be incorrect. If you do this query: SELECT not name='Bob' FROM person You'll see your result is set contains all 0's. Records where name='Bob' would return 1, but you are taking the

mysqld crash

>Description: Upon starting mysql client with the following command: mysql -ppassword radiant Immediately error message where displayed, one per table, saying that the table existed, however no columns/fields where found. Unfortunately I do not have the log

GROUP BY/ORDER BY Problem

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 but this does mysql> SELECT breed, MIN(age)

RE: grant by option on querys

Thank you very much Paul. The order by NULL clause sped the query up from 1.5 minutes to 10 seconds! This is what we were looking for. Thanks, Brad -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 9:59 PM To: Brad Teale; '[EMAIL PROTECTED]'

Install/compile problems

Hi, SYSTEM: Compaq Alpha, Tru64 5.1, mysql4.0.15a. I have having trouble compiling the source on the above system. I have tried a variety  of configure option, notable the ones offered in the install notes for Tru64 OSF but I  still seem to hit an error during the make. I also insta

Why does mySQL violate NOT precedence?

I am reposting this in hopes of convincing the mySQL implementors to change mySQL or to at least gain some understanding as to why they violated the specification. Apparently, in MySQL, NOT has higher precedence than the comparison operators, so WHERE NOT name = 'Bob' is equivalent to WHERE (

How to show locks on a table?

Subject -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How can i make mysql to print date and time automatically?

I am sorry, the instruction I sent doesn't work in MySQL: You should use: INSERT INTO your_table (field1, field2, field3) VALUES(CURDATE(), "value2", CURTIME()) Note the CUR (I think it stands for CURrent) Thanks Emery - Original Message - From: "Director General: NEFACOMP" <[EMAIL PROTE

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

Peer, How big are the table and index files? Can your OS handle files bigger than 2/4Gb? I've got a table with 55 million rows with just 3 columns all floats. I've got three indexes with all the fields in various orders. My data file is 700Mb but my index file is over 4Gb, so yours could easily

Re: ran out of space for bin logs

Hi, > 1. Can I safely delete the binlogs and clear the binlog index by hand? The binlog index maintains admistrative informations that the daemon use to manage the binlog files. If you delete it ( i don't recommended this) the daemon will recreate it . > 2. How can I regulate the size of t

unicode_support

Hi Everybody! I use MySQL with JavaNetBeans. Please tell me, if only the InnoDb support unicode, or MyISAM also supports, and how. best regards Laszlo Illyes Library-informatics Sapientia University (Csikszereda) Miercurea-Ciuc Tel:+40266317310 Fax:+40266317310/+40266371121 Mobil:+40740055706

mysql 4.0.15 and latest redhat enterprise AS Beta - segmention fault

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 /usr/bin/mysqld_safe: line 339: 14874 Speicherzugriffsfehler

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

Next week I will have access to a new PomerMac G5 with Dual 2GHZ processors, and i want to do some indexing. Does anyone know if MySQL will take advantage of dual processors if the only process running is the indexing process?? Is disk I/O more important ? The bad temper of my boss seems to inc

Re: Newbye speed question

Fortunately the database is not in production :-) but it should go as soon as possible :-( On viernes, octu 3, 2003, at 11:03 Europe/Madrid, Wang Feng wrote: 18hrs??? So, the database has been LOCKED for 18hrs - Original Message - From: "Peer Reiser" <[EMAIL PROTECTED]> To: <[EMAIL

unexpected index behaviour...

Hello all, I asked a similar question earlier. Then I went and did tons of tests... but I am back where I started. Basicly I am trying to store pretty high volume of data (ip traffic) in a mysql database. The only choidce for an engine is MyIsam because I need the advantage of compressed table

Re: How can i make mysql to print date and time automatically?

INSERT INTO your_table (field1, field2, field3) VALUES(DATE(), "value2", TIME()) But check the manual for very simple things. Thanks Emery - Original Message - From: "Emilio Ruben Estevez" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 01, 2003 17:09 Subject: How ca

Re: Newbye speed question

18hrs??? So, the database has been LOCKED for 18hrs - Original Message - From: "Peer Reiser" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 03, 2003 6:57 PM Subject: Newbye speed question > HI > > I am having a MYISAM database with 27 million rows and 19 fields

Newbye speed question

HI I am having a MYISAM database with 27 million rows and 19 fields all char between 15 and 1 characters long. yesterday i did a alter table mytablename add column (version char(2)); By now (18 hours later) it has not finished yet? Is there a way to somehow predict the time needed for this? Or t