Query in adding SQL server to embedded Linux

Hi,
I am new to Linux.
I am working in Linux platform for ARM processor.
I am creating a simple application in Linux and i want to port to
target device.
I have SQL server with me. (mysql-server-5.0.33.tgz) which i
downloaded from web for ARM platform.

I am not sure how to add my SQL server (application) to my kernel and
boot to target device.

I want this SQL server to run once my kernel is up in target device.

Further is there any other SQL server which i can download from web
for ARM9 CPU.

Help me in this issue.
How to add my SQL server to Kernel and compile.



Regards,
Natraj.

On a sunny day (Sun, 08 Jul 2007 03:24:27 -0700) it happened
[email]svnatraj@gmail.com[/email] wrote in
<1183890267.572741.310570@i13g2000prf.googlegroups.com>:
[color=blue]
>Hi,
> I am new to Linux.
> I am working in Linux platform for ARM processor.
> I am creating a simple application in Linux and i want to port to
>target device.
>I have SQL server with me. (mysql-server-5.0.33.tgz) which i
>downloaded from web for ARM platform.
>
>I am not sure how to add my SQL server (application) to my kernel and
>boot to target device.
>
>I want this SQL server to run once my kernel is up in target device.
>
>Further is there any other SQL server which i can download from web
>for ARM9 CPU.
>
>Help me in this issue.
>How to add my SQL server to Kernel and compile.
>
>
>
>Regards,
>Natraj.[/color]

SO IT IS YOU AGAIN WHY CHANGE YOUR NAME IF YOUR HEADERS POSTING STYLE AND QUESTION
STAY THE SAME.

[email]svnatraj@gmail.com[/email] coughed up some electrons that declared:
[color=blue]
> Hi,
> I am new to Linux.
> I am working in Linux platform for ARM processor.
> I am creating a simple application in Linux and i want to port to
> target device.
> I have SQL server with me. (mysql-server-5.0.33.tgz) which i
> downloaded from web for ARM platform.
>
> I am not sure how to add my SQL server (application) to my kernel and
> boot to target device.
>
> I want this SQL server to run once my kernel is up in target device.
>
> Further is there any other SQL server which i can download from web
> for ARM9 CPU.
>
> Help me in this issue.
> How to add my SQL server to Kernel and compile.[/color]
^^^^^^^^^
rootfs

Google for "buildroot"

Then read the documentation, configure it, build it, try it and repeat 20
times like I did last month without anyone holding my hand.

Once you have that, attempt to cross compile mysql.

Are you really sure you want mysql, and not, say: sqlite?

On Jul 8, 3:59 pm, Tim Southerwood <t...@dionic.net> wrote:[color=blue]
> svnat...@gmail.com coughed up some electrons that declared:
>
>
>
>
>[color=green]
> > Hi,
> > I am new to Linux.
> > I am working in Linux platform for ARM processor.
> > I am creating a simple application in Linux and i want to port to
> > target device.
> > I have SQL server with me. (mysql-server-5.0.33.tgz) which i
> > downloaded from web for ARM platform.[/color]
>[color=green]
> > I am not sure how to add my SQL server (application) to my kernel and
> > boot to target device.[/color]
>[color=green]
> > I want this SQL server to run once my kernel is up in target device.[/color]
>[color=green]
> > Further is there any other SQL server which i can download from web
> > for ARM9 CPU.[/color]
>[color=green]
> > Help me in this issue.
> > How to add my SQL server to Kernel and compile.[/color]
>
> ^^^^^^^^^
> rootfs
>
> Google for "buildroot"
>
> Then read the documentation, configure it, build it, try it and repeat 20
> times like I did last month without anyone holding my hand.
>
> Once you have that, attempt to cross compile mysql.
>
> Are you really sure you want mysql, and not, say: sqlite?- Hide quoted text -
>
> - Show quoted text -[/color]

Hi Janpanteltje,
Ok found its same person. Surprise for me.
He is my friend Natraj working along with me.He is developing
applications for SQL server.
For the first time he is sending message.So i typed the message.

Bye

