Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Server load at type IN( request)

Z
zymir last edited by

That's the question, if I make a sql request like, WHERE id IN(12,3,54,5,6,8,234) And so on, will this not cause, for example, the fall of the server if the number of those most IN You're gonna grow up to, like, 10,000 identifiers?
Reply Quote 0
1 Reply Last reply
K
Kadyn last edited by

MS Sql Server leaves an exception if the request has more than 2,100 parameters. MySql may have such restrictions, too. If I have to make a sample that has more than 2,100 values in IN, I group the set of values and make a few requests.
Reply Quote 0
1 Reply Last reply

2
Posts

0
Views

Suggested Topics

C

What works fast and right in mySql sample.
Software Programming • mysql sql • • Cleofas

2

0
Votes

2
Posts

0
Views

C

To screen a single quote inside a line in a single quote, we can double it:'mus''ub1' The question of the speed of execution of requests is probably quite sympathetic, and most depends, as far as I can imagine, on the existence/existence of indices for the fields involved and on the volume of stored data.but the indexes also have a " float side " : more time is spent on additions (and most likely modifications).
E

Limit simultaneous requests to server in ajax
Software Programming • jquery ajax google chrome chrome extension • • emerson

2

0
Votes

2
Posts

0
Views

B

So, async: falsethat's not the same. They're in line.$a = ["url1", "url2", ... "url24"]; $.each($a, function(k, v){ setTimeout(function(){ $.ajax({ url: v }); }, k * 125); }); 125 is 1/8 seconds; k is a mass index, but better an in time variable
C

Decrease SQL database size [Oracle] - ORA-12953
Software Programming • sql oracle optimization orac languagele11g • • chanisef

2

0
Votes

2
Posts

0
Views

C

You can change the tables to go cleaning the data with:alter table mytable enable row movement oralter table mytable shrink space cascade https://github.com/maniero/SOpt/blob/master/SQL/DML/AlterTableCleanup.sql . https://stackoverflow.com/q/10934037/221800 .
M

What's the latest on MySQL Proxy?
SQL, Database Testing • mysql mysql proxy • • magpie

2

0
Votes

2
Posts

0
Views

B

From an email on the MySQL lists sent earlier this month, Shawn Green (a MySQL Principal Technical Support Engineer) reports: Thanks to the corporate changes of the last few years, the sole developer has been too busy doing his primary job to really put any more time into the project and no person or group from the community has stepped forward to help push the project to a final deliverable state. So I suppose the latest state of development is it's on hold.
How can I get rid of this UNION?
Software Programming • mysql sql mariadb base de datos • • jeanid

2

0
Votes

2
Posts

0
Views

