Willy wrote:
Hello,
I have a MyISAM table:
CREATE TABLE `dlr` (
`msisdn` varchar(20) NOT NULL default '',
`source` varchar(20) NOT NULL default '',
`operator_id` varchar(20) NOT NULL default '',
`sms_message` longtext NOT NULL,
`smsc_id` varchar(20) NOT NULL default '',
`sms_id` varc
Hello,
I have solved this problem, thanks.
Regards
Willy
- Original Message -
From: Willy
To: mysql@lists.mysql.com
Sent: Wednesday, July 12, 2006 8:55 AM
Subject: datetime issue on MySQL 4.x
Hello,
I have a MyISAM table:
CREATE TABLE `dlr` (
`msisdn` varchar
Hello,
I have a MyISAM table:
CREATE TABLE `dlr` (
`msisdn` varchar(20) NOT NULL default '',
`source` varchar(20) NOT NULL default '',
`operator_id` varchar(20) NOT NULL default '',
`sms_message` longtext NOT NULL,
`smsc_id` varchar(20) NOT NULL default '',
`sms_id` varchar(250) NOT NU
HALIL DEMIREZEN wrote:
Michael,
Thank you and all for effort to help.. I solved the problem by giving high
limit numbers such as;
(select * from tablea where item=1 order by rand() limit 0, 1)
union all
(select * from tablea where item != 1 order by rand() limit 0,
1);
--
>
>
>
>
> Gleb Paharenko <[EMAIL PROTECTED]>
> 05.12.2005 12:19
>
> To
> mysql@lists.mysql.com
> cc
>
> Subject
> Re: About union sql Mysql 4.x
>
>
>
>
>
>
> Hello.
>
>
>
46
To
HALIL DEMIREZEN <[EMAIL PROTECTED]>
cc
Gleb Paharenko <[EMAIL PROTECTED]>, mysql@lists.mysql.com
Subject
Re: About union sql Mysql 4.x
HALIL DEMIREZEN wrote:
> Hi,
>
> I am trying to run an sql query such as below to list items=x randomly
and
> then items
HALIL DEMIREZEN wrote:
> Hi,
>
> I am trying to run an sql query such as below to list items=x randomly and
> then items != x randomly..
>
>
> mysql> (select * from tablea where item=1 order by rand()) union all
> (select * from tablea where item != 1 order by rand());
>
> but the result is not a
]
---
Gleb Paharenko <[EMAIL PROTECTED]>
05.12.2005 12:19
To
mysql@lists.mysql.com
cc
Subject
Re: About union sql Mysql 4.x
Hello.
>From http://dev.mysql.com/doc/refman/5.0/en/union.html:
"ORDER BY for individual SELECT sta
Hello.
>From http://dev.mysql.com/doc/refman/5.0/en/union.html:
"ORDER BY for individual SELECT statements within parentheses has an
effect only when combined with LIMIT. Otherwise, the ORDER BY is
optimized away."
Therefore you're getting the same results, because ORDER BY doen't
wor
Hi,
I am trying to run an sql query such as below to list items=x randomly and
then items != x randomly..
mysql> (select * from tablea where item=1 order by rand()) union all
(select * from tablea where item != 1 order by rand());
but the result is not as expected. rand() seems not to be wo
PD Inc. has open-sourced their "compatibility RPM" that enables system
administrators to install MySQL 4.x on Red Hat Enterprise Linux (RHEL3)
Operating System with minimal impact.
Baltimore -- August 1, 2005 -- PD Inc. today announced the release of
their MySQL-shared compat RPMs for R
Hello.
You have several problems and they're should be resolved step by step.
First fix the problems with permissions. Usually they're solved by
changing the owner of mysql database to mysql user. Check what's wrong
with /var/log/mysqld.log. It might be necessery to create it manually.
Why a
Hi,
Im using : mysqlclient10-3.23.58-6
,mysql-server-4.1.11-2,mysql-4.1.11-2 On fedora 3.
when i run the following command its gives Error:
[EMAIL PROTECTED] etc]$ /etc/init.d/mysqld start
touch: cannot touch `/var/log/mysqld.log': Permission denied
chmod: changing permissions of `/var/log/mysqld.
Reto Baumann wrote:
Is there a way to see if the key buffer size was ever reached?
It's not really an issue. You can determine how frequently it
has the needed index data in memory, to judge the key buffer
efficiency.
Key read requests 3518220013
Key reads 94807
Key reads / Key
Hi all
I have a MySQL installation running on a Pentium3 based system with 2GB RAM... The
database primarily uses MyISAM tables with 60% SELECT statements. The database is used
as a backend for a PHP web application.
Do the following values make any sense?
set-variable= key_buffer=200M
set-
Hi gang
as subject says ... I've got a pretty weird situation. For all users I
create in the 'user' table in 'mysql' DB, if I set a password, that user
becomes unable to access any DBs ... it doesn't matter if I set the pw as
ASCII or password, still won't allow access...
I've tried making new
On Thursday, October 16, 2003, at 01:36 PM, Jeremy Zawodny wrote:
On Wed, Oct 15, 2003 at 06:35:03PM -0400, Gabriel Ricard wrote:
On Wednesday, October 15, 2003, at 03:10 PM, Jeremy Zawodny wrote:
I'd be interested to know if you can get a test running that uses
either a key_buffer or an innodb
If memory serves, adjustments to the OS need to be made to take advantage of
the 64-bit memory addressing. I know some changes have been made to OS X to
run on a 64-bit chip, but I'm not certain they've made enough modifications
to take advantage of the memory addressing.
I'd be interested to see
On Wed, Oct 15, 2003 at 06:35:03PM -0400, Gabriel Ricard wrote:
>
> On Wednesday, October 15, 2003, at 03:10 PM, Jeremy Zawodny wrote:
>
> > I'd be interested to know if you can get a test running that uses
> > either a key_buffer or an innodb_buffer_pool in the 3.5GB range.
>
> Interestingly e
Gabriel Ricard wrote:
>
>On Wednesday, October 15, 2003, at 03:10 PM, Jeremy Zawodny wrote:
>
>>I'd be interested to know if you can get a test running that uses
>>either a key_buffer or an innodb_buffer_pool in the 3.5GB range.
>
>Interestingly enough, I can't seem to get MySQL to use more than
On Wednesday, October 15, 2003, at 03:10 PM, Jeremy Zawodny wrote:
I'd be interested to know if you can get a test running that uses
either a key_buffer or an innodb_buffer_pool in the 3.5GB range.
Interestingly enough, I can't seem to get MySQL to use more than 2GB of
RAM.
I get errors like th
On Wednesday, October 15, 2003, at 03:10 PM, Jeremy Zawodny wrote:
On Wed, Oct 15, 2003 at 11:04:47AM -0400, Gabriel Ricard wrote:
I am currently testing this on a new dual 2GHz G5 with 4GB of RAM.
Seems pretty nice so far. I've loaded up a copy of our production
database (4GB of data for real es
On Wed, Oct 15, 2003 at 11:04:47AM -0400, Gabriel Ricard wrote:
> I am currently testing this on a new dual 2GHz G5 with 4GB of RAM.
> Seems pretty nice so far. I've loaded up a copy of our production
> database (4GB of data for real estate web sites) and moderate property
> search queries of ou
On Wed, Oct 15, 2003 at 11:02:12AM -0700, Dathan Vance Pattishall wrote:
> Wouldn't code need to be added for mySQL to take advantage of memory
> mapping in a 64 bit system? I was under the impression that mysql in its
> current form has specific code to emulate the behavior thus the problem
> of m
r and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, October 14, 2003 11:13 PM
-->To: [EMAIL PROTECTED]
-->Subject: Anyone using MySQL 4.x on Apple's G5
Adam wrote:
Wow, new dual processor G5... drool
How are the bulk operations performing?
-Original Message-
From: Gabriel Ricard [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 11:05 AM
To: [EMAIL PROTECTED]
Subject: Re: Anyone using MySQL 4.x on Apple's G5?
I am current
Wow, new dual processor G5... drool
How are the bulk operations performing?
-Original Message-
From: Gabriel Ricard [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 11:05 AM
To: [EMAIL PROTECTED]
Subject: Re: Anyone using MySQL 4.x on Apple's G5?
I am currently testing
I am currently testing this on a new dual 2GHz G5 with 4GB of RAM.
Seems pretty nice so far. I've loaded up a copy of our production
database (4GB of data for real estate web sites) and moderate property
search queries of ours run much faster than on our dual G4 MDD
PowerMac. I guess we're real
If so, how is it working out? Are you taking advantage of the
64bit memory space?
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 31 days, processed 1,151,820,403 queries (426/sec. avg)
--
[EMAIL PROTECTED] wrote:
>
> I think there is a bug in mysql 4:
>
> select week("2003-08-15") from po.orders limit 1;
>
> produces: 32
>
> after:
>
> set session default_week_format=3;
>
> it produces: 33 (which is correct in the Netherlands)
>
> The documentation states:
>
> set global de
Hi all,
I think there is a bug in mysql 4:
select week("2003-08-15") from po.orders limit 1;
produces: 32
after:
set session default_week_format=3;
it produces: 33 (which is correct in the Netherlands)
The documentation states:
set global default_week_format=3; (As root!)
This command sho
Mario Ohnewald <[EMAIL PROTECTED]> wrote:
> I want to import a MySQL 3.x Databse to my new shiny MySQL4.x.
> I did a backup with
> /usr/local/mysql-standard-4.0.14-pc-linux-i686/bin/mysqldump -u root -p --opt -A >
> mysql_lamp_backup.`date '+%Y.%m.%d'`.sql
>
> And i tried to import it to MySQL4.x
Hello!
I want to import a MySQL 3.x Databse to my new shiny MySQL4.x.
I did a backup with
/usr/local/mysql-standard-4.0.14-pc-linux-i686/bin/mysqldump -u root -p --opt -A >
mysql_lamp_backup.`date '+%Y.%m.%d'`.sql
And i tried to import it to MySQL4.x with:
/usr/local/mysql/bin/mysql -u root -p <
; from != end ; from++)
{
#ifdef USE_MB
int l;
if (use_mb_flag && (l = my_ismbchar(charset_info, from, end)))
{
while (l--)
*to++ = *from++;
from--;
continue;
}
#endif
=
notice that USE_MB(it exists in older version, all mysql 4.x)
it use connection
Anyone know where I can find a compiled version of mysql 4.x for debian linux?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
I have been using the MySql 4.x MAX with absolutely
NO problems. It's being used on heavily operated servers,
and I upgraded to 4.x for it's incredible index speeds and
it's VERY reliable to me.
In fact, in our local benchmarks it's kicking the living crap out
of Oracle on sq
On Tue, Nov 12, 2002 at 11:11:26AM +0800, Jaime Teng wrote:
> Hi,
>
> How stable is the new MySQL 4.x?
>
> I've read some really nice and powerful stuffs with MySQL 4.
> x and surely like to use them.
>
> Is this still in the 'use at your own risk'
Hi,
How stable is the new MySQL 4.x?
I've read some really nice and powerful stuffs with MySQL 4.
x and surely like to use them.
Is this still in the 'use at your own risk' stage?
or is it stable enough for use already?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 06 November 2002 20:48, Jeremy Zawodny wrote:
> Actually, you should work with the current mysql maintainer for
> Debian. I'm sure he'd be thrilled to have official help from MySQL
> AB.
Of course I would not mind helping and assisting
On Wed, Nov 06, 2002 at 11:44:03AM +0100, Lenz Grimmer wrote:
>
> Yes, we plan to add more package formats apart from tarballs in the
> future, it's on my TODO. Debian packages are quite high on the
> priority list there, but I don't know, when I will be able to start
> with it - I have a lot of R
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 06 November 2002 11:20, andy thomas wrote:
> > Does MySQL AB plan to release deb paketes or will
> > MySQL AB support or encourage the debian pakete maintainers?
>
> I think MySQL policy is to support generic packaging formats applicable
On Wed, 6 Nov 2002, von Boehn, Gunnar wrote:
>
> Hello,
>
> what is the status of MySQL 4.x for debian?
>
> Does MySQL AB plan to release deb paketes or will
> MySQL AB support or encourage the debian pakete maintainers?
I think MySQL policy is to support generic packaging
Hello,
what is the status of MySQL 4.x for debian?
Does MySQL AB plan to release deb paketes or will
MySQL AB support or encourage the debian pakete maintainers?
Best regards
Gunnar
-
Before posting, please check:
http
it's true that mysql-4.x process binary data well when not using multi-byte
charset
but mysql-4.x process it differently when using multi-byte
it's only for GBK text escaping, which is not suitable for binary data
that's the key point
if u don't use multi-byte, and mysql-4.
>
> does anyone have problem with binary data in MySQL-4.x using GBK
> charset or any other multibyte charset?
> inserting/updating/replacing
>
> the full description is in mysql mailing list archive, sent by me
> will not repost full desc until someone have
re-posting multibyte problem.
does anyone have problem with binary data in MySQL-4.x using GBK charset or
any other multibyte charset?
inserting/updating/replacing
the full description is in mysql mailing list archive, sent by me
will not repost full desc until someone have or care this
On Sunday 24 February 2002 06:26 pm, Arjen Lentz wrote:
> Hi Anthony,
>
> On Fri, 2002-02-22 at 23:43, Anthony W. Marino wrote:
> > > On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote:
> > > > > Is there a timeline/status for 4.x functionality available?
> &
On Fri, Feb 22, 2002 at 08:59:41AM +, [EMAIL PROTECTED] wrote:
>
> I would like to second this request. I *really* want the replication
> failover functionality targeted for "4.x". In fact, if it isn't
> going to arrive by, say, midsummer, I will have to develop my own
> failover solutions.
date for beta?
If I was *forced to guess*, I'd expect it in April or May. But I
might be pleasantly surprised (and proven wrong).
> > > I would like to use MySQL 4.x, however, I'm looking for some of
> > > the highly requested functionality (ie; subselects, SP's
Hi Anthony,
On Fri, 2002-02-22 at 23:43, Anthony W. Marino wrote:
> > On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote:
> > > > Is there a timeline/status for 4.x functionality available?
> > > > I would like to use MySQL 4.x, however, I'm looking for s
On Friday 22 February 2002 06:26 am, Arjen Lentz wrote:
> Hi Alec,
>
> On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote:
> > > Is there a timeline/status for 4.x functionality available?
> > > I would like to use MySQL 4.x, however, I'm looking for so
.x in production and/or testing now. This
> helps test the code and get folks comfortable enough with it to go
> from alpha to beta to gamma to stable.
Well, any idea on a date for beta?
> > I would like to use MySQL 4.x, however, I'm looking for some of the
> > highly reque
Hi Alec,
On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote:
> > Is there a timeline/status for 4.x functionality available?
> > I would like to use MySQL 4.x, however, I'm looking for some of the
> > highly requested functionality (ie; subselects, SP's, triggers a
> Is there a timeline/status for 4.x functionality available?
> I would like to use MySQL 4.x, however, I'm looking for some of the
highly
> requested functionality (ie; subselects, SP's, triggers and Views) and
would
> like to know where/when in the sequence of things tod
rtable enough with it to go
from alpha to beta to gamma to stable.
> I would like to use MySQL 4.x, however, I'm looking for some of the
> highly requested functionality (ie; subselects, SP's, triggers and
> Views) and would like to know where/when in the sequence of things
> t
Is there a timeline/status for 4.x functionality available?
I would like to use MySQL 4.x, however, I'm looking for some of the highly
requested functionality (ie; subselects, SP's, triggers and Views) and would
like to know where/when in the sequence of things todo does everything
Hi. I have been awayv for a while. I see that 3.23 is still listed as the
current distribution version. When might one expect that 4.X will be released
as a production version?
MySQL, versions
-
Before posting, please c
57 matches
Mail list logo
