I have a query that I need to tune.
Basically, substr a text, and select first and last entry.
The table is currently a few million rows big. Index is on FromHost (text
field) and ReceivedAt (index field)
Is the best way to optimize my query.
1) create an index on substr() and the two date columns
Dear all,
I am running mysql server sharing with apache web server in a box of freebsd
6.4. Hardware spec is roughly as bellow:
CPU: Xeon 3.06GHz x 2
Mem: 4GB
The version of Mysql is 5.1.17_beta, a pre-complied binary package for FreeBSD.
Recently the apache request raises quickly, sometime
Hi all,
You can read this article, written by a SUN benchmarking guru (hi
Dimitri :) ).
Best regards.
Web link : http://dimitrik.free.fr/db_STRESS_BMK_Part2_ZFS.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi,
I installed Mysql 5.0.45 on Solaris 10 01/08 configured to run
the datadir on a ZFS filesystem on a Raid1 pool.
Both myisam and innodb tables are on the same filesystem.
Innodb is configured to run with a buffer_pool_size=256M,
with doublewrite set to OFF and with file_per_table to Off.
The
On Wed, Apr 9, 2008 at 5:51 AM, Nico Sabbi [EMAIL PROTECTED] wrote:
The problem I have is that importing the same 7 MB sql dump
takes 9 seconds if engine=Myisam and 98 when engine is Innodb.
Is autocommit turned off?
http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html
When importing
Il Wednesday 09 April 2008 19:40:32 Rob Wultsch ha scritto:
On Wed, Apr 9, 2008 at 5:51 AM, Nico Sabbi [EMAIL PROTECTED] wrote:
The problem I have is that importing the same 7 MB sql dump
takes 9 seconds if engine=Myisam and 98 when engine is Innodb.
Is autocommit turned off?
Hi All,
I have a pentium box 3.0 GHz processor and 2 GB ram. I want to configure
my.cnf in such a way that it should give the best performance. So, how
should I configure the my.cnf parameter. What are the components on which
the most attention should be paid. I am using innodb parameters.
hi,
we are working on automotive traking solutions and insert our location records
into the mysql database v 4.1.20. If we want search for a particular record,
its taking too long time and mysql is identifying the queries as slow queries.
I have attached the queries.
How to optimize the
times, that's just going to annoy everyone.
Break the query down and find out which part is slow. Each union part
should work by itself, so take each one and tune that. Then worry
about the whole lot.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
: Tuesday, August 01, 2006 5:28 PM
Subject: tune a geometric query
hi,
we are working on automotive traking solutions and insert our location
records into the mysql database v 4.1.20. If we want search for a
particular record, its taking too long time and mysql is identifying the
queries
On Tue, 2006-08-01 at 17:39 +0530, ViSolve DB Team wrote:
Hello Prashant,
If you do need the duplicate rows in the final result, use UNION ALL with
your query. Otherwise you can opt for UNION as UNION is faster than UNION
ALL.
I have never heard of any evidence of this; in fact, it makes
PROTECTED]
Sent: Friday, June 16, 2006 6:22 AM
Subject: Re: *SPAM* Re: Aborted clients status variable seems
increasing -how to tune the server to reduce the same
Thanks Brent.
I increased my wait_timeout.But now also my aborted clients seems increasing than connections.As u said most of my
variable seems increasing -how to tune
the server to reduce the same
Hi,
The aborted clients seems to be increasing than the connections made.
Any solution
Aborted_clients 67529 where as the connection made is 60462 .
Here is my server details,
Server
Hi,
The aborted clients seems to be increasing than the connections made.
Any solution
Aborted_clients 67529 where as the connection made is 60462 .
Here is my server details,
Server : Red Hat Enterprise Linux AS
release 4 (Nahant)
Mysql Server
PROTECTED]
To: mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Sent: Thursday, June 15, 2006 3:42 AM
Subject: Aborted clients status variable seems increasing -how to tune the
server to reduce the same
Hi,
The aborted clients seems to be increasing than the connections made. Any
solution
On 6/15/06, Lakshmi [EMAIL PROTECTED] wrote:
Hi,
The aborted clients seems to be increasing than the connections made.
Any solution
Aborted_clients 67529 where as the connection made is 60462 .
A client is aborted after wait_timeout seconds of inactivity, but as
your app seem to be working
Hello.
SHOW STATUS usually helps others to give you a good advice. I think
you should send the output of this statement to the list. Why have you
changed the type of engine? Did it gave you a great performance hit?
Thomas Lekai [EMAIL PROTECTED] wrote:
We finally split our huge
We finally split our huge logging aspect of an application to its own system,
and we changed the table type from InnoDB to MyIsam. This is a logging table,
1 log writer, many, many selects from customer care reps looking up the last
500 or so records. These are logs of timed events, so they
Hello,
Is there any RH 9 kernel tuning tips for system running Mysql 4.0 db? Thanks
Rob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi -
Before I start fiddling with buffer sizes and what not, is there any
documented issue with truncated results of concat_ws() within joined
tables, when using an order by clause?
Using MySQL 3.23.48 on Linux. Will post SQL queries and table structure if
there's not just an answer somewhere
20 matches
Mail list logo