contributing to mysql ..

hi all
am new to opensource. iam a finalist student doing computer science in
East Africa. i would like to start contributing to the mysql project.
can u guys give me some getting started tips or hacks...
anything that can help me dive in straight..
thanx
Mugisha Moses
--
skype name : mossplix
twitter: @mugisha

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: contributing to mysql ..

here you are:

http://forge.mysql.com/wiki/Contributing

Greetings,

Mattia Merzi.

2009/5/27 mugisha moses :
> hi all
> am new to opensource. iam a finalist student doing computer science in
> East Africa. i would like to start contributing to the mysql project.
> can u guys give me some getting started tips or hacks...
> anything that can help me dive in straight..
> thanx
> Mugisha Moses

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: contributing to mysql ..

--_97e1fa85-1d21-450a-b2ee-4c93bbcda300_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable



mysql docs could use a translation to Swahili (if you speak/read and write =
Swahili)
?

thanks!
Martin Gainty=20
______________________________________________=20
Verzicht und Vertraulichkeitanmerkung/Note de d=E9ni et de confidentialit=
=E9
=20
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaeng=
er sein=2C so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiter=
leitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient l=
ediglich dem Austausch von Informationen und entfaltet keine rechtliche Bin=
dungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen w=
ir keine Haftung fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut =EAtre privil=E9gi=E9. Si vous n'=EAtes=
pas le destinataire pr=E9vu=2C nous te demandons avec bont=E9 que pour sat=
isfaire informez l'exp=E9diteur. N'importe quelle diffusion non autoris=E9e=
ou la copie de ceci est interdite. Ce message sert =E0 l'information seule=
ment et n'aura pas n'importe quel effet l=E9galement obligatoire. =C9tant d=
onn=E9 que les email peuvent facilement =EAtre sujets =E0 la manipulation=
=2C nous ne pouvons accepter aucune responsabilit=E9 pour le contenu fourni=
..




> Date: Wed=2C 27 May 2009 15:51:13 +0200
> Subject: Re: contributing to mysql ..
> From: mattia.merzi@gmail.com
> To: mossplix@gmail.com
> CC: mysql@lists.mysql.com
>=20
> here you are:
>=20
> http://forge.mysql.com/wiki/Contributing
>=20
> Greetings=2C
>=20
> Mattia Merzi.
>=20
> 2009/5/27 mugisha moses :
> > hi all
> > am new to opensource. iam a finalist student doing computer science in
> > East Africa. i would like to start contributing to the mysql project.
> > can u guys give me some getting started tips or hacks...
> > anything that can help me dive in straight..
> > thanx
> > Mugisha Moses
>=20
> --=20
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmgainty@hotmail.c=
om
>=20

____________________________________________________________ _____
Hotmail=AE has ever-growing storage! Don=92t worry about storage limits.
http://windowslive.com/Tutorial/Hotmail/Storage?ocid=3DTXT_T AGLM_WL_HM_Tuto=
rial_Storage1_052009=

--_97e1fa85-1d21-450a-b2ee-4c93bbcda300_--

Why can"t I kill the query cache?

Also titled, I want this to run slow ALL the time...

I have a group of dreadful queries that I have to optimize. =20

Some take 20-30 seconds each -- the first time that I run them. But
then they never seem to take that long after the first time (taking less
than a second then). If I change the "keywords" searched for in the
where clauses, then they take a long time again... so it's the
query-cache or something just like it.

BUT, I am doing this each time :
flush tables;
reset query cache;
set global query_cache_size=3D0;
SELECT SQL_NO_CACHE DISTINCT ca.conceptid AS headingid,

And still it's not avoiding the cache.

Is there a cache I'm missing?

Tim...


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Why can"t I kill the query cache?

Little, Timothy wrote:
> Also titled, I want this to run slow ALL the time...
>
> I have a group of dreadful queries that I have to optimize.
>
> Some take 20-30 seconds each -- the first time that I run them. But
> then they never seem to take that long after the first time (taking less
> than a second then). If I change the "keywords" searched for in the
> where clauses, then they take a long time again... so it's the
> query-cache or something just like it.
>
> BUT, I am doing this each time :
> flush tables;
> reset query cache;
> set global query_cache_size=0;
> SELECT SQL_NO_CACHE DISTINCT ca.conceptid AS headingid,
>
> And still it's not avoiding the cache.
>
> Is there a cache I'm missing?
>
> Tim...
>
>
Disk cache, but I don't know how to clear it.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Why can"t I kill the query cache?

In the last episode (May 29), Gerald L. Clark said:
> Little, Timothy wrote:
> > Also titled, I want this to run slow ALL the time...
> >
> > I have a group of dreadful queries that I have to optimize.
> >
> > Some take 20-30 seconds each -- the first time that I run them. But
> > then they never seem to take that long after the first time (taking less
> > than a second then). If I change the "keywords" searched for in the
> > where clauses, then they take a long time again... so it's the
> > query-cache or something just like it.
> >
> > BUT, I am doing this each time :
> > flush tables;
> > reset query cache;
> > set global query_cache_size=0;
> > SELECT SQL_NO_CACHE DISTINCT ca.conceptid AS headingid,
> >
> > And still it's not avoiding the cache.
> >
> > Is there a cache I'm missing?
> >
> > Tim...
> >
> >
> Disk cache, but I don't know how to clear it.

