SLOW performance over network
mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2 Strange, strange problem. Everything was fine yesterday morning, then all of a sudden any query over the network takes a REALLY long time to return. If I log in at the server console, every query is snappy-fast. There had been no changes to clients or server when this happened. All other networking services on the machine seem to be fine. Processors are between 0-3% utilization, disk is at 8% utilization. Server runs apache as well. There are many php pages on this web server that access the database, and display the results, all snappy-fast as usual. I still use the old MySQL Administrator GUI on my windows box. A simple 'select * from tablename' that would return only three records takes just over a minute to return (although it says '3 records returned in 0.0086 seconds' at the bottom). I have many ODBC clients accessing this server as well, they all have slowness problems too. I'm stumped. What could possibly be causing this issue? Thanks for any ideas! Jim CONFIDENTIALITY NOTICE: This message is directed to and is for the use of the above-noted addressee only, and its contents may be legally privileged or confidential. If the reader of this message is not the intended recipient, you are hereby notified that any distribution, dissemination, or copy of this message is strictly prohibited. If you have received this message in error, please delete it immediately and notify the sender. This message is not intended to be an electronic signature nor to constitute an agreement of any kind under applicable law unless otherwise expressly indicated herein.
Re: SLOW performance over network
On Thu, Sep 29, 2011 at 7:12 AM, Jim Moseby jmos...@elasticfabrics.com wrote: I still use the old MySQL Administrator GUI on my windows box. A simple 'select * from tablename' that would return only three records takes just over a minute to return (although it says '3 records returned in 0.0086 seconds' at the bottom). I have many ODBC clients accessing this server as well, they all have slowness problems too. I'm stumped. What could possibly be causing this issue? Wild Guess: Does DNS resolution, especially reverse dns resolution, still work on the mysql server? ...Todd -- If Americans could eliminate sugary beverages, potatoes, white bread, pasta, white rice and sugary snacks, we would wipe out almost all the problems we have with weight and diabetes and other metabolic diseases. -- Dr. Walter Willett, Harvard School of Public Health -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: SLOW performance over network
Yeah: # host 72.30.2.43 /* yahoo.com */ 43.2.30.72.in-addr.arpa domain name pointer ir1.fp.vip.sk1.yahoo.com. # host 10.1.20.97 /* my windows box */ 97.20.1.10.in-addr.arpa has no PTR record Todd Lyons tly...@ivenue.com 9/29/2011 10:26 AM On Thu, Sep 29, 2011 at 7:12 AM, Jim Moseby jmos...@elasticfabrics.com wrote: I still use the old MySQL Administrator GUI on my windows box. A simple 'select * from tablename' that would return only three records takes just over a minute to return (although it says '3 records returned in 0.0086 seconds' at the bottom). I have many ODBC clients accessing this server as well, they all have slowness problems too. I'm stumped. What could possibly be causing this issue? Wild Guess: Does DNS resolution, especially reverse dns resolution, still work on the mysql server? ..Todd -- If Americans could eliminate sugary beverages, potatoes, white bread, pasta, white rice and sugary snacks, we would wipe out almost all the problems we have with weight and diabetes and other metabolic diseases. -- Dr. Walter Willett, Harvard School of Public Health -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=jmos...@elasticfabrics.com CONFIDENTIALITY NOTICE: This message is directed to and is for the use of the above-noted addressee only, and its contents may be legally privileged or confidential. If the reader of this message is not the intended recipient, you are hereby notified that any distribution, dissemination, or copy of this message is strictly prohibited. If you have received this message in error, please delete it immediately and notify the sender. This message is not intended to be an electronic signature nor to constitute an agreement of any kind under applicable law unless otherwise expressly indicated herein.
replication between two tables in same database
Hi I've a Innodb and MyISAM table in the SAME database that I wish to replicate the data between the two because I need to use FULLTEXT searching on the MyISAM table. Is this possible ? If so how do I do it. Thanks Neil
Re: replication between two tables in same database
Am 29.09.2011 18:56, schrieb Tompkins Neil: Hi I've a Innodb and MyISAM table in the SAME database that I wish to replicate the data between the two because I need to use FULLTEXT searching on the MyISAM table. Is this possible ? If so how do I do it. in short: no in longer: why in the world are you using the wrong engine if you need fulltext-search? mysql 5.6 semmes to start support this in innodb, but currently not replication is based on binlogs and contains database/table so there is no dirty trick do this on one server except let run a script and copy the table-contents per cronjob signature.asc Description: OpenPGP digital signature
Re: replication between two tables in same database
Sounds like a job for CREATE TRIGGER to me. :) http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html Tompkins Neil neil.tompk...@googlemail.com 9/29/2011 12:56 PM Hi I've a Innodb and MyISAM table in the SAME database that I wish to replicate the data between the two because I need to use FULLTEXT searching on the MyISAM table. Is this possible ? If so how do I do it. Thanks Neil CONFIDENTIALITY NOTICE: This message is directed to and is for the use of the above-noted addressee only, and its contents may be legally privileged or confidential. If the reader of this message is not the intended recipient, you are hereby notified that any distribution, dissemination, or copy of this message is strictly prohibited. If you have received this message in error, please delete it immediately and notify the sender. This message is not intended to be an electronic signature nor to constitute an agreement of any kind under applicable law unless otherwise expressly indicated herein.
Re: replication between two tables in same database
Yes, unless I can set-up some sort of replication between the two tables. On Thu, Sep 29, 2011 at 6:05 PM, Reindl Harald h.rei...@thelounge.netwrote: please do NOT post off-list! so your only workaround is like '%whatever%' currently Am 29.09.2011 19:04, schrieb Tompkins Neil: The reason I'm using Innodb is because the usage of foreign keys in short however, we need a couple of the tables to support FULLTEXT searching which Innodb does not support. On Thu, Sep 29, 2011 at 6:01 PM, Reindl Harald h.rei...@thelounge.netwrote: Am 29.09.2011 18:56, schrieb Tompkins Neil: Hi I've a Innodb and MyISAM table in the SAME database that I wish to replicate the data between the two because I need to use FULLTEXT searching on the MyISAM table. Is this possible ? If so how do I do it. in short: no in longer: why in the world are you using the wrong engine if you need fulltext-search? mysql 5.6 semmes to start support this in innodb, but currently not replication is based on binlogs and contains database/table so there is no dirty trick do this on one server except let run a script and copy the table-contents per cronjob -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm
Re: replication between two tables in same database
We've succesfully used FULLTEXT searching on another application that does not need Innodb tables. In addition for the FULLTEXT searching we use things like IN BOOLEAN MODE as well - so for our project Like %% is not enough. On Thu, Sep 29, 2011 at 6:13 PM, Reindl Harald h.rei...@thelounge.netwrote: you do not need any replication or myisam for select * from table where field like '%input%'; for most workloads this is enough and you have not the problem with stop-words, minimum input length and so on Am 29.09.2011 19:07, schrieb Tompkins Neil: Yes, unless I can set-up some sort of replication between the two tables. On Thu, Sep 29, 2011 at 6:05 PM, Reindl Harald h.rei...@thelounge.net wrote: please do NOT post off-list! so your only workaround is like '%whatever%' currently Am 29.09.2011 19:04, schrieb Tompkins Neil: The reason I'm using Innodb is because the usage of foreign keys in short however, we need a couple of the tables to support FULLTEXT searching which Innodb does not support. On Thu, Sep 29, 2011 at 6:01 PM, Reindl Harald h.rei...@thelounge.net wrote: Am 29.09.2011 18:56, schrieb Tompkins Neil: Hi I've a Innodb and MyISAM table in the SAME database that I wish to replicate the data between the two because I need to use FULLTEXT searching on the MyISAM table. Is this possible ? If so how do I do it. in short: no in longer: why in the world are you using the wrong engine if you need fulltext-search? mysql 5.6 semmes to start support this in innodb, but currently not replication is based on binlogs and contains database/table so there is no dirty trick do this on one server except let run a script and copy the table-contents per cronjob -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm
Re: replication between two tables in same database
so mysql is currently the wrong database for your project sad but true, you can not have fulltext-search and innodb this time Am 29.09.2011 19:15, schrieb Tompkins Neil: We've succesfully used FULLTEXT searching on another application that does not need Innodb tables. In addition for the FULLTEXT searching we use things like IN BOOLEAN MODE as well - so for our project Like %% is not enough. On Thu, Sep 29, 2011 at 6:13 PM, Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.net wrote: you do not need any replication or myisam for select * from table where field like '%input%'; for most workloads this is enough and you have not the problem with stop-words, minimum input length and so on Am 29.09.2011 19:07, schrieb Tompkins Neil: Yes, unless I can set-up some sort of replication between the two tables. On Thu, Sep 29, 2011 at 6:05 PM, Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.netwrote: please do NOT post off-list! so your only workaround is like '%whatever%' currently Am 29.09.2011 19:04, schrieb Tompkins Neil: The reason I'm using Innodb is because the usage of foreign keys in short however, we need a couple of the tables to support FULLTEXT searching which Innodb does not support. On Thu, Sep 29, 2011 at 6:01 PM, Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.netwrote: Am 29.09.2011 18:56, schrieb Tompkins Neil: Hi I've a Innodb and MyISAM table in the SAME database that I wish to replicate the data between the two because I need to use FULLTEXT searching on the MyISAM table. Is this possible ? If so how do I do it. in short: no in longer: why in the world are you using the wrong engine if you need fulltext-search? mysql 5.6 semmes to start support this in innodb, but currently not replication is based on binlogs and contains database/table so there is no dirty trick do this on one server except let run a script and copy the table-contents per cronjob -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33 tel:%2B43%20%281%29%20595%203999%2033, m: +43 (676) 40 221 40 tel:%2B43%20%28676%29%2040%20221%2040 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33 tel:%2B43%20%281%29%20595%203999%2033, m: +43 (676) 40 221 40 tel:%2B43%20%28676%29%2040%20221%2040 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm signature.asc Description: OpenPGP digital signature
Re: replication between two tables in same database
You could look into the sphinx engine http://sphinxsearch.com/about/sphinx/ No experience with this personally though - Derek On Sep 29, 2011, at 1:07 PM, Tompkins Neil wrote: Yes, unless I can set-up some sort of replication between the two tables. On Thu, Sep 29, 2011 at 6:05 PM, Reindl Harald h.rei...@thelounge.netwrote: please do NOT post off-list! so your only workaround is like '%whatever%' currently Am 29.09.2011 19:04, schrieb Tompkins Neil: The reason I'm using Innodb is because the usage of foreign keys in short however, we need a couple of the tables to support FULLTEXT searching which Innodb does not support. On Thu, Sep 29, 2011 at 6:01 PM, Reindl Harald h.rei...@thelounge.netwrote: Am 29.09.2011 18:56, schrieb Tompkins Neil: Hi I've a Innodb and MyISAM table in the SAME database that I wish to replicate the data between the two because I need to use FULLTEXT searching on the MyISAM table. Is this possible ? If so how do I do it. in short: no in longer: why in the world are you using the wrong engine if you need fulltext-search? mysql 5.6 semmes to start support this in innodb, but currently not replication is based on binlogs and contains database/table so there is no dirty trick do this on one server except let run a script and copy the table-contents per cronjob -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: replication between two tables in same database
But I could create an additional myisam table to overcome my problem providing I can get the data to synchronise between the two tables On 29 Sep 2011, at 18:16, Reindl Harald h.rei...@thelounge.net wrote: so mysql is currently the wrong database for your project sad but true, you can not have fulltext-search and innodb this time Am 29.09.2011 19:15, schrieb Tompkins Neil: We've succesfully used FULLTEXT searching on another application that does not need Innodb tables. In addition for the FULLTEXT searching we use things like IN BOOLEAN MODE as well - so for our project Like %% is not enough. On Thu, Sep 29, 2011 at 6:13 PM, Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.net wrote: you do not need any replication or myisam for select * from table where field like '%input%'; for most workloads this is enough and you have not the problem with stop-words, minimum input length and so on Am 29.09.2011 19:07, schrieb Tompkins Neil: Yes, unless I can set-up some sort of replication between the two tables. On Thu, Sep 29, 2011 at 6:05 PM, Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.netwrote: please do NOT post off-list! so your only workaround is like '%whatever%' currently Am 29.09.2011 19:04, schrieb Tompkins Neil: The reason I'm using Innodb is because the usage of foreign keys in short however, we need a couple of the tables to support FULLTEXT searching which Innodb does not support. On Thu, Sep 29, 2011 at 6:01 PM, Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.netwrote: Am 29.09.2011 18:56, schrieb Tompkins Neil: Hi I've a Innodb and MyISAM table in the SAME database that I wish to replicate the data between the two because I need to use FULLTEXT searching on the MyISAM table. Is this possible ? If so how do I do it. in short: no in longer: why in the world are you using the wrong engine if you need fulltext-search? mysql 5.6 semmes to start support this in innodb, but currently not replication is based on binlogs and contains database/table so there is no dirty trick do this on one server except let run a script and copy the table-contents per cronjob -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33 tel:%2B43%20%281%29%20595%203999%2033, m: +43 (676) 40 221 40 tel:%2B43%20%28676%29%2040%20221%2040 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33 tel:%2B43%20%281%29%20595%203999%2033, m: +43 (676) 40 221 40 tel:%2B43%20%28676%29%2040%20221%2040 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: replication between two tables in same database
Derek is right. The Sphynx search engine is much faster than MyISAM's full text search engine. It will work on InnoDb tables so you don't have to export the data to MyISAM. Mike At 01:43 PM 9/29/2011, you wrote: But I could create an additional myisam table to overcome my problem providing I can get the data to synchronise between the two tables On 29 Sep 2011, at 18:16, Reindl Harald h.rei...@thelounge.net wrote: so mysql is currently the wrong database for your project sad but true, you can not have fulltext-search and innodb this time Am 29.09.2011 19:15, schrieb Tompkins Neil: We've succesfully used FULLTEXT searching on another application that does not need Innodb tables. In addition for the FULLTEXT searching we use things like IN BOOLEAN MODE as well - so for our project Like %% is not enough. On Thu, Sep 29, 2011 at 6:13 PM, Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.net wrote: you do not need any replication or myisam for select * from table where field like '%input%'; for most workloads this is enough and you have not the problem with stop-words, minimum input length and so on Am 29.09.2011 19:07, schrieb Tompkins Neil: Yes, unless I can set-up some sort of replication between the two tables. On Thu, Sep 29, 2011 at 6:05 PM, Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.netwrote: please do NOT post off-list! so your only workaround is like '%whatever%' currently Am 29.09.2011 19:04, schrieb Tompkins Neil: The reason I'm using Innodb is because the usage of foreign keys in short however, we need a couple of the tables to support FULLTEXT searching which Innodb does not support. On Thu, Sep 29, 2011 at 6:01 PM, Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.netwrote: Am 29.09.2011 18:56, schrieb Tompkins Neil: Hi I've a Innodb and MyISAM table in the SAME database that I wish to replicate the data between the two because I need to use FULLTEXT searching on the MyISAM table. Is this possible ? If so how do I do it. in short: no in longer: why in the world are you using the wrong engine if you need fulltext-search? mysql 5.6 semmes to start support this in innodb, but currently not replication is based on binlogs and contains database/table so there is no dirty trick do this on one server except let run a script and copy the table-contents per cronjob -- Mit besten GrüÃen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33 tel:%2B43%20%281%29%20595%203999%2033, m: +43 (676) 40 221 40 tel:%2B43%20%28676%29%2040%20221%2040 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm -- Mit besten GrüÃen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33 tel:%2B43%20%281%29%20595%203999%2033, m: +43 (676) 40 221 40 tel:%2B43%20%28676%29%2040%20221%2040 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm -- Mit besten GrüÃen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=mo...@fastmail.fm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: replication between two tables in same database
I'm not sure it would work in my environment of IIS and MySQL ? On 29 Sep 2011, at 20:10, mos mo...@fastmail.fm wrote: Derek is right. The Sphynx search engine is much faster than MyISAM's full text search engine. It will work on InnoDb tables so you don't have to export the data to MyISAM. Mike At 01:43 PM 9/29/2011, you wrote: But I could create an additional myisam table to overcome my problem providing I can get the data to synchronise between the two tables On 29 Sep 2011, at 18:16, Reindl Harald h.rei...@thelounge.net wrote: so mysql is currently the wrong database for your project sad but true, you can not have fulltext-search and innodb this time Am 29.09.2011 19:15, schrieb Tompkins Neil: We've succesfully used FULLTEXT searching on another application that does not need Innodb tables. In addition for the FULLTEXT searching we use things like IN BOOLEAN MODE as well - so for our project Like %% is not enough. On Thu, Sep 29, 2011 at 6:13 PM, Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.net wrote: you do not need any replication or myisam for select * from table where field like '%input%'; for most workloads this is enough and you have not the problem with stop-words, minimum input length and so on Am 29.09.2011 19:07, schrieb Tompkins Neil: Yes, unless I can set-up some sort of replication between the two tables. On Thu, Sep 29, 2011 at 6:05 PM, Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.netwrote: please do NOT post off-list! so your only workaround is like '%whatever%' currently Am 29.09.2011 19:04, schrieb Tompkins Neil: The reason I'm using Innodb is because the usage of foreign keys in short however, we need a couple of the tables to support FULLTEXT searching which Innodb does not support. On Thu, Sep 29, 2011 at 6:01 PM, Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.netwrote: Am 29.09.2011 18:56, schrieb Tompkins Neil: Hi I've a Innodb and MyISAM table in the SAME database that I wish to replicate the data between the two because I need to use FULLTEXT searching on the MyISAM table. Is this possible ? If so how do I do it. in short: no in longer: why in the world are you using the wrong engine if you need fulltext-search? mysql 5.6 semmes to start support this in innodb, but currently not replication is based on binlogs and contains database/table so there is no dirty trick do this on one server except let run a script and copy the table-contents per cronjob -- Mit besten GrüÃen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33 tel:%2B43%20%281%29%20595%203999%2033, m: +43 (676) 40 221 40 tel:%2B43%20%28676%29%2040%20221%2040 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm -- Mit besten GrüÃen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33 tel:%2B43%20%281%29%20595%203999%2033, m: +43 (676) 40 221 40 tel:%2B43%20%28676%29%2040%20221%2040 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm -- Mit besten GrüÃen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=mo...@fastmail.fm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=neil.tompk...@googlemail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: replication between two tables in same database
Am thinking now that it might be best to use MySQL 5.6 as this is a new project still in development and we will have the new FullText Search with Innodb On 29 Sep 2011, at 18:43, Andrew Moore eroomy...@gmail.com wrote: Hey Neil, I read your question too quickly and jumped to the conclusion you weren't sure MyISAM replicates in a mixed storage engine environment. However, you could still potentially replicate the data using standard replication and even on the same server (different instances). InstanceA --- InstanceB MyISAM InnoDB You could use Triggers but be careful if you decide to do that because triggers and replication don't play well together in some circumstances. As a side note and something that was already mentioned to you, MySQL are working on 5.6 and as part of that release InnoDB will have it's own implementation of FT indexing. HTH Andy On Thu, Sep 29, 2011 at 6:00 PM, Tompkins Neil neil.tompk...@googlemail.com wrote: Can you give me any pointers ? On Thu, Sep 29, 2011 at 5:59 PM, Andrew Moore eroomy...@gmail.com wrote: Hey Neil, it sure is possible through standard replication configuration. Hth Andy On Sep 29, 2011 5:57 PM, Tompkins Neil neil.tompk...@googlemail.com wrote: Hi I've a Innodb and MyISAM table in the SAME database that I wish to replicate the data between the two because I need to use FULLTEXT searching on the MyISAM table. Is this possible ? If so how do I do it. Thanks Neil
MySQL 5.6
Hi Does anyone know when the production release of MySQL 5.6 will be out ? Thanks Neil
Re: replication between two tables in same database
I've now just upgraded to MySQL 5.6 on our test server. Just trying to find a date as to when it will go into production On Thu, Sep 29, 2011 at 8:10 PM, mos mo...@fastmail.fm wrote: Derek is right. The Sphynx search engine is much faster than MyISAM's full text search engine. It will work on InnoDb tables so you don't have to export the data to MyISAM. Mike At 01:43 PM 9/29/2011, you wrote: But I could create an additional myisam table to overcome my problem providing I can get the data to synchronise between the two tables On 29 Sep 2011, at 18:16, Reindl Harald h.rei...@thelounge.net wrote: so mysql is currently the wrong database for your project sad but true, you can not have fulltext-search and innodb this time Am 29.09.2011 19:15, schrieb Tompkins Neil: We've succesfully used FULLTEXT searching on another application that does not need Innodb tables. In addition for the FULLTEXT searching we use things like IN BOOLEAN MODE as well - so for our project Like %% is not enough. On Thu, Sep 29, 2011 at 6:13 PM, Reindl Harald h.rei...@thelounge.netmailto: h.rei...@thelounge.net** wrote: you do not need any replication or myisam for select * from table where field like '%input%'; for most workloads this is enough and you have not the problem with stop-words, minimum input length and so on Am 29.09.2011 19:07, schrieb Tompkins Neil: Yes, unless I can set-up some sort of replication between the two tables. On Thu, Sep 29, 2011 at 6:05 PM, Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.net**wrote: please do NOT post off-list! so your only workaround is like '%whatever%' currently Am 29.09.2011 19:04, schrieb Tompkins Neil: The reason I'm using Innodb is because the usage of foreign keys in short however, we need a couple of the tables to support FULLTEXT searching which Innodb does not support. On Thu, Sep 29, 2011 at 6:01 PM, Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.net**wrote: Am 29.09.2011 18:56, schrieb Tompkins Neil: Hi I've a Innodb and MyISAM table in the SAME database that I wish to replicate the data between the two because I need to use FULLTEXT searching on the MyISAM table. Is this possible ? If so how do I do it. in short: no in longer: why in the world are you using the wrong engine if you need fulltext-search? mysql 5.6 semmes to start support this in innodb, but currently not replication is based on binlogs and contains database/table so there is no dirty trick do this on one server except let run a script and copy the table-contents per cronjob -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33 tel:%2B43%20%281%29%20595%**203999%2033, m: +43 (676) 40 221 40 tel:%2B43%20%28676%29%2040%**20221%2040 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/**signature.asc.what.htmhttp://www.thelounge.net/signature.asc.what.htm -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33 tel:%2B43%20%281%29%20595%**203999%2033, m: +43 (676) 40 221 40 tel:%2B43%20%28676%29%2040%**20221%2040 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/**signature.asc.what.htmhttp://www.thelounge.net/signature.asc.what.htm -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/**signature.asc.what.htmhttp://www.thelounge.net/signature.asc.what.htm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?**unsub=mo...@fastmail.fmhttp://lists.mysql.com/mysql?unsub=mo...@fastmail.fm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?**unsub=neil.tompkins@** googlemail.comhttp://lists.mysql.com/mysql?unsub=neil.tompk...@googlemail.com
Re: SLOW performance over network
Check your auto negotiate setting on your nic. Run ifconfig and see if there are a lot of errors. On Sep 29, 2011 10:13 AM, Jim Moseby jmos...@elasticfabrics.com wrote: Yeah: # host 72.30.2.43 /* yahoo.com */ 43.2.30.72.in-addr.arpa domain name pointer ir1.fp.vip.sk1.yahoo.com. # host 10.1.20.97 /* my windows box */ 97.20.1.10.in-addr.arpa has no PTR record Todd Lyons tly...@ivenue.com 9/29/2011 10:26 AM On Thu, Sep 29, 2011 at 7:12 AM, Jim Moseby jmos...@elasticfabrics.com wrote: I still use the ol... To unsubscribe: http://lists.mysql.com/mysql?unsub=jmos...@elasticfabrics.com CONFIDENTIALITY NOTICE: This message is directed to and is for the use of the above-noted addres...
Re: MySQL 5.6
在 2011-09-29四的 21:29 +0100,Tompkins Neil写道: Hi Does anyone know when the production release of MySQL 5.6 will be out ? Thanks Neil no idea,maybe you could find some useful info from http://forge.mysql.com/wiki/Development_Cycle. -- Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) Using Gmail? Please read this important notice: http://www.fsf.org/campaigns/jstrap/gmail?10073. signature.asc Description: This is a digitally signed message part