Not quite sure what the question is.
from:
> mysql> select * from table where id='1';
> +---+-+-+---+
> | 1 | 123 | 0.0 | C |
> | 1 | 234 | 0.1 | D |
> | 1 | 345 | 0.0 | D |
> | 1 | 456 | 0.1 | C |
> | 1 | 567 | 0.1 | G |
> +---+-+-+---+
How do we d
Thanks to everybody, and to Rob Wultsch, his link helped me to understand
what I was doing...
./configure select an automake configure or a perl one...
I ended building mysql with innodb,heap,myisam and partitions, statically
built with:
./configure --with-plugins=heap,partition,innobase,myisam
On Sat, Jul 17, 2010 at 7:34 AM, Andrés Tello wrote:
> Who you build mysql 5.5.3 with innodb suport?
>
> I made
> sh configure.am --with-plugins=all
> I see the makefile at innodb subdir being created.
> I build the system correctly but when I log in to the mysql 5 instance and
> do a
>
> show eng
Use indexes before thinking about partitions.
-Original Message-
From: Andrés Tello [mailto:mr.crip...@gmail.com]
Sent: Thursday, July 15, 2010 8:44 AM
To: mysql
Subject: Mysql 4 and or Partitions.
Ok... I solved my mistery of the slow 22G table rebuild the kernel to
support memory an
Michael Dykman wrote:
> One problem you might be having is the column named 'call'.. It's a
> keyword, so perhaps you might get away with backticking it?ie.
> `call`
>
> Also, you shouldn't need that final semi-colon inside your statement
> string.. I have had preparedstatement interfaces gi
Grant Peel wrote:
> Hi all,
>
> I recently migrated a script called perldesk from mysql 4 to mysql 5.
>
> When I envoke the script from the web, I am now getting an error. I suspect
> its a version syntax thing.
>
> Here is what I see:
>
> Couldn't execute statement: You have an error in your
- Original Message -
From: "Grant Peel"
To: "Michael Dykman"
Cc:
Sent: Sunday, July 11, 2010 9:25 PM
Subject: Re: Mysql 4 to 5
- Original Message -
From: "Michael Dykman"
To: "Grant Peel"
Cc:
Sent: Sunday, July 11, 2010 9:20 PM
- Original Message -
From: "Michael Dykman"
To: "Grant Peel"
Cc:
Sent: Sunday, July 11, 2010 9:20 PM
Subject: Re: Mysql 4 to 5
One problem you might be having is the column named 'call'.. It's a
keyword, so perhaps you might get away with backt
One problem you might be having is the column named 'call'.. It's a
keyword, so perhaps you might get away with backticking it?ie.
`call`
Also, you shouldn't need that final semi-colon inside your statement
string.. I have had preparedstatement interfaces give me grief about
that.
As I reca
om:* Rob Wultsch [mailto:wult...@gmail.com]
> *Sent:* 02 July 2010 10:46 AM
>
> *To:* Machiel Richards
> *Cc:* mysql@lists.mysql.com
> *Subject:* Re: Mysql connections not released
>
>
>
> A bad assumption I make these days is that everyone has skip resolve off.
> If th
RDC_Logo
From: Rob Wultsch [mailto:wult...@gmail.com]
Sent: 02 July 2010 10:46 AM
To: Machiel Richards
Cc: mysql@lists.mysql.com
Subject: Re: Mysql connections not released
A bad assumption I make these days is that everyone has skip resolve off. If
that is the case DNS issues will not impac
hy and how to resolve this.
>
>
>
>
>
>
>
> Machiel Richards
>
> MySQL DBA
>
> Relational Database Consulting
>
>
>
> [image: RDC_Logo]
>
>
>
> *From:* Rob Wultsch [mailto:wult...@gmail.com]
> *Sent:* 02 July 2010 9:42 AM
> *To:* Mac
o: Machiel Richards
Cc: mysql@lists.mysql.com
Subject: Re: Mysql connections not released
On Thu, Jul 1, 2010 at 11:58 PM, Machiel Richards
wrote:
Good morning all
A few days ago i posted some questions relating to mysql
threads running out and not being able to restart th
On Thu, Jul 1, 2010 at 11:58 PM, Machiel Richards wrote:
> Good morning all
>
>
>
> A few days ago i posted some questions relating to mysql
> threads running out and not being able to restart the database.
>
>
>
> We had the same again this morning however this ti
2010/6/30 Tompkins Neil :
> Hi
>
> Just one other question. With regards the replication in MySQL 5.1 - does
> it it replication the whole row of data or just the field in which the data
> has been changed for the current record ?
MySQL 5.1 supports two replication formats: row and statement-base
Hi
Just one other question. With regards the replication in MySQL 5.1 - does
it it replication the whole row of data or just the field in which the data
has been changed for the current record ?
Thanks
Neil
2010/6/24 Jaime Crespo Rincón
> 2010/6/24 Tompkins Neil :
> > Hi
> >
> > Regarding tw
f the amount of
connections though.
Machiel Richards
MySQL DBA
Relational Database Consulting
-Original Message-
From: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com]
Sent: 30 June 2010 10:53 AM
To: mysql@lists.mysql.com
Cc: Machiel Richards
Subject: Re: Mysql error causing database t
Hi!
Machiel Richards wrote:
> [[...]]
>
> We received an error on a MySQL database this morning which
> caused it to be unavailable for connections.
>
> Error:
>
> ERROR 1135 (0): Can't create a new thread (errno 11); if
> you are not out of
@lists.mysql.com
Subject: Re: Mysql error causing database to not accept threads
Note that some of the memory settings are per connection, if you have
63 connections, you may have up to 63 copies of the buffers, and you
have pretty huge buffers even with 30GB of memory. Join buffers close to
1 G
Note that some of the memory settings are per connection, if you have
63 connections, you may have up to 63 copies of the buffers, and you
have pretty huge buffers even with 30GB of memory. Join buffers close to
1 G, tmp_table_size of 2 G, 63 connections could mean upto 63 copies of
these, and
2010/6/24 Tompkins Neil :
> Hi
>
> Regarding two-way replication what do you mean by "very
> controlled environment" ? What things do I need to consider ?
Control at application level that you are not going to
insert/update/delete the same record on the two servers.
Even if MySQL gives some suppo
You could have a look at the more recent 5.1 releases, those support
semi-synchronous replication iirc.
On Thu, Jun 24, 2010 at 10:50 AM, Tompkins Neil <
neil.tompk...@googlemail.com> wrote:
> Thanks for your quick response.
>
> Basically our need for replication is because our websites access a
Hi
Regarding two-way replication what do you mean by "very
controlled environment" ? What things do I need to consider ?
Cheers
Neil
2010/6/24 Jaime Crespo Rincón
> 2010/6/24 Tompkins Neil :
> > HI,
> >
> > We have set-up MySQL Community Server 5.1.46 with Master to Slave
> > replication and
Thanks for your quick response.
Basically our need for replication is because our websites access a local
MySQL database - which is fine. In our remote office, we also need to
access this MySQL database too however the connect time/ query speed is very
slow. At the moment the application in the
On 24/06/2010 09:18, Tompkins Neil wrote:
HI,
We have set-up MySQL Community Server 5.1.46 with Master to Slave
replication and everything appears to be working correctly, however I have a
couple of questions which I hope somebody can shed some light.
(1) When the network connection goes down b
2010/6/24 Tompkins Neil :
> HI,
>
> We have set-up MySQL Community Server 5.1.46 with Master to Slave
> replication and everything appears to be working correctly, however I have a
> couple of questions which I hope somebody can shed some light.
>
> (1) When the network connection goes down between
Dear Nilnandan,
Thanks for the quick reply.
But this particular variable is not working in only one proc call...but
rest all procedures creating temporary tables, does not affect my
replication slaves.
So I am not able to identify the problem.
Here's the snapshot of my procedure which is
On Wed, Jun 23, 2010 at 6:33 AM, Steven Staples wrote:
> Hi,
>
> I am looking at upgrading my servers Debian version from Etch to Lenny, and
> in doing that, I think it will upgrade MySQL from 5.0.32 to the lenny
> version, which is 5.0.53 (I think).
>
> I have also been thinking about using the
Hi Manasi,
Please try with this one.
Replicate_Wild_Ignore_Table = mydb\temp_.%
Regards,
Nilnandan Joshi
Manasi Save wrote:
Hi All,
I have kept
Replicate_Wild_Ignore_Table = mydb%.temp_%
this is temporary table which i want should not be replicated. But
still it is getting replicated an
you can stop your Mysql server (the program) and delete the file mysql.sock
and the try to start.
2010/6/21 Tyler Poland
> Charlene,
>
> You should check the mysql error log and if there isn't a message about the
> cause there you may want to check /var/log/syslog for mysql being killed by
>
Charlene wrote:
Anybody have any idea why MySQL would start to have this error message
every 4 or so days at midnight:
Do look at the logs, but if the error always occurs at midnight, you
might look for a disk backup or compression program that's scheduled
to run than and accesses the databas
Charlene,
You should check the mysql error log and if there isn't a message about
the cause there you may want to check /var/log/syslog for mysql being
killed by oomkiller.
Tyler
On 6/21/10 11:11 AM, Charlene wrote:
Anybody have any idea why MySQL would start to have this error message
ever
From: Vikram A [mailto:vikkiatb...@yahoo.in]
Sent: Wednesday, June 16, 2010 2:58 AM
To: je...@gii.co.jp; Andy; mysql@lists.mysql.com
Subject: Re: MySQL For Huge Collections
Hi All,
In this case how the images of a book will be stored, a chapter may contain
number of images with different
Subject: RE: MySQL For Huge Collections
>-Original Message-
>From: Andy [mailto:listan...@gmail.com]
>Sent: Friday, June 11, 2010 8:09 AM
>To: mysql@lists.mysql.com
>Subject: Re: MySQL For Huge Collections
>
>Hello all,
>
>Thanks much for your replies.
>
>OK,
ds,
Gavin Towey
-Original Message-
From: Peter Chacko [mailto:peterchack...@gmail.com]
Sent: Thursday, June 10, 2010 9:05 PM
To: SHAWN L.GREEN
Cc: Andy; mysql@lists.mysql.com
Subject: Re: MySQL For Huge Collections
Usually, you better use a NAS for such purpose. Database is designed
>-Original Message-
>From: Andy [mailto:listan...@gmail.com]
>Sent: Friday, June 11, 2010 8:09 AM
>To: mysql@lists.mysql.com
>Subject: Re: MySQL For Huge Collections
>
>Hello all,
>
>Thanks much for your replies.
>
>OK, so I realized that I may not have exp
Hello all,
Thanks much for your replies.
OK, so I realized that I may not have explained the problem clearly enough.
I will try to do it now.
I am a researcher in computational linguistics, and I am trying to research
language usage and writing styles across different genres of books over the
ye
Usually, you better use a NAS for such purpose. Database is designed
to store highly transactional, record oriented storage that needs fast
access... You can look for any Enterprise content management systems
that rest its storage on a scalable NAS, with file virtualization in
the long run.
thanks
On 6/10/2010 10:16 PM, Andy wrote:
Hello all,
I am new to MySQL and am exploring the possibility of using it for my work.
I have about ~300,000 e-books, each about 100 pages long. I am first going
to extract each chapter from each e-book and then basically store an e-book
as a collection of chap
See http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
Mike
At 12:37 PM 6/1/2010, durumdara wrote:
Hi!
I want to test my program that coded into PGSQL, and PySQLite. With these
DBs I have problem on many blob deletion (2 hours) and compact/vacuum (1
hours)...
So I'm trying to port my progr
Hello Lightingale,
Lightingale wrote:
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 t
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
In the last episode (May 15), James Corteciano said:
> Hi All,
>
> Anyone had tried to push all MySQL logs to the centralized syslog server?
> Can you share with me how did you do it?
>
> I have centralized syslog (rsyslog-3.22.1-3.el5) server who resides
> separately and a remote MySQL server (m
I think you've got it a little wrong. In MySQL, transaction log is different
from bin-log. Transaction logs are used only for Innodb while bin-logs are
optional and capture data related to all the storage engines. I believe, you
cannot read thru the transaction logs and these logs files (used in
It works great for me. After working out the bugs and adding the spatial
index I am now searching in the 0.05 second timeframe vs. minutes
otherwise.
Dan
On Sun, 2 May 2010 23:39:41 -0700, Rob Wultsch wrote:
>> >>> On Sat, May 1, 2010 at 11:12 PM, dan wrote:
>> >>>
>>
>>> >> >>> On Sat, May 1, 2010 at 11:12 PM, dan wrote:
>>> >> >>>
>>> >>
>>> >> Can any one help me with understanding the mysql spatial
>>> >> functions?
>>> >> I
>>> >> can
>>> >> only seem to find bits and pieces of how-to's etc.
>>> >>
>>> >> I have an exist
Ok... I am close I forgot an extra () in my POLYGON statement:
UPDATE `grid` SET lsd_poly = GeomFromText(CONCAT('POLYGON((',n,' ',e,',
',s,' ',e,', ',s,' ',w,', ',n,' ',w,', ',n,' ',e,'))'));
(I also created a new GEOMETRY lsd_poly column rather than the poly POLYGON
one).
Now I nee
poly is a polygon but I have not added a spatial index yet.
Here's where it gets weird. I tried adding dummy data:
mysql> SET @bbox = 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0))';
Query OK, 0 rows affected (0.01 sec)
mysql> update grid set poly = GeomFromText(@bbox);
Query OK, 7876282 rows
Tried it but no luck:
mysql> UPDATE `grid` SET poly = GeomFromText(CONCAT('POLYGON(',n,' ',e,',
',s,' ',e,', ',s,' ',w,', ',n,' ',w,', ',n,' ',e,')'));
Query OK, 0 rows affected (2 min 3.86 sec)
Rows matched: 7876282 Changed: 0 Warnings: 0
mysql> select poly from grid limit 10;
+--
I am still lost... I tried this:
UPDATE `grid` SET poly = PolygonFromText(CONCAT('POLYGON(',n,' ',e,', ',s,'
',e,', ',s,' ',w,', ',n,' ',w,', ',n,' ',e,')'));
I had my delimiters mixed up and I know my CONCAT worked:
mysql> select CONCAT('POLYGON(',n,' ',e,', ',s,' ',e,', ',s,' ',w,', ',
Dan,
I think you are trying to create a polygon based on the values in
other columns in the same row. I think these other columns are named
`n` and so on.
Your mistake is that you are creating a text string, "POLYGON(..)"
and embedding column names inside it. That won't work. Those column
I have seen that but I am stuck at just populating my POLYGON column
(poly). I have tried this:
UPDATE `grid` SET poly = PolygonFromText('POLYGON(`n` `e`, `s` `e`, `s`
`w`, `n` `w`, `n` `e`)');
but my poly column just reports back NULL.
the n, e, s & w columns are decimal lat / long da
Huh? That doesn't make a whole lot of sense. If that is the case, can you
explain why? Is the stored procedure mechanism that primitive?
From: Ted Yu [mailto:yuzhih...@gmail.com]
Sent: Saturday, May 01, 2010 7:11 AM
To: Ashley M. Kirchner
Subject: Re: [MySQL] Re: Variables in s
> -Original Message-
> From: Shawn Green [mailto:shawn.l.gr...@oracle.com]
> Sent: Friday, April 30, 2010 9:49 PM
> To: Ashley M. Kirchner
> Cc: mysql@lists.mysql.com
> Subject: [MySQL] Re: Variables in stored procedures
>
> Two options
>
> 1) use the placeholder, a question mark
Hi Baron,
I am too new to mysql internal jargon to understand "Handler:info()". Can
you tell me specific variables you want to get the real issue?
*Regarding OS:* It ubuntu disto. of linux.
dhee...@:~$ uname -a
Linux host0125 2.6.24-16-generic #1 SMP Thu Apr 10 12:47:45 UTC 2008 x86_64
GNU/Li
Hi,
You probably aren't doing anything wrong, per se, but I suspect
Handler::info() is slow and is being called once per partition. You
should probably start looking at your system overall to check where
the time is spent. Is it in reading from disk? If so, can you make
it read from memory inst
On Fri, Apr 23, 2010 at 10:03 AM, Karen Langford
wrote:
> Dear MySQL users,
>
> MySQL Community Server 5.1.46, a new version of the popular Open
> Source Database Management System, has been released. MySQL 5.1.46 is
> recommended for use on production systems.
>
> For an overview of what's new i
On Mon, Apr 19, 2010 at 12:16 PM, Rob Wultsch wrote:
> One way or another this
> should be a conscious decision, not a copy and paste from a mailing
> list.
>
As is the case with most settings :-)
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt,
On Mon, Apr 19, 2010 at 1:07 AM, Johan De Meersman wrote:
> On Mon, Apr 19, 2010 at 6:48 AM, Rob Wultsch wrote:
>>
>> And if your slave's IO lags badly enough this will hose you. Further
>
> True, but if you remove logs that haven't been transferred, yet, you lose
> your slave.
>
> Transfer of lo
On Mon, Apr 19, 2010 at 6:48 AM, Rob Wultsch wrote:
>
> And if your slave's IO lags badly enough this will hose you. Further
>
True, but if you remove logs that haven't been transferred, yet, you lose
your slave.
Transfer of logs shouldn't be lagging that much, really, unless you're
replicating
On Sun, Apr 18, 2010 at 9:40 PM, Prabhat Kumar wrote:
> You can add a expire_logs_days Variable in my.cnf during the configuration
> of replication server.
>
> # expire_logs_days = 7
>
> It will purged binary logs older than 7 days.The old logs will be purged
> during the next bin-log swittch.
>
You can add a *expire_logs_days* Variable in my.cnf during the
configuration of replication server.
#* expire_logs_days = 7*
It will purged binary logs older than 7 days.The old logs will be purged
during the next bin-log switch.
Or, You can also delete bin-log manually using command :
PURGE B
On Sun, Apr 18, 2010 at 8:58 PM, Angelina Paul wrote:
> How can I remove old mysql-bin log file in log directory? A mysql full
> backup will clear the old mysql bin log file or not?
>
> Thanks,
> Arshu Paul
>
You probably want
http://mysql2.mirrors-r-us.net/doc/refman/5.1/en/purge-master-logs.ht
Note : if you table name it will export all tables from given database;
eg:*
mysqldump -u user -ppassword wordpress --no-data > Dumpdata.txt *
It will export all tables from db wordpress.
On Mon, Apr 19, 2010 at 8:57 AM, Prabhat Kumar wrote:
> use can use mysqldump with option *-no-data*
> eg.
use can use mysqldump with option *-no-data*
eg.
*mysqldump -u user -ppassword wordpress user --no-data > Dumpdata.txt *
where wordpress is my database and user is my table.
Thanks
On Sun, Apr 18, 2010 at 9:48 PM, Shawn Green wrote:
> Vikram A wrote:
>
>> Hi,
>>
>> I would like to export my t
Vikram A wrote:
Hi,
I would like to export my table structure from MYSQL from a particular db. Is there any tool for doing this?
There are several ways to get "structure" information from within MySQL:
the SHOW COLUMNS... command
the SHOW INDEXES... command
the SHOW CREATE TABLE... command
Or MySQL Connector :)
On Apr 8, 2010 10:11 AM, "Carsten Pedersen" wrote:
The MySQL ODBC driver?
/ Carsten
On Thu, 8 Apr 2010 10:42:28 +0530 (IST), Vikram A
wrote:
> Hi,
>
> I would like to export my table structure from MYSQL from a particular
db.
> Is there any...
> !DSPAM:451,4bbd65f93304
2010 08:18
To: Vikram A
Cc: MY SQL Mailing list
Subject: Re: Mysql - Tables Export to Excel!
Hi Vikram,
You can use toad for mysql ( It's a free tool) to export table structure or
data.
Even you can use mysqldump also.
Krishna
On Thu, Apr 8, 2010 at 10:42 AM, Vikram A wrote:
> Hi,
>
Hi Vikram,
You can use toad for mysql ( It's a free tool) to export table structure or
data.
Even you can use mysqldump also.
Krishna
On Thu, Apr 8, 2010 at 10:42 AM, Vikram A wrote:
> Hi,
>
> I would like to export my table structure from MYSQL from a particular db.
> Is there any tool for d
The MySQL ODBC driver?
/ Carsten
On Thu, 8 Apr 2010 10:42:28 +0530 (IST), Vikram A
wrote:
> Hi,
>
> I would like to export my table structure from MYSQL from a particular
db.
> Is there any tool for doing this?
>
> Please guide me.
>
> Thank you
>
> VIKRAM A
>
>
>
>
Hello,
(First let me remember that my OS is Ubuntu 9.04)
I've found a solution today few minutes ago, so I'm posting here since I've
sound so many posts around the web and not a single solution seemed to solve
my problem.
Its actually pretty simple. My real problem was related to the my.cnf and
Also,
run "SHOW PROCESSLIST", to see what sql's are running on slave.
This will give u any idea if any huge dml was run on master and its getting
sync'd with slave.
regards
anandkl
On Fri, Mar 26, 2010 at 8:25 PM, Jim Lyons wrote:
> A few things to keep in mind:
>
> 1: the master may have seve
A few things to keep in mind:
1: the master may have several threads feeding into the binlog at a time,
but a slave only executes in a single thread. Are you throwing more stuff
at the slave in multiple mysql threads?
2: is there something else going on with the slave box? some big backup or
gz
ite on
> the back of a postcard (unless it was encrypted). :-)
>
My point exactly, if you have sensitive data, invest in the technology you
need to look after that data, don't rely on someone else to look after it
for you.
> Mike
>
>
>
>
> -Original Message-
ve used other databases with AES256 with
no noticeable reduction in speed.
In conclusion, I wouldn't store anything at an ISP that I wouldn't write on
the back of a postcard (unless it was encrypted). :-)
Mike
-Original Message-
From: mos
Sent: Sunday, March 21, 2010 3:
621621
===
-Original Message-
From: mos
Sent: Sunday, March 21, 2010 3:40 AM
To: mysql@lists.mysql.com
Subject: RE: MySQL Encryption
At 05:54 PM 3/20/2010, John Daisley wrote:
>Jim
>
>In the case of our encrypted data no user, application or script is given
>a
to a few people in
your company. Never trust the internet service provider to be your only
means to protect your data or your drives.
Mike
-Original Message-
From: Jim
Sent: Friday, March 19, 2010 4:22 PM
To: John Daisley ; mysql@lists.mysql.com
Subject: Re: MySQL Encryption
T
-Original Message-
From: Jim
Sent: Friday, March 19, 2010 4:22 PM
To: John Daisley ; mysql@lists.mysql.com
Subject: Re: MySQL Encryption
Thanks for the reply, John.
What you are describing seems to be the approach I've seen on the few
places I've seen this topic discusse
Hi Neil.
Information (in most cases a string < 100 chars, but that's probably not
important) that actually needs to be decrypted, so a hash won't do.
Jim
On 3/20/2010 5:09 PM, Tompkins Neil wrote:
Hi
What sort of information are you looking to encrypt ? If it is for user
passwords I'd reco
Thanks for all the responses and useful information.
Cheers
Neil
On Thu, Mar 18, 2010 at 6:35 PM, mos wrote:
> At 04:18 AM 3/18/2010, Tompkins Neil wrote:
>
>> Hi
>>
>> I'm currently looking to develop an on line web application - which is
>> going
>> to be used by around 200+ concurrent users
Hi
What sort of information are you looking to encrypt ? If it is for user
passwords I'd recommend SHA256 which is one way encryption. Or are you
looking to encrypt more sensitive information like card holder data ?
Regards
Neil
On Fri, Mar 19, 2010 at 4:22 PM, Jim wrote:
> Thanks for the re
Thanks for the reply, John.
What you are describing seems to be the approach I've seen on the few
places I've seen this topic discussed.
I've been considering something along those lines, essentially a two
part key.
Part one of the key is made from some data that is in the record I want
to
Jim,
I tend to derive a key based on a separate character string and the contents
of the data in the same or a related table. This means each row has a unique
encryption key and you never have to have the whole key stored somewhere
(you don't even know it :p ). Biggest advantage to this is should
At 04:18 AM 3/18/2010, Tompkins Neil wrote:
Hi
I'm currently looking to develop an on line web application - which is going
to be used by around 200+ concurrent users at any one time. Can
you recommend to me the best/preferred MySQL database engine to use for
example MyISAM ?
Also, in your exp
Thanks for the useful information. Can you let me know any other things I
need to consider ?
Regards
Neil
On Thu, Mar 18, 2010 at 9:50 AM, Krishna Chandra Prajapati <
prajapat...@gmail.com> wrote:
> Hi Neil,
>
> Many times we need to generate reports (weekly, montly, yearly) from the
> data we
Hi Neil,
Many times we need to generate reports (weekly, montly, yearly) from the
data we have. For detailed reports we have to use joins on many tables. So,
it takes time from 2 to 5. So these types of activities must be performed on
slave server.
If you need reports then you should have master
Hi
How do you mean "executed on slave" ?
Neil
On Thu, Mar 18, 2010 at 9:32 AM, Krishna Chandra Prajapati <
prajapat...@gmail.com> wrote:
> Hi Neil,
>
> Recommend : Innodb storage engine
>
> Even, i would suggest inner join select query (if report query might takes
> few seconds) should be execu
Hi Neil,
As Krishna said, Innodb is generally always superior to MyISAM unless
you need full-text search (and even if you do there are alternatives to
MyISAMs full-text search, which I've often found to be lacking in
performance).
A poorly optimised query will be slow whether it is called from a
Hi Neil,
Recommend : Innodb storage engine
Even, i would suggest inner join select query (if report query might takes
few seconds) should be executed on slave.
Before doing any thing. Plan out all the requirement.
Regards,
Krishna
On Thu, Mar 18, 2010 at 2:48 PM, Tompkins Neil wrote:
> Hi
>
What are your plans for OS as this can have an impact on hardware choice
especially if you are considering Solaris or Open Solaris.
Regards
John
On Tue, Mar 16, 2010 at 3:22 PM, Евгений Килимчук wrote:
>
> http://assets.en.oreilly.com/1/event/27/Linux%20Filesystem%20Performance%20for%20Databases
http://assets.en.oreilly.com/1/event/27/Linux%20Filesystem%20Performance%20for%20Databases%20Presentation.pdf
2010/3/10 John G. Heim
> Hi,
>
> I am working on configuring a new hardware database server. I'm a little
> confused as to what to do about disk. We have several mysql databases but by
>
On Fri, Mar 12, 2010 at 3:05 PM, Krishna Chandra Prajapati <
prajapat...@gmail.com> wrote:
> The below link shows the benchmark between different web servers ( apache,
> niginx, cherokee).
>
Irrelevant to this list, but I'll bite: there is no detail whatsoever on the
configuration of the various
Hi all,
The below link shows the benchmark between different web servers ( apache,
niginx, cherokee).
http://lists.octality.com/pipermail/cherokee/2009-May/010343.html
*http://nerdbynature.de/benchmarks/ab/2009-05-16/*
Conclusion of Above Benchmarks
*It seems that Cherokee continues being the f
On Thu, Mar 11, 2010 at 4:49 PM, Brent Clark wrote:
> On 11/03/2010 16:52, Krishna Chandra Prajapati wrote:
>
>> Hi Brent
>>
>> You can visit the below link.
>>
>>
>> http://www.mysqlperformanceblog.com/2009/06/09/mysql-proxy-urgh-performance-and-scalability/
>>
>
> Well thats disappointing.
>
> s
Hi Walter,
I have tried and tested haproxy (ver 1.3). But it doesn't work to my
expectation. May be newer version (1.4) works better.
Brent try and check
http://sqlrelay.sourceforge.net/sqlrelay/
http://www.cherokee-project.com/
http://www.alobbs.com/1344/MySQL_asynchronous_balancing_with_HTTP_
Take a look at haProxy. It can be combined with some scripts to
loadbalance mysql.
http://www.alexwilliams.ca/blog/2009/08/10/using-haproxy-for-mysql-failover-and-redundancy/
We use it at Open Query for a similar case.
Cheers,
Walter Heck
Engineer @ Open Query
http://openquery.com | http://openq
Has MySQL Proxy been improved since that article was released?
I ask because although I have no personal experience with it I do know of a
big UK based online payment processing company who use MySQL Proxy with
MySQL 5.1 in production very successfully.
On Thu, Mar 11, 2010 at 3:34 PM, Johan De
On Mar 11, 2010, at 9:49 AM, Brent Clark wrote:
> On 11/03/2010 16:52, Krishna Chandra Prajapati wrote:
>> Hi Brent
>>
>> You can visit the below link.
>>
>> http://www.mysqlperformanceblog.com/2009/06/09/mysql-proxy-urgh-performance-and-scalability/
>
> Well thats disappointing.
>
> sigh
> S
On 11/03/2010 16:52, Krishna Chandra Prajapati wrote:
Hi Brent
You can visit the below link.
http://www.mysqlperformanceblog.com/2009/06/09/mysql-proxy-urgh-performance-and-scalability/
Well thats disappointing.
sigh
So what are we supposed to use for loadbalancing mysql.
Thank you for your
Bah, just spilled coffee on my keyboard.
I never was a big fan of mysqlproxy, but this is almost inconceivable. The
next genius to suggest it for our environment had better have asbestos
underwear.
Thanks for the link, Krishna.
On Thu, Mar 11, 2010 at 3:52 PM, Krishna Chandra Prajapati <
prajap
701 - 800 of 9506 matches
Mail list logo