Did you "FLUSH PRIVILEGES"?
I'd also check that the username and passwords are the same for each
host entry, I've had problems if passwords were different for a shared
username from different hosts.
On Apr 24, 2008, at 8:58 AM, Adam Gerson wrote:
I set up a user and entered % for the host.
RedHat centric systems store them in /var/lib/mysql
On Feb 8, 2008, at 2:55 PM, Riccardo Perotti wrote:
Hi all:
Our sistem crashed and we're trying to recover our data. The disc is
fine but the OS is gone, so I'm trying to get at the actual mysql
databases document. Does anybody know where
All,
InnoDB and MyISAM tables are platform independent, is there a reason
why transferring the actual binary files from one system (or mount
point) is not advised? From like OS to like OS, this seems like it
should be okay and you'll only get into trouble with Float/Double.
MySQL Document
aller segments so I can distribute the data over 2 DVD-R (or
multiple CD-R's if so desired.)
Does anyone have any feedback on this approach? Without laying out
money for a higher capacity DVD/BlueRay drive or tape backup system,
what options are you using for data retention?
Thanks for
ic_status <> 2
ORDER BY t.topic_last_post_id DESC
LIMIT 10;
In the evenings there seems to be 10-20 slow queries every hour, time
between them varying from seconds to usually 5-10 minutes.
Cheers,
Gunnar
On fre, januar 4, 20
Gunnar,
us = user (things like MySQL/PHP/Apache)
sy = system (memory management / swap space / threading / kernel
processes and so on)
ni = nice (apps running only when nothing else needs the resource)
id = idle (extra cpu cycles being wasted)
wa = wait state (io wait for disk/network/memory)
I tested this on two related tables, 170K in one and 90K in the other.
Your tables are currently much smaller, so mysql may come up with a
different execution path. For me, the join syntax was far faster.
On 9/21/07, Erik Giberti <[EMAIL PROTECTED]> wrote:
Hello everyone,
The app server in
is to avoid the full table scan? Thank
you in advance for your assistance.
Erik Giberti
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
