Re: STORE MYSQL DATA ON TWO HARDDISK

Hi chaim, If I move the db to drive2 and link to data directory. Then how the drive1 is used for storing mysql data. I want to use both the drive to store the mysql data. Thanks for quick response. On Tue, Oct 14, 2008 at 11:05 AM, [EMAIL PROTECTED] wrote: Move your logs to the second drive

Re: STORE MYSQL DATA ON TWO HARDDISK

Hi, use software RAID in stripping mode. Linux can do the job well. If it is not a solution for you, try to use symlinks for directory (it works) or tables (I'm not sure, if it does work). On Tue, Oct 14, 2008 at 11:03:30AM +0530, Krishna Chandra Prajapati wrote: Hi, I have two hard disk on

Extract strings from corrupted MySQL database

Hi, I'm trying to extract texts from MySQL database (phpbb). Please, could anybody explain which format is used to store texts? I mean binary structure. I know the sources are open, but I don't like to go throught the sources to find answer for such common question. And, you know, Google did not

Re: STORE MYSQL DATA ON TWO HARDDISK

Thanks a lot. On Tue, Oct 14, 2008 at 12:51 PM, Oto Buchta [EMAIL PROTECTED] wrote: Hi, use software RAID in stripping mode. Linux can do the job well. If it is not a solution for you, try to use symlinks for directory (it works) or tables (I'm not sure, if it does work). On Tue, Oct 14,

Re: super-smack on mysql 5.0 solaris 10 x86_64

Hope this link has some workaround. http://mysqldatabaseadministration.blogspot.com/2006/10/mysql-benchmarking-4-compiling-super.html Meanwhile i do check out. Thanks Regards Sudhir Menon

Insert static column into VIEW

Hey guys, I am trying to construct a specially crafted view for the powerdns DNS-Server. This is what I have so far: CREATE VIEW test4 AS SELECT nummer AS name, ip as content FROM jabix.spaces JOIN jabix.ves ON spaces.veid = ves.id; ++---+ | name | content |

super-smack on mysql 5.0 solaris 10 x86_64

all, does anyone has successful installing super-smack on solaris 10 x86_64 with mysql 5.0. I have installed, but when will doing stress testing, always complaining that client should be upgraded $ super-smack select-key.smack 30 1 super-smack: aborting because of a database error:

Re: Insert static column into VIEW

You can add a column to a view like this: CREATE VIEW test4 AS SELECT nummer AS name, ip as content, 1 as domain_id FROM jabix.spaces JOIN jabix.ves ON spaces.veid = ves.id; This will set the domain_id vaulues to 1 Olaf On 10/14/08 8:18 AM, Samuel Vogel [EMAIL PROTECTED] wrote: Hey guys,

Re: Insert static column into VIEW

Hey guys, I am trying to construct a specially crafted view for the powerdns DNS-Server. This is what I have so far: CREATE VIEW test4 AS SELECT nummer AS name, ip as content FROM jabix.spaces JOIN jabix.ves ON spaces.veid = ves.id; Wouldn't this work? CREATE VIEW test4 (name, content,

Re: Problem with GROUP BY

Philip mysql SELECT number, MAX(event), name FROM info GROUP BY number; For discussion examples see Within-group aggregates at http://www.artfulsoftware.com/queries.php. PB - philip wrote: I created a table with, CREATE TABLE info ( number INTEGER UNSIGNED, event INTEGER

Re: Problem with GROUP BY

http://jan.kneschke.de/projects/mysql/groupwise-max 2008/10/14 Peter Brawley [EMAIL PROTECTED] Philip mysql SELECT number, MAX(event), name FROM info GROUP BY number; For discussion examples see Within-group aggregates at http://www.artfulsoftware.com/queries.php. PB - philip

Problem with GROUP BY

I created a table with, CREATE TABLE info ( number INTEGER UNSIGNED, event INTEGER UNSIGNED, name VARCHAR(2000) NOT NULL, PRIMARY KEY (number, event) ); and populated it with data to produce this, ++---+---+ | number | event | name | ++---+---+ |

Re: super-smack on mysql 5.0 solaris 10 x86_64

Hi, Kindly ignore my first post, as that link was with respect to compiling super-smack on Solaris, which i found useful. As far as the problem is concerned can u check the below 1. Check if you have mysql4client package installed. 2. If then install mysql5client 3. Ensure that the binaries and

Calculating Full Table Scan Percentage/Ratio.

Hi All, I want to calculate Full Table Scan Percentage/Ratio, so i had searched and found the below formula for it. Will that give the correct value ... Any other way to calculate the same ? *1- (handler_read_rnd_next + handler_read_rnd) / (handler_read_rnd_next + handler_read_rnd +

Re: STORE MYSQL DATA ON TWO HARDDISK

Hi Peter, R you trying to say to move data from disk1 to disk2. regards anandkl On 10/14/08, Peter Farkas [EMAIL PROTECTED] wrote: Hi, You can mount second harddisk into /var/lib/mysql/db2 and after migrate data from first db to db2. It's not a great solution but it helps if you use only

Re: Insert static column into VIEW

This is exactly what I tried to avoid by using a view. I do not want to have to take care about synchronizing two tables. Is there any way to avoid this? Regards, Samy

Permissions

Hi all, I run a shared Apache, Perl, PHP, Mysql, on FreeBSD environment. Here is a question: IF I have a user, that has no permissions, but with a decent password, (in the mysql 'Users' table), AND that user only has access to his/her database through the local host (i.e. perl or PHP

Re: Permissions

On Tue, Oct 14, 2008 at 1:49 PM, Grant Peel [EMAIL PROTECTED] wrote: Hi all, I run a shared Apache, Perl, PHP, Mysql, on FreeBSD environment. Here is a question: IF I have a user, that has no permissions, but with a decent password, (in the mysql 'Users' table), AND that user only has

[ANN] Alpha release v05.06 of the BLOB Streaming Engine

Hi, Alpha version 5.06 of the BLOB streaming engine for MySQL has been released. The BLOB Streaming Engine is a MySQL storage engine which enables the storage and streaming of BLOB data directly in and out of a MySQL database. You can download the source code from

Re: STORE MYSQL DATA ON TWO HARDDISK

Hi, You can mount second harddisk into /var/lib/mysql/db2 and after migrate data from first db to db2. It's not a great solution but it helps if you use only few databases. On 10/14/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Thanks a lot. On Tue, Oct 14, 2008 at 12:51 PM, Oto

Re: Trouble with large data in MySql

can u please show us the output of show index from TABLE_NAME; On 10/14/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Hi Karthik, You have many columns in a single table (although you can). But, if you break the below table into two tables ( Vertical partitioning). It will help

Re: Insert static column into VIEW

Hi Samuel, I am not sure if you can add a new column to a view, but why dont u create a new table test4 as create table test4 AS SELECT nummer AS name, ip as content FROM jabix.spaces JOIN jabix.ves ON spaces.veid = ves.id; And then add the new column to test4. When ever any new data is added

Re: STORE MYSQL DATA ON TWO HARDDISK

cant we just create a symlink from /var/lib/mysql (first disk) to second hard disk, so that data will get spread across both disk. regards anandkl On 10/14/08, Peter Farkas [EMAIL PROTECTED] wrote: Hi Ananda, this is not too effective solution move some tables from first database into