Re: "THIS IS NOT AN ADVERTISEMENT": BugReport..Need Help
At 23:19 2/8/2002 +, Tien Lim wrote: Hi, >To Whom It May Concern: > >Environment: >Operating System Windows XP Home Edition >Using MySQL 3.23 >Using Apache 1.3.12 > >Initially it started working suddenly after trying all of the commands >below... : ) > >The next day I started the computer and it does not work : ( > > >Tried to intall from the C:\Progra~1\MySQL\bin> prompt 'mysqld-nt --install'. >Resulted in a pop-up windows MySQL error "Failed To Install Service". Since you had installed the MySQL stuff on another directory than the default C:\mysql, you need to have either the \winnt\my.ini file or c:\my.cnf file with the below section and keys: [mysqld] basedir=C:/Progra~1/MySQL datadir=C:/Progra~1/MySQL/data # ? >Typed 'mysql-nt' alone at the bin prompt..., the prompt comes back with no >stated errors. At the command prompt should be: mysqld-nt --standalone --console >Typed at prompt 'net start mysql' >Resulted in "The MySql service is starting." "The MySql service could not >be started." "A system error has occured." "A System error 1067 has >occurred." "The process terminated unexpectedly." The above means that the server has aborted for something wrong, for example you don't have the configuration file above mentioned with the basedir and datadir keys. Anyway starting the server at the command prompt (see above) you should see the error message. Try to fix them or send to the list the messages error. >When using at the prompt 'mysqladmin ping'...the following message >resulted: "MYSQLADMIN: connect to server at 'localhost' failed error: >'Can't connect to MySQL server on 'localhost' <10061>' Check that mysqld >is running on localhost and that the port is 3306. You can check this by >doing 'telnet localhost 3306'. > The above happens because the server wasn't started. Regards, -- For technical support contracts, visit https//order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
"THIS IS NOT AN ADVERTISEMENT": BugReport..Need Help
To Whom It May Concern: Environment: Operating System Windows XP Home Edition Using MySQL 3.23 Using Apache 1.3.12 Initially it started working suddenly after trying all of the commands below... : ) The next day I started the computer and it does not work : ( Tried to intall from the C:\Progra~1\MySQL\bin> prompt 'mysqld-nt --install'. Resulted in a pop-up windows MySQL error "Failed To Install Service". Typed 'mysql-nt' alone at the bin prompt..., the prompt comes back with no stated errors. Typed at prompt 'net start mysql' Resulted in "The MySql service is starting." "The MySql service could not be started." "A system error has occured." "A System error 1067 has occurred." "The process terminated unexpectedly." When using at the prompt 'mysqladmin ping'...the following message resulted: "MYSQLADMIN: connect to server at 'localhost' failed error: 'Can't connect to MySQL server on 'localhost' <10061>' Check that mysqld is running on localhost and that the port is 3306. You can check this by doing 'telnet localhost 3306'. Please help... : ) Thank you. Cordially, Tien. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
THIS IS NOT AN ADVERTISEMENT: problem of using API in embeded-server mode
Original-Message-ID: <[EMAIL PROTECTED]> Original-Sender: "Chai Wutiwiwatchai" <[EMAIL PROTECTED]> Original-Subject: problem of using API in embedded server mode Original-Date: Fri, 02 Aug 2002 20:52:45 +0700 --- To use MySQL API on Linux RH7.3 in embedded-server mode, I have compiled my source by gcc -o test test.c -L/usr/local/mysql/lib -lmysqlclient It appeared an error message undefined reference to 'mysql_server_init' undefined reference to 'mysql_server_end' The manual suggests to link libmysqld.lib instead of libmysqlclient.lib, but libmysqld.lib has not been built on my machine (I have installed rpm mysql-devel-3.23). I'm not sure what should I do to solve it. Please suggest me some. Chai _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
THIS IS NOT AN ADVERTISEMENT: Please suggest me some
Original-Message-ID: <[EMAIL PROTECTED]> Original-Sender: "Chai Wutiwiwatchai" <[EMAIL PROTECTED]> Original-Subject: Please suggest some Original-Date: Thu, 01 Aug 2002 19:52:59 +0700 - Very sorry for my childish question, I'm just starting to learn about MySQL Following is my procedure in fixing the problem of installation on Intel PC, and Linux RH7.3. 1. RPM installation 2. When execute mysql, there is a message "ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/msql.sock' (111)" 3. Follow the Binary installation 4. At ./scripts/mysql_install_db, there is a message "./bin/mysqld: Shutdown Complete" 5. At ./bin/safe_mysqld --user=mysql &, there is a message mysqld ended 6. The mysql command still cannot be executed successfully with the message in the 2nd step. In /var/log/mysql.log shows an error message "/usr/local/mysql/bin/mysqld: can't find file: ./mysql/host.frm (errno: 13)", then "mysqld ended". There is a comment suggesting that this is about 'permittion denied', but the above process is run under user 'root@localhost'. Please suggest me how can I start mysql.. Chai _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: THIS IS NOT AN ADVERTISEMENT: Please suggest me some
well for one i think you need to make sure after doing mysql_install_db , you check the ownership of your diretory , is should be owned by mysql.deamon, after that try and start mysql i think it should work after, such errors are ususally due to ownership. hope this helps :) ma 2cents cheers David Ziggy Lubowa Systems Administrator One2net (U) 7th Floor Workers Hse Tel: +256 41 345466 Mob: +256 77 769064 Fax: +256 41 345468 Web: www.one2net.co.ug --- A Network Of People And Technology | --- On Thu, 1 Aug 2002, Chai Wutiwiwatchai wrote: > Original-Message-ID: <[EMAIL PROTECTED]> > Original-Sender: "Chai Wutiwiwatchai" <[EMAIL PROTECTED]> > Original-Subject: Please suggest some > Original-Date: Thu, 01 Aug 2002 19:52:59 +0700 > >- > > Very sorry for my childish question, I'm just starting to learn about MySQL > Following is my procedure in fixing the problem of installation on Intel PC, > and Linux RH7.3. > > 1. RPM installation > 2. When execute mysql, there is a message "ERROR 2002: Can't connect to > local MySQL server through socket '/var/lib/mysql/msql.sock' (111)" > 3. Follow the Binary installation > 4. At ./scripts/mysql_install_db, there is a message "./bin/mysqld: Shutdown > Complete" > 5. At ./bin/safe_mysqld --user=mysql &, there is a message mysqld ended > 6. The mysql command still cannot be executed successfully with the message > in the 2nd step. > > In /var/log/mysql.log shows an error message "/usr/local/mysql/bin/mysqld: > can't find file: ./mysql/host.frm (errno: 13)", then "mysqld ended". There > is > a comment suggesting that this is about 'permittion denied', but the above > process is run under user 'root@localhost'. Please suggest me how can I > start > mysql.. > > Chai > > > _ > Chat with friends online, try MSN Messenger: http://messenger.msn.com > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
THIS IS NOT AN ADVERTISEMENT, ERROR 2002
Very sorry for my childish question, I'm just starting to learn about MySQL Following is my procedure in fixing the problem of installation on Intel PC, and Linux RH7.3. 1. RPM installation 2. When execute mysql, there is a message "ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/msql.sock' (111)" 3. Follow the Binary installation 4. At ./scripts/mysql_install_db, there is a message "./bin/mysqld: Shutdown Complete" 5. At ./bin/safe_mysqld --user=mysql &, there is a message mysqld ended 6. mysql command still cannot be executed successfully with the message in the 2nd step. --- Chai Wutiwiwatchai Furui Laboratory, Department of Computer Science, Tokyo Institute of Technology --- _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: THIS IS NOT AN ADVERTISEMENT
>From: [EMAIL PROTECTED]
>To: "Desmond Lee" <[EMAIL PROTECTED]>
>Subject: Re: THIS IS NOT AN ADVERTISEMENT Date: Thu, 25 Jul 2002 03:37:48
>+0200
>
>Your message cannot be posted because it appears to be either spam or
>simply off topic to our filter. To bypass the filter you must include
>one of the following words in your message:
>
>sql,query
>
>If you just reply to this message, and include the entire text of it in the
>reply, your reply will go through. However, you should
>first review the text of the message to make sure it has something to do
>with MySQL. Just typing the word MySQL once will be sufficient, for
>example.
>
>You have written the following:
>
>
>
>
>
>{
> Original-Message-ID: <[EMAIL PROTECTED]>
> Original-Sender: "Desmond Lee" <[EMAIL PROTECTED]>
> Original-Subject: question about varchars
> Original-Date: Wed, 24 Jul 2002 16:42:31 -0700
> }
>
>
>
>
>
>
>_
>Chat with friends online, try MSN Messenger: http://messenger.msn.com
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
"THIS IS NOT AN ADVERTISEMENT" Table Design
First off, this post is going to be long :)
I have designed a database that tracks member earnings on the site. Currently, the
site has been operating for two weeks, has 10,000 members, and the earnings table
already has 750,000 rows. I ran a query to see how many rows were being added each
day, and it is growing exponentially. I.e., 5 days ago, 60,000 rows were added,
yesterday, 100,000 rows were added.
Before I explain why the table is growing so quickly, some background:
Members are paid to read emails, click banners, etc. They are also paid when one of
their direct referrals (a member who signed up under their referral URL) reads an
email or clicks a banner, or when their indirect referrals (a member who signs up
under one of their referrals' referral URL) reads an email or clicks a banner.
Therefore, each time an email is read or a banner is clicked, 3 rows are added to the
earnings table. This table also keeps track of misc earnings, such as signup bonuses,
referral bonuses, etc. I designed it this way because if the site ever wants to add on
(say, pay their members to search the web), the table does not need to be modified at
all.
So, now it's obvious why the table is growing so rapidly. So far, the size of the
table is not a problem. The site is run on a dedicated server, so physical file size
will probably never be a problem (maybe it will?). With 750,000 rows, the current file
size is about 70mb. Also, since the table is indexed properly, queries are running
smoothly, and I also do not think that should ever become a problem. However, data
from this table will never be deleted, so it is just going to continue growing
forever. With 100,000 members to the site instead of 10,000, this table will grow by
millions of rows each day.
My question: Can MySQL handle a table with tens or hundreds of millions of rows?
Here is the design of the table:
CREATE TABLE earnings (
id int(9) unsigned NOT NULL auto_increment,
member_id int(8) unsigned NOT NULL default '0',
action varchar(50) NOT NULL default '',
details varchar(100) default NULL,
amount decimal(7,3) NOT NULL default '0.000',
time timestamp(14) NOT NULL,
paid enum('N','Y') NOT NULL default 'N',
PRIMARY KEY (id),
KEY earnings_member_id(member_id)
) TYPE=MyISAM;
I have played around with some possible "reconstruction" of this table to see the
results.
1) Removing the details column alltogether cuts the physical size of the table to 70%
of the original. Only about 5% of all the rows in this table use the details field,
but the 5% that do use it absolutely require it. So this really isn't much of an
option, but the 95% of rows that are not using this field are really wasting space. Is
there some other way to accomplish this?
2) Modifying the action field from varchar(35) to int(2). Since there are only about
15 different actions (Banner Clicked, Banner Clicked by Direct Referral, etc), I could
create a new table with all the actions, and then simply store the foreign key in the
earnings table. This also cuts the physical file size down to 70% that of the
original.
However, physical file size (at least I think) is not really the issue here, the issue
is the number of rows in the table, and neither of the above solutions help with this.
The only other solution I have come up with, is the following:
1) Create a table with the following fields:
member_id, # of banners clicked, amount from banners clicked, # of banners clicked by
direct referral, amount from banners clicked by direct referral, etc, etc. This would
require 12 fields just for banners clicked and emails read, and is certainly not a
"good" way of doing things (I would think anyway). Then, I would have another earnings
table in addition to this one which tracked misc earnings, such as signup bonuses,
referral bonuses, and any other future addons the site may have. That way, I keep the
advantages of what I have now, and I sacrifice little. (What I sacrifice is the
ability to view a list of every single earnings credited to a members account.
Instead, I only have the total # of banners clicked, and the total amount earned from
that...I don't have a list of all banners clicked, etc).
The method explained above would require a *LOT* of recoding, and I certainly don't
wish to spend the time if it's not even the best way of doing things. If anyone has
any ideas as to a good way of resolving this issue, I'd greatly appreciate it! I am
fully willing to pay someone for consulting services if they can present to me a good
solution to this problem!
Filter: SQL, Query
Join Excite! - http://www.excite.com
The most personalized portal on the Web!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-m
