I use Debian Sarge as my Linux distribution on two servers who replicate MySQL.
Every time I upgrade the MySQL package my replication dies.
Any ideas why?
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
You could use the CSV table type:
http://dev.mysql.com/doc/mysql/en/csv-storage-engine.html
Interesting. I just downloaded 4.1.11 - how does one enable
this engine?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL
Server
Upscene
From the documentation referred to in the link
14.8. The CSV Storage Engine
The CSV storage engine was added in MySQL 4.1.4. This engine stores data
in text files using comma-separated-values format.
To enable this storage engine, use the --with-csv-storage-engine option
to configure when you
Ah David,
From the documentation referred to in the link
14.8. The CSV Storage Engine
The CSV storage engine was added in MySQL 4.1.4. This engine stores data
in text files using comma-separated-values format.
To enable this storage engine, use the --with-csv-storage-engine option
to
Sorry, I don't use windows 8-) except when I have to. All my servers are
unix/linux and I can build them at will. I think there are instructions
in the manual for building it but I think you would probably have to
purchase a C++ compiler or similar.
Regards
David Logan
Database Administrator
Sorry, I don't use windows 8-) except when I have to. All my servers are
unix/linux and I can build them at will. I think there are instructions
in the manual for building it but I think you would probably have to
purchase a C++ compiler or similar.
Exactly the reason why I do NOT want to
Gleb Paharenko wrote:
Hello.
Among other things check that you correctly process lock timeouts.
I've check this, but it seems fine.
I'm testing it this way with 3 applications on the same computer (2
processors) :
- 2 clients applications with an open connection to the DB (which is
remote with
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] writes:
I have loaded a large *.csv spreadsheet into mysql and one number, the
grand total, changes from 16996941 on the Excel spreadsheet to 8388607
in the mysql database. The numbers surrounding this number are
correct at all stages. I have
Hello,
i need to have the time in this output. in MySQL database
phpmyadmin always puts -00-00
i need it to be like this
01-APR-2005 DD-MMM-
the time needs to be like this
22:55 HH:MM
can somebody help
hans
--
MySQL General Mailing List
For list archives:
Hello.
Does Debian package preserve a master.info and relay-log.info files?
Do you stop slave before the upgrade? What does the 'SHOW SLAVE STATUS'
statement report?
Jacob Friis Larsen [EMAIL PROTECTED] wrote:
I use Debian Sarge as my Linux distribution on two servers who replicate
Hello.
Replication should work with MERGE tables. You may make a test
setup and check your scenario.
Eric Anderson [EMAIL PROTECTED] wrote:
Here's a question for you guys: is it possible to have a replicated
table of type MERGE?
Scenario:
Server: WWW1
Table:
Hello.
For your situation a slow query log might be suitable. See:
http://dev.mysql.com/doc/mysql/en/slow-query-log.html
[EMAIL PROTECTED] wrote:
It has been a rough day today. I am using mysql with coldfusion. Something
somehwere on my site is causing mysql to take up 100%
Hello.
When the server starts, it initializes all global variables to their
default values. These defaults may be changed by options specified in
option files or on the command line. After the server starts, those
global variables that are dynamic can be changed by connecting to the
server
Ken
Looks like you used a medium int field on the mysql table - if you import a
figure that is too big for the medium int to handle - on overflow it places
a value of 8388607 into the colum. You need to change to an integer column.
Regards
Tim hayes
-Original Message-
From: [EMAIL
hi All,
I am trying to fech some data from some interrelated tables. I am using
inner joins to relate tables. but mysql takes 7-8 sec to execute the query.
What could be the reason of such delays ? I would like to specify that one of
the interrelated table contains around 3000 rows.
On Wed, Apr 06, 2005 at 12:06:37PM +0200, Hans Bernard wrote:
i need to have the time in this output. in MySQL database
phpmyadmin always puts -00-00
i need it to be like this
01-APR-2005 DD-MMM-
Use date_format(, %d-%b-%Y %H:%m) in your SELECT?
bye,
-christian-
--
MySQL
- Original Message -
From: Hans Bernard [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, April 06, 2005 6:06 AM
Subject: DATE TIME
Hello,
i need to have the time in this output. in MySQL database
phpmyadmin always puts -00-00
i need it to be like this
On Wednesday, April 06, 2005 02:30, Martijn Tonies wrote:
Sorry, I don't use windows 8-) except when I have to. All my servers
are unix/linux and I can build them at will. I think there are
instructions in the manual for building it but I think you would
probably have to purchase a C++
thanks for the hints date_format() solved my problem my select query in php is
now
the following:
$query = SELECT id, calltt, date_format(calldate, '%d-%b-%Y') AS calldate2,
date_format(calltime, '%H:%i') AS calltime2,area, problem, solution, assignto,
status FROM ticketing ;
hans
Rhino
Hi!
MySQL/InnoDB-4.1.11 is a bugfix release of the stable 4.1 branch. This
branch is recommended for production use. There are no important bug fixes
in 4.1.11, for most users there is no need to upgrade from 4.1.10.
InnoDB is the MySQL table type that supports foreign key constraints,
Martijn Tonies wrote:
Sorry, I don't use windows 8-) except when I have to. All my servers are
unix/linux and I can build them at will. I think there are instructions
in the manual for building it but I think you would probably have to
purchase a C++ compiler or similar.
Exactly the reason why I
Sorry, I don't use windows 8-) except when I have to. All my servers are
unix/linux and I can build them at will. I think there are instructions
in the manual for building it but I think you would probably have to
purchase a C++ compiler or similar.
Exactly the reason why I do NOT want
At 18:35 01.04.2005, Gleb Paharenko wrote:
Hello.
I don't have any ideas at least now. But additional information could be
helpful. Do you connect from JBoss to the slave or master server? Please use
We are conecting to the active mysql (normaly master).
SHOW PROCESSLIST to find in what state the
Hi,
I have a problem with mysqldump when I want to copy a table from a database.
I have mysql Ver 14.7, Distrib 4.1.9, for pc-linux-gnu.
I use the following command:
mysqldump -h host -u user -ppassword database_name table_name
table_name.sql
And get the following error message:
mysqldump:
3000 rows are no big deal. 7 to 8 seconds seems long. Most likely,
there is either something wrong with your query, or you are missing a
needed index.
We can't tell you how to improve your query, however, without seeing
the query. We can't tell you if the table structure is the problem
On Monday, Mar 7, 2005, at 16:04 US/Central, [EMAIL PROTECTED] wrote:
It would be happy to try to help if I worked in or on either of those
platforms (Apache + Java). I am Win32(IIS), ASP (VBScript/JavaScript)
using MyODBC as my connection library.
Is using MyODBC the accepted way to connect to a
Yes, but not in the way you're thinking. I believe what you
want is one slave with multiple masters, which AFAIK is not
supported.
== STOP READING NOW UNLESS YOU ARE A GENIUS/MADMAN/IDIOT ==
That said, I suppose you could theoretically set up multiple
servers on your slave machine, where:
- All
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Are prepared statements cached on the server side? When I create a
prepared statement with one connection, and another connection tries to
create the same prepared statement, will the cached one be used?
I am trying to see when prepared statements
There was a magazine Database Programming Design, now defunct...too
much detail for the average IT Manager so it didn't sell well...that did
a nice multi-part series on the subject. Including the SQL3 connection.
I could only locate a couple of fragments online...it used to be all
online if you
mysql 4.1.x :Latin1, the select resualt is disorder:
shoud be axx
bxx
hhh
...
zxx
but actual:
axx
bxx
hhh
...
zxx
I think they are sorted by how many draws each word has.
Zhi
Shuming Wang [EMAIL PROTECTED] wrote:
mysql 4.1.x :Latin1, the select resualt is disorder:
shoud be axx
bxx
hhh
...
zxx
but actual:
axx
bxx
hhh
Robert Citek [EMAIL PROTECTED] wrote on 04/06/2005 10:55:07
AM:
On Monday, Mar 7, 2005, at 16:04 US/Central, [EMAIL PROTECTED] wrote:
It would be happy to try to help if I worked in or on either of those
platforms (Apache + Java). I am Win32(IIS), ASP (VBScript/JavaScript)
using MyODBC
Hi all
Suppose that I want to create a table with a column named DETAILS that
will contain textual data. Performance-wise, does it matter if I represent
this column with, say, a 200-char varchar or a larger type like text or
mediumtext but be sure that only textual data smaller than 200 chars
Unless something has radically changed since 4.1.2 then prepared
statements (at least from c) are 50% slower than executing statements as
required. Search for posts by me on the subject from last year.
Kevin Cowley
Product Development
Alchemetrics Ltd
SMARTER DATA , FASTER
Tel: 0118 902 9000
After executing de command make I have the next error
make: Fatal error: Don't know how to make target `ctype-big5.lo'
Current working directory /2ndhd/MYSQL/one/mysql-4.0.21/libmysql_r
*** Error code 1
make: Fatal error: Command failed for target `all-recursive'
Current working directory
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
It would appear, based on my testing, so far, that using stored
procedures is some between 25% slower and 10x slower, depending on the test.
I am using jdk1.5, on Solaris 8, and mysql 5.0.3.
I hope that when 5 comes out of beta that the performance
On Apr 5, 2005, at 11:37 PM, Matt Wagner wrote:
Hi,
A new version of MySQL Community Edition 4.1.11 Open Source database
management system has been released. It is now available in source and
binary form for a number of platforms from our download pages at
http://dev.mysql.com/downloads/ and
I tried the query defined in the Go Example queries:
and added some filtering on t.term_type, t.is_root and t.is_obsolete
Finding all ancestors of a term:
SELECT p.*
FROM
graph_path
INNER JOIN
term AS t ON (t.id = graph_path.term2_id
and t.term_type=biological_process)
INNER JOIN
term AS
At 10:07 AM 4/5/05, Frank Bax wrote:
At 04:27 PM 4/4/05, Frank Bax wrote:
Cannot execute query.
snip my SQL statement
Can't find file: './donor/list_lst.frm' (errno: 9)
- -
I got the same error last week on a different table. Today I notice that
there is a table in another database
According to perror:
perror 9
Error code 9: Bad file number
This is an operating system error code:
http://dev.mysql.com/doc/mysql/en/operating-system-error-codes.html
Out of curiosity, have you tried running myisamchk or some CHECK TABLE
commands yet?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
For the nams. tables the badge is the primary key, and since the
stored procedure and the dynamically generated function generate the
same queries, it shouldn't matter as to performance.
I am using Solaris 8, JDK1.5, mysql 5.0.3
I haven't tested
On Wed, 2005-04-06 at 09:55 -0500, Robert Citek wrote:
Is using MyODBC the accepted way to connect to a MySQL database from
within an ASP/VBScript page? Or is there some other way? For example,
PHP has a connector that can directly connect to a MySQL database.
I believe it's the only one
I have looked around in the documentation but I do not have a clear
idea of log_bin vs ib_lofile for innodb.
Regarding only INNODB tables, am I right if I say that:
log_bin are the commit transactions and it is what is use in an
automatic recovery or are to be apply in a manual recovery
Does Debian package preserve a master.info and relay-log.info files?
I'll check with some Debian experts.
Do you stop slave before the upgrade?
No.
What does the 'SHOW SLAVE STATUS'
statement report?
Before that everything is ok, after I don't know now that it is
running ok, but I'll
On Apr 6, 2005, at 2:12 PM, Michael Stassen wrote:
On Apr 5, 2005, at 11:37 PM, Matt Wagner wrote:
Hi,
A new version of MySQL Community Edition 4.1.11 Open Source database
management system has been released. It is now available in source and
binary form for a number of platforms from our download
Hi,
I have a problem: I am using mysql 4.0.24 and I need to make
some reports from a database:
mysql describe events;
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
- Original Message -
From: iNFERNo [EMAIL PROTECTED]
To: mysql mysql@lists.mysql.com
Sent: Wednesday, April 06, 2005 5:23 PM
Subject: I need some help
Hi,
I have a problem: I am using mysql 4.0.24 and I need to make
some reports from a database:
mysql describe events;
Hey folks...
While we weren't paying attention, one of the tables we were logging to
got big. Really big... like over 2 gigs... and then the server crashed
and the data became corrupt.
'Course, we'd like that data back...
Normal recovery seems to grab 490 rows... but, originally there were
Rhino wrote:
- Original Message -
From: iNFERNo [EMAIL PROTECTED]
To: mysql mysql@lists.mysql.com
Sent: Wednesday, April 06, 2005 5:23 PM
Subject: I need some help
Hi,
I have a problem: I am using mysql 4.0.24 and I need to make
some reports from a database:
mysql describe
On Wednesday 06 April 2005 20:05, jon wrote:
Normal recovery seems to grab 490 rows... but, originally there were
some 22 million rows in there.
Seems your data file was corruped too not only the indexes. and probably broke
when updating the 491st registry... try use myisamchk -e
-e,
Dear All,
Just to get a better understanding of how indices work in MySQL - If I
have a Innodb table with a composite primary key (fld1,fld2,fld3,fld4,fld5),
then my understanding is that MySQL optimizes just the leftmost primary key
(fld1 in this case).
Hence a query like select * from tbl1
I am looking for a nice OS X GUI client, can be java for osx that works
w/ mysql 5.x.
(these don't work MacSQL, CocaMySQL, YouSQL. MySQK admin does work, but
I want a bit more, like Maestro for OS X).
what should I use?
tia,
.V
--
MySQL General Mailing List
For list archives:
I am looking for a nice OS X GUI client, can be java for osx that works
w/ mysql 5.x.
(these don't work MacSQL, CocaMySQL, YouSQL. MySQK admin does work, but
I want a bit more, like Maestro for OS X).
what should I use?
tia,
.V
--
MySQL General Mailing List
For list archives:
- Original Message -
From: Michael J. Pawlowsky [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Wednesday, April 06, 2005 7:51 PM
Subject: Re: I need some help
Rhino wrote:
- Original Message -
From: iNFERNo [EMAIL PROTECTED]
To: mysql
54 matches
Mail list logo