Re: Can't start mysqld

2007-11-19 Thread sizo nsibande
On 20/11/2007, sizo nsibande <[EMAIL PROTECTED]> wrote: > Greetings > > I just installed mysql and a few other packages but it gives me these erros: > > [EMAIL PROTECTED] zabbix-1.4.2]# service mysqld start > mysqld: unrecognized service > __ > > [EMAIL PROTE

Re: Can't start mysqld

2007-11-19 Thread Ananda Kumar
did u try this /etc/init.d/mysql start On 11/20/07, sizo nsibande <[EMAIL PROTECTED]> wrote: > > Greetings > > I just installed mysql and a few other packages but it gives me these > erros: > > [EMAIL PROTECTED] zabbix-1.4.2]# service mysqld start > mysqld: unrecognized service > _

Can't start mysqld

2007-11-19 Thread sizo nsibande
Greetings I just installed mysql and a few other packages but it gives me these erros: [EMAIL PROTECTED] zabbix-1.4.2]# service mysqld start mysqld: unrecognized service __ [EMAIL PROTECTED] zabbix-1.4.2]# mysql ERROR 2002 (HY000): Can't connect to local M

Re: Giant database vs unlimited databases

2007-11-19 Thread Mohammad wrk
Hi Eric, In the case of a "yes" answer to the second question below, can't we still use something like VPD (Virtual Private Database) in MySQL? Thanks, Mohammad - Original Message From: Eric Frazier <[EMAIL PROTECTED]> To: Mohammad wrk <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Se

Re: ERROR 3 (HY000): Error writing file (Errcode: 5)

2007-11-19 Thread Ofer Inbar
Daevid Vincent <[EMAIL PROTECTED]> wrote: > mysql> use mydbB; > mysql> CREATE TABLE foo ( id int(10) unsigned NOT NULL auto_increment, name > varchar(255) NOT NULL, PRIMARY KEY id (id) ); > ERROR 3 (HY000): Error writing file './mydbB/foo.frm' (Errcode: 5) > > mysql> use mydbA; > mysql> CREATE TAB

Query Optimization

2007-11-19 Thread dpgirago
I need to check a date_time value in a number of tables for "up-to-date-ness." The following query is part of a larger PHP script that runs as a cron job every 10 minutes: select case # If within 2 minutes, do nothing. when (unix_timestamp() - unix_ti

Re: MySQL on Leopard

2007-11-19 Thread Steffan A. Cline
on 11/19/07 2:58 PM, Warren Young at [EMAIL PROTECTED] wrote: > Steffan A. Cline wrote: >> I built MySQL 5.045 from source and it will run fine, just not >> from launchd. > > My previous post was made with the assumption that you were using the > official binaries, and that they had not yet qual

Re: MySQL on Leopard

2007-11-19 Thread Warren Young
Steffan A. Cline wrote: I built MySQL 5.045 from source and it will run fine, just not from launchd. My previous post was made with the assumption that you were using the official binaries, and that they had not yet qualified them on Leopard. I suggested Fink because it's an easy way to ens

Re: MySQL on Leopard

2007-11-19 Thread Steffan A. Cline
on 11/19/07 12:34 PM, Warren Young at [EMAIL PROTECTED] wrote: > Steffan A. Cline wrote: >> >> Starting mysqld daemon with databases from /usr/local/mysql/var >> /usr/local/mysql/bin/mysqld_safe: line 426: 77090 Segmentation fault >> $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_

Re: MySQL on Leopard

2007-11-19 Thread Warren Young
Steffan A. Cline wrote: Starting mysqld daemon with databases from /usr/local/mysql/var /usr/local/mysql/bin/mysqld_safe: line 426: 77090 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file >> $err_log 2>&

Re: innodb rollback question

2007-11-19 Thread B. Keith Murphy
Thanks everyone for the responses. Will put me on the right track here..something that was rolling through my head but I couldn't really define. I will be blogging about this later as I think it is fairly important, but often not understood by beginning/mid-level dbas. thank again, Keith W

Re: Giant database vs unlimited databases

2007-11-19 Thread Eric Frazier
Mohammad wrk wrote: Hi, I'm working on a web 2.0 project that targeting small to medium size companies for providing business services. Companies simply register to the site and then start their business by loading their data, sharing and discussing them with others. The design/architectural

Re: Giant database vs unlimited databases

2007-11-19 Thread Russell E Glaue
How much power do you want? We migrated from Oracle to MySQL because to get enough power from Oracle 8/9i, we had to buy an extremely powerful machine. We had oracle on a sun solaris 9 box, and got X amount of power out of it. On a similar machine we installed MySQL and we got XX amount of power

Re: Giant database vs unlimited databases

2007-11-19 Thread David T. Ashley
On 11/19/07, Mohammad wrk <[EMAIL PROTECTED]> wrote: > > Hi, > > I'm working on a web 2.0 project that targeting small to medium size > companies for providing business services. Companies simply register to the > site and then start their business by loading their data, sharing and > discussing th

RE: Giant database vs unlimited databases

2007-11-19 Thread Jay Blanchard
[snip] The justification for the latter is that MySQL is not powerful enough (compare to Oracle or DB2) to handle large amount of data and concurrent users. [/snip] Not true and it has been proven time and again by the likes of Yahoo and others that size. We routinely use MySQL for large data stor

RE: MySQL Performance Analysis tools

2007-11-19 Thread Bernd Jagla
"sar" will give you some basic information about what happens on the system... (see e.g.: http://linux.die.net/man/1/sar)... -B |-Original Message- |From: thomas Armstrong [mailto:[EMAIL PROTECTED] |Sent: Monday, November 19, 2007 6:42 AM |To: mysql@lists.mysql.com |Subject: MySQL Perform

MySQL Performance Analysis tools

2007-11-19 Thread thomas Armstrong
Hi. Using MySQL on Linux, I'd like to analyze the performance and know how resources (memory, threads) are used during a period of time. Do you know any tool to carry it out? Thank you very much. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:ht

Giant database vs unlimited databases

2007-11-19 Thread Mohammad wrk
Hi, I'm working on a web 2.0 project that targeting small to medium size companies for providing business services. Companies simply register to the site and then start their business by loading their data, sharing and discussing them with others. The design/architectural decision now we are f