RE: determine safest value for max_connections

> This might help you > http://kjalleda.googlepages.com/maxconnbymysql > > Kishore Jalleda Thanks Kishore. Regards, Rithish.

RE: identify process that created the connection

, Rithish. -Original Message- From: Ravi Prasad LR [mailto:[EMAIL PROTECTED] Sent: Friday, July 28, 2006 9:36 AM To: Rithish Saralaya Cc: MySQL general mailing list Subject: Re: identify process that created the connection This blog may help, http://www.xaprb.com/blog/2006/07/23/how-to-track

determine safest value for max_connections

Hello folks. How do I determine what is the safest value that I can set for max_connections in my.cnf? The default value of 100 is proving to be a shortfall during some cases of peak hour traffic. Could you point me to a resource available if any? 1. Our server is RHEL 3, 2*3.00 GHz, 4GB

identify process that created the connection

Hello people. Is it possible to find the process that invoked the mysql thread, given a mysql thread id? We have a web application that runs on Linux-Apache-MySQL-PHP; and I sometimes see numerous mysql threads in sleeping mode when I run mytop. I think the sleeping mysql threads could be due t

RE: How to log the execution time of each query

> I would like to log the execution time for each query in my MySQL server > .Is there any possible way? If you are using MySQL to serve an application, then it is advisable to do the logging through the application scripts. For in most cases, you might require more information other than time alo

RE: Looking for free MySQL Administrator

> I'm looking for a MySQL administrator for 4.x/5.x that will allow me to > > Any suggestions? TIA http://www.webyog.com/ Regards, Rithish. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Re: How to find size of my database

> 1) I'll assume you use myisam tables, as your version is kinda outdated. > 2) I'll assume you want the total DISK space required for your > database. (could be rows, could be tables, could be space used by the > rows and tables, all of those are different, different storage engines > use space d

RE: deadlock - further information

> As 11 > 4, 4.1.11 is newer than 4.1.4, so this variable is available to you. Gawwddd... I really made an ass of myself that time... :o) Thanks for pointing it out though. > 4.1.11 is almost a year old. Have you read the list of bugs fixed since then? >

deadlock - further information

> > > > Hello. > > > > We have a web application for our intranet, which uses MySQL for db > > management. The application has a way of logging query errors that are > > generated in the system. > > > > We get a mysql error recorded as - "Deadlock found when trying to get > > lock; > > try restarti

digest not received

I have not been receiving the daily digest for the past 2 days. Just wanted to check if I am the only one it's the same for others too. Regards, Rithish.

deadlock - further information

Hello. We have a web application for our intranet, which uses MySQL for db management. The application has a way of logging query errors that are generated in the system. We get a mysql error recorded as - "Deadlock found when trying to get lock; try restarting transaction" when one of the files

RE: How to Log Warnings and Errors from queries

Hello Ryan. I am more of a developer than a MySQL administrator. Hence, I would always favour applications logging query errors rather than being dependent on MySQL to generate a log for me. Of course, I may be wrong. You could write a query execution function, say exec_mysql_query(...) in one of

RE: mysqldump backup on filters

>>Your table is missing. Try this: >>mysqldump --single-transaction -u root clientdb >>--where="FLD_CLIENT_ID=1" > client1_dbbackup.sql >Yes. The tables are missing. That's because I want the backup of all the >tables in the db, and those tables that have the column FLD_CLIENT_ID, they >should b

manual deletion of binary log files

Hello. Can I delete off the binary log files manually? I do not want to 'RESET MASTER', as it will clear all the binary logs, and that's not what I want to do. The database is backed up every midnight, and I wouldn't want to keep any of the bin logs except the latest one. We are on RHEL - MySQL 4

RE: mysqldump backup on filters

>Your table is missing. Try this: ?>mysqldump --single-transaction -u root clientdb --where="FLD_CLIENT_ID=1" > client1_dbbackup.sql Yes. The tables are missing. That's because I want the backup of all the tables in the db, and those tables that have the column FLD_CLIENT_ID, they should be fil

RE: create/restore database without binary logging