In the end, analyzing the problem comes to the conclusion that if the tables were to be joined, then the query done more quickly, so that it creates a stored procedure to fill a temporary table, so:CREATE PROCEDURE `crear_tabla_liquidaciones_visibles`(IN id_empresa INT, IN anio INT, IN mes INT, IN quincena INT) BEGIN DROP TEMPORARY TABLE IF EXISTS tmp_liquidaciones_visibles; CREATE TEMPORARY TABLE IF NOT EXISTS tmp_liquidaciones_visibles ENGINE=MEMORY SELECT lt.id_detalle_liquidacion AS id_detalle_liquidacion, lt.cod_concepto AS cod_concepto, lt.columna AS columna, lt.concepto AS concepto, lt.valor AS valor, lt.cantidad AS cantidad, lt.comentario AS comentario, lt.id_liquidacion AS id_liquidacion, lt.id_empleado AS id_empleado, lt.id_periodo_liquidado AS id_periodo_liquidado, lt.id_empresa AS id_empresa, lt.quincena AS quincena, lt.anio AS anio, lt.mes AS mes, lt.no_remunerativo AS no_remunerativo, lt.no_imponible_9 AS no_imponible_9, lt.id_sobre AS id_sobre, 0 AS guardada FROM Liquidaciones_temporales lt WHERE lt.anio = anio AND (lt.mes = mes OR mes = -1) AND (lt.quincena = quincena OR quincena = -1) AND lt.id_empresa = id_empresa; INSERT INTO tmp_liquidaciones_visibles SELECT lg.id_detalle_liquidacion AS id_detalle_liquidacion, lg.cod_concepto AS cod_concepto, lg.columna AS columna, lg.concepto AS concepto, lg.valor AS valor, lg.cantidad AS cantidad, lg.comentario AS comentario, lg.id_liquidacion AS id_liquidacion, lg.id_empleado AS id_empleado, lg.id_periodo_liquidado AS id_periodo_liquidado, lg.id_empresa AS id_empresa, lg.quincena AS quincena, lg.anio AS anio, lg.mes AS mes, lg.no_remunerativo AS no_remunerativo, lg.no_imponible_9 AS no_imponible_9, lg.id_sobre AS id_sobre, 1 AS guardada FROM Liquidaciones_guardadas lg WHERE lg.anio = anio AND (lg.mes = mes OR mes = -1) AND (lg.quincena = quincena OR quincena= -1) AND lg.id_empresa = id_empresa AND NOT EXISTS( SELECT 1 FROM Liquidaciones_temporales lt2 WHERE lt2.anio= anio AND (lt2.mes= mes OR mes = -1) AND (lt2.quincena= quincena OR quincena = -1) AND lt2.id_empresa= id_empresa AND lt2.id_sobre = lg.id_sobre AND lt2.mes = lg.mes AND lt2.anio = lg.anio AND lt2.quincena = lg.quincena AND lt2.id_empresa = lg.id_empresa AND lt2.id_empleado = lg.id_empleado); END The theme is that wheres are parameterized to the views, so that it only works with the assemblies after being filtered, which is much faster than joining the tables and then filtering them.In conclusion: I think the best way to fix it would be if you could parameterize the views, but mysql doesn't allow it any more with some workaround as you see in https://stackoverflow.com/questions/2281890/can-i-create-view-with-parameter-in-mysql .
J

Loading data at Server side rendering through getInitialProps
Software Programming • reactjs redux • • Jolied

2

0
Votes

2
Posts

0
Views

Z

Look at this. https://github.com/kirill-konshin/next-redux-wrapper - I worked with him. There's an explanation. https://habr.com/ru/post/323588/ It's all natural on the Routine page.The asynchronous exchenes passed through redux-thunk.export default withRedux(makeStore)(class MyApp extends App {....
I am shown other records in a MySQL consultation
Software Programming • mysql • • Mystic

2

0
Votes

2
Posts

0
Views

D

To show only one result in you being the first limit the query by remaining the following waySELECT * FROM productos WHERE id_prog=1 AND sub_categoria_prod='Aceites' AND sibol_prod LIKE '%Aceite%' OR nombre_prod LIKE '%Aceite%' AND categoria_prod = "Ingredientes" If what you are looking for the last element you will only have to order in a descending manner and re-limit to one to show the last. I hope your doubt turned out.
S

Request for server via wget
Software Programming • linux post wget • • Saumya

2

0
Votes

2
Posts

0
Views

B

Thank you, everyone! Server didn't mean to communicate at http-protocol. Those bikes I received were parts of the erroneous report or other trash.
A

Processing javascript requests on the python server
Software Programming • javascript python • • amarantha

2

0
Votes

2
Posts

0
Views

T

