10-29-2008
Ah ...
Did you try to stop mysql (if possible given your SLA, of course
)?
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi All,
I am working on a Solaris machine. When i use a particular software to generate some files, the log shows around 0 to 3 secs for generating each file. But the same when i see on the disk it shows double the time difference between two file generation.
For example if file A takes 0 secs... (7 Replies)
Discussion started by: nileshkarania
7 Replies
2. UNIX for Advanced & Expert Users
Dear All,
We are using AIX 5.2 with IBM pseries servers.
I want to check disk io for a running process.
Please if anybody can help me.
Thanks.
Aqeel Anwar (1 Reply)
Discussion started by: aqeelcu@hotmail
1 Replies
3. AIX
hi,
i am working on aix 5.2, i want to check disk i/o for any running process.
please if anybody can help me.
thanks
Aqeel Anwar (1 Reply)
Discussion started by: system-admin
1 Replies
4. Shell Programming and Scripting
Hello ,
Well I have some /tmp files which are growing very quickly..Can anyone suggest me a way to find which process is logging into this file :confused: ?
Thanks very much in Advance!!
Mohammed (2 Replies)
Discussion started by: Mohammed
2 Replies
5. UNIX for Dummies Questions & Answers
Hi
We are running an IBM P570 with AIX and Unidata.
The disk monitor in nmon is showing that one of our logical volumes is hitting 100% most of the time, and that 98% of it is write.
I am trying to identify the top processes in terms of disk IO, obviously particularly write so that we... (4 Replies)
Discussion started by: idwalton72
4 Replies
6. Linux
Hi,
The OS is SuSE Enterprise 11 and the system is HP WS460c G6 Blade with hardware disk array RAID 1 mirror. One disk was just replaced and the disk mirroring process is on its way. My question is how to follow up / monitor the disk mirroring process? I know hpacucli can do the job, but there... (0 Replies)
Discussion started by: aixlover
0 Replies
7. UNIX for Dummies Questions & Answers
I have multiple input files that I want to manipulate using a shell script. The files are called 250.1 through 250.1000 but I only want the script to manipulate 250.300 through 250.1000. Before I was using the following script to manipulate the text files:
for i in 250.*; do
|| awk... (4 Replies)
Discussion started by: evelibertine
4 Replies
8. Ubuntu
Hi,
I am using iostat and /proc/<pid>/status to determine the disk usage per process. I have a question regarding buffer cache. When I am reading a 10MB file, the counters I get show that <5MB of the file is read. Do the counters in iostat and /proc/<pid> reflect the amount of data that is... (2 Replies)
Discussion started by: fidelity
2 Replies
9. Emergency UNIX and Linux Support
In Our Production server I/O was very high, I Recived mail that Disk I/O was high, is it possible how to find which process Used this much I/O ?
Iam Using Ubuntu server 12.04.
Linux 3.9.3-x86_64-server33 (Li473-1200) 07/23/2014 _x86_64_ (8 CPU)
12:05:01 AM DEV ... (5 Replies)
Discussion started by: babinlonston
5 Replies
10. Open Source
Hello!
Need help to write a Linux script that can be run from windows using command/Cygwin/any other way. I am new to scripting, actually i am trying to automate server health check like free disk space, memory along with few services status, if any services is not running then start services ,... (7 Replies)
Discussion started by: Sayed Ibrahim
7 Replies
LEARN ABOUT DEBIAN
dbix::searchbuilder::handle::mysql
DBIx::SearchBuilder::Handle::mysql(3pm) User Contributed Perl Documentation DBIx::SearchBuilder::Handle::mysql(3pm)
NAME
DBIx::SearchBuilder::Handle::mysql - A mysql specific Handle object
SYNOPSIS
DESCRIPTION
This module provides a subclass of DBIx::SearchBuilder::Handle that compensates for some of the idiosyncrasies of MySQL.
METHODS
Insert
Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.
If the insert succeeds, returns the id of the insert, otherwise, returns a Class::ReturnValue object with the error reported.
SimpleUpdateFromSelect
Customization of "SimpleUpdateFromSelect" in DBIx::SearchBuilder::Handle. Mysql doesn't support update with subqueries when those fetch
data from the table that is updated.
DatabaseVersion
Returns the mysql version, trimming off any -foo identifier
CaseSensitive
Returns undef, since mysql's searches are not case sensitive by default
SimpleDateTimeFunctions
Returns hash reference with specific date time functions of this database for "DateTimeFunction" in DBIx::SearchBuilder::Handle.
ConvertTimezoneFunction
Custom implementation of "ConvertTimezoneFunction" in DBIx::SearchBuilder::Handle.
Use the following query to get list of timezones:
SELECT Name FROM mysql.time_zone_name;
Read docs about keeping timezone data up to date:
http://dev.mysql.com/doc/refman/5.5/en/time-zone-upgrades.html
AUTHOR
Jesse Vincent, jesse@fsck.com
SEE ALSO
DBIx::SearchBuilder, DBIx::SearchBuilder::Handle
perl v5.14.2 2011-09-21 DBIx::SearchBuilder::Handle::mysql(3pm)