[Kartik Grover]

Hi

 

Please share the dump file here and we will look into it. 

 

Regards

Kartik

[Kartik Grover]

Hi

 

Well it seems to work fine for us, anyways can you please share the job file(XML file) so that we can look into it.

 

Regards

Kartik

[Kartik Grover]

Hi

 

MONyog’s counter Percentage of full table scans in the Index Usage monitor returns the percentage of the rows accessed via full table scan, the formula for which is as follows:

(Handler_read_rnd_next + Handler_read_rnd) / (Handler_read_rnd_next + Handler_read_rnd + Handler_read_first + Handler_read_next + Handler_read_key + Handler_read_prev)

These values can be obtained from the MySQL server using a simple SHOW GLOBAL STATUS LIKE “%handler%” query. MONyog only reflects the information retrieved from the handler status variables. If you are using MySQL version 5.6.14 or greater then you can enable Custom SQL Object(CSO) in MONyog which will query the performance_schema database to monitor the full table scan. For more details on this please visit: http://www.markleith.co.uk/2012/07/04/mysql-performance-schema-statement-digests/.

 

The Monitors that you see in MONyog cannot give you such information. They give the values from Status Variables that do not fetch such information. For a full table scan and the relevant query details you can view the Query Analyser. The queries that may cause a problem or may trigger an alert situation would be slow queries, and that can be seen in the query analyser.

 

Same goes for the details of the table_cache. It is what the status variable opened_tables fetch.  There is no option in MySQL to provide you the details of the opened tables. It also depends on the number of max_connections at a time.

 

Regards

Kartik

[Kartik Grover]

Hi

 

Can you please tell what are the exact queries and the syntax that you enter in SQLyog. Also please explain the steps that you follow while writing those queries when the error occurs. Give us some screenshots so that we can look into it.

 

Regards 

[Kartik Grover]

Hi

 

This issue is reproducible. Thank you for reporting it. We will fix it.

 

Thanks and Regards

Kartik

[Kartik Grover]

The filename would be connrestore_backup.ysav. (C:Users{user}AppDataRoamingSQLyogconnrestore_backup.ysav)

[Kartik Grover]

Hi

 

The Schema sync tool picks up the source and target from the list that is in the Object Browser of SQLyog. Here as you can see the names of the databases are reflected in the schema sync tool. But since the error is returned by the MySQL server that the database is unknown, that means when Schema sync tool fires a query and connects to the server, at that time the server returns the error that the database is unknown. This could happen in case there is any other script running at the back end which may by temporarily deleting the database and then again updating it. 

 

So can you please check if there is any scheduled job or other script that may be running at the back end which may be causing this. Also please tell if this error is always caused the first time you do a sync.

 

Regards

[Kartik Grover]

Hi 

 

Thank you for the help. We will look into it and get back to you asap. 🙂

 

Regards

[Kartik Grover]

Hi 

 

The main thing about ClustrixDB is that it speaks MySQL syntax, but was built from the ground up to be a distributed shared-nothing database and has no MySQL code in its code base.  Any application that uses a MySQL client or JDBC/ODBC drivers, like SQLyog in our case, can connect to ClustrixDB without issue and use standard MySQL constructs to interact with ClustrixDB but many functionalities cannot be accessed as they are in MySQL. SQLyog is built only to support MySQL. Many functionalities that it support in Clustrix is because Clustrix is a lot like MySQL. We have no plans to give a full out support for Clustrix. 

 

Regards

Kartik

[Kartik Grover]

Hi 

 

Sorry but we are unable to reproduce this in our environment. Can you provide us with a test case? Schema structure of the source and target will help us largely if sharing it is not a problem.  

 

Regards

Kartik

[Kartik Grover]

Hi

 

Please see this article in the above link given earlier.. You will find all the details to create a new DSN here..>> 

http://sqlyogkb.webyog.com/article/275-new-odbc-dsn-data-source-name

 

Regards

[Kartik Grover]

Hi

 

With SQLyog you don’t need to it by programming code. You just need to follow some simple steps which involve selecting the the correct options and clicking some buttons.. 😉 You can read all about the import external data tool here..> http://sqlyogkb.webyog.com/category/270-import-external-data.

 

Regards

[Kartik Grover]

Hi

 

We are not able to reproduce this error on our end. The import from excel works fine. So to help you we would need some part of your data to check if its something with the excel file that you are trying to import. Can you share that or some part of it?

[Kartik Grover]

Hi

 

Sorry but such ER Diagrams cannot be made using SQLyog. You can design schemas if you want, SQLyog has a powerful schema designer for that.

[Kartik Grover]

Hi

 

This is strange. Please send us the result of SHOW CREATE TABLE.

 

Regards

[Author]

Posts