RE: Converting Mysql to mysql cluster

2013-03-27 Thread Andrew Morgan
-Original Message- From: Kevin Peterson [mailto:qh.res...@gmail.com] Sent: 27 March 2013 06:58 To: mysql@lists.mysql.com Subject: Converting Mysql to mysql cluster Hi, My site is using mysql and PHP, now for the scale purpose want to introduce mysql-cluster. Few questions

Re: Show ROUTINE body, not PROCEDURE

2013-03-27 Thread hsv
2013/03/27 08:01 +0200, Dotan Cohen Actually, it is the user that I am logged in as that created the function. That is why I find it hard to believe that one needs root / admin access to see its definition. And that user set DEFINER other than itself, and that worked??? That takes SUPER. --

MOSSCon in Louisville in May! Submit your proposal this week!

2013-03-27 Thread John List
You are invited to be a speaker/presenter at MOSSCon. Preparations are in full swing for the very first Midwest Open Source Software Conference (MOSSCon), to be held in Louisville on May 18-19. Your help in spreading the word and helping us fill out our schedule of presentations and workshops

*.index files in MySQL Data directory

2013-03-27 Thread Arnold, Sandra L.
What are the *.index files in the MySQL Data directory? I notice a new one is created every time that MySQL is stopped and restarted. My Data directory is not in the default location so does that have anything to do with it? Thanks, Sandra Arnold Data Warehouse Administrator MartinFederal

Re: *.index files in MySQL Data directory

2013-03-27 Thread Reindl Harald
Am 27.03.2013 19:53, schrieb Arnold: What are the *.index files in the MySQL Data directory? I notice a new one is created every time that MySQL is stopped and restarted. My Data directory is not in the default location so does that have anything to do with it? maybe a ls -lha of a

RE: *.index files in MySQL Data directory

2013-03-27 Thread Arnold, Sandra L.
There are files beginning with 1.sequence number. The sequence number is 01 to 15. A new file is created every time MySQL is restarted. The 1.index file contains a list of these files. One thing that I have done is when I was hardening the security we stopped MySQL and moved the

Re: *.index files in MySQL Data directory

2013-03-27 Thread Reindl Harald
sound like files of a replication slave or master and that is why you should post details and folder-listings in the first posting to hep understand waht you are speaking about [root@srv-rhsoft:~]$ ls /data/db/mysql-srv/ | grep bin -rw-rw 1 mysql mysql 12M 2013-03-22 19:44 bin.01