Sponsored Content
Special Forums UNIX and Linux Applications MySQL Slow Queries Log: Lock_time Post 302301281 by zefflyn on Thursday 26th of March 2009 11:32:25 AM
Old 03-26-2009
Fantastic, thanks.
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Performance of log parsing shell script very slow

Hello, I am an absolute newbie and whatever I've written in the shell script (below) has all been built with generous help from googling the net and this forum. Please forgive any schoolboy mistakes. Now to the qn, my input file looks like this - 2009:04:03 08:21:41:513,INFO... (7 Replies)
Discussion started by: sowmitr
7 Replies

2. Shell Programming and Scripting

Multiple MySql queries in shell script?

Hi guys, i know how to run a single query using mysql embedded in a shell script as follows: `mysql -umyuser -pmypass --host myhost database<<SQL ${query}; quit SQL` However, how would i be able to run several queries within the same connection? The reason for this is i am creating... (3 Replies)
Discussion started by: muay_tb
3 Replies

3. Web Development

Tracing a Slow MySQL Query

We have a few slow queries in forums. I am trying to track them down and see if I can fix them somehow. Here is an example from our mysql-slow.log: # Time: 090929 9:04:54 # User@Host: unixdb @ localhost # Query_time: 7 Lock_time: 0 Rows_sent: 10 Rows_examined: 75157 SELECT... (2 Replies)
Discussion started by: Neo
2 Replies

4. UNIX for Advanced & Expert Users

Monitoring cpu usage of mysql processes/threads/queries without any tool

hi all, i want to monitor mysql processes/threads/queries with respect to cpu usage.how can i do it? show processlist is of no use as no information abt cpu usage is given. plz help (7 Replies)
Discussion started by: rohitmahambre
7 Replies

5. Shell Programming and Scripting

Extract Mysql table output to a log file

I need to compare the 2 mysql database tables. there are around 50 tables in each DB. my idea is in DB1 extract result select * from table1; to alog file1 in DB2 extract result select * from table1; to alog file2 now compare log file 1 file 2 pls help me out ... thanks in advance (5 Replies)
Discussion started by: kalyankalyan
5 Replies

6. Red Hat

BIND 9.x log answers to queries

Hi, Can anyone tell me how in BIND 9.x (running 9.7.3) do you configure it to put the answer to each query in the log. I see the query, the IP who asked the query but not what the answer to the query is. thanks for your help, Phil (3 Replies)
Discussion started by: pcblack23
3 Replies

7. Red Hat

Bind 9.x cannot log answers to queries

I know this is a duplicate question but the original has never been answered properly. I've got Bind 9.x set up on my box and the logging turned on. I can see queries being logged but I still can't get it to log the answers to those queries. Here is my named.conf file: # File: /etc/named.conf ... (2 Replies)
Discussion started by: Vadim B
2 Replies

8. Solaris

Delayed log in / Slow log in HP -Solaris 10

Hi, i am workiing on HP servers with solaris 10 SunOS vmsvApp01 5.10 Generic_142910-17 i86pc i386 i86pc i am facing a dealyed log in problem, As soon i log in ... server is taking around 40-50 seconds to prompt password. please suggest Anand, (1 Reply)
Discussion started by: anand87
1 Replies

9. IP Networking

Iptables Log in mysql

Hello all friends I am using ulogd with iptables to import iptables log into mysql but it is not working , Is there any way to log iptables log into mysql , i am using centos 6 Thanks (0 Replies)
Discussion started by: rink
0 Replies
SETEUID(2)						     Linux Programmer's Manual							SETEUID(2)

NAME
seteuid, setegid - set effective user or group ID SYNOPSIS
#include <sys/types.h> #include <unistd.h> int seteuid(uid_t euid); int setegid(gid_t egid); Feature Test Macro Requirements for glibc (see feature_test_macros(7)): seteuid(), setegid(): _BSD_SOURCE || _POSIX_C_SOURCE >= 200112L || _XOPEN_SOURCE >= 600 DESCRIPTION
seteuid() sets the effective user ID of the calling process. Unprivileged user processes may only set the effective user ID to the real user ID, the effective user ID or the saved set-user-ID. Precisely the same holds for setegid() with "group" instead of "user". RETURN VALUE
On success, zero is returned. On error, -1 is returned, and errno is set appropriately. ERRORS
EPERM The calling process is not privileged (Linux: does not have the CAP_SETUID capability in the case of seteuid(), or the CAP_SETGID capability in the case of setegid()) and euid (respectively, egid) is not the real user (group) ID, the effective user (group) ID, or the saved set-user-ID (saved set-group-ID). CONFORMING TO
4.3BSD, POSIX.1-2001. NOTES
Setting the effective user (group) ID to the saved set-user-ID (saved set-group-ID) is possible since Linux 1.1.37 (1.1.38). On an arbi- trary system one should check _POSIX_SAVED_IDS. Under libc4, libc5 and glibc 2.0 seteuid(euid) is equivalent to setreuid(-1, euid) and hence may change the saved set-user-ID. Under glibc 2.1 and later it is equivalent to setresuid(-1, euid, -1) and hence does not change the saved set-user-ID. Similar remarks hold for sete- gid(). According to POSIX.1, seteuid() (setegid()) need not permit euid (egid) to be the same value as the current effective user (group) ID, and some implementations do not permit this. SEE ALSO
geteuid(2), setresuid(2), setreuid(2), setuid(2), capabilities(7), credentials(7) COLOPHON
This page is part of release 3.27 of the Linux man-pages project. A description of the project, and information about reporting bugs, can be found at http://www.kernel.org/doc/man-pages/. Linux 2009-10-17 SETEUID(2)
All times are GMT -4. The time now is 11:39 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy