Re: MySQL on RHEL4

2013-04-04 Thread Keith Keller
On 2013-04-05, Nitin Mehta wrote: > > We're trying to upgrade our existing MySQL 5.1.26 to MySQL 5.1.68 but the > installation gives error:libc.so.6(GLIBC_2.4) is needed by > MySQL-server-community-5.1.68-1.rhel5.i386 rtld(GNU_HASH) is needed by > MySQL-server-community-5.1.68-1.rhel5.i386 Now,

MySQL on RHEL4

2013-04-04 Thread Nitin Mehta
Hi,   We're trying to upgrade our existing MySQL 5.1.26 to MySQL 5.1.68 but the installation gives error:   libc.so.6(GLIBC_2.4) is needed by MySQL-server-community-5.1.68-1.rhel5.i386 rtld(GNU_HASH) is needed by MySQL-server-community-5.1.68-1.rhel5.i386   Now, GLIBS2.4 is not available for RHE

Re: Determing number of queries

2013-04-04 Thread Manuel Arostegui
2013/4/4 > 2013/04/04 22:40 +0200, Manuel Arostegui > You can start with show innodb status; > > It is now > show engine innodb status Yep, sorry, not used to it just yet :-) -- Manuel Aróstegui Systems Team tuenti.com

Re: error-log aging

2013-04-04 Thread hsv
2013/04/04 23:18 +0200, Reindl Harald > Is there somewhere within MySQL means of aging the error log, that it not > indefinitly grow big, or is that done through the OS and filesystem on which > "mysqld" runs? man logrotate Not Unix! In any case, I take this to mean that this

Re: Determing number of queries

2013-04-04 Thread hsv
2013/04/04 22:40 +0200, Manuel Arostegui You can start with show innodb status; It is now show engine innodb status -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

error-log aging

2013-04-04 Thread hsv
Is there somewhere within MySQL means of aging the error log, that it not indefinitly grow big, or is that done through the OS and filesystem on which "mysqld" runs? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Determing number of queries

2013-04-04 Thread Manuel Arostegui
2013/4/4 Richard Reina > I am looking to spec out hardware for a new database server. I figured > a good starting point would be to find out how much usage my current > server is getting. It just a local machine that runs mysql and is > queried by a few users here in the office. Is there a way th

Determing number of queries

2013-04-04 Thread Richard Reina
I am looking to spec out hardware for a new database server. I figured a good starting point would be to find out how much usage my current server is getting. It just a local machine that runs mysql and is queried by a few users here in the office. Is there a way that mysql can tell me info about i

Re: Join query returning duplicate entries

2013-04-04 Thread shawn green
Hello Trimurthy, On 4/4/2013 3:21 AM, Trimurthy wrote: Hi list, i wrote the following query and it is returning duplicate entries as shown below, can any one suggest me how to avoid this duplicate entries, with out using distinct. Query: select p.date,p.coacode,p.type,p.crdr,p.quantit

Re: Join query returning duplicate entries

2013-04-04 Thread Lucky Wijaya
Hi, sorry i tried to help but i hardly understand the use of join in your query since the joined table is not used anywhere. From: Trimurthy To: mysql@lists.mysql.com Sent: Thursday, 4 April 2013, 14:21 Subject: Join query returning duplicate entries Hi list

Re: Join query returning duplicate entries

2013-04-04 Thread Johan De Meersman
- Original Message - > From: "Lucky Wijaya" > To: mysql@lists.mysql.com > Sent: Thursday, 4 April, 2013 10:51:50 AM > Subject: Re: Join query returning duplicate entries > > Hi, sorry i tried to help but i hardly understand the use of join in > your query since the joined table is not u