When is this system getting fixed? Having to log into web to answer email is idiotic...
Sent from my iPhone > On Aug 19, 2016, at 8:52 PM, Justin Swanhart <[email protected]> wrote: > > Oh yeah, this stupid system where I have to log into the web. So much stupid > around here. > >> On Fri, Aug 19, 2016 at 11:52 PM, Justin Swanhart <[email protected]> >> wrote: >> If you are using Galera, then aborted transactions due to lock conflict are >> reported as deadlocks. >> >> Temporary tables are not shared between connections and can not cause >> deadlocks. >> >> --Justin >> >>> On Fri, Aug 19, 2016 at 7:50 PM, AskMonty KB <[email protected]> wrote: >>> Hello, >>> >>> A new question has been asked in "MariaDB Knowledge Base" by WebtrendsData. >>> Please answer it at >>> http://mariadb.com/kb/en/lockingdeadlocking-on-temp-tables/ as the person >>> asking the question may not be subscribed to the mailing list. >>> >>> -------------------------------- >>> Hello - I am coming up to speed on MariaDB, I have a MS Sql Server and >>> Hadoop background but we are starting to use MariaDB heavily. We have some >>> queries that hit tables with mediumtext datatype columns. My understanding >>> is these types of queries will always generate temp tables directly to disk >>> (because of the text/blob types). I've confirmed our temp table engine is >>> Aria. >>> >>> From what I've read, in the mysql world, this situation would end up with a >>> MyIsam table on disk, which does not have row locking, only table locking. >>> I've tried looking for info on how Aria tables would handle this as I >>> suspect we are getting deadlocks on these tables. Our application is >>> reporting many database deadlocks, our entire database is all ExtraDB >>> tables, yet SHOW ENGINE INNODB STATUS does not report any deadlocks, which >>> leads me to think it is the temp tables. >>> >>> So I guess my question is, does the Aria engine do row locking? Is it >>> possible to get a status similar to SHOW ENGINE INNODB STATUS? Please >>> forgive me if this is painfully obvious or unclear (I'm still learning!), >>> and thank you for your time. >>> -Aaron >>> >>> -------------------------------- >>> >>> To view or answer this question please visit: >>> http://mariadb.com/kb/en/lockingdeadlocking-on-temp-tables/ >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~maria-discuss >>> Post to : [email protected] >>> Unsubscribe : https://launchpad.net/~maria-discuss >>> More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