On a sunny day (Sun, 08 Jul 2007 07:21:04 -0700) it happened
[email]svnatraj@gmail.com[/email] wrote in
<1183904464.760922.96770@m37g2000prh.googlegroups.com>:
[color=blue]
>Hi Janpanteltje,
> Ok found its same person. Surprise for me.
> He is my friend Natraj working along with me.He is developing
>applications for SQL server.
> For the first time he is sending message.So i typed the message.
>
>Bye[/color]

NO PROBLEM I USE POSTGRESQL

Jan Panteltje wrote:[color=blue]
> NO PROBLEM I USE POSTGRESQL[/color]

Neat. Did you do anything to PostgreSQL's memory footprint down?

thanks
Bob

On a sunny day (Sun, 08 Jul 2007 20:07:12 GMT) it happened Bob Smith
<bsmith@linuxtoys.org> wrote in <iip7m4-k2p.ln1@mail.linuxtoys.org>:
[color=blue]
>Jan Panteltje wrote:[color=green]
>> NO PROBLEM I USE POSTGRESQL[/color]
>
>Neat. Did you do anything to PostgreSQL's memory footprint down?
>
>thanks
>Bob[/color]

NO BECAUSE I USE IT ON THE PC.
As an aside I doubt using advanced databases makes a lot of sense on embedded,
unless your embedded system has more then the 8MB RAM and 2 MB FLASH.
Even then I would probably write something simple and not refer to SQL.


Postgresql is very slow here after some time, no idea why, I have seen many
remarks about this using google.

Jan Panteltje coughed up some electrons that declared:

[color=blue]
> Postgresql is very slow here after some time, no idea why, I have seen
> many remarks about this using google.[/color]

Does your database have a lot of inserts/updates and/or deletes?

If so, you need to do:

VACUUM FULL ANALYZE

or variants thereof regularly - see:

[url]http://www.postgresql.org/docs/8.2/interactive/routine-vacuuming.html[/url]

Also, a REINDEX operation on all indexes may be a good idea. Neither or the
above is a hard and fast rule, much depends on your data update patterns -
but if you can afford to do both every night or week then you won't lose
much and may win a lot.

HTH

Tim

On a sunny day (Sun, 08 Jul 2007 22:40:24 +0100) it happened Tim Southerwood
<ts@dionic.net> wrote in <469159e5$0$640$5a6aecb4@news.aaisp.net.uk>:
[color=blue]
>Jan Panteltje coughed up some electrons that declared:
>
>[color=green]
>> Postgresql is very slow here after some time, no idea why, I have seen
>> many remarks about this using google.[/color]
>
>Does your database have a lot of inserts/updates and/or deletes?
>
>If so, you need to do:
>
>VACUUM FULL ANALYZE
>
>or variants thereof regularly - see:
>
>[url]http://www.postgresql.org/docs/8.2/interactive/routine-vacuuming.html[/url]
>
>Also, a REINDEX operation on all indexes may be a good idea. Neither or the
>above is a hard and fast rule, much depends on your data update patterns -
>but if you can afford to do both every night or week then you won't lose
>much and may win a lot.
>
>HTH
>
>Tim[/color]

Thank you, I did not know that, I have read part of that page now and saved it,
bit late here now....
No I would not say there is really heavy use, but sure the system can have
uptimes of a month, so this may well have something to do with it 'vacuum'.
Always thought such a thing was automatic....

Jan Panteltje writes:[color=blue]
> No I would not say there is really heavy use, but sure the system can
> have uptimes of a month, so this may well have something to do with it
> 'vacuum'. Always thought such a thing was automatic....[/color]

The autovacuum daemon is off by default. You have to turn it on in
postgresql.conf.

--
John Hasler
[email]john@dhh.gt.org[/email]
Dancing Horse Hill
Elmwood, WI USA

On a sunny day (Sun, 08 Jul 2007 17:29:30 -0500) it happened John Hasler
<john@dhh.gt.org> wrote in <871wfiwmut.fsf@toncho.dhh.gt.org>:
[color=blue]
>Jan Panteltje writes:[color=green]
>> No I would not say there is really heavy use, but sure the system can
>> have uptimes of a month, so this may well have something to do with it
>> 'vacuum'. Always thought such a thing was automatic....[/color]
>
>The autovacuum daemon is off by default. You have to turn it on in
>postgresql.conf.[/color]

I have switched it on now.
Thank you.
Will have to wait a couple of days to see if things still slow down.