Re: Where to ask a question about installation and configuration

2015-06-23 Thread Claudio Nanni
Hello Steve, To what list should I post with a post-installation config and startup > question? > > This list, the MySQL General Mailing List, is the right place if the question is about MySQL! Cheers -- Claudio

Where to ask a question about installation and configuration

2015-06-23 Thread Steve Matzura
To what list should I post with a post-installation config and startup question? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Database migration from default configuration to innodb_file_per_table

2014-03-26 Thread Christophe
Hi, Data migration made last night. Use of a new MySQL instance has been quite useful to operate, the outage was about 7 minutes. ibdata1 is now using 58 MiB of disk space ! each table having a proper .ibd file and full data directory from 13GiB to 3.2GiB ... Server load divided by 3 ~ 4 ;). I

Re: Database migration from default configuration to innodb_file_per_table

2014-03-23 Thread Christophe
Hi Shawn, and thanks for this concise anwser ;) . Le 22/03/2014 05:35, shawn l.green a écrit : > > The system is operating exactly as designed. The ibdata* file(s) contain > more than just your data and indexes. This is the common tablespace and > it contains all the metadata necessary to identify

Re: Database migration from default configuration to innodb_file_per_table

2014-03-21 Thread shawn l.green
tabases to recreate them ... ) the ibdata file , which is taking over 9GiB on filesystem. We have to separate data from databases in two cases , whilst it is running , after setting innodb_file_per_table in MySQL configuration , and restarting service. Creating First database, containing at oldest 6

Database migration from default configuration to innodb_file_per_table

2014-03-21 Thread Christophe
over 9GiB on filesystem. We have to separate data from databases in two cases , whilst it is running , after setting innodb_file_per_table in MySQL configuration , and restarting service. Creating First database, containing at oldest 6 months of data. Second database, considered "archive&q

Re: SSH tunnels and non root accounts get "the server service or the configuration file could not be found"

2013-05-29 Thread Claudio Nanni
Hi Miguel, I'm confused. Where should I issue those commands? Yes from the MySQL Administrator. From what you say it seems that you end up being authenticated as the ''@'localhost' user. Connect again with the MySQL Administrator and the non-root account and issue: mysql> SHOW GRANTS;

Re: SSH tunnels and non root accounts get "the server service or the configuration file could not be found"

2013-05-29 Thread Miguel Gonzalez
"the server service or the configuration file could not be found" Miguel, Probably your non-root user is connecting as the anonymous account. Try this: Connect as your (problematic) non-root account and do this: mysql> SELECT USER(); mysql> SELECT CURRENT_USER(); What do y

Re: SSH tunnels and non root accounts get "the server service or the configuration file could not be found"

2013-05-29 Thread Claudio Nanni
delete the anonymous user from mysql.user table. Best Regards Claudio 2013/5/29 Miguel Gonzalez > In my email I state quite clearly that tunnel is working with the root > account so it's not a matter of ports. > > The error message shows that is trying to get some configura

Re: SSH tunnels and non root accounts get "the server service or the configuration file could not be found"

2013-05-29 Thread Miguel Gonzalez
In my email I state quite clearly that tunnel is working with the root account so it's not a matter of ports. The error message shows that is trying to get some configuration from the user account that is not working. Under root account I have found a file called .my.cnf with a [client]

Re: SSH tunnels and non root accounts get "the server service or the configuration file could not be found"

2013-05-28 Thread Tim Pownall
> works fine with the root account. > >With a non-root account I get > > the server service or the configuration file could not be found. I can > log on but I can't see the databases that I should be allowed to see. > >Running a mysql -h 127.0.0.1 -u myuser -p myp

Re: SSH tunnels and non root accounts get "the server service or the configuration file could not be found"

2013-05-28 Thread Michael Dykman
rks fine with the root account. > >With a non-root account I get > > the server service or the configuration file could not be found. I can > log on but I can't see the databases that I should be allowed to see. > >Running a mysql -h 127.0.0.1 -u myuser -p myp

SSH tunnels and non root accounts get "the server service or the configuration file could not be found"

2013-05-28 Thread Miguel González
the server service or the configuration file could not be found. I can log on but I can't see the databases that I should be allowed to see. Running a mysql -h 127.0.0.1 -u myuser -p mypassword from linux works fine I have created a .my.cnf file in the home folder with 600 permis

Re: Why configuration directives are all case sensitive?

