Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• mysql openssl Question
• mysql:it 's a db not a dbms how it 's possible?!
• Does the binary log enabling affect the MySQL performances?
• Strange behavior, Table Level Permission
• FULLTEXT query format question
• Preventing Duplicate Entries
• Comparing and writing out BLOBS
• Executing MySQL Commands From Within C Program
• Can 't access mysql after kernel upgrade
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Downgrade Mysql from 4 to 3 23
• MySQL Cluster Software
• mysql test 4 1 fails with the gis test
• ERROR 2002: Can 't connect to local MySQL server through socket
• Getting Identity after INSERT
• Update one field with more fields from another table
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• mysql have same function mthod as Oracle decode()
 
Configuration changes crashed Database

Configuration changes crashed Database

2007-02-12       - By Beermann, Albert

 Back
Hello Everbody !

I need more power for my production database.

For testing I have a 7.6.00.34 database with default configuration on an suse
linux system with 8 giga ram

Now I changed some parameters

Cache_size = 600000

Cache_cat_supply = 60000

Maxcpu = 2



Ok ! database is running !

Now i want to increase the max usertasks to 500

up to 310 user everything is ok, with 320 user ths database crashed !

In knldiag.err i found:

malloc error failed to allocate TRACE space

please check critical database parameters

MAXUSERTASKS,MAXSERVERTASKS,CACHE_SIZE,TRACE_PAGES_...



MAXSERVERTASKS = 134, but increasing this value gives me another crash



What is the relation between MAXUSERTASKS, MAXSERVERTASKS,CACHE_SIZE,TRACE
_PAGES_... ???

Do i need special a linux configuration

 

I need the configuration parameters for 500 users



Any help welcomed.

Best regards

Albert Beermann

   Piepenbrock Service GmbH & Co. KG
Hannoversche Stra?e 91-95
49084 Osnabr?ck
Tel:  + 49 (0) 5 41/ 58 41-868
Fax: + 49 (0) 5 41/ 58 41-869
mailto:a.beermann@(protected)

Der Inhalt dieser E-Mail ist vertraulich. Falls Sie nicht der angegebene Empf
?nger sind oder falls diese E-Mail irrt?mlich an Sie adressiert wurde, verst
?ndigen Sie bitte den Absender sofort und l?schen Sie die E-Mail sodann. Das
unerlaubte Kopieren sowie die unbefugte ?bermittlung sind nicht gestattet. Die
Sicherheit von ?bermittlungen per E-Mail kann nicht garantiert werden. Falls
Sie eine Best?tigung w?nschen, fordern Sie bitte den Inhalt der E-Mail als
Hardcopy an.

<http://www.piepenbrock.de/>  




<html>

<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859 (See http://iso-8859.ora-code.com)-1">
<meta name=Generator content="Microsoft Word 10 (filtered)">

<style>
<!--

p.MsoNormal, li.MsoNormal, div.MsoNormal
  {margin:0cm;
  margin-bottom:.0001pt;
  font-size:12.0pt;
  font-family:"Times New Roman";}
a:link, span.MsoHyperlink
  {color:blue;
  text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
  {color:purple;
  text-decoration:underline;}
p
  {margin-right:0cm;
  margin-left:0cm;
  font-size:12.0pt;
  font-family:"Times New Roman";}
span.EmailFormatvorlage17
  {font-family:Arial;
  color:windowtext;}
@(protected) Section1
  {size:595.3pt 841.9pt;
  margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.Section1
  {page:Section1;}
-->
</style>

</head>

<body link=blue vlink=purple>

<div class=Section1>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Hello Everbody !</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>I need more power for my production database.</span><
/font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>For testing I have a 7.6.00.34 database with default
configuration on an suse linux system with 8 giga ram</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Now I changed some parameters</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Cache_size = 600000</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Cache_cat_supply = 60000</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Maxcpu = 2</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>&nbsp;</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Ok ! database is running !</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Now i want to increase the max usertasks to 500</span
></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>up to 310 user everything is ok, with 320 user ths
database crashed !</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>In knldiag.err i found:</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>malloc error failed to allocate TRACE space</span><
/font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>please check critical database parameters</span><
/font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>MAXUSERTASKS,MAXSERVERTASKS,CACHE_SIZE,TRACE_PAGES_..
.</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>&nbsp;</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>MAXSERVERTASKS = 134, but increasing this value gives
me another crash</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>&nbsp;</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>What is the relation between MAXUSERTASKS,
MAXSERVERTASKS,CACHE_SIZE,TRACE_PAGES_... ???</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Do i need special a linux configuration</span></font>
</p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>? </span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>I need the configuration parameters for 500 users<
/span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>?</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Any help welcomed.</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Best regards </span></font></p>

<div>

<p class=MsoNormal><b><font size=2 color=navy face=Arial><span style='font-size
:10.0pt;font-family:Arial;color:navy;font-weight:bold'>Albert
Beermann</span></font></b></p>

<p class=MsoNormal style='margin-left:18.0pt;text-indent:-18.0pt'><font size=1
color=navy face="Times New Roman"><span style='font-size:7.0pt;color:navy'><img
width=17 height=17 src="cid:image001.gif@(protected)">?? </span></font>
<font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family
:Arial;
color:navy'>Piepenbrock Service GmbH &amp; Co. KG<br>
Hannoversche Stra?e 91-95<br>
49084 Osnabr?ck<br>
Tel:&nbsp;&nbsp;+ 49 (0) 5 41/ 58 41-868<br>
Fax: + 49 (0) 5 41/ 58 41-869<br>
mailto:a.beermann@(protected) </span></font></p>

<p style='margin-right:11.0cm;text-align:justify'><font size=1 face=Arial><span
style='font-size:8.0pt;font-family:Arial'>Der Inhalt dieser E-Mail ist
vertraulich. Falls Sie nicht der angegebene Empf?nger sind oder falls diese
E-Mail irrt?mlich an Sie adressiert wurde, verst?ndigen Sie bitte den Absender
sofort und l?schen Sie die E-Mail sodann. Das unerlaubte Kopieren sowie die
unbefugte ?bermittlung sind nicht gestattet. Die Sicherheit von ?bermittlungen
per E-Mail kann nicht garantiert werden. Falls Sie eine Best?tigung w?nschen,
fordern Sie bitte den Inhalt der E-Mail als Hardcopy an.</span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10
.0pt;font-family:Arial;color:navy'><a href="http://www.piepenbrock.de/"></a><
/span></font><font color=navy><span style='color:navy'>&nbsp;</span></font></p>

</div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;</span></font></p>

</div>

</body>

</html>