Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 61 to 70 of 934 10 Older Entries

Displaying posts with tag: sun (reset)

451 CAOS Links 2010.07.16
+0 Vote Up -0Vote Down

SugarCRM. Funding for EnterpriseDB and Morphlabs. Even more core. And more

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

Bittersweet
# OStatic asked whether SugarCRM has violated open source principles.

# Larry Augustin clarified SugarCRM’s approach to open source and openness.

# Savio …



  [Read more...]
Translation of "Chapter 7. Concurrent transactions. " of "Methods for searching errors in SQL application" just published.
Employee_Team +0 Vote Up -0Vote Down

This is short chapter which gives some clue what to do with concurrent transactions.



Chapter 7. Concurrent transactions.


Yet another frequent example of similar problem is "Lock wait timeout
exceeded" error while you use InnoDB tables. Most often running query
SHOW ENGINE INNODB STATUS is enough to find the problem, because it
will show last transactions. But output of this command does not
contain information about all queries in the same transaction, but only
about last one. What to do if SHOW ENGINE INNODB STATUS doesn't provide
all …










  [Read more...]
Translation of "Chapter 6. Locks and deadlocks." of "Methods for searching errors in SQL application" just published.
Employee_Team +1 Vote Up -2Vote Down

This is new part which contains information about what to do if problem is repeatable only when queries run concurrently.




Chapter 6. Locks and deadlocks.


In the last part we discussed how to find cause of the problem in case
if it is always repeatable. But there are cases when problem occurs
only under particular circumstances.



For example, such easy query can run long enough:





mysql> select * from t;

+-----+





















  [Read more...]
Translation of Summary of Part 1 of "Methods for searching errors in SQL application" just published
Employee_Team +1 Vote Up -0Vote Down

There is not much new content this week. Just summary of what was written before.




Summary.


In the summary of this part I'd want to recommend following:



Try to find a query which causes inconsistent behavior



Use log files:



  1. General query log
  2. Log files in your application
  3. MySQL Proxy or any other suitable proxy
  4. Others



Analyze what is …





















  [Read more...]
451 CAOS Links 2010.06.29
+0 Vote Up -0Vote Down

Elephants on parade: Hadoop goes mainstream. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

Elephants on parade
# Cloudera launched v3 of its Distribution for Hadoop and released v1 of Cloudera Enterprise.

# Karmasphere released new …



  [Read more...]
"Alternate methods for finding problem query.": chapter 5 of "Methods for searching errors in SQL application" just published
Employee_Team +1 Vote Up -0Vote Down

Translation of chapter 5 which describes alternate methods for searching problem query just published. It starts like:



Chapter 5. Alternate methods for finding problem query.


I already wrote about using of general query log requires resources.
Part of the problem can be solved if use new feature of MySQL 5.1:
online logging which allows to turn general query log to on or to off
without stopping the MySQL server.


Unfortunately this doesn't always work: you can have old
version of MySQL server which has not such a feature, general …











  [Read more...]
Translation of Chapter 4. Miscellaneous. of "Methods for searching errors in SQL application" just published
Employee_Team +0 Vote Up -0Vote Down

This chapter starts as:



Chapter 4. Miscellaneous.


There are cases when wrong output is just symptom of wrong input made before.



For example, you start to receive wrong data at particular step of the
scenario. After analysis of the SELECT query (or queries) is clear what
queries are correct and return exactly same data which exists in the
table (or tables).



This means wrong data was inserted at the earlier step.



How to know when it happened?


















  [Read more...]
MySQL University: Securich - Security Plugin for MySQL (rerun)
Employee +2 Vote Up -0Vote Down

This Thursday (June 10th, 14:00 UTC), Darren Cassar will rerun his February 25 presentation of Securich - Security Plugin for MySQL. (Recording of the session failed in February; hopefully it will succeed this time.) According to Darren, the author of the plugin, Securich is an incredibly handy and versatile tool for managing user privileges on MySQL through the use of roles. It basically makes granting and revoking rights a piece of cake, not to mention added security it provides …

  [Read more...]
MySQL University: Securich - Security Plugin for MySQL (rerun)
Employee +0 Vote Up -0Vote Down

This Thursday (June 10th, 14:00 UTC), Darren Cassar will rerun his February 25 presentation of Securich - Security Plugin for MySQL. (Recording of the session failed in February; hopefully it will succeed this time.) According to Darren, the author of the plugin, Securich is an incredibly handy and versatile tool for managing user privileges on MySQL through the use of roles. It basically makes granting and revoking rights a piece of cake, not to mention added security it provides …

  [Read more...]
MySQL University: Securich - Security Plugin for MySQL (rerun)
Employee +0 Vote Up -0Vote Down

This Thursday (June 10th, 14:00 UTC), Darren Cassar will rerun his February 25 presentation of Securich - Security Plugin for MySQL. (Recording of the session failed in February; hopefully it will succeed this time.) According to Darren, the author of the plugin, Securich is an incredibly handy and versatile tool for managing user privileges on MySQL through the use of roles. It basically makes granting and revoking rights a piece of cake, not to mention added security it provides …

  [Read more...]
10 Newer Entries Showing entries 61 to 70 of 934 10 Older Entries

Planet MySQL © 1995, 2015, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.