Performance MySQL Artikel kopieren / Copy article MySQL

Get help with installation and running phpwcms here. Please do not post bug reports or feature requests here.
Post Reply
strandel
Posts: 50
Joined: Sun 2. May 2004, 22:45

Performance MySQL Artikel kopieren / Copy article MySQL

Post by strandel »

GERMAN

Hallo
Wenn ich im Backend einen Artikel kopiere und ein Duplikat einfüge, dauert dieser Vorgang ca. 20 Sekunden. Sonst ist aber alles sehr schnell und keine Performance-Probleme vorhanden.
Server: 2.8 Ghz Pentium 4, 1 GB Ram, PHP 4.4.1, Linux Redhat ES, eaccelerator 0.9.4-rc1, MySQL 3.23.58 (Update auf Version 4 nicht möglich).
Danke für eure Hilfe
Gruss Hans

my.cnf
[mysqld]
safe-show-database
innodb_data_file_path=ibdata1:10M:autoextend
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = max_connections=500

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

****************************************

ENGLISH

Hello
When I try to copy an article in the backend to make a duplicate of this article, it takes roughly 20 seconds for this procedure. All the rest is pretty fast and there are no performance issues.
Server: 2.8 Ghz Pentium 4, 1 GB Ram, PHP 4.4.1, Linux Redhat ES, eaccelerator 0.9.4-rc1, MySQL 3.23.58 (Update to Version 4 is not possible).
my.cnf
[mysqld]
safe-show-database
innodb_data_file_path=ibdata1:10M:autoextend
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = max_connections=500

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Thanks for your feedbacks.
Regards Hans
Post Reply