logs archiveChat DB / Freenode / #mysql / 2015 / November / 5 / 1
Deep6
folks, is there a de-obfuscation webpage to break down a complex query (what appears to be an SQL injection) into discrete parts?
Pew_Pew_Pew
Why does no one chat but so many people join and quit?
I might as well quit
danblack
!g Deep6 sql formatter
ubiquity_bot
Deep6: See http://google.com/search?btnG=1&q=sql+formatter
reev_
Hii, I have written a c program to connect to a database , how can i make sure that it remain in the connected state as long as program is runing
in mysql
as per the mysql api for c , I am using mysql_real_connect function to connect to the db
danblack
why do you think its a good idea?
what's the program doing generally?
reev_
program is going to perform some actions based upon the output returned from queries made to the db
internally
danblack
are you depending on a repeatible-read isolation level?
reev_
I don't know i am smart enought to figure out what you have said but could you please tell me how can i make sure that it remain in the connected state
*not
danblack
reev_: if you are probably best of catching the disconnected error and reconnecting again if it fails.
or explicitly closing and opening the connection between events
long connections can impact the operation of the server and connection time is really cheap by comparison.
reev_
danblack: so what's your call on this?? how should i proceed ???
danblack
close connections after getting the data, reopen connections when you need more data.
if retrieving data returns an timeout error, reconnect and try again.
reev_
danblack: okay, I will try it
e01
hi
is there performance difference between compact and redunand row formats in innodb engine
bhuddah
ping?
Vacuity
pong?
Takumo
Hi all, I have a table, I know its not very big but if I try to SELECT COUNT(*) from it
it never returns
other tables in the database (some with probably 100x more rows) work fine
jkavalik
Takumo, MyISAM or InnoDB?
Takumo
InnoDB
jkavalik
Takumo, run "EXPLAIN SELECT COUNT(*) FROM <table>;" and pastebin the results, add the results of "show create table <table>;"
Takumo
jkavalik: can't do the first one, doesn't respond :(
jkavalik
explain does not respond? thats weird.. what mysql version?
Takumo
here's the create table: http://ix.io/lU7
jkavalik: 5.5.40
jkavalik
Takumo, can you run the explain and then the select itself and while it is "hanging" check a "show full processlist;" from a different connection?
Takumo
yes
waiting for table metadata lock
jkavalik
any alter or other ddl running (in the processlist)?
Takumo
oh
even if I kill all connecting processes
(I think) its still got a bunch of processes waiting for table metadata lock
any way to kill all connections for a given user?
or just kill the pids?
jkavalik
now try "SHOW ENGINE INNODB STATUS" instead of the processlist in the second connection while first one is waiting on the lock, it should tell you some details about the locks
Takumo
I need to kill all these processes
but it says I don't own them? :(
oh wait
I can log in as that user derp
michael_p
hi is there away to get someone to install pdo on my computer
jkavalik
Takumo, just randomly killing stuff is not really a solution
Takumo
jkavalik: it is for now
there are a *lot* of processes here waiting for metadata lock on this table
darwin
01:28 < jkavalik> any alter or other ddl running (in the processlist)?
is the correct question.
jkavalik
Takumo, thats because "someone" is working with the table such way that it is not safe to access it at the moment - find who is doing what
Takumo
no one
I killed the application
there is nothing communicating with the db at the momment
jkavalik
Takumo, that does not mean some long running operation is not present, or it is part of a backup/migration/something else not directly from the application - standard applications should not run DDL
Takumo
jkavalik: db migrations would run ddl
and there weren#t
the user is used only for a single application which I had killed
jkavalik
the user who what? who tried the count?
Takumo
no, that was me, and me only
the other user who caused it in the first place
jkavalik
or the other waiting queries? these all were waiting for something, did you identify that something?
if you did not then you cannot know if and when it will happen again
Takumo
an application I had terminated
no open connection
jkavalik
Takumo, ok then, did it solve the problem?
Takumo
it did. However when I started the application up again and retried the action, the same thing happened
it at least gives me an idea of what's up
jkavalik
maybe there is some explicit locking going on in the app
michael_p
mysqli is there any programmers
Takumo
jkavalik: shouldn't be, looking at the app's code... but it is when trying to update a row it gets stuck waiting for lock
Azundris
jbruehe: ping?
e01
is there performance differences between COMPACT and REDUNAND row formats?
jkavalik
Takumo, update should not lock metadata exclusively.. only row lock (or table in myisam)
Takumo
still looking into it, let's see as it unfolds ;)
watmm
Looking for a buffer pool flush now command. Was sure i found one before but can't find it, anyone?
JJjack
hi did anyone hear from dunnock lately?
jbruehe
Azundris: pong, and thanks for helping. Should be solved now. (Just the beeper is missing, but that's a local issue.)
XL
e01: not that I ever measured it - but COMPACT was introduced to shift workload from storage to cpu. Because most databases are IO-bound, not CPU-bound. Of course it depends a lot on the data - if it can be compactified or not.
e01: but if your tables are smaller with row_format=compact then I bet queries will also be faster. Also backup.
watmm
I've restored a database from a dump but it's images aren't displaying. Do i have to copy the db directory from the datadir too?
Naktibalda
images?
michael_p
anyone know of anyone that can do mysql conversion
watmm
Anything static
Naktibalda
what is a mysql conversion?
watmm: do you mean files stored in database?
michael_p
mysql to mysqli
watmm
Naktibalda: yup
XL
michael_p: that would be a PHP problem. offtopic here
Naktibalda
find out why they aren't displaying
XL
watmm: first check if anything is stored in the database. Like SELECT HEX(image_blob) ... WHERE ...
robscow
using innodb, if i select 10m rows and start downloading/streaming them (with the use_result option), and some updates occur during it, what's the behaviour? I have a download that takes hours, but updates can and do happen during that time
Naktibalda
!m robscow innodb consistent reads
ubiquity_bot
Naktibalda: Sorry, I have no idea about that manual entry.
1 2 3 4 5 6 next »