Presumably because you are removing 189 gigabyte of data and 549 gigabyte of
indexes, all of which need to be marked as deleted in your innodb file. I/O
is rather expensive :-)
On MyISAM this would have been close to instantaneous (as you probably
expected), because the datafile is used only for
Hello,
I am getting an error
#HY000Incorrect string value: '\xE9l\xE9tra...' for column '
Not quite sure why. hex E9 is a lower case e acute found in CP1252
and googling seems to tell me that the latin1 charset that I have set for the
table should display this OK.
mysql V 5.0.54a on Redhat
Are you running selinux?
On Sunday, November 8, 2009, Sebastiaan van Erk sebs...@sebster.com wrote:
Hi,
$ ls -ld /tmp/mysql
drwxr-xr-x 2 mysql mysql 4096 2009-11-08 10:14 /tmp/mysql
$ ls -ld /tmpfs/mysql
drwxr-xr-x 2 mysql mysql 40 2009-11-08 10:12 /tmpfs/mysql
So I don't see the
Hi,
Not that I am aware of. I'm just running a standard out of the box 9.10
Ubuntu, upgraded from 9.04. Note that when I'm using /tmp/mysql or /tmp
as tmpdir, at least InnoDB starts up, but then I still get the strange
temp file operation failed message instead of the constraint when I
try
At 12:13 PM 11/8/2009, John Meyer wrote:
Now I'm wondering if I can use this query in an update to set a variable in
a second table
Users
--
User_id VARCHAR(50)
. . .
User_active BITINT(1)
I want to set user_active to 0 where the user_id is in the query below.
select user_id,
Under InnoDb, you could use file-per-table which would have
significantly reduced the inter-dependencies.. given the large data
size and heavy I/O you report, it might be a wise way to go.
- michael dykman
On Mon, Nov 9, 2009 at 3:41 AM, Johan De Meersman vegiv...@tuxera.be wrote:
Presumably
I am very new to MySQL and trying to use Navicat Report Builder to format a
renewal invoice to send to our registrants. The renewal fees are fixed for
each type of registrant but the actual fee is not part of the database and must
be computed as the report is generated. As far as I can tell,
Hi,
I need to get rid of all data in one table of my database. The table just has
old
Data that I no longer need. What is the best way to accomplish this?
If I simply drop the table what can I do prior to dropping the table to ensure
I can recreate the table right after I drop it? I still need
If DELETE FROM [table_name] is not suitable for your task then try -
TRUNCATE [table_name] : http://dev.mysql.com/doc/refman/5.0/en/truncate.html
Regards,
Mikhail
Jones, Keven wrote:
Hi,
I need to get rid of all data in one table of my database. The table just has
old
Data that I no longer
Just truncate the table, this will get rid of data whilst preserving the
table structure.
eg: truncate tablename;
regards
John
On Mon, 2009-11-09 at 11:20 -0500, Jones, Keven wrote:
Hi,
I need to get rid of all data in one table of my database. The table just has
old
Data that I no
Hi Sebastiaan,
Steps to fix the issue.
1. Do proper shutdown of mysql server.
2. Check the error log file that mysql server is shutdown properly.
3. Remove log files (ib_logfile0 and ib_logfile1).
4. Start mysql server (The log files will be created automatically)
Thanks,
Krishna
On Sun, Nov 8,
Hi Michael,
Already using innodb_file_per_table.
Krishna
On Mon, Nov 9, 2009 at 9:39 PM, Michael Dykman mdyk...@gmail.com wrote:
Under InnoDb, you could use file-per-table which would have
significantly reduced the inter-dependencies.. given the large data
size and heavy I/O you report, it
Is there anyone, who is using the mysql 64 bit on Intel(R) Xeon(R) CPU
processors? Will it be *IntelEM64T* ?
Regards,
Sanjeev Sagar wrote:
Hello Everyone,
I would like to verify that which mysql 64 bit binary i need to use
for PowerEdge 1950 ?
Will it be *IntelEM64T* ?
Following is the
Sanjeev,
As far as I know that is the version you should use.
Shain
Sanjeev Sagar wrote:
Is there anyone, who is using the mysql 64 bit on Intel(R) Xeon(R) CPU
processors? Will it be *IntelEM64T* ?
Regards,
Sanjeev Sagar wrote:
Hello Everyone,
I would like to verify that which mysql 64
Hi;
I created a user and then granted privileges:
grant all to victor identified by 'pw';
Looked good. Tried to log in as victor an no go. Please advise.
Victor
Never mind. Had to add @'localhost'
On Mon, Nov 9, 2009 at 4:20 PM, Victor Subervi victorsube...@gmail.comwrote:
Hi;
I created a user and then granted privileges:
grant all to victor identified by 'pw';
Looked good. Tried to log in as victor an no go. Please advise.
Victor
Hi,
I followed the instructions but still get:
mysql delete from mytable;
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key
constraint fails (temp file operation failed)
mysql
Regards,
Sebastiaan
Krishna Chandra Prajapati wrote:
Hi Sebastiaan,
Steps to fix the
Hi,
I have the following model:
Domain (*)-(1) Account (*)-(1) User
That is, each user belongs to exactly 1 account, an account can have
multiple users; each account belongs to a single domain, and a domain
can have multiple accounts.
A user has an email address, which must be unique
-Original Message-
From: Jones, Keven [mailto:keven.jo...@ncr.com]
Sent: Monday, November 09, 2009 11:21 AM
To: mysql@lists.mysql.com
Subject: Best way to purge a table
Hi,
I need to get rid of all data in one table of my database. The table just has
old
Data that I no longer need. What
Hi Sagar,
You must use Intel EM64T
Thanks,
Krishna
On Sat, Oct 31, 2009 at 5:45 AM, Sanjeev Sagar
sanjeev.sa...@mypointscorp.com wrote:
Hello Everyone,
I would like to verify that which mysql 64 bit binary i need to use for
PowerEdge 1950 ?
Will it be *IntelEM64T* ?
Following is the
20 matches
Mail list logo