Apparently nothing. Just the "Show process list" query.
70100 | | localhost | | Query |0 | NULL |
show full processlist
Thanks,
Sairam Krishnamurthy
+1 612 859 8161
On 01/03/2011 01:51 AM, Ananda Kumar wrote:
What is the output of "show full processlist"
On Mon, Jan 3, 2011 at 1:
What is the output of "show full processlist"
On Mon, Jan 3, 2011 at 1:10 PM, Sairam Krishnamurthy wrote:
> Hi all,
>
> I set up replication some days back. Because of some internal issues we
> canceled the replication and reset the master to be a normal database
> server. But after this "revert"
Hi all,
I set up replication some days back. Because of some internal issues we
canceled the replication and reset the master to be a normal database
server. But after this "revert", the database is unusually slow.
It was slow because of the discussion below when replication was on. But
I wo
Hey Adarsh,
If no downtime then the only way is lock with write on the table, move to
the new space, create symlink, flush the table.
Remember, this symlinks will have issues if you execute any maintenance on
these tables which are moved.
Better idea - As the tables are MyISAM, move one database
Dear all,
I am working on a stable solution for resolving Space Issue of data
directory of MyISAM tables.
We have a table of 70GB in /hdd-1/mysql_data path and there is 10GB
space available space in Hard Disk.Now the table expects to grow upto 150Gb.
I have some doubts regarding Symlinking a
Another option would be to mangle your insert statement with some other
language like PHP, Python, Ruby, etc. so that the inserts are MULTI inserts
instead. Something like:
INSERT INTO `T_DMU_History` (`DM_History_DM_ID`, `DM_History_Customer_ID`)
VALUES (13071, 299519),
VALUES (13071, 299520),
VA
Jerry,
Use "Load Data Infile" when loading a lot of data. Whoever is giving
you the data should be able to dump it to a CSV file. Your imports will be
much faster.
Mike
At 07:51 PM 1/2/2011, you wrote:
I'm trying to load data into a simple table, and it is taking many hours (and
still
I have a table with a column pv (int)
I want to fetch all the rows r such that (r.pv)+1 is the pv-value of another
row.
what the sql looks like? thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...
I'm trying to load data into a simple table, and it is taking many hours (and
still not done). I know hardware, etc., can have a big effect, but NOTHING
should have this big an effect.
=
us-gii >show create table t_dmu_history\G
*** 1. row ***
