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 Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
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?
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
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 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 ?
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.
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.
Monitor SQL Statements Being Executed
How can I monitor what SQL statements are being executed on any table in realtime for any user? Example... I use Oracle Session Manager to do this with oracle. I want the same ability in MySQL 4.1.5
Monitor A Table Query
Environment: mysql 5.0.22 on Fedora Core 5 I have a mysql table that contains user IDs and passwords. These IDs and passwords are used to allow access various web pages. But the initial web page that does the authorization lookup may not be working correctly. Is there a way to monitor the mysql (table) in realtime to see if the lookup is being performed?
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
Monitor A Long Insert
Is there a way to know at what stage is a long Insert/Replace query, as how many rows have been inserted? Besides the time counter I've found nothing to do it.
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:
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?
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 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"?
|