There's a simple web server on python. import socket It's not WebSocket.If you really want to use the WS, keep reading.Attention recommended to the library, and the code I did not check, it's the first google reference. https://pypi.org/project/websockets/ ) the following text is free translation part of the article https://websockets.readthedocs.io/en/stable/intro.html#browser-based-example , that's Browser-based example.RequirementsPython ≥ 3.4 (beam Python ≥ 3.6).Installationdetermine the next team's dependence.pip install websockets Browser-based examplethis is an example of launching a WebSocket server and joining it from the browser.Let this squeak out of the console.#!/usr/bin/env python WS server that sends messages at random intervals import asyncio import datetime import random import websockets async def time(websocket, path): while True: now = datetime.datetime.utcnow().isoformat() + 'Z' await websocket.send(now) await asyncio.sleep(random.random() * 3) start_server = websockets.serve(time, '127.0.0.1', 5678) asyncio.get_event_loop().run_until_complete(start_server) asyncio.get_event_loop().run_forever() Then create index.html The file with the following content and open it to the browser.<!DOCTYPE html> <html> <head> <title>WebSocket demo</title> </head> <body> <script> var ws = new WebSocket("ws://127.0.0.1:5678/"), messages = document.createElement('ul'); ws.onmessage = function (event) { var messages = document.getElementsByTagName('ul')[0], message = document.createElement('li'), content = document.createTextNode(event.data); message.appendChild(content); messages.appendChild(message); }; document.body.appendChild(messages); </script> </body> </html>
A

Query with two summaries for the same column
Software Programming • mysql sql query mysql workbenc languageh • • Avante

2

0
Votes

2
Posts

0
Views

A

Yeah, you can do this without resorting to a subquery. As the "Secured Seams" are a sub-set of "Total Sales" you must use the first query as the basis for what you want.Use one CASE to restrict sales in the calculation of the total "Liquid Seams"For the condition "when the field serie. document_type_id for 15, in the inner join of the document_detail table the field may not be doc.id but doc.source_id" is enough, once again, to use a CASE.In the end the query would look like this:select month(emitido_date) as mes, ifnull(sum((det.preco * det.quantidade) * (iva.valor/100) + (det.preco * det.quantidade) - (det.preco * det.quantidade * (det.desconto/100))),0) as totalVendas, ifnull(sum(case when serie.documento_tipo_id in (10, 11, 15) then (det.preco * det.quantidade) * (iva.valor/100) + (det.preco * det.quantidade) - (det.preco * det.quantidade * (det.desconto/100)) else 0 end),0) as totalLiquidado from documento as doc inner join documento_serie as serie on serie.id = doc.documento_serie_id inner join documento_detail as det on case when serie.documento_tipo_id = 15 then doc.source_id = det.documento_id else doc.id = det.documento_id end inner join phos_iva as iva on iva.id = det.iva_id where serie.documento_categoria_id = 3 and doc.rascunho = false and doc.exercicio_id = 4 group by mes order by mes
S

How do you calculate mysql max_connections variable?
SQL, Database Testing • mysql configuration my.c languagenf max c languageonnec langu • • simrah

2

0
Votes

2
Posts

0
Views

O

Going to post this as an answer, with the relevant information. The basic formulas are: Available RAM = Global Buffers + (Thread Buffers x max_connections) max_connections = (Available RAM - Global Buffers) / Thread Buffers To get the list of buffers and their values: SHOW VARIABLES LIKE '%buffer%'; Here's a list of the buffers and whether they're Global or Thread: Global Buffers: key_buffer_size, innodb_buffer_pool_size, innodb_log_buffer_size, innodb_additional_mem_pool_size, net_buffer_size, query_cache_size Thread Buffers: sort_buffer_size, myisam_sort_buffer_size, read_buffer_size, join_buffer_size, read_rnd_buffer_size, thread_stack
Highly loaded server testing
Software Programming • linux so epoll • • briley

2

0
Votes

2
Posts

0
Views

