MYSQL :: Configuring MYSQL Enterprise Monitor

MySQL Enterprise And MySQL Monitor
I'm trying to figure out the actual benefits of the MySQL Enterprise subscription service, which includes MySQL Monitor, a so-called "Virtual DBA Assistant".

Has anyone used any of the four service levels of the MySQL Enterprise subscription service? The MySQL site has a lot of glossy marketing info and happy testimonials, but I'm still trying to determine if it makes sense for a small business (i.e., not a mega corporation) to invest anywhere from $695 to $4,9995 for the service.

Has anyone used MySQL Monitor? Does it live up to the claim of being a "Virtual DBA Assistant"?

MySQL Open Source And Enterprise
what is the main difference of the two... enterprise and open source

MySQL View Points From Enterprise DBAs
One of our companies clients has asked us about redoing one of their highly profitable web applications in PHP and MySQL (The had an outside consultant recommend it). Their current application is built in C#.NET and SQL and is not currently clustered or load-balanced. They want to rebuild it as they have learned a lot about what they want since the original design and they know they need to make significant changes to the application to get the new features they are after and also address functionality that their current customers don't like.

The company contacted the original .NET author (who also happens to be an experienced Microsoft SQL DBA) to see about redoing the applciation in PHP and MySQL and the author panned MySQL and stated that their own company had attempted to migrate one of their applications to MySQL and that from his perspectives there were many things that causes A GREAT DEAL of extra DBA overhead.

I was hoping that more experienced DBAs using MySQL would be able to confirm or deny some of the Microsoft SQL DBAs claims - I have never worked with anything except MySQL and I have not used it for very long or even very often, so I am unable to successfully evaluate the claims.

By no means do I want to get into 'down with Microsoft' thread here.

Here are his claims:You can not centralize stored procedures for multiple databases. If you do you have to open up a whole lot of permissions that expose the system too much?The use of stored procedures and triggers is really complicated and you have to get down to a very low level of coding to understand, create or edit them, which makes the DBA's job harder and even once experienced more time-consuming?It lacks quite a few advanced features that Microsoft SQL has (he didn't cite which ones)?The upgrade path (of MySQL) is not standardizes so features that worked in version x are not guaranteed to work in version x.5 or y?There is no standardized way to backup and restore the databases and between the different methods there is a lack of compatibility. This means that backing up a MySQL database in one way - say for example MySQLdump and trying to restore it using phpMyAdmin or the MySQL administrator will not work.For those of you that have worked with different Databases do you think that MySQL is as easy to administrate and update as other Databases and even more specifically Microsoft SQL?

Cannot Start New Install Of MySQL On RedHat Enterprise Linux
I've recently installed MySQL and PHP using YUM on a RedHat Enterprise Linux (RHEL 3) box. The output from rpm -ql | grep -i mysql shows the following are installed: Code:

How Do You Install MySQL 5.0 Server And Administrator On Red Hat Enterprise Linux 3 WS
Could someone point me to instructions for installing MySQL 5.0 server and administrator on a Red Hat Enterprise Linux 3 WS system?

I just freshly installed the system and deliberately did not select MySQL serveras part of the installation I downloaded the 5.0 rpm Community Server edition, and that installed fine. My problems came while trying to build the administrator.

Basically, I got caught up in a loop of incompatable modules:

# rpm -i mysql-3.23.58-16.RHEL3.1.i386.rpm
warning: mysql-3.23.58-16.RHEL3.1.i386.rpm: V3 DSA signature: NOKEY, key ID 025e513b
error: Failed dependencies:
perl-DBD-MySQL is needed by mysql-3.23.58-16.RHEL3.1
MySQL conflicts with mysql-3.23.58-16.RHEL3.1
Suggested resolutions:
/var/spool/up2date/perl-DBD-MySQL-2.1021-3.i386.rpm

If up2date the suggested resolution, it says I need a library from mysql-3.23.58-16.RHEL3.1.i386.rpm.

I will gladly read the "manual" or docs, and would love a pointer to them.

