Nope, it was locked on a single value for about 36 hours, until we restarted the
engine last night. Now it's running fine, and we're setting up a testbed to
evaluate
MySQL 5.6 and FreeBSD 9 (?) for replacing our current Solaris 10/MySQL 5.1.46
setup.
On 6/28/13 12:44 AM, walter harms wrote:
Avoid FreeBSD,
Unless they did some real big magic on the scheduler of 9.
Claudio
On Jun 28, 2013 6:12 PM, "Andy Wallace" wrote:
> Nope, it was locked on a single value for about 36 hours, until we
> restarted the
> engine last night. Now it's running fine, and we're setting up a testbed
> to ev
hi,
does the value change at all like below ?
mysql> show global variables like 'timestamp';
+---++
| Variable_name | Value |
+---++
| timestamp | 1372404355 |
+---++
1 row in set (0.00 sec)
mysql> show global varia
Ok, I appreciate the Einsteinian and Vonnegut humor... just wanted to say. Still
have the problem though. 8-(
On 6/27/13 9:51 AM, Nick Khamis wrote:
Just out of curiosity, is the hardware stationed, or traveling close
to the speed of light (i.e., 18,000 miles per second)? Sorry I could
not help
Just out of curiosity, is the hardware stationed, or traveling close
to the speed of light (i.e., 18,000 miles per second)? Sorry I could
not help it
N.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Well, that begs the question - will restarting the MySQL server instance
tonight fix
the current problem? We do have a plan in place to test and eventually deploy
a more
recent version of MySQL (5.6?), but for now, I have to support 1000's of
customers.
My fingers are crossed.
On 6/27/13 12:2
Hi,
On 06/27/2013 08:19 PM, Andy Wallace wrote:
Benjamin -
Unfortunately:
mysql> show global variables like 'timestamp';
+---++
| Variable_name | Value |
+---++
| timestamp | 1372238834 |
+---++
1 row in set (0.00
Benjamin -
Unfortunately:
mysql> show global variables like 'timestamp';
+---++
| Variable_name | Value |
+---++
| timestamp | 1372238834 |
+---++
1 row in set (0.00 sec)
And:
mysql> set global timestamp = 0;
ERROR
Sort of:
mysql> show variables like 'init_connect';
+---+---+
| Variable_name | Value |
+---+---+
| init_connect | |
+---+---+
On 6/27/13 11:23 AM, Eric Bergen wrote:
Does show variables like 'init_connect'; return anything?
On Thu, Jun
Timestamp is a session variable, so it must have been set to something
other than 0 (1372228034 epoch is the date you're showing) in your current
session.
mysql> set timestamp = 1372228034;
Query OK, 0 rows affected (0.00 sec)
mysql> select now(), sysdate();
+-+-
It persists across sessions?
Does this return anything:
show global variables like 'timestamp';
Hopefully it returns:
Empty set (0.00 sec)
I vaguely remember reading about a bug in 5.1.4x with something to do with
a global timestamp. I thought it only showed one though, and that you
couldn't se
Does show variables like 'init_connect'; return anything?
On Thu, Jun 27, 2013 at 11:19 AM, Andy Wallace wrote:
> Benjamin -
> Unfortunately:
>
> mysql> show global variables like 'timestamp';
> +---++
> | Variable_name | Value |
> +---++
> | t
But the question is how. I have nothing in the code that does it, or this
would have been true for months instead of just the last 24 hours. In
addition, this is currently set globally - no matter what connection to
the database, it all comes up with this value. Which means that all my
time-based
Problem is that I don't set the timestamp variable anywhere (except yesterday as
a test to try and fix the problem). This is stuff that has been working
correctly
for many months. We had some network/dns and load issues over the last couple of
days, and the mysql clock is frozen at:
mysql> sele
y Wallace" , "mysql list"
>
> Sent: Thursday, 27 June, 2013 1:36:31 AM
> Subject: Re: NOW() is stuck...
>
> Random I-can't-sleep thought: you wouldn't be testint this in a
> single
>
--
Unhappiness is discouraged and will be corrected with kitten pictures.
This is the expected behavior if you set the timestamp variable in
your session. This is the same mechanism that replication uses to
execute transactions on the slave with the correct time. Setting
timestamp back to default or reopening your connection will fix it.
MariaDB [(none)]> set timestamp=
Well, if you want to get unstuck in time, maybe you need to call Billy
Pilgrim ;-)
Andy Wallace wrote:
We've been having some issues with one of our MySQL servers lately,
and currently
the dang thing is "stuck". For at least the last hour, NOW() is
returning the same
value:
mysql> select now(
Submit a bug:
http://bugs.mysql.com
Alas, you probably cannot provide a reproducible test case. Still, someone
might start at the code and discover a possible cause.
> -Original Message-
> From: Andy Wallace [mailto:awall...@ihouseweb.com]
> Sent: Wednesday, June 26, 2013 3:10 PM
> To: m
Always echo out your SQL string, it will make it a lot more obvious.
You want to see the result. I php concatenated string can be
confusing at times.
Also, you are not escaping your data, so if you had a word of 'stops,
here' that would break it as well.
So in your case, you very well m
Thanks, Scott.
I thought I couldn't have missed ','(comma) before. But today somehow it
works... ;;
I wasted hours figuring this out, but you saved me!
Maybe I'm still a complete newbie!
Thanks, again. Have a great day. :)
On Thu, Apr 30, 2009 at 12:52 PM, Scott Haneda wrote:
>
> On Apr 29,
On Apr 29, 2009, at 11:29 AM, Antonio PHP wrote:
This is MySQL data structure. - I underlined where it causes the error
message. (datetime)
`id_Company` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`Name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
`Revenue` mediumint(6) NO
Thanks. NOW() and php date(); work for my newly created test tables, but it
doesn't work for my working table. I can't insert date, time or now()
into my old table (which is as below).
For now, I'm using MySQL auto timestamp ('Updated' field), but I need to
insert date when the data was created!
We need to see your entire query and the table structure. timestamp
fields can have options set to auto update them, where order matters,
and only one field can support that feature.
Please supply more data.
On Apr 28, 2009, at 2:18 PM, Antonio PHP wrote:
You have an error in your SQL synt
Can you please give the full table structure and query?
On Tue, Apr 28, 2009 at 23:18, Antonio PHP wrote:
> You have an error in your SQL syntax; check the manual that corresponds to
> your MySQL server version for the right syntax to use near 'Created = NOW(),
> Updated = NOW()' at line 8
>
> 'C
Thanks Jimmy - that's the one.
-Original Message-
From: Jimmy Guerrero [mailto:[EMAIL PROTECTED]
Sent: 31 October 2005 19:39
To: 'Alexander Shaw'; mysql@lists.mysql.com
Subject: RE: Now what's that called?
Hello,
Are you think of Eventum?
http://dev.mysql.com/dow
I have no idea what the product was called but if the email was sent to this
mailing list, you should be able to find it on the MySQL site; they archive
all of the traffic on the various MySQL mailing lists and have a search
engine for locating it; all you need to do is throw appropriate search ter
Hello,
Are you think of Eventum?
http://dev.mysql.com/downloads/other/eventum/
Thanks,
Jimmy Guerrero, Senior Product Manager
MySQL Inc, www.mysql.com
Houston, TX USA
Phone: (713) 636-9239
Are you MySQL Certified? www.mysql.com/training//certification
-Original Message-
From: Al
Peter
>How do i go about saving data to multiple tables from
>one entry form or should this happen automatically
If the model is that a user can have radios which in turn can have
events,
you need a userid column in users and radios, and a radioid column in
radios and events. You need to re
At 17:56 +0900 6/28/03, Itoh Kohji wrote:
Now I have solved the problem I asked you to help me!
The problem was when to invoke mysql_install_db.
I invoked it before l let the daemon start, following the
instruction of a textbook on MySQL.
I have found in a magazine that I shoulld have run the
sc
Itoh-
Is the MySQL doc incorrect?
Please advise.
Martin
- Original Message -
From: "Itoh Kohji" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 28, 2003 4:56 AM
Subject: Now I have solved my problem!
>
> Now I have solved the problem I asked you to help me!
>
> The
> After I set starttime to now(), anytime I run another update query against
> the row starttime changes to a new value.
If starttime is the timestamp data type, and the first timestamp in the row,
it will automatically update every time you update the row. This is not a
bug, it is expected behav
That's really odd. I've never experienced that problem, but I'm running the
latest production release (4.0.13), so I perhaps it's been fixed between
versions.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Lucas Heuman" <[EMAIL PROTECTED]>
To: <[EMAIL
On 17 Jun 2003 at 14:05, Lucas Heuman wrote:
> After I set starttime to now(), anytime I run another update query
> against the row starttime changes to a new value.
You don't give the structure of your table, but it appears that
you're using a TIMESTAMP column, which has automatic updating by
You are absolutely correct.. I did set it to timestamp by mistake!
-//Lucas
On Tue, 17 Jun 2003, Jennifer Goodie wrote:
> > After I set starttime to now(), anytime I run another update query against
> > the row starttime changes to a new value.
>
> If starttime is the timestamp data type, and th
[EMAIL PROTECTED]
cc:
Subject:re: now() function not working with load data infile
On Tuesday 24 December 2002 10:30, [EMAIL PROTECTED] wrote:
> I've created a test table with two columns. The first
> one is a varchar type for inputting first names. The
> second column is dat
On Tuesday 24 December 2002 10:30, [EMAIL PROTECTED] wrote:
> I've created a test table with two columns. The first
> one is a varchar type for inputting first names. The
> second column is datetime. The table will eventually
> expand to include a timestamp column, so I am not
> interested in g
At 9:36 -0800 12/19/02, Troy Kruthoff wrote:
> At 23:39 -0800 12/16/02, Troy Kruthoff wrote:
> >Description:
> Invalid reporting of date calc
>>How-To-Repeat:
> note: SESSIONTS is TIMESTAMP type
>
> SELECT (NOW()-SESSIONTS) FROM WEBSESSIONS;
What leads you to expect that t
> > At 23:39 -0800 12/16/02, Troy Kruthoff wrote:
> > > >Description:
> > > Invalid reporting of date calc
> > >>How-To-Repeat:
> > > note: SESSIONTS is TIMESTAMP type
> > >
> > > SELECT (NOW()-SESSIONTS) FROM WEBSESSIONS;
> >
> > What leads you to expect that this should yield any
At 23:39 -0800 12/16/02, Troy Kruthoff wrote:
>Description:
Invalid reporting of date calc
How-To-Repeat:
note: SESSIONTS is TIMESTAMP type
SELECT (NOW()-SESSIONTS) FROM WEBSESSIONS;
What leads you to expect that this should yield any useful result?
+---+
| (N
On Tuesday 17 December 2002 09:39, Troy Kruthoff wrote:
> Invalid reporting of date calc
>
> >How-To-Repeat:
>
> note: SESSIONTS is TIMESTAMP type
>
> SELECT (NOW()-SESSIONTS) FROM WEBSESSIONS;
> +---+
>
> | (NOW()-SESSIONTS) |
>
> +---+
>
> | 126
Keith Spiller wrote:
> I am trying to figure out how to use the NOW() function with a MySQL
> Insert command on a Timestamp field.
Okey, either use NOW() on the DATETIME field, or use TIMESTAMP field
without inserting there value.
> Here is my mysql command:
>
> INSERT INTO $tablename
> (sender,
> INSERT INTO $tablename
> (sender, recipient, whenread, whensent, subject,
> messagetext, folder, priority, condition)
> VALUES
> ('$directorid', '$SendTo', '00', NOW(), '$SetSubject',
> '$MessageText', 'Inbox', '$SetPriority', 'TO')
Easy as that!
j- k-
mysql, sql
--
Jo
> Over 45 MYSQL API (base) functions are now available for using in Microsoft
> VB,Excel,Word,Visio,Visual FoxPro...etc.Are over 20 examples to learning how
> you must use this API functions and how you can use multiple
> connection/query.
> Memory consumption is 2 kb.Performance guarantied (1700
No differences.
- Original Message -
From: "Ed Carp" <[EMAIL PROTECTED]>
To: "Gelu Gogancea" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, July 18, 2002 12:23 PM
Subject: RE: Now it
]>; "MYSQL"
> <[EMAIL PROTECTED]>
> Sent: Monday, May 13, 2002 9:13 AM
> Subject: Re: NOW()
>
>
> > curdate()
> >
> > - Original Message -
> > From: "Edilson Vasconcelos de Melo Junior" <[EMAIL PROTECTED]>
> > To: "
uot;Edilson Vasconcelos de Melo Junior" <[EMAIL PROTECTED]>; "MYSQL"
<[EMAIL PROTECTED]>
Sent: Monday, May 13, 2002 9:13 AM
Subject: Re: NOW()
> curdate()
>
> - Original Message -
> From: "Edilson Vasconcelos de Melo Junior" <[EMAIL PROTE
curdate()
- Original Message -
From: "Edilson Vasconcelos de Melo Junior" <[EMAIL PROTECTED]>
To: "MYSQL" <[EMAIL PROTECTED]>
Sent: Sunday, May 12, 2002 12:34 AM
Subject: NOW()
Hi,
I have a table with a timestamp field called dtins. When i insert a row to
the table, the value of this f
Hi,
Dave wrote:
> Dim intWeekID
> objRSWeekID.open "SELECT WeekID FROM WeekControl " & _
>" WHERE WeekStart < NOW() AND WeekEnd > NOW()", objConn
>
> intWeekID = objRSWeekID("WeekID")
>
> This fails to bring back a value for WeekID.
>
Just want to mention couple of things:
1. s
Big apologies.
The path to my connection file was wrong, so I was looking at the wrong
database.
*shuffles to the corner in embarrassment.
- Original Message -
From: "Dave" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 13, 2002 12:02 PM
Subject: NOW()
> Not sure this
On Fri, 10 May 2002, Paul DuBois wrote:
> At 12:06 +0100 5/9/02, Sandeep Murphy wrote:
> >Hi,
> >
> >What appears to be the problem with the fwg query:
> >
> >select code,date from multimedia_header where rubrica=87 and now() >
> >'08-03-2002 13:10:53' and date IS NOT NULL
> >
> >The records re
I'm not sure whether your question is about column types or the NOW()
function.
TIMESTAMP fields are defined as being automatically updated every time the
row is modified.
If you want a field which simply holds a "timestamp" which does *not* get
automatically updated, use a DATETIME or similar co
At 12:06 +0100 5/9/02, Sandeep Murphy wrote:
>Hi,
>
>What appears to be the problem with the fwg query:
>
>select code,date from multimedia_header where rubrica=87 and now() >
>'08-03-2002 13:10:53' and date IS NOT NULL
>
>The records returned includes those earlier than 08-03-2002 13:10:53 too.
Just to join ALL the records from ALL 15 tables together in one big blob of
data and have there be a something that tells me which table each record
comes from.
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: "Deryck Henson" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL P
]
> Sent: Sunday, July 29, 2001 6:27 PM
> To: dpowellLLC
> Cc: [EMAIL PROTECTED]
> Subject: RE: now() ?
>
>
>
> On 29-Jul-2001 dpowellLLC wrote:
> > Apologies as this question has probably been asked before.
> > I am new to mysql. I run it on Windows NT4.
l Message-
> From: Don Read [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, July 29, 2001 6:27 PM
> To: dpowellLLC
> Cc: [EMAIL PROTECTED]
> Subject: RE: now() ?
>
>
>
> On 29-Jul-2001 dpowellLLC wrote:
> > Apologies as this question has probably been asked before.
&
On 29-Jul-2001 dpowellLLC wrote:
> Apologies as this question has probably been asked before.
> I am new to mysql. I run it on Windows NT4. I am using version 3.23.39a.
> The function NOW() doesn't appear to work. Is there a fix?
> I've checked my computer and time zone, etc. Everything seems
On Sun, Jul 29, 2001 at 06:15:20PM -0400, dpowellLLC wrote:
> Apologies as this question has probably been asked before.
If you check the mail archives before posting, there's no reason to
aplogize.
> I am new to mysql. I run it on Windows NT4. I am using version
> 3.23.39a. The function NOW
Well, I dont know why, when I do that , it tries to
look in /usr/local/mysql, so i just put a symbolic
link there and everything seems to be OK.
Thanks all
--- Gerald Clark <[EMAIL PROTECTED]>
wrote:
> You forgot the
> mysql_install_db --user=mysql
>
> Mark Vann wrote:
>
> > Hey gang, I got th
You forgot the
mysql_install_db --user=mysql
Mark Vann wrote:
> Hey gang, I got the configure script to run with no
> errors and got it installed in the /opt directory by
> using the following.
>
> ../configure --with-named-z-libs=no --without-debug
> --with-mysqld-user=mysql --prefix=/opt/mysq
Complete tutorial on installing Mysql, PHP and Apache can be found on
www.devshed.com
Have fun.
B.
At 11:12 14-6-01 -0700, Mark Vann wrote:
>Hey gang, I got the configure script to run with no
>errors and got it installed in the /opt directory by
>using the following.
>
>./configure --with-
60 matches
Mail list logo
