my.cnf settings
I currently have a dedicated database server with 8 GBs of RAM and 8 1.60 GHz processors. The tables on my databases are almost exclusively InnoDB, except for 2-3 tables that are MyISAM and used for logging purposes (lots of INSERT DELAYED statements). I have the following settings in my my.cnf, and I'm having trouble adjusting the innodb_buffer_pool_size to something logical. I first tried setting it to 6000M, but the server went OOM and eventually crashed. I've subsequently kept bringing it down, and now it's at 4000M but it looks like swap is still being hit. $ free -m total used free sharedbuffers cached Mem: 7982 7943 38 0 8175 -/+ buffers/cache: 7759222 Swap: 1992702 1289 I spent some time looking at various Google links to figure out memory usage, and what I'm confused by is how mysqld is still talking up 8388m of virtual memory (according to top) and has 6.7g of physical memory used. http://www.mysqlperformanceblog.com/2006/05/17/mysql-server-memory-usage/ http://www.mysqlperformanceblog.com/2009/02/12/how-much-memory-can-mysql-use-in-the-worst-case/ What I'm trying to figure out is 1. Are there settings I should turn down for myisam or myisamchk, and is that why I'm hitting 6.7GBs of actual memory? 2. Is 4000M the correct setting for innodb_buffer_pool_size? 3. Even if it is 6.7 GBs of memory, isn't 1.3 GBs of RAM (give or take) more than enough to run the rest of the machine? I don't see anything else coming close to the memory footprint of mysql, and I'm not sure why swap is still getting hit. [mysqld] #datadir=/home/mysql socket=/var/lib/mysql/mysql.sock max_connections = 320 safe-show-database skip-locking key_buffer = 192M max_allowed_packet = 1M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size= 32M thread_concurrency = 8 wait_timeout = 15 innodb_buffer_pool_size=4000M innodb_log_buffer_size=4M #innodb_log_file_size=128M #innodb_flush_method=O_DIRECT innodb_flush_log_at_trx_commit=2 log-slow-queries=/var/log/mysql/log-slow-queries.log log-error=/var/log/mysql/mysqlerror.log #innodb_file_per_table sql-mode=NO_AUTO_VALUE_ON_ZERO [mysqldump] quick max_allowed_packet = 16M [mysql] #no-auto-rehash max_allowed_packet = 1M [isamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M
Dismal performance on a 16G memory/8 core server - my.cnf settings?
Hello, We recently purchased a Dell PowerEdge 6650 thinking it would be a real fast server. Specs are: OS: Linux Debian 4.0/Etch RAID 5 on 4x U320 15k rpm drives (uses a perc-raid 3/DC hardware raid controller) 16GB of RAM 4 3.0 Ghz Xeon processors - I think they're dual core, in /proc/cpuinfo it shows up as 8 processors - maybe it's only HT I first made the mistake of using the default kernel, which provides SMP support but not large memory support. I have the output of a mysql sql-bench run from mysql on a Mac Mini to compare performance with. The server was only 0.35 (relative) the speed of the Mac mini - that means an 8 core 3.0 Ghz Xeon server with 16GB of RAM was only about 3x as fast as a as a single-core 1.25 Ghz G4 with 1GB of RAM (and a mini uses those little laptop hard drives, too). Needless to say my employer was shocked at the terrible performance and decided to sell the 6650 right away. But I can't help but wonder if there's not something terribly wrong with the settings - either the OS or mysql settings. I changed the kernel to the -bigmem kernel. It now sees all the RAM, but the sql-bench output on this try was _exactly_ the same: 0.35 I copied the my-huge.cnf from the examples directory and changed the thread_concurrency setting to 8 (because it said to set it to No. of CPUs*2). I also set the tmpdir, basedir, datadir and language, which were set in the original my.cnf I ran sql-bench again and the performance was even worse this time: 0.36 Someone suggested I try the -amd64 kernels which provide 64 bit but when I try to boot it I get various errors about this CPU does not support long (something) please use a 32-bit OS - the 64 bit install CD says the same message. So I assume these are not 64 bit CPUs. Any idea how I can configure this server to maximize performace? I think the multiple CPUs are a waste: I'm not looking for lots of concurrency, I want 1 query done really fast. Thanks. JW -- -- System Administrator - Cedar Creek Software http://www.cedarcreeksoftware.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Dismal performance on a 16G memory/8 core server - my.cnf settings?
Hi, On Wed, Apr 23, 2008 at 11:07 PM, JW [EMAIL PROTECTED] wrote: Hello, We recently purchased a Dell PowerEdge 6650 thinking it would be a real fast server. Specs are: OS: Linux Debian 4.0/Etch RAID 5 on 4x U320 15k rpm drives (uses a perc-raid 3/DC hardware raid controller) 16GB of RAM 4 3.0 Ghz Xeon processors - I think they're dual core, in /proc/cpuinfo it shows up as 8 processors - maybe it's only HT I first made the mistake of using the default kernel, which provides SMP support but not large memory support. I have the output of a mysql sql-bench run from mysql on a Mac Mini to compare performance with. The server was only 0.35 (relative) the speed of the Mac mini - that means an 8 core 3.0 Ghz Xeon server with 16GB of RAM was only about 3x as fast as a as a single-core 1.25 Ghz G4 with 1GB of RAM (and a mini uses those little laptop hard drives, too). Needless to say my employer was shocked at the terrible performance and decided to sell the 6650 right away. But I can't help but wonder if there's not something terribly wrong with the settings - either the OS or mysql settings. I changed the kernel to the -bigmem kernel. It now sees all the RAM, but the sql-bench output on this try was _exactly_ the same: 0.35 I copied the my-huge.cnf from the examples directory and changed the thread_concurrency setting to 8 (because it said to set it to No. of CPUs*2). I also set the tmpdir, basedir, datadir and language, which were set in the original my.cnf I ran sql-bench again and the performance was even worse this time: 0.36 Someone suggested I try the -amd64 kernels which provide 64 bit but when I try to boot it I get various errors about this CPU does not support long (something) please use a 32-bit OS - the 64 bit install CD says the same message. So I assume these are not 64 bit CPUs. They almost certainly are. Look at the contents of /proc/cpuinfo. You are probably using a 32-bit OS. You can't use a lot of memory efficiently unless you install a 64-bit OS, regardless of whether it has big memory support. But that's an x86_64 OS, not an AMD64 OS. These are not the same architecture. Any idea how I can configure this server to maximize performace? I think the multiple CPUs are a waste: I'm not looking for lots of concurrency, I want 1 query done really fast. You will be bound by CPU performance on any given single query, yes. But properly tuned, you may get a lot more performance out of this machine. Have you tuned MySQL (key_buffer_size and/or innodb_buffer_pool_size) to use the added memory, for starters? How much data do you even have? If your data all fits in the mac mini's memory and it has a comparable CPU and bus, I wouldn't be surprised to see it keeping up with the Dell fairly well on this benchmark. More to the point: does the benchmark reflect your real-life workload? Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Dismal performance on a 16G memory/8 core server - my.cnf settings?
Hi, Someone suggested I try the -amd64 kernels which provide 64 bit but when I try to boot it I get various errors about this CPU does not support long (something) please use a 32-bit OS - the 64 bit install CD says the same message. So I assume these are not 64 bit CPUs. They almost certainly are. Look at the contents of /proc/cpuinfo. You are probably using a 32-bit OS. You can't use a lot of memory efficiently unless you install a 64-bit OS, regardless of whether it has big memory support. But that's an x86_64 OS, not an AMD64 OS. These are not the same architecture. Er, since he's talking about a 6650, a 6th generation Dell machine, it very likely *does* have 32-bit CPUs. And he's said it came with the PERC 3/DC card, which is a very old RAID card. I would hope this machine didn't cost much, as it's quite old. Besides that, though, x86_64 is exactly the amd64 architecture. AMD came up with it, Linux called it amd64, and then when Intel copied it and called it EM64T, it was renamed in Linux to x86_64 to be more generic. The above message is the exact one you get when you try to boot an x86_64 kernel on a 32-bit CPU. Regards, Jeremy -- high performance mysql consulting www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Dismal performance on a 16G memory/8 core server - my.cnf settings?
Hi, On Thu, Apr 24, 2008 at 12:20 PM, Jeremy Cole [EMAIL PROTECTED] wrote: Hi, Someone suggested I try the -amd64 kernels which provide 64 bit but when I try to boot it I get various errors about this CPU does not support long (something) please use a 32-bit OS - the 64 bit install CD says the same message. So I assume these are not 64 bit CPUs. They almost certainly are. Look at the contents of /proc/cpuinfo. You are probably using a 32-bit OS. You can't use a lot of memory efficiently unless you install a 64-bit OS, regardless of whether it has big memory support. But that's an x86_64 OS, not an AMD64 OS. These are not the same architecture. Er, since he's talking about a 6650, a 6th generation Dell machine, it very likely *does* have 32-bit CPUs. And he's said it came with the PERC 3/DC card, which is a very old RAID card. I would hope this machine didn't cost much, as it's quite old. When you get old like me you won't remember every machine model :-) I didn't think they'd made 32-bit Xeons for a long time. (But I guess that's your point). Besides that, though, x86_64 is exactly the amd64 architecture. AMD came up with it, Linux called it amd64, and then when Intel copied it and called it EM64T, it was renamed in Linux to x86_64 to be more generic. And this one gets me every time. OK, sorry for the wrong advice JW! You can probably sort all this out on your own now. Like I said, /proc/cpuinfo. Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Dismal performance on a 16G memory/8 core server - my.cnf settings?
I think what we need to know is more stuff about the database itself. How big is it? I assume if you were able to serve it from a Mac Mini it can't be all that big. 16GB should be big enough to contain all the data and serve it up quickly. And while 4-disk RAID 5 isn't all that great, it's certainly better than a single ATA disk in Mac Mini. If your database is huge, then 16GB is barely enough to hold innodb buffer pool (if innodb) and maybe the indexes. Then your RAID config will come into play (and maybe filesystem type, tuning). Then whether it's a Dell PE1750 or a 6650 would not make a huge difference since it's I/O bound. Were you testing with something like production data or just some test data? Have you modified my.cnf to reflect the new hardware config? Like Baron Schwartz asked, does your test reflect real-life workload? And yes, the 3.0Ghz Xeon processors you mentioned are 32-bit. You get that error message if your processor doesn't have EM64T capability. -Paul JW wrote: Hello, We recently purchased a Dell PowerEdge 6650 thinking it would be a real fast server. Specs are: OS: Linux Debian 4.0/Etch RAID 5 on 4x U320 15k rpm drives (uses a perc-raid 3/DC hardware raid controller) 16GB of RAM 4 3.0 Ghz Xeon processors - I think they're dual core, in /proc/cpuinfo it shows up as 8 processors - maybe it's only HT I first made the mistake of using the default kernel, which provides SMP support but not large memory support. I have the output of a mysql sql-bench run from mysql on a Mac Mini to compare performance with. The server was only 0.35 (relative) the speed of the Mac mini - that means an 8 core 3.0 Ghz Xeon server with 16GB of RAM was only about 3x as fast as a as a single-core 1.25 Ghz G4 with 1GB of RAM (and a mini uses those little laptop hard drives, too). Needless to say my employer was shocked at the terrible performance and decided to sell the 6650 right away. But I can't help but wonder if there's not something terribly wrong with the settings - either the OS or mysql settings. I changed the kernel to the -bigmem kernel. It now sees all the RAM, but the sql-bench output on this try was _exactly_ the same: 0.35 I copied the my-huge.cnf from the examples directory and changed the thread_concurrency setting to 8 (because it said to set it to No. of CPUs*2). I also set the tmpdir, basedir, datadir and language, which were set in the original my.cnf I ran sql-bench again and the performance was even worse this time: 0.36 Someone suggested I try the -amd64 kernels which provide 64 bit but when I try to boot it I get various errors about this CPU does not support long (something) please use a 32-bit OS - the 64 bit install CD says the same message. So I assume these are not 64 bit CPUs. Any idea how I can configure this server to maximize performace? I think the multiple CPUs are a waste: I'm not looking for lots of concurrency, I want 1 query done really fast. Thanks. JW -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Dismal performance on a 16G memory/8 core server - my.cnf settings?
JW wrote: Hello, We recently purchased a Dell PowerEdge 6650 thinking it would be a real fast server. Specs are: OS: Linux Debian 4.0/Etch RAID 5 on 4x U320 15k rpm drives (uses a perc-raid 3/DC hardware raid controller) 16GB of RAM 4 3.0 Ghz Xeon processors - I think they're dual core, in /proc/cpuinfo it shows up as 8 processors - maybe it's only HT snip This machine is not what is seems to be unfortunately. 1. Dell until their latest series with the Woodcrest based CPUs was a notoriously bad performer period. 2. Raid 5 + Database == run faster over serial cable. Use RAID 1+0. 3. Dell hasn't made a re-branded a decent RAID controller that is anything more than 18 months old. 4. 16GB doesn't help you because you are limited by your 32bitness. Get a real machine with real processors. 5. The CPU is hyper threaded, not dual core. I doubt you would ever get decent performance out of this for any database let alone MySQL. Tell your boss to suck it up, spend 5k. You can get a new, decent Dell for that. Or better yet, a HP. Sincerely, Joshua D. Drake -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
InnoDB my.cnf settings on OS X 10.3 Server?
I am trying to figure out the best innodb paramaters in the my.cnf file. Server is XServe, single CPU, G4 1 GHz, OS X Panther 10.3.4 with 2 GB RAM and 180GB hard drive, MySQL version 4.0.20. Right now I am running on default params. Does anyone out there have a suggested innodb parameters or even a working set of params that I could start with. Also, does anyone definitively know what the maximum filesize is for OS X Panther (and consequently the max innodb tablespace filesize? Regards, Kieran Dev Config = OS X 10.3.4 / Java 1.4.2 / WO 5.2.3 / XCode v1.2 / MySQL 4.0.20 / Connector-J 3.0.11 Deploy Config = OS X 10.3.4 Server / Java 1.4.2 / WO 5.2.3 / MySQL 4.0.20 / Connector-J 3.0.11 My Blog: http://webobjects.webhop.org/ Meet other WO Developers at http://webobjects.meetup.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: InnoDB my.cnf settings on OS X 10.3 Server?
Kieran Kelleher wrote: Does anyone out there have a suggested innodb parameters or even a working set of params that I could start with. The InnoDB manual gives good suggestion. Some minor comments (none particularly OS X specific, but InnoDB works fine on it) innodb_buffer_pool_size is very important. We have ours at 900 MB, but this is a machine running only mysql with 2GB of RAM. You want as much as you can have here, but not so much to cause pageing. innodb_additional_mem_pool_size should be big enough to work around this bug (we use 50M and have avoided the bug, 10M did not, but it's usage specific) http://dev.mysql.com/doc/mysql/en/InnoDB_news-4.0.21.html If you configure innodb_additional_mem_pool_size so small that InnoDB memory allocation spills over from it, then every 4 billionth spill may cause memory corruption. A symptom is a printout like below in the `.err' log. The workaround is to make innodb_additional_mem_pool_size big enough to hold all memory allocation. Use SHOW INNODB STATUS to determine that there is plenty of free space available in the additional mem pool, and the total allocated memory stays rather constant. InnoDB: Error: Mem area size is 0. Possibly a memory overrun of the InnoDB: previous allocated area! InnoDB: Apparent memory corruption: mem dump len 500; hex when we set innodb_thread_concurrency too large we ran into behavior that looked a lot like a thread thrashing problem seen on InnoDB on Linux some time ago. We didn't have proof, but reducing innodb_thread_concurrency to (number of cpus + number of physical disks) made the issue go away. For us this value is 8. We use 4 logs and a log file size about 25% of innodb_buffer_pool_size. (set via innodb_log_file_size and innodb_log_files_in_group). This has implications for speed and recovery time after a crash. Also, does anyone definitively know what the maximum filesize is for OS X Panther (and consequently the max innodb tablespace filesize? It's huge. We use mainlu 4G files, but an autoextending one grew to 12GB without issue. Apple lists this in the knowledge base somewhere. Good luck, Ware -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: InnoDB my.cnf settings on OS X 10.3 Server?
Kieran, The InnoDB tablespace may span multiple files and may even be configured to use raw devices, thus, the filesystem really doesn't limit the maximum InnoDB tablespace size. The maximum InnoDB tablespace size is 64TB. Eg. of multiple files/devices innodb_data_file_path=ibdata1:4G;ibdata2:50M:autoextend http://mysql.megalink.com/doc/mysql/en/InnoDB_restrictions.html http://mysql.megalink.com/doc/mysql/en/InnoDB_configuration.html Hope this helps, Lachlan -Original Message- From: Kieran Kelleher [mailto:[EMAIL PROTECTED] Sent: Tuesday, 20 July 2004 6:15 AM To: Mysql Subject: InnoDB my.cnf settings on OS X 10.3 Server? I am trying to figure out the best innodb paramaters in the my.cnf file. Server is XServe, single CPU, G4 1 GHz, OS X Panther 10.3.4 with 2 GB RAM and 180GB hard drive, MySQL version 4.0.20. Right now I am running on default params. Does anyone out there have a suggested innodb parameters or even a working set of params that I could start with. Also, does anyone definitively know what the maximum filesize is for OS X Panther (and consequently the max innodb tablespace filesize? Regards, Kieran Dev Config = OS X 10.3.4 / Java 1.4.2 / WO 5.2.3 / XCode v1.2 / MySQL 4.0.20 / Connector-J 3.0.11 Deploy Config = OS X 10.3.4 Server / Java 1.4.2 / WO 5.2.3 / MySQL 4.0.20 / Connector-J 3.0.11 My Blog: http://webobjects.webhop.org/ Meet other WO Developers at http://webobjects.meetup.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: RE: my.cnf settings and running admin commands such as mysqldump
David, Wednesday, October 23, 2002, 7:48:25 PM, you wrote: DK Is it a save assumption that I need to create a section for every admin DK command that I want to use? i.e., create another section for mysqladmin and DK so on??? Yes and no. Common options like user, password you can put in the [client] section of my.cnf Specific option, like all-databases for mysqldump, you can put into [client] section and it will work for mysqldump, but it's unrecognized option for other clients. So, you will get errors ... DK -Original Message- DK From: Victoria Reznichenko [mailto:victoria.reznichenko;ensita.net] DK Sent: Wednesday, October 23, 2002 5:28 AM DK To: [EMAIL PROTECTED] DK Subject: re: my.cnf settings and running admin commands such as DK mysqldump or m DK David, DK Wednesday, October 23, 2002, 12:23:36 AM, you wrote: DK I was wondering if someone could shed some light on setting parameters DK in DK my.cnf. When I set params such as user and password in my my.cnf file I DK dont need to then pass these parameters to commands such as mysqldump or DK mysqladmin? Is this True? Can someone please send me an example of DK their DK my.cnf file, Im just curious what a real example would look like. I DK have DK already read through the my.cnf documentation on the website, but if DK someone DK has a better place for online doc on the config file please let me know. DK Any other insight is more than welcome and appreciated. DK For mysqldump you create a section [mysqldump] in the my.cnf where you DK can specify mysqldump options like DK [mysqld] DK . DK [mysqldump] DK user=Victoria DK password=mypassword DK -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: my.cnf settings and running admin commands such as mysqldump or m
David, Wednesday, October 23, 2002, 12:23:36 AM, you wrote: DK I was wondering if someone could shed some light on setting parameters in DK my.cnf. When I set params such as user and password in my my.cnf file I DK dont need to then pass these parameters to commands such as mysqldump or DK mysqladmin? Is this True? Can someone please send me an example of their DK my.cnf file, Im just curious what a real example would look like. I have DK already read through the my.cnf documentation on the website, but if someone DK has a better place for online doc on the config file please let me know. DK Any other insight is more than welcome and appreciated. For mysqldump you create a section [mysqldump] in the my.cnf where you can specify mysqldump options like [mysqld] . [mysqldump] user=Victoria password=mypassword -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: my.cnf settings and running admin commands such as mysqldump or m
Is it a save assumption that I need to create a section for every admin command that I want to use? i.e., create another section for mysqladmin and so on??? Thx, dK -Original Message- From: Victoria Reznichenko [mailto:victoria.reznichenko;ensita.net] Sent: Wednesday, October 23, 2002 5:28 AM To: [EMAIL PROTECTED] Subject: re: my.cnf settings and running admin commands such as mysqldump or m David, Wednesday, October 23, 2002, 12:23:36 AM, you wrote: DK I was wondering if someone could shed some light on setting parameters in DK my.cnf. When I set params such as user and password in my my.cnf file I DK dont need to then pass these parameters to commands such as mysqldump or DK mysqladmin? Is this True? Can someone please send me an example of their DK my.cnf file, Im just curious what a real example would look like. I have DK already read through the my.cnf documentation on the website, but if someone DK has a better place for online doc on the config file please let me know. DK Any other insight is more than welcome and appreciated. For mysqldump you create a section [mysqldump] in the my.cnf where you can specify mysqldump options like [mysqld] . [mysqldump] user=Victoria password=mypassword -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
my.cnf settings and running admin commands such as mysqldump or mysqladmin
I was wondering if someone could shed some light on setting parameters in my.cnf. When I set params such as user and password in my my.cnf file I dont need to then pass these parameters to commands such as mysqldump or mysqladmin? Is this True? Can someone please send me an example of their my.cnf file, Im just curious what a real example would look like. I have already read through the my.cnf documentation on the website, but if someone has a better place for online doc on the config file please let me know. Any other insight is more than welcome and appreciated. Thanks, DK David Kramer Software Developer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
my.cnf settings
Which group(s) would the following options be put under to enable in the my.cnf. safe_show_database skip_show_database Thx's mysql sql database Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php