Re: qcache settings and block meaning

tly. I'll try disabling the query cache and report back. > >> -Original Message- >> From: raphi...@gmail.com [mailto:raphi...@gmail.com] On Behalf Of >> Raphael Bauduin >> Sent: Wednesday, August 29, 2012 2:16 AM >> To: Rick James >> Cc: mysql@lis

RE: qcache settings and block meaning

alf Of > Raphael Bauduin > Sent: Wednesday, August 29, 2012 2:16 AM > To: Rick James > Cc: mysql@lists.mysql.com > Subject: Re: qcache settings and block meaning > > On Tue, Aug 28, 2012 at 6:40 PM, Rick James > wrote: > >> | Qcache_hits | 56418967

Re: qcache settings and block meaning

reasonable max. Thanks for your feedback. These question were going to be the topic of my next mail to the list, but you anticipated correctly :-) Raph > >> -Original Message- >> From: raphi...@gmail.com [mailto:raphi...@gmail.com] On Behalf Of >> Raphael Bauduin >&

RE: qcache settings and block meaning

off the QC for systems with constant write activity. Otherwise, 50M is a reasonable max. > -Original Message- > From: raphi...@gmail.com [mailto:raphi...@gmail.com] On Behalf Of > Raphael Bauduin > Sent: Tuesday, August 28, 2012 7:12 AM > To: mysql@lists.mysql.com > Subject: q

Re: qcache settings and block meaning

- Original Message - > From: "Raphael Bauduin" > > And the query_cache_min_res_unit is 4096 . > > I'm not sure what the meaning of a block is. For the query cache size What you calculated is the *average* block size, which is fairly useless :-) The query cache is not formatted into f

qcache settings and block meaning

Hi, I have a mysql server running with the query cache size being 128M (134217728 bytes). Here are the qcache variables values: | Qcache_free_blocks| 13758| | Qcache_free_memory| 46945512 | | Qcache_hits | 56418967 | | Qcache_

my.cnf settings specifically for myisamchk

hk to do most of this, and I'd like to know the best settings for myisamchk to best optimize all the available memory to get the best performance out of myisamchk. I can have the mysql server down while I'm doing the rebuild, so essentially, the only thing running on the box will be myis

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

Re: Help optimizing settings?

In general you need to adjust your server settings to actually use the new RAM. This depends on various things, storage engines used, what else runs on the box, etc. In addition you should look at your schema, see if you have the right indices for what you want to do. E.g. All columns that you

RE: Help optimizing settings?

Which MySQL server do you use? What is your storage engine? -Original Message- From: Ken D'Ambrosio [mailto:k...@jots.org] Sent: Friday, February 05, 2010 5:26 PM To: mysql@lists.mysql.com Subject: Help optimizing settings? I've got a fairly large -- 100+ GB -- MySQL dat

Re: Help optimizing settings?

Using "load index" might help, but you'll have to make sure you allocate plenty of space to your keycache. If the queries are identical, the query cache might also be a good candidate, but that seems unlikely. The memory will also be used by your OS to cache often-used parts of the filesystem, inc

Help optimizing settings?

I've got a fairly large -- 100+ GB -- MySQL database. It isn't accessed often -- it's acting more as an archive right now than anything else. That being said, when it does get accessed, the indeces seem to take forever to load. Being as I just bumped the RAM from 2 GB to 6 GB, what, generically,

Realistic settings for [myisamchk] in my.cnf

I'm looking to optimize the myisamchk settings for some table rebuilds I need to do. I'm running CentOS 5 and MySQL 5.1 in a VMWare VM with 4 vCPUs and 4GB of memory. All the examples I can find online look like they are several years old, and just copied from someone else's c

Re: Newbie question: importing cvs settings - followup

Thanks again for assistance. FYI, I did track this thread down http://ask.metafilter.com/57007/Missing-commas-in-CSV-file (exerpt: Maybe there is a space or something in the 14th column of the first 15 rows. posted by. on February 14, 2007 It's a bug in Excel (not something you did wrong.)

Re: Newbie question: importing cvs settings

Jerry Schwartz wrote: [JS] This is just a shot in the dark, but Excel can be rather surprising when it puts out a CSV file. Depending upon the data, and exactly how you've specified the export, it can put double-quotes in unexpected places. If you leave out the 17th line of data what happ

RE: Newbie question: importing cvs settings

