Smart-MySQL Quick Start

What is SmartMYSQL?

SmartMySQL is a next-generation GUI tool for the RDBMS MySQL. It  has unique advanced features help to Speed up SQL and PL/SQL development time, Optimize slow query and recommends optimal indexes and Debugs Production MySQL problems and provides fixes.

you can download smartmysql from download link

Download SmartMySQL

SmartMySQL Features

Key Features (Only available in SmartMySQL tool  for Quick Demo )

  • Query Optimizer: recommends the best indexes for slow and long-running queries and improve over 100 times performance.  Demo
  • Advance query browser: Saves more than 10 times SQL and PL/SQL development time (with the following features).  Demo
  • Query Constructor: Simple drag and drop the tables into the Smart query browser, then it generates SELECT Query with JOIN Condition.( An advance version of Query builder Demo)
  • Syntax Error Highlighter: Points out syntax error as an error icon in the tool and highlighted the specific location of the error in the query with the red background color. Demo
  • Smart Auto-Complete: You can reuse historical queries, Frequently executing queries, Favourite queries, Query snippets with shortcut keys Ctrl+Shift+H/Q/F.  Demo
  • SP Code generator: Generate Stored procedure code with the cursor query. Also, it works for Functions, Triggers, Views, and Events. Demo
  • Visual Explain: SmartMySQL provides all of EXPLAIN formats for executed queries including the raw extended JSON, traditional format, and visual query plan
  • Query Formatter: Beautifies SQL statements instantly and converts code into well-formatted SQL script for easy understandable.
  • Lock-Free Execution option: helps to avoid query locking while running queries from the Query Browser.
  • Slow Query log file analyser: is a GUI and an alternative tool for “mysqldumpslow” and “pt-query-digest” command line utilities and has many advanced features and Integrated query optimization and Query visual explain helps to fine-tune Slow Queries on the dashboard. Demo
  • MySQL Production Debugger: Equipped with a refined debugging module, the SmartMySQL is the first of its kind in suggesting real-time solutions to problems encountered during database production. You can debug and fix many of MySQL server production problems using this without specialist level DB engineer knowledge. Demo
  • Dead Lock Debugger: can cope with deadlocks and reduce the probability of their occurrence with the technique to add well-chosen indexes to tables. Then your queries need to scan fewer index records and consequently set fewer locks. Demo
  • Long Running Queries debugger: displays all long-running queries with a rich user interface and integrated with query optimizer, helps to optimize by Developers, Programmers, OS and DB Administrators with our without DB performance specialist skills. Demo
  • Long Running Transaction debugger: debugs long-running Transactions and uncommitted transaction, and Transaction locking problems on Live DB servers Demo
  • Queries Locking debugger: exhibits opulent reports with color denotements with details of which queries are waiting and locked by others, with queries are causing other queries to be a lock. Demo
  • Replication lagging and broken issues debugger: debugs MySQL replication lagging issues and broken replication issues and fix them. Demo
  • Too-Many Connection Debugger: gives detailed graphs about which hosts, which users are opening too many DB connections. Demo
  • DB Speedometer: Shows details graphs about how the DB load and Which SQL commands are executing with execution Rate. Demo
  • InnoDB Engine Monitoring
  • MyISAM Engine Monitoring
  • Foreign key error Debugger: displays recent Foreign key error.
  • Open files monitoring: displays all open files list
  • Duplicate index and Unused indexes detailed reports.
  • The SmartMySQL Error Log Analyzer able to read the MySQL error log file and analyze the error log details. It recognizes MySQL errors from the error log and shows them in a Marxist color text. Integrated popular search engines like Google, Yahoo, Bing, and StackOverflow with errors and helps to start research on the problem expeditiously.
  • The SmartMySQLProfiler Provides point-in-time visibility and historical trending of database performance that enables database administrations and application developers to optimize the performance of their MySQL databases.

Basic Features

  • 64/32 bit software's are available In All Windows/ MAC / Ubuntu operating system.  
  • Editor with syntax highlighting and various automatic formatting options.
  • Intelligent Join condition generator and  Code Completion.
  • Simplifies Data manipulations (INSERT, UPDATE, DELETE) on Table just like excel
  • Visual Schema Designer.
  • Visual Query Builder.
  • Query Formatter.
  • Backups and Experts.
  • Smart SQL Scheduler and Reporting Tool is a tool for scheduling and automating execution of any  SQL statements and  result of queries may be sent as HTML-formatted reports to configured email
  • Schema/Structure Synchronization
  • Query Profile,  Unused index and duplicate Index Finder.
  • Allows to scheduled SQL Code and received result set to your email.
  • There is option for all automated jobs have mail alerting and reporting options.

 

