Re: chroot() in 3.23.54

Sergei, Forgive my ignorance, but i've been thinking about this. Isn't it impossible to get it to work with the system calls i listed from strace? To repeat: chdir("/usr/local/var/mysql/") = 0 chroot("/chroot/mysql") = 0 chdir("/") = 0 open(

Re: more about using sets

Three reasons to keep a table of card types: 1. Generally as an added check, you ask the user to specifiy the card type, then ask for the number. If that card type check is data-driven, you will need less code modification over time. 2. Once MySQL comes to support stored procs, there is a case to

Re: MySQL security flaws uncovered

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 18 Dec 2002, Michael Bacarella wrote: > A good question posted to another list.. > > forwarded message follows > > > Several vulnerabilities have been found in the MySQL database system, > > a light database package commonly used in

Re: chroot() and 3.23.54

Just saw the announcement for 3.23.54a, and that it fixes the bug in safe_mysqld that i mentioned in the postscript to my last mail. Sorry. I was in the middle of building 3.23.54a when i wrote my last mail, and i didn't see anything in the changelog that indicated that bug. -& -- GPG key /

Re: Can MySQL handle 120 million records?

I agree. MySQL is a great database, but I wouldn't call it enterprise grade. Considering that the database is used to store billing information... one has to be weary about losing all the records due to a bug or deficiency in MySQL. I was searching through some of the MySQL help documentatio

Re: Can MySQL handle 120 million records?

Being paranoid... Have you ever lost data with MySQL before? Is it "reliable". I have no problems using MySQL as a lightweight database for simple chores, but I'm a bit weary about putting into a mission critical environment. At 10:19 PM 12/17/2002 -0800, Jeremy Zawodny wrote: On Wed, Dec 18

Re: mysql & dreamweaver

Did you setup MySQL yet? Can you log into to the mySQL server using your command line utilities? At 10:40 PM 12/17/2002 -0800, Is98 wrote: hello, i have access to mysql db i created, using a client app even on a remote pc (adding tables, fields, values) but when i try to connect with dreamweave

Re: MySQL security flaws uncovered

It's bad for business : ) Maybe they're taking the MS route. At 12:19 AM 12/18/2002 -0500, Michael Bacarella wrote: A good question posted to another list.. forwarded message follows > Several vulnerabilities have been found in the MySQL database system, a > light database package c

RE: compression protocol

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 10:55 AM To: Dmitry Kosoy Subject: Re: compression protocol Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filte

Replication of only a couple of databases

Hiya I've setup replication with a master-slave. But i only want to replicate some databases so i'd put in my.cnf on the slave (it's being used, checked that) replicate-wild-do-table=adb.% (it has to catch cross updates to) I also tried to replicate-do-database=adb (in different combinations) Wh

Re: MySQL security flaws uncovered

Michael She wrote: It's bad for business : ) Maybe they're taking the MS route. I second this. These vulnerabilities are serious, they must be given more attention. Apache, PHP, RedHat and so on and so on are very careful with issues like this, all vulnerabilities/exploits are immediately p

Re: JOIN + GROUP BY question

I have two tables: one holding bids for an auction (table bids) and one holding user data who placed the bids (users). I would like to get the highest bid, the user who placed the bid and the number of bids placed, so I use the following query: SELECT MAX(bids.amount) AS amount, COUNT(bids.ite

Accessing last_insert_id problem.

Hi, I'm adding records to a db using the Perl DBI. Subsequent to adding a record I need to know the value of the auto-incrementing 'Ref' field so that I can place a copy of the relavent details into a log file. I could query for the "LAST_INSERT_ID" but what if another process has added anothe

Re: MySQL and PHP question

Thanks for the info. I tried using mysql_free_result() and mysql_close($db) and opening the DB again for the second query with the same results. I haven't tried using a different variable for $result. - Original Message - From: "Steve Yates" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PR

Re: MySQL security flaws uncovered

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 18 Dec 2002, Csongor Fagyal wrote: > Michael She wrote: > > > It's bad for business : ) > > Maybe they're taking the MS route. > > I second this. These vulnerabilities are serious, they must be given > more attention. Apache, PHP, RedHat and s

Re: Replication of only a couple of databases

anyone please? hmm according to the manual comments somone also has the same problem with 4.04 http://www.mysql.com/doc/en/Replication_Options.html Is it a bug? At 10:36 18-12-02 +0100, Wico de Leeuw wrote: Hiya I've setup replication with a master-slave. But i only want to replicate some data

Re: Can MySQL handle 120 million records?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jim, et al -- ...and then JamesD said... % % I've read limits are based on the filesize your OS can handle, % the HDD size, memory, how fast your RISC Yeah, these make sense, but that means that they're not really mysql limits but hardware or OS lim

Re: compression protocol

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dmitry Kosoy wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 10:55 AM To: Dmitry Kosoy Subject: Re: compression protocol Your message cannot be posted because it appears to be

MySQL Security Flaw - Dropped Databases

Hi, I'd like to add to the "security flaw" thread with my own experience. I have been hosting MySQL databases for over 2 years and on a few occasions have had user databases disappear. Last month one of my admin databases was dropped. The only user who has access to that database is root

ANN: EMS MySQL Manager 1.95 released

EMS HiTech company is announcing the next version (1.95) of MySQL Manager -- A Powerful MySQL Administration and Development Tool for Windows95/98/ME/NT/2000/XP. You can download the latest version from http://www.mysqlmanager.com/download.phtml We wish you a Merry Christmas and a Happy New Year!

Re: MySQL Security Flaw - Dropped Databases

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, thanks for your message. On Wed, 18 Dec 2002, Gary Huntress wrote: > I'd like to add to the "security flaw" thread with my own experience. I > have been hosting MySQL databases for over 2 years and on a few > occasions have had user databases di

RE: Can MySQL handle 120 million records?

Hi, I've been using MySQL intercompany for a while now with great results. Even the diehard MSSQL people are amazed at how fast it can be at time. One of the things I use it for is to store syslog events in it. I wrote a backend that parses a syslog file as data is being written into

Recover deleted records

Hi, I posted this a few days ago, but haven't seen a reply as yet, and I'm getting quite desperate now!! I've managed to delete all the records in a table, well haven't we all done it sometime!, and was wondering whether it's possible to recover them. I notice that the .MYD and .MYI files still

re: Accessing last_insert_id problem.

On Wednesday 18 December 2002 14:21, Jeff Snoxell wrote: > I'm adding records to a db using the Perl DBI. Subsequent to adding a > record I need to know the value of the auto-incrementing 'Ref' field so > that I can place a copy of the relavent details into a log file. > > I could query for the "L

re: RE: Mysql - Upgrading from 3.23.53 to 3.23.54

On Tuesday 17 December 2002 19:27, Santiago Alba wrote: > I installed binary version (source distribution)... not with rpm So, binary or source distribution? Please, be clear. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net htt

Re: Can MySQL handle 120 million records?

Qunfeng Dong wrote: Another thing, with some linux system, there is a size limit for file. MySQL seems to store each of its table as single file. You need to choose a file system without that limit. Just use InnoDB tables for these files and you won't have a problem AFAIK; you can have multip

Re: Can MySQL handle 120 million records?

Michael She wrote: I agree. MySQL is a great database, but I wouldn't call it enterprise grade. Considering that the database is used to store billing information... one has to be weary about losing all the records due to a bug or deficiency in Besides actual additional features (managemen

re: Accessing last_insert_id problem.

Hi, I've got that sussed now and am happily using the aquired ref to subsequently play with the record etc. One other related problem and I recon I'm sorted How do I reset the auto-increment value? I'm working with MySQL 3.23.36 so, according to "MySQL, Paul Dubois, New Riders" running th

re: Replication of only a couple of databases

On Wednesday 18 December 2002 11:36, Wico de Leeuw wrote: > I've setup replication with a master-slave. > But i only want to replicate some databases so i'd put in my.cnf on the > slave (it's being used, checked that) > replicate-wild-do-table=adb.% (it has to catch cross updates to) > I also trie

Re: Problem with Query based on HTML form values - Clarification

You have it right. But if the user searches for new power boats, and doesn't specify a make, make should not appear in your WHERE clause. The query has to be different depending on the criteria that have been chosen (or not chosen, as the case may be). Prior to executing the query, look at all

re: Accessing last_insert_id problem.

At 15:31 18-12-02 +, Jeff Snoxell wrote: Hi, I've got that sussed now and am happily using the aquired ref to subsequently play with the record etc. One other related problem and I recon I'm sorted How do I reset the auto-increment value? I'm working with MySQL 3.23.36 so, according t

Parser seems to have problems with '-' (dash).

Hello I have hade several problems with the character '-' (dash, minus, or whatever you wan't to call it) the parser seems to regardles of quoting be seen as an substraction operator. Does anybody recognice this, have I just missed the part where the characters allowed in names and passwords is sp

Re: Can MySQL handle 120 million records?

On Wed, Dec 18, 2002 at 02:38:31AM -0500, Michael She wrote: > Being paranoid... > > Have you ever lost data with MySQL before? No. > Is it "reliable". Yes. It doesn't crash and doesn't lose data. If it did either, we'd never have used it this much. > I have no problems using MySQL as a ligh

RE: JOIN based query problem (little help needed)

Hi Gigi: I got a 2 steps solution to your problem: 1.- Create a TEMPORARY TABLE with CREATE TEMPORARY TABLE anyname SELECT t1.id,t1.description,SUM(t2.quantities) AS Purchases,t3.quantities FROM products t1 INNER JOIN purchases t2 ON t1.id=t2.id INNER JOIN sellings t3 ON t1.id=t3.id GROUP

Re: Can MySQL handle 120 million records?

On Wed, Dec 18, 2002 at 02:37:07AM -0500, Michael She wrote: > > I agree. MySQL is a great database, but I wouldn't call it > enterprise grade. Since you haven't told us what "enterprise grade" means to you, that doesn't tell us much. What is it lacking to become "enterprise grade" in your mind?

Re: InnoDB foreign key problems - is Heikki out there?

Hi! Please send your postings to [EMAIL PROTECTED] The newsgroup mailing.database.mysql is only a mirror of that mailing list. The error message below is misleading. It should really be 'Cannot update a parent row...'. Internally InnoDB does the update by deleting and reinserting the index record

3.23.54a Instability

Hey list, Recently I tried to upgrade MySQL to a newer version. I have 3.23.53a-max running but that is vulnarable to a bug. So I went to mysql.com and grabbed the .54a-max binary. First thing I noticed was the small size, only 6M while .53a was 10M. Net thing I started .54a.. it took the load on

hostname failure

I have a domain mail.xxx.com. Everywhere I do a nslookup the reverse lookup up returns the domain correctly. When I do a 'hostname' it returns the correct name. Also on this machine I have another domain mail.yyy.com Both of these domains resolve to the same IP. The problem I'm having is when

Re: Accessing last_insert_id problem.

Jeff Snoxell wrote: "DELETE FROM my_table_name" should reset it... but it doesnt'. I'm glad the DELETE FROM doesn't, or else my foreign keys would all get screwed up :) TRUNCATE should do what you want (as someone else pointed out). -- Michael T. Babcock C.T.O., FibreSpeed Ltd. ... SQL ht

$Variables and Select statements

Hi, >From the code below $wk gets the values (w1, w2, w3, etc.) as it goes through the 'for' loop. w1, w2, etc. are also colums in the table manager. What I can't figure out is why the select statement fails (no error, just no data) when I use $wk as apposed to hardcoding w1, w2, etc. Is this pos

好马配好鞍 刷卡选正元

×ð¾´µÄmysql£º ÄúºÃ£¡ ÔÚÃÀÀöµÄÎ÷×ÓºþÅÏ£¬ ´Å¿¨¡¢ÌõÂëÉ豸֮¼Ò---º¼ÖÝÕýÔ­µç×Ó www.zymc.com »¶Ó­ÄúµÄÝ°ÁÙÖ¸µ¼£¡ º¼ÖÝÕýÔ­µç×ÓÓÐÏÞ¹«Ë¾ÊÇÒ»¼ÒרҵÖÂÁ¦ÓÚÐÅÏ¢×Ô¶¯Ê¶±ðµÄ¸ß¿Æ ¼¼ÆóÒµ¡¢×Ô¶¯Ê¶±ðÉ豸µÄרҵ¿ª·¢É̺ÍOEMÖÆÔìÉÌ¡£ÕýÔªÅÆZYϵÁÐ ´Å¿¨¶ÁдÆ÷¡¢´Å¿¨ÔĶÁÆ÷¡¢ÌõÂëË¢¿¨Æ÷ºÍÃÜÂë¼üÅ̵ÈÉ豸£

ERROR ON CONNECTION

When i try connect from WindowsXP machine to red hat 8.0 linux machine mysql server (4.05-max), I have the following message error: "ERROR 2013: Lost connection to mysql server during query". But, I can connect from linux to windowsXP mysql server(4.0.5 max). Who knows the problem Thanks. A

ERROR ON CONNECTION

When i try connect from WindowsXP machine to red hat 8.0 linux machine mysql server (4.05-max), I have the following message error: "ERROR 2013: Lost connection to mysql server during query". But, I can connect from linux to windowsXP mysql server(4.0.5 max). Who knows the problem Thanks. A

Re: Can MySQL handle 120 million records?

Hi, I'm using MySQL on a database with 134 Millions of rows (10.9 GB) (some tables contains more than 40 millions of rows) under quite high stress (about 500 queries/sec avg). (using HEAP, MyISAM and InnoDB tables) I never experienced any losses, *even with MySQL-4.1* (yes, I'm currently using 4.1

RE: Can MySQL handle 120 million records?

Without trying to sound like a troll or a rant I'd like to chime in on the side of Jeremy. I've worked with MySQL on sites that serve up over a million hits a day. We hit the 2gb file limit in Linux (NOT a MySQL problem) and moved to Solaris without incident. A friend of mine had over a billion r

myodbc problem.

Hi ¡ : I Have a problem. I 'm connecting Centura Team Developer to Mysql Trough myodbc . when i send a select to the server , i can see that the select statement works fine. but when I evaluate the variables that the server returns , it returns the CHAR fields as empty values . this does not h

RE: $Variables and Select statements

Hi, > while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { > > echo " ALIGN=left>".$line['name']." ALIGN=right>".$line['$wk'].""; > > } Here is your problem. Your are indeed substituting $wk into the query correctly, but when you go to output the result rows y

Re: Mysql - Binary vs. Source

Santiago Alba wrote: I installed binary version (source distribution)... not with rpm This binary/source confusion comes from the download page; it says "Binary packages (tar.gz)" for the source download and "Linux RPM packages (rpm)" for the binary package. Could someone please change th

Implementation of 'Views'

Is there anything on the books for implementing 'Views' both for read and write, (esp. based on key relationships and joins?) I know temporary tables give a form of view, but they aren't "live" unless updated manually and one can't insert into them and have the expected result. -- Pseudo? SQL

Re: Can MySQL handle 120 million records?

At 08:06 AM 12/18/2002 -0800, Jeremy Zawodny wrote: > I have no problems using MySQL as a lightweight database for simple > chores, but I'm a bit weary about putting into a mission critical > environment. Why, exactly? Mainly for 2 reasons: 1. MySQL hasn't been "proven" yet in the corporate

Problem inserting data

Hello all, I'm trying to get a table from a text file with columns delimited by the "|" sign and I can't do it right. I've made a perl script that gets the file, parses it, and inserts the variables into the table, but the problem is that the text contains characters like " ' ? I've tried using

Re: Re: MySQL Download Types (clarification)

heheh ... nice to see: sql,query,queries,smallint Re-clarification of my own message; the .tar.gz described as being a binary is in fact a binary; my mistake. Again, since I found it confusing, I'm assuming others will (and have) found it confusing. The source distribution is at the very e

Re: ERROR ON CONNECTION

On Wed, 18 Dec 2002 16:36:15 + ANGELO CARMO <[EMAIL PROTECTED]> wrote: > When i try connect from WindowsXP machine to red hat 8.0 linux machine mysql > server (4.05-max), I have the following message error: > > "ERROR 2013: Lost connection to mysql server during query". > > But, I can connec

RE: Can MySQL handle 120 million records? - Impressive! How do you guys do that?

I am very encouraged to hear all these successful proofs. I do want to stick to MySQL (we are using it to develop a biology database). But I am indeed seeing not-so-good performance (join on tables much smaller than yours takes minutes even using index) and I seem to read all the docs I could find

Re: Can MySQL handle 120 million records?

Joe Stump wrote: As Jeremy points out all DB's have their problems, shortcomings, etc. If you have specific complaints fill out a feature request, if you've got problems fill out a bug report, but don't knock MySQL as There's a nice point on the MySQL site somewhere that if you really want

Re: Can MySQL handle 120 million records?

Previous hardware was a Bi PIII-733 with 786 MB of RAM, and 1 SCSI drive, under Linux (kernel 2.4.18). It worked fine, with sometimes some slowdown, mainly because of the hard drive. Now the server is Bi Athlon MP 2200+, 2 GB of RAM, and Maxtor Atlas 10K3 SCSI 320 (RAID-5) (still kernel 2.4.18) The

RE: Can MySQL handle 120 million records?

> -Original Message- > From: Joe Stump [mailto:[EMAIL PROTECTED]] > We hit the 2gb file limit in Linux (NOT a MySQL problem) and > moved to Solaris without incident. This appears to have been largely fixed in Linux, too, if you use a recent kernel and glibc. I recently tried creating

Re: Can MySQL handle 120 million records?

Michael She wrote: 2. Some of the comments in the mySQL manual... people losing data doing routine stuff like table optimizations, adding keys, etc. If a database is reliable, things like that shouldn't happen. Comments like those in the MySQL manual scared me. 1) Do you believe this doe

Re: Can MySQL handle 120 million records?

On Wed, Dec 18, 2002 at 12:16:00PM -0500, Michael She wrote: > At 08:06 AM 12/18/2002 -0800, Jeremy Zawodny wrote: > > 1. MySQL hasn't been "proven" yet in the corporate environment You mean in your corporate environment? It works well in ours. :-) And we use it to store data that we serve to mi

Re: Can MySQL handle 120 million records?

> > > I have no problems using MySQL as a lightweight database for simple > > > chores, but I'm a bit weary about putting into a mission critical > > > environment. > 1. MySQL hasn't been "proven" yet in the corporate environment We run a periodic billing system backed with MySQL, in addition to

RE: Can MySQL handle 120 million records?

1. MySQL hasn't been "proven" yet in the corporate environment Is Yahoo! proven enough? Seriously, how many large corporations have to use a DB in order for it to be "proven"? Is Access "proven" because every company on the planet uses it at some level? 2. Some of the comments in the mySQL manual

Re: Can MySQL handle 120 million records?

Hi, I assume you are speaking about this comment : "++--+--+-- + | Table | Op | Msg_type | Msg_text | ++--+--+-- + | database.table_name | optimize | error | 28 when fixing table | | da

Re: Problem inserting data

Octavian Rasnita wrote: Could you tell me if the following script is OK? Note: It uses DBD::mysqlPP and not DBD::mysql, because only this module can be used under Perl 5.8, but it should work the same. I'm using DBD::mysql under PERL 5.8 right now ... FYI. -- Michael T. Babcock C.T.O., Fib

Severe performace problem linking tables with mysql

PLATFORM: 3.23.52-max-nt with Windows 2000 professional (default table type) I have discovered a performace issue when joining several tables together. The performance is extremely poor when performing select queries using the WHERE clause and joining the tables with the pk_media_id = fk_media_

Re: Mysql - Binary vs. Source

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 18 Dec 2002, Michael T. Babcock wrote: > This binary/source confusion comes from the download page; it says > "Binary packages (tar.gz)" for the source download and "Linux RPM > packages (rpm)" for the binary package. Could someone please cha

Re: Can MySQL handle 120 million records?

Joe is right ... we switched from another SQL server to MySQL in 1999, and have never looked back. MySQL has been rock solid for our applications, the MySQL development team is great to work with, and our customers like it. Gerald Jensen - Original Message - From: "Joe Stump" <[EMAIL PRO

Re: Mysql - Binary vs. Source

Lenz Grimmer wrote: Sorry, but that would not be true. We actually *do* distribute most binaries in gzipped tar archives. tar.gz is not limited to contain source files only. I posted a self-correction. I still think the download page is unnecessarily misleading in some ways. Perhaps fixi

Converting many tables into MyISAM

I have about 300 database tables that are mostly ISAM and some MyISAM format. I would like to move them all into MyISAM - what's the easiest/quickest way? I am running 3.23.54. I was thinking of doing mysqldump, then using a search/replace in the file CREATE TABLE .. TYPE=, then recreating the dat

RE: Can MySQL handle 120 million records?

> From: Michael She [mailto:[EMAIL PROTECTED]] > > > I have no problems using MySQL as a lightweight database > for simple > > > chores, but I'm a bit weary about putting into a mission critical > > > environment. > > > >Why, exactly? > > > Mainly for 2 reasons: > > 1. MySQL hasn't been "proven

RE: Parser seems to have problems with '-' (dash).

I believe I ran into this problem before, and I'm pretty sure that a back tick will work. NOTE: a backtick is not the same thing as a single quote Using the backtick will also help you handle (and hopefully rename) tables and so forth that accidentally or unknowingly use a reserved keyword. usin

Can I build a web page to extract data?

I would like to create a web page that will extract the data from mysql so it looks exactly like the form that the end user sees on their end. Also a little bit off topic but I have a situation where it would be great to have the web page form and it's data sent to an email address. I already have

Re: Can MySQL handle 120 million records?

W. D. wrote: At 10:40 12/18/2002, Jocelyn Fournier wrote: Hi, I'm using MySQL on a database with 134 Millions of rows (10.9 GB) (some tables contains more than 40 millions of rows) under quite high stress (about 500 queries/sec avg). (using HEAP, MyISAM and InnoDB tables) I never experienced

Re: Can MySQL handle 120 million records?

At 10:10 -0500 12/18/02, Michael T. Babcock wrote: Qunfeng Dong wrote: Another thing, with some linux system, there is a size limit for file. MySQL seems to store each of its table as single file. You need to choose a file system without that limit. Just use InnoDB tables for these files and y

Re: Parser seems to have problems with '-' (dash).

At 16:51 +0100 12/18/02, [EMAIL PROTECTED] wrote: Hello I have hade several problems with the character '-' (dash, minus, or whatever you wan't to call it) the parser seems to regardles of quoting be seen as an substraction operator. Give us an example of where you use it within a quoted name a

Re: Can MySQL handle 120 million records? - Impressive! How doyou guys do that?

On 12/18/02 9:48 AM, "Qunfeng Dong" <[EMAIL PROTECTED]> wrote: > But I am indeed seeing > not-so-good performance (join on tables much smaller > than yours takes minutes even using index) and I seem > to read all the docs I could find on the web about how > to optimize but they are not working for

Re: Can MySQL handle 120 million records? - Impressive! How do youguys do that?

Qunfeng Dong wrote: not-so-good performance (join on tables much smaller than yours takes minutes even using index) and I seem to read all the docs I could find on the web about how to optimize but they are not working for me (I am Have you stored a slow query log to run them through 'explai

Re: SELECT and UPDATE at the same time?

At 17:56 + 12/18/02, Jeff Snoxell wrote: Hello again, I'm selecting a group of records from my database. I then loop through the selected records and do some work based on what I find. But what I also want to do as I interrogate each record is update some of its fields with new values... b

Re: Can MySQL handle 120 million records?

At 10:40 12/18/2002, Jocelyn Fournier wrote: >Hi, > >I'm using MySQL on a database with 134 Millions of rows (10.9 GB) (some >tables contains more than 40 millions of rows) under quite high stress >(about 500 queries/sec avg). (using HEAP, MyISAM and InnoDB tables) >I never experienced any losses

Re: Can MySQL handle 120 million records?

At 14:28 -0500 12/18/02, Michael T. Babcock wrote: Paul DuBois wrote: And take a look at the last few items in the list, pertaining to page size, max number of pages, etc. 4 billion * 16kB = max table size = 64TB Correct? Sounds pretty serious ;-) That's what it looks like to me! -- M

OT: Spam Filter (again)

Just for anyone who cares (or cares to do the same), when I reply to messages at my average 80wpm and hit send, I don't check if SQL,QUERY,etc. is in the message 90% of the time. Now, besides thanking the crew for adding a couple more keywords to the filter, it still ticks me off to get a bo

Re: Can MySQL handle 120 million records?

At 13:05 12/18/2002, Csongor Fagyal, wrote: >What you need to have is a _good_ install, and then MySQL is superb. But >to have a "good install" is not as easy as it sounds. Can you list the elements of a good install? Start Here to Find It Fast!© -> http://www.US-Webmasters.com/best-start-page

MySQL acces from WinXP

Hi! I've just start to use MySQL on a Linux box. I didn't do any special, just set it up via Webmin (create DB, add user). It is a RedHat 8.0 and I use the MySQL inclued in the original distribution. From the Linux box everything seems to work, but when I try to connect to the MySQL server fro

Re: Can MySQL handle 120 million records?

Michael Bacarella wrote: We've never lost data. Our database server has crashed hard from OS failures and suffered plenty of unclean shutdowns. MySQL/InnoDB always recovers perfectly. Running a slave off-site tops off crash recovery almost 100%. We run a backup of our clients' data to mul

Re: Recover deleted records

Hello. On Wed 2002-12-18 at 14:49:12 +, [EMAIL PROTECTED] wrote: > Hi, > > I posted this a few days ago, but haven't seen a reply as yet, and I'm > getting quite desperate now!! You probably got no reply because there is no real solution to your problem. > I've managed to delete all the re

Re: Can MySQL handle 120 million records?

Joe Stump wrote: Like previous posters have pointed out. If given the same freedom within Oracle's online documentation you'd have to believe there would be horror stories outlining loss of data. The most significant factor I've ever seen in people liking Oracle for their sites is the spee

SELECT and UPDATE at the same time?

Hello again, I'm selecting a group of records from my database. I then loop through the selected records and do some work based on what I find. But what I also want to do as I interrogate each record is update some of its fields with new values... but won't that screw up the outer loop? I mean

RE: Can MySQL handle 120 million records?

Use "iostat -x" while the query is running. You are likely I/O bound doing a table scan on the protected (BIG) table. There has been alot of discussion about RAM and CPU on this thread regarding performance, but nothing regarding disk I/O. If you're going to put tens of millions of records in a da

Re: 3.23.54a Instability

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 18 Dec 2002, Kees Hoekzema wrote: > Recently I tried to upgrade MySQL to a newer version. I have > 3.23.53a-max running but that is vulnarable to a bug. So I went to > mysql.com and grabbed the .54a-max binary. > > First thing I noticed was th

RE: MySQL security flaws uncovered

The real problem is the lack of a central knowledgebase. Is there one that I'm not aware of? Even if there is, it should be very obvious off the front page of the website. > -Original Message- > From: Csongor Fagyal [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 18, 2002 5:34 AM

RE: Severe performace problem linking tables with mysql

Have you tried optimizing your query? It is more likely that the problem is a poorly optimized query and/or poorly tuned server than it is mySQL. Joins will be slow if you do not take the time to figure out the best way to do what you are trying to accomplish. Forcing the table order can really

Re: Severe performace problem linking tables with mysql

Joseph Dietz wrote: MediasMediaAuthorsAuthors pk_media_id fk_media_id, fk_author_id pk_author_id In your table definition, is there an index on each of your keys shown above? What kind of performance 'degredation'? How many values are you chec

RE: Can MySQL handle 120 million records?

That's the only thing wrong with Mysql is what it doesn't do. Everything it does do it does fantastically. > -Original Message- > From: Michael T. Babcock [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 18, 2002 10:12 AM > To: Michael She > Cc: Qunfeng Dong; [EMAIL PROTECTED]; [EMA

RE: 3.23.54a Instability

Hey Lenz, > Can you please try a "ldd /path/to/mysqld" and check, if it > requires shared libraries or is a static binary? Ok, here you go: # ldd /usr/local/mysql-max-3.23.54a-pc-linux-i686/bin/mysqld libdl.so.2 => /lib/libdl.so.2 (0x4002) libpthread.so.0 => /lib/libpthread.so

Re: Can MySQL handle 120 million records?

I guess you can say I'm a follower. Other DB systems have been in use for years, so their reliability has been generally proven through use. It's good to know that a lot of people have had success with MySQL, but considering MySQL is the new comer, I'm still a little tepid! At 01:22 PM 12/18

Re: Can MySQL handle 120 million records?

Michael She wrote: I guess you can say I'm a follower. Other DB systems have been in use for years, so their reliability has been generally proven through use. It's good to know that a lot of people have had success with MySQL, but considering MySQL is the new comer, I'm still a little tep

RE: 3.23.54a Instability

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 18 Dec 2002, Kees Hoekzema wrote: > Ok, here you go: > # ldd /usr/local/mysql-max-3.23.54a-pc-linux-i686/bin/mysqld > libdl.so.2 => /lib/libdl.so.2 (0x4002) > libpthread.so.0 => /lib/libpthread.so.0 (0x40024000) > l

Re: MySQL 3.23.54-max GLIBC errors

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, 13 Dec 2002, Nick wrote: > I am currently running MySQL3.23.53-max with no problems, well > my_print_default complains about the same thing that MySQL-3.23.54 > complains about, but MySQLd runs fine. I am attempting to upgrade to > MySQL3.23.

Re: Re: SELECT and UPDATE at the same time?

SELECT * FROM my_table WHERE Age > 50 AND UPDATE Status = "OLD" No. That's goofy anyway. Why wouldn't you just use a regular UPDATE query? UPDATE mytable Status = "OLD" WHERE Age > 50; Cos I want to do a fairly long-winded process on the records of those who are Age>50 and subsequently up

Suitability of mySQL for desktop use?

How suitable is mySQL for use in a desktop application i.e. one that would be installed completely by the user and run on a standalone PC? My application is written in Delphi and currently uses dBase files, but as Delphi support for accessing dBase files is being phased out, I am looking at possibl

RE: 3.23.54a Instability

> From: Lenz Grimmer [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 18, 2002 9:43 PM > OK, as I already assumed, the Max binary was not linked statically. Doh! > Interesting, that this also causes the load to spike, even though it's not > statically linked against an unpatched glibc. Maybe

  1   2   >