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
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
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
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
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
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
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
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 does
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
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
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
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
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
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
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`
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)
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
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
-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 interval
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
-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 in the
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
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
23 matches
Mail list logo