There is only one thread for replication on the slave. It does one step a
time. If you use mysqlbinlog on one of your binary files on your master,
you will see exactly how it all works.
Multi-threaded would probably cause thousands of problems. Unless it was
threaded per table, but that would
This is my first attempt to design and test MySQL. I have used MS SQL for
number of years. I do appreciate if members of this list can recommend a
good GUI application for MySQL. I want the GUI application to design DB,
design Quiries, etc.
Take a look at Database Workbench -
Hopefully a simple problem!? ...
MySQL produces a server-error when performing a query like
SELECT char FROM mytable WHERE id=4711
This seems to be 'char' is a MySQL-keyword. Ok!
But how can i quote it??? (I could not find any information about this
issue in the documentation...)
Help
Hi,
Hopefully a simple problem!? ...
MySQL produces a server-error when performing a query like
SELECT char FROM mytable WHERE id=4711
This seems to be 'char' is a MySQL-keyword. Ok!
But how can i quote it??? (I could not find any information about this
issue in the documentation...)
If you base64 encode your binary, it will be valid inside the xml. As far
as I know this is the accepted way to transfer binary objects using xml.
chris
-Original Message-
From: Karam Chand [mailto:[EMAIL PROTECTED]
Sent: 13 August 2004 05:09
To: Keith Ivey; [EMAIL PROTECTED]
Subject:
Hello! :)
mysqlcheck -r is very slow when repair big tables
(over 4GB data - repair it 1h and 40m). Is there any
config option to fasten it.
Regards: Kosyo
__
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
On Wed, 11 Aug 2004 23:40:27 -0700, Scott Haneda [EMAIL PROTECTED] wrote:
I made a mailing list archiver, I thread discussions by subject. I chose
to not use message-id's since so many people hijack threads.
Why not select/group on subject, and then thread on messageid.
Given this case:
Replace deletes and inserts.
?
what do you mean?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Anybody else have any ideas?
I cant keep the slave up
only thing I have not tried is upgrading to 4.0.20, however, nothing
changed to cause this problem
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql show index from urun;
+---++--+--+-+--
-+-+--++--++-+
| Table | Non_unique | Key_name | Seq_in_index | Column_name |
Collation | Cardinality | Sub_part | Packed | Null
Have you set it up so that these instances run on different ports and
different sockets? If you are not using mysqld multi you will have to
specify which mysql/bin/safe_mysqld you want to start on the command line.
-Original Message-
From: sean c peters
To: [EMAIL PROTECTED]
Sent: 8/12/04
Yes. Those keys are redundant.
-Original Message-
From: Cemal Dalar
To: Group MySQL List
Sent: 8/13/04 7:12 AM
Subject: Indexes
mysql show index from urun;
+---++--+--+-+--
If possible, and for testing purposes try starting the 4.1.3 server with the
options given on the command line. (datadir, pid, socket, port, etc...)
-Original Message-
From: sean c peters
To: [EMAIL PROTECTED]
Sent: 8/12/04 6:37 PM
Subject: datadir specification, etc
I am 100% convinced
I reset the master, flush logs, reset master, show master status..
shows FINANCE-bin.186 at position 79
so I started the slave
CHANGE MASTER TO
MASTER_HOST='192.168.1.168',
MASTER_USER='repl',
MASTER_PASSWORD='Daredevil22',
MASTER_LOG_FILE='FINANCE-bin.186',
MASTER_LOG_POS=79;
start slave;
and I
matt ryan wrote:
Replace deletes and inserts.
?
what do you mean?
Replace does a delete followed by an insert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
More info..
I dont see anythign wrong with the binlog the slave has
E:\mysql\datamysqlbinlog databasebackup-relay-bin.001
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
# at 4
#691231 19:00:00 server id 1 log_pos 0 Rotate to
FINANCE-bin.186 pos:79
# at 46
#691231 19:00:00 server
Hi,
Just wanted to check if anyone would know if the MyOLEDB / myODBC has
been updated to support stored procedures / functions in MySQL server
version 5.0.0 alpha.
I am getting error DB_E_ERRORSOCCURRED(0x80040E21) when trying to
execute Non Query from ADO.NET (OLEDB provider MyOLEDB).
Replace does a delete followed by an insert.
Ahh, I'm testing innodb on our tables with this problem
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Many threaded discussion groups create a thread_ID for the first topic in
any thread. That thread_ID is usually stored invisibly with each response.
Each response also maintains (invisibly, too) the message id of it's
parent. Of course the parent_ID of the root message in any thread would be
Have you considered that a proxy server may be in the way. I have been
watching this thread but I can't remember if you said anything about your
network connectivity (sorry!). I have seen several programs make what they
thought was a connection then fail because they don't know they are
[EMAIL PROTECTED] wrote:
Have you considered that a proxy server may be in the way. I have been
watching this thread but I can't remember if you said anything about
your network connectivity (sorry!). I have seen several programs make
what they thought was a connection then fail because they
I can connect in the php by using 'root' and the root pw. But when I
tried adding a user ( sarah ) with GRANT I cannot connect from php. The
php is simple, what am I overlooking? Again putting the root user name
and pw it'll work in php but not for sarah:
the php
If I want to update these day fields in this table:
day, date, month, year
-1 August 2004
-1 August 2004
I want on to be Sunday Lunchtime the other to be Sunday Evening. What
query do I use that won't update both fields with the same data?
--
MySQL General Mailing List
For list
Please post the entire contents of SHOW CREATE TABLE for this table and we
will have enough information to answer your question.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
[EMAIL PROTECTED] wrote on 08/13/2004 09:48:21 AM:
If I want to update these day fields in this
john henry bonham wrote:
If I want to update these day fields in this table:
day, date, month, year
-1 August 2004
-1 August 2004
I want on to be Sunday Lunchtime the other to be Sunday Evening. What
query do I use that won't update both fields with the same data?
maybe something
hi
is it possible to have 2 applications update/insert/delete records from a embedded
database. example: app1 on a repetitive process checks for record in table1 while app2
inserts a record in table1.
if u think about it, it should be possible. technically, the mysqld process is now
imbedded
At 10:46 -0700 8/12/04, Karam Chand wrote:
Hello,
i have a table with a LONGBLOB column. We store some
small images in it. I want to export them in XML
format with schema like:
cdata/c
cdata/c
...
...
Now the problem is even if I mysql_real_escape() and
changing entities like , to lt; gt; the
i usually do
$link = mysql_connect($server, $userid, $password);
and it works, except when the pw is incorrect
suomi
leegold wrote:
I can connect in the php by using 'root' and the root pw. But when I
tried adding a user ( sarah ) with GRANT I cannot connect from php. The
php is simple, what
In my experience, where the my.cnf file is concerned, mysqld does not
care what you define for the value of the --datadir flag. The order of
precedence for locating my.cnf files is:
1) /etc/my.cnf
2) my.cnf in the COMPILED-IN DEFAULT datadir
3) .my.cnf in the user's $HOME
That
What error are you getting? My problem when moving to 4.1 was
forgetting that I was using an older MySQL client.
I'm not positive, but I think that in order to connect to MySQL 4.1
with PHP you need to use the mysqli functions, not mysql, and mysqli
requires PHP 5.
If you want to keep
Which flag did you use to define the datadir for configure? --datadir
doesn't do the trick. --localstatedir does. Also, you might want to
consider setting --prefix as well.
--V
sean c peters wrote:
The problem is that i did build 4.1.3 florm a source distribution, and set the
datadir via
Hi,
I'm using mysql 4.0.12 and I got a database that holds the DMOZ data
(master/slave config). Now this is a (to me anyways) pretty big
database(4 million some links, with fulltext indexes). However I have a
problem with it. For some reasons I can't get a grip on, the table
crashes. (error
I'm currently on research on SQL selection for our future Database project,
and so far I've noticed that there are problem with slave, is it common for
MySQL to have slave problem? I'm looking into Microsoft SQL Server,
PostgreSQL and MySQL for our future project.
Scott
--
MySQL General
$ perror 145
Error code 145: Error 145 occurred.
145 = Table was marked as crashed and should be repaired
I think `myisamchk` needs to come into play here (both on slave and
master at this point).
http://dev.mysql.com/doc/mysql/en/myisamchk_syntax.html
Hi list, I get this error from MySQL administrator, everything was fine before I
converted the db and uploaded it to our host company. What is going on here? Thanks a
lot for any help
Could not connect to the specified host
MySQL error Nr.2003
Cant connect to MySQL server on local host (10061)
All:
I have been nosing about for some time now and think I need some help.
The Problem:
Mytop is telling me that I am running no more than 1000 queries per second,
and the key efficiency is 100%. But, some select and replace statements are
taking an unusually long time. These seem to revolve
matt ryan wrote:
Replace does a delete followed by an insert.
Ahh, I'm testing innodb on our tables with this problem
I've switched to innodb but performance isnt very good
while the insert runs, here's what I get for performance
select count(*) from rondon;
1 row in .13 sec
select count(*) from
V. M. Brasseur wrote:
$ perror 145
Error code 145: Error 145 occurred.
145 = Table was marked as crashed and should be repaired
I think `myisamchk` needs to come into play here (both on slave and
master at this point).
Yea I know, and I had done that like a few days ago because it gave me
the
matt ryan wrote:
matt ryan wrote:
Replace does a delete followed by an insert.
Ahh, I'm testing innodb on our tables with this problem
I've switched to innodb but performance isnt very good
while the insert runs, here's what I get for performance
select count(*) from rondon;
1 row in .13 sec
Can you describe your network setup? Are you expecting port 3306 to be open
on your ISP? Are you ssh'ed in and you can not connect?
-Original Message-
From: EWAGW
To: [EMAIL PROTECTED]
Sent: 8/13/04 12:02 PM
Subject: Pinging
Hi list, I get this error from MySQL administrator,
That depends on the setup and configuration and network and other factors. I
have been running slaves for months and a year with little to no problems.
Are you asking something in specific or just looking for feedback?
-Original Message-
From: Scott Hamm
To: 'Mysql ' (E-mail)
Sent:
Boyd E. Hemphill wrote:
But, some select and replace statements are taking an unusually long
time. These seem to revolve around a couple of tables that are
written to and read from very often.
innodb_data_file_path = ibdata1:15G:autoextend
We are running Gentoo Linux 2.6.4 on a dual AMD
Hi,
I would like to use SUM or any other function to sum a series of
records as in the following example.
I have this table T1
Col1Col2
1 20
2 10
1 10
25
1 20
3 10
and would like to obtain this
On Fri, 13 Aug 2004 11:24:46 -0400, Wesley Furgiuele
[EMAIL PROTECTED] said:
What error are you getting? My problem when moving to 4.1 was
forgetting that I was using an older MySQL client.
I'm not positive, but I think that in order to connect to MySQL 4.1
with PHP you need to use the
I am afraid not. A spreadsheet is the right tool for that job, not a
database. Sorry!
Of course you could always script your own solution (calculating running
totals, etc.)
Best Wishes,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
[EMAIL PROTECTED] wrote on 08/13/2004
--Try this, using variable @foo:
SELECT t1.col1, t2.col2, @foo := @foo + (t1.col1 * t1.col2) col3
FROM t1
On Fri, 13 Aug 2004 15:29:18 -0700, Mauricio Pellegrini
[EMAIL PROTECTED] wrote:
Column Col3 should carry forward and sum values from Col2
--
MySQL General Mailing List
For list
Mauricio Pellegrini wrote:
and would like to obtain this result from a query
Col1Col2Col3
1 20 20
1 10 30
1 20 50
2 10 10
25 15
3 10 10
Column Col3 should carry
Thanks for the post Victor, I can connect fine to my isp(through port 3306)
, but not to localhost that is the problem
- Original Message -
From: Victor Pendleton [EMAIL PROTECTED]
To: 'EWAGW ' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, August 13, 2004 1:09 PM
Subject: RE: Pinging
I think that's the problem.
Could be a lot of editing PHP scripts for a lot of people(!?)
Thanks
Try to compile PHP against the client library for MySQL 4.1. I'll
wonder if it won't work. ext/mysqli is required if you like to
use things like prepared statements...
Regards,
A.
--
MySQL
matt ryan wrote:
Replace does a delete followed by an insert.
Ahh, I'm testing innodb on our tables with this problem
Doh another problem
innodb has no merge option, I have too much data, and the only way to
deal with it, is partition the data and then tie it together with merge
views.
Do you know if the user you are using is allowed to connect from the
localhost? Logically one would think that if the ISP granted you the ability
to connect from outside the localhost, your host value would be wildcarded
and thus you should be able to connect from the localhost as well.
Do you
I hate to pry (snoop) but my curiosity is just going nuts! If this is a
sensitive issue, please ignore my questions
What are you doing that requires you to mass-replace so many records so
often? Are they design or processing requirements (or both) that require
this kind of bulk exchange
Do vmstat and top reveal anything about the server's performance? Can you
post the show status output?
-Original Message-
From: Boyd E. Hemphill
To: [EMAIL PROTECTED]
Sent: 8/13/04 12:17 PM
Subject: Tuning InnoDB situation
All:
I have been nosing about for some time now and think I need
Hey!!! thanks thanks thanks to all of you!.
Your just wonderfull and the help you provide is priceless.
I think I will solve my problem now.
I've read about the use of variables in the manual but
It would have taken me a lot of time to figure something like this.
Thanks again and to all the
On Fri, Aug 13, 2004 at 01:19:14AM -0500, Donny Simonton wrote:
There is only one thread for replication on the slave. It does one
step a time. If you use mysqlbinlog on one of your binary files on
your master, you will see exactly how it all works.
No, there are 2 threads: the IO (or
Hello mysql-help,
How i can increase max allowed keys in myisam tables? I find this
sting in myisam.h:
#define MI_MAX_KEY 32 /* Max allowed keys */
Is it so simple? Or I must correct somthing more?
What is the max value of MI_MAX_KEY ?
Michael Monashev
http://softsearch.ru/
Greetings All,
As a way to cooperatively work to address some of the licensing
concerns held by members of the MySQL community and the broader Free
Software/Open Source community, we are initiating a community review of
our licensing policy documents.
This means that we are soliciting feedback
Hi all. Got a weird one. Mysql 4.0.20. Let's say for the sake of
argument that I've got two tables, T1 T2. Here are the two create
statements:
CREATE TABLE `T1` (
`guid` smallint(5) unsigned NOT NULL default '0',
`qid` smallint(5) unsigned NOT NULL default '0',
`a` tinyint(2) NOT NULL
Dear Driends,
From command prompt I want to generate dump files of database tables. Any
guidance how do I do the same.
Inform, please.
Hi,
Is this what you need/want?
mysqldump db_name /path/to/whereever/dump.sql
Kind Regards,
Christian Biggins
Web Developer
Web: http://www.fusiononline.com.au
Email: [EMAIL PROTECTED]
Phone: 0410 596 841
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent:
60 matches
Mail list logo
