[rrkramer]

Anyone have any thoughts?

Richard

[rrkramer]

More info – it seems that sometimes the timer works, sort of.

I ran the two queries with two limits below against databases on two machines and two table in each database.

Machine A is on a local lan, 100 BaseT connecection, but the db server is old and slow.

Machine B is over the internet, 15 hops, average ping ~50 ms, max about 400 ms over a 5 minute span.

Table 1 consists of 3 columns, average length 44 bytes.

Table 2 consists of 62 columns, average length 527 bytes.

The “?” in the queries below represent the two tables and two limit options.

Query A:

SELECT LEFT(xxx,3) as s,COUNT(*) FROM table? GROUP BY s LIMIT ?;

Query B:

SELECT * FROM table? WHERE yyy=”” ORDER BY xxx DESC LIMIT ?;

The two limits were 10 and 1000.

Code:

Machine A Machine B
Query Table Limit MySql(secs) SQLyog (ms) MySql(secs) SQLyog (ms)
A 1 10 1.88 0 0.25 0
A 1 1000 0.89 0 0.27 0
A 2 10 0.28 0 0.20 0
A 2 1000 0.30 0 0.20 0
B 1 10 1.80 0 0.46 0
B 1 1000 1.81 0 0.47 406
B 2 10 0.73 0 0.48 0
B 2 1000 0.87 110 0.59 1547

So one conclusion is that the SQLyog timer results are not strongly related to either the mysql reported times, nor the wall clock times. The timer data seems most strongly related to the amount of data returned.

Richard

[rrkramer]

Ritesh wrote on Aug 18 2005, 05:12 PM:

Are you talking about the contents of the HISTORY TAB?

If yes then there is no way to save it from the GUI. You will need to cut-n-paste from SQLyog to a text editor like Notepad and save it.

[post=”6901″]<{POST_SNAPBACK}>[/post]

OK. There are a few times in the past year that it would have been handy to have a copy of the log from a prior day. When you are bored or looking for work, perhaps? 🙂

[rrkramer]

Yes, MySql is version 3.23, and SHOW WARNINGS produces the same error.

Problem solved.

[rrkramer]

peterlaursen wrote on Aug 1 2005, 05:49 PM:

http://www.webyog.com/forums/index.php?showtopic=1543

A major change took place with 4.05 with the editable resultpane (that in particular is extremely useful with multitable queries).  Unfortunately the sorting functionality with columnheaders in the resultpane was lost then.

You wil have to include an “order by” in your query instead.

[post=”6669″]<{POST_SNAPBACK}>[/post]

Has the ability to select one or more rows (to copy to the clipboard) also been dispensed with?

[rrkramer]

>What is MySql 4.23?

The old off by 1.00? (3.23, in fact)

Thanks,

Richard

[rrkramer]

OK, this MySQL 4.23, but how do I get hold of 3.7?

[Author]

Posts