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 wrote:
> All
>> 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
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
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 wha
On Mon, 12 Jan 2009 16:25:12 +0530, Chandru 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 2>>bkp.err
>
> check if you get some thing in the b
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 | am
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
> >
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
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
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 wrote:
> Hi All,
>
> I got the followi
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 Mailing
Hi All,
I got the following tables:
table items
+-+-++-+--+--+--+
| accountcode | invoicecode | invitemqty | packagecode | itemcode |
packagename | packagedesc |
+-+--
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 i
Hi,
On Mon, Jan 12, 2009 at 4:28 AM, Krishna Chandra Prajapati
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 --error-numbers=1048 --hos
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 2>>bkp.err
check if you get some thing in the bkp.err file.
Regards,
Chandru,
www.mafiree.com
On Mon, Jan 12, 20
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 mk-slave-restart
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
17 matches
Mail list logo