2012-11-26 Thread Johan De Meersman
- Original Message - > From: "Eric Bergen" > > Anger and OS religious arguments the real answer is that is just how > the option parsing code works. It doesn't always have to make sense. Ye gods, it's an outbreak of common sense! Someone quarantine that man before it spreads! In all se

Re: Why configuration directives are all case sensitive?

2012-11-24 Thread Tianyin Xu
Hi, Eric, Thanks a lot for the GREAT explanation! This perfectly answers my question. We can close the threads now :-) Best, T On Sat, Nov 24, 2012 at 8:53 AM, Eric Bergen wrote: > Yes, the missing piece of the puzzle is that configuration files are > turned into command line arg

Re: Why configuration directives are all case sensitive?

2012-11-24 Thread Eric Bergen
Yes, the missing piece of the puzzle is that configuration files are turned into command line arguments internally. Programs will parse configuration files and place them at the beginning of the array for command line arguments. They are made case sensitive because they are turned into command

Re: Why configuration directives are all case sensitive?

2012-11-23 Thread Tianyin Xu
Dear Eric, Thanks a lot for the explanation of argument directives! The concerns are very considerate. Actually, what I'm curious about is the configuration directives in the configuration file, i.e., my.cnf. To my experience, MySQL is the very few software who treats these directives in a

Re: Why configuration directives are all case sensitive?

2012-11-23 Thread Eric Bergen
19.11.2012 02:07, schrieb Tianyin Xu: >> > You are saying as long as admins are careful, there's no >> misconfiguration? >> > But why misconfigurations are so pervasive? >> > Simply because the admins are not careful enough? >> >> yes >> &

Re: Why configuration directives are all case sensitive?

2012-11-18 Thread Karen Abgarian
like > my work but with crappy quality and terrible insecure > > see all this CMS sytems out there writing hundrets of > warnings each request with error_reporting E_STRICT > while my whole source code runs clean i know who is right > > really: > if you find it useful to co

Re: Why configuration directives are all case sensitive?

2012-11-18 Thread Tianyin Xu
ins are not careful enough? > > yes > > That means not only I'm dummy, and that's means you should take care the system configuration design if many people are careless. > > I apologize for my lack of respect. I don't know what's your stuff, but > > I guess

Re: Why configuration directives are all case sensitive?

2012-11-18 Thread Reindl Harald
: if you find it useful to complain why a configuration is case-sensitive instead accept it and correct your fault you are doing the wrong job signature.asc Description: OpenPGP digital signature

Re: Why configuration directives are all case sensitive?

2012-11-18 Thread Tianyin Xu
Hi, On Sun, Nov 18, 2012 at 4:35 PM, Reindl Harald wrote: > > > Am 19.11.2012 01:27, schrieb Tianyin Xu: > > I'm not saying the file names but the configuration directives. > > At least for most servers I have managed so far, > > all the configuration directive

Re: Why configuration directives are all case sensitive?

2012-11-18 Thread Reindl Harald
Am 19.11.2012 01:27, schrieb Tianyin Xu: > I'm not saying the file names but the configuration directives. > At least for most servers I have managed so far, > all the configuration directives are case insensitive. Examples? PostgreSQL, > Apache httpd, OpenLDAP, Squid, etc.

Re: Why configuration directives are all case sensitive?

2012-11-18 Thread Tianyin Xu
Hi, Reindl, On Sun, Nov 18, 2012 at 3:11 PM, Reindl Harald wrote: > > > Am 18.11.2012 23:59, schrieb Tianyin Xu: > > Hi, > > > > I'm just curious why MySQL parses its configuration directives (i.e., the > > ones in my.cnf) in a case sensitive way? > &g

Re: Why configuration directives are all case sensitive?

2012-11-18 Thread Reindl Harald
Am 18.11.2012 23:59, schrieb Tianyin Xu: > Hi, > > I'm just curious why MySQL parses its configuration directives (i.e., the > ones in my.cnf) in a case sensitive way? > > For example, Having "Port=3309", will receive "unknown variable 'Port=3309&qu

Why configuration directives are all case sensitive?

2012-11-18 Thread Tianyin Xu
Hi, I'm just curious why MySQL parses its configuration directives (i.e., the ones in my.cnf) in a case sensitive way? For example, Having "Port=3309", will receive "unknown variable 'Port=3309". I guess there must be some concern for this. Could anyone