Create a file 2x the size of your RAM (for a 2gb system, dd if=/dev/zero
of=bigfile bs=1024k count=4096), then dd it to /dev/null (dd if=bigfile
of=/dev/null bs=1024k). That should flush your OS cache. The guaranteed
way would be to dismount then remount your filesystem, but that could be
difficult depending on how many other processes are using it..

--
Dan Nelson
dnelson@allantgroup.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Why can"t I kill the query cache?

You can also flush the cache with echo 1 > /proc/sys/vm/drop_caches if
you have a new enough kernel.

On Fri, May 29, 2009 at 2:16 PM, Dan Nelson wrote=
:
> In the last episode (May 29), Gerald L. Clark said:
>> Little, Timothy wrote:
>> > Also titled, I want this to run slow ALL the time...
>> >
>> > I have a group of dreadful queries that I have to optimize.
>> >
>> > Some take 20-30 seconds each -- the first time that I run them. =A0But
>> > then they never seem to take that long after the first time (taking le=
ss
>> > than a second then). =A0If I change the "keywords" searched for in the
>> > where clauses, then they take a long time again... =A0so it's the
>> > query-cache or something just like it.
>> >
>> > BUT, I am doing this each time :
>> > flush tables;
>> > reset query cache;
>> > set global query_cache_size=3D0;
>> > SELECT =A0 SQL_NO_CACHE DISTINCT ca.conceptid AS headingid,
>> >
>> > And still it's not avoiding the cache.
>> >
>> > Is there a cache I'm missing?
>> >
>> > Tim...
>> >
>> >
>> Disk cache, but I don't know how to clear it.
>
> Create a file 2x the size of your RAM (for a 2gb system, dd if=3D/dev/zer=
o
> of=3Dbigfile bs=3D1024k count=3D4096), then dd it to /dev/null (dd if=3Db=
igfile
> of=3D/dev/null bs=3D1024k). =A0That should flush your OS cache. =A0The gu=
aranteed
> way would be to dismount then remount your filesystem, but that could be
> difficult depending on how many other processes are using it..
>
> --
> =A0 =A0 =A0 =A0Dan Nelson
> =A0 =A0 =A0 =A0dnelson@allantgroup.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Deric.bergen@g=
mail.com
>
>



--=20
Eric Bergen
eric.bergen@gmail.com
http://www.ebergen.net

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Why can"t I kill the query cache?

I had heard of that trick but never looked it up. 'man proc' tells me

/proc/sys/vm/drop_caches (since Linux 2.6.16)
Writing to this file causes the kernel to drop clean cach=
es,
dentries and inodes from memory, causing that memory to bec=
ome
free.

To free pagecache, use echo 1 > /proc/sys/vm/drop_caches; =
to
free dentries and inodes, use echo 2 > /proc/sys/vm/drop_cach=
es;
to free pagecache, dentries and inodes, use echo 3 =
>
/proc/sys/vm/drop_caches.

Because this is a non-destructive operation and dirty obje=
cts
are not freeable, the user should run sync(8) first.

I should read the whole man page...

On Fri, May 29, 2009 at 5:59 PM, Eric Bergen wrote:
> You can also flush the cache with echo 1 > /proc/sys/vm/drop_caches if
> you have a new enough kernel.
>
> On Fri, May 29, 2009 at 2:16 PM, Dan Nelson wro=
te:
>> In the last episode (May 29), Gerald L. Clark said:
>>> Little, Timothy wrote:
>>> > Also titled, I want this to run slow ALL the time...
>>> >
>>> > I have a group of dreadful queries that I have to optimize.
>>> >
>>> > Some take 20-30 seconds each -- the first time that I run them. =A0Bu=
t
>>> > then they never seem to take that long after the first time (taking l=
ess
>>> > than a second then). =A0If I change the "keywords" searched for in th=
e
>>> > where clauses, then they take a long time again... =A0so it's the
>>> > query-cache or something just like it.
>>> >
>>> > BUT, I am doing this each time :
>>> > flush tables;
>>> > reset query cache;
>>> > set global query_cache_size=3D0;
>>> > SELECT =A0 SQL_NO_CACHE DISTINCT ca.conceptid AS headingid,
>>> >
>>> > And still it's not avoiding the cache.
>>> >
>>> > Is there a cache I'm missing?
>>> >
>>> > Tim...
>>> >
>>> >
>>> Disk cache, but I don't know how to clear it.
>>
>> Create a file 2x the size of your RAM (for a 2gb system, dd if=3D/dev/ze=
ro
>> of=3Dbigfile bs=3D1024k count=3D4096), then dd it to /dev/null (dd if=3D=
bigfile
>> of=3D/dev/null bs=3D1024k). =A0That should flush your OS cache. =A0The g=
uaranteed
>> way would be to dismount then remount your filesystem, but that could be
>> difficult depending on how many other processes are using it..
>>
>> --
>> =A0 =A0 =A0 =A0Dan Nelson
>> =A0 =A0 =A0 =A0dnelson@allantgroup.com
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Deric.bergen@=
gmail.com
>>
>>
>
>
>
> --
> Eric Bergen
> eric.bergen@gmail.com
> http://www.ebergen.net
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dbaron@xaprb.c=
om
>
>



--=20
Baron Schwartz, Director of Consulting, Percona Inc.
Our Blog: http://www.mysqlperformanceblog.com/
Our Services: http://www.percona.com/services.html

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg