Baron Schwartz wrote:
In contrast, InnoDB actually needs to shut down to cleanly close its table
structures before you can physically copy the filesystem.
Actually, not true -- an LVM snapshot (or other snapshot) is a great
way to take a backup of InnoDB. You just need a truly atomic
Jim Ginn wrote:
Jed:
Are you using an in-network IP to access the database ie:
127.0.0.1
192.168.98.##
or are you using a public IP or full domain name ie:
DB001.MY-DOMAIN.COM
...
A very reasonable question. I'm connecting using IP addresses.
$servers = array(
Claudio Nanni wrote:
All, Happy New Year, and let's hope somebody tries to stop the killing in
gaza.
I need to setup a replication slave off a master that is currently
production and not stoppable or lockable(possibly).
If you are using InnoDB, there is a --single-transaction method backup
I've started logging how long my php application takes to login to
mysql, and often it's well below 1 millisecond. However, I'll sometimes
get a wave of long login attempts that take 3 to 6 seconds. I've enabled
skip-name-resolv, and I think that helps. There are no long running
queries on the
Jed Reynolds wrote:
I'm seeing errors in my application where I'm getting from simple
selects every few hours:
I do a flush table activity_profiles; check table activity_profiles;
and the table seems to have fixed itself.
Any thots?
Thanks for the thots, guys. It turns out one of my co
Tompkins Neil wrote:
Hi
We are looking to upgrade our version of mySQL to the latest version of
mySQL 5. One of the main features we are going to think about using is
replication for our website data. Basically we have 2 websites located in
the UK and US which share similar information, and we
Application in php 5.1.6.I'm running MySQL version 5.0.45 on CentOS5
using a HP DL380 with 8G ram and 15krpm raid10 disks. Tables are myisam.
I'm seeing errors in my application where I'm getting from simple
selects every few hours:
SELECT id, host_id, uri_id, profile
FROM
Dave M G wrote:
PHP List, MySQL List
In my PHP environment, I have Magic Quotes turned off, and I use the
mysql_real_escape_string() function clean strings of SQL syntax before
inserting them into my database.
So the data stored in my database does not have escape characters in
it.
Mike Spreitzer wrote:
So I am trying to use mysqldump --tab for the first time. I am running
into the same problem everybody does on their first try --- Errcode: 13. I
have set the permissions on the target directory to be completely liberal
--- anybody can do anything with it --- and I still
what happens when you delete the files that are already in there? Looks
like you're dumping to a file owned by root.
Jed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Grzegorz Paszka wrote:
Hi.
I have extra hdd only for mysql /var/lib/mysql directory.
I have one big database and ten different tables into it.
I had to move three of them into another directory on different hdd becouse
lack of disk space at /var/lib/mysql directory.
Is it possible and how can I
Mike Spreitzer wrote:
Sorry if I have confused people by presenting
evidence in the wrong order. Also, it seems that the .sql file is
written by the client while the .txt file is (attempted to be) written
by the server. Here is a single typescript with all the evidence:
[EMAIL PROTECTED]
12 matches
Mail list logo