Hi,
i have a system that has media files ==> users can be fans of media ( so
media becomes their favorite ).
the table itself:
CREATE TABLE media_fans(
id int(11) unsigned not null auto_increment,
user_id int(11) unsigned not null,
media_id int(11) unsigned not null,
primary key(id),
We have 5.0.27 installed on a CentOS machine that doesn't have a ton
of disk space. Is it possible to point the data directory to lie on a
samba connected share? The samba share does not support Unix file
permissions so it is not possible to set mysql as the owner of the
files. Is this possible
At 03:54 PM 1/25/2007, you wrote:
> Another thing to consider is:
heh, silly mail client :). Another thing to consider is this:
http://dev.mysql.com/doc/falcon/en/index.html
Though it's "Not recommended for production use", I've heard people still use
it in production environments.
--
Chri
Hi Olaf,
> I know the innodb vs myisam issue comes up quite frequently. I went
through
> old threads and could not find an answer to my questions.
>
> Generally, is there any reason/scenario not to use innodb?
>
> >From a feature perspective, I do not need full text indices, foreign keys
> are use
> Another thing to consider is:
heh, silly mail client :). Another thing to consider is this:
http://dev.mysql.com/doc/falcon/en/index.html
Though it's "Not recommended for production use", I've heard people still use
it in production environments.
--
Chris White
PHP Programmer
Interfuel
--
On Friday 26 January 2007 06:17, Olaf Stein wrote:
> From a feature perspective, I do not need full text indices,
This is about the only reason I've seen MyISAM promoted as table engine of
choice.
> I know this is a very general question but it seems not to make any sense
> not to use innodb h
Size is an issue with InnoDB and deleting records does not reduce the size of the file. In my experience, the performance drop off
is considerable once the table reaches a certain size. And it's not a slight drop off over time.
If your table is going to get very large, I would reccommend using MyI
On 1/25/07, Sid Lane <[EMAIL PROTECTED]> wrote:
all,
I have been tasked with upgrading a critical 3.23.55 database to 5.0
(.27-ish).
short version is it's never been upgraded because authors have moved on
and
nobody's sure of everything that uses it.
I enabled the general log a few days ago an
Hi All
I know the innodb vs myisam issue comes up quite frequently. I went through
old threads and could not find an answer to my questions.
Generally, is there any reason/scenario not to use innodb?
>From a feature perspective, I do not need full text indices, foreign keys
are usefull but not n
all,
I have been tasked with upgrading a critical 3.23.55 database to 5.0(.27-ish).
short version is it's never been upgraded because authors have moved on and
nobody's sure of everything that uses it.
I enabled the general log a few days ago and have a good body of data with
which to go code hu
I am doing tests so I want to easy take my DB and make a full copy of
it into a test db everytime I want to test something against the
non-produciton version of DB. What is the easiest way to do this.
So I have a DB called "backlog" and I want to copy it's structure and
data into "backlog_test"
I am doing tests so I want to easy take my DB and make a full copy of
it into a test db everytime I want to test something against the
non-produciton version of DB. What is the easiest way to do this.
So I have a DB called "backlog" and I want to copy it's structure and
data into "backlog_test"
Thanks!
OK, here's where my understanding of MySQL and how indices work get
fuzzy.
In my scenario what would the difference between (I tested with
different indices these and included the query times with the EXPLAIN
outputs):
(1) creating separate indices on entity_id and also on use
Hi,
try
CREATE INDEX geo_idx ON users(entity_id, user_type);
Filip
Alex Arul napsal(a):
and also an index on users.entity_id (will help the join) should solve your
problem.
Thanks
Alex
On 1/24/07, Brent Baisley <[EMAIL PROTECTED]> wrote:
You should create indexes on the fields you search
> The databases are on the same server, however the login details for each
> database are different.
Hmm, I guess that the currently connected user needs to have access
to both databases, how else would it get the data?
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
On Thursday 25 January 2007 11:08, Neil Tompkins wrote:
> The databases are on the same server, however the login details for each
> database are different.
>
A query executes with the credentials of the authentication used to set up the
connection. If you want to query two tables simultaneously
The databases are on the same server, however the login details for each
database are different.
From: "Martijn Tonies" <[EMAIL PROTECTED]>
To:
Subject: Re: Query Two Databases
Date: Thu, 25 Jan 2007 11:56:37 +0100
> Not sure if this is possible or not. But I've two identical tables in
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Neil Tompkins schrieb:
> Not sure if this is possible or not. But I've two identical tables in
> two different databases. Is it possible to retrieve data from the
> different tables in one query ?
(SELECT * FROM db1.table) UNION (SELECT * FROM db2.t
> Not sure if this is possible or not. But I've two identical tables in two
> different databases. Is it possible to retrieve data from the different
> tables in one query ?
Yes, by using this notation:
select *
from mydatabase.mytable
Martijn Tonies
Database Workbench - development tool fo
Not sure if this is possible or not. But I've two identical tables in two
different databases. Is it possible to retrieve data from the different
tables in one query ?
Thanks
Neil
_
MSN Hotmail is evolving check out the new Wi
hi,
AFAIK, if we start mysqld with --low-priority-updates, it sets table updation a
lower priority than the SELECT statements, irrespective of storage engines.
hence it will affect the priority of the update operation.
Ref: http://mysql.justdn.org/doc/refman/5.1/en/table-locking.html
- Orig
21 matches
Mail list logo
