Hi!
Roy == Roy Lyseng roy.lys...@sun.com writes:
cut
The question here is how PostgreSQL and ANSI does this and also what
is the logical interpretation of the number.
Roy ISO 9075 (ANSI SQL) is very strict about this. It only allows TIME
Roy literals with 3 or 4 digit groups, and it only
Hi!
Bernt == Bernt M Johnsen bernt.john...@sun.com writes:
Michael Widenius wrote (2009-01-24 02:07:54):
As Dmitri pointed out, we shouldn't deprecate '.' as substitute for
dates.
Another things is that we should stop making decisions about
incompatible changes without listening to the
Michael Widenius wrote:
Bernt We have a Norwgeian word for this helpfullness:
bjørnetjeneste, but Bernt I'm not sure what the english idiom would
be.
A disservice. In German Bärendienst.
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
* Michael Widenius mo...@mysql.com [09/01/30 14:53]:
Its more important that we don't break things for current users than
try to be concerned about possible wrong usage that no one seams to do
or find important enough to complain about.
Monty, I disagree with this statement. Our current users
Hi!
Konstantin Osipov wrote:
* Michael Widenius mo...@mysql.com [09/01/30 14:53]:
Its more important that we don't break things for current users than
try to be concerned about possible wrong usage that no one seams to do
or find important enough to complain about.
Monty, I disagree with
Robert,
keep the two databases separated,
that is on different mysql database (or schema as they are also called).
If the wordpress blog is on a database named 'wpblog' for example
import your dump in another newly created database.
Could just use those statement in the dump file
CREATE
Sorry if this seems to be a double post, but not sure if the mysql list send
yourself a copy (as I didn't get the 1st one). But a little has changed,
not much, but basically I have an old fc5 machine running mysql 4.1 and a
newer server running centos5 / mysql 5.0.45. The whole site is almost
I think he only has one DB, I guess that is a provider restriction...
On 1/30/09 8:52 AM, Claudio Nanni claudio.na...@gmail.com wrote:
Robert,
keep the two databases separated,
that is on different mysql database (or schema as they are also called).
If the wordpress blog is on a
IMO, offering a variety of input formats just creates one big mess.
How often have you read some date notation and wondered which format was
used - if all values are in the 1 to 12 range, you have to guess.
[JS] I agree 100%. I have to deal with dates from all over the world, and I
often have to
On Fri, Jan 30, 2009 at 9:32 AM, lance raymond lance.raym...@gmail.com wrote:
basically I have an old fc5 machine running mysql 4.1 and a
newer server running centos5 / mysql 5.0.45.
So, different hardware, different OS, different database server...
could be anything. I suggest you run EXPLAIN
MySQL Performance and Scalability Project - Issues and Opportunities
http://forge.mysql.com/wiki/MySQL_Performance_and_Scalability_Project_-_Issues_and_Opportunities
Next Thursday (February 5th), we're continuing our series of sessions on
MySQL performance measuring and improvements with Allan
creating product tablesdone (273 sec).
Can you tell us what queries this code actually executes? This doesn't
tell us too much ;)
Walter
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Fri, Jan 30, 2009 at 3:32 PM, lance raymond
A few weeks back I was reading an article that said that INNODB doesn't take
adantage of servers using more than 4 processors. I think I also recieved this
as a reply some time ago as to the same thing.
I was wondering if this is indeed true. We are using 5.1.30 and wanted to
pickup a new
I am banging my head.
First, is not a file permission problem.
I cant import data on some replication slaves either in binary, or from a
sql mysqldump.
I use one innodb file per table and I am importing only two databases on a
dozen.
After a few hours seem that the problem is with the name of
* check on your filesystem if the directory actually still exists - rmdir on
a nonexisting dir might throw a non-zero exit
* Take your db offline and do an fsck. If you want, you could flush tables
with read lock, then mount -oremount,ro and then fsck - that'll keep your db
up for reads, at least.
Olaf Stein olaf.st...@nationwidechildrens.org writes:
I think he only has one DB, I guess that is a provider restriction...
True. I would create a separate db for each application if I could.
rdc
--
Robert D. Crawford rd...@comcast.net
--
MySQL
Hi Johan,
dirs and files exist (also chmodded to 777)
the strange thing is that this behaviour is on more than one slave,
I think it is a bug related to the Information Schema and to the fact I
use innodb_file_per_table.
Not being able to drop a database is definitely a bug, it seems that
Gary,
I need to know a lot about your workload to say whether it will work
well on InnoDB with 4+ processors. You can check
http://www.mysqlperformanceblog.com/ for a lot of benchmarks in this
area. But in general, my opinion is that for most workloads, 4 total
processors (cores included) is
Hi Lance,
Please post specific queries and EXPLAIN output with the \G
terminator. It's likely your queries that are the problem, and
looking at 'ps' doesn't help you much.
On Fri, Jan 30, 2009 at 9:32 AM, lance raymond lance.raym...@gmail.com wrote:
Sorry if this seems to be a double post, but
You didn't get a response on this one because you didn't really ask
any questions :-)
Baron
On Thu, Jan 29, 2009 at 4:38 PM, lance raymond lance.raym...@gmail.com wrote:
Man, the forums are good, but lists are just so much easier! Anyway, I left
post unanswered now and I need to get this
Hi,
I am running mysql 5.0.32 on debian etch on a VPS. The /var/log/mysql
directory has grown to 5.8G, over 25% of the diskspace on my server.
Can the contents be deleted saftely?
Can mysql be configured to keep the log directory within, for example,
500mb (or whatever is considered
ok, cool. I was not sure if I could use logrotate with the mysql logs.
Is it safe to delete what I have there at the moment? I need to free
up some disk space.
On Sat, Jan 31, 2009 at 5:07 PM, Bazooka Joe fastf...@gmail.com wrote:
On Fri, Jan 30, 2009 at 7:54 PM, will will.va...@gmail.com wrote:
On Fri, Jan 30, 2009 at 8:13 PM, will will.va...@gmail.com wrote:
ok, cool. I was not sure if I could use logrotate with the mysql logs.
Is it safe to delete what I have there at the moment? I need to free
up some disk space.
this is what logrotate run before and after
[ -e
23 matches
Mail list logo