Thanks Sheeri. Regards, Rithish. -Original Message- From: sheeri kritzer [mailto:[EMAIL PROTECTED] Sent: Thursday, March 02, 2006 11:26 PM To: Rithish Saralaya Cc: MySQL general mailing list Subject: Re: create/restore database without binary logging Rithish, It's possible to do

mysqldump backup on filters

Hello. We have a database driven system that serves multiple clients. We have a single database for this purpose. The data(rows) in some of the tables are specific to individual clients. In all such tables, we have a field FLD_CLIENT_ID whose value depicts the client to whom that row of informatio

RE: error 1016 : cant open ibd file even though it exists

sage - From: ""Rithish Saralaya"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Monday, February 27, 2006 7:06 AM Subject: RE: error 1016 : cant open ibd file even though it exists > Heikki. > > I found the ibdata1 and ib_log files located in

RE: error 1016 : cant open ibd file even though it exists

power failure' the words 'table corruption' sprang to my mind. Also, are there any mysql transaction logs (*.log) you can check, to see what was happening when the power outage occured? Keith In theory, theory and practice are the same; In practice they are not. On Sat, 25 Feb 2006, Ri

create/restore database without binary logging

Hello. I was going to recreate a database of size 35 GB from sql dump file. Wanted to know if it is possible to do it without mysql writing into the binary log. If yes, how? Regards, Rithish.

RE: error 1016 : cant open ibd file even though it exists

/order.php - Original Message - From: ""Rithish Saralaya"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Saturday, February 25, 2006 12:14 PM Subject: RE: error 1016 : cant open ibd file even though it exists > --=_NextPart_000_001D_01C63

RE: error 1016 : cant open ibd file even though it exists

EMAIL PROTECTED] Sent: Saturday, February 25, 2006 3:32 PM To: Rithish Saralaya Cc: mysql@lists.mysql.com Subject: Re: error 1016 : cant open ibd file even though it exists Hi Rithish, After reading Heikkis points, I am inclined to agree. Did your sysadmins change a filesystem durin

RE: error 1016 : cant open ibd file even though it exists

s for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php - Original Message - From: ""Rithish Saralaya"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, February 24, 2006

RE: error 1016 : cant open ibd file even though it exists

p MyISAM tables http://www.innodb.com/order.php . List: mysql Subject:error 1016 : cant open ibd file even though it exists From: "Rithish Saralaya" Date: 2006-02-22 11:27:44 Message-ID: ANEAKJJGBMNHIAEBLIAIMEPCECAA.rithish.saralaya () tallysolutions ! com [Download me

RE: error 1016 : cant open ibd file even though it exists

/lib/mysql/ This is where the mysql is located. That's proper. -Original Message- From: sheeri kritzer [mailto:[EMAIL PROTECTED] Sent: Friday, February 24, 2006 3:22 AM To: Rithish Saralaya Cc: MySQL general mailing list Subject: Re: error 1016 : cant open ibd file even though it exi

RE: error 1016 : cant open ibd file even though it exists

Original Message- From: Ady Wicaksono [mailto:[EMAIL PROTECTED] Sent: Thursday, February 23, 2006 5:50 PM To: Logan, David (SST - Adelaide) Cc: Rithish Saralaya; MySQL general mailing list Subject: Re: error 1016 : cant open ibd file even though it exists Try to help Please give us the "l

RE: error 1016 : cant open ibd file even though it exists

PROTECTED] Sent: Thursday, February 23, 2006 10:42 AM To: Rithish Saralaya; MySQL general mailing list Subject: RE: error 1016 : cant open ibd file even though it exists Hi Rithish, Please check your ownership/permissions hambone ~ $ perror 1 OS error code 1: Not owner hambone ~ $ Regards

error 1016 : cant open ibd file even though it exists

Hello. I get the following error when I try to query a table in a particular database (test). The error is generated for all tables within that database. However, 'mysql' database works fine. ERROR 1016 (HY000): Can't open file: 'TBL_FORUM_MSG_BODY.ibd' (errno: 1) However, I have noticed that bo

error 1016 : cant open ibd file even though it exists

Hello. I get the following error when I try to query a table in a particular database (test). The error is generated for all tables within that database. However, 'mysql' database works fine. ERROR 1016 (HY000): Can't open file: 'TBL_FORUM_MSG_BODY.ibd' (errno: 1) However, I have noticed that bo

OPTIMIZE fails on very large table

Hello. We had an INNoDB table of very large size of 47 GB. Recently we deleted a lot of rows from the table in order to reduce the size. The number of rows now stands at 164,000+, however, the disk usage remains the same. I tried OPTIMIZEing the table; but the optimize fails after running for abou