Re: can anyone tell me the best my.cnf Configuration for dedicated MySQL DB server

2012-02-19 Thread Reindl Harald
Am 20.02.2012 06:57, schrieb Nayan Darekar: > hi members, > > I want install, configure my 8GB Ram 4 core CPU hardware server for > dedicated MySQL DB Server with stable version of MySQL. So which version i > should use and can anyone help me for best my.cnf Configuration. the

Re: Automate Install/Configuration of MySQL on Linux

2010-07-29 Thread Todd E Thomas
sit on top of MySQL. For the purposes of consistency I'd like to automate these installs. I've been able to automate the install and configuration of everything except the mysql part. I'm using CentOS 5.5. Installing/verifying is no big deal. It's the MySQL c

Re: Automate Install/Configuration of MySQL on Linux

2010-07-27 Thread Rob Wultsch
On Tue, Jul 27, 2010 at 1:56 PM, Todd E Thomas wrote: > I'm looking for automation direction... > > I've found many packages that sit on top of MySQL. For the purposes of > consistency I'd like to automate these installs. > > I've been able to automate the i

Automate Install/Configuration of MySQL on Linux

2010-07-27 Thread Todd E Thomas
I'm looking for automation direction... I've found many packages that sit on top of MySQL. For the purposes of consistency I'd like to automate these installs. I've been able to automate the install and configuration of everything except the mysql part. I'm usi

Re: Best Configuration on Production Server

2010-03-22 Thread Abdul Mohid Khan
g in both production server and test environment. But the Problem is in test environment one operation is taking 5ms ... but in production(better h/w configuration) 50 ms The Operation which i am talking about is consist of one select, 2 insertion (MyISM) and one updat

Re: Best Configuration on Production Server

