Tag Info

New answers tagged

1

XE changes the following: tnsnames.ora Path variables takes the default port 1521 for itself and this cannot be changed The best way to install XE and other products is to install XE first, then any other Oracle version afterwards. I think you can fix this by examining the path variables by entering PATH at the command line ensuring that each ...


2

To answer your original question in title: Starting with 12c, one can easily limit both SGA and PGA. SGA could be limited in earlier releases also by sga_max_size or other parameters from which the database calculated sga_max_size. The problematic part was usually the PGA, with no simple limit value just some workarounds, but that can be now easily ...


1

The problem was that when the database was installed, conflicting other parameters were set. So I needed to export those from the "spfile" to a "pfile", back them up, edit them, test them and import from the pfile to the spfile: SQL> create pfile='some/file/path' from spfile; File created. Then I set the conflicting parameters to zero: ... ...


1

I know what you feel, I have 3 years working with MySQL, and in my case I always test the DML querys that can mod or broke any information on every table/database/Slave-replication. Its always the safest way to test your query before run it.


0

sorry for that late answer and my bad english :) currently i am working on a session-hybrid with ZebraSession and my own ClientCookie-Session Class. I nerver heard about GET_LOCK so i started to search for its usage. Now i am stumbled into your post. Maybe your (or all ZebraSession Users) Problem a) depends on the MySql Version you are running. b) You ...


1

Put clear passwords in text files is not recommended since mysql 5.6.6. You can use mysql_config_editor to save passwords encrypted also to provide different passwords for different connections https://dev.mysql.com/doc/refman/5.6/en/mysql-config-editor.html


0

The other answer is correct. Unfortunately mysqladmin doesn't support --defaults-group-suffix (at least not the version I'm using). Hence I resorted to using --defaults-file=HOST.cnf instead, which works for both mysql and mysqladmin (and mysqldump).


0

Version 5.1.3 "Renamed the table_cache system variable to table_open_cache. Any scripts that refer to table_cache should be updated to use the new name." However, it did not become an error until years later, in 5.7.6. Change to table_open_cache. However, what does the line in my.cnf look like? Sounds like there is something else wrong. Change it to ...


1

What @Daniel explained so accurately becomes rather obvious when you add the respective column to your query: SELECT name, setting, unit, min_val, max_val, context FROM pg_settings WHERE name = 'shared_buffers'; Or just: SELECT * FROM pg_settings WHERE name = 'shared_buffers'; Consider the project guidelines for your "non-bleeding-edge" (a.k.a. ...


3

The canonical unit for shared_buffers is pages of 8kB, so the actual memory allocated in bytes is: 524288 * 8192 = 4294967296 or 4096*1024*1024 as requested. You can also check the size of the segment of memory with ipcs -m


0

USE db_99; do something with db_1 or 2 or 3; will not replicate because of your binlog-do-db and replicate-do-db. (The later is redundant in your case.) This is because replication (except for "wild" versions) is based on the USE, not on any explicit db spelled out in the statement. Is it a "bug"? Well, a lot of people get burned by it.


1

It looks like you did change the value to 1000, however, it's commented out. Remove the # sign from the line and reboot the service.



Top 50 recent answers are included