Re: Help needed to tune Innodb on ZFS (on Solaris)

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? >

Re: Help needed to tune Innodb on ZFS (on Solaris)

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 import

Re: select count(). Help-a-newb

Thank You Richard! Merci beaucoup. wConti Richard-175 wrote: > > Hi I think you would do this : > > SELECT > sf_conferences.id, > sf_conferences.name, > count(*) AS `count` > FROM > (( > LEFT JOIN sf_forums ON sf_conferences.id=sf_forums.conferenceidfk) > LEFT sf_threads ON sf_forums.id = sf_t

Re: select count(). Help-a-newb

Hi I think you would do this : SELECT sf_conferences.id, sf_conferences.name, count(*) AS `count` FROM (( LEFT JOIN sf_forums ON sf_conferences.id=sf_forums.conferenceidfk) LEFT sf_threads ON sf_forums.id = sf_threads.forumidfk) LEFT JOIN sf_messages ON sf_threads.id = sf_messages.threadidfk GROU

Re: We have just moved to a new web server where we are running mysql version: 5.0.45

Thanks to Martin and Paul for their answers. -- Malka Cymbalista Webmaster, Weizmann Institute of Science [EMAIL PROTECTED] 08-934-3036 >>> On 4/9/2008 at 3:54 PM, in message <[EMAIL PROTECTED]>, Paul DuBois <[EMAIL PROTECTED]> wrote: > At 1:13 PM +0300 4/9/08, Malka Cymbalista wrote: >>We ha

innodb status

Hi All, show engine innodb status gives the following information. I am not able to draw conclusion. SEMAPHORES -- OS WAIT ARRAY INFO: reservation count 97641, signal count 97303 --Thread 1140881760 has waited at log0log.c line 1986 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x

Re: We have just moved to a new web server where we are running mysql version: 5.0.45

At 1:13 PM +0300 4/9/08, Malka Cymbalista wrote: We have just moved to a new web server where we are running mysql version: 5.0.45 On the old machine, when we gave the following command: update table1 set passwd = password('xx') where user_name="xx"; and then gave the following command, SELECT

Re: We have just moved to a new web server wherewearerunningmysql version: 5.0.45

PS, the document I send you also mentions: To change the password but create a short hash, use the OLD_PASSWORD() function instead: Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle & MS SQL Server Upscene Productions http://www.upscene.com My thoughts: ht

Re: We have just moved to a new web server wherewearerunningmysql version: 5.0.45

>Thanks. So how does one use the password function in MySQL 5? Most probably just the same, but your MySQL 4 password hashes are incompatible with MySQL 5 password hashes. A search on "password" in the MySQL docs returns quite some stuff, see: http://dev.mysql.com/doc/refman/5.0/en/password-hash

Help needed to tune Innodb on ZFS (on Solaris)

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 log

Re: We have just moved to a new web server where wearerunningmysql version: 5.0.45

Thanks. So how does one use the password function in MySQL 5? -- Malka Cymbalista Webmaster, Weizmann Institute of Science [EMAIL PROTECTED] 08-934-3036 >>> On 4/9/2008 at 2:57 PM, in message <[EMAIL PROTECTED]>, "Martijn Tonies" <[EMAIL PROTECTED]> wrote: >> Thanks for the email but that didn

Re: We have just moved to a new web server where wearerunningmysql version: 5.0.45

>Thanks for the email but that didn't help. I gave the commands again using only single quotes and I still get no results. >On the old machine we were running MySQL 4.0.15a. Is there any difference with the password function in these 2 versions? Could be, I remember MySQL 4.1 having a new passwo

Re: We have just moved to a new web server where we arerunningmysql version: 5.0.45

Thanks for the email but that didn't help. I gave the commands again using only single quotes and I still get no results. On the old machine we were running MySQL 4.0.15a. Is there any difference with the password function in these 2 versions? -- Malka Cymbalista Webmaster, Weizmann Institut

Re: confirm subscribe to mysql@lists.mysql.com

On Wednesday 09 April 2008 13:03:39 [EMAIL PROTECTED] wrote: > To confirm that you would like > > [EMAIL PROTECTED] > > added to the mysql mailing list, please click on > the following link: > > > http://lists.mysql.com/s/mysql/47fca28b736fbf40/Nicola.Sabbi=poste. >it > > This confirmation serv

Re: confirm subscribe to mysql@lists.mysql.com

On Wednesday 09 April 2008 13:02:57 [EMAIL PROTECTED] wrote: > To confirm that you would like > > [EMAIL PROTECTED] > > added to the mysql mailing list, please click on > the following link: > > http://lists.mysql.com/s/mysql/47fca2617dc97f36/nsabbi=tiscali.it > > This confirmation serves two p

Re: We have just moved to a new web server where we arerunningmysql version: 5.0.45

>Thanks for the answer but that's not it. It was my typo. I am really updating and selecting from the same table. Perhaps "not it" either, but strings should be in single quotes, not double quotes. Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions htt

RE: We have just moved to a new web server where we are runningmysql version: 5.0.45

Thanks for the answer but that's not it. It was my typo. I am really updating and selecting from the same table. -- Malka Cymbalista Webmaster, Weizmann Institute of Science [EMAIL PROTECTED] 08-934-3036 >>> On 4/9/2008 at 1:54 PM, in message <[EMAIL PROTECTED]>, "Edward Kay" <[EMAIL PROTECT

RE: We have just moved to a new web server where we are runningmysql version: 5.0.45

> We have just moved to a new web server where we are running mysql > version: 5.0.45 > On the old machine, when we gave the following command: > update table1 set passwd = password('xx') where user_name="xx"; Here you're updating 'table1'... > and then gave the following command, > SELECT us

We have just moved to a new web server where we are running mysql version: 5.0.45

We have just moved to a new web server where we are running mysql version: 5.0.45 On the old machine, when we gave the following command: update table1 set passwd = password('xx') where user_name="xx"; and then gave the following command, SELECT user_name FROM alon_protein_passwd WHERE (user_na

select count(). Help-a-newb

Is it possible to get the count() for "forums, "threads" and "messages" extrapolating from the following query? Thanx for helping a newb. select sf_conferences.id, sf_conferences.name from ((#variables.tableprefix#conferences left JOIN sf_forums ON sf_conferences.id=sf_forums.conferenceidfk

Re: Replication

It depends how public your database is. If you ever need to shut off one client then you might use separate users. Otherwise it's just annoying complexity, use a single user. Remember to use a different 'server-id' for each client! Ben Krishna Chandra Prajapati wrote: Hi, I am setting

Re: Merge Tables and Replication

[EMAIL PROTECTED] wrote: > > Does this sound about right? Anybody see any road hazards? If not, and > this line of thinking is reasonable, should the DB with the older records > also be replicated so that when a new old records table needs to be > created, I don't have to repeat everything on th