Configuring MySQL On Mac OS X
I recently tried to install MySQL on Mac OS X box using these instructions on the Mac site (http://developer.apple.com/internet/macosx/osdb.html). All was working fine until I got to this part here:

./configure --prefix=/usr/local/mysql --with-unix-socket-path=/usr/local/mysql/run/mysql_socket --with-mysqld-user=mysql --with-comment --with-debug

I got a bunch of "file not found" errors so I wanna trash whatever I did and start from scratch, but I don't know what exactly to delete? Does anyone have an idea about this?

Configuring MySQL
I have WindowsXP Proff. O/S. And I have installed mySQL ver 5.0.1
I have also installed php and Apache in it. Now I want to configure it
with Apache, PHP and I also want to configure with phpMyAdmin.
so I can use it comfortabley. So does anyone have an documentation
of it?

Configuring PHP And MySQL
I've installed Apache 2.0.59 [ C:Program FilesApache GroupApache2 ] and PHP 5.1.6 [C:PHP] successfully. I've tried test page also it works. I've also installed MySQL 5.0.24a successfully. But i couldn't connect PHP file with MySQL database. I've searched in google too but not getting please write for me or suggest me the best website which describe the installation process of the version i've mentioned above.

Configuring MYSQL 5.0
I downloaded MYSQL 5.0 and tried to configure it but I do get the message "Could not start service MYSQL : Error :0". if anyone can advice me what do or where to seek information to correct the problem.

MySQL Monitor?
I recently downloaded the latest stable release and once activated it
requested access to the net. Without access it would come up with
recognition and 'localhost' connection errors?

Can anyone please tell me:

1. What is the MySQL Monitor

2. Why this version needs internet access to it, and (if not [and even if]
benign)

3. Can I prevent it without causing errors

MySQL Monitor
A total Newby with, possibly, a daft question? However, until I can get a
reasonable explanation I am disinclined towards going further. Here goes:
I recently downloaded the latest stable release and once activated it
requested access to the net. Without access it would come up with
recognition and 'localhost' connection errors?
Can anyone please tell me:
1. What is the MySQL Monitor
2. Why this version needs internet access to it, and (if not [and even if]
benign)
3. Can I prevent it without causing errors
I have spoken to others using earlier versions who have not encountered this
particular problem.

Integrating Mysql, @mail, And Suse Linux Enterprise Server 9
I have recently received a admin job at a small web hosting company (small) and the current platform is windows and I will be responsible for creating a linux based platform and eventually moving all information over to linux form the windows setup.

The idea is like this run Suse Linux Enterprise Server 9 using 2 web server running apache, 2 email servers using @mail, and having 2 front end servers with 4 storage nodes clustered. This company also has some custom database query programs to retrieve information.

I might be in a tad over my head at this point, but that is ok there isnt an immediate rush on integration.

I am looking for any other admins that might be able to offer any opions regarding this basic setup or that might have this setup and offer any suggestions concerning the actual construction of this type of platform.

MySQL Enterprise Server With InnoDB For Mission-critical Data?
However recently the company I work for has the requirement to upgrade their database system. The data here really is mission-critical and we can't afford to loose any of it, and we need 24-7 uptime, with good performance (we have lots of clients so there'll be heavy load), any downtime will cost us.

What I'd like to hear is peoples own experiences with MySQL Enterprise, good or bad, and if it's up to the job.

Looking around the net I've seen lots of supposed expert DBAs saying that there's no argument; you should go with one of the "big 3", these being DB2, Oracle or MSSQL. However I get the feeling Oracle and DB2 would be a massive task to configure, and MSSQL - well it runs on Windows, we can't have any downtime no matter how good people say it is these days.

So my idea was; InnoDB on 3 servers - a master and 2 replication slaves, with one slave off-site down a 10Mb line (wide enough pipe?). We use the on-site slave to run our daily backups, and point our reporting web sites at it too. the off site is for worst-case scenario disaster recovery.

