RE: Win NT/2000 mySQL question
Hi Marc, > Thanks Jacques & Christopher, > > you are telling on your site (compliment, really nice work), that your > MySQLX-component is quicker then ODBC. > Any benchmarking about it ? Yes, although not prominent, we've had this on your site for a while: http://www.scibit.com/Products/Software/VCL/benchmark.gif This was done almost a year ago using a (winnt) MySQL table with 40 fields and 10 000 records, giving a comparison on the most used functions on a table, scrolling, posting, deleting, inserting, etc. You would be interested in the first (Blue) and last (Aqua) bars. * The Blue bar is our MySQLDataset Delphi component (http://www.scibit.com/MYSQLCOMPONENTS) using ONLY the (MySQL AB provided) libmysql.dll (straight to the server). * The Brown bar is our MySQLDataset component accessing the MySQL server in cached-updates mode. * The Yellow bar is accessing the same table created in MSAccess. * The Aqua bar is accessing the MySQL server using the standard MyODBC driver. The MySQLDataset component is used as the foundation for MySQLX (http://www.scibit.com/MySQLX) as well as Mascon (http://www.scibit.com/Mascon) > Also - does your component support ADO-objects ? - specially > Recordsets .. > or do you have something similar ? Yes, the most important ADO calls are all available as seen in the OnLine Help File, ex. Connection, Recordset, Fields, etc. As you can see in the Help many more properties and methods are also available giving you full control and access to your MySQL server(s). It is multithreaded and able to access different databases on the server simultaneously. > How can you access mySQL with Mascon ? Only via this ActiveX or also with > ODBC ? Mascon is a standalone MySQL tool, to access any MySQL server (v3.21.x to v3.23.x). You ONLY need Mascon.exe and the accompanying libmysql.dll (MySQL AB developed). Mascon has no built-in support for either Active X or ODBC. > Back to Win NT: > > On the WinNT-Server I only will run mySQL accessing via an ODBC > networkconnection. > Are there any disadvantages running mySQL on NT, not Linux - Linuxfans > keep cool !;) .. I mean just for this kind of application We've not found any major advantages or disadvantages (we run both) that is NOT dependent on your scenario, Linux is by default more stable (nothing to do with MySQL) than NT and given the same hardware it is also faster (because of general less overhead), it is also much cheaper to maintain/upgrade (given a default installation and ignoring training and learning curves). Win2K has many more default features in the IIS and is easier/faster to manage/setup/config on a global (multiple server) scale. This is of course expected from an all in one package, while you will get many more features and functionality from your Linux box if tweaked, patched and installed with everything available (to manage this afterwards could be a challenge). Again everybody keep cool, this is just one guy's (my) opinion and is only valid for me at this point in time. > Or - what is recommended ? Running IIS and mySQL on one Server ? Depends on the load the hardware is going to handle (number of hits, LAN/Internet speeds, etc). Difficult to answer; You can always start of with this config, then move the MySQL (which is probably going to do more work) to a Linux box later. Regards Jacques - 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: mySQL vs Oracle
At 10:49 AM 1/22/2001 -0800, Ann Ricchiazzi quoth: >Dear mySQL Users, > >I am trying to choose between mySQL and Oracle for a Linux server. My >specific questions are: > >1) Will mySQL handle 3000 hits/day well? Yes, over the last 219 hours one of my servers has been averaging 55.417 queries/second. I've managed to get it up to 800 q/s before. >2) Does mySQL handle multi-media file formats? For example, if I want to >store audio clips, or Flash movie clips, or PowerPoint presentations, >can I do so? Depending on size it will work fine. However, you would be far better off with any database using a string referencing a local file. Mike... - 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: aborted connections?
Read the archives. The detailed story can be found there. Use newest MySQL and newest PHP CVS. These errors will go away. Maciek > -Original Message- > From: tc lewis [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 23, 2001 3:56 AM > To: [EMAIL PROTECTED] > Subject: aborted connections? > > > > we're seeing a lot of errors like these in our error log files from mysql: > > 010122 17:38:52 Aborted connection 177373 to db: 'XXX' user: 'YYY' > host: `ZZZ' (Got an error reading communication packets) > > i haven't investigated too too much about this yet, but i was wondering > what common problems this error might be associated with. i'll keep > looking through the manual, but suggestions would of course be wonderful. > > the connections are over ethernet/tcp, and the eth interfaces on the mysql > server are showing 0 errors after months of uptime, so i'm guessing it's > not a tcp/ip issue, as the wording of that error might suggest. > > -tcl. > > > - > 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
Re: Mysql opening tables
Hello Michael, Tuesday, January 23, 2001, 2:02:33 AM, you wrote: Peter>> I saw this many times on different machines and this sequince never Peter>> resolves itself ( the locks never disapears). Always the only way to Peter>> fix this is to kill one of the queries. I killed query #16 and Peter>> situation momentaly fixed: MW> MW> Can you kill any thread when this happens to resolve the problem? Yes. In thin case I always kill the oldest of Locked queries and problem fixes MW> Looks very strange; There is probably some broadcast that is missing MW> after a table is repaired. I shall try to simulate this. It MW> shouldn't be that hard. The other strange thing is - not all tables are locked - some queries are running without any problems and some got stuck. MW> I will do that. Thank you. -- Best regards, Petermailto:[EMAIL PROTECTED] - 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
Problem with make test on Msql-Mysql-modules-1.2215 with MySQL-3.23
To whom it may concern, I get this error when I run make test. Details Perl-5.003_03 MySQL-3.23.32 SCO UnixWare 7.1.1 Developement System that comes with UW 7.1.1 libz 1.1.3 What is this sysbol __llasgdivu that is referenced in libmysqlclient.so.10 used or does it come from? Does any one else have this problem? PERL_DL_NONLAZY=1 /usr/bin/perl -I../blib/arch -I../blib/lib -I/usr/local/lib/perl5/5.00503/i386-svr5 -I/usr/local/lib/perl5/5.00503 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/00baseinstall_driver(mysql) failed: Can't load '../blib/arch/auto/ DBD/mysql/mysql.so' for module DBD::mysql: dynamic linker: /usr/bin/perl: relocation error: symbol not found: __llasgdivu; referenced from: /usr/local/mysql/lib/mysql/libmysqlclient.so.10 at /usr/local/lib/perl5/5.00503/i386-svr5/DynaLoader.pm line 169. at (eval 1) line 3 Perhaps a required shared library or dll isn't installed where expected at t/00base.t line 38 dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 4-5 Thanks, -- Boyd Gerber <[EMAIL PROTECTED]> ZENEZ 3748 Valley Forge Road, Magna Utah 84044 Office 801-250-0795 FAX 801-250-7975 - 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: HELP! Newbie can't get MySQL to start at boot time
* Paul DuBois <[EMAIL PROTECTED]> [010122 21:03]: > >Is there a newbie resource somewhere for Those-Too-Stupid-to-Live? > > > > Did you run mysql_install_db ? > Yes. Several times. :-) The database files are created in /var/mysql. There may be some confusion in this port as to where the datbase etc. files belong. Sometimes it looks in /var/mysql, sometimes in /usr/pkg/var/mysql. Thanks, Dave Chapman -- Dave Chapman |"tar is not a plaything" [EMAIL PROTECTED]|[EMAIL PROTECTED] - 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
HELP! Newbie can't get MySQL to start at boot time
I'm trying to get MySQL running under NetBSD 1.5, and am having problems getting mysqld running at boot time. It starts, but quits almost right away. If I start mysqld using mysqld.server the log file indicates that the table mysqld.host is not found. If I use safe_mysqld the log file just indicates that mysqld started and stopped. I used the NetBSD pkgsrc to install the MySQL server and client, but I guess I have omitted a step somewhere. Is there a newbie resource somewhere for Those-Too-Stupid-to-Live? Thanks, Dave Chapman -- David Chapman [EMAIL PROTECTED] --<561WU/1.1yrs>-- - 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: INSERT/UPDATE and MyISAM table
Paul DuBois wrote: > > In a table with no deleted rows, INSERTS happen by adding the row to > the end of the table. An UPDATE won't necessarily be able to replace > the row in-place (the new data may be longer than the old), so you won't > be able to perform concurrent SELECTS along with the UPDATE. > Has Monty or anybody made mention of adding this feature for fixed row length tables, it would be yet another reason to use fixed row length tables. STeve - 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: INSERT/UPDATE and MyISAM table
At 12:00 PM +0900 1/23/01, Nat Sakimura wrote: >?Hi. > >In the MyISAM table without any deleted rows, >I read in the documentation that INSERT and >SELECT can occur concurrently. > >What about UPDATE? I presume update will >issue exclusive lock to the table unlike >insert, but I wanted to know for sure. In a table with no deleted rows, INSERTS happen by adding the row to the end of the table. An UPDATE won't necessarily be able to replace the row in-place (the new data may be longer than the old), so you won't be able to perform concurrent SELECTS along with the UPDATE. > >Also, after deleting some rows in the table, >if I do the OPTIMIZE TABLE, does the >concurrent INSERT/SELECT property return? Yep. -- Paul DuBois, [EMAIL PROTECTED] - 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
INSERT/UPDATE and MyISAM table
Hi. In the MyISAM table without any deleted rows, I read in the documentation that INSERT and SELECT can occur concurrently. What about UPDATE? I presume update will issue exclusive lock to the table unlike insert, but I wanted to know for sure. Also, after deleting some rows in the table, if I do the OPTIMIZE TABLE, does the concurrent INSERT/SELECT property return? Best regards, Nat - 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
aborted connections?
we're seeing a lot of errors like these in our error log files from mysql: 010122 17:38:52 Aborted connection 177373 to db: 'XXX' user: 'YYY' host: `ZZZ' (Got an error reading communication packets) i haven't investigated too too much about this yet, but i was wondering what common problems this error might be associated with. i'll keep looking through the manual, but suggestions would of course be wonderful. the connections are over ethernet/tcp, and the eth interfaces on the mysql server are showing 0 errors after months of uptime, so i'm guessing it's not a tcp/ip issue, as the wording of that error might suggest. -tcl. - 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
bdb table stability / what to watch out for?
in the mysql manual, i noticed: "Even though Berkeley DB is in itself very tested and reliable, the MySQL interface is still considered beta quality. We are actively improving and optimizing it to get it stable very soon." a team i'm in is considering trying bdb tables for some things for a queue table of sorts. seeing if the row-level granularity of bdb tables or transaction support can help us. i'm wondering what is yet considered unstable about bdb tables, or what we should watch out for or test if we try using it under a good amount of load. i saw the note about deleting tables when not in auto commit mode. anything else that is a known or unconfirmed but possible issue that we could possibly help test out? comments more than welcome! -tcl. - 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: Form Submission
Actually, the TEXTAREA tag does capture the line breaks, they get stored in the mysql
table in a text type column. When I query the table and re-display the TEXTAREA, the
line breaks are preserved. I am using Perl CGI scripts with DBI, DBD-MySQL.
I defined the TEXTAREA (in perl):
$portdesc
The $portdesc is assigned the value directly from the SELECT statement, no fancy
formatting required.
>Mike,
> I'm assuming that you are trying to output this to a webpage.
>
> I think your problem is that, HTML does not use line breaks in the
>document. You can try this out by making a simple webpage like this:
>
> A
>B
>C
>D
>
>
> When you view this in your internet browser, you will see:
>
>A B C D
>
> To insert a line break in HTML, you use a "" tag. In order to have the
>line breaks appear properly in your final document you must insert a ""
>every place the line breaks should appear, and a "" at every
>paragraph break.
>
> In PHP I I have my own funtion to do this, but it would not be that hard to
>make one for Perl or ASP, if that is what you are using. It's just a simple
>search and replace.
>
>function format_text($text){
> // Change any "<", and ">" their equivalent HTML entities
> $text = htmlspecialchars($text);
> // Strip out carriage returns
> $text = ereg_replace("\r","",$text);
> // Handle paragraphs
> $text = ereg_replace("\n\n","",$text);
> // Handle line breaks
> $text = ereg_replace("\n","",$text);
>return $text;
>}
>
>
>Hope this helps,
>
>Daniel Von Fange
>
>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]]
>Sent: Monday, January 22, 2001 8:37 PM
>To: [EMAIL PROTECTED]
>Subject: Form Submission
>
>
>When I submit a form and enter it into the database
>it does not recognize when the user presses enter.
>It keeps coming up as one long line, and for poetry,
>it doesn't look very pleasant.
>
>I would love if anyone could help me because it would
>very much help me when creating future projects. I am
>only 16 and I am doing considerably well since the
>person that showed me MySQL said it was too hard for
>me and I will never get anything good done.
>
>But anyways, please help
>
>Mike
>
>
>
>-
>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
-
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: Form Submission
Mike,
I'm assuming that you are trying to output this to a webpage.
I think your problem is that, HTML does not use line breaks in the
document. You can try this out by making a simple webpage like this:
A
B
C
D
When you view this in your internet browser, you will see:
A B C D
To insert a line break in HTML, you use a "" tag. In order to have the
line breaks appear properly in your final document you must insert a ""
every place the line breaks should appear, and a "" at every
paragraph break.
In PHP I I have my own funtion to do this, but it would not be that hard to
make one for Perl or ASP, if that is what you are using. It's just a simple
search and replace.
function format_text($text){
// Change any "<", and ">" their equivalent HTML entities
$text = htmlspecialchars($text);
// Strip out carriage returns
$text = ereg_replace("\r","",$text);
// Handle paragraphs
$text = ereg_replace("\n\n","",$text);
// Handle line breaks
$text = ereg_replace("\n","",$text);
return $text;
}
Hope this helps,
Daniel Von Fange
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Monday, January 22, 2001 8:37 PM
To: [EMAIL PROTECTED]
Subject: Form Submission
When I submit a form and enter it into the database
it does not recognize when the user presses enter.
It keeps coming up as one long line, and for poetry,
it doesn't look very pleasant.
I would love if anyone could help me because it would
very much help me when creating future projects. I am
only 16 and I am doing considerably well since the
person that showed me MySQL said it was too hard for
me and I will never get anything good done.
But anyways, please help
Mike
-
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
Re: Form Submission
At 6:36 PM -0700 1/22/01, [EMAIL PROTECTED] wrote: >When I submit a form and enter it into the database >it does not recognize when the user presses enter. >It keeps coming up as one long line, and for poetry, >it doesn't look very pleasant. This doesn't really have anything to do with MySQL. It's an HTML question. Try adding wrap="physical" or wrap="hard" to your tag. -- Paul DuBois, [EMAIL PROTECTED] - 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
Form Submission
When I submit a form and enter it into the database it does not recognize when the user presses enter. It keeps coming up as one long line, and for poetry, it doesn't look very pleasant. I would love if anyone could help me because it would very much help me when creating future projects. I am only 16 and I am doing considerably well since the person that showed me MySQL said it was too hard for me and I will never get anything good done. But anyways, please help Mike - 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: Binding mySQL to a specific IP
Pass the option --bind-address=x.x.x.x to safe_mysqld .. see http://www.mysql.com/doc/C/o/Command-line_options.html. -ai On Mon, 22 Jan 2001, Irong Lungs Jr wrote: > Anyone know how to bind / set mySQL to listen on a specified IP on a > multi-homed machine (my machine running mySQL as 3 diff Interfaces, and I > only want to accessible via the local eth0 interface) > > - 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: Binding mySQL to a specific IP
At 7:17 PM -0500 1/22/01, Irong Lungs Jr wrote: >Anyone know how to bind / set mySQL to listen on a specified IP on a >multi-homed machine (my machine running mySQL as 3 diff Interfaces, and I >only want to accessible via the local eth0 interface) Try running mysqld --help to get a list of options that the server accepts. Or see: http://www.mysql.com/doc/C/o/Command-line_options.html Looks like the --bind-address option may be what you want. -- Paul DuBois, [EMAIL PROTECTED] - 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: C API -- using mysql_ping()
> If I call mysql_close() > on a connection that's already closed, will it just return quietly or > will it segfault? You can and should always call mysql_close(). It won't yield problems regardless of the DB's state. Regards, Nick G. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 22, 2001 1:15 PM To: [EMAIL PROTECTED] Subject: C API -- using mysql_ping() If a connection has been closed by the mySQL server, like in a timeout condition, does the API function mysql_ping() awake the connection again if the reconnect flag was set, or will it just return a lost server error? In other words, if I'm testing to see if a long-unused connection is dead before I close it by calling mysql_ping(), am I then forced to call mysql_close() or can I assume the connection is closed and lost and just free up the memory I've used for the connection? If I call mysql_close() on a connection that's already closed, will it just return quietly or will it segfault? - 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
Re: AW: mySQL vs Oracle
Sorry, but our mailserver is down again (Exchange ;), so I had to read via web and search my list-archiv for your mailadress. We tested the system on a Dual-P3-800Mhz-1GB while developing. Now it's running on a E4500 with 6x400Mhz and 8 Slaves (P3-800). Our site generates currently 1,5-2 Million PI's per day with rather many queries to the db's. At the moment we store only european stockdata but in february (I hope) we will add US-Stocks (about 2 times as much additional inserts). I'm confident that mysql will keep running easily. We will see ;) The main problem is I/O. We had to outsource some tables to extra discarrays to take some load from the machine. Regards On Mon, 22 Jan 2001, Christian Rabe wrote: >> we use mysql here for our whole site. there are up to 500 >> inserts/second alone from the stockdata-feed and thats only part of >> our site and about 200-300 selects/second per machine. in >> combination with replication (3.23.xx) you can near to limitlessly >> scale (if you have limitless money for slave-machines). >> >> we tried oracle and it was far too slow for us. mysql made our test about 30 >> times faster. > >That's some serious throughput - what kind of hardware? - 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
Binding mySQL to a specific IP
Anyone know how to bind / set mySQL to listen on a specified IP on a multi-homed machine (my machine running mySQL as 3 diff Interfaces, and I only want to accessible via the local eth0 interface) - 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: mySQL vs Oracle
My bad... They aren't scheduled to come out until 3.24. Sorry. .:: Nathan Cook [ [EMAIL PROTECTED] ] ::. Systems & Network Administrator :: Programmer [ phone - 208.343.3110 ][ pager - 208.387.9983 ] - Original Message - From: "tc lewis" <[EMAIL PROTECTED]> To: "Nathan Cook" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, January 22, 2001 2:42 PM Subject: Re: mySQL vs Oracle > > er, what? > did i miss something? heh. > > -tcl. > > > On Mon, 22 Jan 2001, Nathan Cook wrote: > > > Note: As of version 3.2.3gamma Mysql Supports Sub-Selects. > > > > .:: Nathan Cook [ [EMAIL PROTECTED] ] ::. > > Systems & Network Administrator :: Programmer > > [ phone - 208.343.3110 ][ pager - 208.387.9983 ] > > > > - Original Message - > > From: "Scott Gerhardt" <[EMAIL PROTECTED]> > > To: "Ann Ricchiazzi" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > Sent: Monday, January 22, 2001 12:10 PM > > Subject: RE: mySQL vs Oracle > > > > > > > Hello Ann, > > > > > > The answer to you question depends on how you plan to use the database > > (i.e. > > > financial trancactions, serving data on the web etc.) as well as financial > > > considerations. MySQL is free and Oracle is expensive. > > > > > > > > > Here are some questions you should answer: > > > > > > 1.) Do you need full Transaction support (commit roll-back)? > > > 2.) Do you need subselect and union queries? > > > 3.) Do you need Triggers and Stored Procedures? > > > 4.) Do you absolutely need Foreign Key support? > > > > > > If you anwered YES to any of the above go with Oracle, Sybase, Frontbase, > > > Openbase etc. otherwise, MySQL is an excellent choice. MySQL is very fast > > > and probably faster than Oracle in most cases but I have no documented > > proof > > > (Oracle doesn't like having their benchmarks published). > > > > > > I know this isn't a definite answer and you are on a tight deadline. Hope > > > this helps just the same. > > > > > > > > > ___ > > > > > > Scott A. Gerhardt P.Geo. > > > Gerhardt Information Technologies > > > [EMAIL PROTECTED] > > > ___ > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > I am trying to choose between mySQL and Oracle for a Linux server. My > > > > specific questions are: > > > > > > > > 1) Will mySQL handle 3000 hits/day well? > > > > 2) Does mySQL handle multi-media file formats? For example, if I want to > > > > store audio clips, or Flash movie clips, or PowerPoint presentations, > > > > can I do so? > > > > > > > > We make the decision this decision at 3:00 today. Your advice will be > > > > most helpful. > > > > Thanks, > > > > Ann > > > > > > > > > > > > - > > > > 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 > > > > > > > > > > > > - > > 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 > > - 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: SELECT FROM TABLE WHERE ?
select max(rating) from singlemalts will give you the highest value or select * from singlemalts order by rating desc will give all the rows ordered by rating and the first row will have the highest value Richard Reina wrote: > I've tried the manual (and the Oreily MySQL book) and played around with > MAX() and GREATEST() but could not figure it out. > > > |ID |NAME |RATING | > |213 |McCallen 12| 9 | > |214 |Glenmorangie | 8 | > |225 |Glenlevit | 7 | > > How do I select the one with highest rating without knowing what the > highest rating is. > > SELECT ID, NAME, RATING > FROM SINGLEMALTS > WHERE RATING > > - > 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
RE: SELECT FROM TABLE WHERE ?
Select * from singlemalts order by rating limit 1; Now, you have to share your samples with the rest of us! :) Cal http://www.calevans.com -Original Message- From: Richard Reina [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 21, 2001 12:49 PM To: [EMAIL PROTECTED] Subject: SELECT FROM TABLE WHERE ? I've tried the manual (and the Oreily MySQL book) and played around with MAX() and GREATEST() but could not figure it out. |ID |NAME |RATING | |213|McCallen 12| 9 | |214|Glenmorangie | 8 | |225|Glenlevit | 7 | How do I select the one with highest rating without knowing what the highest rating is. SELECT ID, NAME, RATING FROM SINGLEMALTS WHERE RATING - 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
Startup of mysqld in scripts/mysql_install_db causes SEGV
>Description: I have compiled MySQL 3.23.32 on Slackware 7.1 with BerkeleyDB support. Configure, make and make install work fine without any errors, however as soon as I run scripts/mysql_install_db it fails: Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables scripts/mysql_install_db: line 1: 28667 Segmentation fault /usr/local/mysql/libexec/mysqld --bootstrap --skip-grant-tables --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var Installation of grant tables failed! gdb tells me: [New Thread 1024 (runnable)] Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 1024 (runnable)] 0x0 in ?? () (gdb) bt #0 0x0 in ?? () #1 0x401e39e8 in ?? () #2 0x401dd50a in ?? () #3 0x401c795f in ?? () #4 0x401c7b14 in ?? () #5 0x401c7d7c in ?? () #6 0x4019b82c in getservbyname_r () from /lib/libc.so.6 #7 0x4019b6a4 in getservbyname () from /lib/libc.so.6 #8 0x80c43af in set_ports () #9 0x80c4602 in server_init () #10 0x80c539f in main () #11 0x400f4577 in __libc_start_main () from /lib/libc.so.6 >How-To-Repeat: Compile MySQL 3.23.32 with default options (except for BerkeleyDB support) under Slackware 7.1 on a Athlon TBird 750, I assume. >Fix: Wish I knew. >Submitter-Id: >Originator:Rob Kaper >Organization: Rob Kaper | [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] | http://capsi.com/ - telnet://chat.capsi.com:2300/ | 'What? In riddles?' said Gandalf. 'No! For I was talking aloud | to myself. A habit of the old: they choose the wisest person | present to speak to; the long explanations needed by the young | are wearying.' - "Lord of the Rings", JRR Tolkien > >MySQL support: [none | licence | email support | extended email support ] >Synopsis: Startup of mysqld in scripts/mysql_install_db causes SEGV >Severity: >Priority: >Category: mysql >Class: >Release: mysql-3.23.32 (Source distribution) >Environment: System: Linux ezri 2.2.16 #22 Fri Jun 16 16:51:24 PDT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-slackware-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Nov 1 22:25 /lib/libc.so.6 -> libc-2.1.3.so -rwxr-xr-x 1 root root 1013224 Mar 21 2000 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 20266642 Mar 20 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Mar 20 2000 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql --with-berkeley-db=/usr/local/BerkeleyDB.3.2 - 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
Mysql opening tables
Hi! > "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes: Peter> Hello monty, Peter> After I got mysql/system crash I often see the following after I Peter> bring mysql up again: Peter> ruby:~ # w Peter> 9:37pm up 7:35, 1 user, load average: 0.01, 0.04, 0.06 Peter> USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT Peter> root pts/0mail.local9:37pm 0.00s 0.07s 0.02s w Peter> ruby:/spylog/layers # tail -1 /spylog/db/ruby.err | grep 45/g06hits Peter> 010122 15:20:46 Warning: Checking table: './st45/g06hits' Peter> 010122 15:20:46 Warning: Recovering table: './st45/g06hits' Peter> mysqladmin debug reports no table locks active Peter> I saw this many times on different machines and this sequince never Peter> resolves itself ( the locks never disapears). Always the only way to Peter> fix this is to kill one of the queries. I killed query #16 and Peter> situation momentaly fixed: Can you kill any thread when this happens to resolve the problem? Looks very strange; There is probably some broadcast that is missing after a table is repaired. I shall try to simulate this. It shouldn't be that hard. Peter> The log also shows the table was repaired long ago: Peter> 010122 15:16:35 Warning: Checking table: './st31/g07pages' Peter> 010122 15:16:36 Warning: Recovering table: './st31/g07pages' Peter> Hope this will somehow point the problem :) Peter> P.S You anyway write two messages to a log file then a table is Peter> automatically repaired. I think there might be a good idea to add Peter> third message indicating the table was fixed successfully. I will do that. Regards, Monty - 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
SELECT FROM TABLE WHERE ?
I've tried the manual (and the Oreily MySQL book) and played around with MAX() and GREATEST() but could not figure it out. |ID |NAME |RATING | |213|McCallen 12| 9 | |214|Glenmorangie | 8 | |225|Glenlevit | 7 | How do I select the one with highest rating without knowing what the highest rating is. SELECT ID, NAME, RATING FROM SINGLEMALTS WHERE RATING - 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: ERROR 1040: Too many connections
Hi! > "Filippo" == Filippo Carletti <[EMAIL PROTECTED]> writes: >> >Sometimes something bad happens in a server and it is hard to figure out >> >what is going on because we can not get in. I'd like to suggest a change Filippo> for >> >MySQL 4 protocol, such that a connection from localhost can still get >> >through even if there are too many connections. >> >> It is already there - max_connections limit is actually for the user Filippo> without >> process_priv. For the user with process_priv, the limit is max_connections Filippo> + >> 1. The trick is not to connect as root for your regular connections. Filippo> There must be a problem, then. Filippo> It happens to me, often, that I cannot obtain a proc or ext with mysqladmin Filippo> as root. Filippo> All accesses are through an unpriv username, I have max_connections=1000 and Filippo> a Filippo> ps ax | grep mysqld | wc -l gives me a value lower than 1000, so there must Filippo> be room for one more connection. Filippo> Filippo What error do you get? Are you sure that your other users dosn't have the 'PROCESS_PRIV' privilege? Regards, Monty - 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
Patch for build problems on Alpha!
Hi! > "Christian" == Christian Hammers <[EMAIL PROTECTED]> writes: Christian> Hello Christian> Here is something from the Debian bug tracking system for you. If fixes Christian> the compilation problems on Alpha architecture. Christian> bye, Christian> -christian- >> downloaded 3.23.31. Builds just fine on i386, but sadly, fails on alpha >> (potato, Linux 2.2.13, gcc version 2.95.2 2220). >> ha_berkeley.cc:250: passing `void * (*)(unsigned int)' >> as argument 4 of >> `log_archive(DB_ENV *, char ***, unsigned int, void * (*)(long >> unsigned int))' Fixed. Thanks for pointing this out! Regards, Monty - 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: Creating keys
Hi, Its in the manual, but it is something like ALTER TABLE Discharge ADD PRIMARY KEY (Vessel, Voyage, PortName); Regards Quentin -Original Message- From: Don [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 23 January 2001 10:39 To: msql list Subject: Creating keys The online documentation only has a syntax example of creating a key consisting of a single column. I wish to create a primary key encompassing three columns. Here is my syntax: create primary key on Discharge (Vessel, Voyage, PortName); where Discharge is my table name and all three fields names are not null. MySQL is reporting a syntax error. What is the error please? Thanks, Don - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: select performance
Hi. I am not sure what you compare against, because the description of the second test script is not clear to me in the given context. Anyhow, the difference probably comes from the fact, that MySQL has to use indexes to find the row which matches to the id and has to access about log(65000) =~ 16 index entries (_not_ index blocks. the number of blocks depends also on other factors). The offset method only works reasonably, if you don't have (many) holes in the ids. Assume a worst case, were you have one id=1 and the following ids continue at 20. MySQL will use only 65000 records, whereas the offset method has to use space for 265000. You see? There are some more arguments about that, but it should answer your question regarding number of blocks read in. Bye, Benjamin. On Sun, Jan 21, 2001 at 08:33:49PM -0800, [EMAIL PROTECTED] wrote: > Hi, > > I am trying to benchmark mysql's performance for fetching a random record. > To do so, I have setup the following configuration: Linux, 14 2G tables, > each populated with 65000 records of fixed 32k size, type mediumblob. My > test randomly generates a table/id pair and selects the record. I then > compare this to a different script that randomly generates a table/offset > pair, seeks to the offset and reads 32k worth of data directly from the > table. I have run my tests with a warm mysql key cache (mysqladmin ext > shows all key blocks in the cache). Between each test, I do a 1G read of a > different file > to /dev/null in order to clear the system's buffer cache. > > When I compare the number of blocks read from the disk (via vmstat/iostat), > that number is about 1.5 to twice as much for the mysqld test vs. the random > read test. Does anyone have an idea of why this is the case? Why would > mysqld read in almost double the amount of data? - 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
MYODBC
Hi All, Are there any switches to force MyODBC to do a "Silent" install? Thanks, Lee Jenkins - 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: MySQL constantly crash on BLOB insertions...
Hi. On Mon, Jan 22, 2001 at 11:37:23PM +0200, [EMAIL PROTECTED] wrote: > > "Huang-Ming" == Huang-Ming <[EMAIL PROTECTED]> writes: > > Huang-Ming> hi Tim, > > Huang-Ming> thanks for the prompt response which is hard to be seen with Oracle and >Microsoft. > > Huang-Ming> sorry, i should have had studied hard the manual a year ago. regarding >the error, however, would the error message be better to tell users to adjust >relevant configuration than only to say "MySQL gone away"? it's misleading to some >serious fault in MySQL which actually is not therein, isn't it? > > The reason is that to guard against wrong usage and faulty > connections, MySQL will abort any transactions that doesn't follow the > protocol it enforces. In this case MySQL notices a packet that is > much bigger than the maximum allowed packet size and it can't know if > the packet is valid or is from someone that is trying to use mysqld in > a way that the MySQL maintainer haven't approved of. Just to be safe, > mysqld will in this case abort the connections and the client will get > the 'MySQL gone away' error. Given that, a cleaner(?) way would IMHO be, that the server sends (hm. within connection approvement, if there already exists one?) the status of that variable to the client. Then the client library could check the size itself and issue itself the appropriate error. Or at least add a note that you might have hit the limit and what the current limit is. I assume there are reasons why the current implementation differs. But anyhow, the fact that even an developer *grin to Tim* considered this behaviour a possible bug, shows that it is too non-intuitive. Sorry, but my knowledge about the internals are too bad in order to make a more constructive proposal what to change. Bye, Benjamin. - 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: AW: mySQL vs Oracle
On Mon, 22 Jan 2001, Christian Rabe wrote: > we use mysql here for our whole site. there are up to 500 > inserts/second alone from the stockdata-feed and thats only part of > our site and about 200-300 selects/second per machine. in > combination with replication (3.23.xx) you can near to limitlessly > scale (if you have limitless money for slave-machines). > > we tried oracle and it was far too slow for us. mysql made our test about 30 > times faster. That's some serious throughput - what kind of hardware? - 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: mySQL vs Oracle
Nathan Cook wrote: > > Note: As of version 3.2.3gamma Mysql Supports Sub-Selects. See... I know I've been spending too much time at the computer when I get email in my dreams :) what version are you talking about anyway, that number isn't even a valid version number.. - 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: Creating keys
Do this instead: ALTER TABLE Discharge ADD PRIMARY KEY (Vessel, Voyage, PortName); -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger > -Original Message- > From: Don [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 22, 2001 15:39 > > The online documentation only has a syntax example of creating a key > consisting of a single column. I wish to create a primary key > encompassing three columns. Here is my syntax: > > create primary key on Discharge (Vessel, Voyage, PortName); > > where Discharge is my table name and all three fields names are not > null. MySQL is reporting a syntax error. What is the error please? > - 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: mySQL vs Oracle
er, what? did i miss something? heh. -tcl. On Mon, 22 Jan 2001, Nathan Cook wrote: > Note: As of version 3.2.3gamma Mysql Supports Sub-Selects. > > .:: Nathan Cook [ [EMAIL PROTECTED] ] ::. > Systems & Network Administrator :: Programmer > [ phone - 208.343.3110 ][ pager - 208.387.9983 ] > > - Original Message - > From: "Scott Gerhardt" <[EMAIL PROTECTED]> > To: "Ann Ricchiazzi" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Monday, January 22, 2001 12:10 PM > Subject: RE: mySQL vs Oracle > > > > Hello Ann, > > > > The answer to you question depends on how you plan to use the database > (i.e. > > financial trancactions, serving data on the web etc.) as well as financial > > considerations. MySQL is free and Oracle is expensive. > > > > > > Here are some questions you should answer: > > > > 1.) Do you need full Transaction support (commit roll-back)? > > 2.) Do you need subselect and union queries? > > 3.) Do you need Triggers and Stored Procedures? > > 4.) Do you absolutely need Foreign Key support? > > > > If you anwered YES to any of the above go with Oracle, Sybase, Frontbase, > > Openbase etc. otherwise, MySQL is an excellent choice. MySQL is very fast > > and probably faster than Oracle in most cases but I have no documented > proof > > (Oracle doesn't like having their benchmarks published). > > > > I know this isn't a definite answer and you are on a tight deadline. Hope > > this helps just the same. > > > > > > ___ > > > > Scott A. Gerhardt P.Geo. > > Gerhardt Information Technologies > > [EMAIL PROTECTED] > > ___ > > > > > > > > > > > > > > > > > > > > > > > I am trying to choose between mySQL and Oracle for a Linux server. My > > > specific questions are: > > > > > > 1) Will mySQL handle 3000 hits/day well? > > > 2) Does mySQL handle multi-media file formats? For example, if I want to > > > store audio clips, or Flash movie clips, or PowerPoint presentations, > > > can I do so? > > > > > > We make the decision this decision at 3:00 today. Your advice will be > > > most helpful. > > > Thanks, > > > Ann > > > > > > > > > - > > > 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 > > > > > > > - > 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
AW: mySQL vs Oracle
Hi, we use mysql here for our whole site. there are up to 500 inserts/second alone from the stockdata-feed and thats only part of our site and about 200-300 selects/second per machine. in combination with replication (3.23.xx) you can near to limitlessly scale (if you have limitless money for slave-machines). we tried oracle and it was far too slow for us. mysql made our test about 30 times faster. fazit: if you do not use sub-selects, foreign keys and triggers or store some very touchy personal data i suggest using mysql. Regards -Ursprungliche Nachricht- Von: Ann Ricchiazzi [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 22. Januar 2001 19:49 An: [EMAIL PROTECTED] Betreff: mySQL vs Oracle Dear mySQL Users, I am trying to choose between mySQL and Oracle for a Linux server. My specific questions are: 1) Will mySQL handle 3000 hits/day well? 2) Does mySQL handle multi-media file formats? For example, if I want to store audio clips, or Flash movie clips, or PowerPoint presentations, can I do so? We make the decision this decision at 3:00 today. Your advice will be most helpful. Thanks, Ann - 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
Re: MySQL constantly crash on BLOB insertions...
> "Huang-Ming" == Huang-Ming <[EMAIL PROTECTED]> writes: Huang-Ming> hi Tim, Huang-Ming> thanks for the prompt response which is hard to be seen with Oracle and Microsoft. Huang-Ming> sorry, i should have had studied hard the manual a year ago. regarding the error, however, would the error message be better to tell users to adjust relevant configuration than only to say "MySQL gone away"? it's misleading to some serious fault in MySQL which actually is not therein, isn't it? The reason is that to guard against wrong usage and faulty connections, MySQL will abort any transactions that doesn't follow the protocol it enforces. In this case MySQL notices a packet that is much bigger than the maximum allowed packet size and it can't know if the packet is valid or is from someone that is trying to use mysqld in a way that the MySQL maintainer haven't approved of. Just to be safe, mysqld will in this case abort the connections and the client will get the 'MySQL gone away' error. Regards, Monty - 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
Creating keys
The online documentation only has a syntax example of creating a key consisting of a single column. I wish to create a primary key encompassing three columns. Here is my syntax: create primary key on Discharge (Vessel, Voyage, PortName); where Discharge is my table name and all three fields names are not null. MySQL is reporting a syntax error. What is the error please? Thanks, Don - 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: Error in UPDATE syntax?
On Mon, 22 Jan 2001, Don wrote:
> Hi,
>
> I'm looking at the docs for the UPDATE syntax right now!
>
> Here is my code (in Perl):
>
> $sqlCmd = $dbh->prepare("UPDATE Ports SET Country = $country,
> TransPort = $transPort,
> Suspended = $suspended,
> Transit = $transit,
> Tranship = $tranship,
> CargoDisp = $disposition
> WHERE PortName = $port");
You need to use single quotes around your variables.
> Ports is my table. "GERMANY" is actually the contents of the scaler
> array $country, so why is it giving me an unknown column error?
$country being an array explains your problem. if $country sends the value
"USA GERMANY", mysql wont know what's going on because you're not limiting
your values.
update set = '$value';
is more correct. I suggest using debug functions that tells you what
you're trying to do so that you can try the same command in your
database. this way it's easier to see what might be wrong.
Hope this helps.
Atle
-
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: select HELP from HERE where HELP_NEEDED = TRUE !
This problem is not necessary a mysql problem, it might be a problem with your server or whatever you're using to access your database. For example, if you're using PHP to access your database, you should ask the PHP mailinglist :) (if you are using PHP btw, you migth not be closing your connections when you're done, so that the mysql server "fills" up). Atle On Mon, 22 Jan 2001, Amir wrote: > hi, > i have a web serverrunning redhat linux 7 > i installed mysql 3.23.30 two weeks ago and it has begun to cause problems > i get a "lost connection during query" every half a minute, basicly my web site is >dead > i tried instaling the 3.23.32 ( stable you call it! ) and i get the same response > i'm in desparate need for help... !!! > H E L P ! ! ! > > 10q > amir > [EMAIL PROTECTED] > - 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: How do I allow one user to access DB from anywhere
I suggest you read up on the GRANT syntax :) http://www.mysql.com/doc/G/R/GRANT.html What you need done can either be done through issuing a GRANT statement, or modifying the mysql table manually. If you're not too familiar with MySQL, I suggest you use the GRANT. Atle On Mon, 22 Jan 2001, Apolinaras 'Apollo' Sinkevicius wrote: > What would I have to do (sql expression) if I want to have a user be able > to access database from anywhere (so I don't have to make additions for all > the hosts). > database=list > username=bigpapa > password=see5060 > What would be the route to do that? > Thanx > > > - > 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
integrity of data in mySQL
mySQL Users, Have any of you had any cases of corrupted data in my SQL? We are choosing between Oracle and mySQL, and it boils down to just a few key issues at this point. Integrity of data is one of them. Your answer before 3:00 would be most helpful, as that is when we have a meeting to discuss this. Thank you, Ann Ricchiazzi UC Santa Barbara - 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
Sorry, I just a bug without attaching my email address.
>Description: 23655:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in ./bin/my_print_defaults: _F64_fstat 23655:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in ./bin/my_print_defaults: _F64_stat 23655:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in ./bin/my_print_defaults: __cf_fprintf 23655:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in ./bin/my_print_defaults: _F64_lstat 23655:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in ./bin/my_print_defaults: __cf_printf 23655:./bin/my_print_defaults: /sbin/loader: Fatal Error: this executable has unresolvable symbols 18295:./bin/resolveip: /sbin/loader: Error: Unresolved symbol in ./bin/resolveip: __cf_fprintf 18295:./bin/resolveip: /sbin/loader: Error: Unresolved symbol in ./bin/resolveip: __cf_printf 18295:./bin/resolveip: /sbin/loader: Error: Unresolved symbol in ./bin/resolveip: _F64_stat 18295:./bin/resolveip: /sbin/loader: Error: Unresolved symbol in ./bin/resolveip: _F64_fstat 18295:./bin/resolveip: /sbin/loader: Fatal Error: this executable has unresolvable symbols 22436:./bin/resolveip: /sbin/loader: Error: Unresolved symbol in ./bin/resolveip: __cf_fprintf 22436:./bin/resolveip: /sbin/loader: Error: Unresolved symbol in ./bin/resolveip: __cf_printf 22436:./bin/resolveip: /sbin/loader: Error: Unresolved symbol in ./bin/resolveip: _F64_stat 22436:./bin/resolveip: /sbin/loader: Error: Unresolved symbol in ./bin/resolveip: _F64_fstat 22436:./bin/resolveip: /sbin/loader: Fatal Error: this executable has unresolvable symbols WARNING: The host 'ecpc.ucsd.edu' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL deamon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables %DECthreads bugcheck (version V3.18-042), terminating execution. % Reason: stkGet: (4) nxm_stack_create (0,5251072,16384,8192) % Running on OSF1 V4.0(1091) on , 512Mb; 1 CPUs, pid 10588 Installation of grant tables failed! >How-To-Repeat: Run scripts/mysql_install_db >Fix: >Submitter-Id: Derek Chang >Originator:system PRIVILEGED account >Organization: Scripps Institute of Oceanography - CRD >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release: mysql-3.23.31 (Official MySQL binary) >Environment: System: OSF1 ecpc.ucsd.edu V4.0 1091 alpha Machine: alpha Some paths: /meteora/local/bin/perl /usr/bin/make /usr/bin/cc Compilation info: CC='cc -pthread' CFLAGS='-O4 -ansi_alias -ansi_args -fast -inline speed -speculate all' CXX='cxx -pthread' CXXFLAGS='-O4 -ansi_alias -fast -inline speed -speculate all -noexceptions -nortti' LDFLAGS='' LIBC: lrwxrwxrwx 1 root system17 Jan 13 1999 /lib/libc.a -> ../ccs/lib/libc.a lrwxrwxrwx 1 root system17 Jan 13 1999 /usr/lib/libc.a -> ../ccs/lib/libc.a Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-prefix=/usr/local/mysql --with-mysqld-ldflags=-all-static --disable-shared '--with-named-thread-libs=-lpthread -lmach -lexc -lc' --disable-shared Perl: This is perl, version 5.001 - 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
Running mysql_install_db will not create grant tables
>Description: httpd5%14664:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in ./bin/my_print_defaults: _F64_fstat 14664:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in ./bin/my_print_defaults: _F64_stat 14664:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in ./bin/my_print_defaults: __cf_fprintf 14664:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in ./bin/my_print_defaults: _F64_lstat 14664:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in ./bin/my_print_defaults: __cf_printf 14664:./bin/my_print_defaults: /sbin/loader: Fatal Error: this executable has unresolvable symbols Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables %DECthreads bugcheck (version V3.18-042), terminating execution. % Reason: stkGet: (4) nxm_stack_create (0,5251072,16384,8192) % Running on OSF1 V4.0(1091) on , 512Mb; 1 CPUs, pid 10588 Installation of grant tables failed! Starting mysqld daemon with databases from /usr/local/mysql-3.23.31-dec-osf5.1-alphaev6/data 010122 13:05:31 mysqld ended >How-To-Repeat: Run scripts/mysql_install_db >Fix: >Submitter-Id: Derek P. Chang >Originator:system PRIVILEGED account >Organization: Scripps Institute of Oceanography - CRD >MySQL support: [none | licence | email support | extended email support ] >Synopsis: Won't create grant tables using mysql_install_db >Severity: >Priority: >Category: mysql >Class: >Release: mysql-3.23.31 (Official MySQL binary) >Environment: System: OSF1 ecpc.ucsd.edu V4.0 1091 alpha Machine: alpha Some paths: /meteora/local/bin/perl /usr/bin/make /usr/bin/cc Compilation info: CC='cc -pthread' CFLAGS='-O4 -ansi_alias -ansi_args -fast -inline speed -speculate all' CXX='cxx -pthread' CXXFLAGS='-O4 -ansi_alias -fast -inline speed -speculate all -noexceptions -nortti' LDFLAGS='' LIBC: lrwxrwxrwx 1 root system17 Jan 13 1999 /lib/libc.a -> ../ccs/lib/libc.a lrwxrwxrwx 1 root system17 Jan 13 1999 /usr/lib/libc.a -> ../ccs/lib/libc.a Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-prefix=/usr/local/mysql --with-mysqld-ldflags=-all-static --disable-shared '--with-named-thread-libs=-lpthread -lmach -lexc -lc' --disable-shared Perl: This is perl, version 5.001 - 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
Mysql opening tables
Hello monty, After I got mysql/system crash I often see the following after I bring mysql up again: ruby:~ # w 9:37pm up 7:35, 1 user, load average: 0.01, 0.04, 0.06 USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT root pts/0mail.local9:37pm 0.00s 0.07s 0.02s w ruby:~ # mysqladmin processlist | grep -v Sleep +--+---+-+-+-+---+---+--+ | Id | User | Host| db | Command | Time | State | Info | | | +--+---+-+-+-+---+---+--+ | 1| titan | mars.local | counter | Query | 22606 | Waiting for table | INSERT |INTO st45.g06hits |(counter_id,visitor_id,page_id,referer_page_id,browser_id,display_id,option | | 16 | titan | mail.local | counter | Query | 22857 | Waiting for table | select |sum(lt.hits) as val, st31.g07pages.page as page, st31.g07pages.port as port, |st31.g07pages.qu | | 17 | titan | mail.local | counter | Query | 21685 | Waiting for table | SELECT |visitors FROM layers_st45.g08layers_stat_hits AS lsh, layers | | 21 | titan | mail.local | counter | Query | 21834 | Waiting for table | SELECT |lsh.begin, sh.visitors AS visitors FROM layers_st66.g03layers_stat_hits AS ls | | 57 | root | localhost | counter | Query | 22758 | Waiting for table | SELECT |user_agent_string, user_agent_id FROM st45.g07user_agents WHERE browser_id=20 || | 59 | titan | mail.local | counter | Query | 21883 | Waiting for table | select |lt.id,sum(lt.visitors) as val from layers_st30.g07layers_stat_languages as |l_lt,layers_st30.g | | 80 | titan | ghost.local | | Query | 22627 | Waiting for table | SELECT |HOUR(lsh.begin), sh.visitors AS visitors FROM layers_st30.g07layers_stat_hits | | 122 | titan | mail.local | counter | Query | 21761 | Waiting for table | SELECT |visitors FROM layers_st45.g01layers_stat_hits AS lsh, layers | | 282 | titan | mail.local | counter | Query | 17071 | Waiting for table | SELECT st30.g00hits.visitor_id, st30.g00hits.id AS id,st30.g00hits.ts,hex(st30.g00hits.ip) as ip | | 1490 | root | localhost | | Query | 0 | | show |processlist | | +--+---+-+-+-+---+---+--+ -- ruby:/spylog/layers # tail -1 /spylog/db/ruby.err | grep 45/g06hits 010122 15:20:46 Warning: Checking table: './st45/g06hits' 010122 15:20:46 Warning: Recovering table: './st45/g06hits' mysqladmin debug reports no table locks active I saw this many times on different machines and this sequince never resolves itself ( the locks never disapears). Always the only way to fix this is to kill one of the queries. I killed query #16 and situation momentaly fixed: ruby:/spylog/layers # mysqladmin processlist | grep -v Sleep +--+---++-+-+---++--+ | Id | User | Host | db | Command | Time | State | Info | | | +--+---++-+-+---++--+ | 1| titan | mars.local | counter | Query | 0 | update | INSERT INTO |st45.g06hits |(counter_id,visitor_id,page_id,referer_page_id,browser_id,display_id,option | | 1405 | titan | mail.local | counter | Query | 0 | Checking table | select |lt.id,sum(lt.hits) as val from layers_st66.g09layers_stat_enterpages as |l_lt,layers_st66.g09s | | 1512 | root | localhost | | Query | 0 | statistics | select ip |from st66.g08domip where rt=0 | | | 1515 | root | localhost | | Query | 0 || show |processlist | | +--+---++-+-+---++--+ The log also shows the table was repaired long ago: 010122 15:16:
DbTools question/feature suggestion (EXCEL)
Hi folks I have downloaded DB tools and took a quick look at it and it seemed to me that exporting from excel table can only be done by creating some new table for that purpose in the db. But what do I want to do? I`d like to copy the contents of excel file to an existing table into fields that I will have the chance to set myself. If it isn´t possible right now or even if it was, I have some feature suggestion to the creator of Dbtools: * there should be possibility to tell the program that "I want to the text from the full first row to be written to the mytable col1 and then starting from the row number 5 add column A information to mytable col3 and column B to col4 AND column C to col5" and so on. * And then could be the following feature as well: "Take some substring from some excel column X and write it to the db table to mycol and take another substring from the excel column X and write this to another column in the database table". It would be really great to have these features as well, this would make things much easier. So if possible, I would appreciate it. Or does anyone know of any other free tools that could handle it? Thanks Siim Einfeldt [EMAIL PROTECTED] - 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
MySQL 3.23.32
Hi!
Because of the core-dump bug when getting an Aborted Connecting
when running a mysqld compiled for debugging, we decided to make a
new release almost at once.
This also fixes a timing problem in replication.
Hopefully we don't need to do many more 3.23 releases :)
Changes in release 3.23.32
* Changed code to get around compiler bug in Compaq C++ on OSF1,
that broke `BACKUP, RESTORE, CHECK, REPAIR, and ANALYZE TABLE'.
* Added option `FULL' to `SHOW COLUMNS'. Now we only show the
privilege list for the columns if this option is given.
* Fixed bug in `SHOW LOGS' when there wheren't any BDB logs.
* Fixed a timing problem in replication that could delay sending an
update to the client until a new update was done.
* Don't convert field names when using `mysql_list_fields()'. This
is to keep this code compatible with `SHOW FIELDS'.
* `MERGE' tables didn't work on windows.
* Fixed problem with `SET PASSWORD=...' on windows.
* Added missing `my_config.h' to RPM distribution.
* `TRIM("foo" from "foo")' didn't return an empty string.
* Added `--with-version-suffix' to configure.
* Fixed coredump when client aborted connection without
`mysql_close()'.
* Fixed bug in `RESTORE TABLE' when trying to restore from a
non-existing directory.
* Fixed coredump on the slave replicating `SET PASSWORD'.
* Added `MASTER_POS_WAIT()'.
Regards,
Monty
-
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: mySQL vs Oracle
> "AR" == Ann Ricchiazzi <[EMAIL PROTECTED]> writes: AR> I am trying to choose between mySQL and Oracle for a Linux server. My AR> specific questions are: AR> 1) Will mySQL handle 3000 hits/day well? You need to define what a "hit" is. Is it a simple select on the primary key of a single table or a multi-table join without indexes? How are your "hits" distributed over the duration of the day? Also, how big are you expecting your data tables to be? I'd venture to say that yes, MySQL can handle 3000 queries per day, but it is hard to say without knowing what your load expectations are. AR> 2) Does mySQL handle multi-media file formats? For example, if I want to AR> store audio clips, or Flash movie clips, or PowerPoint presentations, AR> can I do so? MySQL can store binary objects. You probably don't want to do that for these things but instead store a pointer to a URL or filesystem location. The file system access would be much faster than cramming the data down the database socket connection. AR> We make the decision this decision at 3:00 today. Your advice will be AR> most helpful. Luckily you're on the west coast. It is already 3:30 here. ;-) - 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
newbie question on Driver and java
Hello,
I am using MySql in my ISP, this is the first time I downladed the big
guy himself in my machine. It is working fine as stand alone.
My question is , how to use MySql using java programs. I downloaded
RESIN1.1 and copied the JAR file to the following directory
c:\resin1.1\lib and I added c:\resin1.1\lib; to my CLASS_PATH
direcotory. I wrote a test program, I am getting driver not found error.
Can any one help me with this one or any other solution that can help me
use MySql with my java program.
Thanks in advance for the help.
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
res.setContentType("text/html");
PrintWriter out = res.getWriter();
try {
Class.forName("com.caucho.jdbc.mysql.Driver");
con =
DriverManager.getConnection("jdbc:mysql-caucho://localhost:3306/mydb",uid,pwd);
stmt = con.createStatement();
rs = stmt.executeQuery("select * from test");
out.println("Done");
} catch (ClassNotFoundException e) {
out.println("couldn't load database driver: " + e.getMessage());
} catch (SQLException e) {
out.println("SQLException caught: " + e.getMessage());
}
finally {
try {
if(con != null) con.close();
} catch (SQLException ignored){}
}
-
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
Requirements for BDB tables
Hello, I'm new to this list, and apologize as I'm sure this has been covered many times... I'm upgrading from MySQL 3.22.27 to 3.23.31 on Solaris 2.7, and would like to experiment with BDB tables. After reading the 3.23 manual, I'm still unclear whether I need the MySQL source distribution to have BDB support (I think I do). Also, does anyone know if can I use (or build) 3.23.31 with BDB support on Solaris 2.6? Thanks. Chet Singer - 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: ERROR 1040: Too many connections
> >Sometimes something bad happens in a server and it is hard to figure out > >what is going on because we can not get in. I'd like to suggest a change for > >MySQL 4 protocol, such that a connection from localhost can still get > >through even if there are too many connections. > > It is already there - max_connections limit is actually for the user without > process_priv. For the user with process_priv, the limit is max_connections + > 1. The trick is not to connect as root for your regular connections. There must be a problem, then. It happens to me, often, that I cannot obtain a proc or ext with mysqladmin as root. All accesses are through an unpriv username, I have max_connections=1000 and a ps ax | grep mysqld | wc -l gives me a value lower than 1000, so there must be room for one more connection. Filippo - 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: mySQL vs Oracle
Note: As of version 3.2.3gamma Mysql Supports Sub-Selects. .:: Nathan Cook [ [EMAIL PROTECTED] ] ::. Systems & Network Administrator :: Programmer [ phone - 208.343.3110 ][ pager - 208.387.9983 ] - Original Message - From: "Scott Gerhardt" <[EMAIL PROTECTED]> To: "Ann Ricchiazzi" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, January 22, 2001 12:10 PM Subject: RE: mySQL vs Oracle > Hello Ann, > > The answer to you question depends on how you plan to use the database (i.e. > financial trancactions, serving data on the web etc.) as well as financial > considerations. MySQL is free and Oracle is expensive. > > > Here are some questions you should answer: > > 1.) Do you need full Transaction support (commit roll-back)? > 2.) Do you need subselect and union queries? > 3.) Do you need Triggers and Stored Procedures? > 4.) Do you absolutely need Foreign Key support? > > If you anwered YES to any of the above go with Oracle, Sybase, Frontbase, > Openbase etc. otherwise, MySQL is an excellent choice. MySQL is very fast > and probably faster than Oracle in most cases but I have no documented proof > (Oracle doesn't like having their benchmarks published). > > I know this isn't a definite answer and you are on a tight deadline. Hope > this helps just the same. > > > ___ > > Scott A. Gerhardt P.Geo. > Gerhardt Information Technologies > [EMAIL PROTECTED] > ___ > > > > > > > > > > > > I am trying to choose between mySQL and Oracle for a Linux server. My > > specific questions are: > > > > 1) Will mySQL handle 3000 hits/day well? > > 2) Does mySQL handle multi-media file formats? For example, if I want to > > store audio clips, or Flash movie clips, or PowerPoint presentations, > > can I do so? > > > > We make the decision this decision at 3:00 today. Your advice will be > > most helpful. > > Thanks, > > Ann > > > > > > - > > 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 > > - 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: ERROR 1040: Too many connections
On Monday 22 January 2001 11:11, Steven Roussey wrote: >Hi! > >Sometimes something bad happens in a server and it is hard to figure out >what is going on because we can not get in. I'd like to suggest a change for >MySQL 4 protocol, such that a connection from localhost can still get >through even if there are too many connections. It is already there - max_connections limit is actually for the user without process_priv. For the user with process_priv, the limit is max_connections + 1. The trick is not to connect as root for your regular connections. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA <___/ - 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
How do I allow one user to access DB from anywhere
What would I have to do (sql expression) if I want to have a user be able to access database from anywhere (so I don't have to make additions for all the hosts). database=list username=bigpapa password=see5060 What would be the route to do that? Thanx - 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
ERROR 1040: Too many connections
Hi! Sometimes something bad happens in a server and it is hard to figure out what is going on because we can not get in. I'd like to suggest a change for MySQL 4 protocol, such that a connection from localhost can still get through even if there are too many connections. Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e - 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: Win NT/2000 mySQL question
Thanks Jacques & Christopher, you are telling on your site (compliment, really nice work), that your MySQLX-component is quicker then ODBC. Any benchmarking about it ? Also - does your component support ADO-objects ? - specially Recordsets .. or do you have something similar ? How can you access mySQL with Mascon ? Only via this ActiveX or also with ODBC ? Back to Win NT: On the WinNT-Server I only will run mySQL accessing via an ODBC networkconnection. Are there any disadvantages running mySQL on NT, not Linux - Linuxfans keep cool !;) .. I mean just for this kind of application Or - what is recommended ? Running IIS and mySQL on one Server ? Should I know anything else ??? ;) cu, MArc -Ursprüngliche Nachricht- Von: Jacques Venter <[EMAIL PROTECTED]> An: Juergen Haefner <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Datum: Montag, 22. Januar 2001 15:52 Betreff: RE: Win NT/2000 mySQL question >Hi Marc, > >All your questions could be answered at: >http://www.scibit.com/MySQLX > >try the Sample Website > >> Hello, >> >> Hope this list is right for a newbie question. >> >> I would like using mySQL as an ODBC-database on a Win NT Server with MIS, >> >> ... That means, I am having a Website developed with >> ASP/SQL-Server, and I just would like changing the databaseserver >> (SQL-server out, mySQL in ) >> The ASP-clientside SQL-queries are just standard SQL - nothing >> SQL-server specific. >> Also there are a few Visual Basic-SQLclients accessing the >> database. All is working similar as an editorial system. >> >> Cause I didn't work with mySQL till now, I'm having a few questions: >> >> 1. Could it work ? Is it possible running mySQL as an >> ODBC-database ? Are there any tutorials out ? >> 2. If yes - could there be any incompatible probs with the >> ASP-SQLqueries ? >> 3. Any problems with ASP as a Scripting language ? Any probs with >> MIS (Information Server) ? >> 4. Is it possible processing queries multithreaded ? >> 5. Any experiences with Access as a mySQL-client via ODBC for >> databaseadministration ? >> >> >> thanks, >> Marc Hafner >> >> >> >> >> >> >> > >- >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
select HELP from HERE where HELP_NEEDED = TRUE !
hi, i have a web serverrunning redhat linux 7 i installed mysql 3.23.30 two weeks ago and it has begun to cause problems i get a "lost connection during query" every half a minute, basicly my web site is dead i tried instaling the 3.23.32 ( stable you call it! ) and i get the same response i'm in desparate need for help... !!! H E L P ! ! ! 10q amir [EMAIL PROTECTED]
RE: mySQL vs Oracle
Hello Ann, The answer to you question depends on how you plan to use the database (i.e. financial trancactions, serving data on the web etc.) as well as financial considerations. MySQL is free and Oracle is expensive. Here are some questions you should answer: 1.) Do you need full Transaction support (commit roll-back)? 2.) Do you need subselect and union queries? 3.) Do you need Triggers and Stored Procedures? 4.) Do you absolutely need Foreign Key support? If you anwered YES to any of the above go with Oracle, Sybase, Frontbase, Openbase etc. otherwise, MySQL is an excellent choice. MySQL is very fast and probably faster than Oracle in most cases but I have no documented proof (Oracle doesn't like having their benchmarks published). I know this isn't a definite answer and you are on a tight deadline. Hope this helps just the same. ___ Scott A. Gerhardt P.Geo. Gerhardt Information Technologies [EMAIL PROTECTED] ___ > I am trying to choose between mySQL and Oracle for a Linux server. My > specific questions are: > > 1) Will mySQL handle 3000 hits/day well? > 2) Does mySQL handle multi-media file formats? For example, if I want to > store audio clips, or Flash movie clips, or PowerPoint presentations, > can I do so? > > We make the decision this decision at 3:00 today. Your advice will be > most helpful. > Thanks, > Ann > > > - > 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
Re: mySQL vs Oracle
On Mon, 22 Jan 2001 10:49:28 -0800, Ann Ricchiazzi ([EMAIL PROTECTED]) wrote: >Dear mySQL Users, > >I am trying to choose between mySQL and Oracle for a Linux server. My >specific questions are: > >1) Will mySQL handle 3000 hits/day well? I'm on a site that does 90,000 database-heavy pages a day and it's doing great. >2) Does mySQL handle multi-media file formats? For example, if I >want to >store audio clips, or Flash movie clips, or PowerPoint presentations, >can I do so? sure, but it's usually easier to keep them on a filesystem, and just put the filename in the database. - Mark - 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: mySQL vs Oracle
Ann Ricchiazzi wrote: > > Dear mySQL Users, > > I am trying to choose between mySQL and Oracle for a Linux server. My > specific questions are: > > 1) Will mySQL handle 3000 hits/day well? > 2) Does mySQL handle multi-media file formats? For example, if I want to > store audio clips, or Flash movie clips, or PowerPoint presentations, > can I do so? > > We make the decision this decision at 3:00 today. Your advice will be > most helpful. > Thanks, > Ann > 1) is VERY dependant on how many of the hits access the database how many read/write querires.. etc etc.. To answer the question of load you should try to get it down to queries/minute at least.. It also depends on hardware, optimization of queries, etc etc. 2) Yes, you can put anything you want into a mysql database, mysql doesn't know the difference bewteen Falsh and PowerPoint but it doesn't care if you put them in there. - 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
mySQL vs Oracle
Dear mySQL Users, I am trying to choose between mySQL and Oracle for a Linux server. My specific questions are: 1) Will mySQL handle 3000 hits/day well? 2) Does mySQL handle multi-media file formats? For example, if I want to store audio clips, or Flash movie clips, or PowerPoint presentations, can I do so? We make the decision this decision at 3:00 today. Your advice will be most helpful. Thanks, Ann - 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
C API -- using mysql_ping()
If a connection has been closed by the mySQL server, like in a timeout condition, does the API function mysql_ping() awake the connection again if the reconnect flag was set, or will it just return a lost server error? In other words, if I'm testing to see if a long-unused connection is dead before I close it by calling mysql_ping(), am I then forced to call mysql_close() or can I assume the connection is closed and lost and just free up the memory I've used for the connection? If I call mysql_close() on a connection that's already closed, will it just return quietly or will it segfault? - 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: Error in UPDATE syntax?
Don wrote:
>
> Hi,
>
> I'm looking at the docs for the UPDATE syntax right now!
>
> Here is my code (in Perl):
>
> $sqlCmd = $dbh->prepare("UPDATE Ports SET Country = $country,
> TransPort = $transPort,
> Suspended = $suspended,
> Transit = $transit,
> Tranship = $tranship,
> CargoDisp = $disposition
> WHERE PortName = $port");
>
> When I issue an: $sqlCmd->execute() or die "Can't execute statement:
> $DBI::errstr";
>
> I get the following error message:
>
> DBD::mysql::st execute failed: Unknown column 'GERMANY' in 'field list'
> at myprog.pl line 164. Can't execute statement: Unknown column
> 'GERMANY' in 'field list' at myprog.pl
> line 164.
>
> Ports is my table. "GERMANY" is actually the contents of the scaler
> array $country, so why is it giving me an unknown column error?
>
> Thanks,
> Don
>
> -
> 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
Try single quoting the scalar eg ("UPDATE Ports SET Country =
'$country', etc etc")
Stuart
-
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: Unexplained high-loads on FreeBSD
Hi Noor, Here is my my.cnf file, it has almost nothing in it. [mysqld] port=3306 set-variable = max_allowed_packet=1M log-update [mysql.server] user=mysqladm [mysqldump] And Here are some stats for you, it sounds like our servers are very close. I am using DELL 2400's with 2 processors. I do NOT have SMP enabled on FreeBSD yet. Although I have a new test server I am just setting up that does have SMP on it. Nor do I have apache running on the same server. I find the CPU load to be very low. Are you running SMP? Have you modified the GENERIC kernel? There must be something different between our two systems, maybe we could take this discussion private find the answers then just post our results to the list. > mysqladmin -uken -p status Enter password: Uptime: 350099 Threads: 55 Questions: 3161869 Slow queries: 1 Opens: 17814 Flush tables: 1 Open tables: 64 Queries per second avg: 9.031 > PID USERNAME PRI NICE SIZERES STATETIME WCPUCPU COMMAND 11507 sysadm28 0 1880K 1056K RUN 0:00 1.45% 0.73% top 3346 mysqladm 2 0 20884K 16932K poll 130:06 0.00% 0.00% mysqld 117 root 2 -12 1256K 716K select 0:16 0.00% 0.00% ntpd 167 root 2 0 2496K 1240K select 0:02 0.00% 0.00% sendmail 164 root 10 0 952K 560K nanslp 0:01 0.00% 0.00% cron 114 root 2 0 916K 532K select 0:01 0.00% 0.00% syslogd 171 root 2 0 2092K 848K select 0:00 0.00% 0.00% sshd 256 root 3 0 1332K 812K ttyin0:00 0.00% 0.00% csh 11495 sysadm18 0 1328K 808K pause0:00 0.00% 0.00% tcsh 206 root 10 0 632K 232K wait 0:00 0.00% 0.00% sh 11410 sysadm 3 0 1328K 808K ttyin0:00 0.00% 0.00% tcsh 11494 root 2 0 2136K 1316K select 0:00 0.00% 0.00% telnetd 162 root 2 0 1032K 592K select 0:00 0.00% 0.00% inetd 11409 root 2 0 2136K 1316K select 0:00 0.00% 0.00% telnetd - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "Noor Dawod" <[EMAIL PROTECTED]> To: "Ken Menzel" <[EMAIL PROTECTED]>; "Sinisa Milivojevic" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, January 22, 2001 11:49 AM Subject: RE: Unexplained high-loads on FreeBSD > Hi Ken, > > After making the world last week, I've updated sources for Apache, > MySQL, PHP and mod_ssl. Afterwards, recompiled all of them, stopped > previous instances, installed them again and then started all of them. > So yes, I did recompile MySQL. > > Regarding the conservative configuration settings, this is as you said > the default values. Our server has between 5-20 queries per second > (almost quiet at night), so our servers are almost alike. What do you > suggest for the values of the variables in my.cnf? > > TIA > > Noor > > -Original Message- > From: Ken Menzel [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 22, 2001 6:09 PM > To: Sinisa Milivojevic; [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: Unexplained high-loads on FreeBSD > > > Hi Sinisa and everyone, > I have a question for Noor, after updating freeBSD-stable last > week, I assume you did a "make world", but did did you recomiple > MySQL under that update? The compiler itself was broken on the older > FreeBSD and was not fixed till the 12th of Jan (except by patches on > the mailing list!). Also my setting with memory and such are VERY > conservative. We are mostly using the MySQL defaults. I will be > increasing this soon. Our current servers run about 9 queries per > second. (They are quiet at night). > Solaris threads may be an excellent OS, however it is too expensive > for our market. I have found FreeBSD groups to be very responsive to > threads issues, with patches being issued as soon as a repeatable > test case is identified. > All of this does not mean that there may not also be a problem with > MySQL, that would be common to all platforms, however in my > experience, most of these sorts of issues were threads related. > Hope this helps. Ken > - > Ken Menzel ICQ# 9325188 > www.icarz.com [EMAIL PROTECTED] > - Original Message - > From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Monday, January 22, 2001 9:25 AM > Subject: RE: Unexplained high-loads on FreeBSD > > > > Noor Dawod writes: > > > Hi Sinisa > > > > > > Is the FreeBSD problem previously submitted by me known to you? > > > > > > Noor > > > > > > Ken Manzel has submitted many valuable messages to this mailing list > > concerning many important patches for FreeBSD 4.* threads. > > > > He has even provided names of files and dates when they were > released. > > > > > > > > Regards, > > > > Sinisa > > > > __ _
RE: Full-Text Query
Change your second query to:
SELECT COUNT(*) FROM newsStories WHERE MATCH summary AGAINST
(LCASE('news'));
Unfortunately this will be a little slow when you have a few million
records. I have tried in the past to look for solutions to getting the
number of matches in a more efficient way than doing a count(*) but haven't
gotten any responses.
--Paul
-Original Message-
From: Oson, Chris M. [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 22, 2001 8:46 AM
To: [EMAIL PROTECTED]
Subject: Full-Text Query
Good Day All,
This will work...
mysql> SELECT storyID, title, summary, MATCH summary AGAINST (LCASE('news'))
AS probability
-> FROM newsStories WHERE MATCH summary AGAINST (LCASE('news')) > 0
LIMIT 0, 5;
But this will not...
mysql> SELECT COUNT(*), MATCH summary AGAINST (LCASE('news')) AS probability
-> FROM newsStories WHERE MATCH summary AGAINST (LCASE('news')) > 0;
ERROR 1140: Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP
columns is illegal if there is no GROUP BY clause
I have two questions;
1)
What I'm trying to do is get a number of records that will match this
criteria. Has anyone
run into this same problem before?
2)
It seems that full-text searches only work on whole words. Is this correct.
For example, if summary = "The Blackhawks won 5-4 in a wild hockey game",
then the following query didn't return anything...
mysql> SELECT storyID, title, summary, MATCH summary AGAINST
(LCASE('hawks')) AS probability
-> FROM newsStories WHERE MATCH summary AGAINST (LCASE('hawks')) > 0
LIMIT 0, 5;
Maybe if I tried regular expressions??
Cheers,
Chris Oson
-
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
Error in UPDATE syntax?
Hi,
I'm looking at the docs for the UPDATE syntax right now!
Here is my code (in Perl):
$sqlCmd = $dbh->prepare("UPDATE Ports SET Country = $country,
TransPort = $transPort,
Suspended = $suspended,
Transit = $transit,
Tranship = $tranship,
CargoDisp = $disposition
WHERE PortName = $port");
When I issue an: $sqlCmd->execute() or die "Can't execute statement:
$DBI::errstr";
I get the following error message:
DBD::mysql::st execute failed: Unknown column 'GERMANY' in 'field list'
at myprog.pl line 164. Can't execute statement: Unknown column
'GERMANY' in 'field list' at myprog.pl
line 164.
Ports is my table. "GERMANY" is actually the contents of the scaler
array $country, so why is it giving me an unknown column error?
Thanks,
Don
-
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
Mysql and Lotus
Hi, Thought I'd try sending the message again, maybe you all missed the first time. I am using Mysql version 3.22.32 and MyODBC version 2.50.3300 to connect to a Lotus Approach 97 front-end. I have been having some problems with boolean values. Is there anybody out there that has used Mysql with Lotus Approach, you may be able to offer me some help. Regards --- Faizal Mangera Systems Department CarnaudMetalbox Engineering Shipley West Yorkshire BD17 7AY Tel: 01274 846386 Fax: 01274 846201 [EMAIL PROTECTED] CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the confidential use of the above named recipient. If you are not the intended recipient or person responsible for delivering it to the intended recipient, you have received this communication in error and must not distribute or copy it. Please accept the sender's apologies, notify the sender immediately by return e-mail and delete this communication. Thank you. - 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
Full-Text Query
Good Day All,
This will work...
mysql> SELECT storyID, title, summary, MATCH summary AGAINST (LCASE('news'))
AS probability
-> FROM newsStories WHERE MATCH summary AGAINST (LCASE('news')) > 0
LIMIT 0, 5;
But this will not...
mysql> SELECT COUNT(*), MATCH summary AGAINST (LCASE('news')) AS probability
-> FROM newsStories WHERE MATCH summary AGAINST (LCASE('news')) > 0;
ERROR 1140: Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP
columns is illegal if there is no GROUP BY clause
I have two questions;
1)
What I'm trying to do is get a number of records that will match this
criteria. Has anyone
run into this same problem before?
2)
It seems that full-text searches only work on whole words. Is this correct.
For example, if summary = "The Blackhawks won 5-4 in a wild hockey game",
then the following query didn't return anything...
mysql> SELECT storyID, title, summary, MATCH summary AGAINST
(LCASE('hawks')) AS probability
-> FROM newsStories WHERE MATCH summary AGAINST (LCASE('hawks')) > 0
LIMIT 0, 5;
Maybe if I tried regular expressions??
Cheers,
Chris Oson
-
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: Unexplained high-loads on FreeBSD
Hi Ken, After making the world last week, I've updated sources for Apache, MySQL, PHP and mod_ssl. Afterwards, recompiled all of them, stopped previous instances, installed them again and then started all of them. So yes, I did recompile MySQL. Regarding the conservative configuration settings, this is as you said the default values. Our server has between 5-20 queries per second (almost quiet at night), so our servers are almost alike. What do you suggest for the values of the variables in my.cnf? TIA Noor -Original Message- From: Ken Menzel [mailto:[EMAIL PROTECTED]] Sent: Monday, January 22, 2001 6:09 PM To: Sinisa Milivojevic; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Unexplained high-loads on FreeBSD Hi Sinisa and everyone, I have a question for Noor, after updating freeBSD-stable last week, I assume you did a "make world", but did did you recomiple MySQL under that update? The compiler itself was broken on the older FreeBSD and was not fixed till the 12th of Jan (except by patches on the mailing list!). Also my setting with memory and such are VERY conservative. We are mostly using the MySQL defaults. I will be increasing this soon. Our current servers run about 9 queries per second. (They are quiet at night). Solaris threads may be an excellent OS, however it is too expensive for our market. I have found FreeBSD groups to be very responsive to threads issues, with patches being issued as soon as a repeatable test case is identified. All of this does not mean that there may not also be a problem with MySQL, that would be common to all platforms, however in my experience, most of these sorts of issues were threads related. Hope this helps. Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, January 22, 2001 9:25 AM Subject: RE: Unexplained high-loads on FreeBSD > Noor Dawod writes: > > Hi Sinisa > > > > Is the FreeBSD problem previously submitted by me known to you? > > > > Noor > > > Ken Manzel has submitted many valuable messages to this mailing list > concerning many important patches for FreeBSD 4.* threads. > > He has even provided names of files and dates when they were released. > > > > Regards, > > Sinisa > > __ _ _ ___ == MySQL AB > /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic > /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] >/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus > /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| > /*/^^^\*\^^^ > /*/ \*\Developers Team > > - > 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
Re: INSTALLATION QUESTION on Cobalt Raq3
> "l" == lkeeton <[EMAIL PROTECTED]> writes: l> First does anybody know the website address for that searchable l> site that allows you to search on mysql archive emails. I would l> appreciate if I could get that. I also am looking for opinions on Does anyone read the footers on the messages they get from the mailing list or are they just wasting electrons on my box? - 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
Installation Question on MySql and Cobalt Raq3
First does anybody know the website address for that searchable site that allows you to search on mysql archive emails. I would appreciate if I could get that. I also am looking for opinions on the installation of MySql on the Cobalt Raq3. I am really interested in installing the RPM's for that machine. I really don't want to do a manual installation. I want the installation to be smooth and easy without manual configurations. Has anybody had any good experiences with MySql RPM version on the Cobalt Raq3 - 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
INSTALLATION QUESTION on Cobalt Raq3
First does anybody know the website address for that searchable site that allows you to search on mysql archive emails. I would appreciate if I could get that. I also am looking for opinions on the installation of MySql on the Cobalt Raq3. I am really interested in installing the RPM's for that machine. I really don't want to do a manual installation. I want the installation to be smooth and easy without manual configurations. Has anybody had any good experiences with MySql RPM version on the Cobalt Raq3 - 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: Veeery slow.
At 2:15 PM +0100 1/22/01, Torkil Grindstein wrote: >Hi. > >I'm running a mysql database, to which queries seem to take way >too much time. The database contains just two tables, each with >approx 10.000 rows. Simple select() calls to these can take more >than a minute. Can this be right? Can you post some examples of your queries, along with EXPLAIN SELECT output? It's hard to give much more information based upon this post, but one possibility is that you have no keys - or no useable keys - on those tables. See http://www.mysql.com/doc/E/X/EXPLAIN.html Also, you might find some more info in the list archives; try a search for 'slow queries' or 'slow query' at http://lists.mysql.com/php/search.php or http://marc.theaimsgroup.com/?l=mysql&r=1&w=2 > >My platform is a RedHat 6.1, running MySQL-3.22.32-1. > >Should I upgrade to RH 7.0 and MySQL-3.23-32? >-- >Torkil Grindstein Mail: [EMAIL PROTECTED] >System Architect Web: http://www.fast.no >Fast Search & Transfer ASAPhone: +47 21 60 11 90 >Grønnegata 80, Pb 571 Fax: +47 77 69 66 89 >NO-9261 Tromsø, NORWAYMob: +47 98 06 61 38 > >Try FAST Search: http://www.alltheweb.com > - steve edberg -- +--- "They've got a cherry pie there, that'll kill ya" --+ | Steve Edberg University of California, Davis | | [EMAIL PROTECTED] Computer Consultant | | http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ | +-- FBI Special Agent Dale Cooper ---+ - 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: PHP and MySQL in red hat 7.0
I tried RedHat, but had the same problem getting apache and php and mysql to talk to each other. I decided to try Mandrake 7.2 and it did all the work for me. Murdmath - Original Message - From: "Luis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, January 22, 2001 7:55 AM Subject: Re: PHP and MySQL in red hat 7.0 > [EMAIL PROTECTED] wrote: > > > > Thanks Matt. > > MySQL is finally working. > > But the problem now is that PHP is not recognizing its MySQL > > functions. The error I am getting is: > > > > Fatal error: Call to undefined function: mysql_pconnect() in > > /var/www/html/Willy/MySQL/test1.php on line 28 > > > > Well, the php_mysql RPM has been installed along with mod_php4.rpm. > > PHP can recognize its own functions but not those of MySQL. I checked > > for the RPMs to be installed and I have installed all the php RPMs > > ( including php-mysql RPM). despite doing all that I get this error. MySQL > > is running perfect as I get the status when I type "mysqladmin -u=root > > status". > > Please help me. This is very urgent for me. > > > > Thank You. > > Willy > > > > > -- > > > From: Matt Wagner[SMTP:[EMAIL PROTECTED]] > > > Sent: Friday, January 19, 2001 4:29 PM > > > To: [EMAIL PROTECTED] > > > Cc: [EMAIL PROTECTED] > > > Subject: Re: socket problem in red hat. > > > > > > [EMAIL PROTECTED] writes: > > > > Hi there, > > > > I am setting up a lab on MySQL and I am not able to. > > > > Its a red hat 7.0 server and has PHP installed and working with apache. > > > > I installed MySQL from the very RPMs Red Hat provided. > > > > Whenever I try to start the server, I get the error message: > > > > > > > > Can't connect to local MySQL server through socket '/var/lib/mysql/m > > > > ysql.sock' (111) > > > > > > > > Well the file /var/lib/mysql/mysql.sock exists on the computer. I can't > > > > understand what this socket problem is and I went through all > > > documentation > > > > and couldn't find a solution to this. Can you please provide a solution > > > to > > > > this > > > > at the earliest. I have students piling on my head and I have already > > > > skipped my deadline of setting the server up. > > > > > > Hi! > > > > > > We have seen this problem (although I have not personally > > > investigated) with many RH7+default_mysql. The quick and easy solution > > > (until I figure out further) is to download the MySQL RPMs from: > > > > > > http://www.mysql.com/downloads/mysql-3.23.html > > > > > > Uninstall the standard RedHat 7.0 MySQL RPMs, then reinstall > > > ours. Like I said, I'm not sure what RedHat is doing wrong with their > > > MySQL RPMs... But I have seen this numerous times with regard to their > > > supplied RPMs. Something is amiss. > > > > > > I will investigate more. > > > > > > > > > Regards, > > > > > > Matt > > > > > > -- > > >__ ___ ___ __ > > > / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> > > > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ > > > /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA > > ><___/ Developer > > > > > > > - > > 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 > > > > I had the same problem with setting up php , > mysql, and apache. I also notice that the rpm that > redhat cd come with does not work . You have to > download the tar or the rpm from the site. If you > dont mind me asking, how did you set up the apache > server to work with php plus if you find any doc > on setting up php and mysql let me know. > > > Thank you . > > > Luis > > - > 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
Re: How do I know if a record exsist?
Don wrote:
>
> Hi,
>
> I'm using Perl to maintain a database. I'd like to search for a record
> in a database and if it does not exist, add it. Otherwise, just update
> the fields. In my script, I have:
>
> $sqlCmd = $dbh->prepare("SELECT PortName FROM Ports where PortName =
> '$port' ");
> $sqlCmd->execute();
$rc = $sqlCmd->execute().
$rc is the return code.
>
> Where '$port' is a scaler variable.
> If the record exists, I suppose I can do an INSERT. If not, I'll do an
> UPDATE. I can't seem to find the code/function to check for this simple
> test.
>
> Thanks,
> Don
>
-
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
announcement: mssql2mysql database converter
mssql2mysql converts Microsoft SQL Server databases to MySQL mssql2mysql is VB/VBA code (you need VB6 or a VBA6 capable program such as Excel 2000 or Word 2000 to run it) mssql2mysql is free (GPL) for more informations see: http://www.kofler.cc/mysql/ Michael Kofler - 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: Unexplained high-loads on FreeBSD
Hi Sinisa and everyone, I have a question for Noor, after updating freeBSD-stable last week, I assume you did a "make world", but did did you recomiple MySQL under that update? The compiler itself was broken on the older FreeBSD and was not fixed till the 12th of Jan (except by patches on the mailing list!). Also my setting with memory and such are VERY conservative. We are mostly using the MySQL defaults. I will be increasing this soon. Our current servers run about 9 queries per second. (They are quiet at night). Solaris threads may be an excellent OS, however it is too expensive for our market. I have found FreeBSD groups to be very responsive to threads issues, with patches being issued as soon as a repeatable test case is identified. All of this does not mean that there may not also be a problem with MySQL, that would be common to all platforms, however in my experience, most of these sorts of issues were threads related. Hope this helps. Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, January 22, 2001 9:25 AM Subject: RE: Unexplained high-loads on FreeBSD > Noor Dawod writes: > > Hi Sinisa > > > > Is the FreeBSD problem previously submitted by me known to you? > > > > Noor > > > Ken Manzel has submitted many valuable messages to this mailing list > concerning many important patches for FreeBSD 4.* threads. > > He has even provided names of files and dates when they were released. > > > > Regards, > > Sinisa > > __ _ _ ___ == MySQL AB > /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic > /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] >/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus > /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| > /*/^^^\*\^^^ > /*/ \*\Developers Team > > - > 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
RE: Win NT/2000 mySQL question
Hi Marc, All your questions could be answered at: http://www.scibit.com/MySQLX try the Sample Website > Hello, > > Hope this list is right for a newbie question. > > I would like using mySQL as an ODBC-database on a Win NT Server with MIS, > > ... That means, I am having a Website developed with > ASP/SQL-Server, and I just would like changing the databaseserver > (SQL-server out, mySQL in ) > The ASP-clientside SQL-queries are just standard SQL - nothing > SQL-server specific. > Also there are a few Visual Basic-SQLclients accessing the > database. All is working similar as an editorial system. > > Cause I didn't work with mySQL till now, I'm having a few questions: > > 1. Could it work ? Is it possible running mySQL as an > ODBC-database ? Are there any tutorials out ? > 2. If yes - could there be any incompatible probs with the > ASP-SQLqueries ? > 3. Any problems with ASP as a Scripting language ? Any probs with > MIS (Information Server) ? > 4. Is it possible processing queries multithreaded ? > 5. Any experiences with Access as a mySQL-client via ODBC for > databaseadministration ? > > > thanks, > Marc Hafner > > > > > > > - 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
How do I know if a record exsist?
Hi,
I'm using Perl to maintain a database. I'd like to search for a record
in a database and if it does not exist, add it. Otherwise, just update
the fields. In my script, I have:
$sqlCmd = $dbh->prepare("SELECT PortName FROM Ports where PortName =
'$port' ");
$sqlCmd->execute();
Where '$port' is a scaler variable.
If the record exists, I suppose I can do an INSERT. If not, I'll do an
UPDATE. I can't seem to find the code/function to check for this simple
test.
Thanks,
Don
-
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: Access denied ... /mysql.sock Problem
Laurie Savage wrote: > > I am unable to connect to MySQL either as root or user unless I issue a > "mysqld --socket=/var/lib/mysql/mysql.sock - u root" command. This is good > for all users as long as the machine is booted. > > I have checked Ksysv and mysql is enabled at startup. > > I have copied/renamed the myxxx.conf files into /etc and ~user directories > and edited them to contain a pointer to the sock file. I have also edited the > mysql startup script to contain the line > > "socket=/var/lib/mysql/mysql.sock" > > No luck, what am I missing here? It is /etc/my.cnf not myxxx.conf. if your socket is in /var/lib/mysql, then /var/lib/mysql needs to have permissions set to 775. I put my socket elsewhere ( NOT in /tmp ). - 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: Unexplained high-loads on FreeBSD
Herald van der Breggen writes:
> Sinisa Milivojevic wrote:
>
>
> Do you know whether the problem is related to glibc 2.1, or to the 2.2
> kernel or to both ?
>
> With other words : do I really need the 2.4 kernel, which will be al lot
> of work, since a lot has changed (firewalling for example !).
>
> Herald
>
>
It seems that both kernel and glibc have some problems with threads,
but ONLY with SMP under very high load.
I have followed some reports on the kernel list, and I can only hope
that those SMP problems are now resolved fully.
But the way to go is to try upgrading (when 2.2 is available) on a
spare machine.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
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: PHP and MySQL in red hat 7.0
[EMAIL PROTECTED] wrote: > > Thanks Matt. > MySQL is finally working. > But the problem now is that PHP is not recognizing its MySQL > functions. The error I am getting is: > > Fatal error: Call to undefined function: mysql_pconnect() in > /var/www/html/Willy/MySQL/test1.php on line 28 > > Well, the php_mysql RPM has been installed along with mod_php4.rpm. > PHP can recognize its own functions but not those of MySQL. I checked > for the RPMs to be installed and I have installed all the php RPMs > ( including php-mysql RPM). despite doing all that I get this error. MySQL > is running perfect as I get the status when I type "mysqladmin -u=root > status". > Please help me. This is very urgent for me. > > Thank You. > Willy > > > -- > > From: Matt Wagner[SMTP:[EMAIL PROTECTED]] > > Sent: Friday, January 19, 2001 4:29 PM > > To: [EMAIL PROTECTED] > > Cc: [EMAIL PROTECTED] > > Subject: Re: socket problem in red hat. > > > > [EMAIL PROTECTED] writes: > > > Hi there, > > > I am setting up a lab on MySQL and I am not able to. > > > Its a red hat 7.0 server and has PHP installed and working with apache. > > > I installed MySQL from the very RPMs Red Hat provided. > > > Whenever I try to start the server, I get the error message: > > > > > > Can't connect to local MySQL server through socket '/var/lib/mysql/m > > > ysql.sock' (111) > > > > > > Well the file /var/lib/mysql/mysql.sock exists on the computer. I can't > > > understand what this socket problem is and I went through all > > documentation > > > and couldn't find a solution to this. Can you please provide a solution > > to > > > this > > > at the earliest. I have students piling on my head and I have already > > > skipped my deadline of setting the server up. > > > > Hi! > > > > We have seen this problem (although I have not personally > > investigated) with many RH7+default_mysql. The quick and easy solution > > (until I figure out further) is to download the MySQL RPMs from: > > > > http://www.mysql.com/downloads/mysql-3.23.html > > > > Uninstall the standard RedHat 7.0 MySQL RPMs, then reinstall > > ours. Like I said, I'm not sure what RedHat is doing wrong with their > > MySQL RPMs... But I have seen this numerous times with regard to their > > supplied RPMs. Something is amiss. > > > > I will investigate more. > > > > > > Regards, > > > > Matt > > > > -- > >__ ___ ___ __ > > / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> > > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ > > /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA > ><___/ Developer > > > > - > 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 I had the same problem with setting up php , mysql, and apache. I also notice that the rpm that redhat cd come with does not work . You have to download the tar or the rpm from the site. If you dont mind me asking, how did you set up the apache server to work with php plus if you find any doc on setting up php and mysql let me know. Thank you . Luis - 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: MySQL constantly crash on BLOB insertions...
hi Tim, thanks for the prompt response which is hard to be seen with Oracle and Microsoft. sorry, i should have had studied hard the manual a year ago. regarding the error, however, would the error message be better to tell users to adjust relevant configuration than only to say "MySQL gone away"? it's misleading to some serious fault in MySQL which actually is not therein, isn't it? thanks anyway. peter - Original Message - From: Thimble Smith <[EMAIL PROTECTED]> To: Huang-Ming <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, January 22, 2001 7:04 PM Subject: Re: MySQL constantly crash on BLOB insertions... > On Mon, Jan 22, 2001 at 12:33:46PM +0200, Thimble Smith wrote: > > I can repeat this problem; I'm looking into it and we'll hopefully > > have a patch for it shortly. > > Well, the problem is simply that max_allowed_packet needs to > be increased. Check the manual entry. > > http://mysql.tonnikala.org/doc/S/H/SHOW_VARIABLES.html > > Tim > > -- >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Tim Smith <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Development Team > /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland (for a few weeks) ><___/ www.mysql.com >
Re: Unexplained high-loads on FreeBSD
Sinisa Milivojevic wrote: > > > Hi! > > The above is an already reported problem that occurs only on SMP Linux > on the high load. > > A solution is to try kernel 2.4, glibc 2.2 (when stable) and to build > properly MySQL on that setup. > > > Regards, > > Sinisa Do you know whether the problem is related to glibc 2.1, or to the 2.2 kernel or to both ? With other words : do I really need the 2.4 kernel, which will be al lot of work, since a lot has changed (firewalling for example !). Herald - 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
Win NT/2000 mySQL question
Hello, Hope this list is right for a newbie question. I would like using mySQL as an ODBC-database on a Win NT Server with MIS, ... That means, I am having a Website developed with ASP/SQL-Server, and I just would like changing the databaseserver (SQL-server out, mySQL in ) The ASP-clientside SQL-queries are just standard SQL - nothing SQL-server specific. Also there are a few Visual Basic-SQLclients accessing the database. All is working similar as an editorial system. Cause I didn't work with mySQL till now, I'm having a few questions: 1. Could it work ? Is it possible running mySQL as an ODBC-database ? Are there any tutorials out ? 2. If yes - could there be any incompatible probs with the ASP-SQLqueries ? 3. Any problems with ASP as a Scripting language ? Any probs with MIS (Information Server) ? 4. Is it possible processing queries multithreaded ? 5. Any experiences with Access as a mySQL-client via ODBC for databaseadministration ? thanks, Marc Hafner
RE: Unexplained high-loads on FreeBSD
Noor Dawod writes:
> Hi Sinisa
>
> Is the FreeBSD problem previously submitted by me known to you?
>
> Noor
Ken Manzel has submitted many valuable messages to this mailing list
concerning many important patches for FreeBSD 4.* threads.
He has even provided names of files and dates when they were released.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
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: Unexplained high-loads on FreeBSD
Herald van der Breggen writes:
> Does a downgrade to MySQL 3.22.x help ? (seems less work to me, but I'l
> investigate the other possibilities anyway).
>
>
No, downgrading would not be beneficial to you !
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
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
Using Mysql.pm with a different port
Hello, we're using mysql.pm to connect to mysql from perl. After installing a second Mysql-Server we need to connect to the new installation using another port. Unfortunately we did not find out how to do this up to now. Setting mysql_tcp_port or mysql_unix_port in the perl-script doesn't work. Trying to set the port for the DBI-Connect in Mysql.pm failed too. We can't use DBI instead of mysql.pm cause we're using the mysql.pm- Query subroutine in almost every script (>100). Greetings from Germany Lutz Maibach
Patch for build problems on Alpha!
Hello Here is something from the Debian bug tracking system for you. If fixes the compilation problems on Alpha architecture. bye, -christian- -- codito ergo sum - I code, therefore I am! On Sun 21 Jan 2001, Cristian Ionescu-Idbohrn wrote: > downloaded 3.23.31. Builds just fine on i386, but sadly, fails on alpha > (potato, Linux 2.2.13, gcc version 2.95.2 2220). > ha_berkeley.cc:250: passing `void * (*)(unsigned int)' > as argument 4 of > `log_archive(DB_ENV *, char ***, unsigned int, void * (*)(long > unsigned int))' Typical, people assuming that sizeof(long) == sizeof(int). On alpha: 8 != 4 ... Adding a cast for arg 4 should help. Oh wait, I see now that there *is* a cast, and it's an explicit cast to unsigned int, whereas the prototype for the function declares size_t. Hence changing the "unsigned int" to "size_t" in ha_berkeley.cc (at two places) should fix it. What are some people thinking when they add casts... I've seen many cases where simply removing the damn cast does the right thing in all cases, I wouldn't be surprised if that's the case here too. Anyway, with the fix above it compiles fine; uploading now. Paul Slootman -- home: [EMAIL PROTECTED] http://www.wurtel.demon.nl/ work: [EMAIL PROTECTED] http://www.murphy.nl/ debian: [EMAIL PROTECTED] http://www.debian.org/ isdn4linux: [EMAIL PROTECTED] http://www.isdn4linux.org/ - 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: MySQL on Netware - Again!
I have replied to this before and you would have found it in the archives too. Novell lacks a thread library! If you can port a thread library or write your own, you maybe able to get it to work. The thread library is the key to making MySQL work. If you have that, you are 95% there! -- Richard Ellerbrock [EMAIL PROTECTED] >>> Diego Deboni Rossetto <[EMAIL PROTECTED]> 2001/01/22 03:23:19 >>> Hello Folks! Again someone is asking for MySQL on Netware. Sorry if you guys are tired of this... but Netware is all over... I ve checked the list archives, found some threads about this topic. Developers seem to be disapointed with lack of support from Novell, dev tools, etc. We have a couple of test servers running MySQL on FreeBSD and Linux - just fine - as you guess. But in some places, running on Netware would be just better. We are now starting a small "project" to see how far we go with Netware + Apache + MySQL + PHP . We have some tools (CodeWarrior), some time, some test machines. And I dont think Novell Dev Support is that bad. I would appreciate if someone could exchange some info related to this - someone ever tried? Thanks, Diego D. Diego Deboni Rossetto - [EMAIL PROTECTED] MCNE Intranet / Internet Qualityware Info Ltda R. Cons. Laurindo, 825 cj 412 80060-100 Curitiba - PR Brasil 55-41-232-112 - 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
a bug? regarding udf functions and SubString_Index()
Hi
Let's look at this:
# select SubString_Index("10.0.0.0/24","/",1);
10.0.0.0
# select ewu_aton("10.0.0.0");
167772160
# select ewu_aton( SubString_Index("10.0.0.0/24","/",1) );
280239936
Why this? My self written ewu_aton seems to work korrectly when calling
it with any normal argument. The ewu_aton code is (as I don't suspect any
bugs in 3.23.31 :-)):
long long ewu_aton(UDF_INIT *initid, UDF_ARGS *args, char *is_null, char *error) {
struct in_addrin;
inet_aton(((char*) args->args[0]), &in);
*is_null=0;
return htonl(in.s_addr);
}
TIA and bye,
-christian-
--
Save the forests, eat more beavers!
-
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: Replication with three servers - How to do this ?
Amiph wrote: > > Hi ! > > Ok. I've made correctly replication with two servers in a two-way replication. Both >servers are master/slave. But I would like to know if is it possible to make three >servers to replicate and receive the updates from each others like this: > > a sends updates to b and c > a receives updates from b and c > > b sends updates to a and c > b receives updates from a and c > > c sends updates to a and b > c receives updates from a and b > > Anyone have got an idea ? > I've got another question. How to use the log made with --log-slave-updates to >transmit updates in another database ? > > Thanks > Jimmy Aside from the fact that the replication is not really supposed to be two-way, doing it the way you suggest would set up two counter-rotating replication whirlwinds. Set up a bidirectional from a to b, and another from a to c. Updates to c will go to a, and out to b. Updates on b will go to a, and out to c. Updates on a will go to both b and c. It is not ballanced. so recovery after a hardware failure will be more difficult. - 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: Help with Dates
Yes, mysql can do date arithmetic. Read up on date_add and date_sub functions in the manual. -- Richard Ellerbrock [EMAIL PROTECTED] >>> Mike Podlesny <[EMAIL PROTECTED]> 2001/01/22 03:01:10 >>> I have a script that saves a date in to a mySQL database. The date I want to be saved is 14 days from the current date. So for example today's date is January 22, 2001, the date I want saved is February 5, 2001. However when I add 14 days onto the day part part of the day I get January 36, 2001 and the mySQL database allows that to be saved!! Not very efficient. Anyhow how can I correct the problem above without going into and extensive programming to check the month, the number of days in the month etc., other programming langauges do the date check internally, does either mySQL or Perl do it in anyway? Thanks, Mike - 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
RE: Unexplained high-loads on FreeBSD
Hi Sinisa
Is the FreeBSD problem previously submitted by me known to you?
Noor
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 22, 2001 3:32 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Unexplained high-loads on FreeBSD
Herald van der Breggen writes:
> Hello Noor,
>
> I am struggling with a similar problem on a linux based system. It's
a
> Netfinity 4500R, dual pentium, RAID-5 with a rather new ServeRaid-4L
> scsi controler.
>
> On certain moments, mostly in the peak hours, mysql suddenly behaves
> weird and the load increases very very quick. The swap used is also
> increasing very quick (was that also the case on your system ?).
>
> We use mysql in combination with Apache::Session which uses GET_LOCK.
We
> saw that no lock could be obtained, which could be the cause for an
> increase og threads being used.
>
> At the moment the wevserver and mysql server are restarted
automically
> when the number of threads is higher than 60 (by a cron job), which
is a
> clumbsy solution of course
>
> I have seen this problem with 3.23.29-beta, 3.23.30-gamma and
3.23.31.
> I consider downgrading to 3.22.x :-/
>
>
> Herald
>
>
Hi!
The above is an already reported problem that occurs only on SMP Linux
on the high load.
A solution is to try kernel 2.4, glibc 2.2 (when stable) and to build
properly MySQL on that setup.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
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
Re: A report generator MySQL
> I am writing a database to store student academic records at my local > high school. I wish to generate attractively published reports home to > parents. > > Does anybody know of a method or product that will produce elegantly > formatted reports from MySQL? StarOffice can create reports from MySQL databases and it's free. Adam Stein -- Adam Stein @ Xerox Corporation Email: [EMAIL PROTECTED] Disclaimer: All views expressed here have been proved to be my own. [http://www.csh.rit.edu/~adam/] - 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: Unexplained high-loads on FreeBSD
Does a downgrade to MySQL 3.22.x help ? (seems less work to me, but I'l investigate the other possibilities anyway). Sinisa Milivojevic wrote: > Herald van der Breggen writes: > > Hello Noor, > > > > I am struggling with a similar problem on a linux based system. It's a > > Netfinity 4500R, dual pentium, RAID-5 with a rather new ServeRaid-4L > > scsi controler. > > > > On certain moments, mostly in the peak hours, mysql suddenly behaves > > weird and the load increases very very quick. The swap used is also > > increasing very quick (was that also the case on your system ?). > > > > We use mysql in combination with Apache::Session which uses GET_LOCK. We > > saw that no lock could be obtained, which could be the cause for an > > increase og threads being used. > > > > At the moment the wevserver and mysql server are restarted automically > > when the number of threads is higher than 60 (by a cron job), which is a > > clumbsy solution of course > > > > I have seen this problem with 3.23.29-beta, 3.23.30-gamma and 3.23.31. > > I consider downgrading to 3.22.x :-/ > > > > > > Herald > > > > > > > Hi! > > The above is an already reported problem that occurs only on SMP Linux > on the high load. > > A solution is to try kernel 2.4, glibc 2.2 (when stable) and to build > properly MySQL on that setup. > > > Regards, > > Sinisa > > __ _ _ ___ == MySQL AB > /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic > /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] >/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus > /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| > /*/^^^\*\^^^ > /*/ \*\Developers Team > > - 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: Unexplained high-loads on FreeBSD
Herald van der Breggen writes:
> Hello Noor,
>
> I am struggling with a similar problem on a linux based system. It's a
> Netfinity 4500R, dual pentium, RAID-5 with a rather new ServeRaid-4L
> scsi controler.
>
> On certain moments, mostly in the peak hours, mysql suddenly behaves
> weird and the load increases very very quick. The swap used is also
> increasing very quick (was that also the case on your system ?).
>
> We use mysql in combination with Apache::Session which uses GET_LOCK. We
> saw that no lock could be obtained, which could be the cause for an
> increase og threads being used.
>
> At the moment the wevserver and mysql server are restarted automically
> when the number of threads is higher than 60 (by a cron job), which is a
> clumbsy solution of course
>
> I have seen this problem with 3.23.29-beta, 3.23.30-gamma and 3.23.31.
> I consider downgrading to 3.22.x :-/
>
>
> Herald
>
>
Hi!
The above is an already reported problem that occurs only on SMP Linux
on the high load.
A solution is to try kernel 2.4, glibc 2.2 (when stable) and to build
properly MySQL on that setup.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
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: order by ( bug or undocumented feature )
Mark Papadakis writes:
> Hi all,
>
> I was wondering what's wrong with a query like this:
>
> select itemlist , sum(field1), count(*) as cnt from table where where conditions
>group by id having cnt=2 order by field_x, field_y desc limit 10
>
> I am expecting to get the requested rows order by field_x. Those with same value (
>as in field_x=5 ) should be additionaly ordered by field_y. So for example I 'd get:
>
> field_x, field_y
> 52
> 52
> 51
> 50
> 45
> 38
>
> and so on.
>
> Am I missing the point of order by here? If so, what is the best way/fastest way to
>achieve the required results set?
>
> Please, reply directly to me ( [EMAIL PROTECTED] ) if possible.
>
> Thank you,
>
>
>
>
> Mark Papadakis
> R&D Director - Web Division
> Phaistos Networks, S.A. - http://www.phaistosnetworks.gr
> [EMAIL PROTECTED] T:+30-892-23855 F:+30-892-22670
> - A DOL Digital Company
>
>
Hi!
Your problem is quite simple.
Columns not listed in select_list , but used in order by and / or
group by, are silently added to the select_list.
In your case this happens with id field.
This is perfectly in accordance with ANSI SQL standards.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
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
