Jay, mysqld_multi will do what you want, it's a tool to help you manage
two or more mysql daemons on the same host. You can either have the two
databases bind to different IPs or same IP and different ports.
To the other replies in this thread: why wouldn't you want to have
development databases
of features and fixes: http://www.upscene.com/news/20061002.htm
Database Workbench supports:
- Borland InterBase ( 4.x - 8.x )
- Firebird ( 1.x, 2.0 )
- MS SQL Server/MSDE ( v6.5, 7, 2000, 2005, MSDE 1 2, SQL Express )
- MySQL 4, 4.1, 5.0
- Oracle Database ( 8i, 9i, 10g )
- NexusDB ( 2.05 )
If you
Hi,
I remember USE_INDEX optimization hint in Oracle and I have seen
something like this on this list as well but I can't seem to look it
up in the online documentation or the mysql manual sitting on my hard
disk. Can anybody give me pointers as to where I can get
documentation on this
Asif, there's some information here:
http://dev.mysql.com/doc/refman/5.0/en/join.html
It can be a handy tool when you just can't MySQL to make the right
decision (rare) - but it will also result in an error if the index is
later dropped or the name changed.
Dan
On 10/2/06, Asif Lodhi [EMAIL
I have the following piece of a schema that includes nested table
relationships where a child has relationships with both parents and
grand-parents where it CASCADES on one side and RESTRICT on the other:
CREATE TABLE `r180_topic_cd` (
`topic_cd_id` mediumint(9) NOT NULL,
`cd_name`
Is there a detailed source for when innodb creates row or table locks?
I have a situation where one thread is performing this in one
transaction:
UPDATE SomeTable SET WHERE SomeTable.id = N;
This is invoked after another thread has kicked off this long running
query in another
snip
Thanks for the advice.
We've got 12GB of RAM, I'll increase the key_buffer_size.
Unfortunately
I can't turn off indexes, then index after. At these rates, I'd never
catch up.
I don't agree. It takes longer to build the index than to load the data
if
you have indexes active when loading
Hi,
Check for the user in the 'User' Table of 'mysql' database. If there exists
'gamito' User in the User table, then set password will surely do.
Verify:
mysqluse mysql;
mysqlselect * from user;
Thanks
ViSolve DB Team.
- Original Message -
From: Deckard [EMAIL PROTECTED]
To: