Re: Performance issue old server witn mysql 4 vs new server with mysql 5 and old server WINS!

se higher version give us another issules like > encoding, case sensitivity... Hi. For 5.0 or 5.1 you should really use the most recent versions. 5.1.22 is beta software, the first stable (GA) release was 5.1.30. For best performance, you might be better off going directly to 5.5 series. henrik -

Read the counters for max_questions, max_updates, etc.

not find any information on how to to do this. Per Henrik -- Per Henrik Johansen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Lost InnoDB Data

if we go back to backups which are not entirerly new but later than jan 31. I have no idea what's causing this, and I have absolutely no clue what to do about it. Any suggestions? We're running MySQL 4.0.21 on Red Hat. Any help with this would be greatly appreciated! Best regards,

RE: Managing Very Large Tables

how the primary key is created and used. /Henrik -Original Message- From: Chad Attermann [mailto:[EMAIL PROTECTED] Sent: den 30 mars 2004 19:42 To: [EMAIL PROTECTED] Subject: Managing Very Large Tables Hello, I am trying to determine the best way to manage very large (MyISAM) tables

RE: INSERT ... SELECT question

dd an appropriate where-clause to the above statement. /Henrik -Original Message- From: Eric J. Janus [mailto:[EMAIL PROTECTED] Sent: den 29 mars 2004 21:28 To: Matt Chatterley; 'MySQL' Subject: RE: INSERT ... SELECT question Views would be nice. :) That idea sounds like it

RE: How to optimize ugly order by?

Thanks, I'll have to try that to see if it's faster. Adding another column as someone else suggested is too complex in comparison because it forces a bigger code change, and I don't really want that. Changing one SELECT-statement is enough... /Henrik -Original Message-

RE: How to optimize ugly order by?

I don't think it does right now, but that can always be taken care of later. Assuming that the query uses one index that contains all the where-columns and the orderby-columns, having an ORDER BY that sorts on expressions is still the biggest problem, right? /Henrik -Original Me

How to optimize ugly order by?

ed a lot, it would be nice if I could get rid of this. I'm completely stumped. Any ideas? No, I did not choose the sort order. No, I can not change the values used. Yes, it has to be this sort order. :-) /Henrik Schröder -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Re: max_user_connections problem after upgrading

Hi! Thanks for the info. We ARE getting tons of connections/second, so that might be the problem... We hoped that 4.0.16 would solve it, which it didn't, so now we're hoping for 4.0.17... -- Henrik Matt W skrev: > Hi guys, > > Just wanted to say that I think I remember a r

Re: max_user_connections problem after upgrading

uot;flush user_resources" >> is run. Is there a bug in the particular version of MySQL (4.0.12) >> where the "user connections" are not getting decremented when a >> connection is "closed"? >> >> Joe >> >> Henrik Skotth wrote: >> >

Re: max_user_connections problem after upgrading

I'm mostly using mytop, and that's the way that I see that there are no (are almost no) connections when the server claims that it is above the connection limit... So I guess that there's something seriously wrong then... Any ideas what? -- Henrik [EMAIL PROTECTED] (Pete Harlan

RE: max_user_connections problem after upgrading

Hello! I have tested this now, and that isn't the case. Any other ideas? -- Henrik Michael McTernan skrev: > Hi, > > Have you tried "netstat -a" on the box with the MySQL server? This > command > (Linux) will show what is connected to where, and will help y

Re: max_user_connections problem after upgrading

That's new for 4.0? Hadn't noticed it... Anyway, it's set to 0 so there is no limit to exceed. Also, we aren't getting the error messages ALL the time, they start to appear after a day or two and gets more and more frequent untill I restart mysql. Any other ideas? -- Henrik

Re: max_user_connections problem after upgrading

Hi! What I meant was that even if there are currently only two user connections being used, and the limit is 300, we still get the "already more than max_user_connections" error... -- Henrik gerald_clark skrev: > > > Henrik Skotth wrote: > >>Hello all, >> >

max_user_connections problem after upgrading

or two active connections and our max_user_connections is 300. I have to take down and restart the server to solve the problem, and it keeps happening over and over again every few days... Am I the only one having this problem? Any suggestions? Regards, -- Henrik Skotth, Hogwarts.nu -- MySQL

Mysql 4 problem, more than max_user_connections

there is already more than max_user_connections, but there is really only one or two active connections and our max_user_connections is 300. I have to take down and restart the server to solve the problem. Does anyone know of any solution to this? Regards, -- Henrik Skotth -- MySQL General

RE: Re-attaching DB to mysql

Thanks for the reply. I started a mysql v3 on a new system with the old "backup" data directory and type: mysqldump -p henrik > henrik.sql This dumps the DB? To restore, I move henrik.sql to the current 4.0.14 server and type: mysql -p henrik < henrik.sql except it

RE: Re-attaching DB to mysql

Copy of the data files :-( - Henrik -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 2:04 PM To: 'Henrik Schmiediche'; 'Mysql' Subject: RE: Re-attaching DB to mysql Is the backup a mysqldump or a copy of the

Re-attaching DB to mysql

Hello, I have a backup of a mysql v3.0.18 DB. I need to extract one of the DB's from that backup and place it into my current production v4.0.14 mysql DB. Can this be done? How? Sincerely, - Henrik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

License?

The MySQL homepage says: 2. Free use for those who never copy, modify or distribute As long as you never distribute (internally or externally) the MySQL Software in any way, you are free to use it for powering your application, irrespective of whether your application is under GPL or other OSI appr

Re: mysqld question

At 12:44 2003-06-24, Janice Wright wrote: Well, in the Managing MySQL course run by MySQL AB; they taught us that upgrading hardware is the *last* thing you do to get the database to run faster, not the first. Before you buy new hardware you should: Thanks for the info! (appreciate it) Though I

RE: mysqld question

At 16:52 2003-06-24, Christopher Knight wrote: Not a silly question... we all had to start somewhere... you can do it during the create table ( primary key ) http://www.mysql.com/doc/en/CREATE_TABLE.html Thanks for the explanation, I'm no sql-guru at all, so all info is welcome! :-) I'm running

Re: mysqld question

At 16:21 2003-06-24, gerald_clark wrote: Linux shows threads. BSD shows processes. The difference is in the way ps runs, not mysqld. *doh* I guess the sun got to me, sorry mate! :-) But do you have any good ways to get the database to run any faster? I am running it on a really beat up piece of j

mysqld question

On my server running linux several daemons opens when I run "msqld -u mysql" or "safe_mysqld". A listing of the process shows this: mysql24475 0.5 2.1 83292 2012 ?S15:46 0:03 mysqld -u mysql mysql24476 0.0 2.1 83292 2012 ?S15:46 0:00 mysqld -u mysql mysq

Re: But now new problems :-(

At 10:13 2003-03-08, Zak Greant wrote: Why not use the binaries from mysql.com? We recommend them over making your own binaries. I guess this is what I have to do then... I just *imagined* that mysql would run better on my linuxbox if I compiled it on it... Well, cheers! / H, off to setup up

But now new problems :-(

;: libmysql.c:1348: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1348: too few arguments to function `gethostbyname_r' libmysql.c:1348: warning: assignment makes pointer from integer without a cast make[2]: *** [libmysql.lo] Error 1 make[2]: Lea

Issue Solved (Re: MySQL compiling problem - (a classic))

At 03:51 2003-03-08, Henrik Leghissa wrote: I'm about to compile MySQL (3.23.55) för Red Hat 7.2 that I begin with; ./configure --prefix=/usr/local/mysql I get this error message after a while of machine-chewing; checking for tgetent in -lncurses... no checking for tgetent in -lcurses.

Re: MySQL compiling problem - (a classic)

At 03:35 2003-03-08, Henrik Leghissa wrote: I'm about to compile MySQL (3.23.55) för Red Hat 7.2 that I begin with; ./configure --prefix=/usr/local/mysql I get this error message after a while of machine-chewing; checking for tgetent in -lncurses... no checking for tgetent in -lcurses.

MySQL compiling problem - (a classic)

Hello, This is my first post to [EMAIL PROTECTED] I'm about to compile MySQL (3.23.55) för Red Hat 7.2 that I begin with; ./configure --prefix=/usr/local/mysql I get this error message after a while of machine-chewing; checking for tgetent in -lncurses... no checking for tgetent in -lcurses...

Re: joining to tables

x27;$this->temaid' > and tabell2.temaid = '$this->temaid' > order by $this->tabell.pri desc, $this->tabell.published > desc > limit $this->fra, $this->a

error in mysql - help!!!

an do to make mysql work? Php and Apache seems to be up and running. I'm using win98. I'm new to this game, so ALL help is apreciated!! jan henrik - Before posting, please check: http://www.mysql.com/manual.php

Suggestions to table logging

my webpage, plus I have to write a program to sort out the SQL to other tables. Regards, Henrik Daae - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar

Re: MySQL 3.23.47 or 4.0.1???

.23.47 here: http://www.mysql.com/doc/N/e/News.html -- Henrik Hansen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail

Re: MySQL GUI

On Mon, 2002-01-21 at 22:15, lawrence wrote: > Support > I am new to mySQL and would like to use the MySQLGUI . > I can see the download page but are there any instructions for installing > and setting the GUI up under windows 2000 get mysqlfront from mysqlfront.de it's IMHO be

mysql bind variables in php

Does anyone know if it’s possible to use any kind of bind variables to make the queries run faster. In perl I use; $sth=$dbh->prepare(”select * from table where name = ?”); $sth->execute(”Henrik”); Can I do it in PHP? Thanks /

SV: sequence and nextval

hat insert the new nextval unique and then check for errors (non-unique insert) and if error then re-ask for a new nextval? Is this the best solution? Thanks / Henrik --- create table MySequence ( nextval int(10) not null default '0' auto_increment ) ; insert into MySequence

sequence and nextval

Does the above functions exist in MySQL? If not, when do you think it's going to be implemented and how can I simulate nextval the easiest way? / Thanks Henrik - Before posting, please check: http://www.mysql.com/manua

MySQLGUI?

Hi Can MySQLGUI start and stop the daemon? /Henrik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail

clever head needed

oup("group_id") in the next line of code, which would return the correct group_id. Please help, anybody!? Kind regards, Henrik Mohr, Denmark - Before posting, please check: http://www.mysql.com/manual.php (the manu

any ASP/ADO/MySQL programmers out there?

oup("group_id") in the next line of code, which would return the correct group_id. Please help, anybody!? Kind regards, Henrik Mohr, Denmark w e b d a t a . d k .. [EMAIL PROTECTED] mob: +45 26 24 26 27 store kongensgade 36, 5. postbox 9038 dk-1264 køb

double InnerJoin -how?

I have three tables: one with contacts, one with members, and one that links the members to a group. How do I make a SQL-string, that gets the members from a specifik group, AND the contacts that belongs to this group as well? Won't I have to make a double InnerJoin? Kind regards, /Henrik

Newbie: ASP/ADO .addnew - last_insert_id() ??

ct group_id. Please help, anybody!? Kind regards, Henrik Mohr, Denmark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this th

ASP/ADO .addnew - last_insert_id() ??

ct group_id. Please help, anybody!? Kind regards, Henrik Mohr, Denmark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this th

Newbie: Multiple joins?

same groups as myself. How do I do this with multiple joins, when I can't do a select in(select)? Thanks in advance! Regards, /Henrik Mohr - Before posting, please check: http://www.mysql.com/manual.php (the m

newbie: problem with "select in (select)"

mediumint(9). tblUserLink is used to connect tblUser with tblGroup in a many-to-many relationship. Why doesn't it work? Please help. Thanks in advance, and kind regards, /Henrik Mohr - Denmark - Before posting, please check:

Newbit: ADO and MySQL/MyODBC

fields("nOnline") + 1 'int datatype .update end with Any ideas?? Kind regards, Henrik Mohr - Denmark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/