在 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 **Obviou
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" 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
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 wrote:
> Derek is right. The Sphynx search engine is much faster than MyISAM's full
> text search engine. It will work on InnoDb tables s
Hi
Does anyone know when the production release of MySQL 5.6 will be out ?
Thanks
Neil
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 wrote:
> Hey Neil, I read your question too quickly and jumped to the conclusion you
> weren't sure M
I'm not sure it would work in my environment of IIS and MySQL ?
On 29 Sep 2011, at 20:10, mos 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
>
>
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
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 wrote:
> so mysql is currently the wrong database for your project
> sad but true, you can not have fulltext-search and
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
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 F
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 wrote:
> you do not ne
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 replicat
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 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
Sounds like a job for CREATE TRIGGER to me. :)
http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html
>>> Tompkins Neil 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 searchi
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
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
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 9/29/2011 10:26 AM >>>
On Thu, Sep 29, 2011 at 7:12 AM, Jim Moseby wrote:
> I still u
On Thu, Sep 29, 2011 at 7:12 AM, Jim Moseby 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
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.
19 matches
Mail list logo