>-Original Message- >From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com] >Sent: Sunday, September 27, 2009 10:19 AM >Cc: 'mysql' >Subject: Re: Newbie question: importing cvs settings > >Back again... I have 192 records to import, and tried my extra lin

RE: Newbie question: importing cvs settings

6, 2009 11:02 AM To: 'mysql' Subject: Re: Newbie question: importing cvs settings Yep, typo ...:-( I did some screen shots of 2 tests. A workaround solution is to make a final entry in the csv file that I don't really need. Then everything up to that point gets imported ok using

RE: Newbie question: importing cvs settings

ewbie question: importing cvs settings Back again... I have 192 records to import, and tried my extra line at the end hoping for a work around, but nope, it failed at line 17 again. Invalid field count in CSV input on line 17. Anyone have an idea why this might be happening? Patrice Olivier-Wilso

Re: Newbie question: importing cvs settings

Back again... I have 192 records to import, and tried my extra line at the end hoping for a work around, but nope, it failed at line 17 again. Invalid field count in CSV input on line 17. Anyone have an idea why this might be happening? Patrice Olivier-Wilson wrote: Yep, typo ...:-( I did

Re: Newbie question: importing cvs settings

Telephone +44 (0)7812 451238 Email j...@butterflysystems.co.uk -Original Message- From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com] Sent: 26 September 2009 17:08 To: mysql Subject: Newbie question: importing cvs settings Greetings: I have a project for which need to import cvs file

RE: Newbie question: importing cvs settings

fied MySQL 5 Developer (CMDEV) IBM Cognos BI Developer Telephone +44 (0)7812 451238 Email j...@butterflysystems.co.uk -Original Message- From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com] Sent: 26 September 2009 17:08 To: mysql Subject: Newbie question: importing cvs settings Greet

Newbie question: importing cvs settings

the columns, but not all as client will be filling it in online (leaving ID blank) save excel to .cvs log into phpMyAdmin import cvs I've experimented with several settings in the import, but consistently, it fails at line 17, even with different .cvs files. Any guidance, most apprec

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 /p

Re: Dismal performance on a 16G memory/8 core server - my.cnf settings?

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 settin

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" -

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 cer

Re: Dismal performance on a 16G memory/8 core server - my.cnf settings?

t 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

Dismal performance on a 16G memory/8 core server - my.cnf settings?

ible 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

Re: MySQL 5.0.x and 5.1.x Compiling options and settings on Linux IA64: one more question: ./bin/mysqladmin: connect to server at 'localhost' failed

Don't include the password, let mysql prompt for it. ' ./bin/ mysqladmin -u root password -p '. Daniel Culver [EMAIL PROTECTED] On Jan 17, 2007, at 7:57 PM, Mariella Petrini wrote: ./bin/mysqladmin -u root password '***' ./bin/mysqladmin: connect to server at 'localhost' failed

Fwd: Re: MySQL 5.0.x and 5.1.x Compiling options and settings on Linux IA64: one more question: ./bin/mysqladmin: connect to server at 'localhost' failed

Hi, After having compiled (debug and optimized version) of MySQL 5.1.14 on Itanium-2 using icc, I have run mysql_install_db --user=... and started mysqld_safe in both scenarios (debug and optimized). In both cases mysqld starts without any errors. Unfortunaly when

Re: Security settings won't take during installation

Hi Adrian, On 8/25/06, Adrian Greeman <[EMAIL PROTECTED]> wrote: "The security settings could not be applied to the database because the .. I am pasting here the text of one of my earlier posts to this list: I got MySQL 5.0

[Fwd: Re: mysqld_safe and timezone settings]

The starting of the Server with the timezone settings works fine after setting the TZ variable. I always looked at the output from select @@global.time_zone. This was SYSTEM and so I beliefed the timezone wasn't set right on the server. Thanks and Regards Michael Thanks for the help,

Re: mysqld_safe and timezone settings

Thanks for the help, but this isn't my problem. When you start the server as shown below, the SYSTEM Timezone is used for the MySQL server. This could be seen when executing the query select @@global.time_zone on the server. Than you must get a SYSTEM in your data. The problem is that I

Re: mysqld_safe and timezone settings

This was done as root and shows that TZ works. dk:/usr/local/mysql # bin/mysql -V bin/mysql Ver 14.12 Distrib 5.0.18, for pc-linux-gnu (i686) using readline 5.0 dk:/usr/local/mysql # echo $TZ dk:/usr/local/mysql # bin/mysqld_safe --user=mysql & [1] 802 dk:/usr/local/mysql # Starting mysqld da

