function question
Hi, I'm just wondering is there a function instead of update to overwrite data that has expired?? Or can mysql automatically deletes records or rows that has expires just like cookies delete themselves after expiring. Thanx for the info Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
join error
Hi, I think this is an error, anyways i'm trying to join 6 tables together. and when i do EXPLAIN SELECT i get the message in comments Impossible WHERE noticed after reading const tables this is my statment basically SELECT table1.id FROM table1,table2,table3,table4,table5,place WHERE table1.col1 BETWEEN 150 AND 196 AND table1.col2 BETWEEN 50 AND 77 AND table1.col3 IN ( 2 ) AND table2.col1 IN ( 3 ) AND table2.col2 IN ( 14 ) AND table2.col3 IN ( 3 ) AND table3.col1 IN ( 1 ) AND table3.col2 IN ( 1 ) AND table3.col3 IN ( 04 ) AND table4.col1 IN ( 3 ) AND table4.col2 IN ( 2 ) AND table4.col3 IN ( 1 ) AND table5.col1 IN ( 1 ) AND table5.col2 IN ( 1 ) AND table5.col3 BETWEEN 18 AND 41 AND place.longitude BETWEEN - 100.310005083878 AND - 91.6899949161224 AND place.latitude BETWEEN 66 AND 29.385577346152 AND 3963 * ( acos( sin( radians( place.latitude ) ) * sin( radians( 33.00 ) ) + cos( radians( place.latitude ) ) * cos( 33.00 ) * cos( radians( - 96.00 - place.longitude ) ) ) ) = 250 AND table1.id = table2.id AND table2.id = table3.id AND table3.id = table4.id AND table4.id = table5.id AND table5.id = place.id Any help is appreciated. Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: join error
Hi, I saw the error. For interested it is in the place.latitude BETWEEN section Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
4.1 Download
Where/how can I get a copy of 4.1? Thanks, Anthony sql,query,queries,smallint - 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
[Fwd: 3rd Attempt: Fwd: Access Denied (1045)]]
Any thoughts with regards to the problem outlined below would be appreciated! Thank You, Anthony Original Message Subject: 2nd Attempt: Fwd: Access Denied (1045)] Date: Fri, 18 Oct 2002 06:59:21 -0400 From: Anthony W. Marino [EMAIL PROTECTED] To: [EMAIL PROTECTED] I'm boxed in a corner and would appreciate some suggestions, please! Thank You, Anthony Original Message Subject: Access Denied (1045) Date: Tue, 15 Oct 2002 08:47:05 -0400 From: Anthony W. Marino To: [EMAIL PROTECTED] Ive searched about and still haven't been able to resolve my problem. Scenario: 1) OS is RH 7.3. 2) Installing MySQL 4.04-Pro binary tarball. 3) Ordinary user, userX.grpX, is installing tarball themselves on a shared server accessed via telnet. 4) This installation will be userX's instance only, however, there are other MySQL server's running at this site. 5) All directories/files for this installation/implementation are owned by userX.grpX who has non-root access. 6) Modified my.cnf with unique values including port, socket, bind-address, relevant paths and values so as not to step on other installations/implentations. 7) my.cnf is passed through mysqld_safe using --defaults-file= option. 8) mysql_installdb is run. 9) mysql.server is run. Results: 1) mysqld runs with the following log snippets: Error Log: Warning: One can only use the --user switch if running as root. mysqld Log: /unique-path-to-userX-installed-mysql/bin/mysqld, Version: 4.0.4-beta-log, started with: Tcp port: 3307 Unix socket: /unique-path-to-userX-area/temp/mysql.sock 2) When the user tries to run mysql, mysqladmin and etc the following error message is received: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO). Please note that no passwords have been setup as of yet because we can't get pass the access issue. Thank You In Advance! Anthony - 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 To unsubscribe, e-mail Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
2nd Attempt: Fwd: Access Denied (1045)]
I'm boxed in a corner and would appreciate some suggestions, please! Thank You, Anthony Original Message Subject: Access Denied (1045) Date: Tue, 15 Oct 2002 08:47:05 -0400 From: Anthony W. Marino [EMAIL PROTECTED] To: [EMAIL PROTECTED] Ive searched about and still haven't been able to resolve my problem. Scenario: 1) OS is RH 7.3. 2) Installing MySQL 4.04-Pro binary tarball. 3) Ordinary user, userX.grpX, is installing tarball themselves on a shared server accessed via telnet. 4) This installation will be userX's instance only, however, there are other MySQL server's running at this site. 5) All directories/files for this installation/implementation are owned by userX.grpX who has non-root access. 6) Modified my.cnf with unique values including port, socket, bind-address, relevant paths and values so as not to step on other installations/implentations. 7) my.cnf is passed through mysqld_safe using --defaults-file= option. 8) mysql_installdb is run. 9) mysql.server is run. Results: 1) mysqld runs with the following log snippets: Error Log: Warning: One can only use the --user switch if running as root. mysqld Log: /unique-path-to-userX-installed-mysql/bin/mysqld, Version: 4.0.4-beta-log, started with: Tcp port: 3307 Unix socket: /unique-path-to-userX-area/temp/mysql.sock 2) When the user tries to run mysql, mysqladmin and etc the following error message is received: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO). Please note that no passwords have been setup as of yet because we can't get pass the access issue. Thank You In Advance! Anthony - 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 To unsubscribe, e-mail Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Access Denied (1045)
Ive searched about and still haven't been able to resolve my problem. Scenario: 1) OS is RH 7.3. 2) Installing MySQL 4.04-Pro binary tarball. 3) Ordinary user, userX.grpX, is installing tarball themselves on a shared server accessed via telnet. 4) This installation will be userX's instance only, however, there are other MySQL server's running at this site. 5) All directories/files for this installation/implementation are owned by userX.grpX who has non-root access. 6) Modified my.cnf with unique values including port, socket, bind-address, relevant paths and values so as not to step on other installations/implentations. 7) my.cnf is passed through mysqld_safe using --defaults-file= option. 8) mysql_installdb is run. 9) mysql.server is run. Results: 1) mysqld runs with the following log snippets: Error Log: Warning: One can only use the --user switch if running as root. mysqld Log: /unique-path-to-userX-installed-mysql/bin/mysqld, Version: 4.0.4-beta-log, started with: Tcp port: 3307 Unix socket: /unique-path-to-userX-area/temp/mysql.sock 2) When the user tries to run mysql, mysqladmin and etc the following error message is received: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO). Please note that no passwords have been setup as of yet because we can't get pass the access issue. Thank You In Advance! Anthony - 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 db as filesystem.
Pretty interesting stuff: http://www.osnews.com/story.php?news_id=836 http://newsforge.com/article.pl?sid=02/03/22/204220tid=9 Anthony Anthony W. Marino Pres./CTO, AWM Objects David Garamond wrote: Jan Steinman wrote: Today's modern operating systems really stopped evolving in the 80's. Many ideas like database filesystems never really got a chance to show their utility. isn't the next windows operating system (longhorn) supposed to have a new filesystem that's based on SQL Server? i also read that Microsoft had long contemplated about doing this, even before Windows XP/2000... - 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 db as filesystem.
Here's something: http://no.spam.ee/~tonu/modules.php?name=Newsnew_topic=2 Anthony Jayce^ wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Actually, I remember reading about a mysqlfs system, like that, cd to a table, ls for records.. rm to remove and such. that was over a year ago at least.. check sourceforge or google, I bet they'd be able to tell more. Archives might too. Jayce^ On Thursday 10 October 2002 10:32 pm, Joel Rees wrote: At 12:58 +0200 10/10/02, Alex Polite wrote: Is there any way I could display a MySQL database as a filesystem under Linux? To which, on Thu, 10 Oct 2002 at 17:56:31 -0500, Paul DuBois asked What does that mean? Should we guess that he wants to be able to log into a database with csh, run ls and get a list of tables, run cat on a table and get a tab-delimited listing of the contents of the table? On the surface it didn't seem like such an unreasonable question, ... - -- - --Jayce^ -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9pxhyA10/0O8cAHgRAp7kAJ972XyI6+ys+X3rzc13/2mprw2HTwCeOy2m iuG//UzD37flqBKMVwvcDrg= =bT50 -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: User Specific Instance Running
Victoria Reznichenko wrote: Anthony, Friday, October 11, 2002, 5:26:39 AM, you wrote: AWM There is non-root user implementation of MySQL-Pro 4.0.4 linux binary in AWM this users environment (RH 7.3). AWM my.cnf has been modified to include individual user, port , AWM bind-address and host specifics (and etc) unique to that user and is AWM passed as --defaults-file through mysqld_safe script. Data AWM directories are already available with this user/group's ownership. AWM All attempts to run mysql -u root file and other privledged commands This is not a privilege command :-) It means that you connect as user 'root' without a password to the database 'file'. This occurs immediately after running mysql_install_db then running mysql.server scripts so there isn't any passwords at this time. AWM (also tried --skip-grant-tables) end up with Error 1045 Access Denied AWM ? --skip-grant-tables is an option of mysqld, not a mysql client program. Understood, however, doesn't using that switch (with mysqld) impact how you gain access to the server from a security aspect whether using mysql, mysqladmin etc? Thank You, Anthon - 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
User Specific Instance Running
There is non-root user implementation of MySQL-Pro 4.0.4 linux binary in this users environment (RH 7.3). my.cnf has been modified to include individual user, port , bind-address and host specifics (and etc) unique to that user and is passed as --defaults-file through mysqld_safe script. Data directories are already available with this user/group's ownership. All attempts to run mysql -u root file and other privledged commands (also tried --skip-grant-tables) end up with Error 1045 Access Denied ? -- Anthony Anthony W. Marino Pres./CTO, AWM Objects Phone: (732) 610-2441 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql.server Mods for Multiple Instances/Users
What are the issues if I were to remove the following snippets from mysql.server on a RH 7.2 system running multiple instances of MySQL under multiple users?: # Make lock for RedHat / SuSE if test -w /var/lock/subsys then touch /var/lock/subsys/mysql fi # delete lock for RedHat / SuSE if test -f /var/lock/subsys/mysql then rm /var/lock/subsys/mysql fi Thank You, Anthony - 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
Recent Updates
Where/how can I access the most recently updated code for MySQL Max 4.x. Thanks, Anthony - 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: Recent Updates
Thanks alot!!! Anthony In the last episode (May 30), Anthony W. Marino said: Where/how can I access the most recently updated code for MySQL Max 4.x. http://www.mysql.com/doc/I/n/Installing_source_tree.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Select Past 7 days
Try this: SELECT a, b FROM tblName WHERE TO_DAYS(NOW()) - TO_DAYS(pubDate) = 7; Anthony What is the proper query for slect all from the past number of days. i.e. I would like to return all articles from the past week. Right now I am using SELECT blah, bla FROM table WHERE pubDate BETWEEN CURDATE() - 7 AND CURDATE() AND whatever = 'whatever' This worked fine until today. the first of month. Thanks much, olinux __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.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 -- Anthony W. Marino Pres./CTO, AWM Objects email: [EMAIL PROTECTED] phone: (732) 610-2441 - 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 4.0.x enough stable to be in production ?
What table types are you using? Anthony I've been running 4.0.1-alpha on a development server for our new internet bookstore. Holds around 1.3million books, 100k bookcovers and a lot of other information. I haven't experienced any crash/problems except for one bug that brings down MySQL: using two 'match-against' in fulltext search with some words will shutdown mysql. Not sure if it's already fixed or not, but if I get some free time later this week I'll try to make a test case for the mysql-team. But anyway, not counting that bug I haven't experienced any problems. But alpha is alpha... :p Since the logistics etc. are stored on a different server I wouldn't have any problems using this server as our main web-server (which is what I'm going to do in 3 weeks). Restoring the whole server from total crash is relativly easy, so a mysql bug wouldn't hurt much anyway Regards Erlend Stromsvik - Original Message - From: David BORDAS [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 9:09 AM Subject: Mysql 4.0.x enough stable to be in production ? Hi all, just one question, i need to use an index on a specific query. This feature in fact : http://www.mysql.com/doc/N/e/News-4.0.0.html ORDER BY ... DESC can now use keys. And this one is only available in mysql 4.0.x. I'll give a try to mysql 4.0 in a test server. But i need some feed back, did someone using mysql 4.0.x in production ? I know it's an alpha release :( Thanks David - 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 -- Anthony W. Marino Pres./CTO, AWM Objects email: [EMAIL PROTECTED] phone: (732) 610-2441 - 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-lvm] System Suggestions
We have 10 of the 3ware cards, and while the drive is GPLd and in the kernel, we have not been satisfied with the stability of the system Is there anything that I can avoid while still using the card (ie; specific RAID config)? We haven't had a chance yet to qual the latest firmware, etc., but we went with dumb IDE expansion cards (we're only using 4 ide drives per system) and we're getting better speed (RAID0 or 1+0 depending) than we were off the 3ware card. We are not using XFS, so no comments there. We're also having some problems with Mysql that people keep pointing fingers at LVM for, but at this time we're point right back and saying No! in a firm voice... What kind of problems with MySQL, if you don't mind to summarize? Thank You, Anthony - 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
System Suggestions
Could someone, please, provide me with a link and/or facilitate some suggestons for configuration of the following components for a new DB server hosting MySQL 4.01MAX? I'm only looking to get a start and don't expect THE answer since all things are relative and I will have to further test the various scenarios. SuSE 7.3-2.4.18 512MB RAM 4x40GB Maxtor IDE (7200RPM) drives 3Ware 7800 RAID Controller LVM XFS Thank You, Anthony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Availability
Where can I find most recent (ie; 4.0.2 builds ;Nightly/CVS) at? Thank You, Anthony sql - 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 Availability
On Wednesday 06 March 2002 01:37 pm, Ken Menzel wrote: http://www.mysql.com/doc/I/n/Installing_source_tree.html Someone, replying earlier, mentioned that MySQL AB folks don't grant permission to nightly stuff. I'll test it out, regardless. Thank You, Anthony - Original Message - From: Anthony W. Marino [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 12:12 PM Subject: MySQL Availability Where can I find most recent (ie; 4.0.2 builds ;Nightly/CVS) at? Thank You, Anthony sql - 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-lvm] System Suggestions
On Wednesday 06 March 2002 02:40 pm, Petro wrote: On Wed, Mar 06, 2002 at 11:52:30AM -0500, Anthony W. Marino wrote: Could someone, please, provide me with a link and/or facilitate some suggestons for configuration of the following components for a new DB server hosting MySQL 4.01MAX? I'm only looking to get a start and don't expect THE answer since all things are relative and I will have to further test the various scenarios. SuSE 7.3-2.4.18 512MB RAM 4x40GB Maxtor IDE (7200RPM) drives 3Ware 7800 RAID Controller LVM XFS You really don't provide us with enough information here. How big is your database, both in total size and in number of tables. How are those tables utilized, when they get used do you primarily open one table, manipulate it, then close it, or do you go across a bunch of tables? All of these, and more will have a dramatic impact on how you set this stuff up. Thanks. I'm more concerned about any specifics as it applies to MySQL Max and XFS, RAID and LVM as a whole. Are there any nuances as it applies to the whole? Anthony - 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 restart MySQL after innodb table filled up
On Monday 04 March 2002 03:21 pm, Heikki Tuuri wrote: Erik, this is probably not a bug. Your log files probably are not the ones which belong together with the current data file(s). When you start the database it tries to use the obsolete log files in recovery. From the manual: If something goes wrong in an InnoDB database creation, you should delete all files created by InnoDB. This means all data files, all log files, the small archived log file, and in the case you already did create some InnoDB tables, delete also the corresponding .frm files for these tables from the MySQL database directories. Then you can try the InnoDB database creation again. It is best to start the MySQL server from a command prompt so that you see what is happening. Is there now, or later, plans for an automatic procedure for deleting an InnoDB Db and ALL associated files (ie; Delete DB and all) ? Thanks, Anthony Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ Speed up adding of features to MySQL/InnoDB through support contracts See http://www.innodb.com for the online manual and latest news on InnoDB -Original Message- From: Erik Barker [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Date: Monday, March 04, 2002 10:07 PM Subject: Can't restart MySQL after innodb table filled up I'm having problems restarting a MySQL server after a certain table reached maximum capacity. I managed to dump my entire database to a flat file before I restarted the server however when I tried to re-import my data the operation failed. My database size set to 500M in the innodb section of my my.cnf file. I'm running RH 7.2, kernel 2.4.19pre1 with 512M of RAM and have rebooted the server without any change in results. I've also upgraded MySQL-Max from 3.23.48 to 3.23.49a using the RPMS on mysql.com. I've tried removing all the innodb files within my database directory and MySQL seems to build the new 500M file properly but then crashes with the following message in the mysql.log: 020304 11:33:01 mysqld started 020304 11:33:02 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 1819350038 InnoDB: Assertion failure in thread 4096 in file ../include/buf0buf.ic line 265 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=268431360 record_buffer=1044480 sort_buffer=4194296 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 773739 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Bogus stack limit or frame pointer, fp=0xbfffe0b8, stack_bottom=0x49043190, thread_stack=65536, aborting backtrace. Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x47f89f20 is invalid pointer thd-thread_id=138727664 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 138727664 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash 020304 11:33:02 mysqld ended - I've also tried changing a few values in the my.cnf file including changing the number of threads to 1 and increasing the size of the DB to 600M. Is this a known bug? Thanks, -- Erik Barker Sr. Systems Engineer NetNation Communications Inc. http://www.netnation.com | http://www.domainpeople.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: I heard that MySQL 4.01 supports Views?
On Wednesday 27 February 2002 05:16 pm, you wrote: At 17:09 -0500 2/27/02, Anthony W. Marino wrote: On Wednesday 27 February 2002 04:59 pm, Paul DuBois wrote: Does MySQL 4.01 support Views? And if so, how? Ask the person who told you that it does to substantiate the assertion. Can't you just say NO or just don't respond? Sure. But why should this question have even been posted? Isn't it reasonable that if someone told him that views are supported, he could have asked that person, how do you know? Or maybe looked in the manual? Paul, My point is that you are EXTREMELY well versed with MySQL and the current status. I could just imagine at how easy it is to become very annoyed at some of the questions that arrive. We shoudn't stifle interest in this list. We should offer guidance and direction and thus help them help themselves (ie; Please follow the yellowbrick road...) Great '99 book can't wait for more!!! Thank You, Anthony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 4/XFS Journalling FS
Would anyone like to share their experiences with MySQL 4 on XFS and kernel 2.4.16? I'm getting prepared to create a system with the above and would appreciate any thoughts. Thank You In Advance! Anthony - 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 4.x Timeline
On Sunday 24 February 2002 06:26 pm, Arjen Lentz wrote: Hi Anthony, On Fri, 2002-02-22 at 23:43, Anthony W. Marino wrote: On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote: Is there a timeline/status for 4.x functionality available? I would like to use MySQL 4.x, however, I'm looking for some of the highly requested functionality (ie; subselects, SP's, triggers and Views) and would like to know where/when in the sequence of things todo does everything fall into place. This will help me plan my development effort as well since I don't need everything at once. There certainly is a general timeline... have a look at various points in the online manual (http://www.mysql.com/doc/) to see what the priorities are and will be. As for exact dates: it will be ready when it's ready. Some may not like that response, but it's honest. As you know, with MySQL we prefer to do a solid implementation rather than a quick hack. This is the excerpt I found from the docs and Im having difficulty trying to figure out what within a couple of months is relative to. I was wondering if there is some clearer date with regards to the upcoming beta: The rollout of MySQL Server 4.0 will come in several steps, with the first version labelled 4.0.0 already containing most of the new features. Additional features will be incorporated into MySQL 4.0.1, 4.0.2 onwards; very probably within a couple of months, MySQL 4.0 will be labelled beta. Further new features will then be added in MySQL 4.1, which is targeted for alpha release in early 2002. For MySQL Server, an alpha becomes a beta when 1) all features scheduled for that version have been added and 2) no disastrous new bugs are being reported (generally regarding the new features, but of course it is possible that new code also inadvertantly affects the behaviour of old code). So, it is not a completely new separate version or anything like that, it just signifies the development status. It is very dependent on the feedback we get (i.e. the problems that may be found) and therefore there can't be an absolute timeline. The within a few months is just a ballpark figure, relative to the initial alpha release of a sub-version (like 4.0.0). If you keep an eye on the mailing list and the change log for 4.0.x, you can decide for yourself if the server is stable enough for you. I hope this clarifies the issue a bit? I am a bit unsure about exactly what you are looking for... if you want solid code, there can't be an absolute timeline with fixed release dates. I am sure everybody prefers good code. Yet people also keep asking about specific dates for version releases... I suppose it's natural, we're all eager and curious, but maybe you can give me an additional explanation? I DO understand that the BETA becomes available when ALL slated features have made it into the alpha and with some certainity of stability. My concern is in knowing when some of these features (ie; subselects, triggers, sp's and etc) will make it into the alpha so that I can coordinate my coding efforts around them. Don't forget, the db isn't the only part of many software projects. And the more uncertainity that we have about the timing of features/functionality availability which our (my) progam and/or code might need to rely on, it's quite possible that almost everything will be ready for nothing or nothing will be ready for everything. I DO appreciate the GREAT work that's going on with MySQL, however, I'm also looking at other products that already have the above such as PostgreSQL and Firebird (InterBase Opensource) and trying to measure the pros/cons of all three, however, it would make things ALOT easier if I new when the above features would be available. Regards and Thank You, Anthony Regards, Arjen. - 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 4.x Timeline
On Friday 22 February 2002 02:15 am, Jeremy Zawodny wrote: On Thu, Feb 21, 2002 at 08:07:39PM -0500, Anthony W. Marino wrote: Is there a timeline/status for 4.x functionality available? No. It'll be ready when it's ready. :-) There are folks using 4.0.x in production and/or testing now. This helps test the code and get folks comfortable enough with it to go from alpha to beta to gamma to stable. Well, any idea on a date for beta? I would like to use MySQL 4.x, however, I'm looking for some of the highly requested functionality (ie; subselects, SP's, triggers and Views) and would like to know where/when in the sequence of things todo does everything fall into place. This will help me plan my development effort as well since I don't need everything at once. I've heard that there's now a developer working on sub-selects. But I've not heard the same triggers and stored procedures. That doesn't mean a whole lot, since I have no claim to know what's going on at MySQL central... Jeremy Any advantages, featurewise, to using MySQL 3.x at this point? Thanks, Anthony - 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: Paul DuBois Book
On Friday 22 February 2002 05:48 am, Simon Green wrote: It would be nice to see some thing for V4. PS Paul...its only because we liked the first one so much. -Original Message- From: D Bamud [mailto:[EMAIL PROTECTED]] Sent: 22 February 2002 10:47 To: [EMAIL PROTECTED] Subject: Paul DuBois Book When the Next Edition of MySQL By Paul Dubois is coming? +1 with my vote. - 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 4.x Timeline
On Friday 22 February 2002 06:26 am, Arjen Lentz wrote: Hi Alec, On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote: Is there a timeline/status for 4.x functionality available? I would like to use MySQL 4.x, however, I'm looking for some of the highly requested functionality (ie; subselects, SP's, triggers and Views) and would like to know where/when in the sequence of things todo does everything fall into place. This will help me plan my development effort as well since I don't need everything at once. There certainly is a general timeline... have a look at various points in the online manual (http://www.mysql.com/doc/) to see what the priorities are and will be. As for exact dates: it will be ready when it's ready. Some may not like that response, but it's honest. As you know, with MySQL we prefer to do a solid implementation rather than a quick hack. This is the excerpt I found from the docs and Im having difficulty trying to figure out what within a couple of months is relative to. I was wondering if there is some clearer date with regards to the upcoming beta: The rollout of MySQL Server 4.0 will come in several steps, with the first version labelled 4.0.0 already containing most of the new features. Additional features will be incorporated into MySQL 4.0.1, 4.0.2 onwards; very probably within a couple of months, MySQL 4.0 will be labelled beta. Further new features will then be added in MySQL 4.1, which is targeted for alpha release in early 2002. I would like to second this request. I *really* want the replication failover functionality targeted for 4.x. In fact, if it isn't going to arrive by, say, midsummer, I will have to develop my own failover solutions. Which, obviously, I don't want to do - I have this aversion to reinventing wheels, and I have this nasty feeling that the MySQL teams wheels would be rounder than mine. So some indication of the timescales would be really useful. I certainly don't need exact dates, and I know all about the delays in development - but some indiciation would be really helpful and could save me a lot of work. If you have a commercial interest in speeding up a particular part of our planned development, this is certainly something that can be talked about. As you may know, the original replication was done as a 'sponsored' project. One company needed it, and provided the funds to allow us to allocate manpower for doing it. Now, it benefits many more! MySQL's development path is not for sale, but like any company we have to accept certains limit in our human and financial resources. Sponsoring a particular part can in cases such as these allow for faster development, provided of course that technical prerequisites are met; naturally the rule about solid implementations still applies. To get you (and others) thinking along an interesting track sponsoring need not be limited to a single company making a large targeted contribution. It could very well be multiple small(er) companies that have a similar need. The question is simply how fast you need a certain feature, and what it will save you to have it that fast, and/or gain you by having it help your business. That knowledge would allow you to invest (part of) those savings into making sure that it does happen. Regards, Arjen. - 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
Transaction Enhanced Formats
Can anyone point me to a comparison of +'s and -'s with each Transaction enhanced formats (ie; InnoDb, SleepyCat and others) for MySQL. Thanks, Anthony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 4.x Timeline
Is there a timeline/status for 4.x functionality available? I would like to use MySQL 4.x, however, I'm looking for some of the highly requested functionality (ie; subselects, SP's, triggers and Views) and would like to know where/when in the sequence of things todo does everything fall into place. This will help me plan my development effort as well since I don't need everything at once. Thanks, Anthony - 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: raid tables
Isn't this something that RAID O does for you on a larger scale anyway? I would expect that most would have some sort of raid on their mutliple drive system. On Monday 18 June 2001 01:52 am, you wrote: On Sun, Jun 17, 2001 at 11:48:04PM -0700, Jamie Krasnoo wrote: Is there a way to tell MySQL to automatically spread its tables over a number of disks without going through the trouble of symbolic linking the chunks to the different disks? There isn't yet, no. It'd certainly be a nice addition, though, wouldn't it? Jeremy - 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
GEMNI,InnoDB and BDB
Any thoughts on the best support of transactional/ACID attributes for db tables in MySQL? Thank You, Anthony - 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