Maybe something like this:
select ft.topic, fm.message from forums_topics ft, forums_messages fm
match (ft.topic, fm.message) against (...)
if topic is null then the hit is from fm and vice versa... haven't tried
it, so might not work :)
Steffan A. Cline wrote:
I have 2 tables which have
put this in your my.cnf
"read_only"
this would put the DB in a read only mode, except for the slave threads and
the super users, which/who can still do writes, this option is mostly used
on slaves though .
see http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
Kishore Jalle
I have 2 tables which have full text index on each of their columns.
Table 1 - forums_topics field - topic
Table 2 - forums_messages field - message
Is it possible to search them both in one query and determine which table
the result is being returned from in the search results?
Thanks
In the last episode (Jul 01), Douglas Sims said:
> On Jun 30, 2006, at 11:47 PM, Octavian Rasnita wrote:
> >In the /data/database_name directory I have found a few files I
> >don't know what they are used for. I have seen that some of them are
> >pretty big. I don't think it is safe to delete them,
Those are the files which contain the data in each table in your
MySQL databases. I think the .myd files contain the data, the .myi
files contain indexes, and the .frm files contain schema information.
Douglas Sims
[EMAIL PROTECTED]
On Jun 30, 2006, at 11:47 PM, Octavian Rasnita wrote:
>orgunit parent value
>12 10 x
>15 12 y
>16 12 z
>17
Thanks for all your help. I now have a nice backup script running. What I'm
planning to do a little later this summer is to set up a RAID backup server
on my DSL connection ftp downloading the mysql databases every night from my
co-location server. This way I will have a nice archive of dumps on t
Hi all,
I Have a table with followin structure where i have orgunit and parent
and value
orgunitparent value
12 10 x
1512 y
16
I am attempting to set and and schedule automated MySQL backups using the MySQL
Administrator Tool downloaded from mysql.com. All of my back ups work fien
when I perform them manually. However none of the scheduled backups ever get
done. I am not sure where the glicth is but here is what the
Hi Dan,
The contents of both tables is identically.
I checked both tables with SHOW INDEX FROM ...
and the cardinalities are exactly the same.
Nevertheless, thanks for mentioning that those numbers are estimates.
Regards, Cor
- Original Message -
From: "Dan Buettner" <[EMAIL PROTECTED]
What about partitioning the database?
On 7/1/06, Dan Buettner <[EMAIL PROTECTED]> wrote:
Wow, that is a tough one.
My question would be, how often is older data really accessed? Could
you start incorporating a default date range like "past 3 months" or
"past 1 year" into all searches, but al
11 matches
Mail list logo
