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
- 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 and
reopen the
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 and half - rename the file,
Am 05.04.2013 07:56, schrieb Keith Keller:
On 2013-04-05, Nitin Mehta ntn...@yahoo.com 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
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 45. Isn't it supposed to work?
Regards
From: Keith Keller kkel...@wombat.san-francisco.ca.us
To: mysql@lists.mysql.com
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
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 shawn.l.gr...@oracle.comSubject: Re: Fwd: mysql_tzinfo_to_sqlDate: April 5, 2013 1:58:01 PM EDTTo: Joe Kosinski joj...@gmail.comHi Joe,On
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
The commands didn't work and the time zone tables are not loaded. Whenever I ran the queriesmysql 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 previously
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
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
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 urvashi_pat...@symantec.com
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 forwarded
13 matches
Mail list logo