MySQL Database Dimensioning
Hi Iam very new user of MySQL. Can anyone help me in guiding me that how can I dimension and design the MySQL Database Server. If some one can provide the guidelines and the critical parameters that are required to dimension the MySQL Server. Iam looking for scaling the database for at least 5 years How can I do that Regards Vivek Aggarwal
Where can I download HPUX11.0 PA-RISC 2.0 (LP64) platform binaries for 4.1.8 mysql?
Hello- I am looking for ELF-64 relocatable object file - PA-RISC 2.0 (LP64) platform binaries for 4.1.8 mysql. Please lemme know where I can download this from? Thanx, Vivek PS: I downloaded this from the mysql.com mysql-standard-4.1.8-hp-hpux11.00-hppa2.0w ptdh172:vkrajanfile libmysqlclient.a libmysqlclient.a: archive file -PA-RISC1.1 relocatable library ptdh172:vkrajanfile libmysqlclient_r.a libmysqlclient_r.a: archive file -PA-RISC1.1 relocatable library ptdh172:vkrajan I don't see PA-RISC 2.0 binaries.
Migration to Mysql
Hello all, I am going to migrate a MsAccess database to MySQL. I wanted to know if somebody ahs doen it and what problems you might face and workaround them if possible. Also, do let me know if my query is broad?? Reagrds VK ___ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
By mistake I removed root server of localhost thru webmin
Dear List, I have removed root user of localhost thru webmin and now i am not able to login into MySQL Interface of webmin as it says Incorrect user name and password when I try to enter as any user [root or any XYZ user], please tell me how to create this user for MySQL so that I can access this interface again. Please note that I am able to use root login for all other purposes but Webmin does not allow to enter into MySQL Interface only. Regards, Vivek - 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
varchar to char ...
Hi guys, I have a query.I am not sure if this is a bug or a feature (ha ha ha...). Table - abc name varchar(30), address varchar(50) Then I run this sql. create table temp_abc as select * from abc; datatypes of the columns changes: Table - temp_abc name char(30), address char(50) any clues, Vivek - 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: varchar to char ...
What do you mean by optimization of the column? Are you saying that char takes less space than varchar or the performance on char is better in queries compared with varchar ? The whole concept of CREATE AS is that you want target table to inherit all the properties with the data of the source tables and the columns. So I don't understand why should/would it change the data types of columns. thanks Vivek -Original Message- From: bvyas3 [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 6:36 PM To: CHAUDHARY, Vivek; mysql Cc: bvyas3 Subject: Re: varchar to char ... Mysql optimizes the column type while creating the table. Regards, Bhavn. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 14, 2002 2:26 PM Subject: varchar to char ... Hi guys, I have a query.I am not sure if this is a bug or a feature (ha ha ha...). Table - abc name varchar(30), address varchar(50) Then I run this sql. create table temp_abc as select * from abc; datatypes of the columns changes: Table - temp_abc name char(30), address char(50) any clues, Vivek - 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 - 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 - 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: Duplicate Keys
There are couple of ways you can do it. 1) You can use the following sql to find out duplicate rows and then write few more sql to delete duplicate. SELECT column(s), count(*) FROM table-a GROUP BY column(s) HAVING count(*) 1; then massage the data with couple of more sqls. 2) This way you can dump unique rows in another table and then drop this table, recreate it and copy the unique rows. CREATE TABLE table-B (structure same as table-A); INSERT INTO table-B SELECT DISTINCT * FROM table-A; ( Assumption is that rows are duplicated) DROP TABLE table-A; RENAME TABLE table-B TO table-A; 3) You can try; ALTER IGNORE TABLE table-A add unique (columns_with_unique_values); Be careful in using this as there are some issues with this. cheers Vivek -Original Message- From: oswaldo [mailto:[EMAIL PROTECTED]] Sent: Friday, April 26, 2002 11:20 AM To: mysql Cc: oswaldo Subject: Duplicate Keys Hi List Sorry for the newbie question. Im new to MySQL. I have a table that I don't know how many duplicate records it has, so how do I query and delete all the duplicate (or many multiple) records from a MySQL table ? Thanks in advance Oswaldo Castro - 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 - 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: Erwin Vs Mysql ....
Ken, Thanks for your help. I got it working. For now I needed to reverse engineer the database. The trickier part was the username and password. I initially gave mysql login name. But actually you have to give either DB owner or root. Unfortunately we do not have support contract. Somebody picked up this DB because it costs nothing. And now it has come on me to maintain it apart from maintaining Oracle, Informix, Ingres etc. once again thanks for your help. Vivek -Original Message- From: kenm [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 5:22 AM To: CHAUDHARY, Vivek; mysql Cc: kenm Subject: Re: Erwin Vs Mysql Try MyODBC from the downloads page at www.mysql.com. Erwin works fine for reverse engineering databases, on forward engineering I do have to make some patchs by hand to script before I can generate a model. Maybe I need to learn to use Erwin better. Also if you have a support contract please call and ask them to add mysql to the native supported databases they are supposed to do this but the more pressure they get the faster it will get done! Ken - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 5:32 PM Subject: Erwin Vs Mysql Has anyone got Erwin working with mysql. I guess all directly non-supported DBs by Erwin are suppose to work via ODBC but I have not been able to find ODBC driver (either generic or for mysql). thanks Vivek - 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 - 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 - 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
Erwin Vs Mysql ....
Has anyone got Erwin working with mysql. I guess all directly non-supported DBs by Erwin are suppose to work via ODBC but I have not been able to find ODBC driver (either generic or for mysql). thanks Vivek - 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: FW: Mysql unresponsive ....
Hi Joseph, The situation is like this. The daemon was running but any command / requests were hanging for example any mysqladmin command would sit there forever, any mysql command would behave the same way. OS - HP-UX 10.20 Mysql version - 3.23.33 There were lot of activities at the time server hung-up. But even after users got out it was in the hung state. Nothing in the error log files to give any clues. thanks Vivek -Original Message- From: joseph.bueno [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 1:18 AM To: CHAUDHARY, Vivek Cc: mysql Subject: Re: FW: Mysql unresponsive Hi, May be this list was unresponsive because your description of the problem was a bit vague... I haven't experienced this kind of behaviour myself however some more details on your problem may help: - What OS are you using ? - What version of MySQL are you using ? - Was mysql server dead ? (Have you tried mysqladmin with ping, status or processlist options ?) - Have you checked mysql error log ? - When the problem happened, what kind of system activity have you seen ? Have you run top, vmstat (I assume you are on a Unix like OS) ? Hope this helps -- Joseph Bueno NetClub/Trader.com [EMAIL PROTECTED] wrote : Since I didn't get any response (like mysql server) I am sending it again. thanks Vivek -Original Message- From: CHAUDHARY, Vivek Sent: Wednesday, April 17, 2002 3:34 PM To: '[EMAIL PROTECTED]' Subject: Mysql unresponsive Hi all, Last friday we found that mysql was unresponsive (all the SQL activities were on hold) but the daemon was still running. We shutdown the daemon and restarted and everything was OK. My questions: 1) What could cause this behavior ? 2) Is there any way to monitor such a behavior ? any commands, scripts that could test for inactivity etc. Needless to say that I am a newbie on mysql front. Vivek Chaudhary Database Administrator IT STMicroelectronics, Phoenix. Phone:(602)485-2271 Fax: (602)485-6402 Cell:(602)363-1492 Email: [EMAIL PROTECTED] - 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
FW: Mysql unresponsive ....
Since I didn't get any response (like mysql server) I am sending it again. thanks Vivek -Original Message- From: CHAUDHARY, Vivek Sent: Wednesday, April 17, 2002 3:34 PM To: '[EMAIL PROTECTED]' Subject: Mysql unresponsive Hi all, Last friday we found that mysql was unresponsive (all the SQL activities were on hold) but the daemon was still running. We shutdown the daemon and restarted and everything was OK. My questions: 1) What could cause this behavior ? 2) Is there any way to monitor such a behavior ? any commands, scripts that could test for inactivity etc. Needless to say that I am a newbie on mysql front. Vivek Chaudhary Database Administrator IT STMicroelectronics, Phoenix. Phone:(602)485-2271 Fax: (602)485-6402 Cell:(602)363-1492 Email: [EMAIL PROTECTED] - 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
Mysql unresponsive ....
Hi all, Last friday we found that mysql was unresponsive (all the SQL activities were on hold) but the daemon was still running. We shutdown the daemon and restarted and everything was OK. My questions: 1) What could cause this behavior ? 2) Is there any way to monitor such a behavior ? any commands, scripts that could test for inactivity etc. Needless to say that I am a newbie on mysql front. Vivek Chaudhary Database Administrator IT STMicroelectronics, Phoenix. Phone:(602)485-2271 Fax: (602)485-6402 Cell:(602)363-1492 Email: [EMAIL PROTECTED] - 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: Bill-of-Materials
So far I have seen this feature in Oracle and DB2 alone. I am yet to find any other RDBMS. Vivek Chaudhary -Original Message- From: len [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 13, 2002 7:10 AM To: mysql Cc: len Subject: Bill-of-Materials Hello! As a newbie to MySQL (and used to be running DB2), I'm looking for a way to explode a bill-of-materials table. Is there any support for recursive SQL in MySQL, for example by using standard common table expressions? Thanks in advance! Lennart Henäng Henfield AB Sollentuna, Sweden - 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 - 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: cobalt binary version
a == archive archie writes: a any binary version for cobalt qube2 (mips processor) ?? a have mysql ever tested install at cobalt qube/raq ?? a how is it done? There used to be a version on the cobalt ftp site in the contrib area. Don't know what's there now, since they seem to be ignoring the MIPS based equipment lately. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - 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: Help with FreeBSD 4.2 Native Threads (was: Compile broken: mysql-3.23.38/mit-pthreads)
DF == David Favor [EMAIL PROTECTED] writes: DF The problem is the Web hosting service I use does not have this DF package installed. In other words, there is no libpthreads.* in DF any of the library directories. But FreeBSD native threads do not need any libpthreads.* files. Your best bet on FreeBSD is to cd /usr/ports/database/mysql323-server; make install and be done with it. The port is extremely nicely done. - 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: Re: Help with FreeBSD 4.2 Native Threads (was: Compile broken:
Your filter really makes having a discussion difficult. I think I'll just go away. m == mysql [EMAIL PROTECTED] writes: m Your message cannot be posted because it appears to be either spam or m simply off topic to our filter. To bypass the filter you must include m one of the following words in your message: m database,sql,query m If you just reply to this message, and include the entire text of it in the m reply, your reply will go through. However, you should m first review the text of the message to make sure it has something to do m with MySQL. You have written the following: DF == David Favor [EMAIL PROTECTED] writes: make install and be done with it. The port is extremely nicely done. DF The problem is I do not have root access, so have no permission to do this. m You can tell the ports to install themselves wherever you like. Just m copy the necessary port files, then make it in your own directory m with the base install derectory changed. - 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: how force mysql to use certain indexes
PJM == Patrick J Militzer [EMAIL PROTECTED] writes: PJM I'm using mysql 3.22.27. How can I force mysql to use index's in PJM my select statement? You don't. SQL is a 4GL and you only describe what you want, and it is up to the language interpreter and optimizer to do it efficiently. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - 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: MySQL 3.23.37 released
"MW" == Michael Widenius [EMAIL PROTECTED] writes: MW We are just now building the first MySQL-Max binaries with support for MW Berkeley DB and InnoDB tables. The first one will be a Linux x86 RPM Does this imply that BDB tables are stable enough for production use, or is it still considered Beta as per http://www.mysql.com/doc/S/t/Stability.html ? - 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: Indexes on Nulls
"DG" == Dennis Gearon [EMAIL PROTECTED] writes: DG Is it true no indexing on Nulls In the Innobase database tables and DG MyIASM DG tables? Dunnow about Innobase tables, but MyISAM tables let you have indexes on nullable columns. ISAM did not. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - 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: Running crash-me against remote M$ SQL Server
"GC" == Gerald Clark [EMAIL PROTECTED] writes: GC Perl/DBI, or any mysql client on Linux should connect to mysql on NT GC with no problem. Why would you need ODBC? Except that perl/DBI requires an underlying C library for the DBMS in question. I understand that the sybase libs might be able to talk to MS SQL server, so that may be an option. - 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: email only two columns
"PM" == Prasad Mhatre [EMAIL PROTECTED] writes: PM Is it possible to mail only three columns from a database ? Third column PM being email ID? PM I need to send email to all with a valid email ID in a database. MySQL doesn't send email. Perhaps you need to write a program that queries the database and then sends the mail you want. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - 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: MySQL 3.23.36 is relased
"MW" == Michael Widenius [EMAIL PROTECTED] writes: MW* Added `SET TRANSACTION ISOLATION LEVEL ...' How about documenting this? http://www.mysql.com/doc/S/E/SET_TRANSACTION.html is quite uninformative as to what the different levels mean. - 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
stability documentation up to date?
Is the http://www.mysql.com/doc/S/t/Stability.html document up to date? In particular, I'm interested in the current stability level of BDB tables, since I'm in need of transactions for a particular project. Also, the MyISAM handler is still listed as gamma, not stable. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - 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: MySQL vs PostreSQL ??
"t" == topmailbox tmb writes: t How does PostreSQL compair to MySQL ? Did you read what it has to say about this in the manual? t I'm sure each has it's own advantages disadvantages. Yes. t What are some of the major ones? Depends on what your needs are. One person's advantage is another's disadvantage. t Which would be more capible in a large web base t database where the database was very large and the hit t rate very high? Again, it depends on what your specific needs are. Most likely, you'll need to evaluate them both yourself probably with some benchmarks and then decide which is "better". -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - 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
DBD::mysql to support transactions?
Is there any work going on with DBD::mysql for Perl to support transactions at the DBI abstraction? If you attempt to use DBI autocommit=0, DBD::mysql croaks. It would seem that with BDB and the other new table types that support transactions, it will become necessary... -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - 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
multiple charsets per server?
I need to do some tests for a client involving japanese text. I've recompiled the server with extra charsets = complex to have multi-byte support. I see how I can select the default charset upon startup. How can I tell mysql that a particular set of tables (or the whole DB) should use the japanese charset while leaving the other tables and DBs alone (using default Latin1)? Is this possible withour running multiple instances of mysqld? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - 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: HOWTO: Get column types enum values using perl
"MW" == Mark Worsdall [EMAIL PROTECTED] writes: MW When I do this:- MW my $types = $sth-{TYPE}; MW # MW if ($$types[0] = Mysql::FIELD_TYPE_STRING) { MW print "Type is a SRINGBR"; MW } Perhaps you mean if ($$types[0] == Mysql::FIELD_TYPE_STRING) you are doing an assignment, not a comparison. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - 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: Setting a specific default value on a field
"JSB" == Jamie S Buchanan [EMAIL PROTECTED] writes: JSB More specifically, I have two DateTime fields (A and B), in my creation JSB script I want to set the default value of B to the value of A so that JSB when I write a new record to the table the position of B can be left what's wrong with INSERT INTO goo (A,B) VALUES (NOW(),A) -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - 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: Long deletes
"MV" == Michael Villalba [EMAIL PROTECTED] writes: MV Thanks, Fred. The delete job has been running for 21 hours MV at this point, and now rather simple queries on other tables hang MV (e.g. SELECT COUNT(*) FROM other_table WHERE index=some_value). MV I'll let it run overnight to see what happens, but I'm not hopeful. This is a major issue for us as well. We have some tables that need periodic cleaning of old data and it can take hours upon hours to do that. What our workaround is, and it is IMHO, sub-optimal, is to use the LIMIT feature of DELETE in MySQL, and issue the delete in a loop until no more items are deleted. Something like this, in Perl: my $sth = $dbh-prepare("DELETE LOW_PRIORITY FROM playlog $clause LIMIT ?"); $sleeptime = 0; do { print "Sleeping... $sleeptime seconds\n"; sleep($sleeptime); my $stime = time; print scalar localtime $stime," (start delete)\n"; $sth-execute($limit); $affectedRows = $sth-rows(); my $etime = time; print scalar localtime $etime,": "; my $diff = $etime-$stime; print "Deleted $affectedRows rows... $diff seconds\n"; $sth-finish(); # sleep half the time it took to delete, if longer than 30 seconds. $sleeptime = $diff 30 ? int($diff/2) : 1; } until ($affectedRows $limit); Assuming $clause = 'WHERE .' is your match for rows to delete, this will delete things in batch size of $limit (I use 200 rows), and sleep between the deletes to let other threads do their thing with not too much delay. Ideally, MySQL would allow the delete to be concurrent with other operations. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - 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: Having a hard time installing MySQL
"DN" == Dan Nelson [EMAIL PROTECTED] writes: DN This looks like you used the binary package, right? That was built for DN FreeBSD 4.2, which has a different set of c++ libraries from 4.0. DN You'll have to either upgrade to 4.2, or build mysql from ports. I'd highly recommend upgrading to FreeBSD 4.2-STABLE so that you also get the very important C++ library/compiler fixes. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - 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: mod_auth_mysql
"JDZ" == Jeremy D Zawodny [EMAIL PROTECTED] writes: Does anyone know if mod_auth_mysql is still under active development, and if so, where can I find current information on it? JDZ Which one? JDZ There appear to be two. Go here and search for "mysql" JDZ http://modules.apache.org/ My version is still maintained, but since there have been no major problems with it in a looong time, there is really nothing to change in it. :-) Try my version, I'm sure you'll find it works just fine. The only note I have to add is that if you also use php4 with mysql built-in, then absolutely make sure that php is built to use the system mysql library and not its own copy. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - 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: Multiple Column list index
"M" == MikemickaloBlezien [EMAIL PROTECTED] writes: M I have a table that stores business locations, which contains M 'city','state' and 'zip' and this table is utilize for search M queries. Which type of indicing take full advantage of the MySQL M optimizer, create a multiple column index (city,state,zip) or M separate indices on each column. The use of indexes depends on your queries. What do your queries look like? There's no point building an index unless your queries can take advantage of it. M - M Before posting, please check: Mhttp://www.mysql.com/manual.php (the manual) Mhttp://lists.mysql.com/ (the list archive) M To request this thread, e-mail [EMAIL PROTECTED] M To unsubscribe, e-mail [EMAIL PROTECTED] M Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - 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: Binary distribution on FreeBSD4.0
"d" == drew [EMAIL PROTECTED] writes: dJust wondering if anyone could help me out here? I have recently d downloaded the binary distribution of mysql for FreeBSD (mysql- d 3.23.32-unknown-freebsdelf4.2-i386.tar.gz). Now my problem is d probably an easy fix but here goes. When I try and run Your best bet on FreeBSD is to build the MySQL port form /usr/ports. It is really well done. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - 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: Linking MySQL with other programs
"-lm" has been specified in the linker option line. Before or after the -lmylsqlclient flag? It needs to be after. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - 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: taxes
"MK" == Mikel King [EMAIL PROTECTED] writes: MK guys I think you are making this a way bigger problem than it MK really is...e-merce crap is generally taxed based on the location MK of the vendor; much the same way in which mail order businesses MK are taxed. You really only have to worry about the state/locality What world (or country) do you live in? When was the last time you ordered something from Dell or Apple on line? What tax rate did you pay? You pay your local rate; not the rate of the location of the store. - 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: table too big to dump?
"BR" == Brian Reichert [EMAIL PROTECTED] writes: BR When I try to do a mysqldump on the localhost, I get an out-of-memory BR error: BR # mysqldump -uroot -proot customer audit_trail_271 BR mysqldump: Out of memory (Needed 8164 bytes) BR mysqldump: Got error: 2008: MySQL client run out of memory By default mysql client reads the whole result set into memory then writes the output. You can alter this behavior with the "-q" option to mysqldump, so it writes out as it reads from the server without buffering in memory. - 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: problems running mySQL via Telnet
"TT" == The Tilghman [EMAIL PROTECTED] writes: TT You're trying to use a Telnet client with a MySQL server. Instead, TT use a MySQL client with a MySQL server and a Telnet client with a TT Telnet server. Mixing protocols doesn't really work for anybody. well, you can use the telnet client to speak to any service, as long as you are capable of typing the poper protocol characters. Telnet clients are handy for debugging SMTP servers, for example. But in general, you want to use the mysql command line client to speak to mysql. That is, unless you're debugging the mysql protocol ;-) - 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: Boolean Datatype
"RD" == Russ Davies [EMAIL PROTECTED] writes: RD Thanks for the suggestion, but this would still mean converting the data RD type from within ASP (the 'True' type) down to a char ('T') would it not? then use ENUM('False','True') instead. Enum can have any string you want. I personally prefer to use the order False, True since then it also has the numeric values 0 and 1. CREATE TABLE logInfo2 ( logID INT NOT NULL UNIQUE, ipAddress VARCHAR(20) NOT NULL DEFAULT 'None', boolVarsENUM ('T', 'F') DEFAULT 'F' ) - 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: mySQL IS winning
"RH" == Rolf Hopkins [EMAIL PROTECTED] writes: RH That also depends on your definition of *PRODUCTION* status. If you are RH going to make a profit using MySQL then you need to purchase a license. Not any more; MySQL is GPL in the current version. - 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: mySQL is winning
"AS" == Alexander Skwar [EMAIL PROTECTED] writes: AS Well, I still don't get it - why should I want to shell out a huge AS amount of money? I mean, your post would fit a lot better, if AS this was a Oracle mailinglist The point, I beleive, is that Oracle finds MySQL such a threat to their business that they have to put out a migration kit to make it easy for people to switch to their product. It shows that the popularity of MySQL is being taken seriously by the majors. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - 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: Running two Makes
"EJD" == Evan James Dembskey [EMAIL PROTECTED] writes: EJD is it possible to install Gnu make onto teh Dec in a way that it does not EJD interfere at all with the rest of the system? If so, how do I do it? When you install gnu make, call it "gmake". Then run "gmake" when you need it. - 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: idle CPU
"TS" == Tim Samshuijzen [EMAIL PROTECTED] writes: TS We're running a large database on a dedicated server. TS When I look in the list of active processes, I notice that a TS complicated query takes up no more than about 30 % of CPU. TS During this time the CPU is more than 60 % idle. TS Is there some way to speed up the process? Make your disks infinitely fast. Then the CPU will be your bottleneck rather than your disks. - 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: What causes table corruption? (isamchk -r required)
"jds" == j d stumbles [EMAIL PROTECTED] writes: jds I'm running 3.22.32 on Solaris 5.6 on a sparc ultra-1, and have processes jds updating the tables concerned continuously, via REPLACE INTO, INSERT INTO jds or UPDATE statements. I've never had table corruption on a Solaris box, even with older MySQL versions. We don't use REPLACE INTO since I find it to be quite useless, really. Anyhow, here are some stats. These are using binary versions of MySQL from the www.mysql.com site. mysqladmin Ver 7.8 Distrib 3.22.14-gamma, for sun-solaris2.6 on sparc TCX Datakonsult AB, by Monty Server version 3.22.14-gamma Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 108 days 6 hours 38 min 40 sec Threads: 7 Questions: 12566861 Slow queries: 65925 Opens: 120 Flush tables: 1 Open tables: 116 [prod-rtm]% uname -a SunOS prod-rtm.xxx.xxx 5.6 Generic_105181-17 sun4u sparc SUNW,Ultra-250 and another box: mysqladmin Ver 7.8 Distrib 3.22.20a, for sun-solaris2.6 on sparc TCX Datakonsult AB, by Monty Server version 3.22.20a Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 217 days 7 hours 16 min 26 sec Threads: 1 Questions: 43556764 Slow queries: 10224 Opens: 967 Flush tables: 1 Open tables: 255 [prod-rtm2]% uname -a SunOS prod-rtm2.xxx.xxx 5.6 Generic_105181-20 sun4u sparc SUNW,Ultra-250 - 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: MySQL Install trouble on FreeBSD4.2
"JN" == Jeff Neuffer [EMAIL PROTECTED] writes: JN I'm seeing this error when installing mysql-server-3.23.32 on FreeBSD4.2. Use /usr/ports on FreeBSD, and make sure you have the C++ compiler fixes from mid-january (ie, update FreeBSD to 4.2-STABLE). -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - 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: Problem with the UPDATE
"GLC" == Gerald L Clark [EMAIL PROTECTED] writes: GLC You do not say what version you are running. GLC Older versions did not allow updating the primary key field in that GLC manner. he's not updating the primary key field. - 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: BSDI 4.2?
"AH" == Alan Halls [EMAIL PROTECTED] writes: AH Anyone have any luck building Mysql 3.32.23 on a BSDI 4.2 machine? I get an AH error during the make command. Using extreme powers of mental telepathy, we might be able to guess your problem. However, if you told us exactly what the errors were, it would be much easier for those of us without such powers. My guess is you need to use "gmake" instead of "make". That always worked for me. - 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: What proportion of sites use MySQL.
"AS" == Andy Stowell [EMAIL PROTECTED] writes: AS One of my clients has asked me to find out a rough idea as to what AS proportion of database enabled websites use the MySQL database. Exactly 67.2341231123123% Now really, how on earth do you expect to come up with such a statistic? How can you even tell when a site is database backed let alone what database it is using? You just can't do it. So therefore, sticking with the rule that 93.234% of all statistics are just made up, I made one up for you ;-) -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - 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: INSTALLATION QUESTION on Cobalt Raq3
"l" == lkeeton [EMAIL PROTECTED] writes: l First does anybody know the website address for that searchable l site that allows you to search on mysql archive emails. I would l appreciate if I could get that. I also am looking for opinions on Does anyone read the footers on the messages they get from the mailing list or are they just wasting electrons on my box? - 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: mySQL vs Oracle
"AR" == Ann Ricchiazzi [EMAIL PROTECTED] writes: AR I am trying to choose between mySQL and Oracle for a Linux server. My AR specific questions are: AR 1) Will mySQL handle 3000 hits/day well? You need to define what a "hit" is. Is it a simple select on the primary key of a single table or a multi-table join without indexes? How are your "hits" distributed over the duration of the day? Also, how big are you expecting your data tables to be? I'd venture to say that yes, MySQL can handle 3000 queries per day, but it is hard to say without knowing what your load expectations are. AR 2) Does mySQL handle multi-media file formats? For example, if I want to AR store audio clips, or Flash movie clips, or PowerPoint presentations, AR can I do so? MySQL can store binary objects. You probably don't want to do that for these things but instead store a pointer to a URL or filesystem location. The file system access would be much faster than cramming the data down the database socket connection. AR We make the decision this decision at 3:00 today. Your advice will be AR most helpful. Luckily you're on the west coast. It is already 3:30 here. ;-) - 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: inserts with now() resulting in replication-problems
"JK" == Jan Kirchhoff [EMAIL PROTECTED] writes: JK If the Slave gets out of sync (loses the connection to the server), connects JK again and tries to catch up, it processes those two queries *within one JK second* which would result in an duplicate primary key on the slave. The JK Slave would abort with an error and the replication would stop. But then the slave is still not in sync since the data is different. That doesn't seem to make sense for a replication scheme... Just seems wrong to me, but what do I know ;-) - 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