How much would we be better off spending more Â£ on one of the "big 3"? Would our data be safer on these? Would we get better performance with these? Is there a better model I could use for the MySQL setup?

Installing And Configuring MySQL
System: MAC 10.3.2 G4 workstation

For the past three weeks I am trying to do the "simple" install. But of course it never works the way it reads. I have followed the FAQ and install descriptions that came with the package <http://www.mysql.com/doc/en/Mac_OS_X_installation.html>
but i am stuck. At the moment I need to create a database and set the root password. i have no idea why it is not working. the following is the command line and error I am getting. Can someone please help me to install this properly?

Error Configuring Mysql?
I have installed MySQL CE 5.0, but during the configuration wizard I get an error.

It has frozen up during the final step (MySQL Server Instance
Configuration). I'm installing it on Windows XP, and I used all the
default settings, except that I changed "Detailed Configuration" to
"Standard Configuration". At the "Start Service" item in the checklist,
I got a 1045 error message saying to allow TCP port 3306. I tried
creating a rule for this in Norton, but it didn't seem to work.

So then I turned off Norton completely, restarted, tried the wizard, and
now it puts a red 'x' in the "Start service" checklist and says "The
service could not be stopped. Error: 0".

So I don't know if this is really a Norton/firewall issue or not. I
can't seem to get around this final step.

Configuring MySQL For JDBC ?
I'm having a MySQL DB running on one machine and a Java-Tool which accesses this DB via JDBC. With this tool, I can add a second DB data source in form of a mySQL DB and I've installed one more MySQL DB on a third machine, which runs perfect, but the access from the java-tool via JDBC-connection doesn't work.

Command line "mysql" tool work perfect from the machine where the java tool is running. The company which coded the java-tool told me that I have to install a package for the mysql db which enables jdbc. Is that right and what do I have to configure ?

Configuring/Setting Up MySQL 5
Im a complete newbie to mac os x. I downloaded and installed mySQL 5. I installed it and now i cant seem to connect. I have absolutely no idea what im doing. Im not familiar with os x termial commands. I need someone to email me and explain to me everything i need to do in order to create a user and successfully login using mySQL admin.

I've been struggling with this for over a week. Ready to pull my hair out. And please dont refer me to online resources, ive read them all and still cant figure it out. I need a professional who can give me a step by step process to get this going.

Configuring MySQL With Tomcat
I'm trying to configure Tomcat 4.0.1 with mySQL 1.3. I have copied the mySQL driver (mm.mysql-2.0.8-bin.jar) into tomcat/common/lib but I can't get a connection with the database. I can see the database and tables when I use the GUI for mySQL (winmysqladmin.exe). I'm running Win2K and java 2sdk1.4.1_06.

How To Backup/restore To Move Databases From One Server To Another (Win2k3 Enterprise, Mysql)
I'm trying to move a "schema" (I guess thats the term) aka database from our webserver2 to our webserver3. I backup the .sql file, and move it over to webserver3. I tell it to restore that file and create the database if it does not exist. Part way thru i get all these errors like: Code:

MySQL Client Crashes With Segmentation Fault On Red Hat Linux Enterprise IA64
I have an IA64 Red Hat Linux Enterprise Edition system and I tried to
install the binaries recommended on MySQL. However, when I run the
mysql client, I get simply:

Segmentation fault.

So I tried to do a basic source compile, which went fine, but when I
run mysql client, I get this:

Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 2 to server version: 4.1.12

Segmentation fault

When I try the flags recommended by MySQL
(--with-extra-charsets=complex among others), the make test fails on
ucs_binlog - something to do with charsets I believe?

The mysql user, group etc. are all set up. Strangely, the mysql client
works in batch mode so if you make a file that reads:
SHOW DATABASES;

Then type:
mysql < commandfile

It'll display
Database
mysql
test

Without any faults....

Anyone any ideas or suggestions?

Monitor / Tuning Of MYSQL
Can anyone tell me of documention/tutorials/software for monitoring and or tuning MYSQL databases. We currently run something called foglight (Quest Software) which tracks and monitors our Oracle Instances (sends us emails about things). I think we can code stuff to monitor the MYSQL databases that we are due to take over at some point, however I am not quite sure what to look for.

