One may think changing PHP session handler from file based to database driven is fully transparent. In many cases it is, sometimes… of the script, in addition however you may run into database related issues of modifying user profile or other user/session… get back your old file based session behavior with MySQL Sessions ? If you have dedicated connection to session database and use Innodb…
Comment: PHP Sessions - Files vs Database Based
June 6, 2009 By 38 Comments
[...] PHP Sessions – Files vs Database Based | MySQL Performance Blog Share and [...]
Comment: PHP Sessions - Files vs Database Based
April 5, 2007 By 38 Comments
…PHP Sessions – Files vs Database Based Dicas para utilização de mysql como “session …
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…failure. This actually goes to two topics. First – hot vs cold. If you’re using decent hardware and …O_DIRECT with Innodb which makes it to bypass file cache. If you have it DRBD slave will be…maintenance on cold standby database.” But you can do anything you want with a database that you run off a…
Post: Innodb vs MySQL index counts
November 29, 2011 By 6 Comments
… few strange errors in their mysqld.err log: [ERROR] Table database_name/table_name contains 8 indexes inside InnoDB, which is… the entire Innodb Data dictionary to the mysqld error log file. If I had to do it over again, I think… not the greatest thing to do on a live production database master if you can help it. Another solution might be…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… reads. Regardless of the file size, the difference between aligned and misaligned reads was the same and, WT -vs- WB cache of… 8 threads running concurrently. Because the customer was running a database which was way bigger than 16G, I’ve repeated the…. Summary For the two workloads that are most relevant to databases – random reads and random writes – IO alignment on a 4…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
….xx. PZ: I should note MySQL 5.0 vs 4.1 has a lot of performance differences …Oracle’s main database, I believe different applications work best on different database brands. Oracle’s main database has a … for storing ib_log* files; I know that innodb writes files in the log file group in a round …
Post: Tokyo Tyrant - The Extras Part I : Is it Durable?
November 10, 2009 By 5 Comments
…’s going on: /* Synchronize updated contents of a hash database object with the file and the device. */ bool tchdbsync(TCHDB *hdb){ assert…); return rv; } If it first checks if the file descriptor for the database is less then 0, or your not operating as… down as needed to ensure you have the proper recovery -vs- performance setting.
Comment: Disaster: LVM Performance in Snapshot Mode
February 6, 2009 By 55 Comments
… 10 with LVM vs. RAID 10 only: Random Write: For small files (<16k) creation, no much difference; For large files creation, LVM causes… 10 without LVM (Dell poweredge, database size 600G). We scaled out the database so the new database is 1/3 of the original. You can argue they are different hardware and in different database…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… vs most of web applications in insane. Not only that but many of these systems were started by beginners so traditional databases were way to complex to use too. All these requirements made traditional databases irrelevant for many web… are inhouse and opensource solutions for tasks for large scale file storage, queuing, data processing etc. But seriously if you look…
