Thanks Gavin and Joerg, that was very helpful!
-- Jonas
On Sun, Oct 3, 2010 at 12:44 PM, Joerg Bruehe joerg.bru...@oracle.comwrote:
Hi Neil, all!
Tompkins Neil wrote:
So if you have individual indexes for example field_1, field_2 and
field_3
etc and then perform a search like
WHERE
Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Monday, October 04, 2010 8:54 AM
To: Joerg Bruehe
Cc: [MySQL]
Subject: Re: Indexing question
Jörg
Thanks for the useful reply. Maybe I can EXPLAIN my select queries for
you
to advise if any changes need to be made
Hi!
Neil Tompkins wrote:
Thanks for your reply. So should we create individual indexes on each
field or a multiple column index ??
This question cannot be answered without checking and measuring your
installation. The decision whether to create an index is always an act
of balancing
individual indexes on each
field or a multiple column index ??
This question cannot be answered without checking and measuring your
installation. The decision whether to create an index is always an act
of balancing:
- If there is an index, the database server can use it to find data
records
: Re: Indexing question
Jörg
Thanks for the useful reply. Maybe I can EXPLAIN my select queries for you
to advise if any changes need to be made ?
Regards
Neil
On Mon, Oct 4, 2010 at 3:38 PM, Joerg Bruehe joerg.bru...@oracle.comwrote:
Hi!
Neil Tompkins wrote:
Thanks for your reply. So
Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Monday, October 04, 2010 8:54 AM
To: Joerg Bruehe
Cc: [MySQL]
Subject: Re: Indexing question
Jörg
Thanks for the useful reply. Maybe I can EXPLAIN my select queries
for you
to advise if any changes need to be made
11:48 AM
To: mysql@lists.mysql.com
Subject: Indexing question
Suppose I wanted to be able to perform queries against three columns of my
table: 'user_id', 'product_id' and 'created'. Most of the time I'll just be
range-selecting records from the table ordering by 'created'. But I may
also
Hi Neil, all!
Tompkins Neil wrote:
So if you have individual indexes for example field_1, field_2 and field_3
etc and then perform a search like
WHERE field_1 = 10
AND field_3 = 'abc'
This wouldn't improve the search ? You have to create a index for all
possible combined field
Thanks for your reply. So should we create individual indexes on each
field or a multiple column index ??
On 3 Oct 2010, at 16:44, Joerg Bruehe joerg.bru...@oracle.com wrote:
Hi Neil, all!
Tompkins Neil wrote:
So if you have individual indexes for example field_1, field_2 and
field_3
Following on from my previous email I have columns containing numbers
which are then used in SUM and MIN/ MAX functions should these be
indexed too ?
On 3 Oct 2010, at 16:44, Joerg Bruehe joerg.bru...@oracle.com wrote:
Hi Neil, all!
Tompkins Neil wrote:
So if you have individual indexes
Suppose I wanted to be able to perform queries against three columns of my
table: 'user_id', 'product_id' and 'created'. Most of the time I'll just be
range-selecting records from the table ordering by 'created'. But I may also
want to select where 'user_id' = something and 'product_id' in (list,
@lists.mysql.com
Subject: Indexing question
Suppose I wanted to be able to perform queries against three columns of my
table: 'user_id', 'product_id' and 'created'. Most of the time I'll just be
range-selecting records from the table ordering by 'created'. But I may also
want to select where 'user_id' = something
Hi,
I'm finding the description of character_set_connection unclear. Does
this influence the encoding of queries, but not of results? I'm
wondering about the effect of connection encoding.
Is there documentation on how exactly character set settings affect
BLOBs? For example, this is what
Thanks all... I got this to work! Much appreciated..
And thanks for patience with a newbie!
--
Patrice Olivier-Wilson
http://biz-comm.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
, but then I couldn't expand
later.
Reverse is true if I add user_ID to the Topics.
So, need an idea how to solve this so it doesn't matter how many new
users I keep adding, I can still see who is using the topics.
As I said, a newbie question. Thanks much.
--
Patrice Olivier-Wilson
http://biz
, 2010 12:09 PM
To: mysql@lists.mysql.com
Subject: newbie question database tables
I'm working on a database that needs to do a few things and getting
brain freeze on one part.
Scenario:
I want to compile a db of articles with these tables:
Categories
Topics
Users
Categories
cat_ID | cat_name
On 9/10/10 12:31 PM, Jerry Schwartz wrote:
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
E-mail: je...@gii.co.jp
Web site: www.the-infoshop.com
Thank you!
--
Patrice Olivier-Wilson
http://biz-comm.com
--
On 03/09/2010 9:27 p, Hank wrote:
On 02/09/2010 8:30 p, Hank wrote:
Simple question about views:
Hank,
Have you tried running away from the problem :-) by doing...
CREATE PROCEDURE `combo`(theid INT)
BEGIN
(SELECT * FROM table1 WHERE id = theid)
UNION
(SELECT * FROM
On 03/09/2010 9:26 p, Hank wrote:
On Fri, Sep 3, 2010 at 6:23 AM, Jangitajang...@jangita.com wrote:
On 02/09/2010 8:30 p, Hank wrote:
Simple question about views:
Hank,
Have you tried running away from the problem :-) by doing...
CREATE PROCEDURE `combo`(theid INT)
BEGIN
(SELECT
On 02/09/2010 8:30 p, Hank wrote:
Simple question about views:
I have a view such as:
create view combo as
select * from table1
union
select * from table2;
Where table1 and table2 are very large and identical and have a
non-unique key on field id
On 9/3/2010 6:23 AM, Jangita wrote:
On 02/09/2010 8:30 p, Hank wrote:
Simple question about views:
I have a view such as:
create view combo as
select * from table1
union
select * from table2;
...
(I've also tried UNION ALL with the same results
On 02/09/2010 8:30 p, Hank wrote:
Simple question about views:
Hank,
Have you tried running away from the problem :-) by doing...
CREATE PROCEDURE `combo`(theid INT)
BEGIN
(SELECT * FROM table1 WHERE id = theid)
UNION
(SELECT * FROM table2 WHERE id = theid
Simple question about views:
I have a view such as:
create view combo as
select * from table1
union
select * from table2;
Where table1 and table2 are very large and identical and have a
non-unique key on field id..
when I do a:
select * from combo where id
Hi,
I'm creating a application which hosts football matches and I want to record
the player appearances, goals etc. I was thinking of having a record for
each player as follows :
appearance_id
season_id
player_id
team_id
competition_id
appearance
goals
yellow_card
red_card
date_played
Is this
Hi!
I am no InnoDB and tuning expert, so I had intended to stay away from
this question. Ok, I'll give some general remarks:
Nunzio Daveri schrieb:
[[...]]
All, I was running slamdb against one of our QA boxes and noticed that the
innodb database is 190Gb in size BUT the worrying issue
this
question I posted yesterday please?)
Hi!
I am no InnoDB and tuning expert, so I had intended to stay away from
this question. Ok, I'll give some general remarks:
Nunzio Daveri schrieb:
[[...]]
All, I was running slamdb against one of our QA boxes and noticed that the
innodb database
) and the table
structure?
Mike
At 01:31 PM 7/30/2010, you wrote:
Hi!
I am no InnoDB and tuning expert, so I had intended to stay away from
this question. Ok, I'll give some general remarks:
Nunzio Daveri schrieb:
[[...]]
All, I was running slamdb against one of our QA boxes and noticed
Hi everyone and thanks in advance for the help. I have a query that I'd like to
perform using two tables but am not sure what the best way to perform it short
of creating a loop in my code and performing multiple queries.
I have two tables. The first table acts as a master table of sorts and
You'll need to use the technique described here:
http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html
-Original Message-
From: Michael Stroh [mailto:st...@astroh.org]
Sent: Monday, July 26, 2010 2:50 PM
To: MySql
Subject: Yet another query question
Hi everyone
Aren't you grouping on IDt?
something like ? :
select t2.IDt,t2.ID,t2.Num,max(t2.version) from table1 as t1, tabl2 as t2
where t1.num=t2.num and t1.state!='new' group by t2.IDt
Cheers,
Geert-Jan
2010/7/26 Michael Stroh st...@astroh.org
Hi everyone and thanks in advance for the help. I have a
Yes, sorry, you are correct. I am actually grouping on that other column. I'll
take a look at this and see if it works for me. Thanks!
Michael
On Jul 26, 2010, at 6:10 PM, Geert-Jan Brits wrote:
Aren't you grouping on IDt?
something like ? :
select t2.IDt,t2.ID,t2.Num,max(t2.version)
I'm having trouble formulating a query to gather the following data. I can
do this via a script, but now it is more or less just bothering me if there
is an easy/efficient way to gather the following data from a single query.
Example Tables
Products
Type Cost Vendor_id
Scott,
I would like to obtain the least cost of each product type and its
associated vendor.
See Within-group aggregates at
http://www.artfulsoftware.com/infotree/queries.php.
PB
-
On 7/14/2010 9:25 AM, Scott Mullen wrote:
I'm having trouble formulating a query to gather the
On Wednesday, July 14, 2010 09:25:22 am Scott Mullen wrote:
I'm having trouble formulating a query to gather the following data. I can
do this via a script, but now it is more or less just bothering me if there
is an easy/efficient way to gather the following data from a single query.
Date: Wed, 14 Jul 2010 10:25:22 -0400
Subject: Select w/ group by question
From: smulle...@gmail.com
To: mysql@lists.mysql.com
I'm having trouble formulating a query to gather the following data. I can
do this via a script, but now it is more or less just bothering me
Peter
Thanks for the link. I've never run across this page before, but it has
tons of useful informationas well as several answers on how to implement
what I was trying to do.
Ended up going with a solution similar to this example (from the page you
referenced):
SELECT
item,
SUBSTR(
Hi,Is there a way to update the same table on a delete trigger ?I need to call an UPDATE statement when a delete occurs.Best regards
--Kevin Labecot,Innovanticwww.innovantic.frTél. : 05.56.45.60.54
As far as I know, you can´t change data on the same table in triggers.
Kevin Labecot ke...@labecot.fr escreveu na mensagem
news:4d2ce38b-d169-478b-aebf-c19f20dce...@labecot.fr...
Hi,
Is there a way to update the same table on a delete trigger ?
I need to call an UPDATE statement when a
On Fri, Jun 18, 2010 at 16:30, Dave deal...@gmail.com wrote:
SELECT * FROM contacts WHERE state = 'CA' and name = 'bob' or
name = 'sam' or name = 'sara'
We begin by asking on the right list (mysql@lists.mysql.com, CC'd
by courtesy).
You're on the right track though. Try a
Hi,
I'd like to know if MySQL server supports http queries?
Thanks.
Kandy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MySQL is a tradition Relational DataBase System. It underlays
something like 80% (somebody correct me if I'm out-of-date here) of
the http applications populating the internet. While some RDBMSs
offer extensions for RESP-like HTTP implementations, MySQL does not
support this directly. It can be
Hi,
I am new to using mysql. I want to prepare an application for my employer.
The
application will be accessed by staff from as many as 10 different
departments
such as sales, marketing, admin, finance etc. The users will be using DML
commands
on the tables. My question has two parts:
Part
on the tables. My question has two parts:
First problem: you are letting your users run direct commands against
the database.
One of the biggest roles in an application is to isolate and protect the
data from stupid user mistakes. Not only should your application
filter, validate, and sanitize
Hi there,
I am new to using mysql. I want to prepare an application for my employer. The
application will be accessed by staff from as many as 10 different departments
such as sales, marketing, admin, finance etc. The users will be using DML
commands on the tables. My question has two parts
Hello, I'm currently writing a python program that scans some web directories
and then stores some information in a local database. I'm playing with using
InnoDB for this application as a test bed for using InnoDB in further
applications, but I'm running into a couple issues.
When I try to
MyISAM does not support transactions so it is inherently in
'autocommit mode' all the time. You will run into this with any
transactional database, be it InnoDB, Falcon, or Oracle and DB2
installations for that matter.
For many classes of application, avoiding autocommit and explicitly
creating
Thanks for the clarification.
Michael
On May 17, 2010, at 2:28 PM, Michael Dykman wrote:
MyISAM does not support transactions so it is inherently in
'autocommit mode' all the time. You will run into this with any
transactional database, be it InnoDB, Falcon, or Oracle and DB2
missing?
Bob
On May 12, 2010, at 8:00 PM, Keith Clark wrote:
Hi Bob,
No, actually it does not. I'm looking for the count of items. From
your query example I only get two rows. This table has over 2 1/2 years
of daily sales data.
Maybe I'm not stating my question correctly...h
: Keith Clark [mailto:keithcl...@k-wbookworm.com]
Sent: 13 May 2010 14:11
To: mysql@lists.mysql.com
Subject: Re: Count Query question
Bob,
Here are a few rows of my data:
17462, 0, '0929998596', '/GraphicNovels/0929998596.jpg', '8.5000',
'2010-05-12 19:02:47', '2008-10-01 00:00:00', '2008-10-01 00:00
I'm trying to produce a report that will tell me how many products were
available with a Quantity0 before a certain date, and have that ordered
by date.
Table:
Date
Quantity
Result desired
DateQuantity Available
May 1 5000
May 2 5050
May 3 5075
Thanks,
Keith
--
MySQL General
With out the table definitions, I'm not sure how anyone could help. Can
you send the output of show create table for each of the tables
involved in this query?
Chris W
Keith Clark wrote:
I'm trying to produce a report that will tell me how many products were
available with a Quantity0
Chris,
Here is my full table definition:
CREATE TABLE `products` (
`products_id` int(15) NOT NULL AUTO_INCREMENT,
`products_quantity` int(4) NOT NULL,
`products_model` varchar(15) NOT NULL DEFAULT '',
`products_image` varchar(64) DEFAULT NULL,
`products_price` decimal(15,4) DEFAULT NULL,
by products_date_available,
counts all records before products_date_available with a
products_quantity0.
I don't think I'm asking this question properly.
For every date in products_date_available in the table, I'd like to know
the count of items available with products_quantity0 up until
products_date_available with a
products_quantity0.
I don't think I'm asking this question properly.
For every date in products_date_available in the table, I'd like to know
the count of items available with products_quantity0 up until that
date.
So if there are 500 days in the table, there should be 500
Hi Bob,
No, actually it does not. I'm looking for the count of items. From
your query example I only get two rows. This table has over 2 1/2 years
of daily sales data.
Maybe I'm not stating my question correctly...h
Thanks for responding though, greatly appreciated.
Keith
On Wed
data.
Maybe I'm not stating my question correctly...h
Thanks for responding though, greatly appreciated.
Keith
On Wed, 2010-05-12 at 19:46 -0500, Bob Cole wrote:
Keith:
Does this work?
SELECT products_date_available, COUNT(products_quantity)
FROM products
WHERE
Hi guys, i have a server with 20GB InnoDb on a single database and i
use just one user for its. I use mysql 5.4
1- If i change my SCSI 15k RPM to a SSD i will increase my performance ?
2- What is the fast method to a backup to this InnoDB database ? And
the more easy ? And how i restore its ?
On Sun, May 2, 2010 at 11:50 PM, Junior Ortis jror...@gmail.com wrote:
Hi guys, i have a server with 20GB InnoDb on a single database and i
use just one user for its. I use mysql 5.4
1- If i change my SCSI 15k RPM to a SSD i will increase my performance ?
Umm, maybe. More information is
Hey you all,
I'm messing about with various settings and parsing the documentation, and
my naughty mind saw something that's not very clear in the docs:
The InnoDB autoincrement
dochttp://dev.mysql.com/doc/refman/5.1/en/innodb-auto-increment-handling.htmlstates
that innodb_autoinc_lock_mode
= 2
Good Afternoon All
following the documentation available at
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html
i wish to select a date using DD-MON-YY format but my format of '%y-%b-%d'
appears to be incorrect
mysql select DATE_FORMAT('11-10-09','%y-%b-%d') from DUAL;
Basicay, your date_format works like:
select DATE_FORMAT('YY-MM-DD','%y-%b-%d') from DUAL;
Martin Gainty mgai...@hotmail.com escreveu na mensagem
news:blu142-w2137936b18ae273dbd6cb1ae...@phx.gbl...
Good Afternoon All
following the documentation available at
To: mysql@lists.mysql.com
From: j...@consultorweb.cnt.br
Subject: Re: DATE_FORMAT parameter question
Date: Fri, 9 Apr 2010 12:56:46 -0300
Basicay, your date_format works like:
select DATE_FORMAT('YY-MM-DD','%y-%b-%d') from DUAL;
Martin Gainty mgai...@hotmail.com escreveu na mensagem
If you'll excuse the shameless plug: I once created a tool to help find
the exact parameters to use for PHPs date() and MySQLs DATE_FORMAT().
Please see
http://bitbybit.dk/php/date_format/
(Yes, it looks horrible. But it works)
/ Carsten
Martin Gainty skrev:
Good Afternoon All
following
question
If you'll excuse the shameless plug: I once created a tool to help find
the exact parameters to use for PHPs date() and MySQLs DATE_FORMAT().
Please see
http://bitbybit.dk/php/date_format/
(Yes, it looks horrible. But it works)
/ Carsten
Martin Gainty skrev:
Good Afternoon
Hi there,
I currently store some information about a users daily habits in a table.
The table has 4 fields per day, and another 4 fields as the keys. This
table, depending on the month, can be from (4 keys + (28 days * 4 fields per
day)) fields, to (4 keys + (31 days * 4 fields per day)) fields
: Table Length Question...
Hi there,
I currently store some information about a users daily habits in a table.
The table has 4 fields per day, and another 4 fields as the keys. This
table, depending on the month, can be from (4 keys + (28 days * 4 fields per
day)) fields, to (4 keys + (31 days * 4
Your first table layout is horrible, the second one is only marginally
better. You should read up on database normalization.
I have no idea what id, id2 and type are but since they seem like they
are the same for every 'f' and every day, I am pretty sure they all
relate directly to the user
only once for all the rows deleted.
regards
anandkl
On Thu, Mar 18, 2010 at 1:21 AM, Price, Randall randall.pr...@vt.edu
wrote:
Hello,
I have a simple question about deleting records from INNODB tables. I
have
a master table with a few child tables linked via Foreign Key
constraints
] On Behalf Of Johan De
Meersman
Sent: Thursday, March 18, 2010 6:48 AM
To: Ananda Kumar
Cc: Price, Randall; [MySQL]
Subject: Re: Question about DELETE
Given that OP is talking about a single delete statement, I'm gonna be very
surprised if he manages to squeeze an intermediate commit
is happening multiple times?
Thanks,
-Randall Price
From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
Meersman
Sent: Thursday, March 18, 2010 6:48 AM
To: Ananda Kumar
Cc: Price, Randall; [MySQL]
Subject: Re: Question about DELETE
Given that OP is talking about
: Thursday, March 18, 2010 10:11 AM
To: Price, Randall
Cc: Johan De Meersman; Ananda Kumar; [MySQL]
Subject: RE: Question about DELETE
Hi Randall,
If you're talking about processes that are taking that long, then
running SHOW PROCESSLIST several times during the operation should give
you a rough idea
-Original Message-
From: Ian Simpson [mailto:i...@it.myjobgroup.co.uk]
Sent: Thursday, March 18, 2010 10:11 AM
To: Price, Randall
Cc: Johan De Meersman; Ananda Kumar; [MySQL]
Subject: RE: Question about DELETE
Hi Randall,
If you're talking about processes that are taking that long
: Thursday, March 18, 2010 11:15 AM
To: Price, Randall
Cc: Ian Simpson; Johan De Meersman; [MySQL]
Subject: Re: Question about DELETE
delete will also cause the undo(before image) to be generated, in case u want
to rollback. This will also add up to the delete completion time.
After each mass delete
Hello,
I have a simple question about deleting records from INNODB tables. I have a
master table with a few child tables linked via Foreign Key constraints. Each
table has several indexes as well.
My question is: if I delete many records in a single delete statement (i.e.,
DELETE FROM
AM, Price, Randall randall.pr...@vt.eduwrote:
Hello,
I have a simple question about deleting records from INNODB tables. I have
a master table with a few child tables linked via Foreign Key constraints.
Each table has several indexes as well.
My question is: if I delete many records
Hi there,
I have a WEIRD question, that I can't find an answer too...
Here is my stored function:
DELIMITER $$
USE `mydatabase`$$
DROP FUNCTION IF EXISTS `SPLIT_STR`$$
CREATE definer=`thisus...@`%` FUNCTION `SPLIT_STR`(
X VARCHAR(255),
delim VARCHAR(12),
pos INT
) RETURNS VARCHAR(255
I have three tables that work together.
s_product is a list of farm products with an autoincrementing ID.
s_product_market_prices is a list of market pricings, obtained from
various sources. Each one is dated and refers to exactly one s_product
record via its ID.
s_product_harvest is a
For the given table:
FIELD TYPE COLLATION NULL
KEY DEFAULT Extra PRIVILEGES COMMENT
-
-- -- --- --
Hi,
I am sure there is a simple solution to this problem, I just cant find it :)
I have got a table that records views for an article for each blog per day.
So the structure is as follows:
CREATE TABLE `wp_views` (
`blog_id` int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`date` date NOT NULL,
Hi Ian,
Why do you think something's wrong? Here is my test data and the results
of your query:
---
mysql SELECT * FROM wp_views;
+-+-++---+
| blog_id | post_id | date | views |
+-+-++---+
| 1 | 1 | 2009-12-16 |
Hi,
Thanks, I just checked and it was a memcache that was caching the output.
See I knew it was a simple solution ;)
Thanks for the effort everyone and sorry for wasting time.
Regards
Ian
2009/12/17 Aleksandar Bradaric leann...@gmail.com
Hi Ian,
Why do you think something's wrong? Here is
Is mysql the owner of the directories?
- Original Message
From: Manasi Save manasi.s...@artificialmachines.com
To: Johan De Meersman vegiv...@tuxera.be
Cc: Waynn Lue waynn...@gmail.com; mysql mysql@lists.mysql.com
Sent: Wed, November 25, 2009 8:12:25 PM
Subject: Re: question regarding
Hi Johan,
It worked perfectly. Thank you so much for this explanation.
I am really greatful.
--
Best Regards,
Manasi Save
Artificial Machines Pvt Ltd.
On Wed, Nov 25, 2009 at 3:42 PM, Manasi Save
manasi.s...@artificialmachines.com wrote:
Dear Johan,
Need your help again in
...@tuxera.be
Cc: Waynn Lue waynn...@gmail.com; mysql mysql@lists.mysql.com
Sent: Wed, November 25, 2009 8:12:25 PM
Subject: Re: question regarding mysql database location
Dear Johan,
Need your help again in understanding How mysql reads symlink.
As you said below, I have created symlinks
I fixed this by using symlinks for the directories for the underlying
databases. The limit for files is significantly higher than
directories.
Waynn
On 11/24/09, Manasi Save manasi.s...@artificialmachines.com wrote:
Hi All,
I have asked this question before But, I think I am not able
this question before But, I think I am not able to describe
it better.
Sorry for asking it again.
I have multiple databases but there is a limit on the folders getting
created in one folder.
I have mysql default directory set as /var/lib/mysql/data.
Now, After 32000 folder creation I am not able
On Wed, Nov 25, 2009 at 12:53 AM, Manasi Save
manasi.s...@artificialmachines.com wrote:
Thanks Waynn,
I could not get your point of using symlinks. Because as per my knowledge
symlink will store same data which is there in original directory.
and What do you mean by The limit for files is
Well Waynn,
In this case I need to move all the existing databases to new location
right. Which I don't want to do. Is it possible that I create sym link
between two and use both.
--
Thanks and Regards,
Manasi Save
Artificial Machines Pvt Ltd.
On Wed, Nov 25, 2009 at 12:53 AM, Manasi Save
You don't need to move any databases. Look at this structure:
/data/disk1/mysql/db1 (directory)
/db2 (directory)
/db3 (directory)
/db4 (symlink to /data/disk2/mysql/db4)
/db5 (symlink to /data/disk2/mysql/db5)
Hi Johan,
I am Sorry. If I have complicated the senerio But, this still not fix my
purpose.
What I want is - From your example :-
/data/disk1/mysql/db1 (directory)
/db2 (directory)
/db3 (directory)
/db4 (symlink to /data/disk2/mysql/db4)
manasi.s...@artificialmachines.com wrote:
Hi All,
I have asked this question before But, I think I am not able to describe
it better.
Sorry for asking it again.
I have multiple databases but there is a limit on the folders getting
created in one folder.
I have mysql default directory set
On Wed, Nov 25, 2009 at 11:55 AM, Manasi Save
manasi.s...@artificialmachines.com wrote:
Hi Johan,
I am Sorry. If I have complicated the senerio But, this still not fix my
purpose.
What I want is - From your example :-
/data/disk1/mysql/db1 (directory)
/db2 (directory)
On Wed, Nov 25, 2009 at 12:05 PM, Krishna Chandra Prajapati
prajapat...@gmail.com wrote:
At a time mysql can point to one data directory. For your task you can have
n number of mysql installation with different data directory. After that
you
can use federated storage engine to perform your
rows with one query. The question is, which way is
better if these requests may be executed a large number of times?
I think 1 query is better than 2 but if the table_1 holds a lot of
data - resending the whole thing every time (example 2) just to get the
one integer value seems like a waste
Thanks Johan,
It was really a great help. I'll try to implement it. I dont want to opt
for multiple mysql instances option as thats not feasible.
I'll get back to you all if it works fine.
Thanks again.
--
Best Regards,
Manasi Save
Artificial Machines Pvt Ltd.
On Wed, Nov 25, 2009 at 11:55
Dear Johan,
Need your help again in understanding How mysql reads symlink.
As you said below, I have created symlinks in default mysql directory.
and try to read that symlink file as a database. But mysql is not reading
that file as Database. Is there any settings which I need to change.
Thanks
On Wed, Nov 25, 2009 at 3:42 PM, Manasi Save
manasi.s...@artificialmachines.com wrote:
Dear Johan,
Need your help again in understanding How mysql reads symlink.
As you said below, I have created symlinks in default mysql directory.
and try to read that symlink file as a database. But
Hi All,
I have asked this question before But, I think I am not able to describe
it better.
Sorry for asking it again.
I have multiple databases but there is a limit on the folders getting
created in one folder.
I have mysql default directory set as /var/lib/mysql/data.
Now, After 32000 folder
:2048M:autoextend:max:1024M;/var/lib/mysql/data1/ibdata1:2048M:autoextend:max:1024M;
Is there any wayout for this?
Thanks and Regards,
Manasi Save
Artificial Machines Pvt Ltd.
Hi All,
I have asked this question before But, I think I am not able to describe
it better.
Sorry for asking it again.
I have
Mikesz,
The best way to approach this is to discover how it has been
implemented by others. There is no point re-inventing the wheel. I'm sure
you can get some ideas from this web site:
http://www.databaseanswers.org/data_models/. and the tutorial at
301 - 400 of 6660 matches
Mail list logo