Re: mysqld_safe and timezone settings

Thanks for your help, but this is the problem I have. I can't specify the timezone right when I start mysql with mysqld_safe --user=mysql --timezone="America/Argentina/Mendoza" or by setting the TZ enviroment variable and than start the server. The timezone setting is ignored every time I start

Re: mysqld_safe and timezone settings

or what I although could do to start my Server in another than the SYSTEM timezone? I use the MySQL 5.0.18 Server on a Suse Linux 10.0 From: http://dev.mysql.com/doc/refman/5.0/en/timezone-problems.html You can set the time zone for the server with the --timezone=timezone_name option to mysq

mysqld_safe and timezone settings

Hello everybody, I have a problem with replication of data from master to slave server. The problem is, that the master is in a other timezone than the slave and so inserts with using the now() function creates different values on master and slave. If I want to update on the master and use the

Re: Timezone settings

Hello. See: http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html [EMAIL PROTECTED] wrote: > Dear Friends, > I need to do the timezone settings so that now() gives the system > time.Actually first i have installed mysql on a different timezone han > changed the system t

Timezone settings

Dear Friends, I need to do the timezone settings so that now() gives the system time.Actually first i have installed mysql on a different timezone han changed the system time zone but perhaps mysql shows the previous time zone or the default time zone only. Pl. tell me how to change that . I shall

Re: old settings

eleted also the entries in the registry which were not deleted by the uninstall process (search "mysql"). Now, after installing again MySQL db server 4.1.14 etc. everything seems to be ok, but after restarting the MySQL daemon, the old settings from the installation before appear + cannot

Re: old settings

entry/entries must be deleted Settings are stored in the configuration file. See: http://dev.mysql.com/doc/mysql/en/option-files.html Loffler Thomas J. <[EMAIL PROTECTED]> wrote: >Hi all, > >I've installed MySQL db server 4.1.14 + Administrator + Control Center

old settings

registry which were not deleted by the uninstall process (search "mysql"). Now, after installing again MySQL db server 4.1.14 etc. everything seems to be ok, but after restarting the MySQL daemon, the old settings from the installation before appear + cannot be changed. The error is most

Innodb Settings - repost

looking to determine the best Innodb Settings for our MySQL Instances. Specifically, the settings for innodb_buffer_pool_size and innodb_log_file_size. I have read the manual and understand how they work. I am looking for additional information that would help me determine their values instance

Innodb Settings

Hello I am looking to determine the best Innodb Settings for our MySQL Instances. Specifically, the settings for innodb_buffer_pool_size and innodb_log_file_size. I have read the manual and understand how they work. I am looking for additional information that would help me determine their

Minimial settings on Windows XP AND Linux for MySQL server

level. My question here is, how can I set both of them to run ONLY essential utilities necessary to support MySQL with good security settings? And, no I do not mean computer inside a locked room without network support :) I would like to know if anyone had experience and have a resource for it

Re: How can I make permanent timeout variable settings???

owing command. > "LOAD DATA FROM MASTER" after clearing the data folders in the slave > machines. > > But if shows me a timeout error. I then tired to increase the > net_read_timeout, net_write_timeout and the wait_timeout. But this > doesn't seem to work sinc

How can I make permanent timeout variable settings???

oesn't seem to work since I get the same error's. And the settings that I made has not been assigned permanently. When I tried for "Show Variables". It shows me the default settings. How can I make my changes permanent until I move my Data from the Master to the Slave m

Re: my.cnf parameter settings for 4 GB RAM

Hi. Tune key_buffer_size for it. And you may want to order commercial support to receive finetune of your server: go to https://order.mysql.com/?ref=ensita "Anil Doppalapudi" <[EMAIL PROTECTED]> wrote: > please provide me listof my.cnf parameter values for 4 GB RAM . from support > files i

my.cnf parameter settings for 4 GB RAM

please provide me listof my.cnf parameter values for 4 GB RAM . from support files i can list out only upto 2 GB RAM my database is mysql 4.0.20 binary installation on linux and along with database apache, tomcat and one more application is running on the server. Thanks in advance Anil -- My

RE: InnoDB my.cnf settings on OS X 10.3 Server?

