Hi all. I have a 30GB innodb-only database in mysql-5.0.54. I have
always done nightly backups with:
mysqldump --opt db_name db_name.sql -p
Recently this started failing with:
Error 2013: Lost connection to MySQL server
I have checked all tables for corruption - nothing found. Also as far as
I
Hi Baron,
I want to use mk-slave-restart (maatkit tool) to restart the slave if 1048
errors comes up.
[r...@linux18 ~]# mk-slave-restart --always --daemonize
--defaults-file=/etc/my1.cnf --error-numbers=1048 --host=localhost --port
3307 --user=root
[r...@linux18 ~]# ps aux | grep
Hi,
please increase your interactive_timeout variable to some big number and
also try to log the erros if any thing by using the command:
mysqldump --opt db_name db_name.sql -p 2bkp.err
check if you get some thing in the bkp.err file.
Regards,
Chandru,
www.mafiree.com
On Mon, Jan 12, 2009
Hi,
On Mon, Jan 12, 2009 at 4:28 AM, Krishna Chandra Prajapati
prajapat...@gmail.com wrote:
Hi Baron,
I want to use mk-slave-restart (maatkit tool) to restart the slave if 1048
errors comes up.
[r...@linux18 ~]# mk-slave-restart --always --daemonize
--defaults-file=/etc/my1.cnf
I have the following tables:
Customer: id,ssn
Customer_Id: id,customer_id,id_num
The customer table holds customers along with their SSN and the customer_id
table holds identifications for each customer (Driver's License, State
Issued ID, Student ID, etc). The SSN column from the customer table
Hi All,
I got the following tables:
table items
+-+-++-+--+--+--+
| accountcode | invoicecode | invitemqty | packagecode | itemcode |
packagename | packagedesc |
I'm using MySQL 5.1 and if I execute:
alter table mytable delay_key_write=1;
it takes about an hour to rebuild the table. Why? As far as I know it is
not changing the table structure. So why does it have to make a copy of the
table and reload all the data?
TIA
Mike
--
MySQL General
The error is not in the join, but in the fact that you have two invoices
with the same invocecode. The items are retrieved and displayed for both
invoices.
If this is correct, select distinct should solve your problem.
On Mon, Jan 12, 2009 at 5:59 PM, Ron r...@silverbackasp.com wrote:
Hi All,
In the last episode (Jan 12), mos said:
I'm using MySQL 5.1 and if I execute:
alter table mytable delay_key_write=1;
it takes about an hour to rebuild the table. Why? As far as I know it
is not changing the table structure. So why does it have to make a
copy of the table and reload all
At 12:14 PM 1/12/2009, Dan Nelson wrote:
In the last episode (Jan 12), mos said:
I'm using MySQL 5.1 and if I execute:
alter table mytable delay_key_write=1;
it takes about an hour to rebuild the table. Why? As far as I know it
is not changing the table structure. So why does it have to
In the last episode (Jan 12), mos said:
At 12:14 PM 1/12/2009, Dan Nelson wrote:
In the last episode (Jan 12), mos said:
I'm using MySQL 5.1 and if I execute:
alter table mytable delay_key_write=1;
it takes about an hour to rebuild the table. Why? As far as I
know it is not
All too frequently, I see commits stuck in this database. What can I do to
speed that up? Or, abort if it takes more than 40 seconds? This query here
for example appears to take 443 seconds so far.
From mysqladmin processlist:
Id| User | Host | db | Command |Time | State | Info
14010 |
On Mon, 12 Jan 2009 16:25:12 +0530, Chandru chandru@gmail.com wrote:
Hi,
please increase your interactive_timeout variable to some big number and
also try to log the erros if any thing by using the command:
mysqldump --opt db_name db_name.sql -p 2bkp.err
check if you get some
You didn't say much about your workload, tuning or table, but...
Looks like you have a configuration problem, or slow disks, or InnoDB
contention problems.
You can get faster hardware, or make your log files or log buffer
bigger (but first figure out whether they're too small!), or figure
out
I'm also having a similar issue with some tables I've been trying to dump
(total data set is around 3TB). I'm dumping directly from one host to
another (mysqldump -hSOURCE DATABASE | mysql -hLOCALHOST DATABASE) using
mysql 4.1.22. One system is Solaris 10 SPARC, while the other is Solaris 10
x64
Why would delay_key_writes require a table rebuild? It's not
modifying the data. Reloading tens of millions of rows for several
hours seems to be a waste of time.
It probably flips a bit in the .frm file or something like that, but I
have not investigated it myself.
My guess is that you can
Hi Scott,
I believe something wrong with innodb parameters. It should be optimum. In
your case it might be too high or too low. Take a look at log file size.
Please send your show variables and show status data to reach at conclusion.
On Tue, Jan 13, 2009 at 3:35 AM, Scott Edwards
17 matches
Mail list logo