2010-03-21 Thread Abdul Mohid Khan
Hi Gavin, Same setup i am using in both production server and test environment. But the Problem is in test environment one operation is taking 5ms ... but in production(better h/w configuration) 50 ms The Operation which i am talking about is consist of one select, 2 insertion (MyISM

RE: Best Configuration on Production Server

2010-03-19 Thread Gavin Towey
What changed between your test that took 5ms and the current production system? -Original Message- From: Abdul Mohid Khan [mailto:abdulmohid.k...@magnaquest.com] Sent: Friday, March 19, 2010 12:27 AM To: mysql@lists.mysql.com Cc: Abdul Mohid Khan Subject: Best Configuration on Production

Best Configuration on Production Server

2010-03-19 Thread Abdul Mohid Khan
but in production same request is taking 50 ms. The Production sever configuration No of CPU : 8 RAM : 8 GB OS : Cent OS Here i am giving the show variable out put on the system. Please help to do the best configuration for my mysql server on production. We are using both MyISM and InnoDB

Looking for real configuration data

2009-09-02 Thread Wei Zheng
configuration process. The idea is to leverage the configurations of existing users of a piece of software to ease the configuration process for each new user of the software. The reason for this message is that we would like to collect a large number of deployed configurations to help evaluate our

Re: Master-master replication configuration...how?

2009-03-29 Thread blue . trapezius
Hi Craig and others, On Fri, Mar 27, 2009 at 4:16 PM, Craig Dunn wrote: > blue.trapez...@gmail.com wrote: > >> Hi >> >> I have 2 servers and I am trying to set up (for testing purposes) a >> master-master replication environment. I read the instructions in the >> manual >> for master-slave, but

Re: Master-master replication configuration...how?

2009-03-27 Thread Craig Dunn
blue.trapez...@gmail.com wrote: Hi I have 2 servers and I am trying to set up (for testing purposes) a master-master replication environment. I read the instructions in the manual for master-slave, but am not able to find any information on how to set up a master-master system. Can someone on th

Master-master replication configuration...how?

2009-03-27 Thread blue . trapezius
Hi I have 2 servers and I am trying to set up (for testing purposes) a master-master replication environment. I read the instructions in the manual for master-slave, but am not able to find any information on how to set up a master-master system. Can someone on this list point me to any documentat

Re: Is it a bug or my mistake in server configuration?

2008-11-16 Thread Alexey Vlasov
On Mon, Nov 10, 2008 at 08:23:24PM +0300, Alexey Vlasov wrote: > DBI connect('database,...) > failed: Can't create a new thread (errno 12); if you are not out of > available memory, you can consult the manual for a possible OS-dependent > bug at ... I just thought, all this can be a result of du

Re: Is it a bug or my mistake in server configuration?

2008-11-10 Thread Alexey Vlasov
On Mon, Nov 10, 2008 at 06:36:34PM +0100, Uwe Kiewel wrote: > Alexey Vlasov schrieb: >> open files (-n) 1024 > > just a shot to the blue: > > can you count your open files with lsof? # lsof -u mysql | wc -l 1719 I doubt that the problem is in that otherwise every second use

Re: [Fwd: Re: Is it a bug or my mistake in server configuration?]

2008-11-10 Thread Uwe Kiewel
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John Daisley schrieb: > Hit 'Reply to All' instead of reply. > Is is okay for you the have your answers twice? If I post to a list, I read that list. So there is no need to have the ansers at the list and in my inbox Uwe -BEGIN PGP SIGNATURE

Re: [Fwd: Re: Is it a bug or my mistake in server configuration?]

2008-11-10 Thread John Daisley
have released the thread back to the server. On Mon, 2008-11-10 at 18:39 +0100, Uwe Kiewel wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > This mailing list has a stupid configuration. Pressing the answer > button, the message goes to the sender

Re: [Fwd: Re: Is it a bug or my mistake in server configuration?]

2008-11-10 Thread Uwe Kiewel
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Andy Shellam schrieb: > >> This mailing list has a stupid configuration. Pressing the answer >> button, the message goes to the sender not to the list :-( >> > > Hint - use Reply to All - it's not specific to this

Re: [Fwd: Re: Is it a bug or my mistake in server configuration?]

2008-11-10 Thread John Daisley
Hit 'Reply to All' instead of reply. On Mon, 2008-11-10 at 18:39 +0100, Uwe Kiewel wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > This mailing list has a stupid configuration. Pressing the answer > button, the message goes to t

Re: [Fwd: Re: Is it a bug or my mistake in server configuration?]

2008-11-10 Thread Andy Shellam
This mailing list has a stupid configuration. Pressing the answer button, the message goes to the sender not to the list :-( Hint - use Reply to All - it's not specific to this mailing list. :-) Regards, Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/

Re: Is it a bug or my mistake in server configuration?

2008-11-10 Thread Uwe Kiewel
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Curtis Maurand schrieb: > > I've been having the same trouble in a Xen virtual machine. After about > an hour and a half, mysql will be consuming 100% of cpu. There is > nothing wrong with the tables. I'm assuming its a dynamic vs. fix > amount of

[Fwd: Re: Is it a bug or my mistake in server configuration?]

2008-11-10 Thread Uwe Kiewel
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 This mailing list has a stupid configuration. Pressing the answer button, the message goes to the sender not to the list :-( - Original-Nachricht Betreff: Re: Is it a bug or my mistake in server configuration? Datum: Mon, 10 Nov

Re: Is it a bug or my mistake in server configuration?

2008-11-10 Thread Curtis Maurand
I've been having the same trouble in a Xen virtual machine. After about an hour and a half, mysql will be consuming 100% of cpu. There is nothing wrong with the tables. I'm assuming its a dynamic vs. fix amount of memory available to mysql. I'm guaranteed x amount of ram, but that might g

Is it a bug or my mistake in server configuration?

2008-11-10 Thread Alexey Vlasov
Hi. One client from my shared hosting periodically informs me about an error: DBI connect('database,...) failed: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug at ... There's nothing suspicious in the MySQL

Re: Configuration and improvement advice.

2008-07-18 Thread Simon J Mudd
[EMAIL PROTECTED] (Josh Miller) writes: > I have recently become responsible for a LAMP site which has a decent > MySQL install (v5.0.24a). The database is around 40GB with a single > master to single slave replication scheme, although all activity goes > to the master at this time, with the exce

Configuration and improvement advice.

2008-07-18 Thread Josh Miller
I have recently become responsible for a LAMP site which has a decent MySQL install (v5.0.24a). The database is around 40GB with a single master to single slave replication scheme, although all activity goes to the master at this time, with the exception of backups which are taken from the sla

Re: mysql logfile configuration

2008-04-18 Thread Ananda Kumar
just comment this parameter, all actions done by mysql will be in hostnam.err file On 4/18/08, Uwe Kiewel <[EMAIL PROTECTED]> wrote: > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi @all, > > ich have configured in /etc/my.cf as follow: > > [...] > log="/var/log/mysqld.log" > [...] > >

mysql logfile configuration

2008-04-18 Thread Uwe Kiewel
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi @all, ich have configured in /etc/my.cf as follow: [...] log="/var/log/mysqld.log" [...] Now, mysqld writes every query to the log file. How can I avoid the queries in the log file? I want to see any action done by mysql, but not the queries. T

Re: suggestion for disk configuration

2008-01-24 Thread B. Keith Murphy
, from small to quite big (tables with about 2M rows). I've got a SAS disk array and I was wondering what the best configuration could be: 1) raid 10 2) raid 5 3) a combination (e.g., raid10 for the data and raid 5 for the logs). Any suggestion or link? Thanks, Luca -- B. Keith M

suggestion for disk configuration

2008-01-24 Thread Luca Ferrari
Hi, I have to install a mysql server for managing several database, from small to quite big (tables with about 2M rows). I've got a SAS disk array and I was wondering what the best configuration could be: 1) raid 10 2) raid 5 3) a combination (e.g., raid10 for the data and raid 5 for the

Re: MySQL Configuration for a powerful server?

2007-10-03 Thread Jan Kirchhoff
Ratheesh K J schrieb: Hello all, What is the best possible values in my.cnf for a 8 processor (Quad core-2 cpu) 8 GB RAM machine dedicated for MySQL server only. No other application will run on this machine. the innodb_buffer_pool_size cannot accept values above 2000 MB due to 32 bit machin

MySQL Configuration for a powerful server?

2007-10-03 Thread Ratheesh K J
Hello all, What is the best possible values in my.cnf for a 8 processor (Quad core-2 cpu) 8 GB RAM machine dedicated for MySQL server only. No other application will run on this machine. the innodb_buffer_pool_size cannot accept values above 2000 MB due to 32 bit machine constraint. So what ot

Re: MYSQL CONFIGURATION FILE

2007-09-21 Thread Ananda Kumar
Hi Krishna, Have you set this parameter innodb_data_file_path= On 9/21/07, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > > Hi All, > > I am working my.cnf file. I would like to know that whether any component > of > my.cnf has to be setup before setting up the data on mysql. > > I am n

MYSQL CONFIGURATION FILE

2007-09-21 Thread Krishna Chandra Prajapati
Hi All, I am working my.cnf file. I would like to know that whether any component of my.cnf has to be setup before setting up the data on mysql. I am not able to change innodb_log_file_size. Please help me.

Compiling a second mysql binary with a distinct configuration.

2007-09-15 Thread Lloyd Zusman
he /usr/private tree. However, the various programs still seem to be looking by default in /etc for the "my.cnf" file. Since /etc/my.cnf is the file that the standard version of mysql uses, this new, private version tries to point to the directories that are specified in the old version&#x

Suggested tools to benchmark configuration changes

2007-09-11 Thread Rob Wultsch
I have a server that has several hundred table in a few different databases comprising almost a gig of data, all running on a rather old (3.23) version of mysql. I have used the slow query log to identify queries and have optimized the queries significantly. At this point the entries in the slow-q

help with optimal configuration for blobs

2007-07-26 Thread jochen kaechelin
table and two fields. id integer db_data longblob Normally the standard my.cnf coming with etch is good for me - but now I think I need to tune my configuration. Could someone advice me? Thanx. -- Jochen Kaechelin gissmoh.de, figgfrosch.de, ror-ror.de -- MySQL General

Re: right configuration.

2007-03-26 Thread Ananda Kumar
Hi Friends, Can you please help me this info, it would be of great help. regards anandkl On 3/25/07, Ananda Kumar <[EMAIL PROTECTED]> wrote: Hi Friends, We are in the processing of building a new Mysql database. We are planing to use innodb. I need help on couple of questions. 1. What are t

Re: right configuration.

2007-03-25 Thread Ananda Kumar
Hi Friends, Any answers to these questions would be of great help to me. regards anandkl On 3/25/07, Ananda Kumar <[EMAIL PROTECTED]> wrote: Hi Friends, We are in the processing of building a new Mysql database. We are planing to use innodb. I need help on couple of questions. 1. What are th

Re: Making a prefixed install / hard-wired global configuration files?

2007-03-25 Thread Nick Hill
Hello Jeremy Thank you for the pointer. After make clean, re-configured, re-compiled then tried, but /path/to/bin/mysql --help still shows /etc/my.cnf as the default file. Jeremy Cole wrote: Hi Nick, This should do it: --sysconfdir=DIR read-only single-machine data [PREFIX/etc] Reg

Re: Making a prefixed install / hard-wired global configuration files?

2007-03-25 Thread Jeremy Cole
Hi Nick, This should do it: --sysconfdir=DIR read-only single-machine data [PREFIX/etc] Regards, Jeremy Nick Hill wrote: Is there an easy way to build MySQL client library, server and start-up script so that /etc/my.cnf is ignored? I need to build client and server so that it in no

Making a prefixed install / hard-wired global configuration files?

2007-03-25 Thread Nick Hill
Is there an easy way to build MySQL client library, server and start-up script so that /etc/my.cnf is ignored? I need to build client and server so that it in no way interacts with the global system install, and build programs against that client library which also don't interact with the glob

right configuration.

2007-03-24 Thread Ananda Kumar
Hi Friends, We are in the processing of building a new Mysql database. We are planing to use innodb. I need help on couple of questions. 1. What are the best parameter setting in my.cnf for innodb. 2. Is it possible to allocate each table a separate tablespace. 3. Is it possible to create index i

Re: Windows Server Configuration

2006-08-25 Thread William R. Mussatto
Just noticed that you said partitions. I am assuming that you meat multiple drives in a raid array. Bill David Lazo said: > Thanx again. > > For the time being, we will keep 4 drives with Dan's suggestion. OS and > MySQL running from there. > > > > On 8/25/06 11:03 AM, "Dan Buettner" <[EMAIL PR

Re: Windows Server Configuration

2006-08-25 Thread David Lazo
Thanx again. For the time being, we will keep 4 drives with Dan's suggestion. OS and MySQL running from there. On 8/25/06 11:03 AM, "Dan Buettner" <[EMAIL PROTECTED]> wrote: > James, with just 4 drives, you can set up one big RAID 10 disk > (usually called a "logical disk", with Dell PERCs I

Re: Re: Re: Windows Server Configuration

2006-08-25 Thread Dan Buettner
Sorry, I think I had James and David backwards there! On 8/25/06, Dan Buettner <[EMAIL PROTECTED]> wrote: James, with just 4 drives, you can set up one big RAID 10 disk (usually called a "logical disk", with Dell PERCs I think it's a "container"), and then partition it for your different needs.

Re: Re: Windows Server Configuration

2006-08-25 Thread Dan Buettner
James, with just 4 drives, you can set up one big RAID 10 disk (usually called a "logical disk", with Dell PERCs I think it's a "container"), and then partition it for your different needs. If you have 4 73 GB disks, you probably have around 135 GB formatted capacity with RAID 10; I'd do somethin

Re: Windows Server Configuration

2006-08-25 Thread JamesDR
David Lazo wrote: I'm sorry to bother you again with this. So we have the server but we have 4 Drives and now that I'm trying to set up the RAID10 I'm starting to think I needed 5 Drives one for the OS?. Please advise. David. We built one pretty close to this recently. You definitely

Re: Windows Server Configuration

2006-08-22 Thread David Lazo
> >>> Windows Server 2003 R2, Standard x64 Edition >>> 2- Dual Core Intel Xeon 5080, 2x2MB Cache, 3.73GHz, 1066MHz FSB >>> 8GB 533MHz (8x1GB), Dual Ranked DIMMs >>> 3- 146GB, SAS, 3.5-inch, 15K RPM Hard Drives >>> >>> What would be the recomm

Re: Windows Server Configuration

2006-08-22 Thread Dan Buettner
: > We want to get: > > Windows Server 2003 R2, Standard x64 Edition > 2- Dual Core Intel Xeon 5080, 2x2MB Cache, 3.73GHz, 1066MHz FSB > 8GB 533MHz (8x1GB), Dual Ranked DIMMs > 3- 146GB, SAS, 3.5-inch, 15K RPM Hard Drives > > What would be the recommended RAID configuration

Re: Windows Server Configuration

2006-08-22 Thread JamesDR
David Lazo wrote: We want to get: Windows Server 2003 R2, Standard x64 Edition 2- Dual Core Intel Xeon 5080, 2x2MB Cache, 3.73GHz, 1066MHz FSB 8GB 533MHz (8x1GB), Dual Ranked DIMMs 3- 146GB, SAS, 3.5-inch, 15K RPM Hard Drives What would be the recommended RAID configuration settings for a

Windows Server Configuration

2006-08-22 Thread David Lazo
We want to get: Windows Server 2003 R2, Standard x64 Edition 2- Dual Core Intel Xeon 5080, 2x2MB Cache, 3.73GHz, 1066MHz FSB 8GB 533MHz (8x1GB), Dual Ranked DIMMs 3- 146GB, SAS, 3.5-inch, 15K RPM Hard Drives What would be the recommended RAID configuration settings for a dedicated MySQL db

Re: udf configuration resources

2006-07-20 Thread Eric Bergen
t you want to store configuration for? I have a feeling udfs are not he right solution. On 7/19/06, Yong Lee <[EMAIL PROTECTED]> wrote: Hi all, I hope I have hit the right group for this question. I would like to create a UDF that is configurable at run time. Similar to how mysql c

RE: udf configuration

2006-07-19 Thread Jimmy Guerrero
6 6:10 PM > To: mysql@lists.mysql.com > Subject: udf configuration > > Hi all, > > > > I hope I have hit the right group for this question. > > > > I would like to create a UDF that is configurable at run > time. Similar to how mysql can use variables

udf configuration resources

2006-07-19 Thread Yong Lee
Hi all, I hope I have hit the right group for this question. I would like to create a UDF that is configurable at run time. Similar to how mysql can use variables defined in the /etc/my.cnf file, I'd like my UDF to make use of configuration parameters that can be set at run time.

udf configuration

2006-07-19 Thread Yong Lee
Hi all, I hope I have hit the right group for this question. I would like to create a UDF that is configurable at run time. Similar to how mysql can use variables defined in the /etc/my.cnf file, I'd like my UDF to make use of configuration parameters that can be set at run time.

Query Cache configuration

2006-04-20 Thread Gabriel Mahiques
Hi friends, I need your help. I want to configure the Query Cache, but it dosn't work. I have installed MySQL 5.0.19 in Mandrake Linux. The server has 2GB memory ram, 150 gb hard disk, exclusive for dbms. I configure my system how say the home page. I follow step by step the instructions. (http:

Re: Optimal configuration on slow/old machines

2005-11-15 Thread SGreen
Jochen Kächelin <[EMAIL PROTECTED]> wrote on 11/15/2005 07:46:13 AM: > Am Dienstag, 15. November 2005 13:29 schrieb Jochen Kächelin: > > Ups!! > > Wrong link! > > The right one: http://gissmoh.kicks-ass.net:81 > > -- > Jochen > Hardware recommendations: Add as much RAM as possible and if yo

Re: Optimal configuration on slow/old machines

2005-11-15 Thread Jochen Kächelin
Am Dienstag, 15. November 2005 13:29 schrieb Jochen Kächelin: Ups!! Wrong link! The right one: http://gissmoh.kicks-ass.net:81 -- Jochen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Optimal configuration on slow/old machines

2005-11-15 Thread Jochen Kächelin
Hello! I run a picture-database (http://gissmoh.kicks-ass.net) on Ubuntu Breezy on an old machine: processor : 0 vendor_id : GenuineIntel cpu family : 6 model : 7 model name : Pentium III (Katmai) stepping: 3 cpu MHz : 501.226 cache size : 512

Re: Best configuration OS WebServer

2005-10-26 Thread Alvaro Cobo
alled in your laptop to your demo, and to check that your application is really multiplatform. Hope this newbie advice helps you, Alvaro. - Original Message - From: "Serge Goyette" <[EMAIL PROTECTED]> To: Sent: Wednesday, October 26, 2005 9:24 AM Subject: Best confi

RE: Best configuration OS WebServer

2005-10-26 Thread Serge Goyette
Thank you for your precious help -Message d'origine- De : J.R. Bullington [mailto:[EMAIL PROTECTED] Envoyé : 26 octobre 2005 11:18 À : mysql@lists.mysql.com Objet : RE: Best configuration OS WebServer Just because your webpage and your MySQL server are running on Linux doesn&#

RE: Best configuration OS WebServer

2005-10-26 Thread J.R. Bullington
ns, that's the place to go. HTH, J.R. -Original Message- From: Serge Goyette [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 26, 2005 11:03 AM To: 'J.R. Bullington'; mysql@lists.mysql.com Subject: RE: Best configuration OS WebServer Hi Thank you for the answer &q

RE: Best configuration OS WebServer

2005-10-26 Thread Serge Goyette
D] Envoyé : 26 octobre 2005 10:40 À : mysql@lists.mysql.com Objet : RE: Best configuration OS WebServer I don't want to speak out of turn, but here is the real question... What are you more comfortable with? If you feel that you are more comfortable with Windows, then use Windows and Windows 2

RE: Best configuration OS WebServer

2005-10-26 Thread J.R. Bullington
with your laptop to Linux, and it would help you to learn WHY things work, not just HOW they work. HTH, J.R. -Original Message- From: Serge Goyette [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 26, 2005 10:24 AM To: mysql@lists.mysql.com Subject: Best configuration OS WebServer Hi,

Best configuration OS WebServer

2005-10-26 Thread Serge Goyette
Hi, I am a brand new newbie...two questions. Question 1 What is the best configuration for using MySQL and PHP from the three following combinations: #1 OS: Linux WebServer: Apache #2 OS:Windows XP SP2(Family edition

Re: configuration directives 4.0.18

2005-10-18 Thread Gleb Paharenko
ere can I find a good explanation/description of the configuration > directives for mysql as they appear in my.cnf? > > I've downloaded the 4.1 manual but can't seem to find a description of > the directives. > BTW. Is there a manual for 4.0.18 or 4.0 versi

configuration directives 4.0.18

2005-10-16 Thread Luke Vanderfluit
Hi. Where can I find a good explanation/description of the configuration directives for mysql as they appear in my.cnf? I've downloaded the 4.1 manual but can't seem to find a description of the directives. BTW. Is there a manual for 4.0.18 or 4.0 version? Thanks. Kind regards

Solution: old configuration

2005-09-07 Thread Löffler Thomas J .
Hi all, Thanks for your replies, Found the solution. I had the data directory on another harddisk + did not delete it after the deinstallation. cheers, Thomas t.j. loeffler swiss federal institute of technology department of eart

Re: RAID/MySQL configuration question

2005-08-25 Thread Jason Pyeron
On Thu, 25 Aug 2005, Gary Richardson wrote: My guess is that the RAID has nothing to do with it -- it seems very unlikely. In any case, if you want top performance out of your raid, you may want to change things up. You'd get better performance if you didn't use RAID5. Use RAID1 or RAID10 for y

Re: RAID/MySQL configuration question

2005-08-25 Thread Gary Richardson
My guess is that the RAID has nothing to do with it -- it seems very unlikely. In any case, if you want top performance out of your raid, you may want to change things up. You'd get better performance if you didn't use RAID5. Use RAID1 or RAID10 for your data drives. RAID5 is slower than these oth

RAID/MySQL configuration question

2005-08-25 Thread Curious George
G'morning all! (Using Red Hat Linux Enterprise 4.1) I have a Dell PowerEdge 2800 with a PERC 4 RAID controller. The RAID controller has one RAID 1 mirror and one RAID 5 stripe volume created. We installed most of the OS stuff on the RAID 1 set and the /usr/local and /var on the RAID 5 set (since

mysql-4.1.13 and RHEL and rpm was Re: mysql-4.1.13 and openssl-0.9.8 configuration issue

2005-08-23 Thread Jason Pyeron
Could you post your local mods and versions, if you need this, then others may too. Did you file a bug with redhat? I am making the openssl-0.9.8-0 rpms right now. rpmbuild -ta openssl-0.9.8.tgz table for you to fill in: package version reason --- ---

Re: mysql-4.1.13 and openssl-0.9.8 configuration issue

2005-08-23 Thread RedRed!com IT Department
/client/Makefile add “-ldl” to libs parameter of /Software/MySQL/mysqlx.x/tests/Makefile after adding the above to the appropriate Makefiles, the rest of the configuration, make, and make install ran smoothly. Thanks for all of your suggestions. Sean Enrique Sanch

Re: mysql-4.1.13 and openssl-0.9.8 configuration issue

2005-08-23 Thread RedRed!com IT Department
I couldn't find the an rpm for the lastest version of zlib, openssl, etc... I could use the mysql rpm but does it have all of the features and extras in it or does it come barebone? Does it know where to look for all of the necessary libraries and includes? I have never ventured into the rpm r

  1   2   3   >