Re: Stored Routines, INFORMATION_SCHEMA and parameters

[Martijn Tonies]

Hi,

 Please check:
 http://bugs.mysql.com/bug.php?id=33455

 That bug has been closed because it has been fixed in version 6.x

Thanks but - to MySQL - no thanks. In version 6? This is a bug that should
have been taken care of as soon as the INFORMATION_SCHEMA got
release... :-(

Once more, a half-baked implementation of metadata retrieval...

Reminds me of view metadata, is that better in 6.0 of still *$#$*(#)$#  ?

 Please, feel free to add a comment there writing that the bug affect you
as
 well.
 The more we are, the better developers can decide to fix it for version
5.x
 too.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Sybase
SQL Anywhere, Oracle  MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Improve MYSQL performance on large database

[Guillermo Nardoni]

Hello everyone, good evening. This is my first time posting here and it is 
just for asking...!!!

Well, we are building a project for our customer wich is basically a 
searcher, google style.
We use mnoGoSearch as indexer, 3.2.27-mysql, to more specific.!.
We already try lots of version even compiling from source to discard indexer 
as a problem.

The database, wich is about 20 gb and increasing!!!, is distributed among 5 
server, 4 of 5  has SATA disks, 2 gb RAM, the 5th, is 512 mb ram and 80 gb 
SCSI 3 disk with adaptec 2940U as host scsi adapter.

Well, after lots of testing, if you enter on the site, aka: 
www.lomejordetodo.com.ar, and type a text to search to. it takes about 5 
minutues if
query has lots of result, like linux kernel query.

We read lots of posting, messages and googling but we couldn't solve the 
problem at all!.

If anyone here has o had the same problem I'l give lots of thanks if you 
could show me the path to
investigate.

Regards
Guillermo Nardoni
Rosario - Argentina.




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]