bject: 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 anyon

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

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 e

Re: UTF-8 settings and woes (update)

hi mark, What happens if you explicitly specify the table character set to be 'utf-8'? (i.e. you're relying on the database default character set to take care of that for you right now)... 'CREATE TABLE foo CHARACTER SET utf8' the same. All I can say is that with the testcase I posted, it is shown

Re: UTF-8 settings and woes (update)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 robert kuzelj wrote: > hi mark, > >> If you specify UTF-8 as the characterEncoding connection property, then >> that is the transform that is used from client -> server. The transform >> that is used from server -> client is whatever character set the

Re: UTF-8 settings and woes (update)

hi mark, If you specify UTF-8 as the characterEncoding connection property, then that is the transform that is used from client -> server. The transform that is used from server -> client is whatever character set the column in the table is set to when you created the table (or conversely if you us

Re: UTF-8 settings and woes (update)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 robert kuzelj wrote: > hallo mark, > >> Hopefully the following JUnit testcase helps show that your problem >> doesn't exist at the JDBC level. It creates a UTF-8 connection to >> MySQL-4.1.2, stores UTF-8 encoded strings directly and by prepared >> s

Re: UTF-8 settings and woes (update)

hallo mark, Hopefully the following JUnit testcase helps show that your problem doesn't exist at the JDBC level. It creates a UTF-8 connection to MySQL-4.1.2, stores UTF-8 encoded strings directly and by prepared statements, retrieves them, compares to original as strings, and byte-for-byte using t

Re: UTF-8 settings and woes (update)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 robert kuzelj wrote: > hi mark, > > > However, once you start displaying things on the console, all bets are > > off...because your console needs to understand UTF-8 as well, so using > > the 'eyeball' method of testing won't work too well here. >

Re: UTF-8 settings and woes (update)

hi mark, > However, once you start displaying things on the console, all bets are > off...because your console needs to understand UTF-8 as well, so using > the 'eyeball' method of testing won't work too well here. in principle i agree with you. but only having java tests is simply not enough. i ha

Re: UTF-8 settings and woes (update)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 robert kuzelj wrote: > [code] > 18String family = new String(rs.getBytes("FAMILY_NAME")); > 19String given = new String(rs.getBytes("GIVEN_NAME")); > [/code] > > [result] > [java] .Käßsel - Böb > [java] Ægÿl - Àlbért >

Re: UTF-8 settings and woes (update)

seems like my problem is not necesseraly tied to mysql. at least i can reproduce all of this also with postgres. instead of writing to the database i tried to read from it (after inserting data via the following simple script on the commandline) [code] [EMAIL PROTECTED]:> more example_insert.sql in

Re: UTF-8 settings and woes

hi Yiannis, Try changing Eclipse's setting to saving the files as UTF-8 and also force the JVM to the UTF-8 file encoding. eclipse is already set to only write UTF-8. but how should i force the jvm to work with that encoding? ciao robertj smime.p7s Description: S/MIME Cryptographic Signature

RE: UTF-8 settings and woes

Try changing Eclipse's setting to saving the files as UTF-8 and also force the JVM to the UTF-8 file encoding. -Original Message- From: robert kuzelj [mailto:[EMAIL PROTECTED] Sent: 26 May 2004 15:01 To: [EMAIL PROTECTED] Subject: UTF-8 settings and woes hi, i am trying to write

UTF-8 settings and woes

hi, i am trying to write utf-8 data via java into sql but it wont work as expected. first my setup - suse 9.0 - kde 3.2 mysql> SHOW VARIABLES LIKE 'char%'; +--++ | Variable_name| Value | +--

Re: questions about connection settings

Jigal van Hemert wrote: At the moment we have 6 webservers (RedHat) behind a loadbalancer which use one dedicated MySQL server (plus two smaller dedicated MySQL servers for a few special sites) for their data. On setting that seems to cause headaches is MySQL's "max connecterrors". We cannot find w

questions about connection settings

At the moment we have 6 webservers (RedHat) behind a loadbalancer which use one dedicated MySQL server (plus two smaller dedicated MySQL servers for a few special sites) for their data. On setting that seems to cause headaches is MySQL's "max connecterrors". We cannot find which conditions cause co

re: RE: my.cnf settings and running admin commands such as mysqldump

gt; 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, y

RE: my.cnf settings and running admin commands such as mysqldump or m

, 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 us

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> my

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.c

InnoDB Memory Settings for a LOT of RAM

I've got a Linux server (RH 7.3, 2.4.18, 1.5GB RAM) which runs good but could always be faster. Memory is relatively cheap all things considered, so we just added 4GB to it. I can increase innodb_buffer_pool_size from the 800M I had it at previously only to about 1500M without problems. I was hopi

Re: RE: rE: re: mi fa so la ti do... Character Set Settings Query

Query: can you guys please trim up your quotes a little? -- : Jan Steinman -- nature photography: : Bytesmiths -- artists' services: : Join the forums at ---

RE: RE: RE: Character Set Settings

t... Dean Harding. > -Original Message- > From: Nikoloudis George > [mailto:[EMAIL PROTECTED]@intracom.gr] > Sent: Wednesday, 25 September 2002 8:24 pm > To: Nikolaos Georgiafentis > Cc: [EMAIL PROTECTED] > Subject: RE: RE: RE: Character Set Settings > > Nothing I did

RE: RE: RE: Character Set Settings

Mob.: +30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: Τετάρτη, 25 Σεπτεμβρίου 2002 12:58 μμ To: Nikoloudis George ([EMAIL PROTECTED]) Cc: [EMAIL PROTECTED] Subject: Re: RE: RE: Character Set Settings Sorry the correct

Re: RE: RE: Character Set Settings

PROTECTED]] >Sent: Τετάρτη, 25 Σεπτεμβρίου 2002 12:19 μμ >To: [EMAIL PROTECTED] >Cc: [EMAIL PROTECTED] >Subject: Re: RE: Character Set Settings > > >Dear Gorge, >the page you have sent me is included in an other page? >If is not then try to put also all the required html tag