I used to make such measurements. Client and server processes are launched on the same host (yes, this is a significant shortcoming). In general, the number of connections (data are not available). You can see the code. http://pastebin.com/vbMLKhrB Translibrary gcc conn.c -pthreads♪I don't remember how to use it right now, but there's something like help-a. ./a.out -h) As quickly as possible, when the number of customer flows (those that connect and create loads) is indicated, the port of the server must be indicated. For example:./a.out -T2 -C4 12345 16 Starts four client processes with 16 flows (up to 4 per process), they are connected to the port of 12345 servers (this is a separate process, launched automatically) that serves the flow connections from the pool (track 2)../a.out -t -s 12345 32 launch a server that selects and processes each compound in the new flow, and a client from one process creates 32 load flows./a.out -y The four-currency (this default is a customer from one process and four streams) is asynchronously processed by a server using epoll, both for new compounds and data fragments.Well, a combination of arguments might be a lot. If you're interested (and start experimenting), you'll probably figure it out. Then let me know (remind @avp in the commentary and then a note will come), I will refresh my memory and we can discuss these topics (but only on Sunday or Monday night).
M

Fill tables with various foreign keys
Software Programming • mysql foreign key relational model • • magpie

2

0
Votes

2
Posts

0
Views

E

In MySQL, you can use a feature of it called LOAD DATA INFILE.The LOAD DATA INFILE statement allows you to read data from a text file and import the file’s data into a database table very fast.With it, you can directly load a CSV from your file system and move to a database table MySQL.If you have an Aviao table (abstract some fields as I do not have the details of your table):CREATE TABLE Aviao ( codAviao INT NOT NULL AUTO_INCREMENT, data_registro DATE NOT NULL, nome VARCHAR(50) NOT NULL PRIMARY KEY (codAviao ) ); And a CSV called ships. csv, with this content:codAviao, data_registro, nome 1, 20150809, "Aviao 1" 2, 20140809, "Aviao 2" You can import this way (with the file avioes. csv located in c:/tmp/):LOAD DATA INFILE 'c:/tmp/avioes.csv' INTO TABLE discounts FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS; More details you can find here: http://www.mysqltutorial.org/import-csv-file-mysql-table/ To ensure the integrity of the information at the end of the process, since you (probably) need to enter information from related tables not yet imported into one of the imports, just at the beginning of the import disable foreign key verification:SET FOREIGN_KEY_CHECKS=0; and then enable again at the end of the import:SET FOREIGN_KEY_CHECKS=1;
Z

Update many rows in a table with a single statement?
SQL, Database Testing • mysql update replac languagee • • zymir

2

0
Votes

2
Posts

0
Views

R

