Marek,
do not worry:
http://www.innodb.com/ibman.html#InnoDB_history
"
MySQL/InnoDB-4.0.14, July 21, 2003:
...
* Fixed the checksum calculation of data pages. Previously most OS file
system corruption went unnoticed. Note that if you downgrade from version >=
4.0.14 to an earlier version < 4.0.1
I'm testing my application using MySQL 4.1.0. Before I was using 4.0.14
version. Today I've looked into error file of the 4.1.0 where there was
hundreds of new lines with information like this:
InnoDB: Warning: an inconsistent page in the doublewrite buffer
InnoDB: space id 3686351459 page number
Hi!
First: thanks for ideas - I'm adding them to my todo :)
About dates - it's very difficult to say when a particular feature will
be implemented. Anyway, first I'm going to finish with this 2-level
index structure - to implement optimizations that rely on it.
> Any speed/optimization improveme
Dan,
Dan J. Rychlik said:
> Hey,
>
> I have a question about copying a database that was developed on a windows
> os and moving it to a Linux server os. Will this work ? Has it been
> done before ?
>
> Thanks,
>
> -Dan
Yes, I have done it just recently.
Just use the mysqldump-command.
--
O
Thanks so much for the reply...
- Original Message -
From: "Dathan Vance Pattishall" <[EMAIL PROTECTED]>
To: "'Dan J. Rychlik'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, August 27, 2003 2:11 PM
Subject: RE: database from win to lin
> Yes it will work, and it has been do
Yes it will work, and it has been done before.
Copy the *.MY* files and the *.frm files to the linux server.
-->-Original Message-
-->From: Dan J. Rychlik [mailto:[EMAIL PROTECTED]
-->Sent: Wednesday, August 27, 2003 11:31 AM
-->To: [EMAIL PROTECTED]
-->Subject: database from win to lin
Hey,
I have a question about copying a database that was developed on a windows os and
moving it to a Linux server os. Will this work ? Has it been done before ?
Thanks,
-Dan
Hi!
A hot backup (= online backup) means backing up your database without
locking anything for more than a few milliseconds.
If you back up a massive, fast changing, database with
mysqldump --single-transaction, then -- at least in some theoretical
settings -- InnoDB can run out of space in the t
I am still quite new to MySQL and have a basic question. I am using PHP, so
forgive me if this is more a PHP issue.
I want to perform an update to a specific record based on a condition. In
the outer loop, I have Query1, which returns set Result1. Inside this loop,
I run an UPDATE query which r
"Carl B. Constantine" <[EMAIL PROTECTED]> wrote:
> * Victoria Reznichenko ([EMAIL PROTECTED]) wrote:
>> It means that user doesn't have ALTER privilege.
>
> BUT, I've tried granting the user all privs in mysqlcc and it still
> doesn't work. Looking at my other setup, the users look like they are
>
Hello,
Could someone recommend a decent php script that could be used for
database[MySQL]::Web interfacing and management. Preferably open source,
freeware or otherwise [I'll just have to grin & bare it]
Thanks
-- Joe --
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
> >
> > We've got our 3.23 db installed with all the data on the /home
> > partition which is ok. The *-bin.00x logs are also in that data
> > directory. The Var/log/mysql/mysql.log however on our root
> drive has
> > grown to 11gig. Our Root partion is not as large as our
> Home partition
Scott Haneda wrote:
> Anyone else get one of these for every post to this list?
>
> Return-Path: <[EMAIL PROTECTED]>
That offender have now been removed from the list and prevented from
re-subscribing.
Best Wishes
Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
Hi list:
I have the following partial result from an explain select:
| table| type | possible_keys
| key
> > The advantage of other methods is that you avoid all sorts of nasty
> > locking on various parts of your database. The advantage of
> the Hot Copy
> > product that Innobase Oy sell is that it doesn't place any
> locks on your
> > InnoDB table space when it runs.
>
> Wouldn't that break the A
Sorry for reposting , wrong subject in the prebious one
-- Forwarded message --
Date: Wed, 27 Aug 2003 11:17:36 -0400 (EDT)
From: Asif Iqbal <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Replication with multiple servers in Mysql ?
Hi Jeremy Zawodny (and all)
I am using
2003年 8月 28日 木曜日 01:43、Nils Valentin さんは書きました:
> Hi Chris,
>
> 2003年 8月 28日 木曜日 00:54、Chris Nolan さんは書きました:
> > A very good question! One which I will attempt to provide a half-decent
> > answer for.
> >
> > Trying to execute a transaction that involves grabbing massive amounts of
> > data from var
Hi Chris,
2003年 8月 28日 木曜日 00:54、Chris Nolan さんは書きました:
> A very good question! One which I will attempt to provide a half-decent
> answer for.
>
> Trying to execute a transaction that involves grabbing massive amounts of
> data from various tables while still allowing updates to be committed can
>
Hi Chris,
2003年 8月 28日 木曜日 00:54、Chris Nolan さんは書きました:
> A very good question! One which I will attempt to provide a half-decent
> answer for.
>
> Trying to execute a transaction that involves grabbing massive amounts of
> data from various tables while still allowing updates to be committed can
Hi All,
my $0.0.2... anybody correct me please if you know it better...;-)
2003年 8月 27日 水曜日 23:22、P Srinivasulu さんは書きました:
> If the backup solutions are there already, why is that a future
> requirement for Mysql?
>
> Thanks,
> Srinivasulu.
>
> >>> Chris Nolan <[EMAIL PROTECTED]> 8/27/2003 6:41:2
Hello MySQL Team,
I'm working currently on the project where we need
to make a decision what engine would be our main
production database engine.
Could you please help me and shed a light on what
pros and cons MySQL vs Ingres: features, performance,
support, portability among Wintel and Unix ba
A very good question! One which I will attempt to provide a half-decent
answer for.
Trying to execute a transaction that involves grabbing massive amounts of
data from various tables while still allowing updates to be committed can
be tricky. At best, this means performance problems. Please don't
"Li, John" <[EMAIL PROTECTED]> wrote:
>
> Any hint where and how to get mysql 4.1.1?
>
Official binaries will be available in September at:
http://www.mysql.com/downloads/index.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored b
All, the tables are defined as MyISAM. In fact, I left last night and
the Query was still running the convert HEAP to MyISAM Somethings
definately wrong.
I have indices on Name.key, Location.key and Location.cc
the results of the explain :
id| select_type| table | type | possible keys| k
"Jeff McKeon" <[EMAIL PROTECTED]> wrote:
>
> We've got our 3.23 db installed with all the data on the /home partition
> which is ok. The *-bin.00x logs are also in that data directory. The
> Var/log/mysql/mysql.log however on our root drive has grown to 11gig.
> Our Root partion is not as large
Hi Jeremy Zawodny (and all)
I am using your mytop and this is what I am seeing
MySQL on localhost (4.0.13-standard-log)
up 0+10:48:22 [11:14:37]
Queries: 85.6k qps:2 Slow: 207.0 Se/In/Up/De(%):86/05/05/02
qps now:2 Slow qps: 0.0 Threads: 11 ( 2/ 4) 00/
Hi list:
I have the following partial result from an explain select:
| table| type | possible_keys
| key
Dear Mysql Users,
Could you tell me what should I do to get local (polish) daynames from the following
function:
SELECT DAYNAME("1998-02-05");
thanks,
regards,
Lukasz
On Wed, 27 Aug 2003 10:04:02 -0400
Paul DuBois <[EMAIL PROTECTED]> wrote:
> Second reason still applies.
yes, but I suppose he knows what he's trying to do =)
> If it's still something deemed desireable:
>
> ALTER TABLE tbl_name AUTO_INCREMENT = 1;
yes, this is another one possible solution, bu
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 27 August 2003 12:05 pm, I wrote:
> How do I escape UCS2 characters in a latin1 SQL statement?
Okay, so the answer's in the manual. I just didn't look hard enough...
http://www.mysql.com/doc/en/Charset-literal.html
So I do:
'INSERT INT
If the backup solutions are there already, why is that a future
requirement for Mysql?
Thanks,
Srinivasulu.
>>> Chris Nolan <[EMAIL PROTECTED]> 8/27/2003 6:41:27 PM >>>
Hi!
You can currently do this with InnoDB with mysqldump (look at the
--single-transaction switch). I use it for backing up
On Tue, Aug 26, 2003 at 09:26:55PM -0500, Matt W wrote:
> Hi Jesse,
>
> - Original Message -
> From: "Jesse Sheidlower"
>
> > What I'm trying to understand is how you would set up these
> > indexes when you'd always be doing joins with another table.
> > Suppose you have The Canonical CD D
On 26 Aug 2003 at 19:38, Twibell, Cory L wrote:
> I have a query that is inner joined with another table based on
> country codes Select distinct Name.* from Name inner join Location on
> Location.key = Name.key and Location.cc in (' here>');
>From the message you're getting it seems you're using
At 17:56 +0400 8/27/03, Antony Dovgal wrote:
On Wed, 27 Aug 2003 09:38:16 -0400
Paul DuBois <[EMAIL PROTECTED]> wrote:
At 9:05 -0300 8/27/03, bernardaum wrote:
>Hi,
>
>I have a table with an auto_increment field. When I
>delete all the record and insert a new one the
>auto_increment field is
On Wed, 27 Aug 2003 09:33:38 -0400
"Nicola Hartland" <[EMAIL PROTECTED]> wrote:
> I am reading the Book PHP and MYsql for dummies and it talks of a test you can do to
> see if PHP and SQL are talking with each other.
hmm..
> you will have to excuse my ignorance what Is a mysql_*;function as I
On Wed, 27 Aug 2003 09:38:16 -0400
Paul DuBois <[EMAIL PROTECTED]> wrote:
> At 9:05 -0300 8/27/03, bernardaum wrote:
> >Hi,
> >
> >I have a table with an auto_increment field. When I
> >delete all the record and insert a new one the
> >auto_increment field is not clean, its follows the
> >sequence
These are tables that I did not design (and would not have in this fashion), but I
have to make do with them
Table 1 structure:
id_num number,
descr1 varchar(30),
descr2 varchar(30),
descr3 varchr(30)
Table 2 structure
id_name varchar(15),
ext_descr varchar(30)
Table 2 is a child of table 1
At 9:05 -0300 8/27/03, bernardaum wrote:
Hi,
I have a table with an auto_increment field. When I
delete all the record and insert a new one the
auto_increment field is not clean, its follows the
sequence.
Can I restart this sequence? Start from 0 again?
Why bother? MySQL doesn't care if there are
>When I do the tests on frontpage, it doesn't seem to do anything.
what test are you talking about?
I am reading the Book PHP and MYsql for dummies and it talks of a test you can do to
see if PHP and SQL are talking with each other.
> On the Mysqladmin it tells me that my odbc driver 3,.51 no
On Wed, 27 Aug 2003 13:27:25 +0100
Simon <[EMAIL PROTECTED]> wrote:
> On Wednesday 27 August 2003 1:05 pm, bernardaum wrote:
> > Hi,
> >
> > I have a table with an auto_increment field. When I
> > delete all the record and insert a new one the
> > auto_increment field is not clean, its follows the
Hi!
You can currently do this with InnoDB with mysqldump (look at the
--single-transaction switch). I use it for backing up a 12 GB mail
database without problems.
Regards,
Chris
P.S. Keep up the great work over there at Novell! Tell us where to send
the expensive bottles of alcohol for when
On Wednesday 27 August 2003 1:05 pm, bernardaum wrote:
> Hi,
>
> I have a table with an auto_increment field. When I
> delete all the record and insert a new one the
> auto_increment field is not clean, its follows the
> sequence.
>
> Can I restart this sequence? Start from 0 again?
When I need to
Hi All,
The link below says that online backup functionality will be provided
in Mysql-5.1. I think its already there in the form of mysqlhotcopy. Is
Mysql going to extend the functionality of mysqlhotcopy so that it works
for Innodb tables also? or they are going to provide independent online
bac
Quick log question...
We've got our 3.23 db installed with all the data on the /home partition
which is ok. The *-bin.00x logs are also in that data directory. The
Var/log/mysql/mysql.log however on our root drive has grown to 11gig.
Our Root partion is not as large as our Home partition and I n
Hi all,
I'm upgrading a mission critical production server with Solaris 9 and mysql
4.0.13 and was wonder if I should install as 64 bit or 32 bit.
I couldn't find much recent discourse on the subject, perhaps some of you
have some experience, known pit falls, ideas or suggestions
Th
On Wed, 27 Aug 2003 09:05:17 -0300
"bernardaum" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a table with an auto_increment field. When I
> delete all the record and insert a new one the
> auto_increment field is not clean, its follows the
> sequence.
>
> Can I restart this sequence? Start fro
[EMAIL PROTECTED] wrote:
>>User can use SHOW GRANTS command:
>
> Thank you!
> But one more question: what privileges user should have to issue this command? I've
> got a user who has rights only to SELECT from certain db. What should i GRANT to him
> to allow use of SHOW GRANTS?
>
Every user c
Steve,
- Original Message -
From: ""Steve McWilliams"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, August 27, 2003 12:07 AM
Subject: Question about row level locking with InnoDB tables
> Hello,
>
> I am relatively new to MySql (4.0.14) but I have read through
Hi,
I have a table with an auto_increment field. When I
delete all the record and insert a new one the
auto_increment field is not clean, its follows the
sequence.
Can I restart this sequence? Start from 0 again?
Thanks.
Fernando Bernardino
"gord barq" <[EMAIL PROTECTED]> wrote:
>
> I'm using MySQL 4.1 so how do I define case sensitive collation? Is it on
> the columns or on the indexes?
On column. Look at the collations of your character set using SHOW COLLATION command:
http://www.mysql.com/doc/en/Charset-SHOW-COLLATION.h
"Thompson, Jordan" <[EMAIL PROTECTED]> wrote:
> I wan to use a variable for the outfile file name in a select into clause. I am
> doing something like:
>
> set @fileName="/tmp/result.text"
> SELECT col1, col2 INTO OUTFILE @fileName
> FIELDS TERMINATED BY ','
> FROM test_table;
>
> the interprete
from what I can see from the subject and this message alone, someone on
this list has been infected by the sobig.f virus, could everyone just
please check their computers... that is if you are running any windows
machine, not you that are running linux or any other os...
thanks in advance...
/
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I asked a question along these lines yesterday, but got no response. Perhaps I
can make it clearer:
I have a ucs2 table in my predominantly latin1 database. (Mysql 4.1.1 from bk)
I am using latin1 most of the time, it's the default charset, and
Thanks for writing to [EMAIL PROTECTED] This is
an auto-generated response to let you know that your
message has reached our general information box
on 8/23/2003 at 5:38:55 AM.
Customer Service will be processing and, if necessary,
responding to your inquiry shortly. We usually reply
to general inq
Hi
I have problems with mysql (4.0.6-4.0.14b) on windows 2000 SP3. MySQL
locks tables when I alter table structure or execute update queries. I
know that this is the exactly what database engine is supposed to do but
the engine doesn't release the locks at all. This happens frequently but
not
On Wednesday 27 August 2003 10:50, Hans van Harten wrote:
> Matthias Blaser wrote:
> > It's possible a server could act as master for one database with slave
> > server A and as a slave for another database which runs on master
> > server B?
>
> As in A - database1 -> S - database2- > B
Well,
Matthias Blaser wrote:
> It's possible a server could act as master for one database with slave
> server A and as a slave for another database which runs on master
> server B?
As in A - database1 -> S - database2- > B
AFAIK anything S logs will be red by B. Using 'replicate-do-db=database2' B
Hi,
I've read the replication section in the manual but i'm not quite sure about
the possibilities of the replication in mysql:
It's possible a server could act as master for one database with slave
server A and as a slave for another database which runs on master server B?
If yes: as far as
Hi,
When compiling MySQL with statically linking options (with glibc 2.3.1),
There weren't any errors during configure and compilation stages but
mysql_install_db was giving out a segmentation fault.
The list archives had suggested to give up statically linking libraries,
which worked fine.
I
>User can use SHOW GRANTS command:
Thank you!
But one more question: what privileges user should have to issue this command? I've
got a user who has rights only to SELECT from certain db. What should i GRANT to him
to allow use of SHOW GRANTS?
--
MySQL General Mailing List
For list archives: ht
On Tue, 26 Aug 2003 17:00:16 -0400
"Nicola Hartland" <[EMAIL PROTECTED]> wrote:
>When I do the tests on frontpage, it doesn't seem to do anything.
what test are you talking about?
> On the Mysqladmin it tells me that my odbc driver 3,.51 not found is that a problem
> and how do I get the driver
Wendell,
- Original Message -
From: ""Wendell Dingus"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, August 27, 2003 6:35 AM
Subject: RE: 64-Bit and INNODB
> Ahh, so Linux on 64-bit right now with INNODB is really not much different
> than on 32-bit x86? XEON C
On Tue, Aug 26, 2003 at 07:38:04PM -0600, Twibell, Cory L wrote:
> All,
>
> I have a query that is inner joined with another table based on
> country codes Select distinct Name.* from Name inner join Location
> on Location.key = Name.key and Location.cc in (' here>');
>
> The problem is when I ha
nobody have answer ?
For me it is very urgent to kwow when the .15 version will be avalaible .
Tks
- Original Message -
From: "Massimo Petrini" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "I.P." <[EMAIL PROTECTED]>
Sent: Friday, August 22, 2003 1:16 PM
Subject: Re: Replication Problem
Andi,
- Original Message -
From: "Andi Kleen" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Sent: Wednesday, August 27, 2003 1:37 AM
Subject: Re: 64-Bit and INNODB
> "Heikki Tuuri" <[EMAIL PROTECTED]> writes:
> >
> > Adding the 32-bit Intel "AWE" support into InnoDB on Linu
On Tue, 26 Aug 2003, Heikki Tuuri wrote:
> Asif,
>
> now take the old log files from the safe place and put them back! That will
> save your data.
>
> The instructions about changing the size of the log files are the following:
>
> http://www.innodb.com/ibman.html#Adding_and_removing
>
> "
> If yo
Ahh, so Linux on 64-bit right now with INNODB is really not much different
than on 32-bit x86? XEON CPUs have AWE/PAE which lets them address a 36-bit
memory address space, getting past the 4GB addressable limit. 64-bit CPUs
obviously can address _much_ more memory in a single chunk. MySQL/INNODB
t
Indexing columns will help but you *may* need to take a peek at some other
factors such as Memory Management
Read Jeremy's article on MySQL Performance Tuning
http://www.linux-mag.com/2001-12/mysql_01.html
Hth,
Martin
- Original Message -
From: "Roger Baklund" <[EMAIL PROTECTED]>
To: <[EM
>Description:
I've recently compiled mysql 4.0.14 on redhat 8.0.
The installation fails, however, when running mysql_install_db.
I've attached a transcript below.
I gather from searching the 'net that this isn't an entirely
unusual thing to happen, and is likely the result of some
misconfiguratio
Hi Jesse,
- Original Message -
From: "Jesse Sheidlower"
Sent: Monday, August 25, 2003 8:26 AM
Subject: Explanation of multiple-column indexes
> After some discussion in a separate thread, I've been trying
> to get a better understanding of the workings of multiple-column
> indexes, and th
* Twibell, Cory L
> I have a query that is inner joined with another table based on
> country codes
> Select distinct Name.* from Name inner join Location on Location.key =
> Name.key and Location.cc in ('');
>
> The problem is when I have more than 2 country codes, the query
> takes forever..
All,
I have a query that is inner joined with another table based on country codes
Select distinct Name.* from Name inner join Location on Location.key =
Name.key and Location.cc in ('');
The problem is when I have more than 2 country codes, the query takes forever...
When I show processlist, it
Hello, mysql,
Yesterday,mysql process disappear sliently.
After I check the err-log,no clues found.
But the PID file still exising.I think the mysql terminate by some reason.But
I still not found why.
The error-log mysqld.log wouldn't provide any valueable msg.It j
73 matches
Mail list logo
