Hello list, I am about to embark on a little repliction mission;) I was thinking about
setting up a MySQL slave on my Windows box and replicate my MySQL 5.0 Master which
runs on my Linux box. Could the mix of architectures become a problem? I also use
innodb tables alot, are they replicateble?
Hello, I have created a table containing the following fields:
CREATE TABLE msgs (
rec_id int(11) NOT NULL AUTO_INCREMENT,
message_id varchar(80) NOT NULL DEFAULT '',
);
The items (millions) are like the following:
'1', '[EMAIL PROTECTED]'
'2', '[EMAIL PROTECTED]'
'3', [EMAIL
Jonas,
It's recommended in the docs that you upgrade your slaves to 5.0.0 before your Master
(http://www.mysql.com/doc/en/Replication_upgrade_5.0.html)
You shouldn't run into any problems with replicating InnoDB
tables.(http://www.mysql.com/doc/en/InnoDB_and_MySQL_Replication.html)
good
Jonas Lindén [EMAIL PROTECTED] wrote on 26/03/2004 07:56:18:
Hello list, I am about to embark on a little repliction mission;) I
was thinking about setting up a MySQL slave on my Windows box and
replicate my MySQL 5.0 Master which runs on my Linux box. Could the
mix of architectures
Hi.
I need some recommadations.
What is the optimal InnoDB datafile size? Is 75 * 2GB prefered over 1 *
1G:autoextend? The filesystem (ext3) has no problems handling the
filesizes, so that should not be an issue.
Of the 150GB is about 100GB BlOB's, would it have any impact on the
overall speed
Jesper Krogh wrote:
Hi.
I need some recommadations.
What is the optimal InnoDB datafile size? Is 75 * 2GB prefered over 1 *
1G:autoextend? The filesystem (ext3) has no problems handling the
filesizes, so that should not be an issue.
Of the 150GB is about 100GB BlOB's, would it have any impact
Ed Reed wrote:
Thanks Jeff,
After a little more investigation it turns out that the problem only
exists when I run the query through a MS Access database attached to
MySQL via ODBC. If I run the query in MySQLCC or MySQL-Front it runs
just fine.
Any ideas for a work around?
- Ed
Use an
I have read the documentation on the MySQLDump, but have been unable to
launch a mysql dump.
Is the dump performed while logged on to the database that you want to dump,
or do you log onto the machine where the database is and specify which
database you want to dump?. I have looked at and applied
Hello Joe,
mysqldump is a seperate programto be execute at the system prompt.
Therefore it is not to be run under the mysql prompt.
Bernard
On Friday 26 March 2004 06:09, joe collins wrote:
I have read the documentation on the MySQLDump, but have been unable to
launch a mysql dump.
Is the
joe collins [EMAIL PROTECTED] wrote:
I have read the documentation on the MySQLDump, but have been unable to
launch a mysql dump.
Is the dump performed while logged on to the database that you want to
dump, or do you log onto the machine where the database is and specify
which database you
Hi!
It was compiled using additional charecter encoding support, like
chinese, utf, arabian, and others
Best Regards
On Thu, 2004-03-25 at 23:34, Karam Chand wrote:
Hello,
The size of libmysql.dll binary has increased from
188KB to 916KB from MySQL 4.0 to MySQL 4.1.1.
Researching around
Hi!
I have just downlaoded the icc, it took about a day and a half to
recieve a confirmation mail with instructions on how downloading it. I
will give a try tomorrow! =)
Best Regards!
PS: Maybe somenody from mysql could give us some advice on how to
compile mysql server witth icc?(on linux, of
Tim:
Can you bring your libc to the latest patch level?
Not necessary. I resolved the problem:
binlog_cache_size was set to 32MB
I didn't realise that this would automatically be allocated to every
thread, even if there are no InnoDB or BDB tables in the entire
instance. This explains why
Hello,
I created inodb database with around 150 tables with relation to each
table (like Parent -Child Relation ship).
My problem is ,
I take backup using MYSQLDUMP Utility and entre database get backed
up. But all the tables in squenitial order. When I restore backup, It
does not get
SELECT DISTINCTT * FROM a;
-Original Message-
From: nullevent [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 25, 2004 18:43
To: [EMAIL PROTECTED]
Subject: select unique records
Hi mysql,
i have table 'a' with one field 'name',
which contains many dublicated records, like
SELECT *
Sorry...typo...
SELECT DISTINCT * FROM a;
-Original Message-
From: Angelo Sulbaran [mailto:[EMAIL PROTECTED]
Sent: Friday, March 26, 2004 08:34
To: [EMAIL PROTECTED]
Subject: RE: select unique records
SELECT DISTINCTT * FROM a;
-Original Message-
From: nullevent
My problem is ,
I take backup using MYSQLDUMP Utility and entre database get backed
up. But all the tables in squenitial order. When I restore backup, It
does not get restored because first it should create parent table
then child like in hirarchial order of relationship.
Here is an
Hi
I have recently upgraded from mysql vs 4 to 4.1 and have noticed that the
output format in mysqldump has changed a lot, using a single insert statement
to populate a table.
Is there anyway I can use mysqldump to produce a single insert statement for
each row?
Many thanx
Simon
--
Simon
I gmane.comp.db.mysql.general, skrev Kurt Haegeman:
What is the optimal InnoDB datafile size? Is 75 * 2GB prefered over 1 *
1G:autoextend? The filesystem (ext3) has no problems handling the
filesizes, so that should not be an issue.
If your one large datafile suffers irrepairable block
Somebody can help me ? If you run the above code in a new db named prova,
the last line create then error
Can't create table '.\prova\#sql-654_2e.frm' (errno: 121)
If you run the code on 4.0.17 all it is ok.
Tks in advance
Massimo
I did a back up of a database (datbase_1),generated the dump file from
database_1
I then created a new database database_2 and imported the dump file from
database_1 into database_2
I then copied all the data files (located at mysql\data\database_2) from
database_2 to database_1
Restarted
Hello all,
I am playing with a weblog and I created a database in mysql for this
weblog. The tables were in essence created and the installation did not
go well. so I am trying to delete the database and start afresh. The
database contains 40 tables and the names of the tables are gl_*
*
Jesper Krogh wrote:
I gmane.comp.db.mysql.general, skrev Kurt Haegeman:
What is the optimal InnoDB datafile size? Is 75 * 2GB prefered over 1 *
1G:autoextend? The filesystem (ext3) has no problems handling the
filesizes, so that should not be an issue.
If your one large datafile suffers
Simon Windsor [EMAIL PROTECTED] wrote:
I have recently upgraded from mysql vs 4 to 4.1 and have noticed that the
output format in mysqldump has changed a lot, using a single insert statement
to populate a table.
Is there anyway I can use mysqldump to produce a single insert statement for
Try Drop Database, section 13.2.6 in the manual.
For example:
drop database Foo;
Rhino
- Original Message -
From: Ola Ogunneye [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 26, 2004 9:12 AM
Subject: Deleting a database
Hello all,
I am playing with a weblog and I
I tried to download mysqlgui-win32-static-1.7.5-2.zip, but it doesn't appear to be a
valid archive...
What should I do??
Thanks,
Bruno
At 12:23 + 3/26/04, Tim Cutts wrote:
Tim:
Can you bring your libc to the latest patch level?
Not necessary. I resolved the problem:
binlog_cache_size was set to 32MB
I didn't realise that this would automatically be allocated to every
thread, even if there are no InnoDB or BDB tables in
My two cents: Just upgrade. We hammer on it pretty hard and the
transition has not only been smooth, it's been a delight. The query
cache, on our load, handles 60% of the queries, which I never imagined
would happen.
4.0.18 feels as boringly stable as most released MySQLs :)
--Pete
On Thu,
Bonjour Samana,
I will write in english for the list and then french for Samana.
His problem is that he is not supplying a valid user and password.
Je vais écrire en anglais donc français.
You need to create a new user with permissions to access the database.
I don't recommend that you use
My name is Matthew Thomas I am currently a student at Syracuse University
working on a senior design project that utilizes your database at the back
end. I have data streaming from an RS232 port(COM port on a computer) and I
want that information to be able to directly written onto the
I compiled 4.0.18 on FreeBSD 4.9 with linuxthreads support and all of
jeremy's suggestions. My database needs to handle a ton of connections
that are very quick (one INSERT DELAYED each). Using super-smack to do
some benchmarking, I've found that anyting over 80 connections and I begin
to see the
I compiled 4.0.18 on FreeBSD 4.9 with linuxthreads support and all of
jeremy's suggestions. My database needs to handle a ton of connections
that are very quick (one INSERT DELAYED each). Using super-smack to do
some benchmarking, I've found that anyting over 80 connections and I begin
to see the
Hi,
I am trying to store Thai characters into mysql.
But after i pass an INSERT statement from my PHP script, the corresponding field in
the mysql table shows some unintelligible text not readable... looks like some
computer text (checked using PHPMyAdmin). I also checked the same
'm using Multiple-table Update with the above sintax:
mysql desc italica;
++---+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
++---+--+-+-+---+
| ita_empresa | decimal(10,0) | | | 0 | |
|
on a related note to my previous question:
how can i switch on the creation of a (binary) update log, but only
for ONE database of several being on my server?
You probably want to enable the binary log with --log-bin, and use
the --binlog-do-db option along with it. Databases not named with
This is an automatic reply to an email you sent to a MySQL mailing address
protected by our 'self-moderation' system. To reduce the amount of spam
received at these addresses, we require you to confirm that you're a real
person before your email will be allowed through.
Just an FYI, I got -5-
Hi!
On Thu, 2004-03-25 at 19:15, msthom01 wrote:
My name is Matthew Thomas I am currently a student at Syracuse University
working on a senior design project that utilizes your database at the back
end. I have data streaming from an RS232 port(COM port on a computer) and I
want that
We are using mysql-4.0.18, compiled from source with:
./configure --prefix=/usr/local/mysql --enable-thread-safe-client --enable-assembler
--enable-local-infile --enable-largefile --with-mysqld-user=mysql --without-debug
--with-innodb
A two-pronged question:
First, in our experience, we don't
Perl's Win32::SerialPort (or Device::SerialPort) coupled
with DBI would do it in a dozen lines or so. Docs for both
are at http://search.cpan.org/.
Eamon Daly
NextWave Media Group LLC
Tel: 1 773 975-1115
Fax: 1 773 913-0970
-
I'm coverting an Access database to MySQL 4.1.1 and I need help with a
near impossible query. In the Access DB I used a stored procedure; I
think I should be able to solve this problem with a subselect in MySQL
but so far I'm not having any luck.
Here's the problem; In my stored precedure query
Perl's Win32::SerialPort (or Device::SerialPort) coupled
with DBI and DBD::mysql would do it in a dozen lines or so.
Docs for both are at http://search.cpan.org/.
Eamon Daly
NextWave Media Group LLC
Tel: 1 773 975-1115
Fax: 1 773
I have a myisam database on a little Redhat 8 Celeron P3-866 with less than 256MB of
ram. (Schema attached). While response for single table queries is excellent.
(Double table queries are also mostly good.) More real world (ie complex) queries are
glacial in their execution.
My
I send this last week and no one commented.
Has anyone run into this simmilar problem?
-Original Message-
From: Nestor Florez [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 18, 2004 10:28 AM
I have a php web application that has an admin page for inserting course
records and one for
I am testing MySQL as a possible replacement for our proprietary db
server for several large databases. I really want MySQL but I am
getting what seems like slow search times.
Does 6.5 seconds seem slow/typical/fast for the following search?
SELECT main.ownername FROM main, rolledplate WHERE
It's been my experience that table names are case-sensitive in MySQL; you
must get the case exactly right to get data from the desired table. Mind
you, that is based on SQL issued at the command line. Your driver may make
case irrelevant for access from clients.
If your table name is
Everyone,
We're looking to get an HDS SAN solution (95xx series I believe) at my
present employer, and our only remaining concern is the reliability of MySQL
when used in conjunction with dynamic multipathing software (under Linux).
We use 3.23.x mostly, some 4.0.x -- almost all our data is in
Hello,
I want to show outpur like this?
Group hostname details
aa abababa
aa abababababab
aa anannanananna
bbllololololool
bb
On Wed, Mar 24, 2004 at 06:29:40PM -0700, Sasha Pachev wrote:
[EMAIL PROTECTED] wrote:
Hmm.. Looks like Jeremy did not quite fix everything on FreeBSD in version 1.2.
For a hack, change ERESTART to EINTR in client.cc for now until we've figured it
out.
1.3 builds cleanly on FreeBSD. I
48 matches
Mail list logo