Update and lock question.

I'm doing some tests, but have a questions about locking. In a innodb table, if you issue an select for update lock for a row, supposedly, it only locks that row, but if you don't issue a select for update, and trow the update... does it locks the hole table? The update goes over an indexed field

Re: error-log aging

- Original Message - > From: h...@tbbs.net > Subject: Re: error-log aging > > man logrotate > > Not Unix! So get unix :-) > In any case, I take this to mean that this is not done within MySQL, > right? Half and half - rename the file, then issue "flush logs" in mysql to close a

Re: error-log aging

Am 05.04.2013 11:16, schrieb Johan De Meersman: > - Original Message - >> From: h...@tbbs.net >> Subject: Re: error-log aging >> >> man logrotate >> >> Not Unix! > > So get unix :-) > >> In any case, I take this to mean that this is not done within MySQL, >> right? > > Half an

Re: MySQL on RHEL4

Am 05.04.2013 07:56, schrieb 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

Re: MySQL on RHEL4

Hi Keith,   Thanks for your response. However, i'm not sure which case it is because in the downloads, it says "Platform: Oracle and Redhat 4&5". Isn't it supposed to work?   Regards From: Keith Keller To: mysql@lists.mysql.com Sent: Friday, April 5, 2013 11:

Re: Cannot load time zone tables to MySQL

Hi Joseph, We request that except for sensitive information that you keep all responses on the list. This way the entire community can kick in for assistance. On 4/5/2013 12:25 PM, Joseph Kosinski wrote: Thanks for your response. This has been troubling me for days! I am not too familiar wi

Fwd: mysql_tzinfo_to_sql

I tried the use mysql; for my session.  Here is the result: Terminal Saved Output 7 Description: Binary data JoeBegin forwarded message:From: shawn green Subject: Re: Fwd: mysql_tzinfo_to_sqlDate: April 5, 2013 1:58:01 PM EDTTo: Joe Kosinski Hi Joe,On

mysql_tzinfo_to_sql

I cannot find the path where mysql_tzinfo_to_sql is installed. I have these instructions: This program is installed to the same .../bin folder as your mysqld binary. Use a "which" command to clarify where that is on your system. which mysql_tzinfo_to_sql Then use the path it identifi

Fwd: mysql_tzinfo_to_sql

The commands didn't work and the time zone tables are not loaded.  Whenever I ran the queries mysql> SELECT * FROM time_zone;  mysql> SELECT * FROM time_zone_name; I got an error message stating no database was selected.  I think when I tried to locate the path to the mysql_tzinfo_to_sql previousl

Re: error-log aging

Am 04.04.2013 23:08, schrieb h...@tbbs.net: > 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 signature.asc Description: OpenPGP digital signature

Re: Fwd: mysql_tzinfo_to_sql

On Fri, April 5, 2013 13:19, Joe Kosinski wrote: > I also tried mysql_tzinfo_to_sql /usr/share/zoneinfo > sqlLines with the > following Terminal output: > > > -bash: sqlLines: Permission denied > > Joe Well at lease we are on familiar territory now. Whatever d

Re: Update and lock question.

Thanks Urvashi. Based on your answer, instead of the data I looked into the index, and it appears that it was an index issue... I think I have nailed the wait lock contdition due a updating indexes unnecesarely... On Thu, Apr 4, 2013 at 10:52 AM, Urvashi Pathak wrote: > > > Hi Andrés, > > Sel

Fwd: mysql_tzinfo_to_sql

I am logged onto the system as system administrator and should have privilege  to write to the file.  I have tried cd .. several times and no matter what I still get permission denied.  Please see attached terminal output: Terminal Saved Output 11 Description: Binary data Thanks,JoeBegin forward

RE: Determing number of queries

Richard, there is more to a system than number of queries. Please post these in a new thread on http://forums.mysql.com/list.php?24 : SHOW GLOBAL STATUS; SHOW VARIABLES; Ram size I will do some analysis and provide my opinion. > -Original Message- > From: Manuel Arostegui [mailto:

Re: MySQL on RHEL4

Am 05.04.2013 09:46, schrieb Nitin Mehta: > Thanks for your response. However, i'm not sure which case it is because in > the downloads, it says "Platform: Oracle and Redhat 4&5". Isn't it supposed > to work? most likely Oracle does not care about RHEL4 because it is EOL and has no longer supp