Hi,
How big is sample.sql dump ?
there are many different things, might taking the time. dns resolve issue,
network issue
tcp0 0 www.myweb.:mysql A.B.C.D:8366 *TIME_WAIT* (It should
established)
load on the server, check mysql processlist (any wrong query is there)
Thanks,
Krishn
Did you check the server load when it took 10 min.
Check the query log, number of connections and the number of queries in
query log at that time.
We need to analyze the system with the collected data what we have for
monitoring.
Thanks
Suresh Kuna
On Fri, Jan 22, 2010 at 12:25 PM, madunix wrote
Increase your Innodb_buffer_pool_size. It will solve your problem.
Thanks,
Krishna
On Sat, Aug 29, 2009 at 10:39 AM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Hi All,
>
> I have a query which gives an error of lock wait timeout only this
> transaction is running with 2 recor
Hi,
You are right. The storage engine i m using is InnoDB. but then my concern
is why this simple update query takes so long. Is it true that if its
innodb table then even after specifying where condition it scans all
indexed rows. I am bit confused as mysql.com have mentioned on there site
that e
On Sat, Aug 29, 2009 at 12:09 PM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Hi All,
>
> I have a query which gives an error of lock wait timeout only this
> transaction is running with 2 records in the table.
>
> The query is :
>
> Update Test
> Set TestFlag = 1
> Where TestID
Prem Soman <[EMAIL PROTECTED]> wrote:
> i want to update every row in the mysql table that
> matches a part of each row in it.
>
> ie.
>
> for example if a table contains the following rows :
>
> Pid:21577
> PPid: 21174
> Uid:501
> Gid:501
>
> i want to change the firs
joseph,
Wednesday, October 30, 2002, 9:53:57 PM, you wrote:
js> On Tue, Oct 29, 2002 at 11:56:01AM +0200, Egor Egorov wrote:
>> Marco,
>> Tuesday, October 29, 2002, 7:22:44 AM, you wrote:
>>
>> MB> I need your expert and slow guided assistance.
>>
>> MB> I would some one to teach me how to do fo
On Tue, Oct 29, 2002 at 11:56:01AM +0200, Egor Egorov wrote:
> Marco,
> Tuesday, October 29, 2002, 7:22:44 AM, you wrote:
>
> MB> I need your expert and slow guided assistance.
>
> MB> I would some one to teach me how to do for that user
> MB> and allow him/website to have access to that database
Marco,
Tuesday, October 29, 2002, 7:22:44 AM, you wrote:
MB> I need your expert and slow guided assistance.
MB> I would like someone to explain to me the correct mysql commands
MB> monitor to achive the following correctly.
MB> It would greatly help if you work for a hosting company.
MB> The qu
Steve,
Tuesday, July 23, 2002, 7:36:39 AM, you wrote:
S> Can anyone tell me how do achieve the following in MySQL:
S> Update oitems
S> SET Pstatus = SELECT product.Pstatus from products
S> WHERE oitems.Pstatus not like "%Printed%"
S>AND oitems.ProdCode=products.Code
S> i.e.
Can anyone tell me how do achieve the following in MySQL:
Update oitems
SET Pstatus = SELECT product.Pstatus from products
WHERE oitems.Pstatus not like "%Printed%"
AND oitems.ProdCode=products.Code
i.e. I need to update all order item status flields that have not been
printe
* USER
> Is there any way to do an Update...Select like an InsertSelect?
>
> For instance can I fill one table with data from another table.
> The columns
> do not match exactly so a table copy won't do much good. But the data
> retrieved in the select command is compatible with the new table
On Fri, Sep 21, 2001 at 01:43:32AM -0400, Will French wrote:
>
> Actually yes (if I read the documentation correctly - I have not
> tried this).
But if his ISP won't allow it, he can't do it.
Maybe I misunderstood.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Financ
Preface #1: Hi MySQL Admin!
There's an oddity at http://www.mysql.com/doc/. Entering my.cnf returns no
hits. Entering cnf returns all relevant hits.
Preface #2: Hi All!
Folks, this is the *best* online documentation I have ever ever seen. You
can save youself lotsa time waiting for replies here
on 9/21/01 12:43 AM, Will French at [EMAIL PROTECTED] wrote:
> Actually yes (if I read the documentation correctly - I have not tried
> this).
> In MySql Manual section "4.10.5 Replication Options in my.cnf", I find:
> binlog-do-db=database_name
> Tells the master it should log updates fo
nd exclude all others not explicitly mentioned.
(Example: binlog-do-db=some_database)
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 21, 2001 1:34 AM
> To: Christopher Raymond
> Cc: MySQL Mailing List
> Subje
On Thu, Sep 20, 2001 at 04:25:29PM -0500, Christopher Raymond wrote:
>
> Friends:
>
> My ISP does not enable update logging with their MySQL server. Is it
> possible for them or me to turn on update logging just for MY database(s)
> ???
No.
Jeremy
-
17 matches
Mail list logo
