<div>
doesn't answer both of my questions
</div>


<div>
Apparently the EE police doesn't accept my point of view
</div>


Apparently the EE police doesn't accept my point of view

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I have an Atom (CPU D510 @ 1.66GHz) based Foxconn Nettop equipped with 1Gb RAM<br />
running Debian Squeeze<br />
<br />
It is basically a Syslog Repository<br />
I recently tried to run a few queries and ran into memory issues:<br />

<blockquote>
mysql&gt; select * from SystemEvents;<br />
mysql: Out of memory (Needed 3616652 bytes)<br />
ERROR 2008 (HY000): MySQL client ran out of memory
</blockquote>
Syslog MyISAM DB row count (SystemEvents):<br />
+-------------------------<wbr />-------+<br />
| SUM(TABLE_ROWS) |<br />
+-------------------------<wbr />-------+<br />
| &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22996792 |<br />
+-------------------------<wbr />-------+<br />

<blockquote>
swapon -s<br />
Filename &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Type &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Size &nbsp; &nbsp;Used &nbsp; &nbsp;Priority<br />
/dev/sda7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; partition &nbsp; &nbsp; &nbsp; 3004112 53180 &nbsp; -1<br />

</blockquote>
Is there a guide or rule of thumb to help one evaluate CPU and memory requirements for a DB system ?<br />
Apart from FTP'ing the MySQL files to another system to run my queries is there a solution that would allow me to interrogate my table ?<br />
thanks<br />
yann
</div>
</div>


Hi

I have an Atom (CPU D510 @ 1.66GHz) based Foxconn Nettop equipped with 1Gb RAM
running Debian Squeeze

It is basically a Syslog Repository
I recently tried to run a few queries and ran into memory issues:
mysql> select * from SystemEvents;
mysql: Out of memory (Needed 3616652 bytes)
ERROR 2008 (HY000): MySQL client ran out of memory
Syslog MyISAM DB row count (SystemEvents):
+--------------------------------+
| SUM(TABLE_ROWS) |
+--------------------------------+
|                    22996792 |
+--------------------------------+
swapon -s
Filename                                Type            Size    Used    Priority
/dev/sda7                               partition       3004112 53180   -1

Is there a guide or rule of thumb to help one evaluate CPU and memory requirements for a DB system ?
Apart from FTP'ing the MySQL files to another system to run my queries is there a solution that would allow me to interrogate my table ?
thanks
yann

MySQL client ran out of memory

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.

Linux

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.