SELECT * FROM tablename PROCEDURE ANALYSE()

Anyone know of a way to get the size of a row in bytes?


-----Original Message-----
From: Benjamin Wiechman [mailto:benw@meltel.com]
Sent: 24 August 2007 16:18
To: mysql@lists.mysql.com
Subject: Column type suggestions


I recall there is a command that will display suggested optimal columns
types for a given table based on the data stored in the table, but I haven't
been able to figure out what it is.



!



Thanks.



Ben Wiechman

Wisper High Speed Internet

ben@wisper-wireless.com




This email is confidential and may also be privileged. If you are not the intended recipient please notify us immediately by telephoning +44 (0)20 7452 5300 or email postmaster@touchlocal.com. You should not copy it or use it for any purpose nor disclose its contents to any other person. Touch Local cannot accept liability for statements made which are clearly the sender's own and are not made on behalf of the firm.

Touch Local Limited
Registered Number: 2885607
VAT Number: GB896112114
Cardinal Tower, 12 Farringdon Road, London EC1M 3NN
+44 (0)20 7452 5300

Hi,

Does anyone know if thread_concurrency works in linux or is it just
limited to Solaris and Windows?

I know the general rule is number of CPU's*2 but will this actually have
any effect with Linux's threading model?

Thanks for any

Andrew

Mysql, query


This message has been scanned for viruses by BlackSpider MailControl - www.blackspider.com

Hi,

Does anyone know if thread_concurrency works in linux or is it just
limited to Solaris and Windows?

I know the general rule is number of CPU's*2 but will this actually have
any effect with Linux's threading model?

Thanks for any

Andrew

Mysql, query


This message has been scanned for viruses by BlackSpider MailControl - www.blackspider.com

I am not sure whether you are talking about innodb_thread_concurrency. If so
please check out
http://www.mysqlperformanceblog.com/...ad-concurrency for
more details. Innodb_thread_concurrency works on linux.

Thanks
Alex

On 8/29/07, Andrew Braithwaite <andrew.braithwaite@lovefilm.com> wrote:
>
> Hi,
>
> Does anyone know if thread_concurrency works in linux or is it just
> limited to Solaris and Windows?
>
> I know the general rule is number of CPU's*2 but will this actually have
> any effect with Linux's threading model?
>
> Thanks for any
>
> Andrew
>
> Mysql, query
>
>
> This message has been scanned for viruses by BlackSpider MailControl -
> www.blackspider.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=a...rthu@gmail.com
>
>


--
Thanks
Alex
http://blog.360.yahoo.com/alex.lurthu

Hi,

Just to make it clear; I mean thread_concurrency, not
innodb_thread_concurrency.

Cheers,

Andrew

________________________________

From: Alex Arul Lurthu [mailto:alex.lurthu@gmail.com]
Sent: Wed, 29 August 2007 10:10
To: Andrew Braithwaite
Cc: mysql@lists.mysql.com
Subject: Re: thread_concurrency in linux


I am not sure whether you are talking about innodb_thread_concurrency.
If so please check out
http://www.mysqlperformanceblog.com/...ad-concurrency
<http://www.mysqlperformanceblog.com/...ead-concurrenc
y> for more details. Innodb_thread_concurrency works on linux.

Thanks
Alex


On 8/29/07, Andrew Braithwaite < andrew.braithwaite@lovefilm.com
<mailto:andrew.braithwaite@lovefilm.com> > wrote:

Hi,

Does anyone know if thread_concurrency works in linux or is it
just
limited to Solaris and Windows?

I know the general rule is number of CPU's*2 but will this
actually have
any effect with Linux's threading model?

Thanks for any

Andrew

Mysql, query


This message has been scanned for viruses by BlackSpider
MailControl - www.blackspider.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=a...rthu@gmail.com






--
Thanks
Alex
http://blog.360.yahoo.com/alex.lurthu



Click here
<https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg==
iiiREta3C9fLX2sgE4nZ0noAtl5JkL!iHvm8DPbEDRRKpLeL7i kiuRlyFp0i7J7fYEY7nF3F
VUYnGZkja2gCxA9NHjly6QmOpZocISpuA+UrwziytsgRcJau9l J+URueA6A4sujcf4weV3KV
xWnxPySn+mZ5GsUC1bNZpbK2T8Bb8k9u!n4UIOoj> to report this email as spam.

Hi,

Does anyone know if thread_concurrency works in linux or is it just
limited to Solaris and Windows?

I know the general rule is number of CPU's*2 but will this actually have
any effect with Linux's threading model?

Thanks for any

Andrew

Mysql, query


This message has been scanned for viruses by BlackSpider MailControl - www.blackspider.com

Andrew Braithwaite wrote:
> Does anyone know if thread_concurrency works in linux or is it just
> limited to Solaris and Windows?

Hi! That variable only affects Solaris, as the Solaris threading
library supports thr_setconcurrency().

innodb_thread_concurrency, however, can affect all platforms, AFAIK:

http://www.mysql.org/doc/refman/5.0/...ad_concurrency

> I know the general rule is number of CPU's*2 but will this actually have
> any effect with Linux's threading model?

Nope, at least AFAIK.

-jay