Hi Rudolf,
Here's the quick answer.
Copy the text of the script into a text file and save it as SQLOptimize.sh
(or whatever you want to call it).
Change the permissions to make it executable, something like 'chmod 755
./SQLOptimize.sh
Execute the script by typing ./SQLOptimize.sh at the command
Hi Rory,
Humbled, impressed and very thankful.
Regards
Rudolf
Von: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] Im Auftrag von Rory
Gesendet: Dienstag, 30. August 2011 13:45
An: User questions and discussions about OTRS.
Betreff: Re: [otrs] Otrs with lighttpd + fastcgi
Hi Rudolf
Hi Rory, but all your script does is OPTIMIZE TABLE for all OTRS tables, right?
Actually, typically the only tables that need OPTIMIZEing are the
sessions table and maybe the web_upload_cache tables; but you can also
use the FS backends for session and web upload cache; then you don't
have this
Rudolf,
You're welcome. I kept thinking of extra bits of information that I felt
were useful and after a while it turned out the message was huge and needed
a summary! I hope some of it was useful.
Michiel,
The script will iterate through all the tables in each database of the mysql
server. It
Why not ask Config.pm for the credentials?
On Tue, Aug 30, 2011 at 11:11 AM, Rory rcler...@gmail.com wrote:
Rudolf,
You're welcome. I kept thinking of extra bits of information that I felt
were useful and after a while it turned out the message was huge and needed
a summary! I hope some of
Hi Rory,
Thanks for posting your modifications.
Regards
Rudolf
Von: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] Im Auftrag von Rory
Gesendet: Freitag, 26. August 2011 16:34
An: User questions and discussions about OTRS.
Betreff: Re: [otrs] Otrs with lighttpd + fastcgi
That's a great
-boun...@otrs.org]mailto:[mailto:otrs-boun...@otrs.org] Im
Auftrag von Rory
Gesendet: Freitag, 26. August 2011 16:34
An: User questions and discussions about OTRS.
Betreff: Re: [otrs] Otrs with lighttpd + fastcgi
That's a great little optimisation script.
I hope you don't mind that I made some
Hi,
You do not mention if you use MySQL. For our setup it was not apache that was
the bottleneck, rather MySQL. There were a few things we did to speed up OTRS
dramatically:
1) Follow through all the steps mentioned in the OTRS support module
2) Restart all services (MySQL, Apache
If creating a ticket is very slow it could also be caused by various
other issues. Creating a ticket also usually sends mail notifications.
If you have a slow SMTP server this can take a long time.
To alleviate this issue I usually like to install a local postfix that
sends its messages to your
That's a great little optimisation script.
I hope you don't mind that I made some changes to it.
I've added code to ask the user for the DB username and password rather than
include them in the command line. I don't want my passwords to be readable
in plain text just by looking at the shell
Sorry for not providing full information,
It's a centOs 5.6 with mysql + apache + mod_perl
I've tried most of what you said, all issues in support module were solved,
mysql tables were optimizeds, my postfix is in the local machine, I will
check DNS resolution time
but I'll try this script and
On Thu, Aug 25, 2011 at 11:42 PM, Wagner wagner...@gmail.com wrote:
Hello,
has anyone tried using lighttpd + fascgi instead of apache + mod_perl?
My otrs is very slow, so I was wondering if this could help
Thanks
Hello,
Try to install support module ant do everything, what it suggests.
Already installed support module, and did everything it showed me.
Orts is getting slow when I do actions like, creating a new ticket, or when
a click in the + ou - button in the sysconfig module, as to add a new value
to freetext. Is it normal to take about 1 minute to create a ticket?
Thanks
On Fri, Aug 26, 2011 at 1:37 AM, Wagner wagner...@gmail.com wrote:
Already installed support module, and did everything it showed me.
Orts is getting slow when I do actions like, creating a new ticket, or when
a click in the + ou - button in the sysconfig module, as to add a new value
to
14 matches
Mail list logo