Re: optimization of large records
On Mon, Feb 18, 2002 at 01:52:41PM -0600, Melvin wrote: Hi: I'm trying to create an image database of about 130,000 records. Right now I have only the filenames in a CHAR Field (the records are of fixed size). I read those images a lot. Is it better to leave it this way or to move all the image data to a blob fields? you are better off with filenames. I already tried to use the blob field but it was up to 100 times slower. Is there a way I can optimize this? with some operating systems having 130 000 files in a directory might be sub-optimal. you might want to create a 'comb' of directory. i.e 1/1/,1/2/,..,1/9/,..,9/1/,..,9/9/ this will also help if you want to share your datas between several hard-drives. I'm using mysql-max 3.23.47 on Windows XP with Athlon XP 1800+, 512 RAM and 60Gb 5400 revs/s IDE Hard Disk my guess is that your Athlon spends all the time waiting for the HD. You would probably get better performances with 4 400Mhz processors at about the same price, and 2 HDs, if the database is used by several users at the same time. what exactly do you want to optimize? time? space? nobody will be able to tell you anything unless you can do some profiling of your application to pinpoint where the bottlenecks are. -- Laurent Oget, Ph.D. [EMAIL PROTECTED]http://oget.net Senior Engineer Zvolve Systems Inc http://zvolve.com Chercheur Associé Liafa http://liafa.jussieu.fr - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 64bit mysql and gcc
On Wed, Dec 05, 2001 at 05:05:54PM +0200, Michael Widenius wrote: Hi! cut Yes; Our Solaris binaries are currently 32 bit. The main reason for this is that I haven't seen any reports that gcc should be able to produce production quality code on 64 bit sparc. the sun compiler does, though. i wonder why sun is not supporting you on that. having a 64 bit open source database available easily might help getting those not so cheap sparc servers sold. and they are not selling databases. If you know of any links or if you have additional information about this, please email this to me. Regards, Monty - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Laurent Oget, Ph.D. [EMAIL PROTECTED]http://oget.net Senior Engineer Zvolve Systems Inc http://zvolve.com Chercheur Associé Liafa http://liafa.jussieu.fr - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Obtaining MySQL for Solaris 8, Intel Version
On Wed, Sep 26, 2001 at 12:41:43PM -0700, Pauljames Dimitriu wrote: Hello, Where can I get a version of MySQL for Solaris 8, Intel version? Do I use the FreeBSD version of MySQL or should I d/l the Linux version? I am just getting used to the Solaris / UNIX environment. I do not see a binary version for solaris/intel so you should download the source code and recompile it. You will most probably need to install some tools for that. all the gnu development tools are available and mysql compiles fine with those. you can also install sun's compilers if you enjoy paying license fees. have a good time! - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Client-side developing
On Tue, Sep 25, 2001 at 06:26:58PM -0300, Walter Omar Autalán wrote: Hi. Please, excuse me for this Off topic message. I want to develop Windows-based client to interact with linux-based MySQL and I can't realize the best programming language suitable for that task. Clients must be run in Windows because customer requirement. I need your suggestions. Please, excuse my bad english. Omar most reasonable languages have either a mysql module or a way to link with C routines, and hence to call mysql. so the best language will be the one you are the most knowledgeable about/comfortable with. - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: C API problem
On Thu, Apr 19, 2001 at 11:12:23PM +0800, john1 wrote: /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open': my_open.o(.text+0x14):undefined reference to 'open64' /home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format': mf_format.o(.text+0x201):undefined reference to '__lxstat64' /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open': my_open.o(.text+0x21):undefined reference to 'fopen64' looks like you have a version of libc that is too old -- Laurent Oget, Ph.D. [EMAIL PROTECTED]http://oget.net Senior Engineer Zvolve Systems Inc http://zvolve.com Chercheur Associ Liafa http://liafa.jussieu.fr - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: moving database to another computer
On Mon, Feb 19, 2001 at 04:34:05AM -0700, Ming Hsu wrote: Hi, I've been working with mysql for a couple of months now for my website. Now I have to move to a different server, and would like to move the database as well. Problem is I have no idea what this entails and how to do it. Can someone help me? Thanks. Ming Hsu this is usually a good occasion to clean up databases, but if you do not want to do that you can use mysqldump, compress the file and then have mysql read the dump file. You do need a telnet access to that machine though. -- Laurent Oget, Ph.D. [EMAIL PROTECTED] Senior Engineer Zvolve Systems Inc http://zvolve.com Chercheur Associ Liafa http://liafa.jussieu.fr - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
UPDATE using other table
Is there a way to update a column of a table using values from other tables something like update table1 set table1.column1=table2.column1 where table1.column2=table2.column1 -- Laurent Oget, Ph.D. [EMAIL PROTECTED] Senior Engineer Zvolve Systems Inc http://zvolve.com Chercheur Associ Liafa http://liafa.jussieu.fr - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php