Good advice, all of it. What hasn't been said and should be noted: in
most cases, the bottleneck is the queries themselves. You will
generally get a lot more boost from tuning those than from any
configuration tweaking (excepting the pathological cases).
- michael dykman
On Thu, Feb 9, 2012 a
Grant wrote:
> I'm running mysql on Gentoo with 4GB RAM and I'm wondering if I should
> change any settings. I'm using mysql with a website on the same
> server so I have skip-networking, and I increased key_buffer and
> innodb_buffer_pool_size from 16M to 256M. Everything else is default.
> Sho
On 7 Feb 2012, at 00:55, Grant wrote:
> I'm running mysql on Gentoo with 4GB RAM and I'm wondering if I should
> change any settings. I'm using mysql with a website on the same
> server so I have skip-networking, and I increased key_buffer and
> innodb_buffer_pool_size from 16M to 256M. Everythi
Am 07.02.2012 00:55, schrieb Grant:
> I'm running mysql on Gentoo with 4GB RAM and I'm wondering if I should
> change any settings. I'm using mysql with a website on the same
> server so I have skip-networking, and I increased key_buffer and
> innodb_buffer_pool_size from 16M to 256M. Everythin
astmail.fm]
Envoyé : mardi 8 septembre 2009 17:21
À : mysql@lists.mysql.com
Objet : Re: Tuning mysql concurrent running threads
If you are talking about MyISAM tables, in my.cnf you can set the
thread_concurrency=x
where x=2*# of CPU's
but this unfortunately only works on Solaris and not on Lin
If you are talking about MyISAM tables, in my.cnf you can set the
thread_concurrency=x
where x=2*# of CPU's
but this unfortunately only works on Solaris and not on Linux. It may work
on Windows, I'm not sure.
InnoDb has their own innodb_thread_concurrency variable that you can see
the value
Jürgen Ladstätter wrote:
hi all,
i developed a programm which needs my external mysql database server. now i
have to transfer a lot of data and i have todo a lot of select queues. how
can i tune that, so that it would be faster? in my monitoring system i saw,
that CPU load is 0, the only thi
If you can, I recommend installing "mytop"
(http://jeremy.zawodny.com/mysql/mytop/) - it has helped me immensely to
identify which particular queries are putting the heaviest load on the
server.
>>I have a lot of two column tables consisting
>>of integer primary key and varchar in the second c
Here are two ways to find the queries:
1) 'SHOW FULL PROCESSLIST\G' in the mysql client and taking note of what
queries seem to be taking the most time
2) enable update logging and slow query logging
When you have gathered a list of queries that you want to look into
optimizing, run [in the clie
> -Original Message-
> From: Eric Gunnett [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 11, 2005 9:36 AM
> To: mysql@lists.mysql.com
> Subject: Tuning MySQL
>
> I have a quad processor server, with 4 gigs of memory.
> It is only running MySQL right now and seems really slow
"Michael Sleman" <[EMAIL PROTECTED]> wrote:
> key_buffer = 384M
Try to enlarge this up to, say, 1G and check it out how that helps.
> sort_buffer_size = 2M
You may want to enlarge this as well.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is s
My 5 cents... tuning the MySQL database config file is half a solution.
In my experience optimizing the application code and table/index
structure delivers performance results.
Michael Sleman wrote:
Hello,
We're running 1 web server (apache 2 & php) / 1 dedicated DB server
(MySQL 4.0.20-standar
Hi Dan,
- Original Message -
From: "Dan Nelson"
Sent: Thursday, June 03, 2004 12:34 PM
Subject: Re: Tuning MySQL 4.0.20 for large full table scans
[snip]
> > Not sure what can be done about making it not go straight to tmpdir
> > with a BLOB column in the
In the last episode (Jun 03), Dossy said:
> On 2004.06.03, Dan Nelson <[EMAIL PROTECTED]> wrote:
> > Consider multicolumn indexes; if you always "SELECT field1 from
> > table where field2=blah", creating an index on (field2,field1) will
> > let mysql bypass table lookups completely.
>
> Our typica
On 2004.06.03, Dan Nelson <[EMAIL PROTECTED]> wrote:
>
> Consider multicolumn indexes; if you always "SELECT field1 from table
> where field2=blah", creating an index on (field2,field1) will let mysql
> bypass table lookups completely.
Our typical queries look something like:
SELECT level1, le
In the last episode (Jun 03), Dossy said:
> The schema in question needs a redesign (dynamic row format, contains
> two BLOB columns) but I was wondering if anyone has written up some
> guidelines for general data warehouse configuration of MySQL 4.0 --
> Google has not turned up anything useful.
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Qunfeng Dong wrote:
Thanks! I copied
/usr/share/doc/mysql-server-3.23.49/my-huge.cnf into
/etc/my.cnf and restarted mysqld from
/etc/rc.d/init.d/mysqld
but it's not improving anything.
my join query is very simple
select count(B.columnb) from B le
Thanks! I copied
/usr/share/doc/mysql-server-3.23.49/my-huge.cnf into
/etc/my.cnf and restarted mysqld from
/etc/rc.d/init.d/mysqld
but it's not improving anything.
my join query is very simple
>select count(B.columnb) from B left join A on
B.columnb = A.columna.
Both columna and columnb are v
On Friday 06 December 2002 01:11, Qunfeng Dong wrote:
> Hi,
>
> I wish to tune our MySQL Server Parameter to increase
> the speed of Join. I was trying to do a simple join
> with two tables. One is big (~2,500,000 records); the
> other one is small. The current join seems to take
> forever to finis
> I wish to tune our MySQL Server Parameter to increase
> the speed of Join. I was trying to do a simple join
> with two tables. One is big (~2,500,000 records); the
> other one is small. The current join seems to take
> forever to finish even on the indexed attribute.
>
> I am trying to learn from
On Wed, 27 Nov 2002 11:53:25 +0200
"Nick Kostirya" <[EMAIL PROTECTED]> wrote:
> Hi, All.
>
> How can I add additional characters (Ukrainian alphabet) to the source
> code
> for parse?
>
> Thanks, Nick.
>
> database,sql,query,table,handler,compile,ChangeSet
>
>
>
Just add a charset.
Tak
21 matches
Mail list logo
