Re: conflict with msql
Alan Chu wrote: I am now using msql and wants to change to mysql. Is there any problem in install both in the same server? Regards, Alan - 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 Hi, During my migration from mSQL to MySQL, I have been using both on same server without problem. Regards -- Joseph Bueno NetClub/Trader.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to make SQL command by a file?
It is easy make an error while writing SQL coimmand to create table, etc... So I'd like to write this command (CREATE TABLE) in a file then run this command in mysql: How can I do? how can I write it? Thank you in advance. Mario. - 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 to make SQL command by a file?
in UNIX derivatives, vi a text file, and write your create/other sql into it then save and close it. cat your_file | ./bin/mysql -uyour_username -p your_database you will be prompted to enter a password for your username. then enter your password. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 30, 2001 6:34 PM Subject: how to make SQL command by a file? It is easy make an error while writing SQL coimmand to create table, etc... So I'd like to write this command (CREATE TABLE) in a file then run this command in mysql: How can I do? how can I write it? Thank you in advance. Mario. - 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 Approach97
resend! pls reply -- From: Sulman Sent: Monday, March 26, 2001 9:21 PM To: '[EMAIL PROTECTED]' Subject:MySQL Approach97 Hi All! I'm new in the mailing list just want to know about the data transfer from Approach97 to MySQL. In my company we are running Approach97 for fullfil our database need but now my boss want to make this database online. I'v heard a lot about MySQL ( Speed / Stability etc. ) but want to know that is it possible to export data from Approach97 to MySQL or Import in MySQL from Approach97 or anyother option to do this?? Awaiting helpful reply. Thanks Regards / Sulman - 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: Delete Again?
Hi,
This is my full code
$www_domain="select Failed_Signups.EmailAddress.Email from
Failed_Signups.EmailAddress left join www_domain_net.Members on
Failed_Signups.EmailAddress.Email=www_domain_net.Members.EmailAddress where
www_domain_net.Members.EmailAddress is null";
$www_domainRESULT=mysql_query($www_domain);
$www_domain_rows=mysql_num_rows($www_domainRESULT);
for ($a=0; $a$www_domain_rows; $a++)
{
mysql_data_seek($www_domainRESULT, $a);
$www_domain_Array = mysql_fetch_array($www_domainRESULT);
The above two lines are at odds with each other. You are telling PHP to
advance the pointer in the result set with mysql_data_seek(), but
mysql_fetch_array() also does this automatically. So, in effect, you are
getting every alternate row from your result set here. Get rid of the
mysql_data_seek() line - it's not necessary.
printf("%s", $www_domain_Array['Email']);
$inlist .= sprintf("\'%s\'",$www_domain_Array['Email']);
}
$query = mysql_db_query("Failed_Signups","DELETE FROM EmailAddress WHERE
Email NOT IN (".$inlist.")");
I'm not surprised this doesn't work as expected. You are forming a list
($inlist) of e-mail addresses to put in the NOT IN expression, but you are
missing seperating them by commas. It needs to do this:
$inlist .= sprintf("\'%s\'", $www_domain_Array['Email']);
if($a $www_domain_rows - 1) {
$inlist .= ", ";
}
This will seperate all of them by commas (missing, of course, the last one).
Hope this gets you going. Also, if you have any more queries about your
code, you'd be better off asking on the PHP mailing list, as this problem
really isn't much to do with MySQL itself.
Regards,
Basil Hussain ([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
Image in Mysql
Respected Sir i want to know how i store a image in mysql.i sue perl for scripting on linux. please help me thanks allah hafiz
Connecting MySQL to IRIX
Hi, I'm not very experienced yet with MySQL and MyODBC. So I would appreciate very much any help how I could start solving the following problem: We are running a CAD/CAM-system on SGI-Workstations under IRIX 6.5.2 to 6.5.10 and have extended this system by some own applications written in Fortran and C. Now these applications need access to data stored in a MySQL-Database on a Linux-Server (currently MySQL 3.22.32 and SUSE Linux 6.1, hopefully in near future MySQL 3.23 and SUSE Linux 7.1) How can I do this? Do I only have to install UnixODBC on the IRIX-systems? Do I have to write some C-Code to make UnixODBC accessible for our applications?... If there is anybody, who has done something similar or who knows of good sources for further information about this subjects, I would appreciate any help very much. I somehow have to find a start ... Thanks Frank Hennrich - 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: Image in Mysql
Read the archives of this list. P On Fri, 30 Mar 2001, Sheikh wrote: Respected Sir i want to know how i store a image in mysql.i sue perl for scripting on linux. please help me thanks allah hafiz - 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: MYSQLGui
Peter Adamka writes:
Thanks a lot, but I've make a mistake (supposing tha t I've done something
I didn't ;-) -inserting -lfleditor switch). Sorry for it.
Malmo
Malmo If I only got 20$ for evryone who's too lazy to configure his own comp.
Bill Gates "Why not?"
No need to be sorry about anything.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, 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: REPLACE DELAYED bug with MySQL 3.23.36
[EMAIL PROTECTED] writes:
Hi !
I notice a bug with MySQL 3.23.36 with REPLACE DELAYED which crash my MyISAM
tables.
The problem was present in MySQL 3.23.34, but not in 3.23.33 nor 3.23.35.
The bug occurs randomly and makes MySQL restart...
With REPLACE instead of REPLACE DELAYED, there seems to be no problem.
Here is what MyISAMCHK report :
Checking MyISAM file: online
Data records: 96 Deleted blocks: 79
myisamchk: warning: Table is marked as crashed
- check file-size
- check key delete-chain
- check record delete-chain
myisamchk: error: record delete-link-chain corrupted
- check index reference
- check data record references index: 1
myisamchk: error: Found key at page 2048 that points to record outside
datafile
MyISAM-table 'online' is corrupted
Here is what I use with PHP :
mysql_query("REPLACE DELAYED INTO online (pseudo,date,cat,forum) VALUES
('$user','$time','$cat','$site')",$dbh) or die( "Erreur 1:".mysql_error());
}
else
{
mysql_query("REPLACE DELAYED INTO guest (pseudo,date,forum) VALUES
('$REMOTE_ADDR','$time','$site')",$dbh) or die( "Erreur:".mysql_error());
}
$timeold=$time-120;
@mysql_query("DELETE FROM online WHERE date $timeold",$dbh) or die(
"Erreur:".mysql_error());
@mysql_query("DELETE FROM guest WHERE date $timeold",$dbh) or die(
"Erreur:".mysql_error());
Now the online and guest table structure :
CREATE TABLE online (pseudo char(35) NOT NULL,date int(11) unsigned DEFAULT
'0' NOT NULL,cat tinyint(4) unsigned DEFAULT '0' NOT NULL,forum char(35) NOT
NULL,PRIMARY KEY (pseudo),KEY date (date));
CREATE TABLE guest (pseudo char(35) NOT NULL,date int(11) unsigned DEFAULT
'0' NOT NULL,forum char(35) NOT NULL,PRIMARY KEY (pseudo),KEY date (date));
If I have time I'll try to make a stack trace report...
--
Jocelyn Fournier
Presence-PC
www.presence-pc.com
Hi!
We do require a repeatable test case, i.e. table(s) plus set of
commands that always lead to problem, in your case to the crashing of
MySQL.
Also, I hope you have not run myisamchk while MySQL server was
running. You would be better by using CHECK TABLE command instead.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, 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: mysql 3.23.36 problem
On Thu, Mar 29, 2001 at 07:57:41PM +0300, Michael Widenius wrote: mysql rename tables test1 to test3, test2 to test1, test3 to test2; Peter ERROR 1192: Can't execute the given command because you have active locked Peter tables or an active transaction I bet this happens when you have a server that is compiled w transaction support but you are using --skip-bdb and --skip-innobase ? Here is a fix for this: What's the scope of this bug? Does it only affect the use of 'circular' rename, or all renames, or table locking in general, or tables in general? Tim. - 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: MySQLGUI
Hackley, Susan writes:
Help,
I am trying to install the Sun Solaris 2.7 Sparc static binary of
MySQLGUI 1.6 for the MySQLGUI the result was:
ld.so.1:./mysqlgui-solaris-2.7-sparc-static-1.6
:fatal:libstdc++.so.2.10.0:open fatal: no such file or directory
1. Trying to install this GUI on a solaris box, make the solaris box the
client then telnet or some how connect to the database server on a UNIX box.
2. I have tried both ways and it still will not work, are more detailed
instructions. I am not a unix expert.
Susan Hackley
Database Administrator
UNIX Services
USCO Logistics
Phone: (203)578-4364
[EMAIL PROTECTED]
Hi!
Unfortunately, we are not able to build mysqlgui statically on
Solaris, because Sun does not provide static libraries for most of
it's libs.
What you should do is install gcc 2.95.2, complete with STL library
and that symbol will be resolved.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, 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: MySQLGUI: where is the code for wString::Initialize() ?
Hubert Feyrer writes:
On Tue, 27 Mar 2001, Sinisa Milivojevic wrote:
You also need fl_editor package. You will find a link on mysqlgui
page.
OK, that indeed got me further. (Is it only me, or does putting a header
file into one package, and the source in another one really sound funky?).
Anyways, I'm down to one error now:
single.o: In function `EditorEngine::LoadSQL(char const *)':
/usr/pkgsrc/databases/mysqlgui.work/work.i386/mysqlgui-1.7.4/single.cc:33: undefined
reference to `wString::operator=(wString const )'
collect2: ld returned 1 exit status
Digging in single.cc, the offending line is:
left = *Lines[Cursor.Row];
'Lines' is a 'wString **Lines' (decladed in FL/editengine.h).
I'm not C++-clueful enough to resolve this - can someone please help?
- Hubert
--
Hubert Feyrer [EMAIL PROTECTED]
HI!
You have an error in building fl_editor. The above method is from
fl_editor.
You have to add edfile.o to the library or to the mysqlgui linker
args.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, 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: Innobase compile error on MacOS X/Darwin 1.3
Scott Ellsworth writes: Howdy, all. The following error came up when compiling under OS X release. c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr/local/mysql\"" -DDATADIR="\"/usr/local/mysql/var\"" -DSHAREDIR="\"/usr/local/mysql/share/mysql\"" -DHAVE_CONFIG_H -I../bdb/build_unix -I../innobase/include -I./../include -I./../regex-I. -I../include -I.. -I.-O3 -DDBUG_OFF -O3 -fomit-frame-pointer -fno-implicit-templates -traditional-cpp -DHAVE_DARWIN_THREADS -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE -c ha_innobase.cc In file included from ../innobase/include/ut0ut.h:13, from ../innobase/include/univ.i:178, from ha_innobase.cc:48: /usr/include/ctype.h:71: warning: `_C' redefined ../include/m_ctype.h:78: warning: this is the location of the previous definition /usr/include/ctype.h:74: warning: `_L' redefined ../include/m_ctype.h:74: warning: this is the location of the previous definition /usr/include/ctype.h:75: warning: `_P' redefined ../include/m_ctype.h:77: warning: this is the location of the previous definition /usr/include/ctype.h:76: warning: `_S' redefined ../include/m_ctype.h:76: warning: this is the location of the previous definition /usr/include/ctype.h:77: warning: `_U' redefined ../include/m_ctype.h:73: warning: this is the location of the previous definition /usr/include/ctype.h:78: warning: `_X' redefined ../include/m_ctype.h:80: warning: this is the location of the previous definition /usr/include/ctype.h:79: warning: `_B' redefined ../include/m_ctype.h:79: warning: this is the location of the previous definition /usr/include/ctype.h:85: warning: `isalnum' redefined ../include/m_ctype.h:98: warning: this is the location of the previous definition /usr/include/ctype.h:86: warning: `isalpha' redefined ../include/m_ctype.h:93: warning: this is the location of the previous definition /usr/include/ctype.h:87: warning: `iscntrl' redefined ../include/m_ctype.h:103: warning: this is the location of the previous definition /usr/include/ctype.h:88: warning: `isdigit' redefined ../include/m_ctype.h:96: warning: this is the location of the previous definition /usr/include/ctype.h:89: warning: `isgraph' redefined ../include/m_ctype.h:102: warning: this is the location of the previous definition /usr/include/ctype.h:90: warning: `islower' redefined ../include/m_ctype.h:95: warning: this is the location of the previous definition /usr/include/ctype.h:91: warning: `isprint' redefined ../include/m_ctype.h:101: warning: this is the location of the previous definition /usr/include/ctype.h:92: warning: `ispunct' redefined ../include/m_ctype.h:100: warning: this is the location of the previous definition /usr/include/ctype.h:93: warning: `isspace' redefined ../include/m_ctype.h:99: warning: this is the location of the previous definition /usr/include/ctype.h:94: warning: `isupper' redefined ../include/m_ctype.h:94: warning: this is the location of the previous definition /usr/include/ctype.h:95: warning: `isxdigit' redefined ../include/m_ctype.h:97: warning: this is the location of the previous definition /usr/include/ctype.h:98: warning: `isascii' redefined ../include/m_ctype.h:104: warning: this is the location of the previous definition /usr/include/ctype.h:99: warning: `toascii' redefined ../include/m_ctype.h:105: warning: this is the location of the previous definition In file included from ../innobase/include/ut0ut.h:13, from ../innobase/include/univ.i:178, from ha_innobase.cc:48: /usr/include/ctype.h:144: parse error before `char' /usr/include/ctype.h:151: parse error before `char' ha_innobase.cc:63: parse error before `}' make[3]: *** [ha_innobase.o] Error 1 make[2]: *** [all-recursive] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all-recursive-am] Error 2 My configure line was: CFLAGS="-O3 -fomit-frame-pointer" CXXFLAGS="-O3 -fomit-frame-pointer" ./configure --prefix=/usr/local/mysql --with-extra-charsets=complex --with-berkeley-db --with-innobase Scott --- [EMAIL PROTECTED] http://www.iceweasel.com/~scott/ "You die, she dies, EVERYbody dies" - Heavy Metal "When a great many people are unable to find work, unemployment results" - Calvin Coolidge, attrib. by Stanley Walker, City Editor, p. 131 (1934) Hi! Regarding the above warnings, seems like our m_ctype.h has to be changed to include Mac OS X beside Win32 in skipping those macros. But in order to find out how to circumvent the error, we should know what code is like on these lines in ctyp.h. You also did not say what MySQL version you are trying to build. Please try 3.23.36.
Re: how to make SQL command by a file?
command in mysql: How can I do? how can I write it? Create a .sql file.. check the archive, same question has been asked 1 or two days ago. Otherwise read info on websites about MySQL and other SQL languages Bye, B. - 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 message: [Incorrect information in file: './ts1/tbl_status.frm']
Silvio Picano writes:
Hi,
Been running mysql-3.22.32 / Solaris / Sun / dual-processor:
Mysql.pm 1.2214 + DBI 1.14 + perl 5.004_04
Database with 40 tables.
Biggest table has 2,131,447 rows in it.
No problems for 6 months.
Recently ported to mysql-3.23.35 / Linux 2.2.12-20smp / dual-processor.
Mysql.pm 1.2215 + DBI 1.14 + perl 5.005_03
Similar database tables.
Biggest table has 1,297,237 rows in it. (the "tbl_status" above).
Once every 36 hours or so, I receive the above error message from the
DBI.
After receiving the error, then running interactively, commands
that peek into the table gives me the same error. I simply drop
the table, and my program rebuilds the table in a few hours. [I
have not tried to chk the table.]
SQL commands on this table include:
CREATE TABLE
DROP TABLE
LOAD DATA INFILE ... REPLACE ...
SELECT COUNT(*)
ALTER TABLE ... RENAME ...
SELECT
DELETE ... WHERE ...
Table structure:
(increment BIGINT NOT NULL AUTO_INCREMENT,
tsource CHAR(10) NOT NULL,
prid CHAR(8) NOT NULL,
status_word CHAR(64),
status_message TEXT,
PRIMARY KEY(increment),
INDEX (tsource),
INDEX (prid))";
I tried the last mysql-3.22.XY version and same result occurs.
Did not seem to find appropriate error message in manual or the
mail list archives.
Any help or debug suggestions is much appreciated. Thanks.
Silvio
PS ... I am not on the official email lists so please reply with my
work address in the meantime.
Hi!
The above is very unusual error. .frm files are only read, never
written and should not be corrupted. You do not need to restore a
table. Just copy .frm file somewhere and when in good shape, and when
you get the above error just copy it back. .frm file is changed only
in ALTER TABLE. And even then old .frm file is not changed, but new
one is created.
Also check file size of *.MYI(D) files. Unlike Solaris , Linux can
support only up to 2 Gb file sizes, with 2.2.* kernel that is.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, 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
SP
So, is there any support for stored procedures in MySQL or not I don't think so, what do you think ? thank you
Re: How do I insert into BLOB Columns
Hi Darius, Just an idea: can you cut the binary data into separate small(er) chuncks and then store it in different records? (Using some identifier to know which chunks belong together, what is their order,...) This may make data handling harder, but you can reduce the memory load of the server; you do not have to store a very large binary data in one single variable. Regards, Peter Szekszardi PortoLogic Ltd. Portal building, prime number generating, script hacking and more... The prime number of the day is 364664071 On Fri, 30 Mar 2001, Darius Ivanauskas wrote: Hi, Thanks for your interest. Actualy i had alredy saw few examples in different client software implementations. But in all these examples they are using the same way: you must load entire file contents into a single variable, and in most cases you should use escaping sequences for binary data. Ant this method is scaring me. Because for realy BIG files you need HUGE amount of server's memory. (I care mostly about PHP implementation.) And i don't think that there is many database clients that support quries much bigger than 1MB (Im considering possibility to use other databases than MySQL). So, i'm looking the way when I can store binary data using smaller data chunks. Regards, -- Darius Ivanauskas On Fri, 30 Mar 2001, Peter Szekszardi wrote: Hi Darius, It depends on, what client softwer do you use... For example if you would like to fill BLOBS from a perl script via DBI, you have to use parameter binding. Could you give me some details? Regards, Peter Szekszardi PortoLogic Ltd. Portal building, prime number generating, script hacking and more... The prime number of the day is 364664071 On Thu, 29 Mar 2001, Darius Ivanauskas wrote: Hello, Does anybody know, how to insert large amount of data (ex.: large binary files) into BLOB columns? Thanks, Darius Ivanauskas P.S. Please reply to me. - 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: Connecting MySQL to IRIX
Frank Hennrich - Loher AG writes:
Hi,
I'm not very experienced yet with MySQL and MyODBC. So I would
appreciate very much any help how I could start solving the following
problem:
We are running a CAD/CAM-system on SGI-Workstations under IRIX 6.5.2 to 6.5.10 and
have extended this system by some own applications written in Fortran and C.
Now these applications need access to data stored in a MySQL-Database on a
Linux-Server
(currently MySQL 3.22.32 and SUSE Linux 6.1, hopefully in near future MySQL 3.23 and
SUSE Linux 7.1)
How can I do this? Do I only have to install UnixODBC on the IRIX-systems?
Do I have to write some C-Code to make UnixODBC accessible for our
applications?...
If there is anybody, who has done something similar or who knows of good sources
for further information about this subjects, I would appreciate any help very much.
I somehow have to find a start ...
Thanks
Frank Hennrich
Hi!
Why don't you just use our C API and access MySQL directly ??
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, 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
Segmentation fault compiling MySQL-3.2.36
Does somebody try to build MySQL-3.2.36 on Slackware 7.1?
I have an error trying to make test.
configuration:
[30-Mar-01][15:55]{ilya@odin} ~/Sources/mysql-3.23.36./configure
--prefix=/usr/local/mysql --enable-assembler --with-berkeley-db
--with-charset=koi8_ru --with-extra-charsets=latin1,cp1251
building is clean (no warnings)
[30-Mar-01][15:53]{ilya@odin} ~/Sources/mysql-3.23.36make test
cd mysql-test ; ./mysql-test-run
Installing Test Databases
Removing Stale Files
Installing Master Databases
./install_test_db: line 217: 23418 Segmentation fault $execdir/mysqld
--no-defaults --bootstrap --skip-grant-tables --basedir=$basedir
--datadir=$ldata --skip-innobase --skip-bdb --skip-gemini END_OF_DATA
use mysql;
$c_d
$i_d
$c_h
$i_h
$c_u
$i_u
$c_f
$i_f
$c_t
$c_c
END_OF_DATA
Error: Could not install master test DBs
make: *** [test] Error 1
[30-Mar-01][15:55]{ilya@odin} ~/Sources/mysql-3.23.36
-
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
No Stored Procedures - Big Deal
I don't mean to be argumentative, but what is everyones love affair with stored procedures? I like putting my logic in the mid-tier and I'm constantly battling my Sybase Admin at work who maligns me whenever they spot a query in my codeeven a very simple select "oh, I can make that a stored procedurebecause what if I change something?" me "then my code will break and I'll fix it.*somebody* always has to change something!" Triggers I can understand, they take away much of my validation headaches (and make me correspondingly lazy), but what am I missing about the panacea | paradise | emerald city of stored procedures? Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://superid.dyndns.org:8080/freesql/index.php
Locks
THe manual says To avoid using ROLLBACK, you can use the following strategy: Use LOCK TABLES ... to lock all the tables you want to access. Test conditions. Update if everything is okay. Use UNLOCK TABLES to release your locks. I didn't quite understasnd the meaning of Test Conditions Any help will be deeply appreciated Best Regards Sajan - 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
Odd issue
Hello, I have a Cobalt Qube2. I have recently compiled Apache 1.3.19, PHP4.0.3pl1 and MySQL 3.23.33. Even though, everything compiled normally. I am unable to load PHP4 as a DSO. When I run 'apachectl configtest', I get this error: Syntax error on line 239 of /etc/httpd/conf/httpd.conf: Cannot load /usr/lib/apache/libphp4.so into server: /usr/local/mysql/lib/mysql/libmysqlclient.so.10: undefined symbol: my_message_no_curses What does that mean ? I have compiled MySQL with these ./configure options: ./configure --disable-assembler --with-low-memory --prefix=/usr/local/mysql PHP: ./configure --with-apxs \ --enable-versioning \ --with-mysql=/usr/local/mysql --enable-track-vars \ --enable-ftp \ --with-mm=/usr/local/lib \ --with-zlib \ --with-xml - 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: Can't recover a bad corrupeted table...
Sir, I looked quickly through the mass of data supplied below, and it looks like you only tried myisamchk with the -r -q option combination. Try it with just -r. If that doesn't work, try it with -o. If that doesn't work, restore from backup. Got backup? Bob Hall Antonio gulli wrote: Any help is appreciated Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 158 to server version: 3.23.36-log myisamchk -V myisamchk Ver 1.45 for pc-linux-gnu at i686 a) Trying a recovery. myisamchk -r -q -Osort_key_blocks=16 keywords - check key delete-chain - check record delete-chain - recovering (with keycache) MyISAM-table 'keywords.MYI' Data records: 2062985 7000 [root@ideare queries]# myisamchk -r -q -Osort_key_blocks=16 -Okey_buffer_size=256M -Oread_buffer_size=256M -Osort_buffer_size=256M keywords - check key delete-chain - check record delete-chain - recovering (with keycache) MyISAM-table 'keywords.MYI' Data records: 2062985 - - check key delete-chain - check record delete-chain - recovering (with keycache) MyISAM-table 'keywords.MYI' Data records: 2062985 b) Trying a check Database changed mysql CHECK TABLE keywords; +--+---+--+--- -+| Table| Op| Msg_type | Msg_text |+--+---+--+-- --+| keywords | check | error| Key in wrong position at page 24942592 || queries.keywords | check | error| Corrupt |+--+---+--+-- --+2 rows in set (10.12 sec) yisamchk -a -Osort_key_blocks=16 -Okey_buffer_size=256M -Oread_buffer_size=256M -Osort_buffer_size=256M keywords \Checking MyISAM file: keywords Data records: 2062985 Deleted blocks: 0 myisamchk: warning: Table is marked as crashed - check file-size - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check data record references index: 3 myisamchk: error: Key in wrong position at page 24942592 - check record links myisamchk: error: Keypointers and record positions doesn't match MyISAM-table 'keywords' is corrupted 3) Describe this table ... myisamchk -dvv keywords MyISAM file: keywords Record format: Packed Character set: latin1 (8) File-version:1 Creation time: 2001-03-28 10:02:22 Recover time:2001-03-29 11:01:02 Status: crashed Data records: 2062985 Deleted blocks: 0 Datafile parts:2062985 Deleted data: 0 Datafile pointer (bytes):4 Keyfile pointer (bytes):4 Datafile length: 79274620 Keyfile length: 99454976 Max datafile length:4294967294 Max keyfile length: 4398046510079 Recordlength: 281 table description: Key Start Len Index Type Rec/key Root Blocksize 1 5 254 fulltext varchar packed 0 26022912 2048 1 4 float 0 2 266 16 multip. char packed stripped NULL 0 56983552 1024 3 2 255 multip. char packed stripped NULL 0 30499840 2048 Field Start Length Nullpos Nullbit Type 1 1 1 2 2 2551 1 no endspace 3 257 4 1 2 no zeros 4 261 2 1 4 no zeros 5 263 3 1 8 no zeros 6 266 16 1 16 no endspace 4) Re-check it mysql CHECK TABLE keywords; +--+---+--+--- -+| Table| Op| Msg_type | Msg_text |+--+---+--+-- --+| keywords | check | warning | Table is marked as crashed || keywords | check | error| Key in wrong position at page 74375168 || queries.keywords | check | error| Corrupt |+--+---+--+-- --+3 rows in set (9.12 sec) 5) http://www.mysql.com/doc/R/e/Repair.html Stage 3: Difficult repair francesca mysql queries mysql SET AUTOCOMMIT=1; mysql TRUNCATE TABLE keywords; mysql quit myisamchk -r -q -Osort_key_blocks=16 -Okey_buffer_size=256M -Oread_buffer_size=256M -Osort_buffer_size=256M keywords - check key delete-chain - check record delete-chain - recovering (with keycache) MyISAM-table 'keywords.MYI' Data records: 0 mysql use queries;
Re: GROUP BY Question (p2)
Sir, try SELECT g1.name, g1.score, g1.id FROM grades g1, grades g2 WHERE g1.name = g2.name GROUP BY g1.name, g1.score HAVING Max(g1.score) = Max(g2.score); Bob Hall Q: I have the following table "grades". ++++ | name | score |id | ++++ | John |10 | 1 | ++++ | John | 20 |2 | ++++ | John | 8 |3 | ++++ | Carl |10 |4 | ++++ | Carl |15 |5 | ++++ | Mary |6 |6 | ++++ I'd like to select a single name, maximum score, as well as the corresponding id number and put them in order from highest to lowest and end up with: ++++ | name | score |id | ++++ | John |20 | 2 | ++++ | Carl |15 |5 | ++++ | Mary |6 |6 | ++++ I tried using: SELECT name, id, max(score) FROM grades GROUP BY name ORDER BY score DESC At first I was pretty happy with this, but I realized that although the name and score where the values I was looking for, the id didn't always correspond to the record I wanted. Any ideas - 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 Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - 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: No Stored Procedures - Big Deal
Stored procedures offer several advantages over embedded SQL. 1: It is easier to write, debug and modify SQL code in a stored procedure with a tool designed to do that. You can write PHP from the command line also but not many people do it. 2: Placing the code in a stored procedure allows you to divorce it from your other code and debug it separately. 3: It allows for easier division of labor. In our shop, we routinely hand off the SP's to the data team. 4: Stored procedures allow for a greater degree of code reuse. But the biggest advantage. 5: Stored procedures are normally (Oracle, MS SQL, Interbase, etc.) compiled code. They are compiled once and used in their compiled state until they are modified. This offers faster execution than embedded sql, which much be compiled each time it is submitted. IMHO, Cal http://www.calevans.com -Original Message- From: John Dean [mailto:[EMAIL PROTECTED]] Sent: Friday, March 30, 2001 7:50 AM To: Gary Huntress; Mysql (E-mail) Subject: Re: No Stored Procedures - Big Deal Hi I must agree with you on this point, after what can be done in a stored procedure can also be done with SQL. The only real advantage I can see to provide a centralized store of commonly used SQL, but then again these can be stored in a text file. The disadvantage is a down grade in performance, which is exactly what MySQL tries to avoid. On Friday 30 March 2001 14:19, Gary Huntress wrote: I don't mean to be argumentative, but what is everyones love affair with stored procedures? I like putting my logic in the mid-tier and I'm constantly battling my Sybase Admin at work who maligns me whenever they spot a query in my codeeven a very simple select "oh, I can make that a stored procedurebecause what if I change something?" me "then my code will break and I'll fix it.*somebody* always has to change something!" Triggers I can understand, they take away much of my validation headaches (and make me correspondingly lazy), but what am I missing about the panacea | paradise | emerald city of stored procedures? Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://superid.dyndns.org:8080/freesql/index.php -- Regards John MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, UK ___/ - 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 not freeing memory
At 18:52 29/03/01 +0200, you wrote: Hello again! Sorry but didn't see your other comments on first reading. I thought that the key cache meant that mysqld would only hold key/indexes in memory and that the data the indexs point to would still be read/written from disk. It's just that it seems to me that mysqld allocates memory for the indexes and the data they point to, to enable the data set to be retrieved.And that when an additional table is used by a client, the server's memory manager allocates additional memory to cope with new query rather than using the memory that it has already grabbed. I can't belive that it should work this way because mysqld would would allways eat up memory to the sum of all the data of all the tables used. The only way I have found of forcing mysqld to deallocate memory is to drop one of the tables previously used in a select statement - not much use! I have read 90% of MySQL by Paul DuBois and can't find an answer!? Any ideas? cheers Shaun. i'm using:- mysql version 3.23.33 Linux Box - kernel 2.4 (swap disabled) 1: When a client makes a "SELECT * FROM mytable1" request to the server , mysqld allocates memory to handle it and on subsequent queries to the same table no more memory is allocated.However, if a subsequent query such as"SELECT * FROM mytable2" is issued, mysqld allocates additional memory even though the first client has closed it's connection.Is this supposed to happen thisway? Yes. MySQL has a key cache (and some other caches) which are used to optimize speed. You can specify the size of the caches on start-up. - 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: No Stored Procedures - Big Deal
How come nobody has mentioned that complex data manipulation can be performed on the server without waistuful and slow transmission of unwanted data to the client? that seems like the biggest advantage to me. Meaning that if I have to do something to the data that SQL doesn't allow without SPs I have to send large datasets to the client to be manipulated, with SPs data manipulation can be done on the server (which is typicaly more powerful) and then only the smaller answer data is returned to the client. Cal Evans wrote: Stored procedures offer several advantages over embedded SQL. 1: It is easier to write, debug and modify SQL code in a stored procedure with a tool designed to do that. You can write PHP from the command line also but not many people do it. 2: Placing the code in a stored procedure allows you to divorce it from your other code and debug it separately. 3: It allows for easier division of labor. In our shop, we routinely hand off the SP's to the data team. 4: Stored procedures allow for a greater degree of code reuse. But the biggest advantage. 5: Stored procedures are normally (Oracle, MS SQL, Interbase, etc.) compiled code. They are compiled once and used in their compiled state until they are modified. This offers faster execution than embedded sql, which much be compiled each time it is submitted. IMHO, Cal http://www.calevans.com -Original Message- From: John Dean [mailto:[EMAIL PROTECTED]] Sent: Friday, March 30, 2001 7:50 AM To: Gary Huntress; Mysql (E-mail) Subject: Re: No Stored Procedures - Big Deal Hi I must agree with you on this point, after what can be done in a stored procedure can also be done with SQL. The only real advantage I can see to provide a centralized store of commonly used SQL, but then again these can be stored in a text file. The disadvantage is a down grade in performance, which is exactly what MySQL tries to avoid. On Friday 30 March 2001 14:19, Gary Huntress wrote: I don't mean to be argumentative, but what is everyones love affair with stored procedures? I like putting my logic in the mid-tier and I'm constantly battling my Sybase Admin at work who maligns me whenever they spot a query in my codeeven a very simple select "oh, I can make that a stored procedurebecause what if I change something?" me "then my code will break and I'll fix it.*somebody* always has to change something!" Triggers I can understand, they take away much of my validation headaches (and make me correspondingly lazy), but what am I missing about the panacea | paradise | emerald city of stored procedures? Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://superid.dyndns.org:8080/freesql/index.php -- Regards John MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, UK ___/ - 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: No Stored Procedures - Big Deal
Hi Agreed but it still incurrs a performance penulty; more so when the server is under heavy load On Friday 30 March 2001 16:15, Steve Ruby wrote: How come nobody has mentioned that complex data manipulation can be performed on the server without waistuful and slow transmission of unwanted data to the client? that seems like the biggest advantage to me. Meaning that if I have to do something to the data that SQL doesn't allow without SPs I have to send large datasets to the client to be manipulated, with SPs data manipulation can be done on the server (which is typicaly more powerful) and then only the smaller answer data is returned to the client. Cal Evans wrote: Stored procedures offer several advantages over embedded SQL. 1: It is easier to write, debug and modify SQL code in a stored procedure with a tool designed to do that. You can write PHP from the command line also but not many people do it. 2: Placing the code in a stored procedure allows you to divorce it from your other code and debug it separately. 3: It allows for easier division of labor. In our shop, we routinely hand off the SP's to the data team. 4: Stored procedures allow for a greater degree of code reuse. But the biggest advantage. 5: Stored procedures are normally (Oracle, MS SQL, Interbase, etc.) compiled code. They are compiled once and used in their compiled state until they are modified. This offers faster execution than embedded sql, which much be compiled each time it is submitted. IMHO, Cal http://www.calevans.com -Original Message- From: John Dean [mailto:[EMAIL PROTECTED]] Sent: Friday, March 30, 2001 7:50 AM To: Gary Huntress; Mysql (E-mail) Subject: Re: No Stored Procedures - Big Deal Hi I must agree with you on this point, after what can be done in a stored procedure can also be done with SQL. The only real advantage I can see to provide a centralized store of commonly used SQL, but then again these can be stored in a text file. The disadvantage is a down grade in performance, which is exactly what MySQL tries to avoid. On Friday 30 March 2001 14:19, Gary Huntress wrote: I don't mean to be argumentative, but what is everyones love affair with stored procedures? I like putting my logic in the mid-tier and I'm constantly battling my Sybase Admin at work who maligns me whenever they spot a query in my codeeven a very simple select "oh, I can make that a stored procedurebecause what if I change something?" me "then my code will break and I'll fix it.*somebody* always has to change something!" Triggers I can understand, they take away much of my validation headaches (and make me correspondingly lazy), but what am I missing about the panacea | paradise | emerald city of stored procedures? Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://superid.dyndns.org:8080/freesql/index.php -- Regards John MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, UK ___/ - 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 -- Regards John MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, UK ___/ - 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
Odd mysqlhotcopy behavior
For the longest time, I'v ebacked up my various MySQL databases using mysqldump. However, I hated restarting the database each night (on a few occasions it would restart but the databases could not be accessed until it was restarted again) Plus I think mysqlhotcopy is a more elegant solution. OK, so I recently went ahead and tried using mysqlhotcopy. Nothing fancy. /usr/bin/mysqlhotcopy -u user -p pw --allowold --flushlog [names of 10 databases] /home/mysql/backup When I run it manually, it works great. Locks all the tables, copies the files, wonderful. However, I'm having trouble running it via a cron job. My /etc/crontab entry runs the above command as user mysql (which has full access to all the database files and the backup directory) I always get the same error: DBD::mysql::db do failed: Incorrect information in file: './slash/sortcodes.frm' at /usr/bin/mysqlhotcopy line 381. It occurs on different lines and on different tables in different databases. When I run the command manually the next morning - it works MOST of the time though sometimes I do get the Incorrect information error then too - trying again usually fixes it. I've myisamchk'ed the tables - thinking that might be the issue - nope. I searched the archives - couldn't really find anything about this. Its a RedHat 6.2 box running 3.23.35 and now .36 I'm using Perl 5.6.0 and my version of DBI and DBD are up to date according to CPAN. Any ideas? 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
Creating database
Hi out there, I'm new with MySQL. I have installed Linux 6.0 and MySQL 3.23.33 This happens when I want to create a database: [mysql@nestorix mysql]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 49 to server version: 3.23.33 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql create database java_db; ERROR 1044: Access denied for user: '@localhost' to database 'java_db' mysql \q Bye [mysql@nestorix mysql]$ Why? What did I do wrong? Any ideas? with kind regards, Herman Pool Nibble Consultancy b.v. Oude Amersfoortseweg 22 1213 AD Hilversum The Netherlands tel: +31 (0)35 6217619 fax:: +31 (0)35 6219819 www.nibble.nl
RE: No Stored Procedures - Big Deal
No. In other implementations, executing 100 stored procedures is actually LESS taxing to the server than executing the same code 100 times. The stored procedure can be compiled once and execute 100 times. The embedded sql cannot. Cal http://www.calevans.com -Original Message- From: John Dean [mailto:[EMAIL PROTECTED]] Sent: Friday, March 30, 2001 9:24 AM To: Steve Ruby; Cal Evans Cc: Gary Huntress; Mysql (E-mail) Subject: Re: No Stored Procedures - Big Deal Hi Agreed but it still incurrs a performance penulty; more so when the server is under heavy load On Friday 30 March 2001 16:15, Steve Ruby wrote: How come nobody has mentioned that complex data manipulation can be performed on the server without waistuful and slow transmission of unwanted data to the client? that seems like the biggest advantage to me. Meaning that if I have to do something to the data that SQL doesn't allow without SPs I have to send large datasets to the client to be manipulated, with SPs data manipulation can be done on the server (which is typicaly more powerful) and then only the smaller answer data is returned to the client. Cal Evans wrote: Stored procedures offer several advantages over embedded SQL. 1: It is easier to write, debug and modify SQL code in a stored procedure with a tool designed to do that. You can write PHP from the command line also but not many people do it. 2: Placing the code in a stored procedure allows you to divorce it from your other code and debug it separately. 3: It allows for easier division of labor. In our shop, we routinely hand off the SP's to the data team. 4: Stored procedures allow for a greater degree of code reuse. But the biggest advantage. 5: Stored procedures are normally (Oracle, MS SQL, Interbase, etc.) compiled code. They are compiled once and used in their compiled state until they are modified. This offers faster execution than embedded sql, which much be compiled each time it is submitted. IMHO, Cal http://www.calevans.com -Original Message- From: John Dean [mailto:[EMAIL PROTECTED]] Sent: Friday, March 30, 2001 7:50 AM To: Gary Huntress; Mysql (E-mail) Subject: Re: No Stored Procedures - Big Deal Hi I must agree with you on this point, after what can be done in a stored procedure can also be done with SQL. The only real advantage I can see to provide a centralized store of commonly used SQL, but then again these can be stored in a text file. The disadvantage is a down grade in performance, which is exactly what MySQL tries to avoid. On Friday 30 March 2001 14:19, Gary Huntress wrote: I don't mean to be argumentative, but what is everyones love affair with stored procedures? I like putting my logic in the mid-tier and I'm constantly battling my Sybase Admin at work who maligns me whenever they spot a query in my codeeven a very simple select "oh, I can make that a stored procedurebecause what if I change something?" me "then my code will break and I'll fix it.*somebody* always has to change something!" Triggers I can understand, they take away much of my validation headaches (and make me correspondingly lazy), but what am I missing about the panacea | paradise | emerald city of stored procedures? Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://superid.dyndns.org:8080/freesql/index.php -- Regards John MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, UK ___/ - 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 -- Regards John MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, UK ___/ - Before posting, please check:
Re: Can't recover a bad corrupeted table...
I tried -r I tried -o I tried to truncate the table and re-build the index from scratch. I tried to create ex-novo a table, import data from scratch and it result in a corrupted table. None of these seems to work Bob Hall wrote: Sir, I looked quickly through the mass of data supplied below, and it looks like you only tried myisamchk with the -r -q option combination. Try it with just -r. If that doesn't work, try it with -o. If that doesn't work, restore from backup. Got backup? Bob Hall Antonio gulli wrote: Any help is appreciated Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 158 to server version: 3.23.36-log myisamchk -V myisamchk Ver 1.45 for pc-linux-gnu at i686 a) Trying a recovery. myisamchk -r -q -Osort_key_blocks=16 keywords - check key delete-chain - check record delete-chain - recovering (with keycache) MyISAM-table 'keywords.MYI' Data records: 2062985 7000 [root@ideare queries]# myisamchk -r -q -Osort_key_blocks=16 -Okey_buffer_size=256M -Oread_buffer_size=256M -Osort_buffer_size=256M keywords - check key delete-chain - check record delete-chain - recovering (with keycache) MyISAM-table 'keywords.MYI' Data records: 2062985 - - check key delete-chain - check record delete-chain - recovering (with keycache) MyISAM-table 'keywords.MYI' Data records: 2062985 b) Trying a check Database changed mysql CHECK TABLE keywords; +--+---+--+--- -+| Table| Op| Msg_type | Msg_text |+--+---+--+-- --+| keywords | check | error| Key in wrong position at page 24942592 || queries.keywords | check | error| Corrupt |+--+---+--+-- --+2 rows in set (10.12 sec) yisamchk -a -Osort_key_blocks=16 -Okey_buffer_size=256M -Oread_buffer_size=256M -Osort_buffer_size=256M keywords \Checking MyISAM file: keywords Data records: 2062985 Deleted blocks: 0 myisamchk: warning: Table is marked as crashed - check file-size - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check data record references index: 3 myisamchk: error: Key in wrong position at page 24942592 - check record links myisamchk: error: Keypointers and record positions doesn't match MyISAM-table 'keywords' is corrupted 3) Describe this table ... myisamchk -dvv keywords MyISAM file: keywords Record format: Packed Character set: latin1 (8) File-version:1 Creation time: 2001-03-28 10:02:22 Recover time:2001-03-29 11:01:02 Status: crashed Data records: 2062985 Deleted blocks: 0 Datafile parts:2062985 Deleted data: 0 Datafile pointer (bytes):4 Keyfile pointer (bytes):4 Datafile length: 79274620 Keyfile length: 99454976 Max datafile length:4294967294 Max keyfile length: 4398046510079 Recordlength: 281 table description: Key Start Len Index Type Rec/key Root Blocksize 1 5 254 fulltext varchar packed 0 26022912 2048 1 4 float 0 2 266 16 multip. char packed stripped NULL 0 56983552 1024 3 2 255 multip. char packed stripped NULL 0 30499840 2048 Field Start Length Nullpos Nullbit Type 1 1 1 2 2 2551 1 no endspace 3 257 4 1 2 no zeros 4 261 2 1 4 no zeros 5 263 3 1 8 no zeros 6 266 16 1 16 no endspace 4) Re-check it mysql CHECK TABLE keywords; +--+---+--+--- -+| Table| Op| Msg_type | Msg_text |+--+---+--+-- --+| keywords | check | warning | Table is marked as crashed || keywords | check | error| Key in wrong position at page 74375168 || queries.keywords | check | error| Corrupt |+--+---+--+-- --+3 rows in set (9.12 sec) 5) http://www.mysql.com/doc/R/e/Repair.html Stage 3: Difficult repair francesca mysql queries mysql SET AUTOCOMMIT=1; mysql TRUNCATE TABLE keywords; mysql quit myisamchk -r -q
Re: Creating database
On Fri, 30 Mar 2001, Herman Pool wrote: Hi out there, I'm new with MySQL. I have installed Linux 6.0 and MySQL 3.23.33 This happens when I want to create a database: [mysql@nestorix mysql]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 49 to server version: 3.23.33 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql create database java_db; ERROR 1044: Access denied for user: '@localhost' to database 'java_db' mysql \q Bye [mysql@nestorix mysql]$ Why? What did I do wrong? Any ideas? You don't have the privileges to perform a CREATE command. This is part of the MySQL authorization mechanism. From the error message I see that you are connected as user 'nobody', who most probably doesn't have such a privilege. Try connecting as the DB admin (if you have that authority). If not do a: select user(); to see the username you are logged in under and then: select * from mysql.user; and check that the Create_priv column is set to 'Y' for this user. If this is 'N' you'll have to check the mysql.db table and maybe even the mysql.host table. To understand what's going on start reading at: http://www.mysql.com/doc/P/r/Privileges.html regards, thalis - 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 database
Am 17:44 30.03.2001 schrieb Herman Pool: Hi out there, I'm new with MySQL. I have installed Linux 6.0 and MySQL 3.23.33 This happens when I want to create a database: [mysql@nestorix mysql]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 49 to server version: 3.23.33 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql create database java_db; ERROR 1044: Access denied for user: '@localhost' to database 'java_db' mysql \q Bye [mysql@nestorix mysql]$ Why? What did I do wrong? Any ideas? with kind regards, Herman Pool Nibble Consultancy b.v. Oude Amersfoortseweg 22 1213 AD Hilversum The Netherlands tel: +31 (0)35 6217619 fax:: +31 (0)35 6219819 www.nibble.nl have you tried mysql -u root? Normally only user root has all privileges Create others with GRANT, check manual Check http://www.mysql.com/doc/A/c/Access_denied.html http://www.mysql.com/doc/G/R/GRANT.html Hope it helps regards Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - 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: linux benchmarking test and BSD problems
Hi Seung! Yes, you have to do some tuning to get the performance from a transactional database. You should not use autocommit=1, because then the database has to physically write the log segment to disk after each individual insert. Try to insert your data in a single transaction, only a single commit after the insert, or a few commits on the way. I understand you measured several times, doing DELETE FROM TABLE in between. Innobase uses some CPU to physically remove the delete marked records in a purge operation. DROP TABLE and TRUNCATE TABLE (in MySQL-4.0) are faster. I will also add a small optimization to auto_increment columns. Currently it executes SELECT MAX (KEY) FROM TABLE before each insert, which wastes some CPU and is not necessary. It is better cache the latest inserted key value to main memory, to the data dictionary. The FreeBSD bug is known. I will run tests on our FreeBSD machine in the next few days. Obviously there is something wrong with the FreeBSD port. Was it so that it hung and used 100 % of CPU? That has been reported also from Italy. Best regards, Heikki At 06:11 PM 3/30/01 +0900, you wrote: Hi Heikki, I have run a few test for innobase tables on linux and BSD 1. It seems that 'innobase' table was slower than 'bdb' table for 'insert' command, which is surprising(or not? o_O) 2. It may be due to that fact that I dont' know much about optimazing the 'innobase' table. Do you know how to boost the performance of 'bdb' or 'innobase table'? Please let me know...:( 3. I mainly tested the innobase table with linux, but I actually want to run mysql with 'bdb' or 'innobase' tables on FreeBSD. 4. However, mysql just hung when I tried to insert the 1 rows of data, the same data used for linux test, using 'mysql data.sql'. I used 'my-large.cnf' and changed the setting as follwings. innobase_buffer_pool_size=400M innobase_additional_mem_pool_size=20M FreeBSD setting 4.2 release #1 pentium 550, 512 RAM, mysql-3.23.35 complied with ./configure -- 1. --prefix=/usr/local/mysql --with-charset=euc_kr --with-low-memory --without-debug --without-readline --with-mysqld-ldflags=-all-static --with-mit-threads=no --with-client-ldflags=-all-static --with-innobase --with-bdb 2. --with-charset=euc_kr --with-innobase --with-berkeley-db Linux setting Redhat 6.2, kernal 2.2.14-5.0, pentium550, 128 RAM, mysql-3.23.35 complied with ./configure --with-charset=euc_kr --with-berkeley-db --with-innobase Other setting 1. The data used had three columns, 'no', 'name', 'grade' with 'no' as the primary index and auto_increament and grade as a key. There were 1 rows, and I inserted the data using 'shellmysql data.sql'. 2. Whenever I inserted the data, I simply did 'delete from table where no 0' instead of dropping the table. 2. I used 'my-medium' as 'my.cnf' 'mysql insert' benchmarking result( all times are in seconds). 1. with key, autocommit=1, flush_log_at_trx=1, all on, basic setting myisam real 5.61 real 5.10 real 5.08 innobase real 68.57 real 69.27 real 83.26 real 100.87 real 99.99 real 102.31 real 108.82 real 114.23 real 124.23 real 94.42 real 98.20 bdb real 56.83 real 43.49 real 39.76 real 54.77 real 48.75 2. with key, autocommit=1, flush_log_at_trx=1, bdb off, basic setting myisam real 4.48 real 3.01 real 3.08 real 3.08 real 3.04 innobase real 70.04 real 99.04 with innobase_buffer_pool_size=100M innobase_additional_mem_pool_size=10M real 76.60 real 80.97 real 81.52 real 107.47 3. with key, autocommit=1, flush_log_at_trx=1, bdb on bdb real 53.14 real 54.29!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=Content-Type content="text/html; charset=ks_c_5601-1987" META content="MSHTML 5.50.4522.1800" name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff DIVFONT size=2 DIVFONT size=2Hi Heikki, I have run a few test for innobase tables on linux andnbsp;BSD/FONT/DIV DIVFONT size=2/FONTnbsp;/DIV DIVFONT size=21. It seems that 'innobase' table was slower than 'bdb' table for 'insert' command, which is surprising(or not? o_O)/FONT/DIV DIVFONT size=2/FONTnbsp;/DIV DIVFONT size=22. It may be due to that fact that I dont' know much about optimazing the 'innobase' table.nbsp;/FONTFONT size=2nbsp;Do you know how to boost the performance of 'bdb' or 'innobase table'?nbsp;nbsp;Please let me know...:(/FONT/DIV DIVFONT size=2/FONTnbsp;/DIV DIVFONT size=23. I mainly tested the innobase table with linux, but I actually want to run mysql with 'bdb' or 'innobase' tables on FreeBSD./FONT/DIV DIVFONT size=2/FONTnbsp;/DIV DIVFONT size=24. However, mysql just hung when I tried to insert the 1 rows of data, the same data used for linux test,nbsp;using 'mysql lt; data.sql'.nbsp; I used 'my-large.cnf' and changednbsp;the setting asnbsp;follwings.nbsp;nbsp;/FONT/DIV DIVFONT size=2/FONTnbsp;/DIV DIVFONT
Re: MySQL Approach97
If you can export all your data from any database program, using any field and record delimiter character you like, then it can be imported into MySQL. There is always a way. Not being familiar with Approach97, I can't answer for sure, but If there is absolutely no way to export your data as a text file, THEN you might be stuck. On 3/30/01 1:54 AM, "Sulman" [EMAIL PROTECTED] wrote: resend! pls reply -- From: Sulman Sent: Monday, March 26, 2001 9:21 PM To: '[EMAIL PROTECTED]' Subject: MySQL Approach97 Hi All! I'm new in the mailing list just want to know about the data transfer from Approach97 to MySQL. In my company we are running Approach97 for fullfil our database need but now my boss want to make this database online. I'v heard a lot about MySQL ( Speed / Stability etc. ) but want to know that is it possible to export data from Approach97 to MySQL or Import in MySQL from Approach97 or anyother option to do this?? Awaiting helpful reply. Thanks Regards / Sulman - 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:linux innobase benchmarking and BSD problem
Hi Seung! Yes, you have to do some tuning to get the performance from a transactional database. You should not use autocommit=1, because then the database has to physically write the log segment to disk after each individual insert. Try to insert your data in a single transaction, only a single commit after the insert batch, or a few commits along the way. I understand you measured several times, doing DELETE FROM TABLE in between. Innobase uses some CPU to physically remove the delete marked records in a purge operation. DROP TABLE and TRUNCATE TABLE (in MySQL-4.0) are faster. I will also add a small optimization to auto_increment columns. Currently it executes SELECT MAX (KEY) FROM TABLE before each insert, which wastes some CPU and is not necessary. It is better cache the latest inserted key value to main memory, to the data dictionary. The FreeBSD bug is known. I will run tests on our FreeBSD machine in the next few days. Obviously there is something wrong with the FreeBSD port. Was it so that it hung and used 100 % of CPU? That has been reported also from Italy. Best regards, Heikki At 06:11 PM 3/30/01 +0900, you wrote: Hi Heikki, I have run a few test for innobase tables on linux and BSD 1. It seems that 'innobase' table was slower than 'bdb' table for 'insert' command, which is surprising(or not? o_O) 2. It may be due to that fact that I dont' know much about optimazing the 'innobase' table. Do you know how to boost the performance of 'bdb' or 'innobase table'? Please let me know...:( 3. I mainly tested the innobase table with linux, but I actually want to run mysql with 'bdb' or 'innobase' tables on FreeBSD. 4. However, mysql just hung when I tried to insert the 1 rows of data, the same data used for linux test, using 'mysql data.sql'. I used 'my-large.cnf' and changed the setting as follwings. innobase_buffer_pool_size=400M innobase_additional_mem_pool_size=20M FreeBSD setting 4.2 release #1 pentium 550, 512 RAM, mysql-3.23.35 complied with ./configure -- 1. --prefix=/usr/local/mysql --with-charset=euc_kr --with-low-memory --without-debug --without-readline --with-mysqld-ldflags=-all-static --with-mit-threads=no --with-client-ldflags=-all-static --with-innobase --with-bdb 2. --with-charset=euc_kr --with-innobase --with-berkeley-db Linux setting Redhat 6.2, kernal 2.2.14-5.0, pentium550, 128 RAM, mysql-3.23.35 complied with ./configure --with-charset=euc_kr --with-berkeley-db --with-innobase Other setting 1. The data used had three columns, 'no', 'name', 'grade' with 'no' as the primary index and auto_increament and grade as a key. There were 1 rows, and I inserted the data using 'shellmysql data.sql'. 2. Whenever I inserted the data, I simply did 'delete from table where no 0' instead of dropping the table. 2. I used 'my-medium' as 'my.cnf' 'mysql insert' benchmarking result( all times are in seconds). 1. with key, autocommit=1, flush_log_at_trx=1, all on, basic setting myisam real 5.61 real 5.10 real 5.08 innobase real 68.57 real 69.27 real 83.26 real 100.87 real 99.99 real 102.31 real 108.82 real 114.23 real 124.23 real 94.42 real 98.20 bdb real 56.83 real 43.49 real 39.76 real 54.77 real 48.75 2. with key, autocommit=1, flush_log_at_trx=1, bdb off, basic setting myisam real 4.48 real 3.01 real 3.08 real 3.08 real 3.04 innobase real 70.04 real 99.04 with innobase_buffer_pool_size=100M innobase_additional_mem_pool_size=10M real 76.60 real 80.97 real 81.52 real 107.47 3. with key, autocommit=1, flush_log_at_trx=1, bdb on bdb real 53.14 real 54.29!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=Content-Type content="text/html; charset=ks_c_5601-1987" META content="MSHTML 5.50.4522.1800" name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff DIVFONT size=2 DIVFONT size=2Hi Heikki, I have run a few test for innobase tables on linux andnbsp;BSD/FONT/DIV DIVFONT size=2/FONTnbsp;/DIV DIVFONT size=21. It seems that 'innobase' table was slower than 'bdb' table for 'insert' command, which is surprising(or not? o_O)/FONT/DIV DIVFONT size=2/FONTnbsp;/DIV DIVFONT size=22. It may be due to that fact that I dont' know much about optimazing the 'innobase' table.nbsp;/FONTFONT size=2nbsp;Do you know how to boost the performance of 'bdb' or 'innobase table'?nbsp;nbsp;Please let me know...:(/FONT/DIV DIVFONT size=2/FONTnbsp;/DIV DIVFONT size=23. I mainly tested the innobase table with linux, but I actually want to run mysql with 'bdb' or 'innobase' tables on FreeBSD./FONT/DIV DIVFONT size=2/FONTnbsp;/DIV DIVFONT size=24. However, mysql just hung when I tried to insert the 1 rows of data, the same data used for linux test,nbsp;using 'mysql lt; data.sql'.nbsp; I used 'my-large.cnf' and changednbsp;the setting asnbsp;follwings.nbsp;nbsp;/FONT/DIV DIVFONT size=2/FONTnbsp;/DIV DIVFONT
exe file for win2000
Hi again, Im looking for someone that has a win 2000 mysqld compiled with --with-raid Any one? Need it. And dont have any possibillity to compile it myself. /roger
MySQL Stats?
Does anyone know of a software package that can create stats from the MySQL logs? Something similar to Analog (for HTTP logs). Any and all help is greatly appreciated, Bill - 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
Repair Table Message
I received several of these messages when I repaired a table. Can anyone give me any insight about this message. Should I export all data to a new table or can this message be ignored? Found block with too small length at 3532; Skipped --Bill
Symbolic Links to 'data' and 'form' files not resolving properly using mysql.
Description:
I have installed MySQL version 3.23.36 (having previously used 3.23.34a)
After I restarted the daemon, I ran the mysql 'monitor' program to check on the
existing databases and tables. Mysql reported for each table: "Didn't find any fields
in table 'table-name'". This error had shown up in 3.23.34a for tables that had no
records (which, since we weren't using them, were removed, which resolved that issue).
I thought that the tables may have become 'corrupt', so I used "mysql" to
recreate/reload the tables. The 'index' files were created (and appeared to be
'filled'), but the 'data' files had only been 'created' when I recieved the error "Can
not locate file "/index/customer.MYD". "/index" is where the "customer.MYI" is located
(and pointed to by a symbolic link), while the data portion ("customer.MYD") is in
"/data" (pointed to by a symbolic link). I would assume that a bug has been
introduced where the same value of the 'realpath' call for the 'index' portion of the
f!
ile, is being re-used to locate the data portion (instead of another call to get the
'realpath' of the data portion).
How-To-Repeat:
Create a table, and place the index portion (.MYI) in one directory, and the
'form' (.frm) and data portion (.MYD) in another. Create 'symbolic' links to the
files from your "/var/databasename" directory, and restart "mysql". Also, create the
'symbolic' links first (no existing table) pointing to the 2 different directories,
and try to use 'mysql load_script' to create the actual files
Fix:
I have place all 3 parts of each table (.frm, .MYD, .MYI) in the same
directory for now (so I could use the latest version of the "mysql" engine) and
redirected all 'symbolic' links to that area.
Submitter-Id: [EMAIL PROTECTED]
Originator:root
Organization: YubbyDubby
MySQL support: none
Synopsis: MySQL 3.23.36 not resolving 'realpath' to .MYD files.
Severity: serious
Priority: medium
Category: mysql
Class: sw-bug
Release: mysql-3.23.36 (Source distribution)
Server: lt-mysqladmin Ver 8.18 Distrib 3.23.36, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.36
Protocol version10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 16 hours 10 min 27 sec
Threads: 1 Questions: 787 Slow queries: 0 Opens: 22 Flush tables: 1 Open tables:
15 Queries per second avg: 0.014
Environment:
System: Linux uxdb1 2.2.17-14smp #1 SMP Mon Feb 5 18:40:03 EST 2001 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-redhat-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:
lrwxrwxrwx1 root root 13 Sep 29 2000 /lib/libc.so.6 - libc-2.1.3.so
-rwxr-xr-x1 root root 4101836 Jan 15 07:49 /lib/libc-2.1.3.so
-rw-r--r--1 root root 20273324 Jan 15 07:49 /usr/lib/libc.a
-rw-r--r--1 root root 178 Jan 15 07:49 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql --with-berkeley-db
Perl: This is perl, version 5.005_03 built for i386-linux
-
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
joine
join - 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 message: [Incorrect information in file: './ts1/tbl_status.frm']
Received the error again this morning; I was able to copy an older copy of .frm file into tbl_status.frm (via Sinisa's response), and the problems went away; all data appears to be intact. [Largest *.MYD files is 186 mbytes *.MYI is 32 mbytes. Note that all database directories files reside on an NFS automounted file-system, and not a local disk.] Then tried to reproduce the problem interactively. mysql ALTER TABLE tbl_status RENAME tbl_status_bac; Query OK, 0 rows affected (0.02 sec) mysql ALTER TABLE tbl_status_bac RENAME tbl_status; ERROR 1033: Incorrect information in file: './ts1/tbl_status_bac.frm' Hmmm, so I restored the above .frm file again. Then shutdown the server: $ ./bin/mysqladmin -u .. -p shutdown Tried to restart, and now cannot restart the server: $ ./bin/safe_mysqld Starting mysqld daemon with databases from ... 010330 10:18:14 mysqld ended $ less var/p 010330 10:18:14 mysqld started 010330 10:18:14 /fs5/b/spicano/dev/local/mysql/libexec/mysqld: Incorrect information in file: './mysql/host.frm' 010330 10:18:14 /fs5/b/spicano/dev/local/mysql/libexec/mysqld: Normal shutdown 010330 10:18:14 /fs5/b/spicano/dev/local/mysql/libexec/mysqld: Shutdown Complete 010330 10:18:14 mysqld ended Might the NFS dependence be a problem? Silvio - 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
Need examples of companies using mysql
Now that our use of MySQL is being questioned (but they are pretty much convinced). What the higher-ups want to know is a few examples of medium to large companies using mysql for mission critical stuff. If any one can provide some I would be much appreciated. We are a financial company using mysql to back a bunch of our new fast-cgi stuff that is about to be opened to users, so anything in that genre would be all the better. Examples of generally what kinds of machines there are run on could be cool too, but by no means necessary. We are currently running on Solaris 2.7 with like, 4 processors and 4 gigs of RAM, I myself have full faith in mysql. Thanks - Ant -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) Go ahead, jump. 100,000 lemmings can't be wrong. - 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: Need examples of companies using mysql
I read that SGI (sgi.com) uses all kinds of MySQL DBMS's behind the scenes. Presumably, they're running on Irix. ;-) HTH, Jed On 3/30/01 11:48 AM, you wanted me to know this: Now that our use of MySQL is being questioned (but they are pretty much convinced). What the higher-ups want to know is a few examples of medium to large companies using mysql for mission critical stuff. If any one can provide some I would be much appreciated. We are a financial company using mysql to back a bunch of our new fast-cgi stuff that is about to be opened to users, so anything in that genre would be all the better. Examples of generally what kinds of machines there are run on could be cool too, but by no means necessary. We are currently running on Solaris 2.7 with like, 4 processors and 4 gigs of RAM, I myself have full faith in mysql. Thanks - Ant ~)~)~)~)~)~)~)~)~)~)~)~)~)~)~)~)~)~) Jed Verity Chief Technology Officer Communication Works Pier 9 Embarcadero, Suite 116 San Francisco, CA 94111 www.communicationworks.org Direct: 415-255-1946 Fax:415-255-1947 Email: [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: Need examples of companies using mysql
www.livejournal.com www.slashdot.org www.everything2.com At 02:48 PM 3/30/2001 -0500, Anthony R. J. Ball wrote: Now that our use of MySQL is being questioned (but they are pretty much convinced). What the higher-ups want to know is a few examples of medium to large companies using mysql for mission critical stuff. If any one can provide some I would be much appreciated. We are a financial company using mysql to back a bunch of our new fast-cgi stuff that is about to be opened to users, so anything in that genre would be all the better. Examples of generally what kinds of machines there are run on could be cool too, but by no means necessary. We are currently running on Solaris 2.7 with like, 4 processors and 4 gigs of RAM, I myself have full faith in mysql. Thanks - Ant -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) Go ahead, jump. 100,000 lemmings can't be wrong. - 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 - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] "It has been said that the primary function of schools is to impart enough facts to make children stop asking questions. Some, with whom the schools do not succeed, become scientists." - Knut Schmidt-Nielson - 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: Need examples of companies using mysql
Hehe, yeah, I mentioned slashdot... for some reason, they just weren't impressed :) You know the type... unless they are a big money company, then they can't be doing anything mission critical :) www.livejournal.com www.slashdot.org www.everything2.com -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) "DesqView!" ...Gesundheit. - 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: Need examples of companies using mysql
On Fri, Mar 30, 2001 at 02:56:53PM -0500, Anthony R. J. Ball wrote: Hehe, yeah, I mentioned slashdot... for some reason, they just weren't impressed :) You know the type... unless they are a big money company, then they can't be doing anything mission critical :) We use MySQL quite a lot and even manage to generate money once in a while... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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: Need examples of companies using mysql
I know that www.yahoo.com uses it somewhere... but I can't remember where I read that (probably on this list a while ago) - Original Message - From: "Anthony R. J. Ball" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 30, 2001 12:48 PM Subject: Need examples of companies using mysql Now that our use of MySQL is being questioned (but they are pretty much convinced). What the higher-ups want to know is a few examples of medium to large companies using mysql for mission critical stuff. If any one can provide some I would be much appreciated. We are a financial company using mysql to back a bunch of our new fast-cgi stuff that is about to be opened to users, so anything in that genre would be all the better. Examples of generally what kinds of machines there are run on could be cool too, but by no means necessary. We are currently running on Solaris 2.7 with like, 4 processors and 4 gigs of RAM, I myself have full faith in mysql. Thanks - Ant -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) Go ahead, jump. 100,000 lemmings can't be wrong. - 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: Need examples of companies using mysql
Greetings: We Manage Servers (http://www.wemanageservers.com/) - Their ASP-based advanced monitoring service utilizes the power of mySQL. While I don't have the institutions name, I was told by Verio Advanced they have a financial institution running mySQL. XOXO Clothes (http://www.xoxo.com/) Many others... Other: http://www.mysql.com/news/article-57.html http://www.mysql.com/news/article-51.html http://www.mysql.com/news/article-62.html Peter M. Perchansky, Microsoft FrontPage MVP Dynamic Net, Inc. Helping companies do business on the Net 109 East High Street PO Box 86 Womelsdorf, PA 19567 Voice: 1-610-589-2262 Personal Email: [EMAIL PROTECTED] Company Email: [EMAIL PROTECTED] Web:http://www.dynamicnet.net/ http://www.wemanageservers.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need examples of companies using mysql
Check this Motorola press release, it may help you... Motorola Teams With MySQL AB to Offer Tools for Developers to Create Mobile Database Applications http://www.corporate-ir.net/ireye/ir_site.zhtml?ticker=MOTscript=410layout =-6item_id=161725 - Original Message - From: "Anthony R. J. Ball" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 30, 2001 2:48 PM Subject: Need examples of companies using mysql Now that our use of MySQL is being questioned (but they are pretty much convinced). What the higher-ups want to know is a few examples of medium to large companies using mysql for mission critical stuff. If any one can provide some I would be much appreciated. We are a financial company using mysql to back a bunch of our new fast-cgi stuff that is about to be opened to users, so anything in that genre would be all the better. Examples of generally what kinds of machines there are run on could be cool too, but by no means necessary. We are currently running on Solaris 2.7 with like, 4 processors and 4 gigs of RAM, I myself have full faith in mysql. Thanks - Ant -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) Go ahead, jump. 100,000 lemmings can't be wrong. - 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 _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need examples of companies using mysql
Some MySQL Users http://www.mysql.com/documentation/mysql/bychapter/manual_Users.html#Users Regards, Ernesto Vargas - Original Message - From: "Anthony R. J. Ball" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 30, 2001 2:48 PM Subject: Need examples of companies using mysql Now that our use of MySQL is being questioned (but they are pretty much convinced). What the higher-ups want to know is a few examples of medium to large companies using mysql for mission critical stuff. If any one can provide some I would be much appreciated. We are a financial company using mysql to back a bunch of our new fast-cgi stuff that is about to be opened to users, so anything in that genre would be all the better. Examples of generally what kinds of machines there are run on could be cool too, but by no means necessary. We are currently running on Solaris 2.7 with like, 4 processors and 4 gigs of RAM, I myself have full faith in mysql. Thanks - Ant -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) Go ahead, jump. 100,000 lemmings can't be wrong. - 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 _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how can I get code example of manual?
I'd like to write a simple application with API of MySql. I see "4.4.1 A Simple Exaple" of the manual but I can't find the file "simple1.cc" that should be in my computer... but there isn't. How can install it? thank you in advance, Mario. - 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: Need examples of companies using mysql
I asked for the same things awhile back. But you got more responses then I did! I got the yahoo address from Jeremy D . Zawodny http://biz.yahoo.com/ne.html Thanks Jeremy, its a good site At 02:48 PM 3/30/2001 -0500, you wrote: Now that our use of MySQL is being questioned (but they are pretty much convinced). What the higher-ups want to know is a few examples of medium to large companies using mysql for mission critical stuff. If any one can provide some I would be much appreciated. We are a financial company using mysql to back a bunch of our new fast-cgi stuff that is about to be opened to users, so anything in that genre would be all the better. Examples of generally what kinds of machines there are run on could be cool too, but by no means necessary. We are currently running on Solaris 2.7 with like, 4 processors and 4 gigs of RAM, I myself have full faith in mysql. Thanks - Ant -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) Go ahead, jump. 100,000 lemmings can't be wrong. - 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
How compile a C/C++ program which use API for mysql?
I have write a simple program in C/C++. this program use API for Mysql (linux) the question is : How to compile this programs? Tank you in advance, Mario. - 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: Need examples of companies using mysql
My company is using it for all database functions. We're an online
'collection' agency and have been using it for the past 6 months (versions
3.22.23 upgraded to 3.23.36). In comparison with Borland's
"Interbase" ("Ibase"), which I supported at the late "Money Store"
corporation for all 100 of it's branches and central databases, it's far
superior (especially with the fact that you can relocate the physical files to
different storage devices via symbolic links, though I just reported a bug
with the latest version of MySQL in doing just that...).
Unless you're going to have a LOT of users accessing a HUGE database, the
system you've outlined below will be overkill (do you have any current usage
statistics ? Are you using the system (is it an E450 ?) for any other
applications/processes ?).
Our database is still pretty small, and ends up entirely in the 1 gig of RAM
we have installed in the server (so disk layout/access is not an issue yet)
but if you grow larger than that, you'll want to focus on the drive layout
and datafile locations (if you DO have an E450, make sure you have extra
SCSI controller cards installed, and spread the drives across their 'paths')
such as placing the data portion (*.MYD) on one set of drives, the 'index'
portion (*.MYI) on another, and any 'temp' files (use the $TEMP variable) on
another...
We're using Compaq 1850R's with dual Pentium2 processors and a gig of RAM
each. The MySQL datafiles are spread across the drives in an exteral Compaq
storage array (so the either of the 2 systems can 'grab' the array and take
over the database functions in case of failure, or during maintanence/upgrade
periods of one of the systems)
"Anthony R. J. Ball" wrote:
Now that our use of MySQL is being questioned (but
they are pretty much convinced). What the higher-ups
want to know is a few examples of medium to large
companies using mysql for mission critical stuff.
If any one can provide some I would be much appreciated.
We are a financial company using mysql to back a bunch
of our new fast-cgi stuff that is about to be opened to
users, so anything in that genre would be all the better.
Examples of generally what kinds of machines there are
run on could be cool too, but by no means necessary.
We are currently running on Solaris 2.7 with like,
4 processors and 4 gigs of RAM, I myself have full
faith in mysql.
Thanks - Ant
--
___ __ ____ _ _ _ _
/ __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _)
\__ \ )(__)( /(__)\\ / )__)) ( )__) )(
(___/(__)(__)(__)\/ ()()(_)\_)() (__)
Go ahead, jump. 100,000 lemmings can't be wrong.
-
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: Need examples of companies using mysql
If he is talking about the Samples that come with Paul DuBois book MySQL thay are at: http://www.mysql.com/Downloads/Contrib/Examples/samp_db.tar.gz Jason Maderios -Original Message- From: Mike Roberts [mailto:[EMAIL PROTECTED]] Sent: Friday, March 30, 2001 5:21 PM To: Anthony R. J. Ball Cc: [EMAIL PROTECTED] Subject: Re: Need examples of companies using mysql I asked for the same things awhile back. But you got more responses then I did! I got the yahoo address from Jeremy D . Zawodny http://biz.yahoo.com/ne.html Thanks Jeremy, its a good site At 02:48 PM 3/30/2001 -0500, you wrote: Now that our use of MySQL is being questioned (but they are pretty much convinced). What the higher-ups want to know is a few examples of medium to large companies using mysql for mission critical stuff. If any one can provide some I would be much appreciated. We are a financial company using mysql to back a bunch of our new fast-cgi stuff that is about to be opened to users, so anything in that genre would be all the better. Examples of generally what kinds of machines there are run on could be cool too, but by no means necessary. We are currently running on Solaris 2.7 with like, 4 processors and 4 gigs of RAM, I myself have full faith in mysql. Thanks - Ant -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) Go ahead, jump. 100,000 lemmings can't be wrong. - 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: linux innobase benchmarking and BSD problem
In the last episode (Mar 30), Heikki Tuuri said:
The FreeBSD bug is known. I will run tests on our FreeBSD machine in
the next few days. Obviously there is something wrong with the
FreeBSD port. Was it so that it hung and used 100 % of CPU? That has
been reported also from Italy.
I have a similar problem, on FreeBSD 5 (i.e. -current). I can insert
records one at a time with no problem, but if I try to update more than
~250 records at a time, it hangs, consuming 100% cpu. gdb'ing a corefile of
the process, it looks like a mutex/spinlock problem of some sort.
Deleting records dies if I delete between 100 and 150 records in one
go. Does innobase create a mutex for each record processed? Maybe
there's a limit on 256 held mutices per thread on FreeBSD or something.
-- mysqld hung on "insert into temp (value) select ip from iptable limit 300":
(gdb) thread apply all bt
Thread 1 (process 764):
#0 0x28288163 in _get_curthread ()
at /usr/src/lib/libc_r/uthread/uthread_kern.c:1145
#1 0x28280064 in _spinlock_debug (lck=0xbfaa9ecc,
fname=0x28280138
"\203─\020\205└\017\2055 \213\205ⁿ■ \213U\b\211B\004\213E\f\211B\b\213E\020\211B\f\215Ñ╪■ [^_\211∞]├$FreeBSD:
src/lib/libc_r/arch/i386/_atomic_lock.S,v 1.3 1999/08/28 00:03:01 peter Exp $",
lineno=149551536)
at /usr/src/lib/libc_r/uthread/uthread_spinlock.c:83
#2 0x282854d6 in mutex_trylock_common (mutex=0xbfaa9ecc)
at /usr/src/lib/libc_r/uthread/uthread_mutex.c:311
#3 0x28285712 in __pthread_mutex_trylock (mutex=0x8ea3090)
at /usr/src/lib/libc_r/uthread/uthread_mutex.c:441
#4 0x8193d4b in mutex_spin_wait (mutex=0x8ea308c) at ../include/os0sync.ic:38
#5 0x8126ead in srv_master_thread (arg=0x0) at ../include/sync0sync.ic:220
#6 0x2827f18c in _thread_start ()
at /usr/src/lib/libc_r/uthread/uthread_create.c:326
#7 0x0 in ?? ()
(gdb)
-- mysqld hung on "delete from temp limit 150":
(gdb) info threads;
* 1 process 26111 0x28361b54 in gettimeofday () from /usr/lib/libc.so.5
(gdb) where
#0 0x28361b54 in gettimeofday () from /usr/lib/libc.so.5
#1 0x28280949 in _thread_sig_handler (sig=0, info=0x828a660, ucp=0x282808d1)
at /usr/src/lib/libc_r/uthread/uthread_sig.c:93
#2 0xbfbfffac in ?? ()
#3 0x28287ffb in _thread_kern_sig_defer ()
at /usr/src/lib/libc_r/uthread/uthread_kern.c:1049
#4 0x282854bf in mutex_trylock_common (mutex=0x0)
at /usr/src/lib/libc_r/uthread/uthread_mutex.c:308
#5 0x28285712 in __pthread_mutex_trylock (mutex=0x8ea3210)
at /usr/src/lib/libc_r/uthread/uthread_mutex.c:441
#6 0x8193d4b in mutex_spin_wait (mutex=0x8ea320c) at ../include/os0sync.ic:38
#7 0x8165a84 in buf_page_get_gen (space=0, offset=6, rw_latch=2, guess=0x0,
mode=10, mtr=0xbfaa95d0) at ../include/sync0sync.ic:220
#8 0x81576d9 in trx_purge_truncate_rseg_history (rseg=0x8ebd10c,
limit_trx_no={high = 0, low = 7946}, limit_undo_no={high = 0, low = 0})
at ../include/trx0rseg.ic:25
#9 0x8157bdd in trx_purge_truncate_history () at trx0purge.c:545
#10 0x81589c7 in trx_purge_fetch_next_rec (roll_ptr=0xbfaa9ee4,
cell=0x8ec016c, heap=0x8ebfe0c) at trx0purge.c:564
#11 0x813a2b6 in row_purge (node=0x8ec0134, thr=0x8ec00d4) at row0purge.c:481
#12 0x813a4fe in row_purge_step (thr=0x8ec00d4) at row0purge.c:548
#13 0x8129aa2 in que_run_threads (thr=0x8ec00d4) at que0que.c:1223
#14 0x8158f95 in trx_purge () at trx0purge.c:1050
#15 0x8126fb5 in srv_master_thread (arg=0x0) at srv0srv.c:1901
#16 0x2827f18c in _thread_start ()
at /usr/src/lib/libc_r/uthread/uthread_create.c:326
#17 0x0 in ?? ()
(gdb)
--
Dan Nelson
[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: Mysql in a 4-way / 2 GByte server / raid 5
Hi All, On Tue, Mar 27, 2001 at 02:28:05PM +0100, Rafael Martinez wrote: I am thinking to install our DB server in a 4-way machine with Intel Xeon processors/1MB cache. I can see in the mysql documentation that mysql works OK in a 2-way machine but that in a 4-way system has to be tested. Is this true? Or the documentation is not updated? Anybody out there with a 4-way machine that runs mysql without problems? (kernel 2.4.x glibc 2.2.12) Yes. On a quad Xeon 500, 512kB cache with 3GB of memory, Dell PERC 2/DC (AMI Megaraid 1500 elite, I believe), 128MB battery backed cache in write through mode, six 9Gb 10krpm disks in a raid5 with 128kB chunks, running 2.4.2 Uptime: 226134 Threads: 102 Questions: 368839757 Slow queries: 252 Opens: 30433 Flush tables: 127 Open tables: 336 Queries per second avg: 1631.067 ...the machine barely breaks into a sweat. Note that the figure 1631 q/s is averaged over the last couple of days. In (exhaustive - I was leery of 2.4.x) testing, I managed to get this machine digesting over six thousand *inserts* per *second* at one stage, with the (four) perl+DBI scripts running on the same box! Investigate using lvm on the box - being able to take regular (eg. hourly!) self-consistent lvm snapshots of the database with a swift `FLUSH TABLES WITH READ LOCK' quickly becomes indispensable. Also, being able to stop the database, make a snapshot of the data, blow away the binary update logs and restart the database in less than one second makes setting up and resyncing slaves trivial. Finally, consider reiserfs. It seems to be a smidgin faster than ext2. ATB, Wesley. - 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: Need examples of companies using mysql
Not sure how much use to you it would be, but my employers, Dexterus Ltd, trust my judgement enough to have adopted my recommendation to use MySQL as an "embedded" DBMS in our smallscale PC-based systems. It has been deployed in a "farm" of PC's running Linux to co-ordinate virus scanning of email, and we are using it in a number of internal systems for fault logging, change request management and project accounting. Dexterus (www.dexterus.com) is a VC-funded company set up to provide application services to the banking industry in the City of London. While we are still in the pre-launch stages (we launch Tuesday!), we are aiming for a 99.999% SLA service agreement, so our systems *have* to be reliable. Now, if I can just figure out a mirroring/failover setup for MySQL, I could shut the Oracle types up for good - OPS is really rather *too* heavyweight for what we need! :-) On Fri, 30 Mar 2001, Peter M. Perchansky wrote: Greetings: We Manage Servers (http://www.wemanageservers.com/) - Their ASP-based advanced monitoring service utilizes the power of mySQL. While I don't have the institutions name, I was told by Verio Advanced they have a financial institution running mySQL. XOXO Clothes (http://www.xoxo.com/) Many others... - 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: Need examples of companies using mysql
Greetings Steve: At 12:01 AM 3/31/2001 +0100, Steve Allsopp wrote: "Dexterus (www.dexterus.com) is a VC-funded company set up to provide application services to the banking industry in the City of London. While we are still in the pre-launch stages (we launch Tuesday!), we are aiming for a 99.999% SLA service agreement, so our systems *have* to be reliable. Now, if I can just figure out a mirroring/failover setup for MySQL, I could shut the Oracle types up for good - OPS is really rather *too* heavyweight for what we need! :-)" I'm not sure if it helps or even applies, but Verio and other companies (including ours) have been using the advanced server monitoring at http://www.wemanageservers.com/ to handle SLA reporting and compliance. Peter M. Perchansky, Microsoft FrontPage MVP Dynamic Net, Inc. Helping companies do business on the Net 109 East High Street PO Box 86 Womelsdorf, PA 19567 Voice: 1-610-589-2262 Personal Email: [EMAIL PROTECTED] Company Email: [EMAIL PROTECTED] Web:http://www.dynamicnet.net/ http://www.wemanageservers.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replace strings
Rol wrote: Hallo all, A table containing some text needs to have some of the letters changed (eg. letter to be replaced with "auml;" ). Is there a way to use a replace function to search for such chararcters in a text and then replace it with the html tag? Yes of course and this function is called "REPLACE()". Check the manual :) Just HTML stuff you should handle yourself. Database does not need to know about HTML but replacing one string with another is common. -- MySQL Security Administrator __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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: Need examples of companies using mysql
How are you supposed to convince people that MySQL is a worthy DBMS with boring testimonials about millions of dollars worth of dataflow and incredible fault tolerance? If you REALLY want to sell MySQL, point them to http://m4m4sex.com/, a web site that is dedicated to helping men find men for real sex encounters right now! This efficient sex-finding site is made possible by the awesome power of MySQL! Now THAT's something to tell the suits about! Seriously, I'm totally suprised at how well MySQL can handle the load. We definitely made the right choice when we picked the database system. [ PS. I don't own the site, I just implemented it ] -- Michael Bacarella [EMAIL PROTECTED] Technical Staff / System Development, New York Connect.Net, Ltd. - 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
multiple instances and initial password
Two things that I am sure will be answered very quickly. 1) I have a development box that I have successfully installed and configured 3 seperate instances. Each instances has its own port number. When playing around with mysqladmin I know I can specify the port number as an option, but what I cannot figure out is how to change the password. What is the default password that is used whenever the tables are created for root? 2) second what is the syntax for changing that blasted password. Thanks for the patience, Kris (aka: unixboy _ Get your FREE download of MSN Explorer at http://explorer.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: multiple instances and initial password
On Fri, 30 Mar 2001, Kristopher Briscoe wrote: Two things that I am sure will be answered very quickly. 1) I have a development box that I have successfully installed and configured 3 seperate instances. Each instances has its own port number. When playing around with mysqladmin I know I can specify the port number as an option, but what I cannot figure out is how to change the password. What is the default password that is used whenever the tables are created for root? the empty string '' 2) second what is the syntax for changing that blasted password. since root initially doesn't have a passwd, you set it with: mysqladmin password 'THE+NEW+PASSWORD' But changing it for a user that already has one is: mysqladmin -p password 'THE_NEW_PASSWORD' and this time you'll be prompted for the old passwd for the change to take place. Thanks for the patience, Kris (aka: unixboy Kris_aka:_unixboy, I think you should do the unix approach: read the manual. regards, thalis -- No excellent soul is exempt from a mixture of madness. -- Aristotle - 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: multiple instances and initial password
Two things that I am sure will be answered very quickly.
1) I have a development box that I have successfully installed and
configured 3 seperate instances. Each instances has its own port
number.
When playing around with mysqladmin I know I can specify the port
number as
an option, but what I cannot figure out is how to change the password.
What is the default password that is used whenever the tables are created
for root?
it's null, you can login as root with no password initially
2) second what is the syntax for changing that blasted password.
update user set password=password('changeme') where user='root';
-
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
mysq.sock ownership problem
Hi, We have been encountering a problem running mysql on sgi. We normally run it as a normal user, which writes the file /tmp/mysql.sock. However, when the machine is rebooted while the daemon is running, the mysql.sock file's ownership will change to root. After that we can no longer start the server as the normal user because it cannot overwrite the existing mysql.sock file. Btw, we are running 3.22.26a for Irix6.5. Is it a bug that has been fixed?Thanks. - 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
More examples of very large organisations using mysql
want to know is a few examples of medium to large companies using mysql for mission critical stuff. I too am in a similar situation, needing links to large organisations on mySQL. This would help me to replace the largest-ever (proposed) deployment of MSSQL (as per the official release of MicroSoft) for establishing democratic decentralisation in a project in India (state of Kerala). The issues against MS are mainly ethical ones, and those relating to siphoning off well-earned public funds. The setup would eventually include services in the social (incl educational, health, justice and security) and economic (incl revenue and industrial) sectors of public governance and would be made available to all nations or states to introduce IT for effective democratisation (needless to add, for free). - 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: mysq.sock ownership problem
At 5:56 PM -0800 3/30/01, Guo, Zhian wrote: Hi, We have been encountering a problem running mysql on sgi. We normally run it as a normal user, which writes the file /tmp/mysql.sock. However, when the machine is rebooted while the daemon is running, the mysql.sock file's ownership will change to root. After that we can no longer start the server as the normal user because it cannot overwrite the existing mysql.sock file. Btw, we are running 3.22.26a for Irix6.5. Is it a bug that has been fixed?Thanks. This may be a bug, but it doesn't sound like a MySQL bug. If you're running the server as a normal user, there should be no way that it could possibly change the ownership of the socket to root. Are you sure something else isn't doing that? -- 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
question...
I am interesting in develop tools, for plataforms,like PHP, Linux, Apache, etc... but I have a Sistem, with Clipper, and I need know, if MySQL supports, NTX indexs, is very important, for me,know this, Can you help me please... Atte: Aarón Reyes __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text - 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 compile a C/C++ program which use API for mysql?
Make sure you have installed the MySql-shared package At the command prompt type gcc -lmysqlclient -I/usr/include/mysql file.c where file.c will be file that contains the C APIs Best Of Luck Shambhu. _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
email only two columns
Dear All, Is it possible to mail only three columns from a database ? Third column being email ID? I need to send email to all with a valid email ID in a database. Thanks Regards Prasad - 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
Q: How to set autocommit=0 while shellmysql datablse data.sql
Hi, everybody, I have a couple of quesitons 1. From the mysql manual, if I want to use 'autocommit=0', it says that I type 'set autocommit=0' and this only applies to a session. So, when I want to back up data using 'shellmysql datablse data.sql', do I need to add 'set autocommit=0' at the begining of data.sql? 2. Is there a way to change the default value of 'autocommit' whenever mysql starts? Like 'set-variable = autocommit = 0' in 'my.cnf'. Also, how can I know the mysql is using 'autocommit=0 or 1' since there is no mysql command that shows that particular info, or since 'set autocommit=0 or 1' is session based, we reset the 'autocommit' at each session. Yours Ryu
error: no suitable driver
we are having no suitable driver error. Please help us to get rid off this problem. we are having SunOS 5.7+tomcat webserver+mysql 3.23.32. thanks, naveen
Re: Error
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 What did you do to get the error Adrian On Fri, 30 Mar 2001, Lebrun Jonathan wrote: What's error 1062 ? Thanks. -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.2 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE6xYp3/f1mUNueu/oRAqP4AJ0Z0So1MmNobXAD+AxXRi4nWgigoACfYvhO erKMiznCDqCPMBUIyzOh+EQ= =gYyX -END PGP SIGNATURE- - 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 on mysql tables
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 What are the results you expect. There are always workarounds Adrian On Fri, 30 Mar 2001, Ramasamy Palaniappan wrote: Sir, created the following tables as primary and secondary primary : partycode(primary key),partyname secondary : partycode(references to primary),companyname select partycode,companyname from secondary where partycode=(select partycode from primary where partyname=""); as per mysql - the above query returns the syntax error. please send the correct syntax and also the below query select partycode,companyname from secondary where partycode='select partycode from primary where partyname=""'; if we try to execute the above code, it returns an empty set even if the values are there in the table. I am expecting the reply sir. regards palani _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.2 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE6xYov/f1mUNueu/oRArvuAKCDVWBl1pm9xlRbzsOKnV3C9C90QQCaApCE nUJ7VOTiTtjYbaNmd8gwrtQ= =xL3I -END PGP SIGNATURE- - 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 at start mysql
Dear: I can not start mysql server. There is an error when I start mysql using :mysqld start or safe_mysqld The error is : Can not connect to 'localhost' throught ~/mysql.sock Please check is file ~/mysql.sock exist! I checked the file, it exists, but it have zero byte. And my linux is Redhat7.0 , hostname is localhost. Can you help me start mysql in my machine? Thanks for your help! tomzhang 2001.3.31