RE: RE: Character Set Settings

Mob.: +30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: Τετάρτη, 25 Σεπτεμβρίου 2002 12:19 μμ To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: RE: Character Set Settings Dear Gorge, the page you have sent me is

Re: RE: Character Set Settings

Fax: +30 10 667 97 97 >Greece Mob.: +30 972 03 60 06 > > > >-Original Message- >From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] >Sent: Τετάρτη, 25 Σεπτεμβρίου 2002 11:33 πμ >To: Nikoloudis George ([EMAIL PROTEC

RE: Character Set Settings

]) Cc: [EMAIL PROTECTED] Subject: RE: Character Set Settings Fear George, try putting '' in the header section of your page. Keep me informed At 10:54 AM 9/25/2002 +0300, you wrote: >Dear Nikos > >I run the below --defult-character-set=ISO-8859-7 and when I insert into

RE: Character Set Settings

Original Message- >From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] >Sent: ÔåôÜñôç, 25 Óåðôåìâñßïõ 2002 10:41 ðì >To: Nikoloudis George ([EMAIL PROTECTED]) >Cc: [EMAIL PROTECTED] >Subject: Re: Character Set Settings > > >Dear George, >I use to have problems

RE: Character Set Settings

Mob.: +30 972 03 60 06 -Original Message- From: kayamboo [mailto:[EMAIL PROTECTED]] Sent: ÔåôÜñôç, 25 Óåðôåìâñßïõ 2002 11:08 ðì To: [EMAIL PROTECTED] Cc: list mysql Subject: Re: Character Set Settings What you mean by explorer pages? Browser? If so you have to set the

Re: Character Set Settings

t;[EMAIL PROTECTED]> Sent: Wednesday, September 25, 2002 4:54 PM Subject: RE: Character Set Settings Dear Nikos I run the below --defult-character-set=ISO-8859-7 and when I insert into the database like insert into test values('ÄÕÏ'); when I select: mysql> select * from test

RE: Character Set Settings

rding. > -Original Message- > From: Nikoloudis George ([EMAIL PROTECTED]) > [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 25 September 2002 5:54 pm > To: Nikolaos Georgiafentis > Cc: [EMAIL PROTECTED] > Subject: RE: Character Set Settings > > Dear Nikos > >

RE: Character Set Settings

+30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: ÔåôÜñôç, 25 Óåðôåìâñßïõ 2002 10:41 ðì To: Nikoloudis George ([EMAIL PROTECTED]) Cc: [EMAIL PROTECTED] Subject: Re: Character Set Settings Dear George, I use to have problems with Greek Chars an

Re: Character Set Settings

Dear George, I use to have problems with Greek Chars and after hundreds of hours of testing i can assure you that the only solution is to compile Mysql using as default char-set the Greek char-set. Thus if your are using mysql for Linux you have to add to the ".configure" parameters the followi

Character Set Settings

Dear support I am trying to write data in the database in ISO-8859-7 character set. My Questions are: 1) How do I configure MySQL to support this character set? 2) I am using PHP to get these infornation from the database. Do I have to do something in my code to read teh data? Thenks a lot Geo

