Categories
Linux Mastering Development

Output from Bonnie++ doesn’t match up

I just ran bonnie++ ten times to test the performance of a file server. After removing the verbose output this is what remains: format_version,bonnie_version,name,concurrency,seed,file_size,io_chunk_size,putc,putc_cpu,put_block,put_block_cpu,rewrite,rewrite_cpu,getc,getc_cpu,get_block,get_block_cpu,seeks,seeks_cpu,num_files,max_size,min_size,num_dirs,file_chunk_size,seq_create,seq_create_cpu,seq_stat,seq_stat_cpu,seq_del,seq_del_cpu,ran_create,ran_create_cpu,ran_stat,ran_stat_cpu,ran_del,ran_del_cpu,putc_latency,put_block_latency,rewrite_latency,getc_latency,get_block_latency,seeks_latency,seq_create_latency,seq_stat_latency,seq_del_latency,ran_create_latency,ran_stat_latency,ran_del_latency 1.98,1.98,15.local,1,1602631781,8G,,8192,5,901,93,45205,13,23092,10,1162,90,66262,8,369.7,16,1,,,,100,18,1,360,4,21,0,18,1,542,4,20,0,12295us,665ms,1903ms,48384us,1944ms,5397ms,1652ms,13917us,2866ms,507ms,4953us,803ms 1.98,1.98,15.local,1,1602631781,8G,,8192,5,891,93,46620,14,23701,10,1177,90,66461,8,674.0,15,1,,,,100,18,1,406,4,22,0,18,1,559,4,23,0,12010us,1415ms,1264ms,52618us,496ms,69643us,1267ms,10064us,515ms,958ms,4650us,829ms 1.98,1.98,15.local,1,1602631781,8G,,8192,5,909,93,47824,14,21431,9,1147,88,67050,8,754.3,17,1,,,,100,20,1,400,4,19,0,14,1,530,3,20,0,11888us,1177ms,2710ms,45197us,1021ms,127ms,398ms,4562us,2874ms,1317ms,4810us,1006ms 1.98,1.98,15.local,1,1602631781,8G,,8192,5,890,91,37540,12,21765,9,1183,90,66822,8,1419,22,1,,,,100,19,1,461,3,23,0,19,1,547,3,19,0,11992us,548ms,864ms,46664us,480ms,25566us,760ms,44844us,1036ms,704ms,4778us,6449ms 1.98,1.98,15.local,1,1602631781,8G,,8192,5,795,83,43425,13,23066,10,1218,93,938042,27,1282,17,1,,,,100,19,1,406,4,21,0,18,1,560,4,23,0,53141us,14308ms,2786ms,39855us,71572us,6216ms,1761ms,6592us,1224ms,511ms,4654us,504ms 1.98,1.98,15.local,1,1602631781,8G,,8192,5,870,91,37339,11,21559,9,1187,91,924835,26,1499,19,1,,,,100,20,1,401,5,25,1,19,1,545,4,20,0,11615us,907ms,1870ms,44530us,352ms,1694us,626ms,4660us,359ms,659ms,5166us,972ms 1.98,1.98,15.local,1,1602631781,8G,,8192,5,881,93,37399,11,22194,9,1199,92,66756,8,1341,21,1,,,,100,17,1,409,4,20,0,17,1,557,4,23,0,11831us,1334ms,1113ms,45929us,579ms,29992us,4185ms,4348us,985ms,521ms,4889us,442ms 1.98,1.98,15.local,1,1602631781,8G,,8192,5,879,92,37592,12,21603,9,1208,93,4320730,99,1485,18,1,,,,100,17,1,403,4,22,0,16,1,570,3,19,0,11683us,665ms,1118ms,23421us,158us,5495ms,1623ms,4401us,592ms,863ms,10107us,1072ms 1.98,1.98,15.local,1,1602631781,8G,,8192,5,879,92,37386,11,21728,9,1168,90,554500,18,1516,19,1,,,,100,19,1,410,4,25,1,18,1,553,3,27,1,11325us,1617ms,1546ms,42335us,476ms,1812us,681ms,4294us,357ms,870ms,4776us,261ms 1.98,1.98,15.local,1,1602631781,8G,,8192,5,850,92,37915,11,21600,9,1159,88,141678,10,1513,20,1,,,,100,20,1,403,5,22,0,16,1,604,3,22,0,12674us,1461ms,1496ms,62742us,382ms,123ms,786ms,5874us,690ms,956ms,5011us,795ms but pasting this into a spread sheet results in missing columns (there are two header columns fewer than there are data […]

Categories
Mastering Development

Select relationship columns and query inside with method eloquent laravel

Using with method to retrieve relations I stuck here: I have 3 tables, news, users and news_user: users: id, name, email, is_admin, role_id, internal_id, timestamps news: id, title, subtitle, slug, published, timestamps news_user: id, user_id, news_id, action_id, timestamps So as you can see I created this news_user as a pivot table and returning to my […]

Categories
User Help Web Apps

Google Sheets: Link/Sync Two Cells Dynamically (based on a third column’s data)

I want to preface this by saying this is NOT a duplicate of Sync two cells value. It’s similar, and uses the OnEdit() Function of Google Sheets, but the solution presented in that thread only works statically. This is an extension of that issue, not the same issue. Let’s act like I work for Twitch […]

Categories
User Help Web Apps

Google Sheets: Link/Sync Two Cells Dynamically (based on a third column’s data)

I want to preface this by saying this is NOT a duplicate of Sync two cells value. It’s similar, and uses the OnEdit() Function of Google Sheets, but the solution presented in that thread only works statically. This is an extension of that issue, not the same issue. Let’s act like I work for Twitch […]

Categories
Mastering Development System & Network

Optimizing NGINX Configuration for video serving

Hello I have set up my VPS for media delivery (mp4 videos) to my main site, this VPS is only used for this purpose, my website is hosted on a different VPS. I think the speed is a bit slow but not a big problem currently but I want to make sure that it is […]

Categories
CMS Drupal Mastering Development

Extracting user field values from dynamic SQL queries

Aim I have successfully written a fairly long dynamic sql query, however am struggling with a seemingly simple part at the end. Although, I am able to successfully extract mail and name from the users table, when I try to extract field_first_name it returns the error below. The users table has a column with the […]

Categories
Mastering Development

How can I submit HTML form data into MySql database table using javascript along with node.js – mysql and without php?

I was trying to make a blog where a viewer(guest) can send message to the blogger. HTML form prepared and in onclick() function of the Submit button of the HTML form, a javascript (named Db_connect.js) function named submitData() is executed. In submitData(), two more functions are called from the same javascript – one to establish […]

Categories
User Help Web Apps

Google Sheets: Link/Sync Two Cells Dynamically (based on a third column’s data)

I want to preface this by saying this is NOT a duplicate of Sync two cells value. It’s similar, and uses the OnEdit() Function of Google Sheets, but the solution presented in that thread only works statically. This is an extension of that issue, not the same issue. Let’s act like I work for Twitch […]

Categories
Mastering Development System & Network

Setting up a Django + Postgres + PgBouncer through Docker

I have an existing Django app where Django runs in a Docker container (served through uvicorn), and Postgres runs in another Docker container. In my settings.py I have DATABASES = { "default": { "ENGINE": "django.db.backends.postgresql", "NAME": <name>, "USER": <user>, "PASSWORD": <pw>, "HOST": "db", "PORT": "5432", } } For postgres I just have FROM postgres:12.4-alpine in […]