Re: Transfering data from postgresql to MySQL
now I managed to dump table schema with pg_dump. However, is there any schema converting tool available? I don't want to edit each table schema to make it mysql-compliant. Ideas? Pahud On Mon, 18 Oct 2004 12:23:41 +0200, Jochem van Dieten [EMAIL PROTECTED] wrote: On Mon, 18 Oct 2004 18:08:24 +0800, Patrick Hsieh wrote: I am planing to transfer data from postgresql to mysql. Is there any useful tools, scripts or utilities to achieve this? pg_dump First dump the schema, edit that until you have something MySQL understands. Then dump the data using the -d option so you have full inserts instead of the usual COPY syntax and feed the file to the MySQL command line client. Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Patrick Hsieh() [EMAIL PROTECTED] MSN: [EMAIL PROTECTED] | ICQ: 97133580 Skype: pahud_at_pahud.net | YIM: pahudnet pub 1024D/203F7DF1 2001/12/25 Patrick Hsieh (Pahud) [EMAIL PROTECTED] http://pgp.mit.edu:11371/pks/lookup?op=getsearch=0x203F7DF1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Transfering data from postgresql to MySQL
Hello list, I am planing to transfer data from postgresql to mysql. Is there any useful tools, scripts or utilities to achieve this? Any infomation is highly appreciated! --- Patrick Hsieh() [EMAIL PROTECTED] MSN: [EMAIL PROTECTED] | ICQ: 97133580 Skype: pahud_at_pahud.net | YIM: pahudnet pub 1024D/203F7DF1 2001/12/25 Patrick Hsieh (Pahud) [EMAIL PROTECTED] http://pgp.mit.edu:11371/pks/lookup?op=getsearch=0x203F7DF1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
how to check .MYI file withour shutdown database
Hello list, Can I use myisamchk to check the index without shutdown the mysql server? - 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
increase mysql max connections over 1024
Hello list, I'd like to increase the number of max connections above 1024 in Linux. I think I have to increase PTHREAD_THREADS_MAX in /usr/include/bits/local_lim.h /* The number of threads per process. */ #define _POSIX_THREAD_THREADS_MAX 64 /* This is the value this implementation supports. */ #define PTHREAD_THREADS_MAX 1024 My question is, what should I do after modify this file. Should I rebuild mysql-server .deb package again? Or I just set mysql max connections and restart mysql server? -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - 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 to increase max connections above 1024 in Linux
Hello Tonu Samuel [EMAIL PROTECTED], Thanks, but my Debian woody did not install glibc package. Should I get the package source, modify the PTHREAD_THREADS_MAX value and rebuild glibc package for further installation? On Thu, 13 Jun 2002 08:55:35 +0200 (EET) Tonu Samuel [EMAIL PROTECTED] wrote: On Thu, 13 Jun 2002, Patrick Hsieh wrote: Hello, I want to raise the max connections in mysql. Due to the linux limix thread limitation, I can only increase the number to around 1024. How can I break the limitation? This is topic of glibc (assuming you are using kernel 2.4 at least). Look into links (I found them with Google right now): http://www.volano.com/linuxnotes.html http://www.mysqldeveloper.com/4.x-bk_tree/Docs/glibc-2.2.5.patch Tonu - 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 -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - 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 to increase max connections above 1024 in Linux
Hello Tonu Samuel [EMAIL PROTECTED], home:~# dpkg -l | grep libc ii libc6 2.2.5-6GNU C Library: Shared libraries and Timezone ii libc6-dev 2.2.5-6GNU C Library: Development Libraries and Hea I think I have to rebuild one of them and reinstall the package again. Which one should I choose? On Thu, 13 Jun 2002 08:55:35 +0200 (EET) Tonu Samuel [EMAIL PROTECTED] wrote: On Thu, 13 Jun 2002, Patrick Hsieh wrote: Hello, I want to raise the max connections in mysql. Due to the linux limix thread limitation, I can only increase the number to around 1024. How can I break the limitation? This is topic of glibc (assuming you are using kernel 2.4 at least). Look into links (I found them with Google right now): http://www.volano.com/linuxnotes.html http://www.mysqldeveloper.com/4.x-bk_tree/Docs/glibc-2.2.5.patch Tonu - 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 -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - 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 to increase max connections above 1024 in Linux
Hello Tonu Samuel [EMAIL PROTECTED], In my Debian woody, I found relative definition in /usr/include/bits/local_lim.h /* The number of threads per process. */ #define _POSIX_THREAD_THREADS_MAX 64 /* This is the value this implementation supports. */ #define PTHREAD_THREADS_MAX 1024 I think I have to modify this file to raise the number of max threads, however, what shoudl I do after modifying this file? Should I recompile the Linux kernel? On Thu, 13 Jun 2002 08:55:35 +0200 (EET) Tonu Samuel [EMAIL PROTECTED] wrote: On Thu, 13 Jun 2002, Patrick Hsieh wrote: Hello, I want to raise the max connections in mysql. Due to the linux limix thread limitation, I can only increase the number to around 1024. How can I break the limitation? This is topic of glibc (assuming you are using kernel 2.4 at least). Look into links (I found them with Google right now): http://www.volano.com/linuxnotes.html http://www.mysqldeveloper.com/4.x-bk_tree/Docs/glibc-2.2.5.patch Tonu - 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 -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - 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
how to increase max connections above 1024 in Linux
Hello, I want to raise the max connections in mysql. Due to the linux limix thread limitation, I can only increase the number to around 1024. How can I break the limitation? -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - 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 mysql threads on freebsd
Hello Leo De Geer [EMAIL PROTECTED], the problen nr 2 i dont have but the server we have dont handle the load on one cpu. at the moment we are runing the sql on a linux instead (same hardwere) but i sucks. alla auter servers is freebsd and they run mutch beter Why MySQL on Linux sucks? Can you give any concret examples? -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - 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 to set max_connections ?
Hello Steve Katen [EMAIL PROTECTED], How do you tell the number of connections currently in use? On Mon, 10 Jun 2002 18:17:19 -0700 Steve Katen [EMAIL PROTECTED] wrote: what do you mean it doesn't do anything? you should be able to set it on the command line as: --set-variable=max_connections=200 or you could edit the my.cnf file that mysql is using when it starts-up. if you can't find the my.cnf, then you should create one. here is a link to the manpage and some default entires on mysql.com: http://www.mysql.com/doc/O/p/Option_files.html either way, you can check to see if the max connections has been updated by running the below command at the mysql prompt: show variables; katen At 06:05 PM 6/10/2002, Rekha Das wrote: Hi all, I am trying to set max_connections to 200 on my server. Currently it is 100. My mysql version 3.22.32. My problem is I am not able to find my.cnf. And if I set the variable on command line like this: --set-variable = max_connections=200; Then it does not do anything. What am I doing wrong ? Thanks, Rekha - 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 -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - 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
how to define my max_connections?
Hello list, I am running mysql-3.23.49 on Linux 2.4.18 for production purpose. Now I want to define a proper max_connections value in mysql. The document said, The maximum number of connects MySQL is depending on how good the thread library is on a given platform. Linux or Solaris should be able to support 500-1000 simultaneous connections, depending on how much RAM you have and what your clients are doing. My question is, how can I raise the max_connections value as many as possible? Does it depend on the hardware resource limit or how the OS implement thread library? -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - 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 on iSCSI or IPSAN?
Hello Dan Nelson [EMAIL PROTECTED], So, what will happen if I use iSCSI/Fiberchannel/NFS to share the storage? Well, I am just worried about the chance of data loss in MySQL 3.23 two-way replication. I hope there is a share storage and 2 or more write-only mysql servers could mount the device. In this case, I don't worry about the raw data consistency and can balance the write-only connections to mutiple mysql servers. Ideas? I am looking a solution to implement load balance amount write-only mysql servers yet keeping the data consistency. On Thu, 23 May 2002 01:16:35 -0500 Dan Nelson [EMAIL PROTECTED] wrote: In the last episode (May 22), Jeremy Zawodny said: On Wed, May 22, 2002 at 03:52:33PM +0800, Patrick Hsieh wrote: Hello Dan Nelson [EMAIL PROTECTED], Is there any lock problem on iSCSI or SAN environment? Say, mutliple mysql server mount the backend iSCSI or SAN storage device. Is it safe? It is safe if you use MySQL's external (file) locking. You will also need a filesystem that supports shared storage. Sistina's Global File System (GFS) is the only such filesystem available for Linux, afaik (at only $995 per node; shared storage is NOT easy to implement). If you do not have such a filesystem, you will most likely completely trash your filesystem when you mount it from the 2nd machine. iSCSI/FibreChannel is not NFS. It is block-level access to raw storage just like SCSI or IDE. -- Dan Nelson [EMAIL PROTECTED] -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - 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 on iSCSI or IPSAN?
Hello Dan Nelson [EMAIL PROTECTED], Is there any lock problem on iSCSI or SAN environment? Say, mutliple mysql server mount the backend iSCSI or SAN storage device. Is it safe? On Fri, 17 May 2002 12:49:01 -0500 Dan Nelson [EMAIL PROTECTED] wrote: In the last episode (May 18), Patrick Hsieh said: Hello list, How does MySQL support iSCSI or IPSAN infrastructure? MySQL does not care. Your OS handles access to devices. As long as your OS can put a filesytem on it, MySQL will use it. Is it wise to put MySQL data in iSCSI or IPSAN storage appliance? As long as your hardware is stable I don't see it as any different from a Fibre-channel SAN. -- Dan Nelson [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 -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - 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 connection handshaking
Hello list, I am planing to write a script to telnet mysql server(port:3306) and try to verify the server status. When I try something like this: home:~ #telnet localhost 3306 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. , 3.23.49-logĂșm|zn:u`^,Connection closed by foreign host. home:~ # Well, it seems that I have no idea complete the handshaking. Is there any way that I can type something and expect something to return? -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - 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 on iSCSI or IPSAN?
Hello list, How does MySQL support iSCSI or IPSAN infrastructure? Is it wise to put MySQL data in iSCSI or IPSAN storage appliance? Any experiences appreciated. -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - 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 thread resource control?
Hello list, Is it possible to limit the mysql thread resource? Say, when there is a heavy-load query, it will not use 99% of the cpu time and afect other system processes. Idea? -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - 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 mysql daemons in process
Hello list, I have 38 mysqld processes running in one single machine, is it normal? 11:48:43 up 49 days, 15:11, 34 users, load average: 0.02, 0.06, 0.00 275 processes: 265 sleeping, 1 running, 9 zombie, 0 stopped CPU states: 3.2% user, 4.3% system, 0.0% nice, 92.5% idle Mem:900464K total, 840808K used,59656K free, 277532K buffers Swap: 498004K total, 327808K used, 170196K free, 221132K cached PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 31277 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:04 mysqld 31279 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:07 mysqld 31280 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31281 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31282 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31283 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31284 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31285 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:12 mysqld 31286 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:02 mysqld 31287 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:01 mysqld 31288 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31738 mysql 9 0 300M 30M 3004 S 0.0 3.5 4:11 mysqld 7110 mysql 10 0 300M 30M 3004 S 0.5 3.5 6:22 mysqld 12137 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:59 mysqld 16802 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:02 mysqld 16841 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:02 mysqld It seems mysqld has used all of my memory. Any idea? -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatezplay.gpg -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - 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: My.S.Q.L
Hello [EMAIL PROTECTED], It's pretty interesting! Is tere MP3 file available for this song? On Sat, 6 Apr 2002 09:35:12 -0800 (PST) [EMAIL PROTECTED] wrote: Ok... it's Saturday and I've been meaning to share this with a wider audience for years Antti, you'll probably remember this from when I sent this to you shortly after I wrote it (1999)... If anyone would like to record this, let me know! :-) My.S.Q.L (sung to Y.M.C.A by the Village People) Young man, service should not go down. I said, young man, when your data's to be found I said, young man, 'cause Larry Ellison's a clown there's no need to be unhappy. Young man, there's a place you can go. I said, young man, when you're short on your dough. You can use it, as a production database and it takes up a lot less space. It's fun to run MySQL It's fun to run MySQL It has everything for your code to enjoy You can port it to all your toys... It's fun to run MySQL It's fun to run MySQL You can download the source, it's really quite small. Bug fixes are out before the fall... Young man, do you want to pay a fee? I said, young man, this database is free. I said, young man, it helps the economy but you got to know this one thing! No man does it all by himself. I said, young man, it's not about the wealth. Freedom, is part of it of course, We like to call it the Open Source. It's fun to run MySQL It's fun to run MySQL - 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 -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - 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: InnoDB is better than MyISAM ?
Hello Heikki Tuuri [EMAIL PROTECTED], Where can I find InnoDB Hot Backup product? On Sat, 6 Apr 2002 10:35:33 +0300 Heikki Tuuri [EMAIL PROTECTED] wrote: Hi! - Original Message - From: Eric S [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Saturday, April 06, 2002 2:10 AM Subject: Re: InnoDB is better than MyISAM ? On Fri, 5 Apr 2002, BD wrote: At 01:54 PM 4/5/2002, you wrote: I have seen many people saying that InnoDB is a great deal, that InnoDB rocks, etc. and I am concerced about how much better InnoDB is compared to MyISAM tables. Can someone tells me wich one is better ? I know that InnoDB have foreign keys support, but I deal very well without then since now. My interests are justified becaus eI got out of a very old struct ( DBM + Text Files ) and jumped head first into MySQL - MyISAM tables, but my site has a good deal of visitors ( about 30.000 unique visitors by day ) and speed and reliability are my primary concerns. I plan to use replication in MySQL, and I would like to know if InnoDB is better than MyISAM for this. MySQL replication works with InnoDB type tables, and is currently used at several sites. InnoDB Hot Backup (non-free software) makes it possible to set up a new slave without stopping the master or setting any locks on the master. This is a useful feature at sites requiring high availability. One note here is that transactions aren't preserved for replication with InnoDB, so you loose part of one of the major advantages of InnoDB. Rollbacks are O.K., since I don't think that goes out to the slaves until the commit, but if the master or slave goes down after part of a transaction is sent to the slave, you get a partially committed transaction on the slave. How critical this is depends on the application, and still is no worse than MyISAM which has no transactions to begin with. I think Heikki Tuuri has mentioned plans to get this fixed, though I think I remember that he said that the problem was in MySQL, not in the actual InnoDB code, which makes sense. A potential embedded license buyer is interested in getting this fixed. If the deal is closed, we may add the commit marks to the binlog rather soon. Have you ever heard the old saying, If it ain't broke, don't fix it?.bg If your website is mainly for read access to your database then you're not going to need InnoDb. Agreed 100%, but it doesn't hurt too much (except for index sizes) on readonly databases, so on our production system, we standardized on InnoDB for all tables for consistency, though we will allow for exceptions for tables that need features that aren't in InnoDB yet, such as full text searching. InnoDb inserts (for a single user) are much slower (for me it is around 10x slower) than MyISAM because InnoDb does a lot more work. This was not my experience. Without batching the commits, InnoDB lost out to MyISAM on our initial testing by about 1.5x rather than 10x. However, when I committed every 100 or so inserts, InnoDB beat out MyISAM by a small (25%) margin. This was with a single user hitting the database, a perl program that read in a text file, split it into fields, and stuffed it into the database one record at a time (identical programs except for handling the commits()). Now, this wasn't normal database activity, pure inserts into a freshly created table, but the results were still quite impressive. Also, I'm dealing with single-user activity, so there may have been some differences there as well. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - 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 -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - 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 to mirror MySQL database on two servers?
Hello List, Does mysql support raw device? In this case, two or more mysql servers could share the same raw device as the backend storage. On Wed, 3 Apr 2002 17:35:41 +1000 Paul [EMAIL PROTECTED] wrote: Scott, Try the following perl script to copy the contents of one mysql table from a mysql database and insert it's contents into another mysql database on a different host/server/computer under the same table name. Essentially a mirrored copy. Can be useful in a cron or a shedule as it wont output any information or anything. Fill in your database details and let it run. Ensure both mysql's are running on each of the hosts and all the accounts and permissions for each database work etc and try it out :) #!/usr/bin/perl $localuser = mysql; $localpass = mysqlpassword; $localdatabase = mydatabase; $localtable = products; $remoteuser = mysql; $remotepass = mysql; $remotehost = 192.168.1.200; $remotedatabase = mirrordatabase; system (/usr/local/bin/mysqldump -u $localuser --password=$localpass --add-drop-table $localdatabase $localtable | /usr/local/bin/mysql5:32 PM 4/3/2002--user=$remoteuser --password=$remotepass --host=$remotehost $remotedatabase); - Original Message - From: Scott Broderick To: [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 5:07 PM Subject: How to mirror MySQL database on two servers? Does anyone know of a good place to start looking at how to mirror a MySQL database on two different computers? Any help would be great, Thanks Scott - 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 -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - 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
myisamchk and table corrupt
Hello list, There's an corruption in my mysql table. I tried to use myisamchk -o to recovery, but still exists when I use myisamchk -s. What is the possible reason of the problem? linux95:/var/lib/mysql# myisamchk -s stocks/TimelyDeals.MYI myisamchk: ISAM file stocks/TimelyDeals.MYI myisamchk: error: Size of datafile is: 5947722 Should be: 6016194 myisamchk: error: Keyblock size at page 284672 is not correct. Block length: 1022 key length: 2 MyISAM-table 'stocks/TimelyDeals.MYI' is corrupted Fix it using switch -r or -o linux95:/var/lib/mysql# -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - 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
what makes mysql table corrupt?
Hello list, When I periodically do myisamchk -s *.MYI, it sometimes complains that some tables are corrupt. Is there any way to keep mysql tables healthy? What are the reasons to cause the table corruption? Thanks. - 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
myisamchk and table corruption
Hello list, This is the output of mysql myisamchk -s */*.MYI, which seems very badly corrupted. I know myisamchk -o or myisamchk -c will rescue this, but is any idea to know what made the corruptions? myisamchk: ISAM file stocks/TimelyDeals.MYI myisamchk: error: Size of datafile is: 5645430 Should be: 5969700 myisamchk: error: Keyblock size at page 1562624 is not correct. Block length: 772 key length: 2 MyISAM-table 'stocks/TimelyDeals.MYI' is corrupted Fix it using switch -r or -o myisamchk: ISAM file stocks/TimelySecIndex.MYI myisamchk: error: Size of datafile is: 878400Should be: 925920 myisamchk: error: Found key at page 704512 that points to record outside datafile MyISAM-table 'stocks/TimelySecIndex.MYI' is corrupted Fix it using switch -r or -o myisamchk: ISAM file stocks/news.MYI myisamchk: error: Size of datafile is: 516728Should be: 531496 myisamchk: error: Found key at page 113664 that points to record outside datafile myisamchk: error: Record-count is not ok; is 667 Should be: 688 myisamchk: warning: Found667 partsShould be: 688 parts MyISAM-table 'stocks/news.MYI' is corrupted Fix it using switch -r or -o myisamchk: MyISAM file tv2/sectors_names.MYI myisamchk: warning: 1 clients is using or hasn't closed the table properly MyISAM-table 'tv2/sectors_names.MYI' is usable but should be fixed - Original Message Ends -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatezplay.gpg - 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
myisamchk and table corruption
Hello list, This is the output of mysql myisamchk -s */*.MYI, which seems very badly corrupted. I know myisamchk -o or myisamchk -c will rescue this, but is any idea to know what made the corruptions? myisamchk: ISAM file stocks/TimelyDeals.MYI myisamchk: error: Size of datafile is: 5645430 Should be: 5969700 myisamchk: error: Keyblock size at page 1562624 is not correct. Block length: 772 key length: 2 MyISAM-table 'stocks/TimelyDeals.MYI' is corrupted Fix it using switch -r or -o myisamchk: ISAM file stocks/TimelySecIndex.MYI myisamchk: error: Size of datafile is: 878400Should be: 925920 myisamchk: error: Found key at page 704512 that points to record outside datafile MyISAM-table 'stocks/TimelySecIndex.MYI' is corrupted Fix it using switch -r or -o myisamchk: ISAM file stocks/news.MYI myisamchk: error: Size of datafile is: 516728Should be: 531496 myisamchk: error: Found key at page 113664 that points to record outside datafile myisamchk: error: Record-count is not ok; is 667 Should be: 688 myisamchk: warning: Found667 partsShould be: 688 parts MyISAM-table 'stocks/news.MYI' is corrupted Fix it using switch -r or -o myisamchk: MyISAM file tv2/sectors_names.MYI myisamchk: warning: 1 clients is using or hasn't closed the table properly MyISAM-table 'tv2/sectors_names.MYI' is usable but should be fixed - Original Message Ends -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatezplay.gpg - 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
High-Available MySQL Servers topology
Hello list, I am planing to design high-available mysql servers which serve as one single virtual mysql server to application servers. My criteria is: 1. HA(High Availability) Due to mission critical services, we hope the mysql clusters can provide high availability to application servers. In the hardware term, I think hardware raid or software raid is necessary, but which is recommended in mission critical case? In the application/software term, I hope to have load-balancing among mysql servers. Also, I'd like to have fail-over design in it. 2. replication Now we know there's one-way replication in mysql-3.23(ok, maybe two-way replica. is also possible), how reliable is the built-in replication function in mysql-3.23? Can I rely on hardware syncronization solutions like storage appliance solutions? The service based on it(mysql) is not quite mission critical, but we just do not want to lose the high availability. I ask here just want to know how possible can I build a high-available mysql clusters with considerable scalebility. Any ideas are hightly welcome. -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - 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