Use indexes before thinking about partitions.
-Original Message-
From: Andrés Tello [mailto:mr.crip...@gmail.com]
Sent: Thursday, July 15, 2010 8:44 AM
To: mysql
Subject: Mysql 4 and or Partitions.
Ok... I solved my mistery of the slow 22G table rebuild the kernel to
support memory an
Michael Dykman wrote:
> One problem you might be having is the column named 'call'.. It's a
> keyword, so perhaps you might get away with backticking it?ie.
> `call`
>
> Also, you shouldn't need that final semi-colon inside your statement
> string.. I have had preparedstatement interfaces gi
Grant Peel wrote:
> Hi all,
>
> I recently migrated a script called perldesk from mysql 4 to mysql 5.
>
> When I envoke the script from the web, I am now getting an error. I suspect
> its a version syntax thing.
>
> Here is what I see:
>
> Couldn't execute statement: You have an error in your
- Original Message -
From: "Grant Peel"
To: "Michael Dykman"
Cc:
Sent: Sunday, July 11, 2010 9:25 PM
Subject: Re: Mysql 4 to 5
- Original Message -
From: "Michael Dykman"
To: "Grant Peel"
Cc:
Sent: Sunday, July 11, 2010 9:20 PM
- Original Message -
From: "Michael Dykman"
To: "Grant Peel"
Cc:
Sent: Sunday, July 11, 2010 9:20 PM
Subject: Re: Mysql 4 to 5
One problem you might be having is the column named 'call'.. It's a
keyword, so perhaps you might get away with backt
One problem you might be having is the column named 'call'.. It's a
keyword, so perhaps you might get away with backticking it?ie.
`call`
Also, you shouldn't need that final semi-colon inside your statement
string.. I have had preparedstatement interfaces give me grief about
that.
As I reca
At 4:12 PM -0800 3/5/08, Garris, Nicole wrote:
OK, what is wrong with the following statement? MySQL 4.1 doesn't like
my syntax ...
mysql> grant all privileges on *.* to [EMAIL PROTECTED] identified by
'myownpassword';
% needs quotes around it.
I recommend always quoting the username and hos
Nope, no backups happening at the time.
Anyone other ideas?
- John
At 11:42 AM -0500 6/12/06, Dan Buettner wrote:
Hi John -
Yes, at my former workplace, we had a couple of different instances
where we experienced severe crashing problems on G4-based machines.
Prior to using a G4 X
Hi John -
Yes, at my former workplace, we had a couple of different instances
where we experienced severe crashing problems on G4-based machines.
Prior to using a G4 Xserve, we were using a dual-G4 tower as our MySQL
and Intranet server, and as we ramped up MySQL usage, the hard crashing
got
John May wrote:
I've got an xserve running 10.3.9 and MySQL 4.0.27-max that is
restarting itself every 2-3 days. It appears that it is due to a kernel
panic, though I don't have direct access to the machine (colocated) to
verify when it occurs.
There are no crash.logs from MySQL, and watchdo
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
Joey wrote:
Is there a way to tell mysql 4 to defaul to the old style passwords instead
of having to run this every time we add a user?
SET PASSWORD FOR 'user'@'localhost' =
OLD_PASSWORD('passowordo');
Applications we develop in php, and phpMyadmin don't seem to work with the
new style passw
On Friday 03 June 2005 03:36 pm, Joey wrote:
> SET PASSWORD FOR 'user'@'localhost' =
> OLD_PASSWORD('passowordo');
Why not recompile php to work with 4.1?
--old-password
Jeff
pgpEctk2PnMK1.pgp
Description: PGP signature
El Sáb 07 Feb 2004 02:28, escribió:
> Mr. Alfredo
> Pls, will you give the complete structure as 'create query' of your
> database? that will help us to solve your problem.
> Pradap
This is the structure of the table that holds the sequential numbers for
various documents that need them:
CRE
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,
1.First generate un encrypted certificates. This can be done by using
an Open SSL library. The instructions are available at
http://www.mysql.com/doc/en/Secure_Create_Certs.html
Note: Here un encrypted certificates means certificates that are not
protected by any password. When MySQL code
Fine
Subject: RE: MySQL 4 Built in SSL?
What I have done is load putty on my WIN2K box.
Connect to the nix box - make sure authentication is correctly
configured
Launch mysql and work on it from the command line prompt
-Original Message-
From: Paul Fine [mailto:[EMAIL PROTECTED]
Sent
Don't compile mySQL for Solaris 9. The mySQL team has invested months of
work to get a very fast and stable static link of up-to-date libraries
from their downloadable binaries section. I find that they are more
stable and faster then the ones compiled by hand.
For Perl 5.8 goto sunfreeware.com a
[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,
Hi all
I've recently moved a database to MySQL from MSSQL, and am running it on
a Windows 2000 Server.
Can anybody advise me on the best method for running regular maintenance
tasks (i.e. optimize and analyze)?
First, I would question that you even need to optimize and analyze "on a
regular
My machine is a IRIX 6.5
Online Manual:
2.6.6.8 SGI Irix Notes
If you are using Irix Version 6.5.3 or newer mysqld will only be able
to create threads if you run it as a user with CAP_SCHED_MGT
privileges (like root) or give the mysqld server this privilege with
the following shell command:
shell>
On Fri, Feb 07, 2003 at 07:23:43PM +1100, Dan Rossi wrote:
> yes i am aware that sub selects are in 4.1, i'm pretty sure i have it
> running @ home, there are some large traffic sites i would like to lighten
> up and make a bit faster code wise with query caching and sub selects, but i
> havent be
quot;gamma" means ?
It's in the manual what MySQL AB means by alpha, beta, gamma:
http://www.mysql.com/doc/en/Which_version.html
-Original Message-
From: Josh Trutwin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 2:16 PM
To: [EMAIL PROTECTED]
Subject: Re: Mysql
ssage-
From: Josh Trutwin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 2:16 PM
To: [EMAIL PROTECTED]
Subject: Re: Mysql 4 production quality
> hi there i was wondering if mysql 4 will become production quality soon
> ? i would like to convince work to start using it, so i
On Wed, Feb 05, 2003 at 09:24:22PM +1100, Dan Rossi wrote:
> hi there i was wondering if mysql 4 will become production quality soon ? i
> would like to convince work to start using it, so i can start using the
> transactions, sub selects and query cache
We've been using various builds of 4.0.x in
In the last episode (Feb 05), Dan Rossi said:
> hi there i was wondering if mysql 4 will become production quality
> soon ? i would like to convince work to start using it, so i can
> start using the transactions, sub selects and query cache
Well, MySQL 3.23 already has transactions with the InnoD
> hi there i was wondering if mysql 4 will become production quality soon
> ? i would like to convince work to start using it, so i can start using
> the transactions, sub selects and query cache
I don't think MySQL 4.0 has sub-selects, that's 4.1.
I've been using 4.0 on two different ISPs for a
-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 formats applicable to
a
x, u will never have such problem
>From: Gerald Clark <[EMAIL PROTECTED]>
>To: xuefer tinys <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: MySQL-4.x GBK Problem with Binary Data
>Date: Fri, 20 Sep 2002 15:35:20 -0500
>
>Binary data is binary data.
>It do
Binary data is binary data.
It doesn't mattrer whether it is GBK or and audio file,
or a jpeg.
If you escape the data properly before inserting it you will get
back the same data you stored.
Your application must display it properly.
xuefer tinys wrote:
> re-posting multibyte problem.
>
> does
15
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: mysql 4 release
Matt Darcy wrote:
> Does anyone have any idea when Mysql 4 will be classed as stable.
>
>
> -
> Before posting, please check:
>http://w
Matt Darcy wrote:
> Does anyone have any idea when Mysql 4 will be classed as stable.
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list a
On Thursday, 23. May 2002 19:20, Olexandr Vynnychenko wrote:
Hi,
> Hey people, I'm using MySQL 3.23.49 now, but I'd like someone to tell
> me if I can use new MySQL 4. Is it very buggy? Is it safe enough to
> use not only at home? AFAIR it has some features 3.23 doesn't have.
> Thank's in advance.
What is it you are trying to accomplish with MySQL?
I have MySQL 4.0.1a running on WinNT 4.0 SP6a with Apache 2.0.36 and PHP
4.2.1. So far, in a development environment, MySQL 4.0.1 has done all I
have asked it to do (granted I am not doing anything at the edge of the
envelope).
Mike
- Orig
On Thu, May 23, 2002 at 08:20:13PM +0300, Olexandr Vynnychenko wrote:
>
> Hey people, I'm using MySQL 3.23.49 now, but I'd like someone to
> tell me if I can use new MySQL 4. Is it very buggy? Is it safe
> enough to use not only at home? AFAIR it has some features 3.23
> doesn't have. Thank's in
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?
> > > > > I would like to use MySQL 4.x,
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.
On Fri, Feb 22, 2002 at 08:29:03AM -0500, Anthony W. Marino wrote:
> On Friday 22 February 2002 02:15 am, Jeremy Zawodny wrote:
> > On Thu, Feb 21, 2002 at 08:07:39PM -0500, Anthony W. Marino wrote:
> > > Is there a timeline/status for 4.x functionality available?
> >
> > No. It'll be ready when
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 some of the
> > > > highly requested func
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 some of the
> > > highly requested functional
On Friday 22 February 2002 02:15 am, Jeremy Zawodny wrote:
> On Thu, Feb 21, 2002 at 08:07:39PM -0500, Anthony W. Marino wrote:
> > Is there a timeline/status for 4.x functionality available?
>
> No. It'll be ready when it's ready. :-)
>
> There are folks using 4.0.x in production and/or testing
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 and Views)
> > and would like 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
fall
On Thu, Feb 21, 2002 at 08:07:39PM -0500, Anthony W. Marino wrote:
> Is there a timeline/status for 4.x functionality available?
No. It'll be ready when it's ready. :-)
There are folks using 4.0.x in production and/or testing now. This
helps test the code and get folks comfortable enough with
Hi!
On Feb 07, Alain Fontaine - Consultant and developer wrote:
>
> <-- snip -->
> select
> BienID
> from
> biens
> where
> MATCH(Notes) AGAINST('+appartemen* -lux* -prop*' IN BOOLEAN MODE)
> <-- snip -->
>
> This does not produce the correct result, whereas this does:
>
> <-- snip -->
Hi!
On Feb 07, Alain Fontaine - Consultant and developer wrote:
>
> <-- snip -->
> select
> BienID
> from
> biens
> where
> MATCH(Notes) AGAINST('+appartemen* -lux* -prop*' IN BOOLEAN MODE)
> <-- snip -->
>
> This does not produce the correct result, whereas this does:
>
> <-- snip -->
Tony Bailey writes:
> I've been trying MySQL 4 alpha (Windows build) as I need UNION but can't work out
>how to get the query I
> need against the version without the union
>
[skip]
> 2)
> select count(docs.docid) as score, docs.docdate, docs.docid, docs.docsection,
>docs.docsubdir, docs.docm
dan writes:
> Towards the end of running the end of the configure script (./configure
> --prefix=/usr/local/mysql - and yes I know I can optimise better than
> this), I get:
>
> creating ./config.status
> creating Makefile
> sed: file conftest.s1 line 6: Unterminated `s' command
> creating os/M
At 8:52 PM +0200 9/26/01, Ralph Graulich wrote:
>Hi,
>
>
>just read about the UNION operator beging supported with mySQL 4. How far
>are those operators implemented yet? Will there be any chance that UNION
>ALL and INTERSECT will be supported, too?
UNION ALL is implemented; I don't think INTERSEC
>Hi
>
>I am not sure if you mean what I am thinking you mean.
>Lets say you have several input fields and you only
>want the output where ALL entries apply, you can manage that
>with the IF(match...against(), IF(match...against,0,0),0,0) -something like
>that - clause.
>At least thats worked for
53 matches
Mail list logo
