Configuring MYSQL Enterprise Monitor
I was given the setup files for configuring the MYSQL Enterprise Monitor with dashboard for testing in Local.
1. I have installed MYSQL Server to my localhost [Windows].
MYSQL SERVER Version: 5.0.50sp1a-enterprise-gpl-nt.
2. I have installed the MYSQL Network Monitor to my local system [Windows]
With all options like admin login, agent and other details.
But my doubt is how to set my MYSQL DB Server for regular monitoring using the MYSQL Enterprise Monitor.
I.e I just want to know about the Server setting like how to add my localhost server to the Mysql Enterprise Monitor.
We have a Enterprise Subscription but as iam just a developer i dont have the login id so can i get help from here?
View Complete Forum Thread with Replies
Related Forum Messages:
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"?
View Replies !
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.
View Replies !
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?
View Replies !
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.
View Replies !
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?
View Replies !
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?
View Replies !
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.
View Replies !
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.
View Replies !
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.
View Replies !
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 ?
View Replies !
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.
View Replies !
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
View Replies !
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.
View Replies !
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?
View Replies !
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.
View Replies !
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
View Replies !
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.
View Replies !
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.
View Replies !
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?
View Replies !
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:
View Replies !
How About A Google Desktop Gadget To Monitor MySQL?
I run a small windows MySQL server for the office that has about 10 users. I've set up a Samurize configuration to monitor CPU, Memory and Disk stress levels on the server,but I'm missing a few graphics to monitor MySQL load and throughput. There is no gadget already to do that, I suppose it is an "easy" task for real programmers to develop a little gadget to query the server on it's health.
View Replies !
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
View Replies !
Community To Enterprise Upgrade Path
We are a start-up business which has decided to use MySQL Community version but as we grow we dread the thought of redoing everything when we are ready for the Enterprise version. Is/will there be a utility/program that will simplify this process?
View Replies !
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.
View Replies !
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 "
View Replies !
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.
View Replies !
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?
View Replies !
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.
View Replies !
Configuring Script For Mbstring And Pconnect
i was told i need to "configure your script to use pconnect (persistent connections) to the mysql database.". because "Your site is creating too many concurrent connections (20 is a reasonable limit).". as well i need to figure out how to add the mbstring function on mysql, so that my pages with special characters (french characters), will load up properly.
View Replies !
Configuring Security For Stored Procedures
I have a test DB with 4 tables. I also have around 20 Stored Procedures that manipulate these tables. My test application uses only these Stored Routines to SELECT,INSERT,UPDATE and DELETE data from 4 tables. In other words, all the interaction with the Test DB is performed through these Stored Routines. My application is an ASP.NET project which uses .NET connector to talk to MySQL. I decided to tighten the security on my system and created a test user account. (CREATE USER `TestMySQLUser`@`localhost` IDENTIFIED BY PASSWORD '6872364823746FC76CA82G73648237BB462876'; -- I made up the hash here but you get an idea) I then granted this test account the "Execute" permission to the 20 Stored Routines. The idea here was to only allow this test account call the SPROCS and nothing more. The SPROCS then will do all the work. However, when I try to run my app, I am getting an error: System.ObjectDisposedException: Cannot access a closed Stream. Basically, if I play with the security and allow my test account to have SELECT access to some of the tables in my DB as well as in MySQL db then things work. Is this expected? Am I doing something wrong? As I mentioned above, I only want the test account to have "EXECUTE" permission to the SPROCS. nothing else. What is the minimum privileges I need to accomplish the above?
View Replies !
Configuring A Database On A Remote Server
i have an aplication on .net for web, with mysql db, in my local server i have no problems, but recently i upload the aplication into a bougt host; when i open the page on the internet explorer or firefox, the page loads well, except for one simple grid. in another part of the aplication i try to insert a record, the app gave the me no error message, but when i check the table, there's nothing new. i don't if i configuring something wrone, on the web.config. and the worse of all if that i dont get any error?
View Replies !
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?
View Replies !
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?
View Replies !
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 ?
View Replies !
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
View Replies !
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.
View Replies !
Cannot Use Mysqladmin Monitor
I just installed mysql on my machine and there are few problems that I am facing wonder if any of you could help. 1. I can't seem to use the normal command line to open mysql. I got error 1045 access denied for user 'ODBC'@'localhost' (using password: NO) but I have no problem accessing it via MySQL command line client with a password (root user). My question is why doesn't a cmd prompt for a password? 2. I read from a book it states that I can create/drop a database using mysqladmin. the command line is bin/mysqladmin -p create sample_db. I tried that but got error 1064(42000): you have an error in your syntax... 3. Why can't I open mysql.exe and mysqladmin.exe directly by double click on the file from bin folder? I have to use Pause/break key to stop it every time I tried to open it this way. do I not suppose to open it this way? 4. How can I switch to differ account other than root?
View Replies !
Monitor Activities
how do u monitor activities in database per: who is connected and what she consume? what is the top 10 queries now going? where is the bottlneck?
View Replies !
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.
View Replies !
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?
View Replies !
|
TRACKER
