How do i split file during ENABLE KEYS
On 6/13/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> increase bulk_insert_buffer_size and if possible split the bigger file into
> small chunks. It will help you.
>
> On Thu, Jun 12, 2008 at 1:51 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>
>
increase bulk_insert_buffer_size and if possible split the bigger file into
small chunks. It will help you.
On Thu, Jun 12, 2008 at 1:51 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> Hi All,
> We are doing load data into a table using LOAD DATA INFILE process. Below
> is
> the method we are follo
Hi, I am attempting to do a "natural sort" from within mysql, if possible.
So, for example, jane2 would come before jane10, and normal strings would
still sort as expected. I found some solutions, like using length for the
numerical part, but that only works if the strings are the same length.
Ide
does it work outside the function?
Yes, If I run:
select CONCAT(UPPER(SUBSTRING('JESSE',1,1)),LOWER(SUBSTRING('JESSE',2)));
replacing cInput with 'JESSE', it returns "Jesse" as it should.
did you tried SUBSTRING(cInput, 2)?
Tried replacing SUBSTRING(cInput FROM 2) with SUBSTRING(cInput, 2)
I usually use the --tabs option on mysqldump. However, if a table has a
function, procedure, or trigger, the code is not written to a file but
rather to standard out. Is this the only way to dump them using the --tabs
option? I thought of trying to use the Information Schema database somehow
but
mos wrote:
Why not switch to Sphinx full text search for MySQL? It is faster and
can handle more data than MySQL's built in fulltext search.
http://www.sphinxsearch.com/
Mike
I have read about sphinx and the good performance boost it provides -
unfortunately there is a lot of legacy code
At 02:20 PM 6/12/2008, you wrote:
Hi List
I have a table with a fulltext index across five fields, with about 2.2
million records and a data size of about 5.6 GB (index another 3.5 GB).
When I test a query that uses fulltext matching, the first run takes about
15-16 seconds to complete. The s
>From: Rory McKinley [mailto:[EMAIL PROTECTED]
>Sent: Thursday, June 12, 2008 4:57 PM
>To: Jerry Schwartz; mysql
>Subject: Re: Fulltext index -first query slow, subsequent queries fast
>
>Jerry Schwartz wrote:
>> File system, or disk caching, uses some kind of algorithm to hold
>chunks of
>> files
Jerry Schwartz wrote:
File system, or disk caching, uses some kind of algorithm to hold chunks of
files in system RAM. That way a program can get to it more quickly than if
it had to go out to the disk. The algorithms vary, depending upon the smarts
of the program and the smarts of the file syste
>-Original Message-
>From: Rory McKinley [mailto:[EMAIL PROTECTED]
>Sent: Thursday, June 12, 2008 3:20 PM
>To: mysql
>Subject: Fulltext index -first query slow, subsequent queries fast
>
>Hi List
>
>I have a table with a fulltext index across five fields, with about 2.2
>million records and
We are currently looking for a contractor for 30 days in Kansas City that
has experience doing MySQL DBA/Windows Server Administration work. This
will be a production support role as the consultant will be covering for
someone that will be out on vacation. The consultant needs to be available
24/
Hi List
I have a table with a fulltext index across five fields, with about 2.2
million records and a data size of about 5.6 GB (index another 3.5 GB).
When I test a query that uses fulltext matching, the first run takes
about 15-16 seconds to complete. The second run takes about 0.1 sec and
no there is no index building or alter doing on.
On 6/13/08, mos <[EMAIL PROTECTED]> wrote:
>
> At 11:38 AM 6/12/2008, you wrote:
>
>> Hi Sebastian,
>>
>> I tried to order the column as close as possible to the table structure
>> and
>> removed all the formatn command and if conditions, but still
On Thursday 12 June 2008, David Giragosian wrote:
> The same is true of mysql_real_escape_string() in PHP. You escape
> special characters upon update or insertion, but upon viewing the data
> in the DB or retrieving it programmatically, the data simply appear as
> it was originally before use of
At 11:38 AM 6/12/2008, you wrote:
Hi Sebastian,
I tried to order the column as close as possible to the table structure and
removed all the formatn command and if conditions, but still it take 3 min
Are you sure when you are running the fulltext search, the table isn't
locked because you are
Any difference in default collation?
Not sure what that is. I'm using a visual tool (EMS) to create my function,
and it doesn't offer that option. I could update it using the command
prompt, however. I may try that later.
--
MySQL General Mailing List
For list archives: http://lists.mys
I am curious about that, as well. It brings to mind a discussion that
happened on this list last week (I believe) about case
sensitive/insensitive use of LIKE. I believe the synopsis was that
tables are either created as case-insensitive, or the search needs to be
specified as case sensitive (with
On 6/12/08, Tim Johnson <[EMAIL PROTECTED]> wrote:
> On Thursday 12 June 2008, Warren Young wrote:
> > Tim Johnson wrote:
> > > Not sure what you mean by "directly usable".
> >
> > I mean "directly usable". :)
> >
> > > If I do an insert statement with a backslash, for example:
> > > "headlin
Hi,
I want to change an existing table to StorageType "federated"
according to http://dev.mysql.com/doc/refman/5.1/en/federated-create.html
I've just created this sample table, now I can't even have a look at
the scheme with mySQL Administrator, only the "mySQL Query Browser"
works and shows me th
On Thursday 12 June 2008, Warren Young wrote:
> Tim Johnson wrote:
> > Not sure what you mean by "directly usable".
>
> I mean "directly usable". :)
>
> > If I do an insert statement with a backslash, for example:
> > "headline\one", I will retrieve "headline\\one", and that will
> > need t
Tim Johnson wrote:
Not sure what you mean by "directly usable".
I mean "directly usable". :)
If I do an insert statement with a backslash, for example:
"headline\one", I will retrieve "headline\\one", and that will
need to be unescaped, because it is not a true representation
of wha
For whatever it's worth, some years ago I wrote a database that kept track
of IPs. I found it very easy if I treated the IPs as numbers.
Each IP is a quartet of digits, each in the range 0-255. This really means
an IP is a 4-digit number in base 256 and you can use use standard
conversion functi
Hi Sebastian,
I tried to order the column as close as possible to the table structure and
removed all the formatn command and if conditions, but still it take 3 min
select
ITEM_ID,ITEM_TITL,AUCT_START_DATE,AUCT_END_DATE,AUCT_DURTN_DAYS,AUCT_TYPE_CODE,LEAF_CATEG_ID,SLR_ID,START_PRICE_USD,RSRV_PR
yes, this is the default folder its configured.
On 6/12/08, Boyd, Todd M. <[EMAIL PROTECTED]> wrote:
>
> From: Ananda Kumar [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 12, 2008 10:27 AM
> To: Boyd, Todd M.
> Cc: mysql
> Subject: Re: enable and disable keys
>
> /tmp has 16GB free space
> On
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 10:27 AM
To: Boyd, Todd M.
Cc: mysql
Subject: Re: enable and disable keys
/tmp has 16GB free space
On 6/12/08, Boyd, Todd M. <[EMAIL PROTECTED]> wrote:
> -Original Message-
> From: Ananda Kumar [mailto:[EMAIL PROT
On Thursday 12 June 2008, Warren Young wrote:
> Tim Johnson wrote:
> > I can not locate a C api function to _unescape_ strings.
>
> Why do you believe you need one?
>
> You need to escape strings when building SQL query strings to avoid
> problems with quote characters, which are special in SQL. W
thanks!
I can't do a physical copy as it's an upgrade from 32-bit 3.23 (don't ask -
ancient shrink-wrap app) to 64-bit 4.0 (again, don't ask - least bad option
for reasons you don't want to know).
I'll may try the csv/load data though I've never understood what that should
be faster than extended
On 6/12/08, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>
>
>
> On 6/12/08, Sebastian Mendel <[EMAIL PROTECTED]> wrote:
>>
>> Ananda Kumar schrieb:
>>
>>> Hi All,
>>> We have table with 99 Million records, with fulltext index.
>>> But when there is not load the sql's performance in just 6 sec, but when
Tim Johnson wrote:
I can not locate a C api function to _unescape_ strings.
Why do you believe you need one?
You need to escape strings when building SQL query strings to avoid
problems with quote characters, which are special in SQL. When MySQL
returns the queried data to your program, i
On 6/12/08, Sebastian Mendel <[EMAIL PROTECTED]> wrote:
>
> Ananda Kumar schrieb:
>
>> Hi All,
>> We have table with 99 Million records, with fulltext index.
>> But when there is not load the sql's performance in just 6 sec, but when
>> anyother jobs like Index creation or data load is happening it
Using MySQL 5.0.45 on linux.
For the first time I am using the C API directly. I am using
mysql_real_escape_string() - see
http://dev.mysql.com/doc/refman/5.1/en/mysql-real-escape-string.html
I can not locate a C api function to _unescape_ strings. If there were one,
I would use it. If I have over
Sid,
Do you still have them as myisam files (myd,myi)?
If yes and your other server has the same mysql version and cpu architecture
you can just copy the myisam binary files to the new server.
If you have the dump only you can either load with the mysql client or parse
it, create a csv filw with
/tmp has 16GB free space
On 6/12/08, Boyd, Todd M. <[EMAIL PROTECTED]> wrote:
>
> > -Original Message-
> > From: Ananda Kumar [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, June 12, 2008 9:41 AM
> > To: [EMAIL PROTECTED]
> > Cc: mysql
> > Subject: Re: enable and disable keys
> >
> > We have
hey,
as the sub says I have a dump of a 50GB (MYD/60GB MYI) table I need to load
on another server.
I guess the bigger question is how can I optimize this, particularly the
index builds? I had always thought is was best in these cases to create the
table w/o any indexes, load the rows then creat
> -Original Message-
> From: Ananda Kumar [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 12, 2008 9:41 AM
> To: [EMAIL PROTECTED]
> Cc: mysql
> Subject: Re: enable and disable keys
>
> We have 200GB of free space on the file system where our database is
> located.
>
---8<--- snip
If t
> -Original Message-
> From: Martijn Tonies [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 12, 2008 6:23 AM
> To: MySQL List
> Subject: Re: Function Still Not Working
>
> Hey,
>
> > Sorry for posting this again, but I got only one response last time,
> and
> I'm
> > still having the pro
Ananda Kumar schrieb:
Hi All,
We have table with 99 Million records, with fulltext index.
But when there is not load the sql's performance in just 6 sec, but when
anyother jobs like Index creation or data load is happening its take close
to 3 min for the same query to execute, any ways to improve
Hi All,
We have table with 99 Million records, with fulltext index.
But when there is not load the sql's performance in just 6 sec, but when
anyother jobs like Index creation or data load is happening its take close
to 3 min for the same query to execute, any ways to improve the performance
of this
Ananda Kumar wrote:
We have 200GB of free space on the file system where our database is
located.
On 6/12/08, Ken Menzel <[EMAIL PROTECTED]> wrote:
Ananda Kumar wrote:
Hi All,
We are doing load data into a table using LOAD DATA INFILE process. Below
is
the method we are following.
1. create
We have 200GB of free space on the file system where our database is
located.
On 6/12/08, Ken Menzel <[EMAIL PROTECTED]> wrote:
>
> Ananda Kumar wrote:
>
>> Hi All,
>> We are doing load data into a table using LOAD DATA INFILE process. Below
>> is
>> the method we are following.
>>
>> 1. create em
Ananda Kumar wrote:
Hi All,
We are doing load data into a table using LOAD DATA INFILE process. Below is
the method we are following.
1. create empty table with all the indexes.
2. disable keys
3. Load data using LOAD DATA INFILE, close to 99 Million records which takes
around 3 hrs
4 . Enable k
Hi,
I need to be able to store data from our Radius servers that includes IP
addressing and IP blocks into a MySQL field that is easily searchable.
Basic IP addreses I have sorted with INET_ATON(), but is there a way to
store blocks of IP's as in "192.168.1.0/24" in a way that would allow it
Jesse schrieb:
Sorry for posting this again, but I got only one response last time, and
I'm still having the problem. I spent HOURS the other day manually
going through the data and Properizing these things by hand. I don't
want to do that again if I can avoid it. If anyone has any clues on
Hey,
> Sorry for posting this again, but I got only one response last time, and
I'm
> still having the problem. I spent HOURS the other day manually going
> through the data and Properizing these things by hand. I don't want to do
> that again if I can avoid it. If anyone has any clues on this o
Sorry for posting this again, but I got only one response last time, and I'm
still having the problem. I spent HOURS the other day manually going
through the data and Properizing these things by hand. I don't want to do
that again if I can avoid it. If anyone has any clues on this one, I would
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
http://www.w3.org/1999/xhtml";>
newsletter arpsworldproperties
Our contacts:
tel: + 44 (0)208 200 60 20 | fax: +
44 (0)208 200 10 49 | m: + 44 (0)7938 056 756
email: mailto:[EMAIL PROTECTED]" class
Hi,
I have a problem with the migration of a table that has a column with BLOB data.
The source server is MySQL version: 4.0.16 and the destination server is MySQL
version: 5.0.45
I tried with mysqldump and SELECT INTO but when import the data on the destination server, the
BLOB data are
Hi All,
We are doing load data into a table using LOAD DATA INFILE process. Below is
the method we are following.
1. create empty table with all the indexes.
2. disable keys
3. Load data using LOAD DATA INFILE, close to 99 Million records which takes
around 3 hrs
4 . Enable keys
Table size is aro
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
http://www.w3.org/1999/xhtml";>
newsletter arpsworldproperties
Our contacts:
tel: + 44 (0)208 200 60 20 | fax: +
44 (0)208 200 10 49 | m: + 44 (0)7938 056 756
email: mailto:[EMAIL PROTECTED]" class
49 matches
Mail list logo
