Professional Web Applications Themes

Linux & MySQL on Intel - MySQL

Hello all, I have a project which I am not sure if MySQL can handel. I will be getting around 80Million records daily (230 bytes per record) I need to insert these in to a database and have only a month window, this would make my database after the first 4 months around 96 Billion records at 230 bytes each. I will have limited indexing, around 4 or 5 My question is can MySQL handle this, I will be running SuSe 8.2 or can upgrade to 10+ with a P4 with 1GB+ memory with a large RAID drive. Should I ...

  1. #1

    Default Linux & MySQL on Intel

    Hello all,

    I have a project which I am not sure if MySQL can handel.

    I will be getting around 80Million records daily (230 bytes per record)

    I need to insert these in to a database and have only a month window,
    this would make my database after the first 4 months around 96 Billion
    records at 230 bytes each.

    I will have limited indexing, around 4 or 5

    My question is can MySQL handle this, I will be running SuSe 8.2 or can
    upgrade to 10+ with a P4 with 1GB+ memory with a large RAID drive.

    Should I even attempt this? If so, where are the pitfalls?

    Thank you for reading this.

    Q

    Please respond to q<AT>starlinx.com or reply to the posting here

    Q Guest

  2. #2

    Default Re: Linux & MySQL on Intel

    Q wrote:
     


    You are out by an order of magnitude (9.6bn)


    --
    Brian Wakem
    Email: http://homepage.ntlworld.com/b.wakem/myemail.png
    Brian Guest

  3. #3

    Default Linux & MySQL on Intel

    Hello all,

    I have a project which I am not sure if MySQL can handel.

    I will be getting around 80Million records daily (230 bytes per record)

    I need to insert these in to a database and have only a month window,
    this would make my database after the first 4 months around 96 Billion
    records at 230 bytes each.

    I will have limited indexing, around 2 or 3 fields (date, phone number,
    etc..)

    My question is can MySQL handle this, I will be running SuSe 8.2 or can
    upgrade to 10+ with a P4 with 1GB+ memory with a large RAID drive.

    Should I even attempt this? If so, where are the pitfalls?

    Thank you for reading this.

    Q

    Please respond to q<AT>starlinx.com or reply to the posting here

    Q Guest

Similar Threads

  1. Replies: 3
    Last Post: February 2nd, 06:23 PM
  2. Replies: 1
    Last Post: September 2nd, 08:40 PM
  3. Intel Hyper Threading on Linux..
    By Louie Miranda in forum Debian
    Replies: 6
    Last Post: July 29th, 12:00 AM
  4. SE A1000, Intel, Linux
    By Pawel PIWOWAREK in forum Sun Solaris
    Replies: 3
    Last Post: July 18th, 04:04 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139