[EMAIL PROTECTED] wrote:
is this relevant ?
We've been looking at connection graphs, but MySQL doesn't seem to reach
that limit. However, these are timely based measurements, so it could've
peaked in between, although highly unlikely.
I'm not very comfortable tweaking these values in a
You haven't told how many members are there.
Anyway... i've worked out something with a colleague at work...
Given your tables:
*CREATE TABLE `list_problem_members` ( `id` int(11) NOT NULL
auto_increment, `member` varchar(11) NOT NULL default '', PRIMARY KEY
(`id`) );*
**
*CREATE TABLE
I am very sorry for ask the question.
I want to know mysql support ipv6 or not
if support, which is the version from
best regards!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
zhengjc wrote:
I am very sorry for ask the question.
I want to know mysql support ipv6 or not
if support, which is the version from
best regards!
Here, this might help:
http://www.ngn.euro6ix.org/IPv6/mysql/
Regards
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me!
Song Ken Vern-E11804 wrote:
It seems like different version are doing things differently.
This is the most normal thing in the world!
Looking through the newsgroups forums, I understand that that mysql5.0
will
prepend the tablename to each column.
But I don't understand what does
Sandy wrote:
Hi
code snippet
select max(f1) as nf1 , max(f2) as nf2, max(f3) as nf3, max(f4) as nf4 from
table
/code
How can I extract a max value from the 4 columns of the result ?
ex: greatest(nf1,nf2,nf3,nf4)
Thanks
SELECT MAX (max(f1) as nf1 , max(f2) as nf2, max(f3) as nf3,
古雷 wrote:
Hello:
If I use Multiple-Master Replication with two mysql server, when one of them
goes down(disk crashed) must I shutdown the good one to recover the
Multiple-Master Replication ?
I think yes.
Depends on what you mean with recover the Multiple-Master Replication
Do you want to
Quoting Pete Harlan ([EMAIL PROTECTED]):
MySQL version 5.0.18
| Mar 14 00:32:59 zwart mysqld[29820]: *** glibc detected *** double
| free or corruption (!prev): 0x012b1ab0 ***
You don't say which versions of glibc or the kernel you're running,
but if you're running
Hello Heikki,
can you email the complete .err log from the server to
[EMAIL PROTECTED]
the complete log is about 50 mb, since a lot of errors occur.
I am interested in what caused the very first crash in the server. Now your
database seems to be seriously corrupt, since the log sequence
Hi Jorrit,
Jorrit Kronjee wrote:
[EMAIL PROTECTED] wrote:
is this relevant ?
We've been looking at connection graphs, but MySQL doesn't seem to
reach that limit. However, these are timely based measurements, so it
could've peaked in between, although highly unlikely.
I'm not very
Marten,
Marten Lehmann wrote:
Hello Heikki,
can you email the complete .err log from the server to
[EMAIL PROTECTED]
the complete log is about 50 mb, since a lot of errors occur.
I am interested in what caused the very first crash in the server. Now
your
database seems to be seriously
Mark Leith wrote:
Hi Jorrit,
Jorrit Kronjee wrote:
[EMAIL PROTECTED] wrote:
is this relevant ?
We've been looking at connection graphs, but MySQL doesn't seem to
reach that limit. However, these are timely based measurements, so it
could've peaked in between, although highly unlikely.
I have found the answer
snip
select max(greatest(f1,f2,f3 .)) from table
/snip
Sandy [EMAIL PROTECTED] a écrit dans le message de news:
[EMAIL PROTECTED]
Hi
code snippet
select max(f1) as nf1 , max(f2) as nf2, max(f3) as nf3, max(f4) as nf4
from table
/code
How can I extract a
Hello!
I'm having a weird problem i'd like to hear your opinions about:
| [18:44] [EMAIL PROTECTED]:~] # mysqlcheck v games
| v.games
| error: Table './v/games' is marked as crashed and should be repaired
| [18:44] [EMAIL PROTECTED]:~] # mysqlcheck -r v games
| v.games
any one of the servers could go down in many ways like
1) disk crash
2) replication failure
3) power failure
4) any hardware component failure
5) OS hang
6) Network failure
7) MYSQL bug
8) table corruption etc ...
9) or just scheduled donwtime
in any case what really matters is the difference
That usually means the table is corrupt beyond repair and nothing is really
fixing it or there is something one cannot easily comprehend ( this usually
happens with inconsistency among deleted records and some kind of mismatch
that occurs) -anyway what I would really advice in this case is to
Well,
ok, we need to stress this more in the manual. A few users have
misunderstood that ibdata files would no longer be needed if one uses
innodb_file_per_table.
ib_logfiles are always needed. How else can InnoDB recover after a crash.
but how can I repair my existing ib-files so that the
Are there any documents, help files, tutorials, or anything on the MySQL
Workbench program? I've played with it, and just can't figure out how to
use some of it's features.
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I am using freeradius with MySql and what I would like to do is create
in my radius table an user with attributes stating a start and stop
date.
I would like to be able to do a bulk entry (more than 1 at a time) or
would love for this to be web based.
Is this process out there?
Thanks
Well, I'm doing something stupid because that is what the bosses want. I
appreciate the suggestions, I think the CSV string format is the way to
go.
David Godsey
David Godsey wrote:
I know, I know, sounds like something that should be done in the
presentation layer, howerver if possible,
Thanks Shawn,
Believe you me, I share your reaction to this architecture...I had to spend
2 hours coding a ruby script to get the data into the kludgy form needed for
the data import (though I do find that thing kind of fun...but it's not the
best use of my time on the job). Fortunately the
After a 23days of running mysql, I have a 3GB database. When I use an
application
called base(v.1.2.2) a web based intrusion detection analysis console, the
mysqld utilization
shoots up to over 90% and stays there until the application times out or is
terminated.
Question: Have I made some
Quoting Kishore Jalleda ([EMAIL PROTECTED]):
That usually means the table is corrupt beyond repair and nothing is really
fixing it or there is something one cannot easily comprehend ( this usually
happens with inconsistency among deleted records and some kind of mismatch
that occurs)
Have you tried the following myisamchk option:
--extend-check, -e
Check the table very thoroughly. This is quite slow if the
table has many indexes. This option should only be used in
extreme cases. Normally, myisamchk or myisamchk
--medium-check should be able to determine whether there
Quoting [EMAIL PROTECTED] ([EMAIL PROTECTED]):
Have you tried the following myisamchk option:
--extend-check, -e
Yup. But that won't even work at ALL:
# myisamchk -e games.MYI
Checking MyISAM file: games.MYI
Data records: 10644 Deleted blocks: 0
- check file-size
- check record
what's the result of
SHOW CREATE TABLE games
??
I'd drop the indexes on the games table, and then run repair tables,
and then put the indexes back in. Worth a shot.
-Sheeri
On 3/29/06, Sander Smeenk [EMAIL PROTECTED] wrote:
Quoting [EMAIL PROTECTED] ([EMAIL PROTECTED]):
Have you tried
Quoting sheeri kritzer ([EMAIL PROTECTED]):
what's the result of
SHOW CREATE TABLE games
It gives me the create statement for that table.
All perfectly normal. MyISAM table, latin1 charset.
I'd drop the indexes on the games table, and then run repair tables,
and then put the indexes back
According to the manual, 64 to 32 bit shouldn't matter, it should work
fine as long as they're both little endian, or they're both big
endian.
I've copied MyISAM tables from 64 to 32 bit without a problem.
BTW, I suggested that because in the error it said:
myisamchk: error: Key in wrong
Quoting sheeri kritzer ([EMAIL PROTECTED]):
According to the manual, 64 to 32 bit shouldn't matter, it should work
fine as long as they're both little endian, or they're both big
endian.
This friend of mine said he also had major problems moving 32-64.
Crashing mysql's, but not corrupt
Jacob, Raymond A Jr wrote:
After a 23days of running mysql, I have a 3GB database. When I use an
application
called base(v.1.2.2) a web based intrusion detection analysis console, the
mysqld utilization
shoots up to over 90% and stays there until the application times out or is
terminated.
Hello All,
I am running across a very weird problem.
Sometimes when a person paste text from a Worddoc
into the text field of our webapp, the insert fails. Unfortunately
I am not seeing the failure in the logs. There are a lot of factors
to consider. The path to mysql looks like this.
Firefox
Marten,
- Original Message -
From: Marten Lehmann [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, March 29, 2006 7:52 PM
Subject: Re: innodb errors on startup
Well,
ok, we need to stress this more in the manual. A few users have
misunderstood that ibdata
If they are pasting from Word, there is a lot of Word-proprietary XML and
formatting that is being pasted as well.
Your insert statement may be failing because:
1) Because of the XML and formatting, the statement is going beyond
the TEXT fields limit;
2) There are ' (single
I'm migrating a database from 4.0.12 on Solaris to 4.0.18-0 on Red Hat
Linux. A few of the tables have a 0 (zero) in the auto_increment primary
key column. However, when importing, the 0 in the insert is translated to
the next available auto_increment value thus causing a duplicate key
situation
Vinny [EMAIL PROTECTED] wrote on 03/29/2006 03:52:33 PM:
Hello All,
I am running across a very weird problem.
Sometimes when a person paste text from a Worddoc
into the text field of our webapp, the insert fails. Unfortunately
I am not seeing the failure in the logs. There are a lot of
Stanton, Brian wrote:
I'm migrating a database from 4.0.12 on Solaris to 4.0.18-0 on Red Hat
Linux. A few of the tables have a 0 (zero) in the auto_increment primary
key column. However, when importing, the 0 in the insert is translated to
the next available auto_increment value thus causing a
Are you saying just change the row with the 0 value as the
PK, and change the FK's in the related tables to point to
the new value instaed of 0?
If so, would this move the row logically to the end of the
table, if the 0 PK was replaced with the next auto_increment
value?
I suppose that
[EMAIL PROTECTED] wrote:
Are you saying just change the row with the 0 value as the
PK, and change the FK's in the related tables to point to
the new value instaed of 0?
Yes.
If so, would this move the row logically to the end of the
table, if the 0 PK was replaced with the next
On 30/03/2006 12:31 p.m., Daniel Kasak wrote:
[EMAIL PROTECTED] wrote:
I suppose that would be alot easier than trying to bump the PK and
related FK values of the whole table by 1, just to give the first row
in the table the auto_increment value of 1?
Yes. That sounds messy.
What about
Thanks a lot. I'll try.
- Original Message -
From: Kishore Jalleda [EMAIL PROTECTED]
To: 古雷 [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Wednesday, March 29, 2006 11:53 PM
Subject: Re: Multiple-Master Replication recovery
any one of the servers could go down in many ways like
1)
mysql desc MSGDB_20060330;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
| CREATETIME| char(14)| NO | |
Hi folks. I come to the list with another compound question.
My middleware allows me to build any syntax for the actual sql
statement, so I'm trying to minimize the work done to insert several
records at one try. I currently have multiple insert statements, but
can't find any reference to
That is, in fact, the exact correct syntax. What error are you
getting when you try to run that on the commandline? What version of
MySQL are you using?
-Sheeri
On 3/29/06, Rich [EMAIL PROTECTED] wrote:
Hi folks. I come to the list with another compound question.
My middleware allows me to
Hi,
Iam running a mysql server 5.0.15 over Redhat linux es4. My disk space
has exhausted. so i need to add a new ibdata file to my /etc/my.cnf
configuration. I followed the following procedure to do so.
1. I checked the ibdata1 file size.
when i do a du -sh ibdata1 , i get the size to be 443M
You can override MySQL behaviour of generating a new value if you insert a 0
into an auton_increment field.
Quoting from the manual:
NO_AUTO_VALUE_ON_ZERO affects handling of AUTO_INCREMENT columns.
Normally, you generate the next sequence number for the column by inserting
either NULL or 0
45 matches
Mail list logo