Platforms 

SmartMySQL works on the Windows platform starting from Windows XP to Windows 10 . It has also been made to work under MAC, Linux and various Unix’s OS. Further a subset of MySQL Workbench or SQLyog Enterprise/Ultimate functionalities are available with the free version. SmartMySQL makes MySQL smarter.

SmartMySQL Installation

SmartMySQL Installation

  1. Download SmartMySQL from  Download Page. Execute it and follow the steps to install the program
  2. Register user’s details in SmartMySQL and it needed to enter your login details to start the application.
  3. You will receive a confirmation email from SmartMySQL for validation. Your account will be activated after click the email validation link. 
  4. Execute the setup program in Windows and MAC.
  5. In Ubuntu (Linux) OS run the following command (without sudo)

    #sh SmartMySQLQB_64.sh

  6. Read and Agree on SmartMySQL terms and conditions and Choose the default options except when specified.

Prerequisites

  1. Operating System : Windows  / MAC / Ubuntu (Linux)
  2. System Requirements: Minimum 4 GB RAM

Connect to DB server:

Once you start SmartMySQL, you will get a figure as shown below. You need to enter your SmartMySQL email and password. It is a one-time program.

 

After your authentication, you will get a figure as shown below to connect to the MySQL server.

 

Connect to MySQL DB Server

Connect to DB

You need to connect to MySQL server in SmartMySQL connection window before you will perform any activities. You can connect to the MySQL server in the following ways.

  • Select  File->Connection->New connection using current settings(or press CTRL+N)  to open the same server of the current server without any details.
  • Select  File->Connection->New connection (or press CTRL+M)   it will open connection window. Click on connect to new MySQL server button once enter all server details.
  • Select File->Modify->Disconnect(or press CTRL+F4)  to close the current connection.
  • Select File->Modify->Disconnect All to disconnect to close the all open connections.

SmartMySQL gives you a choice between two different connectivity options allow you to smartly manage your MySQL Server(s). 

  • Direct connection: This is the fastest way to connect and manage your MySQL server. This is the preferred method if you are not concerned about your MySQL traffic being spoofed. However, this requires direct access to your MySQL server.
  • SSH Tunneling: Peoples Use this option if they want to encrypt the contents of your MySQL traffic and host supports SSH tunneling, SmartMySQL can use the tunnel to communicate with MySQL.

SmartMySQL is next generation MySQL tool if you need to monitor your MySQL's OS and then you can enter DB server OS details.  Also, it can directly pull slow queries log and Error logs details if you provide details and analyze and summarize them.  It supports Linux OS and local windows servers.

In advance, tab can allow users to change connection settings

  • New- If you want to add a new connection then client NEW button, In the name field type the name of the connection by which you will recognize the DB connection. By default, SmartMySQL will create an instance name with default values  Ex. localhost, root.
  • Save- It saves all recent changes in connection settings.
  • Delete- 
    Delete the currently selected connection. It needs your confirmation before Delete.
  • Rename- "Rename" button to rename a DB connection. 

SmartMySQL User Interface

After you have established a connection with SmartMySQL you will get a window like 

Title Bar

It shows the connection name and the database host name of the current connection.

Menu Bar:

All SmartMySQL features are listed in the menu bar e.g query execution, Query Optimization, PL/SQL code generator.

DB Object Browser

SmartMySQL builds tree Structure with all DB objects. If you open database you can see all tables, Views, Stored Procs, Triggers and Events. It also constructs an ER diagram for each database and it will be visible in the diagram.

SQL Window

In these Windows allow you to write SQL queries and it can identify syntax errors, slow queries. 

 

Result Window

Result Window display query result set. Also, it can display query profile, Visual Explain, inline table edit options and many more. 

Session Restore

SmartMySQL has the ability to save database sessions savepint and It can able open connections from the savepoint to the same state as when the savepoint was generated.

With the term "database session" we understand the sum of all open connections as well as all Query tables opened in every connection as well the History tab and Frequently Execute Queries(FEQ)  for every connection. 

1) The automatic way

SmartMySQL will restore your previous session along with all the query tabs , history tab and FEQ. The way you left it. This option can be found in  Tools > Preferences > Others > Restore session on startup.

 

2) The user-managed way

Open Session Savepoint:  used to open a saved session.

Save Session: Save the current session.

Save Session As: Save in a different file name.

End session: Session will be ended