For the majority of us who have grown accustomed to a Windows
environment over the years, Linux can seem like another world. In
essence, Linux is a free open-source operating
system that has gained increasing popularity since its release in
1991. Linux is based on the whole Unix ecosystem of operating
systems that grew out of Bell Laboratories in the early 1970s.
Linux has been around for almost 25 years and grew immensely in
the late 1990s and early 2000s when it became associated with the
LAMP web development stack; Linux stands for the ‘L’ in the
acronym of popular tools, along with Apache, MySQL, and
PHP/Perl/Python.

I will be speaking about MySQL at the Bulgarian Oracle Users
Group's Spring Conference.

In furthering my mission to increase the MySQL knowledge among my
countrymen I will try to give the grand tour of all the modern
MySQL administrative and development tools that the MySQL team
provides.

This will be the 3d BGOUG conference I'm speaking to. And I expect
no less than the stellar organization and the great audience that
I had the privilege to interact with during the previous 2
conferences.

Windows 7 User Access Control (UAC) issue fixed - When
running on Windows 7, the Windows UAC would prohibit MyQuery from
starting, complaining about registry access. For once, this was
not yet another UAC annoyance, but an actual bug that I hadn't
caught before. Now, this should work OK even on Windows 7.

SQL Statement normalization issues - The SQL Statements
dialog got statements wrong at times, and could cause a crash.
This was due to a bug in the normalization of SQL Statements and
this is now fixed, including refining the normalization a bit.

Optionally Show SQL SELECT tool output vertically - This will
turn the output from the SQL command in …

(NOTE: If you’ve come here from http://planet.mysql.com my
apologies. I’ve notified them to only follow my database related
posts and hope they’ll not follow my full blog feed shortly.) I
recently came across a new site which offers a GUI configuration
tool for FreeSWITCH. Despite buying the FreeSWITCH 1.0.6 Book
which is a very good [...]

I have not finished MyQuery
3.4.0, after a long time of weekend and spare-time
development. This version adds some features that are basically
Scintilla featires that I have integrated with. This includes
error indicators, margin markers and some other things. In
particular the margin markers changes a few things in the
interface: When running up to, or continue from a point in teh
script, then use the margin marker instead of the current line!
If you don't like this, then don't set the margin marker and the
current line will be used just like in old releases.

Another addition this release is Online help. I get the help
contents from the database that you connect to, which is
installed with most MySQL installations in the tables called
help_xxx in the mysql schema.

External program has a few more options, and in this release the
installer installs a …

I've been spending some cycles now and then on MyQuery 3.4. One
thing I wanted to do with this release was to fix some
long-standing bugs I knew about, but hadn't identified (Are you
seeing ReleaseSemaphore errors? That's one of them). Also, I had
a couple of issues with the new Plugins, as well as some ideas
for new features, such as OnLine Help.

In addition to that, I also felt that the Scintilla editor
controls tht I was using wasn't used to it's full
potential.

As I have the new 3.4 in front of me now, I have done something
about all those things. I have cleaned up some of the more recent
code, I have added OnLine help, in this case I get that from the
MySQL help tables. I am pretty happy with how a few more steps to
integration with Scintilla could add so much more usability,
Scintilla really is a great editor control with a lot of
potential, I haven't …

aka “How to use multiple MySQL Servers and Workbench in Snow
Leopard without using Terminal… and live happily ever after”

The MySQL Community is a world of command-line aficionados. Many
people, including myself, show their love to the
simple-but-powerful interface of the mysql command-line client,
but not everybody is keen to use a bash shell and give up its
GUI, no matter how powerful the software is.

Until recently, GUI tools for MySQL were half baked solutions: in
the end, there was always something that you had to do via the
command line. Today, you can install, set up and use MySQL on
your Mac with Snow Leopard without using Terminal, at all.

My Special Needs

Before digging into the details of the installation, let me
describe what I need on my Mac. I use various versions of MySQL
and I often need to run 2 or more instances at the same time. I
constantly build, install and uninstall versions of …

CMake is a family of tools designed to build, test and package
software. CMake is used to control the software compilation
process using simple platform and compiler independent
configuration files. CMake generates native makefiles and
workspaces that can be used in the compiler environment of your
choice.

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 Event Scheduler has been added only in
the 5.1 branch. In particular we will use MySQL® 5.1.24-rc. We
will also do some …

I've been playing with various GUIs off and on over the last
couple of months. I find that I drop to mysql.exe quite often no
matter which tool I use. My favorites until recently have been
the MySQL GUI Tools and NaviCat.

I was using the Lite edition of Navicat. I actually started using
navicat with postgres a few years ago. I like it
but the lite version is limited in some annoying ways. It's nice
in that it runs (at least the mysql version) in Linux and
windows. I don't use a mac so that doesn't really do anything for
me.

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.