meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year |
| seen | May 15 at 15:49 | |
| stats | profile views | 29 |
|
Mar 7 |
answered | Does this query make sense? |
|
Mar 3 |
comment |
MySQL design problem "Nonsense, I say. Disregard that advice." I second that. I would be be very suspect of any advice that comes from whatever source offered you that little nugget of absurdity. Much better advice is to completely disallow direct access to tables, using stored procedures as the only interface to them. |
|
Feb 20 |
comment |
Database Design Cars-Models / Car Classifieds If this is what you were looking for, perhaps you might accept it as the answer. Otherwise I'd be more than happy to expound on it if more is needed. |
|
Feb 19 |
answered | Database Design Cars-Models / Car Classifieds |
|
Feb 5 |
comment |
MySQL Tables crashing randomly Corruption can cause mysqld to crash, which can cause further corruption, so yes. It is theoretically possible for a bug in the data storage code that results in certain queries causing a crash, per the MySQL troubleshooting docs. |
|
Feb 4 |
comment |
MySQL Tables crashing randomly It's hard to say from the info given. Crashes can cause corruption, and corruption can cause crashes. All we have is evidence of one crash. It is not likely that it is a bug, but it is possible. If you follow the steps above to try to isolate a query that is causing a crash, and you can replicate that crash reliably, it's almost certainly a bug and should be submitted. |
|
Feb 4 |
comment |
MySQL Tables crashing randomly It may be that I am being overly cautious, but in the event that you somehow have an actual bug in your version of mysqld, I would try to bypass it in verifying that your tables are starting up uncorrupted by cutting it out. Since mysqlcheck is basically just an interface to mysqld, invoking mysqlcheck would also potentially be invoking the bug. It's not very likely, but it is a possibility. |
|
Feb 4 |
comment |
MySQL Tables crashing randomly A single instance can have multiple threads, which is what I assume htop is showing you. If top shows only one mysqld running, you have only one instance running. |
|
Feb 2 |
comment |
MySQL Tables crashing randomly By multiple instances I mean more than one mysqld process running concurrently. The biggest difference between mysqlcheck and myisamchk is that mysqlcheck is a client application that sends requests through the MySQL server, so it requires mysqld to be running in order to function. myisamchk is a utility that operates directly on the files--it's best if mysqld is NOT running. If you use myisamchk, you can verify integrity before starting mysqld--I thought that might eliminate one more variable in the troubleshooting process. |
|
Feb 1 |
answered | MySQL Tables crashing randomly |
|
Feb 1 |
awarded | Informed |
|
Jan 31 |
awarded | Enthusiast |
|
Jan 28 |
answered | Disabling “SHOW TABLES;” on mysql |
|
Jan 25 |
comment |
sql error 1241 operand should contain 1 column Extra +1 for the suggestion to normalize the table. |
|
Jan 17 |
comment |
Split date range into indiviual records And there's the join I couldn't conjure. Nice. |
|
Jan 16 |
answered | Split date range into indiviual records |
|
Jan 3 |
comment |
MySQL SELECT query: i want show duplicated entries There's only one row returned because there is only one row in the table categories where code_CAT has the value 14. Repeating that same id_code value in the IN doesn't change that. I don't follow why, if there is only one such row in the table, you want it repeated four times. Could you elaborate? |
|
Dec 18 |
comment |
Wordpress SQL database error: option tree already exists I agree with Mat. The error is self-explanatory. Given that, I don't think this is really a question for DBAs. It might be more appropriate--and get quicker/better answers--in Stack Overflow, as a general question on migrating blogging software. |
|
Dec 18 |
awarded | Citizen Patrol |
|
Dec 14 |
awarded | Analytical |
