Questions tagged [optimization]

Optimization is the process of modifying a system to make some aspect of it work more efficiently or use fewer resources.

A system may be optimized so that it executes more rapidly, or is capable of operating with less memory storage or other resources, or draw less power. The optimized system will typically only be optimal in one application or for one audience. For example, one might reduce the amount of time a task takes to perform at the price of making it consume more memory.

339 questions
0
votes
1 answer

optimize Mysql 8.0 performance for millions of small tables

my data structure is around 0.2 million Innodb tables. each table is not longer than 300 rows. And the number grows by ~3000 tables per day. I'm afraid that this may bottleneck my I/O operations while looking for the required tables. Each table is…
0
votes
0 answers

What is the ideal value for threads on thread_pool in nginx config?

I have a machine with 2x CPU 24 Cores, 48 Threads Total: 48 Cores, 96 Threads. My nginx default configuration came configured with threads=32 thread_pool pool_name threads=32 max_queue=0; Should i change my nginx config file from threads=32 to…
melk
  • 1
  • 2
0
votes
1 answer

Tightvnc Server using only 1 core?

I have a server setup with 8 cores and 32gb of RAM. I am using it to launch as many java applications as I can and hope to make the most efficient use of my resources. Upon launching I notice the server begins lagging fairly badly and Xtightvnc is…
Plee
  • 131
  • 1
  • 3
0
votes
1 answer

product import is broke behind cloudflare

Im having trouble to resolve my database errors and how to optimize it. Coz of the slowness of my server (mostly querries i believe), my imports turns with a cloudflare error code. (Cloudflare blocks connections over 15 secs as i remember) Need…
0
votes
2 answers

MariaDB 10.3 per thread memory usage and low CPU utilization

I am a bit unsure why we are seeing these memory numbers while the cpu usage is actually very low. -------- Storage Engine Statistics ----------------------------------------------------------------- [--] Status: +Aria +CSV +InnoDB +MEMORY…
0
votes
1 answer

Cost of Parameterization in SQL Server 2008

Does Anybody know absolute or relative cost of forzed parameterization in SQL Server 2008?
fravelgue
  • 117
  • 4
0
votes
1 answer

mysql thread and tomcat thread should be the same for a better perfoming?

my tomcat instance on ubuntu server running with mysql and only the application has access to mysql (only the service-user tomcat). I have small experience level with optimizing with mysql and tomcat. For a good perfomance should the maxthread…
beard black
  • 67
  • 2
  • 14
-1
votes
1 answer

Tracking the slow - how to list all processes related to web-server?

I wanted to ask people in this community about administration of the Debian based web server - its a dedicated server, hosting a single website. From time to time the web site is slowing down, on some occasions becoming unresponsive for a…
-1
votes
1 answer

What will be the best mysql settings for 3gb server?

I have a 3GB server with the below settings. The issue I am facing is when I pull some records through the admin panel of my site, sometimes it works well, but most of the times it process very slow. Can you please suggest the…
-1
votes
1 answer

Server optimization for long running script

I have a system running on a remote VPS whose main feature is a long running script (it could run for about 10 hours, depending on the user input). The following are some of its features: Database insertion and selection (MySQL) HTTP Post…
cawecoy
  • 273
  • 3
  • 11
-1
votes
1 answer

Recommended resources for server tuning and security checklist for production Linux server deployment

There are many questions on server tuning and security checklist are being closed. So, I am not asking for the exact detail. Please point me to the resources you find it is helpful (no matter web server, db server etc) and worth reading (and still…
Howard
  • 2,135
  • 13
  • 48
  • 72
-1
votes
1 answer

Nginx , Apache , Mysql , Memcache with server 4G ram. How optimize to enought memory?

i have 1 dedicated server with Nginx proxy for Apache. Memcache, mysql, 4G Ram. These day, my visitor on my site wasn't increased, but my server get overload always in some specified time. (9AM - 15PM) Ram in use is increased second by second to…
TomSawyer
  • 101
  • 1
  • 3
-1
votes
4 answers

Improve server performance by configuring MySQL

I have a server with 8GB of memory, running CentOS 5.4, php 5.2.9, mysql 5.0.77. I have a very large databse of about 20GB (InnoDB and MyIsam tables) and website using it. Website has about 20000 visitors per day and about 100 000 pageviews per…
dennisg
  • 1
  • 1
  • 3
-1
votes
1 answer

Should a well-optimized ad server be able to run fine on a single dedicated server?

This is a completely hypothetical question that myself and a colleague have been wondering/debating about, and we thought some of the knowledgeable people at SF could shed some light. Say, for example, you have an ad server that delivers around 10…
James Simpson
  • 1,651
  • 2
  • 15
  • 31
-2
votes
2 answers

Server bandwidth is going crazy, after reboot all ok

I have a streaming server with 10gbps card on it. I'm using ~2.5gbps. My server is running perfect for 8-9 hours / day, and after that is going crazy, and everyone is freezing. At exactly the same time i reboot the system , and everything is back to…
user3393046
  • 131
  • 2
  • 11
1 2 3
22
23