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
Subject:
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
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
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.
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
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',
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
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:
)
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 day.
mysql describe art
[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
:), thanks
The slow query log don't show that many slow
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 exactly are you trying to accomplish? Personally, I don't recommend
using union unless absolutely necessary, since most people
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
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
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
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
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
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
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: Donny Simonton; [EMAIL PROTECTED]
Subject: Re
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: MySQL 4.1.7 Network slowdown
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'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
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:
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
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 simple 1
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
Donny,
Unfortunately I can't. The query must return all rows that
*start
, 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 both the master
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,
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 PROTECTED]
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
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), Dirk
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,
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 CPU + platform for MySQL now? Opteron?
OpenBSD? SuSE
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
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: Dan Nelson
Cc: Donny
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 changed0 will always do a full table scan. This is definitely not
a bug.
Donny
-Original
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 on
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
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
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
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
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
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
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
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 Blazer
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
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
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
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: MySQL List
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
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
Russ,
We use #2 currently, and we are actually about to switch back to the
inserting them one at a time. The reason is very simple. In our case we
have a insert statement that will insert a maximum of 600 entries at a time.
But we could have up to 25 different programs running that could
1. The timeout is set to 5 min, because of the number of queries, there
are a lot of unused http processes that linger with connections, and the
only way to seeminly keep MySQL connections available is to keep
timeouts short.
What about using a connection-pool?
Like Apache::DBI.
It
I definitely don't see this in the documentation anywhere, but can you drop
multiple indexes at one time with an alter table?
Donny
Donny Simonton [EMAIL PROTECTED] wrote on 01/06/2004 03:12:43:
We have been using 4.1 in a production environment since about a month
after
4.1.0 was released. And we have run into a bug or two now and then, but
that usually happens the first day we try something out. Overall, I
won't
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 01, 2004 7:39 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: 4.1 Beta
But then I would have to do without the excellent MySQL support.
Donny Simonton [EMAIL PROTECTED
Rpm -U xxx
-Original Message-
From: Larry Lowry [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 01, 2004 9:55 AM
To: [EMAIL PROTECTED]
Subject: Upgrade 4.1.1 to 4.1.2
I'm running 4.1.1 on RH 9. I want to upgrade this
to 4.1.2. I'm using the rpm from the MySQL site.
If
It depends on which version of MySQL you are using. Since you are using a
subquery, I assume you are using a fairly new version.
Delete audit_log_records from audit_log_records, audit_log where
audit_log_records.tracker_id = audit_log.tracker_id and
audit_log.operation='A'
That should be it.
Peter,
Actually,
Mysql -uUSERNAME -pPASSWORD works just fine.
Donny
-Original Message-
From: Sunmaia [mailto:[EMAIL PROTECTED]
Sent: Monday, May 31, 2004 7:44 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Root users permissions not working
hi
this may be the
Jonathan,
I have no idea, but I can tell you about the stability of the 4.1 tree from
my experience. If you are using MySQL for anything besides prepared
statements, I would say don't worry if it's beta or not. It works and works
great! The only reason I mention anything about prepared
Now the fun part becomes which linux distro do you use? Which is faster?
Because trust me, each distro will benchmark differently.
Let the games begin!
Donny
-Original Message-
From: JG [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 29, 2004 4:34 PM
To: [EMAIL PROTECTED]
Subject:
Jose,
First I would recommend fixing your site.
Warning: main(db/db.php): failed to open stream: No such file or directory
in /home/uc0208ea/public_html/mainfile.php on line 77
Fatal error: main(): Failed opening required 'db/db.php'
(include_path='.:/usr/lib/php:/usr/local/lib/php') in
Wait until 4.1.2 is out in the next few days. I've been using it since
4.1.0, besides a few little bugs here and there, which almost every version
has, it's very stable. I won't install any other version of any of my
machines.
Donny
-Original Message-
From: Marc Greenstock
]
Subject: Re: Is MySQL 4.1 ready?
Wait until 4.1.2 is out in the next few days. - Do you know where I can
find any indication of when 4.1.2 is expected to be released?
Marc.
Donny Simonton [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Wait until 4.1.2 is out in the next few
Sounds like a tmp drive issue to me. Maybe you had reiserfs on your old tmp
partition and now you have ext3 or something like that.
Donny
-Original Message-
From: Charles, Tony (Exchange) [mailto:[EMAIL PROTECTED]
Sent: Friday, May 21, 2004 12:47 PM
To: [EMAIL PROTECTED]
Subject:
I have this same problem on 4.1.1 as well.
Donny
-Original Message-
From: Steven Roussey [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 20, 2004 7:33 PM
To: [EMAIL PROTECTED]
Subject: thread stack issues
Since going from 4.0.18 to 4.0.20 (or 4.0.19) I now receive these warnings
We have a MySQL server that is a backend processing server that in about 60
days will probably run out of disk space. The data cannot be archived off,
because it is always used and changed many times a day. The server
currently has 6 72 gig SCSI 15k drives in it. We have it raided with 2
drives
Let's see if I can give you some ideas.
-Original Message-
From: RV Tec [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 18, 2004 8:28 AM
To: [EMAIL PROTECTED]
Subject: MySQL limits.
We have a database with approximately 135 tables (MyISAM).
Most of them are small, but we have 5
Actually, if you are using 4.1.1 optimize table does get passed to the
slave. This is from the 4.1.1 change log.
ANALYZE TABLE, OPTIMIZE TABLE, REPAIR TABLE, and FLUSH statements are now
stored in the binary log and thus replicated to slaves. This logging does
not occur if the optional
It surprised me at first, but then I was actually happy about it.
Donny
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Friday, May 14, 2004 4:26 PM
To: Donny Simonton
Cc: [EMAIL PROTECTED]; 'Jim'
Subject: Re: OPTIMIZE TABLE and mySQL replication
On Fri
Yes.
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Friday, May 14, 2004 4:26 PM
To: Donny Simonton
Cc: [EMAIL PROTECTED]; 'Jim'
Subject: Re: OPTIMIZE TABLE and mySQL replication
On Fri, May 14, 2004 at 03:26:28PM -0500, Donny Simonton wrote:
Actually
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
WordMagic
Kevin,
I've been using 4.1.1 since it was released and I've never heard of compiled
queries. Are you talking about prepared statements?
Donny
-Original Message-
From: Kevin Cowley [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 29, 2004 1:35 PM
To: [EMAIL PROTECTED] Mysql. Com
Jeremy,
We have also seen the problem on linux a while back; we haven't had the
problem lately though.
Donny
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Monday, April 26, 2004 3:36 PM
To: MySQL
Cc: [EMAIL PROTECTED]
Subject: Re: mysqld too busy to check
: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Monday, April 26, 2004 3:49 PM
To: Donny Simonton
Cc: [EMAIL PROTECTED]; 'MySQL'
Subject: Re: mysqld too busy to check its grant tables?
On Mon, Apr 26, 2004 at 03:44:03PM -0500, Donny Simonton wrote:
Jeremy,
We have also seen the problem
, 2004 4:21 PM
To: Donny Simonton
Cc: [EMAIL PROTECTED]; 'MySQL'
Subject: Re: mysqld too busy to check its grant tables?
On Mon, Apr 26, 2004 at 04:11:37PM -0500, Donny Simonton wrote:
We have tried the same thing, flush hosts and flush privileges did
nothing.
Refresh reload did nothing
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
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 PROTECTED]
Subject: Re: SLOW
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
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]
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
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';
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
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
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
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
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
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
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
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,
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
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:
-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 1gb memory limit?
Yes. There's a limit.
Start
:[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 back with
4.1.x.
In your email, the reference to big-tables stated
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:
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?
Please advise your choice of hardware and software configuration
1 - 100 of 124 matches
Mail list logo