Skip to main content

Home/ MySQL/ Group items tagged dev

Rss Feed Group items tagged

mikhail-miguel

dev.mysql.com - 0 views

guocai chen

MySQL AB :: MySQL 5.1 Reference Manual :: 24.2.7.25 mysql_stmt_send_long_data() - 0 views

  • mysql_stmt_send_long_data()
  • Return Values Zero if the data is sent successfully to server. Non-zero if an error occurred.
guocai chen

MySQL AB :: MySQL 5.1 Reference Manual :: 24.2.7.4 mysql_stmt_bind_param() - 0 views

  • mysql_stmt_bind_param()
  • Return Values Zero if the bind operation was successful. Non-zero if an error occurred.
Ken Wei

MySQL AB :: Advanced MySQL Replication Techniques - 0 views

  • Fixing these two misfeatures is exactly the purpose of this article. Using features introduced in MySQL 5.0 and 5.1, it is possible to build a replication system where all nodes act as master and slave at the same time, with a built-in fail-over mechanism.
Ken Wei

MySQL AB :: Using the New MySQL Query Profiler - 1 views

  • When it comes to overall performance, it's important to remember that the #1 contributor is always a good database design. The second highest contributor to performance is well-tuned SQL code.
  • But a better day has come along in MySQL 5.0.37 with the inclusion of the SQL Profiling utility. This interactive diagnostic aid allows a developer or DBA to gain insight into where a set of SQL code spends its time and the resources it is using.
Ken Wei

MySQL AB :: MySQL 5.0 Reference Manual :: 17.2.6 DECLARE Statement Syntax - 0 views

  • Declarations must follow a certain order. Cursors must be declared before declaring handlers, and variables and conditions must be declared before declaring either cursors or handlers.
  • DECLARE is allowed only inside a BEGIN ... END compound statement and must be at its start, before any other statements.
Ken Wei

MySQL AB :: MySQL 5.0 Reference Manual :: 17.2.1 CREATE PROCEDURE and CREATE FUNCTION S... - 0 views

  • Each parameter is an IN parameter by default. To specify otherwise for a parameter, use the keyword OUT or INOUT before the parameter name.
  • Specifying a parameter as IN, OUT, or INOUT is valid only for a PROCEDURE. (FUNCTION parameters are always regarded as IN parameters.)
Ken Wei

application_partitioning_wp.pdf (application/pdf Object) - 0 views

  •  

1 - 20 of 34 Next ›
Showing 20 items per page