> You can set the default storage engine on each of the servers and then
> don't declare it explicitly in any CREATE TABLE statements.
This seems like the most viable option. Since almost all of the remote
tables are created with INNODB it should work fine. I do have one table
that isn't but we
Hi all,
I have a advanced servers 4 with 30 gb of ram please let me know the exact
details how much i have to configure and use the exact variables in the cnf
file and which one to be used.(innodb engine)
any my database size is upto 600gb how to take up the backup, using ibbackup my
system get
yes. just found it.
it's funny, I was looking for it last half hour and the second after I
sent the email - I found it.
:)
yes, yes... I know. RTFM
:D
thanks.
-afan
sol beach wrote:
SET Column type?
On Dec 6, 2007 2:01 PM, Afan Pasalic <[EMAIL PROTECTED]> wrote:
hi,
I wonder if mysql h
hi,
I wonder if mysql has something like ENUM() but instead ONLY ONE it
could be selected ANY COMBINATION of these offered solutioins?
If column is ENUM('a','b','c','d') I can select 'a' or 'b' or 'c' or
'd'. Clear.
Tough, I need SOMETHING('a','b','c','d') that I can select 'a' and 'b',
or 'b',
Ok, I ran xfs_check and the filesystem is all well. Does anybody else
have an idea?
Regards,
Samy
Samuel Vogel schrieb:
Hey,
Thanks for the very fast reply.
Of course I forgot that I'm running Linux Debian Etch with mysql
5.0.45 from backports.
We have a 20GB quota set for MySQL. Before th
Typo3 is a cms used to build web page and store its data into mysql. Never
used it myself but our clients do. It must be somewhat close to
dreamweaver and such. By kicked out i mean he get disconnected from typo3
and when he go back in the data is not inserted.
Éric Fournier
Technicien en in
Have anyone out there any experience building, installing, and using
MySql on Leopard (PowerPC G4)
(MySql Community server 5.0.51) If so, I would be thankful for info on
possible problems.
--
Skinheads are so tired of immigration, that they are going to move to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I've been experimenting with mysql replication, specifically error
handling under varying error conditions. My tests are with 5.0.22 that
comes with CentOS 5.0.
My main concern is that I would like to lower the slave_net_timeout
setting, but don't wa
> Hi ,
> Someone using typo3 try to update a field "tx_templavoila.flex" into a
table tt_content but get kicked out of typo3 without error message. The
user tried with PHPmyadmin but got the same result. First thought coming
to mind is the field is too small for the data being inserted but
Does anyone know of a programming library/module (C or PERL or ?) to interface
with the MySQL binary logs?
Preferably a PERL module which wraps some C library to gain a PERL OO api
interface to manipulating MySQL Binary Logs.
If this does not exist, can someone point me at the API documentation
Hi ,
Someone using typo3 try to update a field "tx_templavoila.flex" into a
table tt_content but get kicked out of typo3 without error message. The
user tried with PHPmyadmin but got the same result. First thought coming
to mind is the field is too small for the data being inserted but the
f
Hmm... mysqlsla is not bad
However, I was hoping for something to help dive into the SQL queries and
present their relation together in a single view of how the database and tables
are being used.
mysqlsla shows the unique queries being used. And I'd like to see from the other
end how the databas
Hey,
Thanks for the very fast reply.
Of course I forgot that I'm running Linux Debian Etch with mysql 5.0.45
from backports.
We have a 20GB quota set for MySQL. Before the crash about 9GB where
used, now it's down to 5GB. I will unmount the disk and check the XFS
filesystem and report back h
Hey guys,
I have a big Problem. About 30 % of my databases just disappeared around
6pm today. I do not have any clue how this happened. Is can just guess
the time it happened from my munin graphs.
The only thing that might be a clue are the following files in my data
directory:
h1314631:~#
Dear MySQL users,
MySQL Community Server 5.0.51, a new version of the popular Open Source
Database Management System, has been released. The release is now
available in source form (only) from our download pages at
http://dev.mysql.com/downloads/
and mirror sites.
Note that not all mi
DUH!!!
LOL, I'm an idiot..
Gonna go flush my head down the toilet now.
Thanks guys.
From: William Newton [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 06, 2007 1:29 PM
To: Jeff Mckeon; MySql
Subject: Re: Error: No query specified
I'm guessing you are adding a semi-colo
No, I do not think this is possible.
> -Original Message-
> From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 06, 2007 8:38 AM
> To: ars k; MySql
> Subject: Re: REPLICATION
>
> A, B, C, D are mysql Servers
>
>
> On Dec 6, 2007 12:18 PM, ars k <[EMAIL
I'm guessing you are adding a semi-colon (;) to the end of the statement. Its
unnecessary with the \G
- Original Message
From: Jeff Mckeon <[EMAIL PROTECTED]>
To: MySql
Sent: Thursday, December 6, 2007 12:19:22 PM
Subject: Error: No query specified
When I run a "Show slave status \
Are you sure you don't have a semicolon after the \G? That would do it.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
> -Original
When I run a "Show slave status \G" I get a message at the bottom that says
"Error: No query specified"
I don't recall ever seeing this before and can't find anything online about
it. Anyone know what it means?
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Repli
You could convert all the tables on the slave to MyISAM after all the table
creates are done on the slave. Here are the six(6) steps to do this:
Step 1 : Make sure binary logging is turned off on the slave
Step 2: Copy the data over to the slave
mysqldump -h -u... -p... --routines --triggers |
Hi Gary,
On Dec 6, 2007 10:56 AM, Gary W. Smith <[EMAIL PROTECTED]> wrote:
> We have a master/master environment that has tables in innodb. We want to
> setup a slave that will be used for reporting and some other stuff as well.
> We want to use MyISAM as the engine on the slave'd server.
>
>
We have a master/master environment that has tables in innodb. We want to
setup a slave that will be used for reporting and some other stuff as well. We
want to use MyISAM as the engine on the slave'd server.
Since all of the table creations are also part of the replication, is it
possible t
You could also try http://hackmysql.com/mysqlsla
On Dec 6, 2007 9:23 AM, B. Keith Murphy <[EMAIL PROTECTED]> wrote:
> MySQL Proxy is good. It doesn't fit in some environments however.
> Another option would be the QPP (Query Processing Programs) that I and a
> co-worker have developed. They can
MySQL Proxy is good. It doesn't fit in some environments however.
Another option would be the QPP (Query Processing Programs) that I and a
co-worker have developed. They can be downloaded at
http://www.paragon-cs.com/queryprogs.
thanks
Keith
Michael Dykman wrote:
Have you considered:
A, B, C, D are mysql Servers
On Dec 6, 2007 12:18 PM, ars k <[EMAIL PROTECTED]> wrote:
> are A,B,C,D servers or separate mysql instances?
>
>
>
> On Dec 6, 2007 10:18 AM, Krishna Chandra Prajapati <[EMAIL PROTECTED]>
> wrote:
>
> > Does any body has tried this
> >
> > On Dec 6, 2007 10:08 AM, K
26 matches
Mail list logo