Forum Replies Created
-
AuthorPosts
-
Manoj
MemberHi,
Make sure in SQLyog preferences “Generate Queries Using BackQuote” is ticked!
MemberHi,
I imported the dump attached to two databases and structure sync tool reports both are same!
SQLyog: v6.12 RC
MySQL : v5.0.28-enterprise-nt-log
Screen shot attached
MemberHi,
By default MONyog will filter ''SHOW FULL PROCESSLIST' for queries and queries which are not like ''SHOW FULL PROCESSLIST'. You can change this by using 'Change Filter' option. If you click 'Change Filter' you can see the filter is set to
SELECT *
FROM processlist
WHERE Command = 'Query'
AND info <> 'SHOW FULL PROCESSLIST'
ORDER BY time DESC
you can replace this filter with the fiollowing
SELECT *
FROM processlist
ORDER BY time DESC
it will display all threads.
MemberBug confirmed in 6.1 Beta 1. We will include the fix in 6.1 Beta 2.
Thanks for reporting this issue.
MemberThis issue is fixed in MONyog 1.1 development tree. Now MONyog will take care this situation.
MemberHello,
Thanks for trying MONyog.
First I will tell you Slave_running is not a value exposed by SHOW SLAVE STATUS, it is exposed by SHOW STATUS, so you need to use “MONyog.MySQL.GlobalStatus.Slave_running”.
Following is the full dashboard implementation of Slave Running…
obj = {
Caption : “Slave Status”,
SeriesCaption : [“Running”, “Stopped”],
SeriesValues : [MONyog.MySQL.GlobalStatus.Slave_running == “ON”?1:””, MONyog.MySQL.GlobalStatus.Slave_running == “ON”?””:1],
ChartType : “Line”,
YAxisType : “OnOff”,
ChartValue: “Current”
};
_DASHBOARD_MYSQL_COUNTERS.push(obj);
The extra property that you need to add other than the properties used in Availability graph is “ChartValue”. This is required because all the current dashboard graphs are plotted on Delta context values(Difference b/w last two capture), Availability is a custom value and it will have valid value in all context( Alltime/Current, Delta, Default Timeframe as well as Custom Timeframe), but here “Slave_running ” is not a custom value and it won't have a valid value in Delta context. So we need to tell explicitly to use Current context. This is not documented in Help and we will add this also in the next release. Once again thanks for reporting.
The possible values for ChartValue is “Current” / “Latest”
MemberHi,
This is a SQLyog question, not a MONyog question. Please post in the correct category.
SQLyog supports executing the query by placing the cursor anywhere(even after semicolon) in the editor if you have only one query, otherwise you need to keep the cursor inside the query which you want to execute!
MemberHi,
SQLyog uses only one query thread for each connection, and different connections operate indepedently.
MemberHi,
Some coloring improvements are done in the 6.05 development tree(SINGLE QUOTE(') b/w two BACK QUOTE(`)).
We will consider this after 6.05 releases.
Memberhi,
If you want to automate the CSV import through ODBC you need make sure that the csv file contains the column names as the first row. The Odbc driver expects the first row as the fieldnames. So your first data row is mapped as column name here.
MemberMemberHi,
The workaround for this now is you can add your template to SQLyog's favorites.
Memberhi,
Thanks for reporting this issue.
Plz try to add (not EDIT)one/two more connections to the same 5.1.18 and check whether it is showing correctly. We had similar internal reports and we are working on this issue.
MemberHello,
Bug confirmed. This issue will be fixed in the next release.
-
AuthorPosts
