Budget: 600 UAH Deadline: 2 days
Good day . I can see. The road question is what the maximum number of simultaneously launched requests you have observed. The number of simultaneous requests in the average.
Proposals concealed
Proposals are currently absent
-
Vladimir Malomuzh 30 March 2018Сам сервер уходит в перезагрузку? Или демон mysql? Попробуйте в самой ОС покопиорвать большие файлы в несколько потоков. Если резултат будет такой же то нужно перебрать весь сервер. От диска, ядра ... и до настроек mysql
-
Alex Bycha
30 March 2018
Вот текуши my.cnf может вам он поможет понять что не так настроено
# $FreeBSD: branches/2017Q3/databases/mysql57-server/files/my.cnf.sample.in 414707 2016-05-06 14:39:59Z riggs $
[client]
port = 3306
socket = /tmp/mysql.sock
[mysql]
prompt = \u@\h [\d]>\_
no_auto_rehash
[mysqld]
#innodb_force_recovery = 1
#innodb_log_checksums = 0
#innodb_checksums = OFF
log_error = /data/db/mysql/mysql_error.log
user = mysql
port = 3306
socket = /tmp/mysql.sock
bind-address = 127.0.0.1
basedir = /usr/local
datadir = /data/db/mysql
tmpdir = /var/db/mysql_tmpdir
slave-load-tmpdir = /var/db/mysql_tmpdir
slave-skip-errors = 1062
secure-file-priv = /data/db/formatted
#log-bin = NO
log-output = TABLE
master-info-repository = TABLE
relay-log-info-repository = TABLE
relay-log-recovery = 1
slow-query-log = 1
server-id = 1
sync_binlog = 1
sync_relay_log = 1
binlog_cache_size = 16M
expire_logs_days = 30
default_password_lifetime = 0
enforce-gtid-consistency = 1
gtid-mode = ON
safe-user-create = 1
lower_case_table_names = 1
explicit-defaults-for-timestamp = 1
myisam-recover-options = BACKUP,FORCE
open_files_limit = 40000
table_open_cache = 32384
table_definition_cache = 8192
net_retry_count = 16384
key_buffer_size = 512M
max_allowed_packet = 256M
query_cache_type = 0
query_cache_size = 0
long_query_time = 1
innodb_buffer_pool_size = 3G
innodb_buffer_pool_load_at_startup = OFF
innodb_data_home_dir = /data/db/mysql
innodb_log_group_home_dir = /data/db/mysql
innodb_tmpdir = /data/db/mysql_tmp
innodb_data_file_path = ibdata2:512M:autoextend
innodb_temp_data_file_path = ibtmp2:512M:autoextend
innodb_flush_method = O_DIRECT
innodb_log_file_size = 256M
innodb_log_buffer_size = 16M
innodb_write_io_threads = 8
innodb_read_io_threads = 8
innodb_autoinc_lock_mode = 2
skip-symbolic-links
collation-server = utf8_unicode_ci
init-connect = 'SET NAMES utf8'
character-set-server = utf8
[mysqldump]
max_allowed_packet = 512M
quote_names
quick
Current freelance projects in the category Databases & SQL
C# / .NET WPF Developer – Completion of Migration of a Large Invoicing Program RAFSOFT.NET Sp. z o.o. is looking for a C# / .NET developer to complete the rewriting of a large, long-standing invoicing program to a new technology. The project involves the migration of an extensive desktop application for companies, used for invoicing, handling sales documents, contractors, records, and accounting-tax functions. The new version of the program is being created in C# / .NET, using DevExpress components. The project is already about 70% rewritten. We are looking for someone who can help bring it to completion, organize the missing elements, perform tests, and ensure the new version operates in accordance with the existing program. Scope of Work: completion of the migration of a large desktop application to C# / .NET, recreation of the functionality of the old program in the new version, maintaining as identical logic of operation, appearance, and handling as possible, working with DevExpress components, analyzing existing code and comparing the operation of the old and new versions of the program, fixing bugs, completing missing functions, and testing the application, collaborating on the final preparation of the program for deployment. Requirements: very good knowledge of C# and .NET, experience in creating desktop applications for Windows, knowledge of WPF or WinForms, experience with DevExpress or similar UI component libraries, ability to analyze a large existing project, accuracy and patience in reproducing existing functionality, ability to test one's own changes, very good ability to use AI tools supporting programming, code analysis, refactoring, and testing. Preferred: experience with legacy projects, knowledge of or previous work with Visual Basic 6.0, experience in migrating applications from older technologies to C# / .NET, knowledge of issues related to invoicing, accounting, JPK, or KSeF, experience working with large business applications. Who We Are Looking For: We are looking for a self-sufficient, precise, and technically experienced person who can enter an existing project, understand its logic, and consistently bring it to completion. In this project, it is very important not only to write new code but also to faithfully reproduce the operation of the old program — both in terms of functionality and appearance as well as handling. We also require proficiency in using AI tools in daily programming work. We are looking for someone who can use AI practically: for code analysis, bug finding, speeding up migration, creating tests, and organizing the project. About the Company: RAFSOFT.NET Sp. z o.o. is a Polish company creating software for entrepreneurs, accounting offices, and small and medium-sized enterprises. Our main product is the VAT Invoice program, supporting the daily handling of invoices, sales documents, contractors, records, and settlements in accordance with Polish regulations. We develop our own desktop applications and tools related to invoicing, accounting, KSeF, JPK, and automation of business processes. Our solutions are designed with stability, ease of use, and practical application in users' daily work in mind. Company website: www.rafsoft.net
It is necessary to calculate statistics in a medical project (including correlations). Additionally, there is a request to create a mathematical model for predicting the development of pathologies based on available data.
Hello, I need your help in implementing a task. Fix the bugs on the website page, the page displays a 404 error.
Project Meta Implement Viber integration without using third-party CRM systems. All work with messages should be done directly in our internal CRM based on BAS / 1C 8.3.Current System BAS / 1C 8.3 Custom configuration "Customer Service" Database of over 40,000 subscribersRequired Implementation Integration through an official Viber Business provider (TurboSMS, GMS Worldwide, or another agreed service). The button "Write to Viber" in the subscriber card. Sending messages directly from BAS. Receiving incoming messages via Webhook. Automatic linking of messages to the subscriber by phone number. Complete preservation of correspondence history in the subscriber card. Displaying the time, message status, and the manager who responded. Simultaneous work of multiple managers. Message templates for quick responses. Assistance with setting up the Viber provider, API keys, and Webhook. Transfer of all source code and settings after the work is completed.Acceptance Conditions The work is considered completed after successful testing of all functions on the working database and transfer of the source code.Guarantee 1 month warranty for fixing bugs related to the implemented functionality. Further modifications are carried out by separate agreement.Result After the project is completed, managers should be able to fully work with Viber directly in BAS: write to clients, receive responses, view correspondence history, and communicate without using third-party CRMs. All source code, modifications, API keys, and settings will be transferred to the client after the project is completed.
It is necessary to correct the SQL scripts for the Postgres database. It is required to check the scripts and update data from external Excel tables and between two Postgres databases (different servers). Scripts will be run through AnyDesk using Navicat. List of data for verification and correction: 1. Products subject to repair – assignment of a mark Result: Number of records discrepancies Correction script 2. List of Categories, Groups, Subgroups – comparison with the tmp table Result: Number of records discrepancies Correction script 3. Number of products in category. Groups, subgroups. (statistics) – Comparison by table, identification of discrepancies Result: Number of records discrepancies Correction script 4. List of spare parts in the system with category, group, subgroup - Comparison by table, identification of discrepancies, elimination of discrepancies Number of records discrepancies Correction script 5. Repair items related to spare parts - Comparison by table, identification of discrepancies, elimination of discrepancies Discrepancy table Correction script 6. Reconciliation of balances and SN Discrepancy table