Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 5

Displaying posts with tag: mysql gui (reset)

MySQL search database | MySQL search all tables
+8 Vote Up -0Vote Down

“What will you do if one day some one ask you to find single string in all databases, all tables and in all columns?”

– This was asked to me once. There is some string in the database but I do not know where. There was a task to find an user’s details which is in the database which consists of many tables. And all I know is only the user name and do not know any other details. How am I supposed to find that string? I do not want to write some complex SQL for this. Digging more into this, I came across few GUI tools for MySQL which have good search feature.

So I am writing this blog about search feature in those tools. I shortlisted three client application for MySQL:

1) SQLyog

2) phpMyAdmin

3)

  [Read more...]
HoneyMonitor v.1.0.16-beta released!
+0 Vote Up -0Vote Down

We are pleased to announce the release 1.0.16 of HoneyMonitor, our GUI for MySQL™ administration and monitoring.

In this release, available for immediate download, we have fixed many bugs and included several improvements.

We are working to release a RC version as soon as possible.

The following is the list of changes:

  • New Features:
    • new Tab “Defaults Folders” in the “HoneyMonitor Options” Window to set the default
  [Read more...]
Step by Step Guide on How to Create a Customized Performance Report using HoneyMonitor
+0 Vote Up -0Vote Down

Reading this article you will learn how to create a Customized Performance Report for one of your MySQL™ Servers using HoneyMonitor, a GUI for MySQL™ Server Administration, Monitoring & Performance Tuning.

Contents

  • Introduction
  • Step 1 - Choosing a File Name and Opening the Report Designer
  • Step 2 - Editing the SQL Queries used by the Report
  • Step 3 - Editing the Charts contained in the Report
    • Axis
  [Read more...]
Performance Monitoring, Tuning & Auditing in MySQL® 5.1 - A GUI Approach - PART 1
+0 Vote Up -0Vote Down

Revision: 8 - Last Update: September 03 2008

This is the first part of a series of short articles with a how-to approach about MySQL® Performance Monitoring, Tuning & Auditing. We will see the question from a GUI prospective. In particular we will describe which monitoring-oriented features HoneyMonitor, a GUI for MySQL® currently in alpha development, implements.

I will explain how HoneyMonitor let you

  • install an audit database on your server, without the need of using 3th Party Agents nor using remote repository databases
  • enable the auditing and start monitoring your server
  • tuning your server changing a few suggested list of variables to get better performance.
  • We will use only the 5.1.x series of the Server as we use some Scheduled Events and the

      [Read more...]
    HoneyMonitor Pro and Audit Pro Editions v.1.0.13-alpha released!
    +0 Vote Up -0Vote Down
    [HoneyMonitor is a MySQLTM GUI Tool for WindowsTM Systems. Server Administration, Database and Database Objects Administration, Code Development, Server Monitoring, Performance Monitoring, Performance Auditing. Read more on http://www.honeysoftware.com]

    We are pleased to announce the availability of HoneyMonitor Pro and HoneyMonitor Audit Pro!

    Press Release available at:
    http://www.honeysoftware.com/news/pressreleases/20080714-honeymonitor-performance-tuning.php.

     


      [Read more...]
    Showing entries 1 to 5

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.