Hi,
I am getting a lot of these ones after a power outage. I have a huge amount
of tables and databases on the server. Is there any automated way to check
the health of ALL databases and ALL tables? And maybe some automated way to
repair if problems?
Got error: 1016: Can't open file: 'guest
Your settings doesn't seem optimized much.
So here first question, do you use 32bits or 64 bits platform? If you
have 64 bits platform with 64 bits mysql and os you can boost most the
settings to use almost the 8G of ram you have on the server. If you are
using 32bits you will have to do some
Craig,
I am working on Martin Minka's date diff function as found
at http://forge.mysql.com/snippets/view.php?id=56. It is a beautiful
thing. However, I am trying to alter it or identify a similar function
that instead of giving me the number of days between two dates it
returns the number of w
At 5:44 PM -0700 8/27/07, Chris wrote:
I don't think this is a bug. I think what's
happening is that your timestamp column can't
hold that date, it's max value is somewhere in
2038.
So I guess either change your timestamp column
to a datetime column, or prevent users from
putting invalid da
> -Original Message-
> From: Chris [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 27, 2007 5:45 PM
>
> I don't think this is a bug. I think what's happening is that your
> timestamp column can't hold that date, it's max value is
> somewhere in 2038.
You appear to be correct, burried i
I don't think this is a bug. I think what's happening is that your
timestamp column can't hold that date, it's max value is somewhere in 2038.
So I guess either change your timestamp column to a datetime column, or
prevent users from putting invalid data in.
Daevid Vincent wrote:
using
Does anybody know what is the problem. MySql ran out of memory and I
have not been able to start it again. Here's an error from log file:
070827 15:09:17 mysqld started
^G/usr/sbin/mysqld: Character set 'utf8 |' is
not a compiled character set and is not specified in the
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 27, 2007 5:04 PM
> To: Daevid Vincent; 'MySQL General'
> Subject: Re: BUG: DATE_ADD 9 fails, but works.
>
> At 4:56 PM -0700 8/27/07, Daevid Vincent wrote:
> >using 9 as the DATE_ADD
At 4:56 PM -0700 8/27/07, Daevid Vincent wrote:
using 9 as the DATE_ADD interval value will result in 000-00-00 but
one less 9 will work.
root# mysql --version
mysql Ver 14.12 Distrib 5.0.41, for pc-linux-gnu (i686) using EditLine
wrapper
CREATE TABLE `Users` (
`CoreID` int(10) unsi
using 9 as the DATE_ADD interval value will result in 000-00-00 but
one less 9 will work.
root# mysql --version
mysql Ver 14.12 Distrib 5.0.41, for pc-linux-gnu (i686) using EditLine
wrapper
CREATE TABLE `Users` (
`CoreID` int(10) unsigned NOT NULL auto_increment,
`Username`
Justin wrote:
Sometimes I get about 300 connections to the server, all are selects
and all select and get the data returned but the connection doesn't go
away and the website doesn't load up.. usually if there is a lock, the
selects wait 2-3 secs and build up, but once unlocked the queries all
Hello all,
I am working on Martin Minka's date diff function as found
at http://forge.mysql.com/snippets/view.php?id=56. It is a beautiful
thing. However, I am trying to alter it or identify a similar function
that instead of giving me the number of days between two dates it
returns
Sometimes I get about 300 connections to the server, all are selects and all
select and get the data returned but the connection doesn't go away and the
website doesn't load up.. usually if there is a lock, the selects wait 2-3
secs and build up, but once unlocked the queries all are performed a
Olav Mørkrid wrote:
hello
does anyone know what is returned when you do a where column without
further parameters?
SELECT * FROM TABLE WHERE COLUMN;
for integer columns it seems to return non-zero columns, but for other
types of columns the results seemed unpredictable.
The value of the co
A read lock does not prevent other reads.
Rolando Edwards wrote:
SELECTs do lock the tables implicitly.
According to Page 400 (Section 28.1 : Locking Concepts) of MySQL 5.0 Certification Study
Guide (ISBN 0-672-32812-7), here is what the first bulletpoint says under the heading
"A lock on dat
sorry.. you're right.. that came out wrong.. actually shouldn't of even of
put that in there like that..
The locking is some other issue that I can't for the life of me remember
what the query was.. I know it wasn't an Update but it was copying to a tmp
table then sorting the result which was
SELECTs do lock the tables implicitly.
According to Page 400 (Section 28.1 : Locking Concepts) of MySQL 5.0
Certification Study Guide (ISBN 0-672-32812-7), here is what the first
bulletpoint says under the heading "A lock on data can be acquired implicitly
or explicitly":
For a client that doe
SELECTs don't lock the table. Are you having frequent UPDATEs while
selecting? That would be the reason for locks.
-jay
Justin wrote:
Ok.. Straight to the point.. Here is what I currently have.
MySQL Ver 14.12 Distrib 5.0.27
RHEL vs 5
584GB Raid 5 storage
8GB of RAM
and Dual 5130 processors
Ok.. Straight to the point.. Here is what I currently have.
MySQL Ver 14.12 Distrib 5.0.27
RHEL vs 5
584GB Raid 5 storage
8GB of RAM
and Dual 5130 processors (2.0GHz Intel Dual-Core Xeon)
what my question is.. is am I utilizing the servers potential with the
following as my settings. The serve
Hi! Comments inline.
Edoardo Serra wrote:
SELECT sum(usercost) FROM cdr WHERE calldate BETWEEN '2007-06-01
00:00:00' AND '2007-06-30 23:59:59'
If I run it on the MyISAM table, MySQL choose the right index (the one
on the calldate column) and the query is fast enough
If I run it on the Inno
Hi Jim -
I'm using MySQL on Fedora 6 as well, with no performance problems. Did not
need to do anything to speed it up on Fedora.
It's difficult to answer the question why one is faster than the other, as
there are any number of potential differences. Some more specifics about
your setup (hardw
Hi everybody,
I know this email is slightly off-topic for this list and I'm sorry
about that but I wanted as many people as possible to be aware of this
opportunity. If you are not looking for a job, please skip this email.
We have another open position in the MySQL Developer Tools Team that
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: root
To: mysql@lists.mysql.com
Subject: MySQL daemon fails to start
>Description:
mysqld fails with error
070827 10:5
Hello list,
I have a table whose 'default charset=utf8'.
I insert a record into it with non-utf8 charset,like GBK.Then I select
this record,it print GBK characters correctly.
Then I insert a utf8 record into it,and read this record in scripts and
decode it with utf8_decode,the result is also corre
24 matches
Mail list logo