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:
Hi All,
All,
I will be recording timezone information based on user input using the
time zone names from mysql.time_zone_name - names
like 'America/Los_Angeles'.
When recording this information, do I store the full name or just
the 'time_zone_id' which is present in mysql.time_zone_name ?
thanks
Per
Hi list,
Have a bit of a mystery here that I hope somebody can help with.
I've just got a new server that I'm using as a dedicated MySQL server.
In terms of hardware it's pretty much identical, if not slightly
superior to an existing server already in production use.
It's having a real struggle
Please check if the my.cnf configurations to be the same.
What are your configuration parameters in terms of innodh flush log trx
commit , bin logging, sync binlog and innodb unsafe for binlog ?
If the systems have raid, check if the BBWC is enabled on the new host and
WB is enabled.
On Fri,
Hi Alex,
Configurations are identical, other than the differences I initially
mentioned. I've diffed both the configuration files and the output of
SHOW VARIABLES on both servers.
I've contacted my hosting provider to ask about the RAID settings.
Variable_name: innodb_flush_log_at_trx_commit
check for iostat to see if the disk is heavly used.
On 6/13/08, Ian Simpson [EMAIL PROTECTED] wrote:
Hi Alex,
Configurations are identical, other than the differences I initially
mentioned. I've diffed both the configuration files and the output of
SHOW VARIABLES on both servers.
I've
also how often do you issue a commit. batching the inserts inside a
transaction might help.
On Fri, Jun 13, 2008 at 6:53 PM, Ananda Kumar [EMAIL PROTECTED] wrote:
check for iostat to see if the disk is heavly used.
On 6/13/08, Ian Simpson [EMAIL PROTECTED] wrote:
Hi Alex,
Configurations
Hi guys, thanks for pitching in.
The inserts are from replication; we're not using transactions on the
master (yet), and I don't think there's a way of telling MySQL to batch
incoming replication statements if they're not already in a transaction.
Disk usage: the older server (the one that's
replication based inserts are serial whereas most of the time the inserts on
masters are concurrent. this leads to the slaves falling behind. to tackle
this we have used the following strategies :
1. Use raid 0 on the slaves (master users raid 10) so as to speed up writes.
2. pre fetch and cache
Disk usage: the older server (the one that's running fine) is running
more transactions per second, but has lower blocks written and read per
second than the new server:
[JS] That, to me, suggests that the difference might be in the way the systems
themselves are configured. Unfortunately, I
Hi Guys,
Having delved a little more into the capabilities of iostat, I've
discovered that the drive bandwidth seems to be maxed out while MySQL is
running, which I'd peg as the primary candidate for the problem.
Looks like I'll be having more words with my hosting company about
this...
Thanks
Having delved a little more into the capabilities of iostat, I've
discovered that the drive bandwidth seems to be maxed out while MySQL is
running, which I'd peg as the primary candidate for the problem.
[JS] That suggests even more strongly that there is a difference in the kernel
configuration.
-Original Message-
From: Jesse [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 1:40 PM
To: Martijn Tonies; MySQL List
Subject: Re: Function Still Not Working
Any difference in default collation?
Not sure what that is. I'm using a visual tool (EMS) to create my
Hi Jerry,
It could be a kernel issue; however, currently I'm suspecting that the
drive in the new server simply doesn't have the same bandwidth
capability. The iostat results I'm getting (although I'm not an expert
in reading them, having only learned of it about 3 hours ago) suggest
that the
-Original Message-
From: Emily Heureux [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 8:25 PM
To: mysql@lists.mysql.com
Subject: natural sort via substrings
Hi, I am attempting to do a natural sort from within mysql, if
possible.
So, for example, jane2 would come before
-Original Message-
From: Per Jessen [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 5:17 AM
To: mysql@lists.mysql.com
Subject: what is the proper way to store timezone information?
All,
I will be recording timezone information based on user input using the
time zone names
-Original Message-
From: Boyd, Todd M. [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 10:33 AM
To: Emily Heureux; mysql@lists.mysql.com
Subject: RE: natural sort via substrings
---8--- snip
Forgive me if I am incorrect, but wouldn't jane2 already be listed
before jane10 if
Hi
Is sphinxsearch avialable only on for windows
regards
anandkl
On 6/13/08, Rory McKinley [EMAIL PROTECTED] wrote:
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.
On Fri, June 13, 2008 08:26, Ian Simpson wrote:
Hi Jerry,
It could be a kernel issue; however, currently I'm suspecting that the
drive in the new server simply doesn't have the same bandwidth
capability. The iostat results I'm getting (although I'm not an expert
in reading them, having only
-Original Message-
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 10:48 AM
To: [EMAIL PROTECTED]
Cc: mos; mysql@lists.mysql.com
Subject: Re: Fulltext index -first query slow, subsequent queries fast
Hi
Is sphinxsearch avialable only on for windows
I'm looking for a query that reports the count of each table in the
database.
the query should not assume the table list of the database.
Thanks for any inputs
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
-Original Message-
From: Elim Qiu [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 10:56 AM
To: mysql@lists.mysql.com
Subject: query counts of a database
I'm looking for a query that reports the count of each table in the
database.
the query should not assume the table list
That's pretty much what I've been doing to get that the drive is running
at 100% bandwidth.
What I'd like is something that just gives the bandwidth of the device
in terms of Mb/s: you can probably work it out using that iostat
command, seeing how much it wrote and what percentage of the
Hi, I am sorry for being so vague. The values are not as simple as jane20,
jane10, or jane2. There are names like, jane-2, alex 3, alex4, and just
'jane', etc. ORDER BY sorts by either numerical OR string, not both, as far
as I can tell. I'll have to think about zero-fill, but I doubt that
If you are using MySQL 5.0 or later, use the INFORMATION_SCHEMA database.
It has an in-memory table of table names called (as you would expect) 'tables'.
SELECT table_rows,table_name FROM information_schema.tables
WHERE table_schema = 'whatever database you choose';
If you are using a current
-Original Message-
From: Emily Heureux [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 11:12 AM
To: Boyd, Todd M.; mysql@lists.mysql.com
Subject: RE: natural sort via substrings
Hi, I am sorry for being so vague. The values are not as simple as
jane20,
jane10, or jane2.
Sorry, my email didn't make the intention clear.
I want the number of records per table in a database like:
querytime | -xx-xx-xx:xx:xx
tNm1 | yyy
tNm2 | zzz
..
where tNm1, tNm2 are table names in the database.
- Original Message -
From: Boyd, Todd M. [EMAIL
-Original Message-
From: Emily Heureux [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 8:25 PM
To: mysql@lists.mysql.com
Subject: natural sort via substrings
Hi, I am attempting to do a natural sort from within mysql, if
possible. So, for example, jane2 would come before
From: Jim Lyons [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 12:10 PM
To: Boyd, Todd M.
Subject: Re: natural sort via substrings
What I would do is form 2 additional fields from the first, an alphanumeric
field and a numeric field so:
jane-2 jane- 2
alex 3 alex 3
Ok, thanks for all the information. I have tried solving the problem via
perl, but I am using DBIx::Class and Catalyst, which are both relatively new
to me. The way DBIC deals with grabbing data from the database combined
with my limited skills had me looking for a mysql solution.
You're saving
Thanks a lot Edwards!
I'm using MySQL 5.1. Your query works great!
- Original Message -
From: Rolando Edwards [EMAIL PROTECTED]
To: Elim Qiu [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Friday, June 13, 2008 10:32 AM
Subject: RE: query counts of a database
If you are using MySQL 5.0
Good.
On Fri, Jun 13, 2008 at 3:23 AM, Lori Kurovski [EMAIL PROTECTED] wrote:
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
32 matches
Mail list logo