Security issues

2010-05-21 Thread Rob Wultsch
Given the rather serious recent bug fixes I have been thinking a good bit about security. Does MySQL AB/Sun/Oracle maintain a page similar to http://www.postgresql.org/support/security.html which lists security issues and what releases they effected? -- Rob Wultsch wult...@gmail.com -- MySQL Ge

Re: Mysqltest Unknown system variable, failed: 1193

2010-05-21 Thread Meng-Ju, Hsieh
Thank for your reply. I've also tried the configure option - '--enable-debug-sync', but it cannot work with message - ' configure: WARNING: unrecognized options: --enable-debug-sync '. I've also tried configure option - '--with-debug=full', it can configure and no-warring message. When i compl

MySQL Server 5.0.91 has been released

2010-05-21 Thread Joerg Bruehe
Dear MySQL users, MySQL Community Server 5.0.91, a new version of the popular Open Source Database Management System, has been released. Please note that the active maintenance of 5.0 has ended,and these community builds are only provided because of the fixes to security bugs # 50974, 53237, and 5

MySQL Community Server 5.1.47 has been released

2010-05-21 Thread Hery Ramilison
Dear MySQL users, MySQL Community Server 5.1.47, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.47 is recommended for use on production systems. For an overview of what's new in MySQL 5.1, please see http://dev.mysql.com/doc/refman/5.1/en/mysq

Re: Another Foreign Key Problem

2010-05-21 Thread Victor Subervi
I'm canceling this thread. It belongs in the Python list. Sorry! V On Fri, May 21, 2010 at 1:24 PM, Victor Subervi wrote: > Hi; > When I try to execute this code from my Python script, I get this error: > > Traceback (most recent call last): > File > "/var/www/html/creative.vi/clients/sea-flig

Another Foreign Key Problem

2010-05-21 Thread Victor Subervi
Hi; When I try to execute this code from my Python script, I get this error: Traceback (most recent call last): File "/var/www/html/creative.vi/clients/sea-flight/reservations/create_edit_bags3.py", line 38, in ? create_edit_bags3() File "/var/www/html/creative.vi/clients/sea-flight/rese

Re: Recover accidentally deleted MySQL database files

2010-05-21 Thread Johan De Meersman
And this is why you have backups :-) You have little guarantee that the recovered blocks form complete files, but you can try to move them into the directory (with the correct mdi, myd and frm extensions and named consistently, of course) and try to figure out what contains which data from the con

RE: Recover accidentally deleted MySQL database files

2010-05-21 Thread Jose Luis Marin Perez
thanks for your answer, it seems these files were deleted when running fsck. In the /Lost+found directory files are referenced to Mysql for example: #114470: MySQL table definition file Version 9 #114471: MySQL MISAM compressed data file Version 1 #114472: DBase 3 data file (256 records) #114473:

Re: Mysqltest Unknown system variable, failed: 1193

2010-05-21 Thread Joerg Bruehe
Hi! Meng-Ju, Hsieh wrote: > Thank for your reply. > > I've tried to use Version 5.1, but it cannot work. > Did you have used the system variable - 'DEBUG_SYNC' ? I don't know what you are doing exactly, but I guess you are not using the correct options in your call to "configure". "DEBUG_SYNC"

Re: Database Quotas

2010-05-21 Thread Tim Gustafson
> i guess my thinking is more along the lines of implementing > a lustre interface I'm sure that I'm vastly over-simplifying this, but I was thinking something along the lines of: 1. Assemble the data being written, calculate its length 2. Check for any free pages in the database file, and use

Re: Recover accidentally deleted MySQL database files

2010-05-21 Thread mos
At 10:42 AM 5/21/2010, you wrote: Dear sirs, Accidentally files in a database have been deleted (/ var/lib/mysql /"database") when entering the mysql console shows that the database is created but does not show any table, there is some method to recever the information in this database? Yo

RE: Database Quotas

2010-05-21 Thread Martin Gainty
i guess my thinking is more along the lines of implementing a lustre interface http://en.wikipedia.org/wiki/Lustre_%28file_system%29#Architecture where the chronology *may* follow: the File's Metadata attributes are written the particulars of where the data is written would be handled by OSS

Re: Mysqltest Unknown system variable, failed: 1193

2010-05-21 Thread Meng-Ju, Hsieh
Thank for your reply. I've tried to use Version 5.1, but it cannot work. Did you have used the system variable - 'DEBUG_SYNC' ? Thank you very much. - Original Message - From: "Joerg Bruehe" To: "Meng-Ju, Hsieh" Cc: Sent: Friday, May 21, 2010 6:25 PM Subject: Re: Mysqltest Unknown

Recover accidentally deleted MySQL database files

2010-05-21 Thread Jose Luis Marin Perez
Dear sirs, Accidentally files in a database have been deleted (/ var/lib/mysql /"database") when entering the mysql console shows that the database is created but does not show any table, there is some method to recever the information in this database? Centos 4.6 mysql Ver 14.7 Distrib 4

Re: Database Quotas

2010-05-21 Thread Johnny Withers
I ran out of space on a large, busy production database just a few weeks ago. All tables are InnoDB and I experienced zero data loss. It was actually running out of space for almost 2 weeks after a review of the log file. As temp files were deleted transactions were able to continue until all but

Re: Innodb buffer pool size

2010-05-21 Thread Raj Shekhar
In infinite wisdom "Machiel Richards" wrote: > The current Innodb buffer pool size is at 4Gb for instance, and the > innodb tables then grow to be about 8Gb in size. InnoDB manages the pool as a list, using a least recently used (LRU) algorithm incorporating a midpoint insertion strategy. W

Re: Database Quotas

2010-05-21 Thread Tim Gustafson
> if MYSQL attempts to insert more bytes than what is available > on disk you will get 28 ENOSPC No space left on device > http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html Does it figured that out before it tries to write a record? So, if I have 2KB left on the device an

RE: Database Quotas

2010-05-21 Thread Martin Gainty
Tim- if MYSQL attempts to insert more bytes than what is available on disk you will get 28 ENOSPC No space left on device http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html does this help? Martin Gainty __ Verzicht und Vertra

Re: Mysqltest Unknown system variable, failed: 1193

2010-05-21 Thread Joerg Bruehe
Hi! Meng-Ju, Hsieh wrote: > I also read the URL > http://forge.mysql.com/wiki/MySQL_Internals_Test_Synchronization#Test_Synchronization > > But it cannot work. > > > Sorry, mysql version is "mysql-6.0.0-alpha" Development on the 6.0 branch is stalled, almost all current effort is on the MySQL

Re: Mysqltest Unknown system variable, failed: 1193

2010-05-21 Thread Meng-Ju, Hsieh
Thank you for your reply. Thank for your suggest. I'll try to send question to the mail address. Thank you very much. - Original Message - From: "Johan De Meersman" To: "Meng-Ju, Hsieh" Cc: Sent: Friday, May 21, 2010 4:29 PM Subject: Re: Mysqltest Unknown system variable, failed:

Re: Mysqltest Unknown system variable, failed: 1193

2010-05-21 Thread Johan De Meersman
You may want to try this on the mysql-dev list, I think. 2010/5/21 Meng-Ju, Hsieh > I also read the URL > > http://forge.mysql.com/wiki/MySQL_Internals_Test_Synchronization#Test_Synchronization > But it cannot work. > > > Sorry, mysql version is "mysql-6.0.0-alpha" > > > -- > MySQL General Maili