Re: Transfering data from postgresql to MySQL

: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

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

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)

increase mysql max connections over 1024

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

Re: how to increase max connections above 1024 in Linux

] 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

Re: how to increase max connections above 1024 in Linux

. 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

Re: how to increase max connections above 1024 in Linux

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

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

Re: problem with mysql threads on freebsd

? 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

Re: How to set max_connections ?

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

how to define my max_connections?

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

Re: MySQL on iSCSI or IPSAN?

[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

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

mysql connection handshaking

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

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

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

multiple mysql daemons in process

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

Re: My.S.Q.L

://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

Re: InnoDB is better than MyISAM ?

://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

Re: How to mirror MySQL database on two servers?

://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

myisamchk and table corrupt

: 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

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

myisamchk and table corruption

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

myisamchk and table corruption

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

High-Available MySQL Servers topology

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