Hi,
I have a small innodb table ~ 2k rows in Mysql 5.5.31-log version. Dont
understand why sometimes in a day , one update on that table is taking
around 1 minute to complete.
DBName Table Name DataData Free
| test | users | 0.48MB | 0.00MB
and I may not), views are representations of
> queries themselves. The guy who wrote
> the app chose to do updates and joins against the views instead of against
> the underlying tables themselves.
>
> I've tuned to meet the gross memory requirements and mysqltuner.pl is
> saying
ot), views are representations of queries
themselves. The guy who wrote
the app chose to do updates and joins against the views instead of against the
underlying tables themselves.
I've tuned to meet the gross memory requirements and mysqltuner.pl is saying
that 45% of the joins are withou
Hi, All,
Regarding mysql, I have problems on concurrent updates in the following
settings. I get a mysql server containing one database with 512 tables.
There is also a client who send concurrent updates to the server, each
update by a thread. As I increase the number of concurrent updates, I have
gt;
> like:
>
> mysql> UPDATE tbl_xyz set listprice='9.45' where prod_id='3069' and
> prod_code='a0071';
> Query OK, 1 row affected (0.00 sec)
> Rows matched: 1 Changed: 1 Warnings: 0
>
>
>
>
> How can I list rows with no recent up
it. Plus it's stored internally as an integer (timestamp)
*http://en.wikipedia.org/wiki/Long_and_short_scales
> -Original Message-
> From: MadTh [mailto:madan.feedb...@gmail.com]
> Sent: Monday, June 14, 2010 2:23 PM
> To: mysql@lists.mysql.com
> Subject: Re: list ro
Hi,
Thank you all for your prompt response. Unfortunately timestamp file isn;t
there, so I will find some other way to do it.
Seems timestamp is a valuable field ( unless you want to save resource on
generating timestamps on a very busy table).
Thanks
Do you have a timestamp field on this table?
There's no way of seeing when a row was last updated unless you have a
timestamp field that automatically updates for any change (that's *any*
change - not necessarily the ones you want to keep track of) or creating
your own and updating them
se that in your future query where @updated_time +/- some fuzzy amount of
seconds.
> -Original Message-
> From: MadTh [mailto:madan.feedb...@gmail.com]
> Sent: Monday, June 14, 2010 2:02 PM
> To: mysql@lists.mysql.com
> Subject: list rows with no recent updates
>
> Hi,
&g
_code='a0071';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
How can I list rows with no recent updates ( or the once where the above
updates were not done) or say with no updates in last 2 hours?
Thank you.
CREATE TRIGGER sync_t
AFTER UPDATE ON table1
FOR EACH ROW
UPDATE table2
SET name = NEW.name WHERE id = NEW.id;
> i have two tables namely.. table1 and table2, table1 and table2 have the two
> columns samely like id and name, by using triggers i have to bring the
> updates in table1
i have two tables namely.. table1 and table2, table1 and table2 have the two
columns samely like id and name, by using triggers i have to bring the
updates in table1 to table2, if i updated name in table1 trigger has to made
the same up date for table2. please help me regarding this.
thnaks in
:
Ron
> I would like to log all updates for a certain, only updates, not
inserts, is it possible?
Sure. For a review of methods for various kinds of audit trails see
"Audit Trails" Parts I & II at
http://www.artfulsoftware.com/infotree/mysqltips.php.
PB
Ron wrote:
Ron
> I would like to log all updates for a certain, only updates, not
inserts, is it possible?
Sure. For a review of methods for various kinds of audit trails see
"Audit Trails" Parts I & II at
http://www.artfulsoftware.com/infotree/mysqltips.php.
PB
Ron wrote:
Hi All,
I have a mysql cluster setup with 2 nodes. I would like to log all
updates for a certain, only updates, not inserts, is it possible?
would i be able to tell when it was updated and from what IP address the
update came from?
coz i have an issue wherein a certain table is being
Hello,
After a system host name had changed, my organization updated the MySQL user
records, changing the old (and now non-existent) host name to the new one.
This caused any views that were created by users accessing the MtSQL server
from the old host to become invalid as the view's creating
Is there anyway to keep updates and deletes from showing up in the slow
query logs?
He's using Delphi according to his first post. You might wanna use a
TClientDataSet if you're not doing so already. It provides a bit more
flexibility and won't keep the select query open for longer than is
necessary.
Have fun!
Walter
OlinData: Professional services for MySQL
Support * Consultin
er after
> a
> while if there are a lot of updates in the loop. If the updates are moved
> outside of the loop, the program completes without a problem. So it looks
> to me that there is some sort of contention for the table, between the
> Next
> statement of the Select and the U
my.ini file
(which worked fine with MySQL 5.0) with MySQL 5.1.30 and the same problem
occurs, the Next statement loses connection to the MySQL 5.1 server after a
while if there are a lot of updates in the loop. If the updates are moved
outside of the loop, the program completes without a problem. So
thing about this is the loop will work fine for a few hundred
> iterations then all of a sudden the Next statement is frozen and then loses
> connection to the server. This fails every single time it is run. If I take
> the updates out of the loop and process them later, it works fine. So there
>
is frozen and then loses
connection to the server. This fails every single time it is run. If I take
the updates out of the loop and process them later, it works fine. So there
is some sort of contention between traversing a table and updating a row of
the table at the same time. There ar
s worked fine in v5.0.1. Since upgrading to v5.1.30 after
a few
> hundred rows have been updated, the Next statement will hang for 60 seconds
> and then I get a "lost connection to mysql server" message. If I take the
> updates out of the loop, it completes just fine. So why are a f
imple and has worked fine in v5.0.1. Since upgrading to v5.1.30 after a few
>> hundred rows have been updated, the Next statement will hang for 60 seconds
>> and then I get a "lost connection to mysql server" message. If I take the
>> updates out of the loop, it completes just
grading to v5.1.30 after a few
> hundred rows have been updated, the Next statement will hang for 60 seconds
> and then I get a "lost connection to mysql server" message. If I take the
> updates out of the loop, it completes just fine. So why are a few thousand
> updates causing a
for 60
seconds and then I get a "lost connection to mysql server" message. If I
take the updates out of the loop, it completes just fine. So why are a few
thousand updates causing a problem inside of a loop? The updates are
updating 1 row at a time and does not alter any of the keys in
>
> If I have a table like this:
>> CREATE TABLE `Test` (
>> `TestId` bigint(20) default NULL
>> ) ENGINE=MyISAM DEFAULT CHARSET=latin1
>>
>> Does using --safe-updates mean that it's impossible for me to ever delete
>> from it, since it
If I have a table like this:
CREATE TABLE `Test` (
`TestId` bigint(20) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Does using --safe-updates mean that it's impossible for me to ever delete
from it, since it doesn't have a key? For example:
http://dev.mysql.com/doc/ref
If I have a table like this:
CREATE TABLE `Test` (
`TestId` bigint(20) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Does using --safe-updates mean that it's impossible for me to ever delete
from it, since it doesn't have a key? For example:
INSERT INTO Test VALUES (1),
On Thu, Oct 16, 2008 at 3:40 PM, Reyna.Sabina <[EMAIL PROTECTED]> wrote:
> A test using mysql -e "LOAD table ..." was ran to see
> if "LOAD' will give an error when loading a record with
> the same primary-key of an existing record in the table.
Do you mean LOAD DATA INFILE? It will give an erro
Hello,
Running Environment:
MySQL Server version: 5.0.45
OS is Red-Hat 64-bit
A test using mysql -e "LOAD table ..." was ran to see
if "LOAD' will give an error when loading a record with
the same primary-key of an existing record in the table.
LOAD acted as an UPDATE statement and it didn'
he partitioning. However I
> noticed
> that inserts and updates slow down considerably when the number of
> partitions goes up. (I think because if needs to inspect / open all
> partitions of the table)
>
> Since hashing uses a modulo function I figured that if I inserted rows
> which
&g
I'll do that, thanks. (Sorry for the long response time, I was in
Dublin this past week...).
On Mon, Apr 21, 2008 at 3:16 PM, Wm Mussatto <[EMAIL PROTECTED]> wrote:
>
> On Mon, April 21, 2008 07:28, Waynn Lue wrote:
> > Is there any way to prevent UPDATEs on on
On Mon, April 21, 2008 07:28, Waynn Lue wrote:
> Is there any way to prevent UPDATEs on one database on one mysql
> instance from affecting SELECTs on other databases in the same
> instance? I'm noticing a whole bunch of backed up connections on
> other databases when I run massi
Is there any way to prevent UPDATEs on one database on one mysql
instance from affecting SELECTs on other databases in the same
instance? I'm noticing a whole bunch of backed up connections on
other databases when I run massive UPDATEs on one.
Thanks!
--
MySQL General Mailing List
For
Hi,
I have a partitioned table using hash. For the example lets say I have N
partitions. Selects perform well due to the partitioning. However I noticed
that inserts and updates slow down considerably when the number of
partitions goes up. (I think because if needs to inspect / open all
Hello,
I am facing a problem related with triggers and bulk updates/inserts.
I have two tables one is having 'transactions' and another is 'documents'.
Each record in transactions table relates with a document by DocId. Foreign
keys are created.
I have activated triggers for tr
Robert DiFalco wrote:
Is there any difference between calling rollback or commit on a
transaction that did not alter data? For example, not a read-only
transaction but a transaction that only performed read-only selects. Any
difference in performance between calling rollback or commit? I know
the
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 18, 2007 10:00 AM
To: Robert DiFalco
Cc: Baron Schwartz; mysql@lists.mysql.com
Subject: Re: Rollback on a Transaction with No Updates
I realize that wasn't the question, but it does seem like a lot of
trouble to get the equivalent of setAutoCommit
ichael Dykman [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 17, 2007 2:56 PM
> To: Robert DiFalco
> Cc: Baron Schwartz; mysql@lists.mysql.com
> Subject: Re: Rollback on a Transaction with No Updates
>
> If your transaction are only 1 query deep, why use them at all? An
> indivi
Sure, but that wasn't really the question.
-Original Message-
From: Michael Dykman [mailto:[EMAIL PROTECTED]
Sent: Monday, September 17, 2007 2:56 PM
To: Robert DiFalco
Cc: Baron Schwartz; mysql@lists.mysql.com
Subject: Re: Rollback on a Transaction with No Updates
If your transa
Is there any difference between calling rollback or commit on a
transaction that did not alter data? For example, not a read-only
transaction but a transaction that only performed read-only selects. Any
difference in performance between calling rollback or commit? I know
they are functionally the s
same as issuing a commit (unless there was an exception but I'm not
> analyzing that case).
>
> -Original Message-
> From: Baron Schwartz [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 17, 2007 2:36 PM
> To: Robert DiFalco
> Cc: mysql@lists.mysql.com
>
ing a commit (unless there was an exception but I'm not
analyzing that case).
-Original Message-
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Sent: Monday, September 17, 2007 2:36 PM
To: Robert DiFalco
Cc: mysql@lists.mysql.com
Subject: Re: Rollback on a Transaction with No Updat
Robert DiFalco wrote:
Is there any difference between calling rollback or commit on a
transaction that did not alter data? For example, not a read-only
transaction but a transaction that only performed read-only selects. Any
difference in performance between calling rollback or commit? I know
the
This helped:
http://forums.mysql.com/read.php?26,133157,136626
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
7;. Query: 'delete from xxx'
...
However, safe-updates is not configured in my.cnf and I also think this
is a CLIENT SESSION variable.
How can I disable safe-updates for the slave-thread (if it should be
configured).
What else could be the reason?
Regards
Dominik
--
MySQL Gener
I think this is a bug in MySQL 5.1.16-beta (I'm using SUSE 10.2 Linux),
but I can't find any information on it.
When performing an update which doesn't change any rows, I get different
results back depending on the declarations of the fields in the table.
If a 'normal' NDB table is created
hi,
AFAIK, if we start mysqld with --low-priority-updates, it sets table updation a
lower priority than the SELECT statements, irrespective of storage engines.
hence it will affect the priority of the update operation.
Ref: http://mysql.justdn.org/doc/refman/5.1/en/table-locking.html
Здравствуйте, mysql.
Hi all.
I want to ask about low-priority-updates and innodb tables. Does
low-priority-updates=1 affect on priority of select or update query on
innodb type tables?
--
С уважением,
Vitaliy mailto:[EMAIL PROTECTED]
--
MySQL General Mailing List
For
Hello, I'm looking for help in merging the contents of two database
tables with identical columns between them. A base set of data will
be stored in the "permanent" table, and incremental additions and/or
changes will be introduced in the "staging" table the ID's of the
data in the tables
HERE y.id IS NULL
Or the opposite with a multi-table update:
UPDATE x,y
SET x.YitemsExist="Y", y.XitemsExist="Y"
WHERE x.id=y.id
- Original Message -
From: "Chris White" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, January 10, 2007 12:55 PM
Subject: Multiple tabl
The key part of the documentation for me was:
- Original Message -
From: "Chris White" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, January 10, 2007 12:55 PM
Subject: Multiple table updates (Was: Does Update allow for aliases)
Reading the noted previous thread, I w
Reading the noted previous thread, I was curious as to updating multiple
tables. I read the MySQL docs, which mentions that you can do it:
Multiple-table syntax:
UPDATE [LOW_PRIORITY] [IGNORE] /|table_references|/
SET /|col_name1|/=/|expr1|/ [, /|col_name2|/=/|expr2|/ ...]
[WHERE /|where
I have this problem too on large tables. Currently my table is 5
million or so but could easily grow to 10 to 50 times that.
I ended up adding a field called Status, and then adding an index for
the primary key and status fields.
Then I do my UPDATES or DELETES for a particular status value
seconds, so locking isn't a big issue. Insert/Updates complete between the selects. I also don't have to
worry mysql running out of memory and swapping to disk regardless of how big the dataset gets.
- Original Message -
From: "Jon Ribbens" <[EMAIL PROTECTED]>
provided all
your inserts are delayed (otherwise you could get corruption).
If you have optimized the table and there are no deleted rows, the Inserts
will not need to do any locking at all.
As for Updates, make sure you are using an index on the update, preferably
the primary key to identify the row
On Thursday 19 October 2006 17:06, Jon Ribbens wrote:
> I have a simple single-table SELECT query that takes of several
> minutes to complete, due to a very large number of result rows being
> involed. I don't think there is any way to optimise the query - MySQL
> is already using the appropriate i
I have a simple single-table SELECT query that takes of several
minutes to complete, due to a very large number of result rows being
involed. I don't think there is any way to optimise the query - MySQL
is already using the appropriate index etc, it's just a huge table and
the query has a large res
;[EMAIL PROTECTED]>
To:
Sent: Wednesday, June 14, 2006 2:24 PM
Subject: Time of entry updates?
Is there any way to find the time of the most recent update for a row?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is there any way to find the time of the most recent update for a row?
Hi Luke,
When mysql is doing a dump, do the updates that happen during the dump
get included in the dump.
I assume you mean 'mysqldump'.
I have a dump that starts at 11pm and goes for 2 hours. If someone
updates data at say 11:45pm, does that update get included in the dump?
Whe
need.
Hope this help,
themage
On Monday 08 May 2006 00:07, Logan, David (SST - Adelaide) wrote:
> Hi Luke,
>
> Like most backup systems, there is no window unless you are locking the
> table/database. If the record has been read and passed out to mysqldump,
> any further upda
Hi Luke,
Like most backup systems, there is no window unless you are locking the
table/database. If the record has been read and passed out to mysqldump,
any further updates will not be included until the next backup.
The only way to ensure you get complete referential integrity is to stop
any
Hi.
When mysql is doing a dump, do the updates that happen during the dump
get included in the dump.
I have a dump that starts at 11pm and goes for 2 hours. If someone
updates data at say 11:45pm, does that update get included in the dump?
When does the window, on what gets included in a
`valorSNMP` varchar(12) default NULL,
>`nombre_dns` varchar(20) default NULL,
>`hora` varchar(10) default NULL
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1
>
> I cannot use indexes because my dbexpress driver doesn't sup
lt NULL,
>`hora` varchar(10) default NULL
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1
>
> I cannot use indexes because my dbexpress driver doesn't support it (long
> story short, I'll
Because you have no indexes on that table... MySQL will open and search
within the entire table.
If you would have had an index MySQL would know how to go directly to the
row you want to update.
You are always looking for rows with:
WHERE id ="?"
So there you have... you mus
`hora` varchar(10) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
I cannot use indexes because my dbexpress driver doesn't support it (long story
short, I'll change it in the next version).
Now, I have to make a lot of sequential updates, like
UPDATE ultimas_respu
Hi,
2006/1/17, Karl Pielorz <[EMAIL PROTECTED]>:
>
> Hi All,
> 1. Fixed length CHAR fields are quicker to update than VARCHAR fields
> (because the field size is constant)
There is no advantage if not all your field in your table are fixed
size. as soon as you add a text/blob column, you loose t
s it not that 'clever'?
I realise the savings from the above could be fairly small, but when you're
processing thousands of updates an hour, it all adds up - if we can have
MySQL doing 'less work' for the updates.
Thanks in advance,
-Karl
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Pete Harlan wrote:
> FYI,
>
> 4.1.16 appears not to be using prefixes of compound indexes when doing
> updates. Reverting to 4.1.15, or adding an index consisting of only
> the desired field, restores reasonable behavior.
>
> I have added feedback to a possibly
FYI,
4.1.16 appears not to be using prefixes of compound indexes when doing
updates. Reverting to 4.1.15, or adding an index consisting of only
the desired field, restores reasonable behavior.
I have added feedback to a possibly-related bug,
<http://bugs.mysql.com/bug.php?id=15935>, but
L PROTECTED]>
> To:
> Sent: November 23, 2005 5:51 AM
> Subject: Re: UPDATE and INDEX updates
>
>
> > Hello.
> >
> > > don't think I will find the answer to this question in the normal
> >manuals
> > > but rather from someone / plac
.
Is it the "row changed" flag or is there a "column changed" flag ??? Mike
- Original Message -
From: "Gleb Paharenko" <[EMAIL PROTECTED]>
To:
Sent: November 23, 2005 5:51 AM
Subject: Re: UPDATE and INDEX updates
> Hello.
>
> > don't
Hello.
> don't think I will find the answer to this question in the normal >manuals
> but rather from someone / place that deals with the internals of the
>system.
> Mike
MySQL internals are available at:
http://dev.mysql.com/doc/internals/en/
Mike OK wrote:
> I did read the man
>
Cc: "MySQL List"
Sent: November 22, 2005 3:05 PM
Subject: Re: UPDATE and INDEX updates
You're going to have to read the manual on the different types of
indexes. Without knowing what kind of index (Hash, B-tree) you're
using and on what kind of table, I cannot help you.
emoved from the index and re-placed?? Does
> MySQL look at each column value first to compare?? Mike
>
> - Original Message -
> From: "sheeri kritzer" <[EMAIL PROTECTED]>
> To: "MySQL List"
> Sent: November 22, 2005 9:31 AM
> Subject:
- Original Message -
From: "sheeri kritzer" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: November 22, 2005 9:31 AM
Subject: Re: UPDATE and INDEX updates
Mike,
The documentation at
http://dev.mysql.com/doc/refman/5.0/en/update.html explains that MySQL
is aware of the fact th
Mike,
The documentation at
http://dev.mysql.com/doc/refman/5.0/en/update.html explains that MySQL
is aware of the fact that it only needs to update different values --
for instance, it returns only the # of rows changed, not the # of rows
looked at. Given that, I will extrapolate that MySQL is no
Hi
I was wondering how the index process worked internally for UPDATE
statements. If I was to "set" a value for a column with the UPDATE statement
but the value was the same, would MySQL re-work the index?? I can check for
data change for each column inside of my code before UPDATE but wa
I've got a table (pages) with an order column (pages.iOrder) and and
grouping column (pages.iCategoryID).
The order column is just a SMALLINT UNSIGNED column, that should contain
the values 1-n for each iCategoryID. These are used to order the rows in
each category.
I'm in the process of writi
d row is reported and the value is indeed only updated once.
Filed as http://bugs.mysql.com/8942
Regards, Jigal.
- Original Message -
From: "Jigal van Hemert" <[EMAIL PROTECTED]>
To:
Sent: Thursday, March 03, 2005 11:18 AM
Subject: Strange internal loop causing multiple updates
Tested on MySQL version 4.0.23, 4.1.8 and 4.1.10
OS: RedHat Fedora Core 2 / RedHat 8
Table type: InnoDB or MyISAM
Table structure:
CREATE TABLE `param_str` (
`id` int(11) NOT NULL default '0',
`name` varchar(32) NOT NULL default '',
`value` varchar(255) default NULL,
`match` varchar(255)
Hi,
I use the following statement to update a table, but I don't see the
testing record being updated:
$udpate_sql = qq {update transaction
set salesvolume=$salesvol,
netsales=$netsales, transtype="$transtype",
returnreason="$returnreas
Hello.
Use --log and --log-long-format (if your MySQL version below 4.1) to
determine who makes these queries.
Dilipan Sebastiampillai <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> from time to time I have a huge number of DELETEs or/and UPDATES
> processed by MySQL at
Hi all,
from time to time I have a huge number of DELETEs or/and UPDATES
processed by MySQL at noon and 8pm. The trouble is that I didn't send
those queries to MySQL !
i don't have any crons running.
Is this an automated MySQL procedure ? Is there any automated procedure
within MySQ
Hi everyone,
Our server crashed the
Two questions :
1) is it normal to have a dramatic amount of UPDATES after a MySQL
restart after crash ?
2) how to get valuable information from the following? ;
Crash from 20/12/04 at 20.10(?)
from server.err :
mysqld got signal 11;
This could be because
Hello!
Could anyone tell me if updates in multiple tables also make use of table indexes? And
if they do does it works in the same general manner as it does for select clauses?
Thanks,
Arthur
be used to read
8i redo logs as well, so you might want to use the
newer 9i client if you go this way.
Updates to the oracle database could be processed the
same way using the mysql binary log as long as no
mysql extensions were used like inserting multiple
rows with a single insert statement
On Tue, Jul 13, 2004 at 06:11:22PM -0700, Carl Edwards wrote:
> Hello,
>
> I found a question about Oracle 2 MySQL replication in the
> archive on Sep. 2001 but no mention since?
>
> We have a department using Oracle 8.1.7 and I'm running MySQL
> 4.0 and neither of us wants to change :-)
>
> I
Hello,
I found a question about Oracle 2 MySQL replication in the
archive on Sep. 2001 but no mention since?
We have a department using Oracle 8.1.7 and I'm running MySQL
4.0 and neither of us wants to change :-)
I could call a Perl, C++ or Java program from cron to periodically
update the MySQ
[resending this with another mail user agent to bypass the spam filter]
Dear Andy,
I have this weird problem with 1 transaction locking out another for
no
apparent reason and in an inconsistent fashion. I'm using mysql
4.0.18
with innodb tables. The table in question has 2 primary keys: CID and
mysql docs
and the comments in the source), updates that uses all primary keys does
not place gap locks. FYI, there is already a row in the table with those
primary keys, so the update query did update 1 row (and not 0 rows).
And notice that in both of my test cases, the only difference is in the
pr
Hi all,
This is my first time on the mysql mailing list, I appreciate if someone
can help me with a major problem I encountered with mysql.
I have this weird problem with 1 transaction locking out another for no
apparent reason and in an inconsistent fashion. I'm using mysql 4.0.18
with innodb ta
records.
Hope this helps,
Jack
-Original Message-
From: William Wang [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 06, 2004 1:12 PM
To: [EMAIL PROTECTED]
Subject: many updates really slow
Hi everyone,
Please help.
I have MySQL server running on host A in US and I am
using it on host B in Europe. Ever
s helps,
>
> Jack
>
> -Original Message-
> From: William Wang [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 06, 2004 1:12 PM
> To: [EMAIL PROTECTED]
> Subject: many updates really slow
>
>
> Hi everyone,
>
> Please help.
>
> I have MySQL server
e file, it goes
back to sleep.
Jack
-Original Message-
From: William Wang [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 06, 2004 1:43 PM
To: Jack Coxen; [EMAIL PROTECTED]
Subject: RE: many updates really slow
Thanks Jack and Jeremy.
But this is part of my application and I need to do
this a
n receiving the status
> back in Europe...times 5000 records.
>
> Hope this helps,
>
> Jack
>
> -Original Message-
> From: William Wang [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 06, 2004 1:12 PM
> To: [EMAIL PROTECTED]
> Subject: many updates really slo
Original Message-
From: William Wang [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 06, 2004 1:12 PM
To: [EMAIL PROTECTED]
Subject: many updates really slow
Hi everyone,
Please help.
I have MySQL server running on host A in US and I am
using it on host B in Europe. Every query takes about
1 - 100 of 241 matches
Mail list logo