First here is sample data mysql> drop table if exists mytable; Query OK, 0 rows affected (0.03 sec) mysql> create table mytable -> ( -> id int not null, -> value VARCHAR(255), -> primary key (id) -> ); Query OK, 0 rows affected (0.06 sec) mysql> insert into mytable (id) values (1),(2),(3); Query OK, 3 rows affected (0.06 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql> select * from mytable; +----+-------+ | id | value | +----+-------+ | 1 | NULL | | 2 | NULL | | 3 | NULL | +----+-------+ 3 rows in set (0.00 sec) mysql> Here is the new query update mytable A inner join ( SELECT 1 id,'xyz' value UNION SELECT 2 ,'abc' UNION SELECT 3 ,'def' ) B USING (id) SET A.value = B.value; Here is the new query executed mysql> update mytable A inner join -> ( -> SELECT 1 id,'xyz' value UNION -> SELECT 2 ,'abc' UNION -> SELECT 3 ,'def' -> ) B USING (id) -> SET A.value = B.value; Query OK, 0 rows affected (0.06 sec) Rows matched: 3 Changed: 0 Warnings: 0 mysql> select * from mytable; +----+-------+ | id | value | +----+-------+ | 1 | xyz | | 2 | abc | | 3 | def | +----+-------+ 3 rows in set (0.00 sec) mysql>
Count the number of days between dates
Software Programming • php sql • • irl

2

0
Votes

2
Posts

0
Views

May be (PHP):$now = time(); // текущее время (метка времени) $your_date = strtotime("2017-01-01"); // какая-то дата в строке (1 января 2017 года) $datediff = $now - $your_date; // получим разность дат (в секундах) echo floor($datediff / (60 * 60 * 24)); // вычислим количество дней из разности дат Why don't we split the number of seconds? 60 * 60 * 24? Number of seconds ♪ 60 We'll get the number of minutes. seconds). Then, with a few minutes. 60 - We'll get the number. (in one hour, sixty minutes). And then I'll take a few hours. 24 - We'll get the number of days.Example from here: https://stackoverflow.com/a/2040589/5275890 Example of checking the date between two dates: https://stackoverflow.com/a/19070307/5275890 There's an example for ruSO: https://ru.stackoverflow.com/a/451773/189339 For reference: http://php.net/manual/ru/function.time.php http://php.net/manual/ru/function.strtotime.php http://php.net/manual/ru/datetime.diff.php Some comments are worth noting: http://php.net/manual/ru/function.strtotime.php - Transform the English version of the date into the Unix time.The timeline of Unix is the number of seconds since 1 January 1970, 00:00 UTC. http://php.net/manual/ru/function.strtotime.php - returns the time mark in case of success, or comes back. FALSE♪ Before PHP 5.1.0, in case of error, the function was returned -1♪

Server load at type IN( request)

Suggested Topics

What works fast and right in mySql sample. Software Programming • mysql sql • • Cleofas

Limit simultaneous requests to server in ajax Software Programming • jquery ajax google chrome chrome extension • • emerson

Decrease SQL database size [Oracle] - ORA-12953 Software Programming • sql oracle optimization orac languagele11g • • chanisef

What's the latest on MySQL Proxy? SQL, Database Testing • mysql mysql proxy • • magpie

How can I get rid of this UNION? Software Programming • mysql sql mariadb base de datos • • jeanid

Loading data at Server side rendering through getInitialProps Software Programming • reactjs redux • • Jolied

I am shown other records in a MySQL consultation Software Programming • mysql • • Mystic

Request for server via wget Software Programming • linux post wget • • Saumya

Processing javascript requests on the python server Software Programming • javascript python • • amarantha

Query with two summaries for the same column Software Programming • mysql sql query mysql workbenc languageh • • Avante

How do you calculate mysql max_connections variable? SQL, Database Testing • mysql configuration my.c languagenf max c languageonnec langu • • simrah

Highly loaded server testing Software Programming • linux so epoll • • briley

Fill tables with various foreign keys Software Programming • mysql foreign key relational model • • magpie

Update many rows in a table with a single statement? SQL, Database Testing • mysql update replac languagee • • zymir

Count the number of days between dates Software Programming • php sql • • irl

What works fast and right in mySql sample.
Software Programming • mysql sql • • Cleofas

Limit simultaneous requests to server in ajax
Software Programming • jquery ajax google chrome chrome extension • • emerson

Decrease SQL database size [Oracle] - ORA-12953
Software Programming • sql oracle optimization orac languagele11g • • chanisef

What's the latest on MySQL Proxy?
SQL, Database Testing • mysql mysql proxy • • magpie

How can I get rid of this UNION?
Software Programming • mysql sql mariadb base de datos • • jeanid

Loading data at Server side rendering through getInitialProps
Software Programming • reactjs redux • • Jolied

I am shown other records in a MySQL consultation
Software Programming • mysql • • Mystic

Request for server via wget
Software Programming • linux post wget • • Saumya

Processing javascript requests on the python server
Software Programming • javascript python • • amarantha

Query with two summaries for the same column
Software Programming • mysql sql query mysql workbenc languageh • • Avante

How do you calculate mysql max_connections variable?
SQL, Database Testing • mysql configuration my.c languagenf max c languageonnec langu • • simrah

Highly loaded server testing
Software Programming • linux so epoll • • briley

Fill tables with various foreign keys
Software Programming • mysql foreign key relational model • • magpie

Update many rows in a table with a single statement?
SQL, Database Testing • mysql update replac languagee • • zymir

Count the number of days between dates
Software Programming • php sql • • irl