MySQL Monitor Access
I am having trouble connecting to the MuSQL monitor via Command prompt, every time i try to open the Monitor i get the following error

"ERROR 1045 (28000): Access denied for user `ODBC`@`localhost` (using password: NO) "

No i can use phpmyadmin to create a DB and I can access a DB via PHP but it won`t let me open the Monitor in Command Promt.

MySQL Performance Monitor
Wanting to do some performance testing of MySQL on my Windows 2003 Server, and was wondering if there was anyway to setup some basic MySQL performance counters to monitor and log in perfmon? Things like queries per second, connections, traffic, etc? Doesn't have to be a permon counter, just something that can log usage values to a CSV at one second intervals

Cygwin Xterm As `mysql` Monitor
I have used MySQL on linux before, but have installed to win32 (XPsp2)
for the first time (running from commandline, not as service). I
usually use cygwin xterm's on win32, as well as running other apps
(e.g. emacs) via cygwin X. After installing MySQL, I noticed I could
do the following in 2 xterm's: Code:

Software Rollout: Configuring Mysql Driver
When rolling out software that uses a mysql backend, how is it possible to configure the odbc driver for mysql during the installation process of the software?

Is there anyway to do this via command line, installshield, batch files..? What would one do if individuals were not "computer literate", and would not how to go about setting up the driver themselves or to make it easier, the software would automatically do it for them?

MySQL Monitor To Generate SQL Script For Table
Is there a way to get the mySQL monitor to generate the SQL script for the creation of a table? I'm kinda looking for the same thing SQL Server does to allow you to preview the SQL script for a table.

MySQL Monitor To Generate SQL Script To Create Table?
Is there a way to get the mySQL monitor to generate the SQL script for the creation of a table? I'm kinda looking for the same thing SQL Server does to allow you to preview the SQL script for a table.

Enterprise Manager
I'm looking for a GUI manager tool like MSSQL Enterprise Manager for MySQL (free, if possible). I'm using XP.
I'm especially interested in a GUI for creating views in which I can graphically manage INNER and OUTER join between objects
Does anyone know a tool like the one I just described in my dream

Crystal Enterprise Connection
I can connect Crystal Reports to MySQL via JDBC or ODBC. But I have trouble connecting MySQL to Crystal Enterprise. Is it possible to connect Enterprise to MySQL?

Which Version Is Enterprise Ready
Am I correct in assuming that the "Enterprise" production ready version of MySQL is version 5.0? If so, when is the 5.1 release going to be production ready?

Configuring MyODBC
I am using MyODBC 3.51 with Borland BDE, and was having a problem whereby Blob result fields were being restricted to a maximum size of 32k. Now, in the BDE control panel, I can set configuration variables for the MyODBC driver, and I was able to change the value of BLOB SIZE from 32 to 128, which solved the problem. However, there are many other configuration variables there (TRACE MODE, BATCH COUNT, BLOBS TO CACHE, ENABLE SCHEMA CACHE, ROWSET SIZE, etc.) for which I have not been able to find any documentation. Does anybody know where I can find documentation for these settings?

Configuring A New Server
while configuring a new server instance the following error message is throwed:

" The template configuration file cannot be found at C:programFilesMySQLMySQL Server 4.1inmy-templates.cnf "

Configuring On Win98
Win98 , Apache 2.0, Apache running on port 443 is that matters.
Latest version (community) of mysql, 5 i think.
Have run the msi file and installed mysql. Wasn't promted for a username / password during this , not sure if thats right, maybe only on win2000/xp?
I'm stuck as what to do next.
cd'ed to mysql....in and ran mysql.exe and gives me the error,
cant connect to mysql server on localhost 10061.

How Can I Log Or Monitor The Query!
I want to log or minitor the query that commit to NySQL server, and have format like this: whois, IP or Hostname, Time, Query. What I need to do?

Logging In To Monitor Thru Dos
I am playing around with logging in and running commands through batch files on a win2000 machine running mysql, I have a password on my db, I am using mysql -h localhost -u root -p
to start up the monitor this works, but it asks for a password which kind of kills the automated part of what I am wanting to do, is there a way to include the password on this command? I thought about passing the password using %1, but I haven't done dos in so long that I dont even know if this feature still works, does anybody?

Monitor A Table For Any Changes
how can I monitor a table for any changes that have occurred to it? Ive considered watching 'CHECKSUM TABLE table' for a change, and then checking the table, but that still requres checking the entire table for the actual change.

Big Problem With Monitor
The majority of my problems come down to this:

whenever I change a user's password in the mysql monitor, via...

mysqladmin -u root -p password 'newpass'

...it fails. It accepts the argument as expected, but any time after that I have to use the root password it fails to connect. whether I try the old password or the new one, it seems I'm locked out. why is the change password command setting it to something unbeknown to me?

Database Monitor
I am trying to write an application which will run on a web server which will monitor a table in my MySQL database. If there are entries in this table, then try to service those entries. Keep checking every 5 seconds or so to see if there are any entries which need to be serviced.
I'm pretty new to web development so I'm not sure how to set this up and how the "monitor" application would run. What is the preferred method of approaching this sort of problem? I need to make sure that this application is running all the time, so how can I ensure this? The web page is mainly comprised of php code with some javascript. Would I need a Java program or a per script running on the server to do this?

Monitor Disappears
I have just installed MySQL and when i double click mysql.exe the monitor appears for a split second and disappears. There is no welcome message

Monitor Newlines
Does anyone here work with the command line on win xp? The thing is it's easier for me to read/write commands when creating a newline, though if I notice a typo I don't know how to get back to the line I want to fix which is a frustrating thing.

Monitor Every SQL Query
How To monitor every SQL query that hits the database?
(something like Log files).
So i can record ever query, so i can see it or manipulate that log files.
is any internal utility in mysql can do that with automaticly ?

Configuring The Service In Each Start Up?
A couple of weeks ago I posted several questions in one post, and I think I overwhelmed people, so I'm breaking it into individual questions this time.

I don't know why but everytime I use MySQL I need to reconfigure the server using the wizard(I go to start>programs>mysql>MySQL server 4.1>MySQL service instance config wizard) everytime I turn my computer on. If I don't, I get a "ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)" error when trying to connect to the server in any account. I don't have to change anything when I run the wizard, I just click next all the way, and when its done I can connect normally.

I've noticed that at the end of the configuration when its running through all the tasks, the last one says "Sart service". I'm guessing that I'm not starting the mysql service when I turn my computer on, and that reconfiguring the service solves the problem because it starts the service for me. Do I have to reconfigure the service everytime I want to use it? Is there another way or maybe start the service automatically?

Configuring XAMPP In The Domain
I am installing my XAMPP in my pc.

It works fine. Everything works. My question is, is it possible to install XAMPP inside in my domain e.g., www.mydomain.com/xampp. Please help me to configure it using the domain, not in the localhost.

Configuring Database Server
tell me a way to increase the productivity of a database server. It has nothing else installed other than the newest production version of mysql and the default packages from FreeBSD.

Is there a toaster than can bring me up to speed.

Error Configuring PhpMyAdmin
I'm trying to install phpMyAdmin on a test server. I am using the GUI to create the configuration script.I would like to use HTTP mothod for authentication. As the guide says, I need to create a user and grant some privileges to the user. Here is the problem.
mysql -u root -p
INSERT INTO `user` (Host, User, Password) VALUES('localhost','pma',PASSWORD('something'));
Next I try to grant privileges, but receive an error:

GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'something';

Error 1133 (42000) Can't find any matching row in the user table.
Now I know the user is there...If I do

SELECT * FROM `user` WHERE User='pma';

I get results, 1 row in set. The password is encrypted, but I did double check with the original user creation line and it is the same and typed in correctly. localhost is also there.So why is it not finding any user when I want to grant privileges?