Re: mysql 4.1.8 client installation problem

2005-01-22 Thread Gleb Paharenko
Hello. We want only mysql 4.1.8 client version RPMs with 4.1.8 client programs for Linux on x86, IA64, AMD64 are aviable from: http://downloads.mysql.com/archives.php?p=mysql-4.1v=4.1.8 But MySQL Server 4.1.9 would be a better choice. sirisha gnvg [EMAIL PROTECTED] wrote: [--

Re: load balacing in a replicated environment

2005-01-22 Thread Gleb Paharenko
Hello. You may tell the slave to replicate updates only for the certain database or table. See: http://dev.mysql.com/doc/mysql/en/Replication_Options.html Eben Goodman [EMAIL PROTECTED] wrote: I am considering setting up replication for a loaded database that has to perform

Re: mysql store queries?

2005-01-22 Thread Gleb Paharenko
Hello. Does mysql stores queries? If so where? MySQL server can log the queries in log files. See: http://dev.mysql.com/doc/mysql/en/Log_Files.html Jerry Swanson [EMAIL PROTECTED] wrote: Does mysql stores queries? If so where? -- For technical support contracts, goto

mysql client installation

2005-01-22 Thread kalyan kumar
hai, Give sequence of steps to install mysql client 4.1.8 alone in windows xp? thanks in advance.. Yahoo! India Matrimony: Find your life partneronline.

force configure to not use -lcrypt

2005-01-22 Thread Alex S Moore
On Solaris 8, how can I force configure to not use /usr/lib/libcrypt.so without renaming that file? I changed config.h to undefine HAVE_LIBCRYPT, but configure just puts it back to defined and changes the Makefiles to include -lcrypt. Thanks, Alex -- MySQL General Mailing List For list

INNER JOIN across multiple tables appear very slow.

2005-01-22 Thread sam wun
Hi, Can anyone tell me how to optimize the following sql statement? $sql_1 = SELECT t.prodcode 'Product Code', t.prodname 'Product Name', ROUND(avg(t.salesvolume),2) 'PastSales Quantity', ROUND(avg(tt.salesvolume),2) 'Sales

Re: INNER JOIN across multiple tables appear very slow.

2005-01-22 Thread sam wun
sam wun wrote: Hi, Can anyone tell me how to optimize the following sql statement? $sql_1 = SELECT t.prodcode 'Product Code', t.prodname 'Product Name', ROUND(avg(t.salesvolume),2) 'PastSales Quantity',

accent, quote and fulltext search

2005-01-22 Thread Rot Ulet
Hello, It seems it is possible to get ride of accent problems in fulltext search (but I don't know how to). I am using 4.1.8a version of mysql and I am not enable to find any accentuated word from its non-accent version (says 'siecle' for 'siècle'). For example : SELECT * FROM table WHERE

Collation

2005-01-22 Thread Michael J. Pawlowsky
I just upgraded from 4.0.8 to 4.1.9. On MySql 4.1.9 my default collation seems to be latin1_swedish_ci. I need to support french accents. Right now, not sure if it's MySQL or PHP. But all accented caracters in the database are coming out wrong. I'm thinking I should just use utf8_general_ci but

Re: MySQL Losing database information

2005-01-22 Thread Heikki Tuuri
Christopher, InnoDB tables are in ibdata files. I hope that you have not deleted them inadvertently. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables

RE: MySQL Perl

2005-01-22 Thread Gerald Preston
Hi! I am totally lost here and I know this is a no brinier. I do not know what I am doing wrong: I can access from the command line by mysql -u gjw -p then use club and I can do anything I want. I am trying to access by Perl: # line 6 following my $dbh=DBI-connect( 'DBI:mysql:gjw:club',

RE: isam to myisam

2005-01-22 Thread Bagus
According to the help message, the --type option is for specifying the table type that you want to convert the tables *to*. So it should be --type=MyISAM, I think. You could also execute this statement for each table that you want to convert: ALTER TABLE tbl_name ENGINE=MyISAM; Both of

RE: isam to myisam

2005-01-22 Thread Paul DuBois
At 19:41 -0600 1/22/05, Bagus wrote: According to the help message, the --type option is for specifying the table type that you want to convert the tables *to*. So it should be --type=MyISAM, I think. You could also execute this statement for each table that you want to convert: ALTER

RE: MySQL Perl

2005-01-22 Thread Paul DuBois
At 13:28 -0800 1/22/05, Gerald Preston wrote: Hi! I am totally lost here and I know this is a no brinier. I do not know what I am doing wrong: I can access from the command line by mysql -u gjw -p then use club and I can do anything I want. I am trying to access by Perl: # line 6 following my

Error with Storage engine

2005-01-22 Thread sam wun
Hi, I was trying to optimize a sql (for INNER JOIN) by spliting the sql into 2 temporary tables. But I got error with the following sql: mysql CREATE TEMPORARY TABLE pastsales_tab_3141604663377652915968 SELECT c.salescode,c.type, c.custcode, i.basename, i.vendorname, t.salesvolume, t.netsales,

Re: Connection performance, suggestions?

2005-01-22 Thread Larry Lowry
Actually I was just trying to see why the same code to mySql is so much slower than SQL Server. I tried the same code using the data provider from CoreLabs and found the connections occur 4 times faster than the mySQL AB connector. The slowness just seems to be in the connector. Now I know my

RE: Connection performance, suggestions?

2005-01-22 Thread Donny Simonton
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:

RE: isam to myisam

2005-01-22 Thread Bagus
SHOW ENGINES says no support for ISAM. So that explains it. Which other server would you suggest I try installing? Do you mean I should try installing an earlier version of mysql? Where should I find one? I'm worried about messing up my new installation by installing an old one. Is there an

system requirements for large selects

2005-01-22 Thread why me
We are looking for buying a new server for running MySQL database. The database is around 50-70G and individual tables run to 5 - 15 GB. There wont be any frequent updates instead we need maximum select performance. There will be multiple table joins to perform our query. I hope your experience

library mamager for linux

2005-01-22 Thread gowthaman ramasamy
Hi list, can any one suggest a good PHP/mysql based library manager to manage books,magazines, documents, cds etc . I tried libman .. but i am having problem with that . many thanks in advance ... with love gowtham -- MySQL General Mailing List For list archives:

auto-increment question

2005-01-22 Thread leegold
I have two different databases they both have an auto-increment PK field and while they are different databases with different names, they do have tables with the same names. What I find is that the auto-crement integer number remembers what it is across these databases. So if I insert in the 1st

show temporary table

2005-01-22 Thread sam wun
Hi, How can I see all temporary tables that created by Create Temporary Table command in mysql 5.01? thanks Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]