System resets when loading a large table

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Beau E. Cox
    #1

    System resets when loading a large table

    Hi -

    I have an application which is essentially 'read-only' -
    once the database is loaded it is only read from. So,
    I am trying to implement it with various indices and
    a table containg some large content in blob columns.
    I observe the max_allowed_pac ket setting and
    'split' blobs too large among multiple rows. All is fine
    during testing. However, when I try a production
    load (which should load about 1.5G to the various
    tables) the system resets at or near the 1G mark
    leaving no logs/msgs (that I can find) telling me
    what went wrong. I have tried the following to no
    avail:
    - 'disable' bin logging on the main 'content' table
    - RAID that table into 8 chunks.
    Sill, when the total in the .MYD chunks reaches
    1GB - KABOOM!

    My configuration:
    SuSE Linux 8,1
    Mysql 4.0.13
    loading with perl 5.8 using DBI 1.37/
    DBD::mysql 2.9002.

    Can someone suggest a next step?

    Aloha => Beau;
    == please visit ==
    <http://beaucox.com> => main site
    <http://howtos.beaucox. com> => howtos
    <http://PPM.beaucox.com > => perl PPMs
    <http://CPAN.beaucox.co m> => CPAN
    == thank you ==



    --
    MySQL General Mailing List
    For list archives: http://lists.mysql.com/mysql
    To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

    Tags: None
    • Aggro
      #2
      Re: System resets when loading a large table

      Beau E. Cox wrote:
      [color=blue]
      > tables) the system resets at or near the 1G mark
      > leaving no logs/msgs (that I can find) telling me
      > what went wrong. I have tried the following to no
      > avail:[/color]

      I'm no expert but could this be hardware failure? Perhaps something
      wrong with cpu, memory or motherboard that causes the hardware to do
      panic solution.

      I had a problem with cpu. It couldn't take a lot of cpu load without
      booting the machine.

        Comment

        • Aggro
          #3
          Re: System resets when loading a large table

          Beau E. Cox wrote:
          [color=blue]
          > tables) the system resets at or near the 1G mark
          > leaving no logs/msgs (that I can find) telling me
          > what went wrong. I have tried the following to no
          > avail:[/color]

          I'm no expert but could this be hardware failure? Perhaps something
          wrong with cpu, memory or motherboard that causes the hardware to do
          panic solution.

          I had a problem with cpu. It couldn't take a lot of cpu load without
          booting the machine.

            Comment

            Previous template Next
            Working...