!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd;
html xmlns=http://www.w3.org/1999/xhtml;
head
meta http-equiv=Content-Type content=text/html; charset=utf-8 /
titlenewsletter arpsworldproperties/title
link href=news.css
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
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
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd;
html xmlns=http://www.w3.org/1999/xhtml;
head
meta http-equiv=Content-Type content=text/html; charset=utf-8 /
titlenewsletter arpsworldproperties/title
link href=news.css
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
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 one,
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
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
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
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 empty table with
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
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
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
-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 problem. I
-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 the system
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
/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 200GB of free
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
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
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 its take close
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,
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
anyother jobs like
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
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. When
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
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 6/12/08,
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
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
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 what was
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 to be unescaped,
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 the
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:
headline\one, I will retrieve
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
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:
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
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
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 it take 3 min
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
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
-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 a data
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
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 in system
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
mos wrote:
snip
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
snip
I have read about sphinx and the good performance boost it provides -
unfortunately there is a lot of
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
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)
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.
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 following.
48 matches
Mail list logo
