I know this may be strange, but have you turned on innodb on the box? Even
if don't use it? I have 8 amd64 boxes and have never experienced this
problem you are talking about. They range from single proc to quad proc.
Never this problem but all of them have innodb turned on.
Turn it on and se
Actually, I've done a test with this in the past, we could not find a limit.
But there is a magic number where the optimizer stops doing a good job of
optimizing the query and it starts to get really slow.
In our case we were using words, and phrases, so we would have something
like:
IN ('a', 'ap
Heikki,
I sent this to a few friends of mine who work on fedora quite a bit.
> As a general note, Fedora Cores are not considered stable.
None of them wanted to officially comment, but just asked that you show
proof. Especially since most of RH4 is Fedora.
I know I've used FC1, FC2, and FC3.
Kevin,
I am in the same boat that you are, I can't store anything in memory, just
have too much data. I've got 2tb on one box right now, I did get a quote
last week for that much memory, I think it was 4 million just for the
memory.
> Also.. if you have a high cache hit rate you can effectively h
With Mysql you should ONLY use RAID10. Everything else is not worth your
time.
As long as you are using 15k SCSI drives, on both your master and your
slave, your slave should rarely ever fall behind. Especially if you are
doing less than 1,000 inserts per second on the master. Otherwise you
s
I'm not sure but I know when I installed it yesterday via RPM it kept core
dumping and restarting. Glad I still had 4.1.11 available.
Donny
> -Original Message-
> From: Douglas K. Fischer [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 19, 2005 1:18 PM
> To: mysql@lists.mysql.com
> Subje
I have a new box that I am trying to install 4.1.1 on, and whenever I try to
use rpm to install either MySQL-shared-4.1.1-0.i386.rpm or
MySQL-shared-compat-4.1.1-0.i386.rpm. I get the dreaded messages below:
[EMAIL PROTECTED] src]# rpm -i MySQL-shared-compat-4.1.1-0.i386.rpm
warning: MySQL-shared
I figured out a little trick yesterday, I do not recommend it, but I did
work for me. I installed the rpm of MySQL-server, installed the client via
rpm, then when it came to the shared libraries. I went and downloaded the
binary build of MySQL then found the files I needed and put them in the
rig
Chris,
We have found the same thing, the more indexes you add the longer it takes
to add another index. This is because at least from what I understand is
the index/MYI file is recreated when you add another index.
I don't know enough about INNODB but based on what I do know you would do
much bet
Eve,
You can look at http://www.mysql.com/doc/en/Column_types.html
Or:
[NATIONAL] CHAR(M) [BINARY | ASCII | UNICODE]
A fixed-length string that is always right-padded with spaces to the
specified length when stored. The range of M is 0 to 255 characters (1 to
255 prior to MySQL Version 3.23). Tr
SELECT * FROM `support_start` WHERE (NOW() - (60*7)) > TO_DAYS(date)
Not the most optimized way of doing it, but it would work. 60 seconds in a
minute and 7 minutes is the example.
Donny
> -Original Message-
> From: Scott Haneda [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 28, 2
I'm using apache 2, and I'm not having any problems with it at all. It's a
little weird trying to get it configured the first time, but other than that
it's not bad. We have found that it can push a little more bandwidth and
the load seems to be a little lower than 1.x. But then again we are run
The biggest problem I see is that you are using a text field and you don't
have an index on it anyway. Maybe you should use a different field type and
index it. That should make it a little bit faster.
Donny
> -Original Message-
> From: Lancashire, Pete [mailto:[EMAIL PROTECTED]
> Sent:
Brian,
I know that I have been using 4.1.0 and 4.1.1 and when compared to 4.0.x,
4.1.x is much faster for us. We have been pushing over 3000 queries per
second with 4.1.1 without any problems. Now we aren't using utf8, but I
don't think that would really be the problem.
Donny
> -Original Me
Chris,
Another option is to use | instead of commas. Unless you have pipes in your
file. :)
Donny
> -Original Message-
> From: Dan Nelson [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 20, 2004 2:55 PM
> To: Chris Fossenier
> Cc: [EMAIL PROTECTED]
> Subject: Re: White Space
>
> In t
As a manager of over 20 programmers, I would say from a web point of via PHP
would be your best bet. Everybody who graduates today can program in Java,
and if they don't have any other skills I don't even interview them. I
consider Java programmers to be the MCSE of a few years ago.
Donny
> -
market you are in might only be looking for C
programmers, so you become a C programmer.
Just my opinion.
Donny
> -Original Message-
> From: Walt [mailto:[EMAIL PROTECTED]
> Sent: Sunday, February 22, 2004 7:52 PM
> To: Donny Simonton; 'Rhino'; [EMAIL PROTECTED
Set this in you're my.cnf and restart and see if that solves your problem.
open-files-limit=36864
*** Don't ask me what that number is, it's just a random number.
Donny
> -Original Message-
> From: Ken Menzel [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 23, 2004 10:20 AM
> To: Chr
Kevin,
As I mentioned earlier, set this in you're my.cnf and restart mysql. It has
helped me on many occasions.
open-files-limit=36864
Donny
> -Original Message-
> From: Kevin Marks [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 23, 2004 6:27 PM
> To: [EMAIL PROTECTED]
> Subject: Re
I'm about to pull my hair out on this one so I thought I would see if
somebody could point me in the right direction.
I have a subquery that like like so.
SELECT *
FROM Word
INNER JOIN DomainWord
USING ( word )
INNER JOIN Domain
USING ( domain )
WHERE Domain.domain = ANY(
SELECT Domain.domain
Can you send us a new explain on this version?
Donny
> -Original Message-
> From: karthik viswanathan [mailto:[EMAIL PROTECTED]
> Sent: Sunday, February 29, 2004 4:12 PM
> To: [EMAIL PROTECTED]
> Subject: Re: optimizing a select statement over a database with >50
> million recs
>
> here
me_id =56) to use IN.
It has proven to be much faster for me. But that won't speed it up .3
seconds.
Donny
> -Original Message-
> From: karthik viswanathan [mailto:[EMAIL PROTECTED]
> Sent: Sunday, February 29, 2004 5:41 PM
> To: Donny Simonton; 'karthik viswanath
ROTECTED]
> Sent: Sunday, February 29, 2004 6:46 PM
> To: Donny Simonton; 'karthik viswanathan'; [EMAIL PROTECTED]
> Subject: RE: optimizing a select statement over a database with >50
> million recs
>
> Here i
I started using 4.1.0 in a production environment 2 weeks after it was
released. Then when 4.1.1 came out I started using it before it was even
posted on the mysql.com website. And I am sure I will do the same with
4.1.2. Is it stable? Yes. Are there bugs? Depends on what you are doing,
but m
The problem is not a mysql problem, it's a php problem. It's probably
because you don't have register_globals = On. The new versions of php have
register_globals off by default. If you turn it on in the php.ini and
restart apache, I bet it will work.
Then again, I could just blame it on Novell
I think you would have to do one column at a time.
Like this.
Select * from QA where title is NULL;
Or you could get a little more crazy with something like this.
Select * from QA where (title is NULL) or (blabla is NULL) or (jimbob is
NULL) or (theskyisfall is NULL);
Donnny
> -Original M
Are you connecting from the local mysql command line client? Or from some
other box? I saw this happen once before, but we were using an old client.
Donny
> -Original Message-
> From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
> Sent: Saturday, November 06, 2004 4:06 AM
> To: [EMAIL PROTECT
Why would have to write not, when your keyword=a will not return b to begin
with?
But if this was really just an example you would do this.
SELECT data_id from table WHERE keyword = a AND keyword != b
Donny
> -Original Message-
> From: L a n a [mailto:[EMAIL PROTECTED]
> Sent: Saturday,
I think a lot of it has to do with the fact that 4.1 is now production and a
lot more people are now using it then before. So you are bound to have new
bugs crop up, or in some cases people think they are bugs and they just
haven't read the manual. You can see what's already been fixed for 4.1.8
Michael,
Normally I would let a fellow domain registrar fend for themselves, but I'm
feeling nice today. :)
Do a "show create table contacts" and see what the charset is set too.
I bet the character set on the slave is different. Are you running this
from the command line?
Or are you gett
Mos,
Personally, I never use like for anything. I would add a fulltext index
myself and call it a day. But that's me.
Donny
> -Original Message-
> From: mos [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 15, 2004 2:40 PM
> To: [EMAIL PROTECTED]
> Subject: Poor Select speed on simpl
Subject: RE: Poor Select speed on simple 1 table query
>
> At 03:32 PM 11/15/2004, Donny Simonton wrote:
> >Mos,
> >Personally, I never use like for anything. I would add a fulltext index
> >myself and call it a day. But that's me.
> >
> >Donny
>
>
nt: Monday, November 15, 2004 4:23 PM
To: Donny Simonton
Cc: [EMAIL PROTECTED]
Subject: Re: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) and Replication
Donny,
I certainly appreciate your help.
"show create table contacts" shows the same output on
Move this:
tries.status IN('running','waitkill','preemption'
to a where clause and remove it from the join.
Never actually tried to do a IN in a join before. I personally don't think
it should work.
Donny
> -Original Message-
> From: Sergei Golubchik [mailto:[EMAIL PROTECTED]
> Sent: Tu
I've got 3 amd64 machines running mysql. One with 32 gigs of memory and 2
with 16gigs. All of them are quad 848's. We use fedora core 2 on all of
our boxes.
2 of the boxes are pushing over 3000 queries per second. And one is over 4k
per second.
Personally, I have about 30 mysql boxes, and I
Andrew,
DO you have the slow query log turned on? What does one of your tables look
like and the one of the 8 queries you talk about? It very well could just
be a index problem.
And what is the size of the data.
Donny
> -Original Message-
> From: Andrew Nelson [mailto:[EMAIL PROTECTED]
I have a bunch of 4.1.7 boxes all running linux, some 32 bit and some 64 bit
and I've never experienced the problem you are having. Are you have the
problem if you connect from a remote linux box?
The final question, does the windows box have reverse DNS setup for it? If
not add it to the /etc/h
ation like on page 13,645 paragraph 12 or something so they won't
consider it a bug. But at least this way somebody else may know about the
problem.
Donny
> -Original Message-
> From: Frank Febbraro [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, December 07, 2004 3:09 PM
> To: D
It was probably attempting to do a reverse and nothing exists, so it just
has to timeout.
Donny
> -Original Message-
> From: Frank Febbraro [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, December 07, 2004 3:23 PM
> To: Donny Simonton; [EMAIL PROTECTED]
> Subject: Re: MySQ
> > What are some typical queires for a given schema?
> I have no idee thats the whole problem, its a propretaire product.
Nothing is proprietary when it comes to mysql, you can turn on the slow
query log which is the first thing, do you have it turned on? What is the
slow query set to? Are any
Aaron,
Three things.
1. Do a "show create table Offers_To_Buy"
2. And why in the world would you have force index(scdd) when your where
clause is on subcatID? If you can explain what you are trying to do, I'm
sure many people can help you get exactly what you are looking for.
3. Why so many in
Bryan,
Select count(*) is basically a different query then select locationid or any
of your fields. I have tables with way more than a billion rows of
information, I have some in innodb and some in myisam, and neither of them
when heavily loaded will take as long as yours is taking.
I recommend
Rob,
First of all I would say, your query is pretty badly laid out. First,
unless you need every fields from a table returned only ask for those
specific fields, and do you have an index on the combination of person_id +
session_start? If not, your query will always be slow.
But this is how I wo
The problem is not with phpmyadmin, the problem is with php. If you install
4.3 of php it will not work with mysql 4.1.8 or any version mysql 4.1 or
5.0. It will only work if you turn on the short passwords option in 4.1.
I've not tried it on 5.0 lately. You can get it installed but it takes a
l
What kind of box is this? According to you're my.cnf it looks like it's a
either a dual with hyperthreading or a quad box.
I don't see that you have your slow query log turned on, this should be the
first thing you should do in my opinion. This is what mine looks like.
### Slow Query Informat
rom: Fredrik Carlsson [mailto:[EMAIL PROTECTED]
> Sent: Sunday, January 02, 2005 5:18 AM
> To: Donny Simonton
> Cc: mysql@lists.mysql.com
> Subject: Re: Max connections being used every 10-12 day.
>
> It is a single PIII 500MHz, so i just changed thread_concurrency to 2
> :), than
checked the server 14 hours later (16:00) it still said
> that max_connections was full and mysqld was idling using 0% of the CPU,
> if the queries was queued up would'nt mysql at least show some activity?
>
> // Fredrik
>
> Donny Simonton wrote:
>
> >Frederick,
> >What
g (id)
where A.id=60 or B.parent=60
order by A.date
Donny
> -Original Message-
> From: Fredrik Carlsson [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 03, 2005 11:08 AM
> To: Donny Simonton
> Cc: mysql@lists.mysql.com
> Subject: Re: Max connections being used every 10-12 da
Attempt to connect to mysql via ip address, and make sure on the mysql box
that that you add the connecting boxes to your hosts file. Your problem
should go away then.
Donny
-Original Message-
From: Larry Lowry [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 22, 2005 9:25 PM
To: Peter
What does the error log say? Anything?
Donny
> -Original Message-
> From: Frank Denis (Jedi/Sector One) [mailto:[EMAIL PROTECTED]
> Sent: Friday, January 28, 2005 10:42 AM
> To: Mat
> Cc: mysql@lists.mysql.com
> Subject: Re: 2 gigs limits on MyISAM indexes?
>
> On Fri, Jan 28, 2005 at 0
Yes, if you are using a dynamic table which means it has varchar's, text, or
blobs the limit is 2 gigs. If you are using a fixed table which uses chars
only, then there is no limit that I have seen.
Donny
> -Original Message-
> From: J S [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 25,
Yep, modify the uid from a varchar to a char. It will make your table
bigger, because char uses all 10 characters. But it will allow you to get
past the 2 gig limit. It will take a while for the table to be modified
though. But it's definitely worth the wait.
Also personally I would change the
Matt,
I've been reading this thread for a while and at this point, I would say
that you would need to provide the table structures and queries that you are
running.
For example, we have one table that has 8 billion rows in it and it close to
100 gigs and we can hammer it all day long without any p
Have you tried using between instead of "<= =>"? We have found that between
in some cases works better than <>. Not saying it will make it use the
correct index.
Donny
> -Original Message-
> From: David Griffiths [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 30, 2004 9:35 PM
> To: MySQ
There is only one thread for replication on the slave. It does one step a
time. If you use mysqlbinlog on one of your binary files on your master,
you will see exactly how it all works.
Multi-threaded would probably cause thousands of problems. Unless it was
threaded per table, but that would s
I know that 2.6.7 works just fine with MySQL 4.0.20. I don't use Max
though.
Donny
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 16, 2004 12:11 AM
> To: Demetrios Stavrinos
> Cc: [EMAIL PROTECTED]
> Subject: Re: Kernel panic when mysql stop
This is not a mysql problem, it is a phpmyadmin problem. You must be using
2.6.0 rc1, download 2.6.0 beta 2 and you won't have the problem any more. I
have complained to them about it, but not exactly sure what they are going
to do.
Donny
> -Original Message-
> From: Martin Rytz [mail
Matt,
I know you have gotten a lot of recommendations, I have 3 for you that I
don't think anybody has mentioned.
1. Try a merge table. We had 1 table with about 750 million rows in it,
and every once in a while we would need to do something crazy to it and it
would be locked up for hours. We d
I've been using it since 4.1.0 was released. Works great for me. Wouldn't
use 4.0 or 3.x because it's missing so many features that 4.1 has. And we
have servers that use 4.0.x and 3.x and everytime I have to deal with them I
cringe.
We have one mysql server pushing over 3500 queries/second ri
As mysql will tell you, have your tried to use the mysql supplied binary or
the mysql supplied rpm? I bet that will solve your problems.
One thing I learned from mysql a long time ago, don't compile yourself
unless you absolutely have too.
Donny
> -Original Message-
> From: Mike Blaze
Luke,
As far as I know you can't do that in mysql, it would have to be at the
kernel level. Replication threads, really don't use much cpu anyway at
least not on the master, since all it's doing is basically reading a binary
file.
Now the kernel itself does do something like you are talking about
John,
>From my experience it is a lot more on how big is your data, not necessarily
the amount of data. Which version of mysql are you running? Are you using
a mysql prepared version (you downloaded it from mysql.com). I'm using
4.1.3 and I have a table that has a char 68 with 29 million rows th
Sergei,
I don't know much about innodb, but myisam doesn't have a 4 gig limit unless
you are using a dynamic type of table. If you are using a fixed table which
is by using int, char, etc... Not text, varchar, blobs.
As long as you don't use the last ones, you don't have a 4 gig limit.
As far
Todd,
I don't use Windows XP as a production machine, but I do run MySQL on my
personal machine running Windows XP, I run the Windows version of MySQL. Is
there any reason that you are using Cygwin to run MySQL when you can run the
MySQL windows binaries without any problems? The only thing I can
David,
I haven't ever attempted to delete the slave user on the master, and since I
only run replication on 4.1 boxes and not 4.0 boxes, I won't be able to help
much. But I would probably submit it to http://bugs.mysql.com and they can
verify that it is a bug. But they will probably not recommend
Start mysql on fc2 with
/etc/rc.d/init.d/mysql start
If that fails then look at the mysql error log.
Donny
> -Original Message-
> From: Danesh Daroui [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 02, 2004 3:04 PM
> To: [EMAIL PROTECTED]
> Subject: Installing MySQL 4.1 from RPM o
It would help if you would say how many entries do you have for changed =0
and how many are greater than 0.
Since changed is a timestamp you should never get an entry of 0. So the
query of changed>0 will always do a full table scan. This is definitely not
a bug.
Donny
> -Original Message--
etter solution for you.
Select changed from archived_stats where changed > DATE_SUB(NOW(), INTERVAL
1 DAY) order by changed DESC limit 0,1
Hope this helps.
Donny
> -Original Message-
> From: Dave Dyer [mailto:[EMAIL PROTECTED]
> Sent: Saturday, September 04, 2004 2:58 AM
> To: Da
Why not just do it like this. You will need to compare the results yourself
to make sure. But the numbers should be the same. And you don't have to do
a union.
select empssn,paycode_1,payrate_1 from paympe where paycode_1 != '000' or
paycode_2 != '000'
That might need to be an "and" and not an
Why not just add an index on touser+hidden. Problem solved.
Donny
> -Original Message-
> From: Dan Nelson [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 14, 2004 11:48 AM
> To: Dirk Schippers
> Cc: [EMAIL PROTECTED]
> Subject: Re: MySQL speed
>
> In the last episode (Sep 14), Dir
I can verify that a quad opteron 2.2 runs about a million times better than
a quad xeon 3.06. The opteron can handle more than 3 gigs of memory which
is a 32 bit limitation. Right now in my quad opteron we have 32 gigs of
memory and MySQL is using 16.8 gigs of the memory.
We run fedora core 2, w
quad opteron it's less than .25.
Donny
> -Original Message-
> From: Brian Abbott [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 14, 2004 4:32 PM
> To: [EMAIL PROTECTED]; 'Donny Simonton'
> Cc: 'Miles Keaton'
> Subject: RE: best-performing
You should change it to something like this:
Select * from posts group by user_id order by username, timestamp DESC
That should give you the last post.
Donny
> -Original Message-
> From: Darran Kartaschew [mailto:[EMAIL PROTECTED]
> Sent: Sunday, March 07, 2004 9:42 PM
> To: [EMAIL PROT
ORDER BY RAND(), just sucks in my opinion. We have created our own internal
randomization system because pretty much everytime you use it will show up
in the slow query log, because of the using temporary, using filesort it
does. Splitting your data into a hundred tables will still make it "using
really remember how well it works. Actually, I just tried this on
a table with 43 million entries and it took 0.0004 seconds.
Just some ideas.
Donny
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 08, 2004 2:36 PM
> To: Donny Simo
age-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
> Neil Gunton
> Sent: Monday, March 08, 2004 3:11 PM
> To: Donny Simonton
> Cc: [EMAIL PROTECTED]; 'MySQL'
> Subject: Re: ORDER BY RAND() performance
>
> Donny Simonton wrote:
> > One other
Michael,
Add this to you're my.cnf and then restart mysql. See if that solves your
problem.
open-files-limit=36864
Donny
> -Original Message-
> From: Michael Bacarella [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 08, 2004 4:52 PM
> To: [EMAIL PROTECTED]
> Subject: Re: "Can't create t
I've got a server with 24 gigs in it and it works just fine. About 3 with 8
gigs and a few with 2 gigs. All running 4.1.1. And all of them run without
any problems on Xeon's with Hyperthreading.
Donny
> -Original Message-
> From: Jigal van Hemert [mailto:[EMAIL PROTECTED]
> Sent: Tuesd
sary.
So --big-tables, has nothing to do with any limit.
Donny
> -Original Message-
> From: Peter J Milanese [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 09, 2004 7:32 AM
> To: Donny Simonton
> Cc: 'Jigal van Hemert'; [EMAIL PROTECTED]
> Subject: RE: mysql
er J Milanese [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 09, 2004 9:06 AM
> To: Donny Simonton
> Cc: 'Jigal van Hemert'; [EMAIL PROTECTED]
> Subject: RE: mysql 1gb memory limit?
>
> Donny-
>
> While I appreciate your bluntness, I did have this issue a time bac
I'd never actually tried that before, it definitely seems like a bug to me.
SELECT *
FROM WordScoreTemp
WHERE word = (
SELECT word
FROM Word
WHERE word = 'mysql' )
The above works fine.
SELECT *
FROM WordScoreTemp
WHERE word = (
SELECT word
FROM Word
WHERE word = 'mysql' ) order by score;
Chris,
Is it faster if you remove the 'IS NOT NULL'? I know that's not the results
you want, but we have found that is NOT NULL will do a full scan. But we
normally use it with a join. Since you are using one table, I'm not sure
how it would affect it.
Donny
> -Original Message-
> From
koy [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 09, 2004 1:25 PM
> To: 'Donny Simonton'; 'Jigal van Hemert'; [EMAIL PROTECTED]
> Subject: RE: mysql 1gb memory limit?
>
> Hi Donny,
>
> What server hardware do you use to support 24G RAM over 32-bits limit?
&g
And Chris, maybe now you can get rid of some of those single indexes and
drop the entire size down quite a bit.
Donny
> -Original Message-
> From: Chris Fossenier [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 09, 2004 6:48 PM
> To: 'Richard Davey'; [EMAIL PROTECTED]
> Subject: RE: Opti
SCSI, 15,000 RPM drives and a decent amount of memory 2-16 gigs. Dual procs
definitely do help; we have tried it with dual procs with hyperthreading and
without and with hyperthreading seems to be much faster.
Besides that, you can run it on any OS; we use Fedora, with Linux 2.6.x.
But that's o
Chris,
You would have to send the table structures including any indexes and also
the real queries.
It would also help if you would send an explain on your select statements.
100+ a minute is not much, I have one server currently doing:
Queries per second avg: 3157.235
Yes, that's per second, n
Personally, it's an unexpected flaw that I hope one day will be fixed. But
I'm not holding my breath, even though they seem to be planning for it. But
it could also be because of query-cache.
To benchmark something like this, you really need to add SQL_NO_CACHE to
your select statement to get ac
Another option is DB Designer 4, http://fabforce.net/dbdesigner4/ never
quite used it because I live by phpmyadmin, but I know a few people who use
it.
Donny
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 30, 2004 10:26 AM
> To: [EMAIL PR
Sami,
I run Fedora core 1 and haven't had any problems.
This is all you do if you want MySQL 4.1.1.
wget
http://www.mysql.com/get/Downloads/MySQL-4.1/MySQL-server-4.1.1-1.i386.rpm/f
rom/http://mysql.mirrors.pair.com/
wget
http://www.mysql.com/get/Downloads/MySQL-4.1/MySQL-client-4.1.1-0.i386.rpm/
Run mysqladmin extended-status
Look for something like this:
| Max_used_connections | 138|
If it says, 512 is your max connections that you have used, then you need to
raise it. If your number is much lower and you are getting that problem,
it's a different problem, but that's just
Steven,
In your case, you query doesn't even use an index. And you are using an
order by DESC. Now what I would recommend is something like this, change
your query just to test this out.
SELECT p.* FROM p_cat c, p_ad p WHERE p.cat = c.id AND c.lft
BETWEEN 4 AND 5 ORDER BY p.date DESC LIMIT 0,30
Everybody should remember as well, if you run rm -rf /*.* on your server you
will delete everything from your server, but linux will stay running. Even
though that's not documented either.
If you use a client like PHPMyadmin or one of the other 80 million that are
around you won't have to worry a
4.1.2 will probably not be beta or gamma. Not sure why. I've been using
4.1.1 in a production environment since it was released. I love it! We
still use 4.0.x or 3.23.x on some of our older stuff, and everytime I have
to use it I get aggravated. Once you use it and you find all of the
differen
Lou,
I normally download the html version of the manual and have a little search
feature just for it. And you are correct, I've looked for a few of your
examples and can't find any information on them besides you can turn them on
or off basically. Not in the mood to bust out the code to figure ou
You can always go to a mirror.
http://mysql.mirrors.pair.com/
Even though Jim, I think that's his name would probably like to know about
the problem.
Donny
> -Original Message-
> From: Brad Teale [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 21, 2004 7:37 AM
> To: 'Peter Burden'; L
I would bet 99.9% of the problem is you aren't using indexes.
Run an explain on your queries that will show you were the problem probably
is.
Donny
> -Original Message-
> From: Teus van Arkel [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 22, 2004 6:11 AM
> To: [EMAIL PROTECTED]
> Sub
Actually if you are using 4.1.x
INSERT INTO table (a,b,c) VALUES (1,2,3)
ON DUPLICATE KEY UPDATE c=3;
One of the best new features, because insert is faster than an update,
update is faster than a delete, and replace is the slowest command you can
run. These are based on my benchmarks about 6 mo
Use insert delayed, and you will cut your time in half. At least with my
experience. But also how long does it actually take to run the query
itself. Giving a summary explain doesn't help much. You really need a
table structure that the select is using and a full explain.
Donny
> -Origina
Cliff, still no explain still not table structure. Until that happens enjoy
the 5 hour club.
Donny
> -Original Message-
> From: Cliff Daniel [mailto:[EMAIL PROTECTED]
> Sent: Saturday, April 24, 2004 6:41 PM
> To: Donny Simonton
> Cc: 'Tim Cutts'; [EMAIL PROTE
Here are a few examples of my tables. Table name, # of records, type, and
size. The database currently has 898 million records in it and it's right
over 100 gigs.
Phrase49,769,178 MyISAM5.3 GB
Volume9,671,996 MyISAM1.1 GB
Word7,790,076 MyISAM942.2 MB
WordMagic12
1 - 100 of 124 matches
Mail list logo
