Did you deleted the data dir (inside Program Files) after uninstall ?? i
think that is was not empty and when the new install tries to set up
finds it and get messy (maybe because the 32 and 64 bit issue).
Carlos
On 7/13/2009 11:07 PM, Edward Diener wrote:
I had previously installed the 64-b
On 7/13/2009 9:19 PM, Daevid Vincent wrote:
Both systems are UTC time so I don't get the issue with the sequence number
is in the future business either.
If I ever do get mysqld to start using the "innodb_force_recovery = 4" line,
then as you know, I can't alter/update/insert. And it seems any a
I had previously installed the 64-bit version of MySQL 5.1 server under
Windows Vista x64 and both the installation and configuration were
successful. Then for compatibility reasons with something on which I am
working I realized I needed to install the 32-bit version of MySQL 5.0
server. Since
> InnoDB: Your database may be corrupt or you may have copied the InnoDB
> InnoDB: tablespace but not the InnoDB log files. See
> InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
> InnoDB: for more information.
> InnoDB: Error: trying to access page number 2144600306 in space 0,
I have a 70GB database that I need to put on another box I'm building
(Ubuntu 9.04 w/ext4, 1TB drive). I copy these files from the existing
database (stopped it first of course) via USB HD. Doing a mysql dump/restore
isn't really realistic as it gets exponentially slower and can take from 3-5
days
It is a little bit of paranoia which is not unhealthy. You might be
running those scripts on a dev server or a shared host where the
default warnings setting is not the default nor is it necessarily
under your control. You are right, warnings *should* be enabled by
default, but when you want to b
yes,it is more faster that i select every cols except the TEXT col,but
unfortunately i need the TEXT cols for next step.
2009/7/14 Johnny Withers
> It looks like MySQL is using both columns in the key for that query, since
> the key_len is 8, but for some reason it says it is still "using where"
Hello,
I am returning to mysql after long break, so not experienced with
details. I inherited a text file with the mysql DDL statements which
create database and tables, etc. Each 'create' or 'drop' table statement
is preceded with a 'show warnings' statement. Since this file is used to
initialize
Did you even look here:
http://dev.mysql.com/downloads/gui-tools/5.0.html
> -Original Message-
> From: Carlos Williams [mailto:carlosw...@gmail.com]
> Sent: Monday, July 13, 2009 12:43 PM
> To: Ray
> Cc: mysql@lists.mysql.com
> Subject: Re: MySQL GUI Tools
>
> Yup. That was what I was l
mo...@fastmail.fm (mos) writes:
> At 08:06 PM 7/12/2009, Morten wrote:
>
> If you can get rid of the DateTime and switch to just Date it may
> speed up the indexes.
While not as pretty it's more compact to convert timestamp values into
an bigint. For example: seconds since epoch. If you know th
Yup. That was what I was looking for. Thanks!
On Mon, Jul 13, 2009 at 3:27 PM, Ray wrote:
> On July 13, 2009 12:03:49 pm Carlos Williams wrote:
>> If I am looking for a application that will connect to MySQL and allow
>> me to make database / table / user / permission modifications via a
>> graphi
On July 13, 2009 12:03:49 pm Carlos Williams wrote:
> If I am looking for a application that will connect to MySQL and allow
> me to make database / table / user / permission modifications via a
> graphical tool, is there something specific out there you guys
> recommend? I have been doing everythi
If I am looking for a application that will connect to MySQL and allow
me to make database / table / user / permission modifications via a
graphical tool, is there something specific out there you guys
recommend? I have been doing everything via CLI only and would like to
try a GUI option if availa
It looks like MySQL is using both columns in the key for that query, since
the key_len is 8, but for some reason it says it is still "using where".
What happens when you only select these fields: seq_id, ref_id,
start_position, end_position?
Does the query speed up? I had a table that had some TE
>-Original Message-
>From: Michael Abbott [mailto:damy...@hotmail.com]
>Sent: Saturday, July 11, 2009 11:10 AM
>To: mysql@lists.mysql.com
>Subject: What to Download
>
>
>Hi Folks, can someone give me some info on what I need to download
>here?? I just bought a new 64 bit laptop
>
>-Original Message-
>From: russbucket [mailto:russbuc...@nwi.net]
>Sent: Friday, July 10, 2009 12:09 PM
>To: mysql@lists.mysql.com
>Subject: MySQL Windows version
>
>I have been using the Linux version of MySQL for five years, also used
>it on
>a Windows ME system even though documents said
sorry for my careless,the sql should be select * from REF_SEQ where REF_ID =
3 and START_POSITION between 3 and 803;
the explain output is :
mysql> explain select * from REF_SEQ where REF_ID = 3 and START_POSITION
between 3 and 803;
++-+-+---+
I've been reading High Performance MySQL today and got some great
tips
from that which will help a lot.
Yes it is a good book. I hope you have the 2nd edition.
I do, I should have read this years ago (well.. the 1st edition then
at least). So many caveats to using indexes.
So why not h
Hi Dan,
The problem with BLOB is that traditionally MySQL, along with a lot of other
databases, is not designed to handle them very well. The BLOB data is passed
between the client and server as if it where the same as any other data.
This results in large memory use by both the client and server
I see that index_ref_start is defined on Ref_Id and Start_Position. Mysql
only uses the left-most column of this index. Drop and re-add this key only
defined as
INDEX idx_ref_start(start_position)
and see if that helps.
Your explain you sent this time is not even using the index.
In your previo
At 07:08 AM 7/13/2009, you wrote:
Hello,
I'm developing a web application that requires to store large files in a
MySQL database. The files can range up to 2Gb.
In my understanding the upper limit for the SQL queries (thus insert
queries) is 1GB. I'm trying, for the time being, to upload files o
the REF_SEQ is defined below, the col DNA_SEQ is a string such as
"ATGCGGTTA",
| REF_SEQ | CREATE TABLE `REF_SEQ` (
`SEQ_ID` int(11) NOT NULL auto_increment,
`REF_ID` int(11) NOT NULL,
`START_POSITION` int(11) NOT NULL,
`END_POSITION` int(11) NOT NULL,
`DNA_SEQ` text,
`DNA_QUALITY` tex
Can you show the CREATE TABLE for your REF_SEQ table?
The explain output says "using where" which means that MySQL will have to
post-filter rows after the storage engine retrieves them. It also means the
query may benefit from different/better indexing.
On Mon, Jul 13, 2009 at 12:04 AM, TianJing
Redesign. Do NOT store files in a database. The kind of database that's good
a storing files, is more commonly known as "filesystem".
On Mon, Jul 13, 2009 at 2:08 PM, Daniele Development-ML <
daniele@googlemail.com> wrote:
> Hello,
> I'm developing a web application that requires to store la
Hello,
I'm developing a web application that requires to store large files in a
MySQL database. The files can range up to 2Gb.
In my understanding the upper limit for the SQL queries (thus insert
queries) is 1GB. I'm trying, for the time being, to upload files of sizes
around 65MB, but I still get
25 matches
Mail list logo
