Hi Scott,
The configuration shows that you are using default mysql configuration with
very few enhancement. The enhancement must depends on the size of physical
memory available.
innodb_buffer_pool_size268M
It should be between 50% to 70% of your ram.
innodb_additional_mem_pool_s
On Tuesday 13 January 2009 07:23:52 am Krishna Chandra Prajapati wrote:
> Hi Scott,
>
> I believe something wrong with innodb parameters. It should be optimum. In
> your case it might be too high or too low. Take a look at log file size.
> Please send your show variables and show status data to rea
Hi Scott,
I believe something wrong with innodb parameters. It should be optimum. In
your case it might be too high or too low. Take a look at log file size.
Please send your show variables and show status data to reach at conclusion.
On Tue, Jan 13, 2009 at 3:35 AM, Scott Edwards wrote:
> All
You didn't say much about your workload, tuning or table, but...
Looks like you have a configuration problem, or slow disks, or InnoDB
contention problems.
You can get faster hardware, or make your log files or log buffer
bigger (but first figure out whether they're too small!), or figure
out wha
Now that was fun and educational. :-)
I like the third approach, but theres an added problem to the whole thing.
This query is just a part of a bigger search.
The tables, job and color and other fields, which will also be searchable. I
am trying to automate the whole process, i mean, the user see
Three solutions, the first one is not recommended I just showed it for
fun -- I think the last one is the most efficient:
mysql> show create table job \G
*** 1. row ***
Table: job
Create Table: CREATE TABLE `job` (
`job_id` int(10) unsigned
Sorry i replied from a different address. Heres the reply with some editing:
Got it to work perfectly, thanks, although it takes some time (CILS has
>150.000 records). There was no need for unique since all the results are
already surprisingly unique.
Thank you, it was a different way of doing th
Got it to work perfectly, thanks, although it takes some time (CILS has
>150.000 records). There was no need for unique since all the results are
already surprisingly unique.
Thank you, it was a different way of doing things. Well, different to me, at
least. :-)
In the meantime, i found an altern
Hopefully your CILS table is not too many rows...
select * from JOB, CILS as cyan, CILS as magenta
where cyan.num_of = JOB.num_of
and magenta.num_of = cyan.num_of
and cyan.color = 'cyan'
and magenta.color = 'magenta'
or something not unlike that...
You may want UNIQUE JOB.id_enc
> insert into user (user,host) values ('jeff','localhost');
> flush privileges;
> grant all on databaseName.* to jeff;
jeff = [EMAIL PROTECTED]
not [EMAIL PROTECTED]
So in your statement you should have used...
grant all on databaseName.* to [EMAIL PROTECTED];
>select user,host from
Ankur G35 Saxena wrote:
All I had to do was rpm -Uvh --nodeps
I have the MySQL AB RPMs running on Red Hat 9 just fine. I didn't have
to force them at all.
I suspect you had to force it because you had MySQL installed already.
The problem is, the Red Hat package is called "mysql", whereas the M
Hello.
> Hi, I am trying to install the latest version of MySQL(i am not sure
> 4.0.23?
Use 4.1.10a. See:
http://dev.mysql.com/downloads/
> Hi, I am trying to install the latest version of MySQL(i am not sure
> 4.0.23? currently in the office). The RH9 comes with some 3.2.xx
> vers
Thanks for helping brian, While I was going through some sites where
people had posted some trouble, I found this guy who had successfully
installed the server, client and dev package.
All I had to do was rpm -Uvh --nodeps
I am not sure of the --nodeps, but i think it was there, but in any
event,
Hi Michael,
Thx for your answer: About your feedback:
Current situation: I moved back to my working apache 2 / mysql 4.0/ php 4.3
installation after trying to compile mysql 4.1 from source this afternoon.
Which (after following the guidelines on mysql.com) returned in an error in
the configure
rik wrote:
Hello all
Sitting stuck in an upgrade to mysql 4.1, I thought this mailing list would be
a good idea to get help.
I've a php4/mysql application developed on a windows xp machine. Right now I
want to migrate this app to my linux machine. Since the app uses subqueries,
I need to upgrad
Try something like is:
select a.Name as PL_Name,b.Name as PC_Name,c.Name as PA_Name from
(select * from table1,table2 where table1.ID=table2.PL) a,
(select * from table1,table2 where table1.ID=table2.PC) b,
(select * from table1,table2 where table1.ID=table2.PA) c
where a.description=b.description
Wait, I see it now :)
-Original Message-
From: Luc Foisy
Sent: Wednesday, April 07, 2004 10:45 AM
To: [EMAIL PROTECTED]
Subject: RE: stuck with simple query. Plz have a look
I would like to ask a question here, just for my own knowledge. What is actually the
difference between
= Table1-1.PL
LEFT JOIN Table1 Table1-2 ON Table1.ID = Table1-2.PC
LEFT JOIN Table1 Table1-3 ON Table1.ID = Table1-3.PA
-Original Message-
From: Jim Page - EMF Systems Ltd [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 07, 2004 10:09 AM
To: gerald_clark
Cc: [EMAIL PROTECTED]
Subjec
You are correct Jim..
This is certainly not Cartesian.
"Jim Page - EMF Systems Ltd" <[EMAIL PROTECTED]>
04/07/2004 10:09 AM
Please respond to "Jim Page - EMF Systems Ltd"
To: "gerald_clark" <[EMAIL PROTECTED]>
cc: <
Forgive me, but it would be a cartesian product if there were no where
condition, I agree? It would return (size Table1)x(size Table2)^3 rows,
definitely not what Tariq wants. The query I supplied will return (size
Table2)x(1)^3 rows won't it? Or am I missing the point?
Jim
> >SELECT ta.Name,tb.Na
Jim Page - EMF Systems Ltd wrote:
SELECT ta.Name,tb.Name,tc.Name,Description
FROM Table2,Table1 ta,Table1 tb,Table1 tc
WHERE ta.ID=PL AND tb.ID=PC AND tc.ID=PA;
Should work
Jim
(This email has been scanned for viruses by www.emf-systems.com)
I t may work, but it may consume all ram and di
SELECT ta.Name,tb.Name,tc.Name,Description
FROM Table2,Table1 ta,Table1 tb,Table1 tc
WHERE ta.ID=PL AND tb.ID=PC AND tc.ID=PA;
Should work
Jim
(This email has been scanned for viruses by www.emf-systems.com)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To uns
I couldn't get the LOCAL option to work; even when I started mysql with
the --local-infile argument. After reading around in the manual I decided
to grant myself the FILE privilege since I am the only user on my computer
where I am teaching myself mysql.
On Friday, July 4, 2003, at 12:08 PM, Pa
At 11:27 -0500 7/4/03, Richard Grubb wrote:
I have mysql 3.23.49 on Mac OS-X 10.1.5 and am going through the
tutorial in the "MySQL Reference Manual" in Chapter 3.
I get an empty set with the following command:
SELECT * FROM pet WHERE birth >= "1998-1-1";
I have tried many variations which all
On Friday, July 4, 2003, at 12:27 PM, Richard Grubb wrote:
SELECT * FROM pet WHERE birth >= "1998-1-1";
Try: SELECT * FROM pet WHERE birth >= "1998-01-01";
You need 2 characters for the day and month fields.
___/
/
__/
/
/
Ed Leafe
http://leafe.com/
http://opentech.leafe
Hi, you may try:
SELECT DISTINCT portlet.*
FROM portletAssignment PortletAssignment,
portlet LEFT JOIN UserTabAssignment UTA
ON (portlet.name=UTA.portlet_fk AND UTA.user_fk = 'guest' AND
UTA.portal_FK = 'mysqlPortal' AND UTA.tabNumber = 0 AND
UTA.subtabName = 'firstSubtab'
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 11 Feb 2003, J. A. Tovey wrote:
> i am having no end of problems with installing mysql (any 3.23.*
> version) on linux.
>
> i started off on SuSe and received different errors, I am now trying
> with mandrake,
>
> The current error is that I h
Um - you would only ./configure if you have downloaded the source tarball - you have
the linux binary so you need to follow the instructions for binary installation.
DC
\"J. A. Tovey\" <[EMAIL PROTECTED]> wrote:
>
> hi,
>
> i am having no end of problems with installing
> mysql (any 3.23.* ver
Ian,
Sunday, April 28, 2002, 5:18:57 AM, you wrote:
IP> In reply to Egor's request...
Egor>> > Ian, show me the contents of your .err file (the last
IP> 20-40 rows)
IP> This is the total contents of this file.
IP> /nfs/usr/libexec/mysqld: ready for connections
IP> /nfs/usr/libexec/mysqld:
v" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 27, 2002 7:16 PM
Subject: Re: Stuck Some More
> Ian,
> Saturday, April 27, 2002, 2:31:28 AM, you wrote:
>
> IP> Mysql has not been used on my server before, and I am the only user
who has
> IP> ss
Ian,
Saturday, April 27, 2002, 2:31:28 AM, you wrote:
IP> Mysql has not been used on my server before, and I am the only user who has
IP> ssh access to the system, (any mysqld processes are mine) and have been
IP> trying to get mysql set up and working properly.
IP> Currenlty I have two mysqld p
Try to load MySQL with out --skip-grant-tables.
Then you can see what is in your pass word db..
Simon
-Original Message-
From: David Tomsett [mailto:[EMAIL PROTECTED]]
Sent: 14 September 2001 10:05
To: [EMAIL PROTECTED]
Subject: FW: Stuck!
Hi,
I'm moving my intranet to a new server. I
32 matches
Mail list logo
