← prev | next →
piterden 2020-04-16 05:17:20
https://github.com/anomalylabs/redirects-module/pull/12
piterden 2020-04-16 05:18:20
https://github.com/anomalylabs/streams-platform/pull/436
Not success sometimes
piterden 2020-04-16 05:20:14
Also some of my work was stolen
https://github.com/anomalylabs/streams-platform/pull/412
Feature write bindings to SP class by Piterden · Pull Request #412 · anomalylabs/streams-platform –
GitHubAdded command to fill bindings, singletons and their uses into service provider class during making a stream with artisan command.
piterden 2020-04-16 05:32:56
Sometimes my awesome features were dismissed https://github.com/tj/commander.js/pull/621
He wrote it a bit unnecessary as he thought. Then after a few month they added color output to a main command
MasterZiv 2020-04-16 05:39:14
AleHerz 2020-04-15 13:17:10
Always the same, the connection is dropped, “Lock wait timeout exceeded” (from the client)
Stop, is it deadlock or Network error? The logs say it is Network. Why deadlock then?
MasterZiv 2020-04-16 05:41:06
Master Yoda 2020-04-15 17:05:15
I have no idea about VPS. I don’t think the variable you mentioned tobe a problem tho not sure. You can set this variable using SET SESSION innodb_lock_wait_timeout=100 or so. I haven’t used much cloud service providers. But you can try digital ocean , pay according to use.
If it is a real deadlock this will not help.
Manogna 2020-04-16 05:48:46
piterden 2020-04-16 05:14:35
To practice as much as you need
I am asking… what’s the query for finding experience of an employee from his date of joining…
MasterZiv 2020-04-16 05:49:02
Manogna 2020-04-16 04:48:15
How-to find experience of an employee from date of joining?
Explain you question!
MasterZiv 2020-04-16 05:49:29
Manogna 2020-04-16 05:48:46
I am asking… what’s the query for finding experience of an employee from his date of joining…
Explain what experience is
Manogna 2020-04-16 05:50:52
MasterZiv 2020-04-16 05:49:29
Explain what experience is
Diff between today’s date and date of joining…
MasterZiv 2020-04-16 05:52:26
Manogna 2020-04-16 05:48:46
I am asking… what’s the query for finding experience of an employee from his date of joining…
It seems all you need is calculating interval between two dates, this is made by means of some date function like datediff or another similar.
Check the docs and find it
Manogna 2020-04-16 05:53:48
Ya but . Sometimes they will ask in years ir months or days right
MasterZiv 2020-04-16 05:56:02
Manogna 2020-04-16 05:53:48
Ya but . Sometimes they will ask in years ir months or days right
This is what your task specification should state, they must decide beforehand in what units they want to see this experience.
Manogna 2020-04-16 05:56:43
MasterZiv 2020-04-16 05:56:02
This is what your task specification should state, they must decide beforehand in what units they want to see this experience.
Could you please write the query
MasterZiv 2020-04-16 05:57:10
Manogna 2020-04-16 05:53:48
Ya but . Sometimes they will ask in years ir months or days right
It you can calculate then all at once, in yes, months, weeks, days and hours
MasterZiv 2020-04-16 05:57:34
As a separate result columns
MasterZiv 2020-04-16 05:58:11
Manogna 2020-04-16 05:56:43
Could you please write the query
It is so trivial that it is uninteresting to write it
MasterZiv 2020-04-16 19:22:08
HTML can’t connect to a database, at all
HTML is not a programming language. You must be using some programming language on the server side, use it for connecting the DB
MasterZiv 2020-04-16 19:23:37
MasterZiv 2020-04-16 19:22:08
HTML can’t connect to a database, at all
HTML is not a programming language. You must be using some programming language on the server side, use it for connecting the DB
They are like PHP, Python, Ruby, Java, and so on…
MasterZiv 2020-04-16 20:22:06
Classic DB applications look like client and server. The client is usually a GUI app and the server is a DBMS that is serving queries to the database.
WEB applications are different, they at least have 3 tiers, the front or client, the web-server, and a database,
Clietn tier has this html, JS, and what shit they put in it. Client sends HTTP queries to web server and receives the feedback usually as HTML, XML, JSON or similar, and the web server works with the DB and queries the data and processes it,
And the DB is a DBMS of some kind.
It is considered to be a very bad practice if you stick the DB out to the Internet, that is, if a WEB client accesses the DB directly, and nobody does things like this , and web client has very little or nothing at all to work with databases.
aqilhaziqazman 2020-04-20 18:08:43
hello. is there anyone that can help me with two question “create a stored procedure……”? urgent
MasterZiv 2020-04-20 20:55:51
aqilhaziqazman 2020-04-20 18:08:43
hello. is there anyone that can help me with two question “create a stored procedure……”? urgent
No, nobody’s at home
work_sakura 2020-04-27 01:40:02
Hi everyone, is there some book/useful resource that would allow me to understand how to make faster and more efficient import of dump?
MasterZiv 2020-04-27 07:01:51
work_sakura 2020-04-27 01:40:02
Hi everyone, is there some book/useful resource that would allow me to understand how to make faster and more efficient import of dump?
You must explain first what kind of dump you mean to use.
On Persona’s site there’s a lot of materials in angry topic related to performance of mySQL.
ICUI4CUtwo 2020-04-27 07:32:20
work_sakura 2020-04-27 01:40:02
Hi everyone, is there some book/useful resource that would allow me to understand how to make faster and more efficient import of dump?
MySQL database dump…?
work_sakura 2020-04-27 15:40:16
I have sql dump of mariadb
work_sakura 2020-04-27 15:40:21
It is 109 gb file
work_sakura 2020-04-27 15:40:32
I am importing it on another system
work_sakura 2020-04-27 15:48:04
MasterZiv 2020-04-27 07:01:51
You must explain first what kind of dump you mean to use.
On Persona’s site there’s a lot of materials in angry topic related to performance of mySQL.
Its maria db file created with mysqldump and i am importing it now on machine with 4 cores and 96gb ram, although 109gb dump is big and it takes time i was looking for ways to speed it up
work_sakura 2020-04-27 15:48:40
I wont interupt current import in 12 hours it got to 25% according to pv, but for future i wanted to study what i can do
Master Yoda 2020-04-27 19:54:05
Take physical backups
ysf_cms 2020-04-27 21:28:49
hello everyone i yusuf, i just joined the group. i am happy about that
Manejandodatos 2020-04-27 23:40:33
Hi, my name is David. I work with MySQL and i am migrating a server from 5.5.x to 8.0.18.
Anyone has experience doing this before?
MasterZiv 2020-04-28 00:09:18
Manejandodatos 2020-04-27 23:40:33
Hi, my name is David. I work with MySQL and i am migrating a server from 5.5.x to 8.0.18.
Anyone has experience doing this before?
Do you experience some difficulties or are you just curious about the process?
MasterZiv 2020-04-28 00:11:17
Manejandodatos 2020-04-27 23:40:33
Hi, my name is David. I work with MySQL and i am migrating a server from 5.5.x to 8.0.18.
Anyone has experience doing this before?
Because it must be pretty straight-forward process, do dump if the old DB, create the new, load the dump, enjoy.
Manejandodatos 2020-04-28 00:16:47
MasterZiv 2020-04-28 00:09:18
Do you experience some difficulties or are you just curious about the process?
I am having issues
MasterZiv 2020-04-28 00:20:15
Manejandodatos 2020-04-28 00:16:47
I am having issues
Then announce them!
MasterZiv 2020-04-28 00:20:32
Tell us about them!
MasterZiv 2020-04-28 00:22:09
Manejandodatos 2020-04-28 00:16:47
I am having issues
It is useless when you ask questions like this, your problems may be even unrelated to the migration
Manejandodatos 2020-04-28 00:23:35
Yes, problems are related to utf8, i didnt realice it before, and some features that will be deprecated. As an exsmple, int (number)
ysf_cms 2020-04-28 15:24:28
Hello, everyone . does anyone know about tecdoc ?
MasterZiv 2020-04-28 17:12:46
ysf_cms 2020-04-28 15:24:28
Hello, everyone . does anyone know about tecdoc ?
What’s tecdoc ?
Sofas1 2020-04-28 22:43:41
Master Yoda 2020-04-27 19:54:05
Take physical backups
Sure this saves a lot of time.
ysf_cms 2020-04-29 00:50:19
tecdoc is a cataog for outomotive spare parts catalog
kutasior 2020-04-29 02:54:09
Hello every one 🙂
kutasior 2020-04-29 02:56:16
kutasior 2020-04-29 02:56:24
I have this problem how to solve it?
piterden 2020-04-29 03:01:03
kutasior 2020-04-29 02:56:24
I have this problem how to solve it?
Change collation to known one
smlkw 2020-04-29 07:51:51
kutasior 2020-04-29 02:56:16
Maybe, your MySQL version does not support this collation.
kutasior 2020-04-29 11:23:05
how to fix this problem ??
← prev | next →
