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 allow
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]
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 all,
I Have a table with followin structure where i have orgunit and parent
and value
orgunitparent value
12 10 x
1512 y
16
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
orgunit parent value
12 10 x
15 12 y
16 12 z
17 12 p
Now here 15,16, and 17 are the children of 12 and 12
is the
child of 10.Now i need a query which gives the sum of all the
children of
12 and nturn 12 itself . i.e I need the sum(values(15+16+17+12)).Is
there a
query which gives the
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:
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, but
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
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
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
11 matches
Mail list logo