Re: max_connections / settings (info/help)

On Tue, 18 Jun 2002, louie miranda wrote: > [mysqld] > max_connections= 500 > Hi i have here my [mysqld] settings, im having troubles though on > "max_connections" > I was wondering if this settings is correct, and what option is correct? max_connections

Re: mysql.server script does not honor datadir settings

t;How-To-Repeat: t> # joe /etc/my.cnf t> Change some settings, especially datadir t> # /usr/local/share/mysql/mysql.server start t> wait a few seconds.. t> # /usr/local/share/mysql/mysql.server stop t> No mysqld pid file found. Looked for /var/db/mysql/farmer.pid. Your MySQL server

mysql.server script does not honor datadir settings

>Description: Change datadir in /etc/my.cnf or elsewhere. Start server (i.e., /usr/local/share/mysql/mysql.server start) and then try to stop it (/usr/local/share/mysql/mysql.server stop) >How-To-Repeat: # joe /etc/my.cnf Change some settings, especially datadir # /usr/local/share

RE: Problem with access settings on one database on mySQL

in to 700. Thanks again Keiran -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: 17 January 2002 15:30 To: Keiran Wynyard Cc: [EMAIL PROTECTED] Subject: Re: Problem with access settings on one database on mySQL The user under which mysql is running ( 'mysql&

Re: Problem with access settings on one database on mySQL

The user under which mysql is running ( 'mysql' ? Better check. ) does not have read permissions on the .frm files OR does not have execute (x) permissions on their parent ( or any ancestor ) directory. chown -R mysql:mysql /var/lib/mysql should do the trick. Replace /var/lib/mysql with the ac

Problem with access settings on one database on mySQL

Hi I have MySQL running on a RAQ4i. It has been running perfectly well for almost a year and has four separate databases on it. Last week, whilst checking over the sites that make calls on these databases I noticed that only one had problems. Through searching the FAQs and online documentation

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.thu

MySQL regional settings problem

I have a problem with my regional setting. I want to insert into my database a decimal number, using comma instead of dot like in this example: 11,45 not like 11.45 If possible, i wouldn't change my regional settings. Can you help me ? T

Re: Settings

p your server. All the best, /Rob >What information would you need to recommend the initial settings for a >MySQL server. We are about to deploy a new server and move our website over >to the server and I would like to have a somewhat optimized configuration >from the start. Let me

Settings

What information would you need to recommend the initial settings for a MySQL server. We are about to deploy a new server and move our website over to the server and I would like to have a somewhat optimized configuration from the start. Let me know what you need, and I'll provide it. T

Re: Cannot get server to honor configuration settings

That is a permissions error. Mysql does not own the database directory. chown -R mysql /var/lib/mysql Mailing List Receiver wrote: > With basedir and datadir=/var/lib/mysql the error is: > 011001 16:16:42 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) > > With basedir=/

Cannot get server to honor configuration settings

With basedir and datadir=/var/lib/mysql the error is: 011001 16:16:42 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) With basedir=/var/lib/mysql and datadir not set: /usr/libexec/mysqld: Can't change dir to '/var/lib/mysql/var/' (Errcode: 2) 011001 16:18:23 Aborting 011001

Re: Privilege settings

ee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: "Mike Blezien" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 30, 2001 7:19 PM Subject: Privilege settings Hi all, trying to figure out the relationship of t

Re: Privilege settings

Mike Blezien writes: > > Ok, now I understand, the "global" would refer to the privileges set in the > mysql db user table then,..correct?? :) and the privileges set in the db table > are specific to that particular database. Sound right?? > > thanks > > > Mike(mickalo)Blezien > =-=-=-=-=-=-=-

Re: Privilege settings

Ok, now I understand, the "global" would refer to the privileges set in the mysql db user table then,..correct?? :) and the privileges set in the db table are specific to that particular database. Sound right?? thanks >>> trying to figure out the relationship of the mysql User and db tables. No

  1   2   >