| 2009/7/28-8/6 [Computer/SW/Database] UID:53213 Activity:nil | 7/27 I have an actual technical question here. My MySQL DBA tells me
that I can't expect a MySQL port to be able to run effectively
on more than a two CPU box, he says that the extra CPUs will
sit there unused. Is this true? I have a bunch of new quad core
servers that I would like to use as Database machines. -ausman
\_ It's not that simple. If you stress test your new fancy multi core
...
|
| 2008/2/7-8 [Computer/SW/Database] UID:49086 Activity:nil | 2/7 What the hell? Is there configuration option to make mysql behave
reasonably? By "reasonably" I mean, when a user tries to put in
the wrong data type i'd like it to fail and throw an error, not just
say "hmmm, I'll just put a '0' there instead". -crebbs
mysql> desc hi;
+-------+------------+------+-----+---------+-------+
...
|
| 2007/10/29-11/1 [Computer/SW/Database] UID:48479 Activity:nil | 10/29 In mysql MyISAM table, if I do a very long read query (SELECT)
and then do an INSERT, will that INSERT hang? I understand that
MyISAM is non-transactional so I'm guessing the two calls are
independent of each other?
\_ From my understanding no. Not unless you explicitly lock the table.
What you get, however, is undefined. (I'm assuming these are on
...
|
| 2006/12/1-12 [Computer/SW/Languages/Misc, Computer/SW/Languages/Java] UID:45409 Activity:nil | 11/30 I remember people complaining about http://dreamhost.com on the motd in
recent months. What were the complaints?
\_ You can't run ANY script for over 20-30 seconds or else ALL of
your processes will get killed, rendering cron and cgi
useless. Mysql quota may be unlimited but is overloaded so
takes SECONDS for each simple query. It has been hacked into
...
|
| 2006/10/27-30 [Computer/SW/Database] UID:45007 Activity:nil | 10/27 Dear MySQL experts, I have a serious problem. I backed up my
database using mysqldump. When I try to recover using
"mysql < recover_file.sql" I keep getting "ERROR 2013 (HY000)
at line 116: Lost connection to MySQL server during query"
\_ So the dump file is just standard sql data. Why not take a look at
the line where it's running into problems and see if that yields
...
|
| 2013/10/24-2014/2/5 [Academia/Berkeley/CSUA/Motd, Computer/SW] UID:54746 Activity:nil | 9/26 I remember there was web version of the motd with search function
(originally due to kchang ?). The last time I used it it was hosted
on the csua website but I can't remember its url (onset of dementia?)
now. Can somebody plz post it, tnx.
\_ http://csua.com
\_ for some reason I couldn't log in since Sept and the archiver
...
|
|
http://csua.com/feed/