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

Displaying posts with tag: Technical (reset)

Load Delimited Data – CSV to MySQL, Excel to MySQL Database
+1 Vote Up -0Vote Down

Loading csv to MySQL or any delimited data files to MySQL database is a very common task frequently questioned about and almost every-time LOAD DATA INFILE come into rescue. In this article I will explain you about all different scenarios and explain you how to get the data loaded directly from csv to MySQL database […]

MySQL Memory Usage Limits on 32 bit Linux
+0 Vote Up -0Vote Down

I’m having RHEL 5 (32-bit) and MySQL-5. I was trying to check how much is the Memory Utilization limits for MySQL 5 on 32bit OS. We can easily calculate the maximum capacity of the address space is 2^32 bytes and that is where these limits come from. * For MYSQL 5.0: Following are memory (storage) […]

MySQL Certification Free Retake: Get TWO chances to get MySQL Certified
+1 Vote Up -0Vote Down

Recently MySQL has offered MySQL Certification Free Retake on both DBA or Developer Certifications for a limited time. For MySQL Certifications: 1. MySQL 5.0 Data Base Administrator Certification (SCMDBA) – MySQL 5.0 DBA Part I Certification (CX-310-810) – MySQL 5.0 DBA Part II Certification (CX-310-811) 2. MySQL 5.0 Developer Certification (SCMDEV) – MySQL 5.0 Developer […]

Monty: Help Saving MySQL – The Oracle & EC
+0 Vote Up -0Vote Down

And I looked back and thought of updating this post… We all are aware about the acquisition happened to MySQL; Sun and now Oracle. A common understanding tells me that a business will always seek profit; so will Oracle. And thats where worries and fear for existance of MySQL as an open-source and future growth […]

MySQL Stored procedure – Split Delimited string into Rows
+0 Vote Up -0Vote Down

This procedure will split  a “;” separated column in to new fields preserving ids. This is very specific problem, lets check it with example. Consider a sample table test: And we want output as follows: So again I wrote a procedure. Procedure will read a data from “tmp” table and will split data by my_delimiter […]

MySQL Stored procedure – Execute query if table or Column exists
+0 Vote Up -0Vote Down

Well procedures mainly carried out working with information schema and it’s usage in stored procedure. Procedures are fairly simple and easy to understand. 1. Edit_table – following procedure executes queries to particular table if it exists. Basically I created it to satisfy a need of altering a table if column exists. Now it can be used […]

Stored procedure to Find database objects
+0 Vote Up -0Vote Down

This procedure lists available database objects under passed database name. It lists present Tables, Views, Stored Procedures, Functions and Triggers under particular database. It also lists storage engine of tables. It uses information schema database to gather information and storing in a temporary table. [ad#ad-2-300×250] Usage: call xplore(database-name); – Procedure will search through information schema […]

MySQL master master replication monitor with php code
+0 Vote Up -0Vote Down

For monitoring replication we know a lot of tools and codes – but this one is different because I wrote it Well this is fairly simple php code for monitoring a master master replication setup. It requires a single shared login id available on both MySQL servers. It will display in tabular format following details: […]

Calculate Mysql Memory Usage – Quick Stored Proc
+0 Vote Up -0Vote Down

While going through mysql doc and MySQL Server Memory Usage, I noted following quick points regarding how mysql uses memory. We have global buffers which are allocated irrespective of connections as and when mysql server is started. Along with that mysql server allocates memory to each thread to perform respective tasks. So the formula goes: Mysql […]

Scheduled Backup MySQL Administrator & Windows Scheduler – Odd
+1 Vote Up -0Vote Down

Creating scheduled backup using administrator is an easy task. Follow the GUI and you’re done. But I observed something different! MySQL Version: 5.0.83 Community MySQL Administrator: 1.2.17 Machine: Intel P4, Windows XP, Enough RAM Logs: General, Error & irrelevant here though Slow query. Prologue: Administrator performs scheduled backup properly in normal scenario. What I was […]

10 Newer Entries Showing entries 31 to 40 of 66 10 Older Entries

Planet MySQL © 1995, 2014, 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.