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: 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: 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
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: 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
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-mail
Advertisement
will be VERY profitable in a short period of time. 1.. After you have ordered all 5 reports, take this advertisement and REMOVE the name address of the person in REPORT # 5. This person has made it through the cycle and is no doubt counting their fortune. 2..Move the name address in REPORT # 4 down TO REPORT # 5. 3.. Move the name address in REPORT # 3 down TO REPORT # 4. 4.. Move the name address in REPORT # 2 down TO REPORT # 3. 5.. Move the name address in REPORT # 1 down TO REPORT # 2 6 Insert YOUR name address in the REPORT # 1 Position. PLEASE MAKE SURE you copy every name address ACCURATELY! This is critical to YOUR success. == Take this entire letter, with the modified list of names, and save it on your computer. DO NOT MAKE ANY OTHER CHANGES. Save this on a disk as well just in case if you loose any data. To assist you with marketing your business on the internet, the 5 reports you purchase will provide you with invaluable marketing information which includes how to send bulk e-mails legally, where to find thousands of free classified ads and much more. There are 2 Primary methods to get this venture going: METHOD # 1: BY SENDING BULK E-MAIL LEGALLY == Let's say that you decide to start small, just to see how it goes, and we will assume You and those involved send out only 5,000 e-mails each. Let's also assume that the mailing receive only a 0.2% (2/10 of 1%) response (the response could be much better but lets just say it is only 0.2%). Also many people will send out hundreds of thousands e-mails instead of only 5,000 each). Continuing with this example, you send out only 5,000 e-mails. With a 0.2% response, that is only 10 orders for report # 1. Those 10 people responded by sending out 5,000 e-mail each for a total of 50,000. Out of those 50,000 e-mails only 0.2% responded with orders. That's=100 people responded and ordered Report # 2. Those 100 people mail out 5,000 e-mails each for a total of 500,000 e-mails. The 0.2% response to that is 1000 orders for Report # 3. Those 1000 people send 5,000 e-mail each for a total of 5 million e-mail sent out. The 0.2% response is 10,000 orders for Report # 4. Those 10,000 people send out 5,000 e-mails each for a total of 50,000,000 (50 million) e-mails. The 0.2% response to that is 100,000 orders for Report # 5. THAT'S 100,000 ORDERS TIMES $5 EACH = $500,000.00 (half a million dollars). Your total income in this example is: 1. $50 + 2. $500 + 3. $5,000 + 4. $50,000 + 5 $500,000 Grand Total=$555,550.00 NUMBERS DO NOT LIE. GET A PENCIL PAPER AND FIGURE OUT THE WORST POSSIBLE RESPONSES AND NO MATTER HOW YOU CALCULATE IT, YOU WILL STILL MAKE A LOT OF MONEY! == REMEMBER FRIEND, THIS IS ASSUMING ONLY 10 PEOPLE ORDERING OUT OF 5,000 YOU MAILED TO. Dare to think for a moment what would happen if everyone or half or even one 4th of those people mailed 100,000 e-mails each or more? There are over 150 million people on the Internet worldwide and counting, with thousands more coming on line every day. Believe me, many people will do just that, and more! METHOD # 2: BY PLACING FREE ADS ON THE INTERNET == Advertising on the net is very, very inexpensive and there are hundreds of FREE places to advertise. Placing a lot of free ads on the Internet will easily get a larger response. We strongly suggest you start with Method # 1 and add METHOD #2 as you go along. For every $5 you receive, all you must do is e-mail them the Report they ordered. That's it. Always provide same day service on all orders. This will guarantee that the e-mail they send out, with your name and address on it, will be prompt because they can not advertise until they receive the report. ===AVAILABLE REPORTS The reason for the cash is not because this is illegal or somehow wrong. It is simply about time. Time for checks or credit cards to be cleared or approved, etc. Concealing it is simply so no one can SEE there is money in the envelope and steal it before it gets to you. ORDER EACH REPORT BY ITS NUMBER NAME ONLY. Notes: Always send $5 cash (U.S. CURRENCY) for each Report. Checks NOT accepted. Make sure the cash is concealed by wrapping it in at least 2 sheets of paper. On one of those sheets of paper, Write the NUMBER the NAME of the Report you are ordering, YOUR E-MAIL ADDRESS and your name and postal address. PLACE YOUR ORDER FOR THESE REPORTS NOW : == REPORT# 1: 'The Insider's Guide To Advertising for Free On The Net Order Report #1 from Keith Gilbert 2822 N. Ridgewood St. Santa Ana, CA 92705 USA REPORT # 2: The Insider's Guide To Sending Bulk Email On The Net Order Report # 2 from: Steve Stwan P.O
