[Rohit]

I think this is a webserver issue.

Are you able to access the tunneling URL from a browser?

[Rohit]

@DonQuichote:

Did you create the PHP page as a workaround because the Unicode features of SQLyog were not working as you had expected?

We really want to know if you are STILL not able to see data properly from your local server.

[Rohit]

With the current values of create_tmp_tables and create_tmp_disk_tables, MONyog should advice you to increase tmp_table_size and max_heap_table_size. It is not doing so?

[Rohit]

@Brashquido:

I just wanted to know if MONyog was already advising you on the Temporary Tables Tuning that Anand has suggested. If not, we have a bug in MONyog!

[Rohit]

I think we have to fine-tune the advisor for Key cache hit rate. Right now, if the key cache hit rate is below 99%, it advises you to increase the key_cache_size. We have to take other factors (like unused blocks) before coming up with the advice.

I will keep you updated.

[Rohit]

We have looked at the techniques used in http://forge.mysql.com/wiki/DebuggingStoredProcedures. However, we didnt find them very convenient for the end user – specially the requirement of editing the SP before debugging.

I will have a look at the other link in your post and get back soon!

[Rohit]

MySQL AB does not provide any debugging APIs at this point in time. Unless debugging support is provided by the server itself, SQLyog wont we able to set breakpoints, inspect variables, etc while the proc is getting executed.

Can you point me to some other tool that supports debugging of MySQL Stored Procs?

[Rohit]

Yes, only localhost connection is supported for the web-server.

We will allow remote access to the web-server after we build a robust authentication system.

[Rohit]

Thanks for the data.

We will analyze them and get back to you shortly.

[Rohit]

Yes, only manual structure sync is possible right now.

Automated structure sync is a *risky* business – we are not sure how many customers would be interested in this feature.

[Rohit]

Yes. You can cut and paste you scripts into the default scripts. A better way would be to add them in the separate file available for customization (mycounters.js).

We are buidling a sophisticated dev. environment to allow easy merge/integration of user defined counters/advisors.

[Rohit]

What is the hit rate of MyISAM Key Cache and Query cache?

[Rohit]

Well, this is a subjective issue. The 'default' MONyog installation considers the following as “good hit rates”:

MyISAM Key Cache > 99%

InnoDb Key Cache > 98%

Query Cache > 95%

MONyog will highlight if the hit rates are lower.

You can always change the defaults by going to Customize->Edit Builtincounters.js

[Rohit]

Yes, we are aware of it. Right now the port is “hard-coded” inside the program. Making this(and other params) configurable is high in our list.

[Rohit]

There is no built in support for proxies in mysqld. You will have to open up a port by some external means such as creating an SSH tunnel.

Additionally, the MySQL client library does not provide any option to access the underlying socket. This prevents us from developing our own proxy server support for SQLyog.

However, SQLyog HTTP tunnelling module *WORKS* over proxy server. So if you are able to connect to a HTTP server, you should be able to connect to MySQL as well.

[Author]

Posts