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
>-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 n
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 acro
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 issu
Never mind. Had to add @'localhost'
On Mon, Nov 9, 2009 at 4:20 PM, Victor Subervi wrote:
> 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 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
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 bit
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 cp
Hi Michael,
Already using innodb_file_per_table.
Krishna
On Mon, Nov 9, 2009 at 9:39 PM, Michael Dykman 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 might be a wis
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,
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
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
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 t
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,
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 wrote:
> Presumably because you are r
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, max(tweet_cre
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
Are you running selinux?
On Sunday, November 8, 2009, Sebastiaan van Erk 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 difference
>
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 5.
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 t
20 matches
Mail list logo