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

2011-02-16 Thread Henrik Ingo
On Sun, Feb 13, 2011 at 11:40 PM, Andrés Tello wrote: > I have a test process, which runs in the "old server" in 35 seconds, the new > server runs the same process in 110. > > There is a change of version from mysql 4.1.22 to  5.1.22. > We were stuck at 5.1.22 because higher version give us anothe

view doesn't refresh inside transaction

2009-03-04 Thread Ingo Weiss
Only after the transaction is committed does the row appear in the view. Now I would like to avoid having to commit the transaction at that point. Is there any way to force a view to refresh inside a transaction? Thanks for any hint! Ingo Metaversum GmbH Rungestr. 20 - 10179 Berlin - Ge

Re: SQL question: find items tagged with specific tags

2008-04-23 Thread Ingo Weiss
d_and_green | +---+ Do you have an idea how to create an AND query? Ingo On Apr 22, 2008, at 5:42 PM, Sebastian Mendel wrote: Ingo Weiss schrieb: Hi all, I have an application where items can be tagged. There are three tables 'items', '

SQL question: find items tagged with specific tags

2008-04-22 Thread Ingo Weiss
' - items tagged with 'blue', 'red' and 'green' Any help is very much appreciated! Ingo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: malloc troubles on 64-bit machine

2005-08-09 Thread Ingo Strüwing
you mean that the performance degrades if the database is bigger than the cache. I this case you are right. But I can't think of any way to get around it. If you mean something else, I can't help you much with InnoDB. Please start a new thread with good "Subject:" on the MySQL ma

Re: max key file length

2005-02-08 Thread Ingo Strüwing
So you get the offset of each value in the file. If you have a source tree, you will find a file Docs/internals.texi. It describes, how you can access the 'real' internals.texi. In this file you find an explanation, how the key file is structured. This may help you to understand,

Re: [PHP-DB] Upgrading mySQL

2004-11-30 Thread Ingo Strüwing
PHP mysql extension and the > Python MySQLdb module. "However I do not know how to do this and > was asking how to for PHP 4. > > > > > On Mon, 22 Nov 2004 15:55:25 +0100, Ingo Strüwing <[EMAIL PROTECTED]> wrote: > > Hi GH, > > > > apart of the c

Re: Remote user problem

2004-11-30 Thread Ingo Strüwing
127.0.0.1 to 'localhost.localdomain' instead of 'localhost'. Consequently, it does not match the entries in the user table (select host,user from mysql.user). "mysql -h localhost -u root -p" should work then. Regards, Ingo -- Ingo Strüwing, Senior Software Developer MySQL A

Re: [PHP-DB] Upgrading mySQL

2004-11-22 Thread Ingo Strüwing
he same applies to other > MySQL interfaces as well, such as the PHP mysql extension and the > Python MySQLdb module. " [But now how to] Regards, Ingo -- Ingo Strüwing, Senior Software Developer MySQL AB, www.mysql.com Office: +49 30 43672407 Are you MySQL certified? www.mysql.com/ce

Re: Stupid Newbie Query Help with AND and OR logical operators

2004-05-08 Thread Ingo Thierack
hi, you should set parentheses on it Select * FROM name WHERE last LIKE "d" AND (choice1="2" OR choice2="2" OR choice3="2"); without it interprets it as like "d" and choice1="2" or choice2="2" or

mysql-test 4.1 fails with the gis test

2004-03-15 Thread ingo
>Description: After pulling the 4.1 version from bk-internal.mysql.com:/home/bk/mysql-4.1, I compiled with BUILD/compile-pentium-debug and startet tests with make test. This failed with the gis test. I try to follow the instructions given at the end of the te

Suggest improvement for mysqlbug

2004-01-06 Thread Ingo . Struewing
>Description: I had some difficulties to send a bug report by mysqlbug. It inserted my UNIX user name as From: and used some default mail agent, which used my UNIX username @ local domain as the sender address. While the first is merely uncomfortable, the lat

mysqld crashes when closing a prepare/execute session

2004-01-06 Thread Ingo . Struewing
omes during closing the session, closes and exits. /* bug_prepared.c * * Copyright 2004 Ingo Struewing * * Show a server bug during close after executing prepared SQL. */ static char*USAGE[] = { "Usage: bug_prepared -p|-q \n", 0}; #define ARGS(x) ( ((

Re: CVS finally worked.

2001-12-01 Thread Ingo Krabbe
he CVS tree for mysql database right now. CU INGO - 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 <[EM

CVS errors corrected addition:

2001-12-01 Thread Ingo Krabbe
to overthink the autoconf process. These errors are quite likely to occure. It is more easy to get the system resources running with a software package than correct the software package itself. Of course autoconf helps configuring for many systems, but it also helps such internal errors. CU INGO

CVS changed some things:

2001-12-01 Thread Ingo Krabbe
*)tok,len,function) in sql_lex.cc. Do I need another dependent software ? where did you hide this function ? CU INGO - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com