RE: MySQL running out of date
As per the manual that is correct. The only correct date will be 1996-02-31. what is the problem? -Original Message- From: Hans van Harten [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 4:09 PM To: [EMAIL PROTECTED] Subject: MySQL running out of date Some make the laughing stock of MySQL with this code: create database data_test ; use data_test; create table test3 (a date); insert into test3 values (-1); insert into test3 values ('1996-02-31'); insert into test3 values ('1996-67-31'); select * from test3; I ran it on MYSQL-4.10-max and was not amused. Anyone to comment?? HansH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Oracle DBA here looking for advice on MySQL ....
Just look at amazon. There are more books popping up all the time. The manual with user comments is the best. http://www.mysql.com/doc/en/ Paul DuBois wrote a good book that helped me get started on a few things. This one is a newer one I think. http://www.amazon.com/exec/obidos/tg/detail/-/0735709211/ref=pd_sim_books_1/ 103-1999417-1493463?v=glances=books or for 4.0 by Ian Gilfillan http://www.amazon.com/exec/obidos/tg/detail/-/0782141625/ref=pd_sbs_b_1/103- 1999417-1493463?v=glances=books opinion per 1st reply I've noticed a lot of Oracle people don't like MySQL for one reason or another. I don't understand why that is, but in my opion MySQL is easier, faster and more fun to use. Granted there are not as many features available in MySQL, but having the ability to create my own solutions to problems is what I enjoy most about it. That's the reason I became a programmer, not an app user. /opinion per 1st reply Brian -Original Message- From: Andy Jackman [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 19, 2003 2:29 AM To: Johnson, Michael Cc: MySQL Users Subject: Re: Oracle DBA here looking for advice on MySQL I've used a lot of Oracle, some MS Access and I'm newish to MySQL. I found it easy to write an abstraction layer for Ms Access and Oracle despite their different approaches to some important things. I find MySQL very sparse by comparison and I spend more time working round the db than working with it. Unlike Oracle the richness and integrity of language is simply missing - these people have lived without something as useful as sub-queries for a long time. (The argument being that speed and data integrity are all-important). It's more a file system than a relational database. I know you asked about books rather than a comparison of the products, but the software philosophy is reflected in the documentation. If someone else pays you to be an Oracle Dba then I bet you have at least a 10 foot shelf of comprehensive documentation. This list is about as good as it gets (see your previous response). There is a PDF copy of the manual somewhere and setting up MySql was accompilshed by a colleague who wouldn't have known where to start with Oracle, so it has that in its favour. So, if you're thinking of migrating, think carefully! If I could get Oracle to give me a sensible price (say USD 1000) to sell their db with my product I would be out of here so fast. So far with mySQL i've written my own database for a particular (simple) structure that it wouldn't handle to my satisfaction; I've written my own date/time routines to calculate things like seconds between 2 datetimes (despite a wealth of datatime functions, this one isn't available unless you convert to 'Unix' dates which expire in 2036) and I've written functions to handle the fact that in 'C' all data is returned as strings rather than as native data types. Sigh. - Andy Johnson, Michael wrote: What is the best book on MySQL with regard to its Architecture and how it starts up, shutdowns, processes queries, rolls back data, etc etc. ? I am not looking for a SQL book here. What is the best My SQL book you have read ? Thank you in advance. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: max clients
http://www.mysql.com/doc/en/Linux.html If you are using Linux, you need to read this section. You can get up to 4096 connections minus a few for the server admin threads. Did this a while back and works well. I don't know if any of these issues have been resolved in the Kernel or LinuxThreads yet. However, you can see from some MS SQL Server, and Oracle benchmarks, that you can have 20,000+ connections which sounds cool, till you read the fine print and see each query takes over 5 minutes! I don't remember where I read that, but it was posted on slashdot a while back. Hope that helps. Brian -Original Message- From: NEWMEDIAPLAN [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 1:46 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: max clients Hi Jeremy I'm planning to use a dual xeon 2.8Ghz and 6/8 gb ram on the database server. Redhat 9 is the o.s. Applications (perl dbi) will reside on other boxes. What hw/o.s. are you using? Can you send me your variables (max connections etc.) ... just for a check ;) Thanks!! |-Original Message- |From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] |Sent: Thursday, July 31, 2003 11:36 PM |To: NEWMEDIAPLAN |Cc: [EMAIL PROTECTED] |Subject: Re: max clients | | |On Thu, Jul 31, 2003 at 08:36:02PM +0200, NEWMEDIAPLAN wrote: | Can mysql handle 5000 concurrent webusers sending queries to the |db through | a web search engine. | Is it possible (with a very big server/hw) ? | |What OS are you using? And how much hardare? |-- |Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! |[EMAIL PROTECTED] | http://jeremy.zawodny.com/ | |MySQL 4.0.13: up 21 days, processed 679,998,992 queries (359/sec. avg) | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: store video file into MySQL database server
Why not change VIDEO - VIDEO_PATH and just use the directory path as a varchar() field to point you to the file stored on your computer. That way you don't have to worry about it. Whenever I need to use images or large files of some type, I just put it in a directory and reference the path to it. like this... INSERT INTO GAME GAME_ID, GAME_NAME, VIDEO_PATH VALUES(2, 'Termonator2', '/tmp/tm.mpg'); That leaves you to handle opening it or viewing it in your own code when you query though. HTH Brian -Original Message- From: Steven Wu [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 2:04 PM To: [EMAIL PROTECTED] Subject: store video file into MySQL database server Hi Need emergency help: I am doing some project use the MySQL to store the video file. The format of video is either avi or mpg. However I can not successfully insert the video file into the cooresponding field of a table by using the LOAD_FILE function. Does anyone know how to store video into MySQL database server ? Please help me, thank you in advance. The following is my table and SQL code. CREATE TABLE GAME ( GAME_ID INTEGER NOT NULL PRIMARY KEY, GAME_NAMEVARCHAR (20), VIDEO LONGBLOB ); INSERT INTO GAME GAME_ID, GAME_NAME, VIDEO VALUES(2, 'Termonator2', LOAD_FILE(/tmp/tm.mpg); My email is [EMAIL PROTECTED] Steven Wu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql.sock doesn't exist
OK. I sent to you once on the list, and to the original poster, but it was returned from his email server (who knows). Here it goes. The most probable reason reason that file is not there is permissions. When mysqld starts (under user mysql or mysqld) it writes the file in the directory specified by the my.cnf file. If the my.cnf file says path-to-unix-sock=/var/lib/mysql/mysql.sock, the user that is starting the server has to have write permissions in that directory. Otherwise it will not create the file and die. Make sure that the user who starts the server has write permissions in the directory. A simple ls -l will tell you. I hope this can fix your problem, it seems you've been stuck on this quite a while. Good Luck Brian -Original Message- From: John Nichel [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 8:25 AM To: [EMAIL PROTECTED] Subject: Re: mysql.sock doesn't exist Kevin H. Phillips wrote: Well, the find / -name mysql.sock didn't return anything at all so this *is* an odd predicament. Would it work if someone with a similar version e-mailed me a copy of their mysql.sock file? Kevin John Nichel wrote: It doesn't look as if you have any conflicting MySQL versions. When the server is running, have you looked for the socket (someone may have already asked you this, but I'm running out of ideas)? find / -name mysql.sock mysql.sock isn't a 'file' in the normal sense of the word. It's more like a symbolic link to the socket which is bound to the the port MySQL is listening on (so to speak). It can't really be sent to you, as it has to be generated when the server starts up. Let me recap what we've done here so that hopefully someone will reconize the problem for you... MySQL is running (verified with a ps -ax) mysql.sock does not exist cannot shutdown server, even as root What's the permissions on the /var/lib/mysql directory, and what user/group is the mysql daemon set to run as in your my.cnf file? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql.sock doesn't exist
check that the permissions in the data directory are correct. If mysqld does not have write perms in that directory, it will not start. ls -l /var/lib/mysql mysql_install_db used to set the permissions to the user that ran the script (usually root). -Original Message- From: John Nichel [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 9:26 AM To: Kevin H. Phillips Cc: [EMAIL PROTECTED] Subject: Re: mysql.sock doesn't exist Kevin H. Phillips wrote: Yes, the server is running. One odd thing about my setup is that when I restart the service I get a Failed signal for the shutdown phase but an OK for the start phase. Thanks, Kevin Victor Pendleton wrote: Is the mysql server currently running? You can also use either -S or --socket to specify the socket connection. If you get a failed when the script is stopping the server, it's more than likely that the server is dying right after it's started. When you think it's running do a ps -ax | grep mysqld If that doesn't return anything (or it only returns the grep), then the server isn't running. Check your logs to see why it's dying. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Install PHP with MySQL
yes... it seems that you do not have mysql in the PHP module. you can use --with-mysql in the php configure, but you should use --with-mysql=/your/mysql/directory PHP has included code for the default mysql build. try to use your own libs and headers. HTH brian sql, query, mysql On Thursday 05 December 2002 08:28, Bryant Hester wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kenneth, I would download the source packages from php.net and explicitly compile the mysql options into PHP. As an alternative, you can look for the mysql-php library rpms on rpmfind.net. My linux webserver (running apache and PHP 4.1.2) has php-mysql-4.1.2-7.i386.rpm, and I am sure that there is a comparable rpm package for your version. HTH, Bryant Hester - -Original Message- From: Kenneth Illingsworth [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 7:50 AM To: Subject: Install PHP with MySQL I recently installed the following RPM's: MySQL-3.23.41-1a.s390.rpm MySQL-devel-3.23.41-1a.s390.rpm MySQLclient9-3.23-22-6a.s390.rpm MySQL-server-3.23.41-1a.s390.rpm Afterwards, I was able to start the mysqld daemon ok and install an application I downloaded for a demonstration of the viability of the Linux VM on s390 platform. The application url is http://epayroll.sourceforge.net/ and it required mysql v3,22x or higher, Apache running as a webserver, and PHP v4.0.2 or higher (mine is v4.0.6). However, when I finally attempted to log into this application, I got the following error: Fatal error: Call to undefined function: mysql_connect() in /var/www/html/eps/datacon.php on line 14 I contacted the author of this application who suggested that I reinstall PHP with the mysql option enabled. Towards that end, I downloaded and installed the php-mysql-4.0.6-15.s390.rpm file. Unfortunately I got the same error. I am somewhat certain that the author of this application was on the right track. Would anyone on this forum care to offer me any direction on this matter? Thank you in advance for your time. - - 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 -BEGIN PGP SIGNATURE- Version: PGPfreeware 7.0.3 for non-commercial use http://www.pgp.com iQA/AwUBPe9ij0lWu7/HFp4nEQIdAwCgpmddOCcEdtpTQTR4oYV3YfRnCrUAn1AH psNBnvk4dbfG81g0CEQdSoQU =t/gi -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 - 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: RE: thread compile error on MySQL 4.0
here I hope this will get into your mailing list query query query query query query query query query query query query query query query query query query I am having a small problem compiling V4.0 on RedHat 6.2. At the end of the make process, it dumps out with undefined references to some functions in the thread library. I'm sorry that I cannot paste the exact error. I'm on a windows box. I saw a few days back in the archives that someone had the same error, and the next in thread said it was fixed with help from a previous reply, but I cannot find that message. It seems that the thread library is not included correctly some where. any help would be appreciated thank you brian austin - 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