Mysql

1

STOP: DELETE IGNORE on Tables with Foreign Keys Can Break Replication

http://www.mysqlperformanceblog.com

DELETE IGNORE suppresses errors and downgrades them as warnings, if you are not aware how IGNORE behaves on tables with FOREIGN KEYs, you could be in for a surprise.
Let’s take a table with data as example, column c1 on table t2 references column c1 on table t1 – both columns have identical set of rows for simplicity.

Read more »
admin's picture
Created by admin 2 days 20 hours ago – Made popular 2 days 20 hours ago
Category: Databases   Tags:
1

Sending a header using the PHP SOAP client

http://feedproxy.google.com

I've recently been interfacing with a SOAP API on a .NET server and also creating an API in PHP, and both require sending a specific SOAP header for authentication. This post shows how to send a SOAP header using the PHP SOAP client which is built into PHP.
Sending an authentication header with PHP SOAP
In the case of the SOAP server I have been developing, the server requires a header to be sent which contains the API key. The header name is APIKey and the value the key itself. In the example below the namespace used for the API call is "ExampleNamespace".

Read more »
Created by shashi 3 days 8 hours ago – Made popular 3 days 8 hours ago
Category: Programming   Tags:
1

Verifying backup integrity with CHECK TABLES

http://www.mysqlperformanceblog.com

An attendee to Espen’s recent webinar asked how to check tables for corruption. This kind of ties into my recent post on InnoDB’s handling of corrupted pages, because the best way to check for corruption is with CHECK TABLES, but if a page is corrupt, InnoDB will crash the server to prevent access to the corrupt data.

Read more »
admin's picture
Created by admin 3 days 21 hours ago – Made popular 3 days 21 hours ago
Category: Databases   Tags:
1

PHP $_SERVER variables - CLI via SSH vs cron

http://feedproxy.google.com

I have a number of batch processes that run using PHP as the command interpreter, and discovered after making a change to one of them the other day that the variables available to PHP in the $_SERVER superglobal are different depending on whether it's run via an SSH session or cron. This post shows the difference on Debian 6. The values available are probably the same on other distros.
$_SERVER using the CLI via SSH
Using the PHP command line interpeter (CLI) the following was displayed when running print_r($_SERVER), showing which variables are available:

Read more »
Created by bands 5 days 10 hours ago – Made popular 5 days 10 hours ago
Category: Programming   Tags:
1

Speaking at MySQL Meetup in Raleigh,NC

http://www.mysqlperformanceblog.com

I’ll be presenting at MySQL Meetup in Raleigh,NC February 21,2012. The talk with be about Optimizing MySQL Configuration which I believe is a great topic for my first talk at this meetup group as it covers something every MySQL user has to deal with, also being something both beginner and advanced MySQL Users can learn a lot from.

Read more »
admin's picture
Created by admin 5 days 22 hours ago – Made popular 5 days 22 hours ago
Category: Databases   Tags:
1

"Error opening terminal xterm-color" on Mac OSX Terminal

http://feedproxy.google.com

If you are connecting to a remote server from the Mac OS X terminal and get the message "Error opening terminal: xterm-color" when doing certain operations on the remote server, then you either change your terminal's declaration setting or add a TERM declaration to the bash profile on the server at the other end to prevent the error message from happening. There may be other ways to solve it at the server end but this post shows a quick and easy fix.

Read more »
Created by admin user 1 week 2 days ago – Made popular 1 week 2 days ago
Category: Programming   Tags:
1

MySQL Configuration Wizard Updated

http://www.mysqlperformanceblog.com

We’ve released an updated version of the MySQL Configuration Wizard we announced at the end of last year. If you don’t remember that announcement, here’s the short version: this is a tool to help you generate my.cnf files based on your server’s hardware and other characteristics.
We’ve gotten really good feedback on this tool, including this nice mention on Stack Exchange:

Read more »
admin's picture
Created by admin 1 week 3 days ago – Made popular 1 week 3 days ago
Category: Databases   Tags:
1

How to recover a single InnoDB table from a Full Backup

http://www.mysqlperformanceblog.com

Sometimes we need to restore only some tables from a full backup maybe because your data loss affect a small number of your tables. In this particular scenario is faster to recover single tables than a full backup. This is easy with MyISAM but if your tables are InnoDB the process is a little bit different story.

Read more »
admin's picture
Created by admin 1 week 3 days ago – Made popular 1 week 3 days ago
Category: Databases   Tags:
1

Schedule for MySQL Conference 2012 is Published

http://www.mysqlperformanceblog.com

I am pleased to announce the schedule for Percona Live: MySQL Conference And Expo 2012 is now published. This is truly great selection of talks with something for MySQL Developers, DBAs, Managers, people just starting to use MySQL as well as looking for advanced topics. We have talks about running MySQL on extremely large scale in a Web as well as running MySQL In the Enterprise Environments.

Read more »
admin's picture
Created by admin 1 week 4 days ago – Made popular 1 week 4 days ago
Category: Databases   Tags:
1

linux.conf.au 2012 roundup

http://www.mysqlperformanceblog.com

I spent last week at linux.conf.au in Ballarat, Victoria (that’s the Victoria in Australia, not wherever else there may be one) which is only a pleasant two hour drive from my home town of Melbourne (Australia, not Florida). I sent an email internally to our experts detailing bits of the conference that may interest them – and I thought that it may also interest our wider readers who are interested in all levels of the software stack.

Read more »
admin's picture
Created by admin 1 week 4 days ago – Made popular 1 week 4 days ago
Category: Databases   Tags:

Your Ad Here

User login

Who's online

There are currently 0 users and 2 guests online.

Best karma users

  1. bands
  2. sri's picture
    sri
  3. shashi
  4. sunnyholic
  5. admin user