Blog

Monyog Custom Counters – overcoming a problem.

In this previous Blog I described an example on how to build a Custom Object in MONyog. But there is one problem you may encounter and that is, that...

Log security and log tables.

by Ritesh

Accidentially I came across the statement "SHOW GRANTS requires the SELECT privilege for the mysql database." in MySQL documentation...

Java 6u29 bug prevents SSL connection to SQL Server 2008 R2

by Niels Gron

In Java 6u29, there was a bug introduced which prevented SSL connections to SQL Server 2008 R2. This bug was logged with Oracle as Bug ID: 7103725...

How to add a simple Custom Object in Monyog

by Ritesh

MySQL is developing rapidly. And today it does not only happen along a single track but in multiple directions simultaneously. This is due to both...

How to Make a Copy of a Database on Windows Azure SQL Database

by Liz Stephens

Windows Azure SQL Database (previously SQL Azure) offers a unique way to make a database copy to another database using the CREATE DATABASE as COPY...

Per-database information in performance_schema, please!

by Ritesh

This is a follow-up om my first Blog on performance_schema that appeared here: One particular request that we had frequently from our users is to...

FLUSH STATUS surprise?

by Ritesh

What does FLUSH STATUS do? We all know that it will simply reset all status variables (except for 'uptime') to same values as immediately...

Performance_schema considerations.

by Ritesh

I have for the first time been spending some time trying to understand the performance_schema. It is not easy to understand everything unless you...

Setting per-server thresholds in Monyog.

by Ritesh

Please note that this blog was updated on April 5th 2012. We have added(at the buttom) how to use server TAGS for defining thresholds....

Why does selecting a file in the filechooser on OSX not select the file extension with the full file name?

by Niels Gron

I run the Import Tool, and click browse to select a file to import. When I select one of my files, which has a .CSV extension, the full file name is...

I get the warning “Server returned invalid line number (0)” when debugging a Sybase procedure, am I doing something wrong?

by Niels Gron

I am not sure why I am getting the warning "Server returned invalid line number (0)" when debugging Sybase stored procedures. Response Niels Gron...

Why are certains operations of Aqua Data Studio very slow with MySQL?

by Niels Gron

I have a server registration to MySQL and other databases. When I execute queries in the Query Window for MySQL they are fast. But If I try to...

Why isn’t there a Procedure Editor for MySQL like there is for the other database vendors?

by Niels Gron

I can right mouse click on a procedure in Oracle, DB2 and SQL Server and choose the "Edit in Procedure Editor", but in MySQL this option doesn't...

Aqua Data Studio is crashing, not responding, or showing other signs of unstable behavior. What do I do?

by Tariq Rahiman

Aqua Data Studio is crashing, not responding, or showing other signs of unstable behavior. Response Jonathan Powers over 11 years ago Unstable...

How can I backup Aqua Data Studio settings and server connections, or move them from one computer to another?

by Tariq Rahiman

How can I backup Aqua Data Studio settings and server connections, or move them from one computer to another? Response Jonathan Powers over 11 years...

Scripts with multiple statements return errors. Some database commands or symbols do not work in Aqua Data Studio while they do work in the database vendor’s command line tool.

by Tariq Rahiman

Scripts with multiple statements return errors. Some database commands or symbols (such as “;”) do not work in Aqua Data Studio while they do work...

Aqua Data Studio is running out of memory. How do I increase it?

by Tariq Rahiman

Aqua Data Studio is running out of memory. How do I increase it? Response Jonathan Powers over 11 years ago Memory Allocation in Aqua Data Studio If...

Aqua Data Studio gets disconnected after a certain period of time.

by Tariq Rahiman

Aqua Data Studio gets disconnected after a certain period of time. Response Tariq Rahiman over 11 years ago Timeouts: ADS periodically gets...

How do I connect to PostgreSQL using SSL and my personally created certificate

by Niels Gron

I want to connect to my PostgreSQL server using SSL. I've created a certificate on my PostgreSQL server, but I can't configure Aqua Data Studio to...

How do I connect to Teradata with LDAP?

by Niels Gron

How do I connect to Teradata with LDAP authentication using Aqua Data Studio? Response Niels Gron over 11 years ago The authentication mechanism for...