Hi All,
Thanks a lot for you reply. Will do this setup.
regards
anandkl
On 4/2/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Hi,
> Enter in my.cnf file
> [mysqld]
> skip-bdb
> skip-innodb
>
> Regards
> Rakesh
>
> -Original Message-
> From: Ananda Kumar [mailto:[EMAIL PROTECTED]
>
Hi,
Enter in my.cnf file
[mysqld]
skip-bdb
skip-innodb
Regards
Rakesh
-Original Message-
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 02, 2008 9:59 AM
To: MySql
Subject: only myisam storage engine
Hi All,
We have a linux box running debain, with 8 cpu and 8 GB RAM,
You can set the skip-innodb option in my.cnf
-Eric
On Tue, Apr 1, 2008 at 9:28 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> Hi All,
> We have a linux box running debain, with 8 cpu and 8 GB RAM, we want only
> myisam engine to be running on this.
>
> So, should i not setup any innodb paramete
Hi All,
We have a linux box running debain, with 8 cpu and 8 GB RAM, we want only
myisam engine to be running on this.
So, should i not setup any innodb parameters or is there any other way to
have only myisam engine running on this machine, please let me know.
regards
anandkl
Hi Michael,
I do not understand, please explain.
The plan is to use "One file per table", move the database directory to
a separate disk and establish a link to the directory from the previous
location. What locking problem do you see in Unix or Windows?
Thanks, Reuven
Michael Dykman wrote:
I
YEs, both of MySQL are running on each system.
Show status display a big long list of items, any specific?
uptime is 3239 on 10.100.1.170
uptime is 3353 on 10.100.1.171
Thanks,
Néstor :-)
On Tue, Apr 1, 2008 at 3:46 PM, Srini <[EMAIL PROTECTED]> wrote:
> is your mysql running on the master ho
is your mysql running on the master host i,e 10.100.1.170
Also can you please execute "show status" on that host to see how long
the server is up,
may be the server is restarted and your slave is retrying on the same
old connection
HTH,
-srini
Néstor wrote:
In my RHEL5, I am using this lin
In my RHEL5, I am using this link to create MySQL replication an did work
the first time I did it:
http://crazytoon.com/2008/02/29/mysql-how-do-you-set-up-mastermaster-replication-in-mysql-centos-rhel-fedora/
I change the ip address and the hostname and it is not working now.
My new ip is 10.100.1
In a replication environment with 1 master and a 2 slaves, does the
entire database always have to be stored on the master? I understand
that slaves can come on and off line but I am not sure if the master
must always store a complete copy of DB.
Thanks,
MK
--
MySQL General Mailing List
For li
Right, the proof is that if I have an PKEY on ID and an index just on
VALUE in MySQL then a query that would use both ID and VALUE works fine
with just the index on VALUE.
For Oracle, I need an explicit compound index (in addition to the PKEY)
on (ID,VALUE).
The results on MySQL get a little blur
On Tue, Apr 1, 2008 at 11:54 AM, Tim McDaniel <[EMAIL PROTECTED]> wrote:
> > Please also consider using explicit JOINs.
> Another way to do the same thing with different syntax, right?
>
Generally speaking it is another way to do the same thing, however it is
much easer to read complicated querie
On Tue, 1 Apr 2008, Tim McDaniel wrote:
On Tue, 1 Apr 2008, Rob Wultsch <[EMAIL PROTECTED]> wrote:
On Tue, Apr 1, 2008 at 11:15 AM, Hiep Nguyen <[EMAIL PROTECTED]> wrote:
how do i select all fields in tbl1,tbl2, and only fld1,fld2 in tbl3?
select tbl2.*,
tbl1.*,
tbl3.fld1,
tbl3.fld2
from tb
On Tue, 1 Apr 2008, Rob Wultsch <[EMAIL PROTECTED]> wrote:
On Tue, Apr 1, 2008 at 11:15 AM, Hiep Nguyen <[EMAIL PROTECTED]> wrote:
how do i select all fields in tbl1,tbl2, and only fld1,fld2 in tbl3?
select tbl2.*,
tbl1.*,
tbl3.fld1,
tbl3.fld2
from tbl1,tbl2,tbl3;
Hiep, will you be supplyin
On Tue, Apr 1, 2008 at 11:15 AM, Hiep Nguyen <[EMAIL PROTECTED]> wrote:
> how do i select all fields in tbl1,tbl2, and only fld1,fld2 in tbl3?
>
select tbl2.*,
tbl1.*,
tbl3.fld1,
tbl3.fld2
from tbl1,tbl2,tbl3;
Please also consider using explicit JOINs.
--
Rob Wultsch
[EMAIL PROTECTED]
wultsch
There is already a primary key index on ID.
-Original Message-
From: Wm Mussatto [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2008 10:50 AM
To: mysql@lists.mysql.com
Subject: Re: Indices in InnoDB/MySQL
On Tue, April 1, 2008 10:01, Robert DiFalco wrote:
> I've been told that an in
hi all,
how do i select all fields in tbl1,tbl2, and only fld1,fld2 in tbl3?
is this possible???
select *,*,tbl3.fld1,tbl3.fld2 from tbl1,tbl2,tbl3;
the reason for this is b/c there are hundred of fields in tbl1 & tbl2 that
i don't want to type them all.
thanks,
t. hiep
--
MySQL General
On 4/1/08, Paul DuBois <[EMAIL PROTECTED]> wrote:
>
> At 10:01 AM -0700 4/1/08, Robert DiFalco wrote:
> >I've been told that an index always contains the primary key.
>
>
> By who?
>
> Ask for proof.
I guess he was referring to the fact that InnoDB stores the primary key
values alongside the ind
At 10:01 AM -0700 4/1/08, Robert DiFalco wrote:
I've been told that an index always contains the primary key.
By who?
Ask for proof.
So if I
have a LONG ID that is the primary key of table and create on index on
LONG VALUE, the index on LONG VALUE will actually work as a typical
compound i
On Tue, April 1, 2008 10:01, Robert DiFalco wrote:
> I've been told that an index always contains the primary key. So if I
> have a LONG ID that is the primary key of table and create on index on
> LONG VALUE, the index on LONG VALUE will actually work as a typical
> compound index on ID,VALUE. My
2008/4/1 Reuven Nisser <[EMAIL PROTECTED]>:
> Hi Rob,
>
> Thank you for the answer.
>
> Yes, the two databases do not interact but I access them using ODBC
> connection and if I use two instances, I will need two ODBC connections
> setup on each production PC. If I use one instance I could use fo
Hi Rob,
Thank you for the answer.
Yes, the two databases do not interact but I access them using ODBC
connection and if I use two instances, I will need two ODBC connections
setup on each production PC. If I use one instance I could use for the
second connection:
;ODBC=XXX;Database=yyy
So,
I've been told that an index always contains the primary key. So if I
have a LONG ID that is the primary key of table and create on index on
LONG VALUE, the index on LONG VALUE will actually work as a typical
compound index on ID,VALUE. My question is this, if I don't know that
about MySQL and crea
I would not recommend using either SMB or NFS to access data
directories , especially if you expectingany kind of load. File locks
simply do do work effectively (or at all) across such mounts.
- michael dykman
On Tue, Apr 1, 2008 at 12:05 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
> Option 1:
>
Option 1:
Assuming you do not need the databases to interact with each other I
would setup two instances of mysql with separate datadirectories. This
should make your back process easier. Read:
http://dev.mysql.com/doc/refman/5.0/en/option-files.html
http://dev.mysql.com/doc/refman/5.0/en/windows-c
Hello everyone.
I'm getting a strange error when calling a SELECT query with JOIN:
Mysql::Error: Table '' is marked as crashed and should be repaired
Note that there is no name for the table that is marked as crashed.
An example of a query that causes this is:
select feed_items.* from feed_ite
Hi Thufir,
I know I am late! And you'll have already resolved.
But I haven't been receiving mysql mailing list posts since november
for our company server misteries!
Every date can be converted to an absolute number-of-seconds number
(for instance with time_to_sec() function),
so you can subtract
Hi
I am referring to
http://dev.mysql.com/doc/refman/5.0/en/multiple-unix-servers.html to
create multiple instances of MySQL Database Server. I wanted it for
Gentoo Linux
is there a HowTo for configuring multiple instance of MySQL Database
Server on Gentoo Linux
Thanks and Regards
Kaushal
--
Weird things happen!
Which MySQL server version are you using?
It looks like you managed to start two instances,
and from a unix point of view it is no strange.
But the problem is that two MySQL instances not only
differ for the TCP/IP port number and the Unix Socket file,
but there is the data
28 matches
Mail list logo
