General :: Monitor Database IO And Available Database Threads?
Mar 7, 2011
am using zabbix open source solution for systems monitoring. I am facing a problem and discussed it on zabbix forum. my post was as "My zabbix server is behaving abnormally, approximately daily from 9 to 12, the server stop accumulating logs. I observed that the server report is RUNNING but it did not accumulate log values and also the machine have no extra load. Its shown in the graph image attached.t the following reply,"database performance?are you monitoring database IO and available database threads? "So any one have any idea that how can I do this as I am using MySQL as backend database on RHEL 3.
View 1 Replies
ADVERTISEMENT
Jan 20, 2010
I have installed mysql in my local machine having centos. i also installed nagios in the same machine nagios is running fine by monitoring the local host. Now i need to monitor the local MySQL database and so i installed check_mysql_health plugin and followed the steps as given in the file.
when i try to give the command
./check_mysql_health -H mysqlhost --user nagios --password wipro --mode threads-connected
i got the error like
CRITICAL - cannot connect to information_schema. install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: . /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.7/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7
[Code]....
I installed mysql Ver 14.12 Distrib 5.0.87 after removing the version that comes along with the centos, is this things relates to my error?
View 2 Replies
View Related
Jan 5, 2011
I am writing a simple application that will run as user foo (i.e. Ubuntu user foo).However, the application will connect to my database as (database user foobar). IIRC, database users have nothing to do with Linux system users - but I just need to clarify that.So can an app launched to run as user 'foo', connect to a database as user 'foobar'?
View 1 Replies
View Related
Jul 8, 2011
I recently moved into a new place and when I hooked up my webserver, I wasn't able to bring up my page, even from localhost. With some digging, it seems that I can't access the database that housed my posts (wordpress installation). I looked for the datadir in MySQL and that directory shows the wordpress directory that should be holding the database and all the files are still there. 1) why the database no longer shows up 2) how to restore the database from the files?
View 2 Replies
View Related
Jun 16, 2011
I've setup a CentOS apache web server, and loaded a site onto it. The site previously was functioning under windows xp (before I "stepped in") and wamp. What I did was copy the site in /var/www, reconfigure the httpd.conf (DocumentRoot /var/www/site, etc). Although when I try to open the webpage I get this error: Database Error: Unable to connect to the database:The MySQL adapter "mysql" is not available.
[code]...
View 10 Replies
View Related
Jan 12, 2011
I have been ordered to transfer my database running on oracle 10g on linux 32 bit OS to linux 64 bit. I need to know the advantages of 64 bit over 32 bit. Besides i would like to know if would face any difficulty while i migrate the database from 32 bit to 64 bit.
View 3 Replies
View Related
Mar 25, 2010
Specifically I'm looking for a native Linux program that is similar in functionality to Navicat or SQLYog. I.e. I need something good at editing data. Free would be best, but not essential.
View 9 Replies
View Related
Jul 30, 2011
I recently installed a portable WAMP server on my usb stick. Really nice, I can do some php programming on my girlfriend's windows7 laptop without installing anything on it.I also have a LAMP environnement on my linux computer.When I plug my usb stick on my linux box, I can easily mount -o bind /usbstick/wwwfolder ~/public_html and work on my php script from there.
But my question is, is there a way I could get the database from my usb stick's MySql server, to run on my linux MySql server? So I can modify data base schema from my Linux workstation, doing some INSERTS in some tables, and then plub my usb stick on the laptop and get my up-to-date database running from the portable environnement?I don't know where / how MySql stores its databases. Basically, I want to "mount" the database from the usb stick in my Linux' installed MySql server, without extracting and importing the data, so there is just ONE database used for BOTH environnement.
View 3 Replies
View Related
Jul 14, 2010
parsing the text file in perl.I have very large text file with plenty of columns and rows.how can i parse the file into Oracle database.
View 3 Replies
View Related
Mar 11, 2010
I would like 2 computers (same network) to use the same SQL database. How should I start?
View 2 Replies
View Related
Mar 24, 2010
I posted a thread regarding a CD Base Application. I can run the program, but for some reason It does not seem to work properly.
For some reason in exits the program back to the command prompt. I am using the code from Linux programming 4th edition which you can get it from here...and in the folder ch08/app you will find all you need to create the CD database application.
View 1 Replies
View Related
Nov 16, 2010
I'm trying to connect to a remote database but can't connect directly (I think due to security reasons). Here's the setup:
Computer A - my computer
Computer B - server, I can SSH to this from computer A
Computer C - server that runs database, I can SSH to this from B but can't from A
Any ideas how I can can connect to C directly from A? I think I need to setup a tunnel or something like that but I can't figure it out.
View 3 Replies
View Related
Nov 26, 2010
I am not having any knowledge of mysql database & in my present jobs i have to solve problem on mysql database. need some commands which are used regularily in database.
View 1 Replies
View Related
Mar 8, 2010
I want to migrate a mysql databases from a old server to a new server ( Redhat ) , can advise what I need to do ,is it just copy all .frm , .MYI & .MYD files to new server will do ? or I need to do export and inport data ?
View 12 Replies
View Related
Apr 13, 2011
I need to copy tables from abc5/abc5@pqrXYZ1 to jk8/jk8@pqrXYZ1. For this I am trying to create a link between the 2 databases but not wkng.I am pasting here what I ve tried.
sqlplus jk8/jk8@pqrXYZ1
[code]....
View 4 Replies
View Related
Jun 27, 2011
How to backup a particular Databases..through Bash script! For example i have 6 databases;
Anish
linux
Software
Questions
Rhce
Google
these are the databases i have from that i want to take "Anish" and "questions" database backup regularly.
View 8 Replies
View Related
Apr 19, 2011
I switched from Windows 7 to Linux and when I'm trying to import my database i get error 1044. It used to work when I was using Windows 7. I was able to export the database from my localhost. However, when I try to import it to the other server I get this:#1044 - Access denied for user ' '@'%' to database'.I have been trying for hours to upload my site from the localhost to another server without any luck..I'm using phpmyadmin to import it.
View 2 Replies
View Related
Aug 17, 2010
I m trying to store the output of vmstat 1 10 into a database.I have done the necessary homework to connect bash to interact with the database.Program logic.1)storing the output of vmstat 1 10 to a file named abc.txt2)I m applying a filter to vmstat to get desired output containing cpu(user),cpu(system),cpu(idle) values.3)
Code:
# cat abc.txt | grep -vE '(procs|free)'| awk '{print $13 " "$14 " " $15}'
0 1 97
[code]....
View 3 Replies
View Related
Sep 5, 2010
i need to update my mysql database from 5.0 for 5.1, i have several java application and php application running on that server, without disturbing the setup i need to upgrade the server can someone suggest a method of doing this
View 2 Replies
View Related
Jan 7, 2010
I was wondering if anyone knows of a good password database I can download for Redhat. It only needs to be basic with a few options such as 'hostname', 'userid', 'password' etc and will allow read access for everyone but only allow administrators to edit, create, delete entries.
Most of the downloadable Password Databases run on Windows but apart from Gringott's I am unable to find a suitable database which will run on Redhat.
View 2 Replies
View Related
Jun 30, 2011
I am running RHEL5 and I have just upgraded my RPM software manager from RPM version 4.4.2 to RPM version 4.9.0 (the latest version) by doing a clean install of v4.9.0. The version 4.4.2 came with the RHEL5 and at the moment is very old so I cannot install certain newer rpms. I followed the INSTALL instructions that comes with the tarball for V4.9.0. The problem is the new install (i.e. RPM V4.9.0) has no knowledge of my old RPM manager i.e. V4.4.2, hence it does not know of the rpm packages installed on my system.
I think the problem is that the V4.9.0 is a new install rather than an upgrade (There are no instructions on how to perform a 'real' upgrade). I have tried to rebuild the rpmdb for v4.9.0 but that does not help and I have no idea how to import the data from v4.4.2 database to v4.9.0 database. My question is, how do I import the database from RPM manager V4.2.2 into RPM manager V4.9.0 or how do I 'upgrade'properly from V4.4.2 to V4.9.0. I have trawled the internet for some guides but there does not seem to be anything regarding this.
View 4 Replies
View Related
Oct 1, 2010
Am using mandriva 2008 i developed one simple application using cross platform = Qt3 Database = PostgreSQL
I want to share my database over peer to peer network.
server ip = 192.168.1.5
client ip = 192.168.1.6
Now how to share data over those ip?
View 1 Replies
View Related
Jan 29, 2010
I'm having trouble ssh tunneling through two servers to get to my database. Server3 is restricted to all except from server2 and I'm at server1. So on server2 i do ssh -L1434:server2:1435 -l user server2 - this works i'm able to connect to the db on server3 from server2. But on server3 i'm trying to ssh -L1433:server2:1434 -l user server2
- and I get 'connection refused'. I tried telnet server2 1434 from server3 and i get 'connnection refused'. I checked the firewall is open on server 2 - firestarter confirms that port 1434 is open to everyone. I'm not sure what I'm doing wrong, but I have a hunch that maybe firestarter on server2 is not working correctly, because it also shows that port 22 is open to everyone and I can telnet server2 22 and I'm able to connect.
View 2 Replies
View Related
Jan 31, 2011
Ok so I need to Search for a postgres database File on a CentOs System. Is their a command i can run in the terminal to search for postgres files?
View 2 Replies
View Related
Jul 25, 2011
how do I create a shell script that looks for connections running on a oracle database. e.g connection name is CONNECT and database name is DBTEST. I want to know what processes with the name CONNECT are running in database called DBTEST. Am creating the script on the server side. I know about the ps -ef | grep command but how to point to a particular database I don't know.
View 4 Replies
View Related
Jun 26, 2011
i want to write a program that need to know how much data has transmitted in network usage _how much send and how much received_which file , record or structure in which library i have to follow ?
View 2 Replies
View Related
Jul 6, 2011
i had installed alfresco 3.4 server .previously we are working with alfreso version 1 .how i can moved the database content of alfresco 1 version content in alfresco 3.4 content.whether i had to migrate mysql of 3.1 directly to 3.4 alfresco server are else i had to just put the content in alf_data content store and content deleted table alone is enough .
View 1 Replies
View Related
Apr 8, 2010
is it possible to authenticate users logins by a database (postgres, mysql)?for instance: -user types username, pasword, at login screen -OS then connects to server with database and checks if the user is valid. if so, is it feasible to add a time lock function for each user? in the sql, postgres table ? for instance user sandra can only log onto the computer for 1hr at 5pm
View 7 Replies
View Related
Oct 10, 2010
Is there a particular distro that would be the 'best' for a newbie to use for developing database applications using Firebird?
View 5 Replies
View Related
Apr 8, 2011
translationables,i.e,camp_generic_transcamp_generic_trans_defcamp_generic_trans_epcthese tables exist in cntr1/cntr1@camABC1I have to copy these tables from here to staging environment.I need to first check if any of the tables exist in staging.If yes,then delete and create new.There are 4 staging env from 5 to 8.I have to pass the staging environment as parameter to ask the user which environment does he want the tables to be copied
View 1 Replies
View Related
