473,837 Members | 1,595 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Mysql running slow on Mandrake Linux 10.0 for AMD 64

Hi,

I'm having a problem with a new machine running Mysql version 4.0.18
on the AMD64 version of Mandrake 10.0. The new machine has got 64bit
AMD processor and 2GB of RAM.

Nearly all queries(updates are especially slow) are running 20/30 or
more times slower than on an inferior(32 bit processor, 1.5GB RAM)
machine runnning Mysql 3.23.56 on mandrake 9.0.

As far as I can tell mysql is configured correctly for the power of
the machine.
The my.cnf file looks like this:

# This is for large system with memory of 1G-2G where the system runs
mainly
# MySQL.
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /var/lib/mysql) or
# ~/.my.cnf to set user-specific options.
#
# One can in this file use all long options that the program supports.
# If you want to know which options a program support, run the program
# with --help option.

# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
#turn off ability to use InnoDB tables
skip-innodb
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_pac ket = 1M
table_cache = 512
sort_buffer_siz e = 2M
read_buffer_siz e = 2M
read_rnd_buffer _size = 2M
myisam_sort_buf fer_size = 64M
thread_cache = 8
query_cache_siz e = 32M
tmp_table_size = 64M
# Try number of CPU's*2 for thread_concurre ncy
thread_concurre ncy = 8
# Replication Master Server (default)
# binary logging is required for replication
log-bin

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id = 1
# Point the following paths to different dedicated disks
#tmpdir = /tmp/
tmpdir=/home/mysqltemp
#log-update = /path-to-dedicated-directory/hostname

# Uncomment the following if you are using BDB tables
#bdb_cache_size = 384M
#bdb_max_lock = 100000

# Uncomment the following if you are using InnoDB tables
#innodb_data_ho me_dir = /var/lib/mysql/
#innodb_data_fi le_path = ibdata1:2000M;i bdata2:10M:auto extend
#innodb_log_gro up_home_dir = /var/lib/mysql/
#innodb_log_arc h_dir = /var/lib/mysql/
# You can set .._buffer_pool_ size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_ pool_size = 384M
#innodb_additio nal_mem_pool_si ze = 20M
# Set .._log_file_siz e to 25 % of buffer pool size
#innodb_log_fil e_size = 100M
#innodb_log_buf fer_size = 8M
#innodb_flush_l og_at_trx_commi t = 1
#innodb_lock_wa it_timeout = 50

[mysqldump]
quick
max_allowed_pac ket = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 256M
sort_buffer_siz e = 256M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 256M
sort_buffer_siz e = 256M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout
Does anyone know any reason why the new machine is so rubbish??

Thanks in advance
Scott
Jul 20 '05 #1
0 1824

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
3707
by: barsepsi | last post by:
(I apologize for my "ugly" english... :-) I'm a beginner with Linux (Mandrake 9.1) and try to run my own local web server. Apache 1.3.27 et PHP 4.3.3 are OK. The problem is MySQL... I tried with the 3.23.56 version and the 4.0.1. Always, I recompiled. I have installed also phpMyAdmin (once agin, in 2 versions) in order to understand what happened. It is able to connect to the database but not to read the data. I tried to "see" my...
0
1847
by: W I L L | last post by:
I have a few qeustions for some linux/mysql pros in here. Background: I've just built MySQL on Mandrake Linux 9.1 from source. I can get the mysql service running my: shell> /usr/local/mysql/bin/mysqld_safe --user=mysql & but I don't know how to keep it running, or how to make it start at every bootup. How do I do that? Also, I've made an alias to mysql:
3
863
by: Mark Adams | last post by:
I am a relative newbie to MySQL. I had a Postfix+Courier+MySQL mail server running for several months. It took me a week or so to get it up and running in September. Now, I did a clean upgrade to Mandrake 9.2 and am reinstalling everything. This thing is kicking my ass and I can't seem to get past it. I could really use some help if anybody has any. Just for reference, this was my primary source for information on installation and...
0
3955
by: Mike Chirico | last post by:
Interesting Things to Know about MySQL Mike Chirico (mchirico@users.sourceforge.net) Copyright (GPU Free Documentation License) 2004 Last Updated: Mon Jun 7 10:37:28 EDT 2004 The latest version of this document can be found at: http://prdownloads.sourceforge.net/souptonuts/README_mysql.txt?download
2
2060
by: William Friend | last post by:
Im rather new to Linux and my server has been running great, up until the other day. I was messing around with mysql through webmin in mandrake 9.2 and know I cant do anything, not even create a database. I keep getting this message ( DBI connect failed : Access denied for user: '@localhost' to database 'mysql') and have no clue how to fix it. I have tried to reinstall the rpms that came on the mandrake 9.2 cds and I still get the same...
2
2136
by: Derek | last post by:
Hello Sorry if this has been asked before but here we go any way. I am running Mandrake Linux 9 with MYSQL 3.23.52 ( I know not the latest but it did work). I have been running/using the database for about 6 weeks now without a problem. I rebooted the Linux box and now MYSQL doesn't seem to be running and will not start. I get the following error message 'cant connect to local
0
519
by: Plymouth Acclaim | last post by:
Hi guys, We have a problem with Dual AMD64 Opteron/MySQL 4.0.18/Mandrake 10 for a very high volume site. We are evaluating the performance on our new server AMD64 and it seems it's slow compared to Dual Xeon/MySQL 4.0.15/RedHat8 and Dual Xeon/MySQL 4.0.18/Mandrake 10. And it seems there are zombie threads. 570 threads in 1 hour and we didn't even use JDBC connection pooling at all. These threads are supposed to be gone within 60...
0
1352
by: Scott | last post by:
Hi, I'm having a problem with a new machine running Mysql version 4.0.18 on the AMD64 version of Mandrake 10.0. The new machine has got 64bit AMD processor and 2GB of RAM. Nearly all queries(updates are especially slow) are running 20/30 or more times slower than on an inferior(32 bit processor, 1.5GB RAM) machine runnning Mysql 3.23.56 on mandrake 9.0.
11
17587
by: DJJ | last post by:
I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL tables to a Microsoft Access 2003 database. I am finding that the data from the MySQL tables takes a hell of a long time to load making any kind linkage with my Access data virtually useless. I have the MySQL driver setup in as a USER DSN. The MySQL data is sitting out on a server and the Access database is running locally. The network connection is very...
0
9833
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10867
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10617
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
7803
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5666
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5842
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4469
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4036
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3122
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.